Re: [vchkpw] could not connect to mysql update server Access deniedfor user

[Toyoda Yasuyuki]

Hello,

I forget to add checking the following contests.

6.Initialize database in MySQL(please check username)
/usr/local/mysql/bin/mysql_install_db --user=(username)
chown -R (username) /usr/local/var
chgrp -R (username) /usr/local/var
Regards,
Yasuyuki Toyoda


System wrote:
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.




.