Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 19th May 2012, 21:47
f-do f-do is offline
Junior Member
 
Join Date: Apr 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Postfix - Mysql - SSL - error

Hi There,

i have a litte problem if i want to send a e-mail over ssl, here is my config:

master.cf
Code:
tlsmgr    unix  -       -       -       1000?   1       tlsmgr
smtps     inet  n       -       y       -       -       smtpd -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
only if i want to sent it over ssl this error i get in the mail.log
Code:
May 19 21:44:44 fdo-s2 postfix/smtpd[18942]: connect from 188-195-140-169-dynip.superkabel.de[188.195.140.169]
May 19 21:44:44 fdo-s2 postfix/smtpd[18942]: setting up TLS connection from 188-195-140-169-dynip.superkabel.de[188.195.140.169]
May 19 21:44:45 fdo-s2 postfix/smtpd[18942]: Anonymous TLS connection established from 188-195-140-169-dynip.superkabel.de[188.195.140.169]: TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)
May 19 21:44:45 fdo-s2 postfix/smtpd[18942]: warning: mysql:/etc/postfix/client_access.cf: table lookup problem
May 19 21:44:45 fdo-s2 postfix/smtpd[18942]: NOQUEUE: reject: RCPT from 188-195-140-169-dynip.superkabel.de[188.195.140.169]: 451 4.3.5 <188-195-140-169-dynip.superkabel.de[188.195.140.169]>: Client host rejected: Server configuration error; from=<flo@codefact.de> to=<flo@f-do.de> proto=ESMTP helo=<Florians-MacBook-Pro.local>
May 19 21:44:46 fdo-s2 postfix/smtpd[18942]: disconnect from 188-195-140-169-dynip.superkabel.de[188.195.140.169]
the client_access.cf:
Code:
hosts = unix:/var/run/mysqld/mysqld.sock
user = mail
password = xxx
dbname = mail
query = SELECT action FROM access WHERE client != '' && action != '' && client = '%s' && active = 1;
The Table access is empty.

SO can you help me?

Thanks...
Reply With Quote
Sponsored Links
  #2  
Old 21st May 2012, 10:44
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Can Postfix access /var/run/mysqld/mysqld.sock? If it's running chrooted, it might not be able to do so.
__________________
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
  #3  
Old 21st May 2012, 10:53
f-do f-do is offline
Junior Member
 
Join Date: Apr 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

the permission is:
srwxrwxrwx 1 mysql mysql 0 May 14 17:32 mysqld.sock

So but this is only then when i want to sent a mail over TLS/SSL - without that it runs perfektliy - so i think the postfix has the permission - all the data are on the mysql.

Or runs postfix on a diffrent user on TSL/SSL?
Reply With Quote
  #4  
Old 22nd May 2012, 14:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Do you have other *.cf files in /etc/postfix/ that access your database? Do they use sockets as well, or do they use TCP (127.0.0.1 and port 3306)?
__________________
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
  #5  
Old 22nd May 2012, 14:37
f-do f-do is offline
Junior Member
 
Join Date: Apr 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

fdo-s2:/etc/postfix# ls -1 *.cf
autorespond.cf
client_access.cf
dynamicmaps.cf
greylist.cf
main.cf
master.cf
spamfilter.cf
virtual_alias_domains.cf
virtual_alias_maps.cf
virtual_mailbox_domains.cf
virtual_mailbox_maps.cf

They do all connect through the socket...
Reply With Quote
  #6  
Old 23rd May 2012, 14:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Can you post the contents of virtual_alias_domains.cf, for example, so that I can do a comparison? Do you have problems with the other cf files as well, or is client_access.cf the only one that is making problems?
__________________
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
  #7  
Old 23rd May 2012, 14:41
f-do f-do is offline
Junior Member
 
Join Date: Apr 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Hi,

here is the virtual_alias_domains.cf:

hosts = unix:/var/run/mysqld/mysqld.sock
user = mail
password = xxx
dbname = mail
query = SELECT domain_name FROM domains WHERE domain_name != '' && domain_name = '%s' && alias_domain = 1 && active = 1;


I have only the problem with the client_access.cf and after the error in the log is the connection closed... With( Server configuration error
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
ISPCONFIG 3 Email Content Filter jariasca Installation/Configuration 11 2nd August 2012 12:27
dovecot: lda: Fatal: Unknown user dpicella Installation/Configuration 1 22nd August 2010 02:59
Undelivered Mail Returned to Sender Error202 General 5 7th May 2009 11:14
localhost postfix/master: fatal: bind 127.0.0.1 port 125: Permission denied g18c Installation/Configuration 4 24th March 2009 17:39
Help configure Postfix to use alt port 465 or 587 BoloMarkIII Installation/Configuration 10 16th March 2009 17:57


All times are GMT +2. The time now is 20:39.


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