Re: [vchkpw] possible authvchkpw.c patch

2004-03-16 Thread Michael Bowe 
Matthew,

Sorry for the delay in replying.

I believe your patch is correct.

I will submit the patch to MrSam for inclusion in the courier-imap
distribution.

Michael.


 Matthew Kanar wrote:

  I found that changing cdb passwords through courier-imap was failing for
  others and me with the courier-imap developement release,
  courier-imap-2.2.2.20040207.  This patch seems to correct the issue.
  The change is very simple.  vpw-pw_passwd in authvchkpw.c is changed
  to vpw-pw_passwd == 0.  Somebody else, most notably Michael Bowe
  [EMAIL PROTECTED], should probably review the change.
 
  Thank You,
  Matthew Kanar
 
  2004-03-02  Matthew Kanar [EMAIL PROTECTED]
 
 * authlib/authvchkpw.c: Made a change so that vpopmail
 password changes work again.
 
  --- ../courier-imap-2.2.2.20040207/authlib/authvchkpw.c 2004-01-14
  22:17:01.0 -0500
  +++ authlib/authvchkpw.c2004-03-02 12:52:52.136420151 -0500
  @@ -190,7 +190,7 @@
  *   - user's password field in the passwd entry is empty
  *   - supplied current password doesnt match stored password
  */
  -   if (vpw-pw_passwd || authcheckpassword(pass, vpw-pw_passwd)) {
  +   if (vpw-pw_passwd == 0 || authcheckpassword(pass,
  vpw-pw_passwd)) {
 errno=EPERM;
 return (-1);
 }

[vchkpw] replication and vpopmail.mysql

2004-03-16 Thread 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] Migrating users from debian ipop to vpopmail with mysql.

2004-03-16 Thread David Petruzzella 








I have a box that is being decommissioned running debian with ipop and I need to
migrate the e-mail from that server to the new server which is running qmail, vpopmail, courier-imap, with mysql authentication
and I was wondering what is the easiest way of doing it with out loosing any
e-mail which is the most important thing.
If anyone has any suggestions, recommendations it will be greatly
appreciated. Thanks.

Re: [vchkpw] Migrating users from debian ipop to vpopmail with mysql.

2004-03-16 Thread Jeremy Kitchen 
On Tue, 2004-03-16 at 10:44, David Petruzzella wrote:
 I have a box that is being decommissioned running debian with ipop and
 I need to migrate the e-mail from that server to the new server which
 is running qmail, vpopmail, courier-imap, with mysql authentication
 and I was wondering what is the easiest way of doing it with out
 loosing any e-mail which is the most important thing. If anyone has
 any suggestions, recommendations it will be greatly appreciated. 
 Thanks.

easiest way?  Hire someone.

alternative way?  Post more useful information, ie, what kind of users,
what kind of mailbox storage, etc.

'we are using debian and ipop' is really not useful.

-Jeremy
 
-- 
Jeremy Kitchen
Systems Administrator
[EMAIL PROTECTED]
Kitchen @ #qmail on EFNet - Join the party!
.
Inter7 Internet Technologies, Inc.
www.inter7.com
866.528.3530 toll free
847.492.0470 int'l
847.492.0632 fax
GNUPG key ID: 93BDD6CE