kn wrote:Can you post all the /etc/postfix/mysql-*.cf files?
This is a fresh install I haven't changed anything at all. When I disable TLS I can connect and I get:
[root@smtp ~]# telnet 127.0.0.1 25
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
220 smtp.srvxx.com ESMTP Postfix
Here is the content of all mysql-*.cf files:
[root@smtp ~]# cat /etc/postfix/mysql/catchall_maps.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT alias.goto FROM alias,domain WHERE alias.address='%d' AND alias.address=domain.domain AND alias.active=1 AND domain.active=1 AND domain.backupmx=0
[root@smtp ~]# cat /etc/postfix/mysql/domain_alias_catchall_maps.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT alias.goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain='%d' AND alias.address=alias_domain.target_domain AND alias_domain.target_domain=domain.domain AND alias.active=1 AND alias_domain.active=1
[root@smtp ~]# cat /etc/postfix/mysql/domain_alias_maps.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT alias.goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain='%d' AND alias.address=CONCAT('%u', '@', alias_domain.target_domain) AND alias_domain.target_domain=domain.domain AND alias.active=1 AND alias_domain.active=1 AND domain.backupmx=0
[root@smtp ~]# cat /etc/postfix/mysql/recipient_bcc_maps_domain.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT bcc_address FROM recipient_bcc_domain WHERE domain='%d' AND active=1
[root@smtp ~]# cat /etc/postfix/mysql/recipient_bcc_maps_user.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT recipient_bcc_user.bcc_address FROM recipient_bcc_user,domain WHERE recipient_bcc_user.username='%s' AND recipient_bcc_user.domain='%d' AND recipient_bcc_user.domain=domain.domain AND domain.backupmx=0 AND domain.active=1 AND recipient_bcc_user.active=1
[root@smtp ~]# cat /etc/postfix/mysql/relay_domains.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT domain FROM domain WHERE domain='%s' AND backupmx=1 AND active=1
[root@smtp ~]# cat /etc/postfix/mysql/sender_bcc_maps_domain.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT bcc_address FROM sender_bcc_domain WHERE domain='%d' AND active=1
[root@smtp ~]# cat /etc/postfix/mysql/sender_bcc_maps_user.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT sender_bcc_user.bcc_address FROM sender_bcc_user,domain WHERE sender_bcc_user.username='%s' AND sender_bcc_user.domain='%d' AND sender_bcc_user.domain=domain.domain AND domain.backupmx=0 AND domain.active=1 AND sender_bcc_user.active=1
[root@smtp ~]# cat /etc/postfix/mysql/sender_login_maps.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT mailbox.username FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.enablesmtp=1 AND mailbox.active=1 AND domain.backupmx=0 AND domain.active=1
[root@smtp ~]# cat /etc/postfix/mysql/transport_maps_domain.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT transport FROM domain WHERE domain='%s' AND active=1
[root@smtp ~]# cat /etc/postfix/mysql/transport_maps_user.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1
[root@smtp ~]# cat /etc/postfix/mysql/virtual_alias_maps.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT alias.goto FROM alias,domain WHERE alias.address='%s' AND alias.domain='%d' AND alias.domain=domain.domain AND alias.active=1 AND domain.backupmx=0 AND domain.active=1
[root@smtp ~]# cat /etc/postfix/mysql/virtual_mailbox_domains.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT domain FROM domain WHERE domain='%s' AND backupmx=0 AND active=1 UNION SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='%s' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0
[root@smtp ~]# cat /etc/postfix/mysql/virtual_mailbox_maps.cf
#
# File generated by iRedMail (2012.05.16.22.20.38):
#
# Version: 0.8.0
#
#
user = vmail
password = PETRfZ7xBYQtKbegmWzNpMeOqgDYkv
hosts = 127.0.0.1
port = 3306
dbname = vmail
query = SELECT CONCAT(mailbox.storagenode, '/', mailbox.maildir) FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.domain = mailbox.domain AND domain.active=1