have u compiled vpopmail with vpopuser and vpoppass in vmysql.h. If no then please recompile your vpopmail with this username and password.
If you have compiled vpopmail with this user name already then problem can be in database privileges. check again using console... -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) "All I want is a few minutes alone with the source code for the universe and a quick recompile." ----- Original Message ----- From: "System" <[EMAIL PROTECTED]> To: "Ahmad Masood Shah" <[EMAIL PROTECTED]> Cc: "vpopmail" <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 12:26 PM Subject: Re: [vchkpw] could not connect to mysql update server Access denied for user > > check your permission and also check database and data base user or valid > in > > vmysql.h > > GRANT select,insert,update,delete,create,drop ON vpopmail.* > TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; > This is just fine and even connects to mysql from the prompt. I tried > granting all privileges to [EMAIL PROTECTED] but still it gives me the same > error!!! > > Regards, > Tina. > > > > > -- > > > > Best Regs, > > Masood Ahmad Shah > > System Administrator > > > > ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ > > | * * * * * * * * * * * * * * * * * * * * * * * * > > | Fibre Net (Pvt) Ltd. Lahore, Pakistan > > | Tel: +92-42-6677024 > > | Mobile: +92-300-4277367 > > | http://www.fibre.net.pk > > | * * * * * * * * * * * * * * * * * * * * * * * * > > ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ > > Unix is very simple, but it takes a genius to understand the simplicity. > > (Dennis Ritchie) > > "All I want is a few minutes alone with the source code for the universe > and > > a quick recompile." > > > > > > ----- Original Message ----- > > From: "System" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Thursday, June 05, 2003 12:15 PM > > Subject: [vchkpw] could not connect to mysql update server Access denied > for > > user > > > > > > > Hello All, > > > > > > I have installed vpopmail on my redhat 7.3 box with mysql 4.x and qmail > > with > > > SquirrelMail 1.0.4. > > > > > > I compiled vpopmail and used the following settings for mysql. > > > > > > /usr/sbin/groupadd -g 89 vchkpw > > > /usr/sbin/useradd -g vchkpw -u 89 vpopmail > > > > > > GRANT select,insert,update,delete,create,drop ON vpopmail.* > > > TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppass'; > > > > > > pico vmysql.h > > > > > > /* Edit to match your set up > > > #define MYSQL_UPDATE_SERVER "localhost" > > > #define MYSQL_UPDATE_USER "vpopuser" > > > #define MYSQL_UPDATE_PASSWD "vpoppass" > > > */ > > > > > > #define MYSQL_READ_SERVER "localhost" > > > #define MYSQL_READ_USER "vpopuser" > > > #define MYSQL_READ_PASSWD "vpoppass" > > > /* End of setup section*/ > > > > > > /* defaults - no need to change */ > > > #define MYSQL_VPORT 3306 > > > #define MYSQL_DEFAULT_TABLE "vpopmail" > > > #define MYSQL_DATABASE "vpopmail" > > > #define MYSQL_DOT_CHAR '_' > > > #define MYSQL_LARGE_USERS_TABLE "users" > > > > > > here are my Configure options > > > > > > > > > ./configure --enable-roaming-users=n --enable-default-domain=mydomain.com -- > > > > > > [EMAIL PROTECTED] --enable-logging=p --enable-defaultquo > > > > > > ta=20971520S --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pa > > > > > > sswd=n --enable-domain-quotas=n --enable-mysql=y --enable-incdir=/usr/includ > > > > > > e/mysql --enable-libdir=/usr/local/lib/mysql --enable-many-domains=n --enabl > > > > > > e-auth-logging=y --enable-mysql-logging=y --enable-valias=y --enable-mysql-l > > > imits=n > > > make > > > make install-strip > > > > > > The above process works just fine. and even i have checked my mysql user > > and > > > pass this is also fine. > > > > > > But after compiling my database vpopmail remains empty (without any > table) > > > Why ? > > > when i execute /home/vpopmail/bin/vadduser [EMAIL PROTECTED] "pass" it > > gives > > > an error : > > > > > > could not connect to mysql update server Access denied for user: > > > '[EMAIL PROTECTED]' (Using password: YES) with database > > > could not connect to mysql update server Access denied for user: > > > '[EMAIL PROTECTED]' (Using password: YES) > > > > > > Why does it takes root if i am using vpopuser for the mysql connection. > > > > > > Please put on the correct path as i have googled a lot and also search > but > > > could not found any info that will help me in this context. > > > > > > Regards, > > > Tina. > > > > > > > > > > > > > > > > > > > > > > > > > >
