Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th August 2011, 00:15
lezelf lezelf is offline
Junior Member
 
Join Date: Aug 2011
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default 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.

Last edited by lezelf; 5th August 2011 at 19:02.
Reply With Quote
The Following User Says Thank You to lezelf For This Useful Post:
AbannyvabVask (17th December 2013)
Sponsored Links
  #2  
Old 5th August 2011, 09:30
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

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)
Reply With Quote
  #3  
Old 5th August 2011, 10:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

What's the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 5th August 2011, 15:17
lezelf lezelf is offline
Junior Member
 
Join Date: Aug 2011
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

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..

Last edited by lezelf; 5th August 2011 at 15:44.
Reply With Quote
  #5  
Old 5th August 2011, 15:51
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

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

Code:
ls -al /var/run/mysqld/mysqld.sock
Reply With Quote
  #6  
Old 5th August 2011, 16:00
lezelf lezelf is offline
Junior Member
 
Join Date: Aug 2011
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by Mark_NL View Post
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.
Reply With Quote
  #7  
Old 5th August 2011, 16:35
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

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>' {} \;
Reply With Quote
  #8  
Old 5th August 2011, 17:24
lezelf lezelf is offline
Junior Member
 
Join Date: Aug 2011
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
Reply With Quote
  #9  
Old 5th August 2011, 18:24
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

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)
Reply With Quote
  #10  
Old 5th August 2011, 19:00
lezelf lezelf is offline
Junior Member
 
Join Date: Aug 2011
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
 
Red face

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

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

Last edited by lezelf; 5th August 2011 at 19:02.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Inbound email issue MrMoo Installation/Configuration 4 15th April 2011 21:56
Email - Spamer sending mail from my site? rtrynor Installation/Configuration 7 2nd March 2011 19:18
Stop a certain domain sending any email? edge Server Operation 3 28th June 2009 11:27
Email Forwarding Issue crayz1 Server Operation 4 15th January 2009 13:49
Sending email problems: Relay access denied jaffaizal HOWTO-Related Questions 35 24th April 2006 10:04


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


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