Virtual Users And Domains With Postfix, Courier And MySQL

Discussion in 'HOWTO-Related Questions' started by triak, Jan 13, 2006.

  1. triak

    triak New Member

    Hi guys.
    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[5735]: (05735-05) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=192.168.2.4;port=3306': Access denied for user: '[email protected]' (Using password: YES)

    And in amavis.conf it clearly says:

    @lookup_sql_dsn =
    ( ['DBI:mysql:database=mail;host=192.168.2.4;port=3306', '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.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This problem is related to your mySQL permissions.

    "Access denied for user: '[email protected]' " means that the access was denied for user mail_admin that connects from the host mail.abc.de.

    You must change the permissions on your mySQL server that the user mail_admin is allowed to connect from mail.abc.de and not only from localhost. Then reload the mysql server. If that wont help, you can try to allow connections from every host, that means to set host to "%" in the mysql permission tables.
     
  3. triak

    triak New Member

    Changed the permissions, but problem persists

    I am still getting the same error in mail.log complaining that amavis cannot connet to the mysql server. If I connect using mysql client I can access the server
    mail:/etc/postfix# mysql -h 192.168.2.4 -u mail_admin -p

    So if this works, why cannot amavis connect using exactly the same user/password?

    Is there a way to trace the problem?

    Thanks in adw.

    -Johannes-
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    In your connect string is:

    Code:
    port=330 6
    but it must be:

    Code:
    port=3306
     
  5. triak

    triak New Member

    It's working!!! whee :=)

    I got it!

    I have the correct port. Somehow my opera and this forum does not work togeather and it keeps dropping letters from my posts.

    The autentication problem was gone when I changed mail_admin to mailadmin
    Now everyting works like a charm.

    What about local users, such as me, postmaster etc. How do I add a local alias map so that theese users allso can recive mail?
    I think they don't have to use mysql, am I right?

    tia: Johannes
     

Share This Page