[vchkpw] replication and vpopmail.mysql

[Andrea Ubiali]

Hi,

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

[vchkpw] problem with solaris 8 and md5 password

[Andrea Ubiali]

hi all,

i don't know how to add support for md5 password on my solaris 8 servers

This is my configure

./configure --enable-mysql=y --enable-logging=y --enable-clear-passwd=y
--enable-valias=y --enable-learn-passwords=y
--enable-defaultquota=104857600 --enable-auth-logging=y
--enable-incdir=/usr/local/mysql/include
--enable-libdir=/usr/local/mysql/lib --enable-md5-passwords=y
This kind of configuration works perfectly on my linux servers (suse
8.0) and doesn't work on solaris 8 (sparc)
I have no error, but on solaris i can't read or write MD5 passwords

vpopmail-5.2.1 on all servers

Any idea ?

Thanks. Andrea.

--
Andrea Ubiali
Elitel S.p.A.


smime.p7s
Description: S/MIME Cryptographic Signature