Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th January 2006, 07:19
triak triak is offline
Junior Member
 
Join Date: Jan 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier And MySQL

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=330 6': Access denied for user: 'mail_admin@mail.abc.de' (Using password: YES)

And in amavis.conf it clearly says:

@lookup_sql_dsn =
( ['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.
Reply With Quote
Sponsored Links
  #2  
Old 13th January 2006, 12:01
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,333 Times in 4,184 Posts
Default

This problem is related to your mySQL permissions.

"Access denied for user: 'mail_admin@mail.abc.de' " 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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th January 2006, 15:14
triak triak is offline
Junior Member
 
Join Date: Jan 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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-
Reply With Quote
  #4  
Old 14th January 2006, 17:19
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,333 Times in 4,184 Posts
Default

In your connect string is:

Code:
port=330 6
but it must be:

Code:
port=3306
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 14th January 2006, 21:14
triak triak is offline
Junior Member
 
Join Date: Jan 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default 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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 21:45
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs ruskicar HOWTO-Related Questions 26 20th July 2007 16:28
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs amilcar HOWTO-Related Questions 1 1st January 2006 17:12
Virtual Users And Domains With Postfix, Courier And MySQL: POP/IMAP authentication SeanG HOWTO-Related Questions 3 1st January 2006 17:08
Virtual Users And Domains With Postfix, Courier And MySQL ariek HOWTO-Related Questions 3 12th December 2005 22:14


All times are GMT +2. The time now is 00:47.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.