HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Sending email issue (http://www.howtoforge.com/forums/showthread.php?t=53664)

lezelf 5th August 2011 00:15

Sending email issue
 
Hi,

I used this tutorial:
http://www.howtoforge.com/perfect-se...er-ispconfig-3

EDIT: Wrong Link, i used this one: http://www.howtoforge.com/perfect-se...ot-ispconfig-3

And i got some issue. My webs applications are sending mails, but those mails stay local.

-On isp config 3, i can found every mail in the queue tab.
-error tab:

Code:

Aug 4 16:35:11 server postfix/smtp[9320]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/smtp[9403]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9411]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9412]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9413]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9414]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9415]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:59 server postfix/smtpd[9463]: fatal: no SASL authentication mechanisms

warning-tab:

Code:

Aug 4 17:52:20 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:20 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14349 exit status 1
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14350 exit status 1
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14351 exit status 1
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14352 exit status 1
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 4AD584C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 5A8AA4C79F6: virtual_alias_maps map lookup problem for root@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 5AC5E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 55E184C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 6A85B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 6B0FD4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 765894C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7A4F04C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 7AEAC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7BC674C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 7DA944C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7E42A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 80B264C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 814594C79F6: virtual_alias_maps map lookup problem for www-data@mydomnain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 81CC84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 826164C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 82EF24C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 840034C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 848E74C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8517F4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 85B384C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 864394C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 86A0B4C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 876634C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 883EB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 891944C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 89ECB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8A7D84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8B1114C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8BA654C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8C75D4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8D3AF4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8E45A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8EAE54C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 901C74C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 90B0A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 914604C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 91DFC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 9311B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 93A754C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 946E64C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 953BB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 965184C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 9AC474C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 9D5EA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 9DEC14C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: A28A84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: A31FB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A3B074C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: A47E14C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A501E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: A90A34C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A9A4A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: AA4304C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AB5DA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: ABF514C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AC7FC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: AD20B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AE3DC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: AEC774C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AF5674C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B154E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B1E564C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B42014C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B4B134C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B541F4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B61DA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:55 server amavis[10580]: (10580-12) (!)rw_loop: leaving rw loop, no progress
Aug 4 17:52:55 server amavis[10580]: (10580-12) (!)FWD via SMTP: -> , 451 4.5.0 From MTA([127.0.0.1]:10025) during fwd-connect (Negative greeting: at (eval 84) line 555, line 868.): id=10580-12
Aug 4 17:52:55 server postfix/smtp[14340]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:55 server postfix/smtp[14340]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 17:52:56 server postfix/master[3594]: warning: process /usr/lib/postfix/smtp pid 14340 exit status 1
Aug 4 17:52:56 server postfix/qmgr[12515]: warning: private/amavis socket: malformed response
Aug 4 17:52:56 server postfix/qmgr[12515]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:53:00 server amavis[10580]: (10580-12) (!)rw_loop: leaving rw loop, no progress
Aug 4 17:53:00 server postfix/smtpd[14406]: warning: SASL: Connect to private/auth failed: Connection refused
Aug 4 17:53:00 server postfix/smtpd[14406]: fatal: no SASL authentication mechanisms
Aug 4 17:53:01 server postfix/master[3594]: warning: process /usr/lib/postfix/smtpd pid 14406 exit status 1
Aug 4 17:53:01 server postfix/master[3594]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Aug 4 17:53:18 server postfix/smtpd[14413]: warning: SASL: Connect to private/auth failed: Connection refused
Aug 4 17:53:18 server postfix/smtpd[14413]: fatal: no SASL authentication mechanisms
Aug 4 17:53:19 server postfix/master[3594]: warning: process /usr/lib/postfix/smtpd pid 14413 exit status 1
Aug 4 17:53:19 server postfix/master[3594]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling

If look for solutions on the forum, but none seems to be working.
If it can help, my postfix/main.conf :
Code:

# See /usr/share/postfix/main.cf.dist for a commented, more complete version


# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

readme_directory = /usr/share/doc/postfix

# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

myhostname = server.mydomain.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = server.mydomain.com, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8 [::1]/128
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
html_directory = /usr/share/doc/postfix/html
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /var/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
smtpd_tls_security_level = may
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canon$
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
# See /usr/share/postfix/main.cf.dist for a commented, more complete version


# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

readme_directory = /usr/share/doc/postfix

# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

myhostname = server.mydomain.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = server.mydomain.com, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8 [::1]/128
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
html_directory = /usr/share/doc/postfix/html
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /var/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
smtpd_tls_security_level = may
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canon$
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf

and
Code:

telnet localhost 25
doesn't work instead of
Code:

telnet 127.0.0.1 25

could you please help me? It would be really apreciated.

Mark_NL 5th August 2011 09:30

double, triple, quadrupal check the how-to, because if you follow it to the letter, it WILL work.

From the information you provided i see there is a problem with your mysql server

Quote:

Aug 4 16:35:11 server postfix/smtp[9320]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
you get that because of:

Quote:

Aug 4 17:52:21 server postfix/cleanup[14353]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

falko 5th August 2011 10:30

What's the output of
Code:

netstat -tap
?

lezelf 5th August 2011 15:17

Thanks for your answers.

@falko, the output shows:

Code:

(No info could be read for "-p": geteuid()=1000 but you should be root.)
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address          Foreign Address        State      PID/Program name
tcp        0      0 localhost:10024        *:*                    LISTEN      -             
tcp        0      0 localhost:10025        *:*                    LISTEN      -             
tcp        0      0 *:mysql                *:*                    LISTEN      -             
tcp        0      0 localhost:spamd        *:*                    LISTEN      -             
tcp        0      0 server.mydomai:domain *:*                    LISTEN      -             
tcp        0      0 localhost:domain        *:*                    LISTEN      -             
tcp        0      0 *:ssh                  *:*                    LISTEN      -             
tcp        0      0 *:smtp                  *:*                    LISTEN      -             
tcp        0      0 localhost:953          *:*                    LISTEN      -             
tcp        0      0 *:1723                  *:*                    LISTEN      -             
tcp        0    48 server.mydomain.c:ssh modemcable028.124:11445 ESTABLISHED -             
tcp        0      0 server.mydomain:56401 akismet.com:www        TIME_WAIT  -             
tcp6      0      0 [::]:http-alt          [::]:*                  LISTEN      -             
tcp6      0      0 [::]:www                [::]:*                  LISTEN      -             
tcp6      0      0 [::]:tproxy            [::]:*                  LISTEN      -             
tcp6      0      0 [::]:domain            [::]:*                  LISTEN      -             
tcp6      0      0 [::]:ssh                [::]:*                  LISTEN      -             
tcp6      0      0 localhost:953          [::]:*                  LISTEN      -             
tcp6      0      0 [::]:https              [::]:*                  LISTEN      -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1166 TIME_WAIT  -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1158 TIME_WAIT  -             
tcp6      0  16610 server.mydomain.c:www 89.35.223.218%3463:1170 FIN_WAIT1  -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1143 TIME_WAIT  -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1153 TIME_WAIT  -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1133 TIME_WAIT  -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1130 TIME_WAIT  -             
tcp6      0      0 server.mydomain.c:www 89.35.223.218%3463:1118 TIME_WAIT  -

any idee of what is wrong?

