Hi All,
Got a funny one:
Using Postfix 3.8.1 connecting to a MariaDB backend - everything is
working AOK.
I can get the correct response when I do a `postmap -q my_example.com
mysql:/etc/postfix/virtual_domains.cf` - as I said, everything is
working AOK.
However, when I turn on 1-way TLS *on the MariaDB Server* (ie the client
confirms the DB Server has a TSL Certificate) something breaks. IE when
I do a `postmap -q my_example.com mysql:/etc/postfix/virtual_domains.cf`
I get back:
~~~
postmap: warning: connect to mysql server sql.my_example.com: Access
denied for user 'mail-user'@'192.168.1.101' (using password: YES)
postmap: fatal: table mysql:/etc/postfix/sql_vdomains.cf: query error:
Resource temporarily unavailable
~~~
FTR: The IP Address of server sql.my_example.com is 192.168.1.101.
As I said, the only change being made is turning on TLS on the DB Server
ie in /etc/my.cnf.d/my_settings.cnf add the settings:
~~~
require_secure_transport=ON
ssl-ca=/my/cert/path/ca_bundle.pem
ssl-cert=/my/cert/path/sql.my_example.com_rsa.crt
ssl-key=/my/cert/path/sql.my_example.com_rsa.key
~~~
The logs (on either box) aren't showing anythings useful :-(
Anyone have any ideas? I can supply full config files if necessary, but
the relevant stuff is above - and as I said, everything works without
the TLS-to-DB stuff.
Thanks in advance
Dulux-Oz
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
_______________________________________________
Postfix-users mailing list -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org
