Postfix MySQL error
Hi folks, I've already searched the forum for an answer but none worked for me.
I get this error in my mail log:
Btw: I have the amavis disabled!
I don't know why is this happening. When I log in using this
mysql -u ispconfig -ppassword
Everything ok. But when I try to log in the way it shows in the error log, it fails:
mysql -h 127.0.0.1 -u ispconfig -ppassword
According to the error message, postfix does not sue a password for logging in. Please check the file /etc/postfix/mysql-virtual_domains.cf if the password for the ispconfig user is set there.
Then please post the output of:
netstat -tap | grep mysql
and the content of the file /etc/mysql/my.cnf or /etc/my.cnf
Sorry for the delay. I've fixed it, and here is the explication of it
When I was trying to connect to mysql with the -h parameter set to 127.0.0.1
Then I tried modifying all the files that were connecting to mysql for postfix and had the value hostname set to 127.0.0.1 to localhost but still no success.
After a while watching logs, searching on the interned I went to phpmyadmin and do some checking there and I noticed that ISPConfig's databases had the permissions set for user ispconfig on host localhost so what I did was to add the same use but with the host set to 127.0.0.1.
That is weird, because 127.0.0.1 and localhost by default should resolv the same thing. I don't know why was that happening but I have fixed the way I just told you.
Good luck if any1 else has this problem.
|All times are GMT +2. The time now is 06:06.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.