@Mark_NL I followed it. everything else is working i don't know what's wrong here :(.

I don't have any /etc/init.d/mysqld to restart :(

Thanks again.


EDIT: I got this:

Code:

myname@server:~$ sudo /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..


Mark_NL 5th August 2011 15:51

Oke, so mysql is running .. does the socket file exist?

Code:

ls -al /var/run/mysqld/mysqld.sock

lezelf 5th August 2011 16:00

Quote:

Originally Posted by Mark_NL (Post 261032)
Oke, so mysql is running .. does the socket file exist?

Code:

ls -al /var/run/mysqld/mysqld.sock


yes
Code:

myname@server:~$ ls -al /var/run/mysqld/mysqld.sock
srwxrwxrwx 1 mysql mysql 0 2011-08-05 09:40 /var/run/mysqld/mysqld.sock

i'm trying some restart and other stuff, i assume this is why the date is the today's date.

Mark_NL 5th August 2011 16:35

Ii'm guessing you changed the password of the ispconfig mysql user and now all your daemons can't log into mysql anymore. Or you made a typo ..

if you can log into the ispconfig3 web admin, then f.e. check this:

Code:

grep db_password /usr/local/ispconfig/interface/lib/config.inc.php
that's the correct password for the mysql 'ispconfig' user.

Result should be somthing like this:
Code:

$conf['db_password'] = '<PASSWORD>';
define('DB_PASSWORD',$conf['db_password']);

Now check if it's the same as the one in these files:
Code:

./courier/authmysqlrc
./amavis/conf.d/50-user
./pure-ftpd/db/mysql.conf
./pam.d/smtp
./postfix/mysql-virtual_client.cf
./postfix/mysql-virtual_forwardings.cf
./postfix/mysql-virtual_relayrecipientmaps.cf~
./postfix/mysql-virtual_sender.cf~
./postfix/mysql-virtual_recipient.cf~
./postfix/mysql-virtual_email2email.cf
./postfix/mysql-virtual_email2email.cf~
./postfix/mysql-virtual_mailboxes.cf~
./postfix/mysql-virtual_mailboxes.cf
./postfix/mysql-virtual_transports.cf~
./postfix/mysql-virtual_domains.cf
./postfix/mysql-virtual_client.cf~
./postfix/mysql-virtual_relaydomains.cf
./postfix/mysql-virtual_domains.cf~
./postfix/mysql-virtual_forwardings.cf~
./postfix/sasl/smtpd.conf
./postfix/sasl/smtpd.conf~
./postfix/mysql-virtual_relaydomains.cf~
./postfix/mysql-virtual_relayrecipientmaps.cf
./postfix/mysql-virtual_transports.cf
./postfix/mysql-virtual_recipient.cf
./postfix/mysql-virtual_sender.cf
./vlogger-dbi.conf

you can check it if it exists in the files with this command:

Code:

find /etc -type f -exec grep -l '<PASSWORD>' {} \;

lezelf 5th August 2011 17:24

Code:

/etc/postfix/mysql-virtual_relaydomains.cf
/etc/postfix/mysql-virtual_sender.cf
/etc/postfix/mysql-virtual_email2email.cf
/etc/postfix/mysql-virtual_recipient.cf
/etc/postfix/mysql-virtual_client.cf
/etc/postfix/mysql-virtual_mailboxes.cf
/etc/postfix/mysql-virtual_forwardings.cf
/etc/postfix/mysql-virtual_transports.cf
/etc/postfix/mysql-virtual_relayrecipientmaps.cf
/etc/postfix/mysql-virtual_domains.cf
/etc/amavis/conf.d/50-user
/etc/vlogger-dbi.conf
/etc/dovecot/dovecot-sql.conf
/etc/pure-ftpd/db/mysql.conf

here is the list i got.
there is no "courier" subfolder,
neither pam.d/smtp files.

/postfix/sasl exist but is empty.

Mark_NL 5th August 2011 18:24

You're running dovecot, therefor did not follow the How-to to the letter!
In the how-to they tell you to install courier and saslauthd, not dovecot.

(see page 4: http://www.howtoforge.com/perfect-se...ispconfig-3-p4 )

i suggest you do the how-to again, and follow the instructions exactly as they are described in the how-to, nothing else (unless you know what you're doing)

lezelf 5th August 2011 19:00

OMG, i copy pase the wrong link. I'm really sorry.
I used this tutorial:

http://www.howtoforge.com/perfect-se...ot-ispconfig-3


All times are GMT +2. The time now is 12:35.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.