Hello

Ok today adding SSL support to my MariaDB after try to connecting from
postfix to it, I have here this error, that in this moment I don't see any
solution.

 

>May 26 18:32:50 nmail postfix/smtpd[23806]: warning: connect to mysql
server unix:/run/mysqld/mysqld.sock: Can't connect to local MySQL server
through socket '/run/mysqld/mysqld.sock' (2)

>May 26 18:32:50 nmail postfix/smtpd[23806]: warning:
mysql:/etc/postfix/mysql-virtual_alias_maps.cf lookup error for
mauri...@caloro.ch <mailto:mauri...@caloro.ch> 

 

>May 26 18:36:48 nmail postfix/smtpd[24310]: warning: connect to mysql
server unix:/run/mysqld/mysqld.sock: Can't connect to local MySQL server
through socket '/run/mysqld/mysqld.sock' (2)

>May 26 18:36:48 nmail postfix/smtpd[24310]: warning:
mysql:/etc/postfix/mysql-virtual_alias_maps.cf lookup error for Emailaddress

 

The file "mysql-virtual_alias_maps.cf" exist and if I change the "unix
socket" to the "hosts ip" this will also run without any problem

 

># cat mysql-virtual_alias_maps.cf

>hosts = unix:/run/mysqld/mysqld.sock

># hosts = 127.0.0.1

>user = username

>password = password

>dbname = MailDatabase

>query = SELECT goto FROM alias WHERE address = '%s'

 

The socketfile from mysql are also creating when the mysql will start, also
add 777 to file but without any change

 

# ls -la /run/mysqld/mysqld.sock

srwxrwxrwx 1 mysql mysql 0 May 26 18:37 /run/mysqld/mysqld.sock

 

 

MariaDB are now ready to run with SSL support

MariaDB > sh running-config

+---------------------+----------------------------------+

| have_ssl            | YES

 

 

Thanks for any more help, so that this connection can run more secure.

Reply via email to