postfix courier-auth authmysql change mysql port
I'm hopping maybe someone can point out what I'm missing here. I'm running debian sarge and have packages postfix, courier-imap, authlib ... from testing. When I setup everything to run on mysql with the default port everything is great. However I would like to run mysql on port 3308.
It appears that something is wrong with the way I'm trying to tell everything to use a different port. It doesn't appear that I'm getting any errors from post fix, but If I try to authenicate I'm getting this error in my logs:
mech_list: plain login
sql_select: select password from users where email = '%u'
auth required pam_mysql.so user=email_admin passwd=<pw> host=127.0.0.1:3308 db=email table=users usercolumn=email passwdcolumn=password crypt=1
account sufficient pam_mysql.so user=email_admin passwd=<pw> host=127.0.0.1:3308 db=email table=users usercolumn=email passwdcolumn=password crypt=1
mysql_virtual_* (these all look basicly like this):
user = email_admin
password = <pw>
dbname = email
table = domains
select_field = 'virtual'
where_field = domain
hosts = 127.0.0.1:3308
I'd love to hear if I'm wrong on how I went about trying to set the port number somewhere.
Did you restart all services?
What's the output of
Yep restarted all services. I know its mostlikly just something that isn't configured right.
Here is the output from netstat -tap:
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN -
tcp 0 0 *:pop3s *:* LISTEN -
tcp 0 0 localhost:3308 *:* LISTEN -
tcp 0 0 *:pop3 *:* LISTEN -
tcp 0 0 *:imap2 *:* LISTEN -
tcp 0 0 *:ssh *:* LISTEN -
tcp 0 0 *:smtp *:* LISTEN -
tcp 0 720 192.168.100.55:ssh 192.168.100.50:55980 ESTABLISHED-
Looks ok. I think the problem might be the way you added the new MySQL port to the configuration files. Unfortunately I couldn't find any information about how to do it if you use another than the standard MySQL port... :(
|All times are GMT +2. The time now is 04:46.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.