Hello Dave, Wednesday, February 11, 2004, 1:14:09 PM, you wrote:
DL> Hey, I'm sure this is something really stupid.. but DL> I am trying to convert from vpasswd to mysql authentication DL> I've hit a road block. DL> here's what I've done DL> installed vpopmail 5.4.0 (was actually an upgrade too from my existing version) DL> ./configure --disable-roaming-users --enable-logging=p DL> --disable-ip-alias-domains DL> --disable-passwd --enable-clear-passwd DL> --disable-domain-quotas DL> --enable-auth-module=mysql --disable-many-domains DL> --enable-auth-logging DL> --enable-mysql-logging --enable-valias DL> --disable-mysql-limits DL> make && make install strip DL> I change teh vpopmail.msql file and add the tables and permissions.. DL> I then do a vconvert on my existing domains and bang... they're in the DL> database DL> (so that's all working in theory) DL> then I go to try to get mail.. setup a dummy account on OutXpress, and it DL> won't log in.... DL> so I check my maillog files.. and I see this.. DL> Feb 11 04:41:37 mail pop3d: Connection, ip=[::ffff:10.10.10.20] DL> Feb 11 04:41:37 mail pop3d: could not connect to mysql update server Access DL> denied for user: '[EMAIL PROTECTED]' (Using password: YES) with DL> database DL> Feb 11 04:41:37 mail pop3d: could not connect to mysql update server Access DL> denied for user: '[EMAIL PROTECTED]' (Using password: YES) DL> Feb 11 04:41:42 mail pop3d: LOGIN FAILED, ip=[::ffff:10.10.10.20] DL> now.. that's not the username i'm using... so where would it be coming from.. DL> I'm using qmail and courier for my pop/imap connections.. DL> as I say.. must be something stupid but I can't for the life of me think what.. DL> Suggestions would be greatly appreciated.. DL> Thanks DL> Dave IMHO it's all up to MySQL permissions. Just let localhost(if vpomail and mysql on the same machine) to connect to database in "user" or "host" table, and check passwords for user vpopmailaccount in mysql "user" table. It must be the same as you choose when compiled vpopmail. -- Best regards, Andrew mailto:[EMAIL PROTECTED]
