i'm trying vpopmail 5.4.3
I have a trouble with settings of vpopmail.mysql and replication.
My configure options here:
./configure --enable-auth-module=mysql --enable-logging=y --enable-clear-passwd=y --enable-valias=y --enable-learn-passwords=y --enable-auth-logging=y --enable-mysql-replication=y
then my vpopmail.mysql in /home/vpopmail/etc on my server test01 (named localhost below)
localhost|0|vpopmail|myfirstpasswd|vpopmail 192.168.1.52|3306|vpopmail|mysecondpasswd|vpopmail
then on my localhost
mysql> grant select on vpopmail.* to [EMAIL PROTECTED] identified by 'myfirstpasswd';
and on 192.168.1.52
mysql> grant all on vpopmail.* to vpopmail@'192.168.1.45' identified by 'mysecondpasswd';
When i try to connect to port 110 of localhost i have the following error
vmysql: sql error[i]: Access denied for user: '[EMAIL PROTECTED]' to database 'vpopmail'
looking in the mysql log file i can find the following lines
Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Connect [EMAIL PROTECTED] on vpopmail Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from vpopmail where pw_name = "test" and pw_domain = "interac.it" Connect [EMAIL PROTECTED] on vpopmail Query replace into lastauth set user="test", domain="interac.it", remote_ip="81.208.57.37", timestamp=1079449554
I can't understand the first and the last line.
I have no problem if i remove the following line in the vpopmail.mysql file
localhost|0|vpopmail|myfirstpasswd|vpopmail
Is there something wrong in my configuration ?
Thanks. Andrea.
-- Andrea Ubiali Interactive srl
smime.p7s
Description: S/MIME Cryptographic Signature
