I just joined your forum cause I'm stuck really bad
I have been following the HowTo that falco posted here and trying to setup a mailserver for my friends business. I made some minor adjustments to the setup so that mysql-server is not on localhost, but a completly different computer (we need it for other puposes too). My problem is that amavis is sending the wrong usename to the mysql server an cannot authenticate.
Here's a clip from the mail.log:
Jan 13 08:08:10 mail amavis: (05735-05) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=192.168.2.4;port=330 6': Access denied for user: 'firstname.lastname@example.org' (Using password: YES)
And in amavis.conf it clearly says:
( ['DBI:mysql:database=mail;host=192.168.2.4;port=330 6', 'mail_admin', 'somepassord'] );
What must I do so that amavis would send only the usename part and not username@fqdn? I think this is related with me using a external sql server.
Any help is greatly appreciated.