In the end it looks like my courier was the problem. I downloaded the latest one and recompiled it and things are working again.... Go Figure.....
weird... oh well :) one project down many to go :)
thanks for the reply
Dave
At 05:36 AM 2/11/2004, Andrew Averin wrote:
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]
