amavisd-new & broken mysql

[Benedict White]

OK, so I have experienced issues with the DBI:MySQL

I have via CPAN installed DBD::MariaDb.

What is the correct syntax for this line in amavisd.conf:

@lookup_sql_dsn = ( ['DBI:mysql:DB_Name:localhost;port3306', 'DB_USer', 'DB_User_Password'] );

I did try @lookup_sql_dsn = ( ['DBI:MariaDB:DB_Name:localhost;port3306', 'DB_USer', 'DB_User_Password'] );

But it failed to look anything up and so failed to process mail.

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:amavis-users-bounces+benedict.white=cse-ltd.co.uk at amavis.org] On Behalf Of Damian
Sent: 24 July 2019 09:26
To: amavis-users at amavis.org; pali at cpan.org
Subject: Re: amavisd-new & broken mysql

Hi,

> Would you mind to test if amavisd-new work with DBD::MariaDB? As after 
> two years people still reports that amavisd-new has problems with 
> DBD::mysql, it would be probably a good idea to look if DBD::MariaDB 
> driver is not more suitable for end users.

is DBD::MariaDB intended to be and remain a drop-in replacement for DBD::mysql or will the feature sets diverge eventually (however that would look like)? The former would be most convenient, as DBD::MariaDB could be proposed as an officially supported alternative for amavis without code change.

Damian