LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Setting up postfix on ubuntu 8.1 (https://www.linuxquestions.org/questions/linux-newbie-8/setting-up-postfix-on-ubuntu-8-1-a-715470/)

pontiki 03-30-2009 06:42 AM

Setting up postfix on ubuntu 8.1
 
Hello,
We are trying to install postfix on ubuntu 8.1 and we we are following a pretty good guide http://flurdy.com/docs/postfix/edition5.html#conf_data,
unfortunately in the logs of the application when we start up postfix we get the erro 159 Connect Access denied for user 'mail'@'localhost' (using password: YES)
r that mail user cannot connect to the database:
"
But in the authmysqlrc file we haset the user mail and the correct pwd.
If we try to connect through command prompt with user mail to our db it is working:
"sysadmin:/etc/courier$ mysql -u mail -p maildb
Enter password:
Reading table information for completion of table and column names
"
Any ideas why postfix cannot connect to mysql?
Many thanks!!!!!!!!!!!!

vlademir 03-31-2009 02:52 AM

Quote:

Originally Posted by pontiki (Post 3492412)
Hello,
We are trying to install postfix on ubuntu 8.1 and we we are following a pretty good guide http://flurdy.com/docs/postfix/edition5.html#conf_data,
unfortunately in the logs of the application when we start up postfix we get the erro 159 Connect Access denied for user 'mail'@'localhost' (using password: YES)
r that mail user cannot connect to the database:
"
But in the authmysqlrc file we haset the user mail and the correct pwd.
If we try to connect through command prompt with user mail to our db it is working:
"sysadmin:/etc/courier$ mysql -u mail -p maildb
Enter password:
Reading table information for completion of table and column names
"
Any ideas why postfix cannot connect to mysql?
Many thanks!!!!!!!!!!!!

the reason for this error can be because postfix is running in chroot /var/spool/postfix. So it cannot find the unix socket for MySQL.

If you have the option to run mysql on 127.0.0.1 or on another IP, simply go to;

Quote:

/etc/postfix
run;

Quote:

grep localhost *
and replace all localhost to 127.0.0.1 or the IP in all files starting with mysql-virtual.

Please report if worked for you


All times are GMT -5. The time now is 06:07 PM.