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.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 27th July 2006, 04:32
kasper22 kasper22 is offline
Junior Member
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default postfix courier-auth authmysql change mysql port

Hi,

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:

Quote:
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?

authmysqlrc:
MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD <pw>
MYSQL_PORT 3308
MYSQL_DATABASE email
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
MYSQL_SOCKET /var/run/mysqld/mysqld.sock

smpt.conf
pwcheck_method: saslauthd
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
sql_hostnames: 127.0.0.1:3308
sql_user: email_admin
sql_passwd: <pw>
sql_database: email
sql_select: select password from users where email = '%u'

/etc/pam.d/smtp:
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.
Thanks
Bryan
Reply With Quote
Sponsored Links
 

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
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40
Virtual Users And Domains With Postfix, Courier And MySQL - "apt-get" and Courier burritonator HOWTO-Related Questions 3 15th March 2006 20:11
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53
Virtual Users And Domains With Postfix, Courier And MySQL: POP/IMAP authentication SeanG HOWTO-Related Questions 3 1st January 2006 17:08


All times are GMT +2. The time now is 09:50.


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