OK, now it works with the following syntax for that line: @lookup_sql_dsn = ( ['DBI:MariaDB:database=$db;host=127.0.0.1;port=3306', '$user', '$password'] );
Note that the DBI:MariaDB is case sensitive. If you replace 127.0.0.1 with "localhost" you are using Unix pipes not TCP IP so ports does not make sense and needs to be removed and your MariaDB/MySQL server does need to accept Unix pipe connections. Other notes, Amavisd is a little slow to start up, so refuses connections for a few minutes. After you can connect you can of course flush the mail q. Many thanks for everyone's help. Also many thanks to Mark Martinec with whom I have corresponded many times on this list and thanks for the mods. Also to Patrick Ben Koetter for taking over from Mark. Kind Regards, Benedict White Our business grows by referrals. If you know someone who would benefit from our help, please pass on our details. Tel: 01444 238070 Tech: 01444 238080 Fax: 01444 238099 Web: www.cse-ltd.co.uk Registered in England and Wales No: 8666450 27 Victoria Gardens, Burgess Hill, West Sussex, RH15 9NB Legal Disclaimer: This message and any attachment may be confidential and privileged. If you are not the intended recipient please notify the sender and delete this e-mail and any attachment from your system. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. All information given in this e-mail is provided in good faith but not binding for legal reasons. -----Original Message----- From: amavis-users [mailto:[email protected]] On Behalf Of Damian Sent: 24 July 2019 12:02 To: [email protected] Subject: Re: amavisd-new & broken mysql Some debug output would be useful then. > Still doesn't work for me. > > When I ran it with the same settings as the DBI:mysql it did at least > fire up but just didn't work afterwards with the child processes dying as > they were called to do an SQL lookup.
