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:
Jul 26 11:23:44 localhost imapd: authentication error: Input/output error
Jul 26 11:23:44 localhost authdaemond: failed to connect to mysql server (server=localhost, userid=mail_admin): Access denied for user: 'mail_admin@localhost' (Using password: YES)
I'm thinking that its still trying to use the default port, but I'm not finding something more spacific to see where the connection is trying to be made. Here are my config files, maybe you'll see something wrong with them?
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.