Is there a clear password in your mysql database?  And on your solaris box,
did you compile vpopmail with clear password support (if you didn't specify
no, then it compiled with clear passwords).


-----Original Message-----
From: nicholas [mailto:nicholas@;]
Sent: Wednesday, November 13, 2002 1:58 PM
Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to

Thanks for your answer

Do you mean --enable-clear-passwd=n here?
Im sure i didnt compile it with yes to clear passwords, and trawling
through the database they look pretty encypted to me


> I've wondered about the clear passwords.  Whether or not i compile
> vpopmail with --enable-clear-passwd=y  it still stores a clear text
> password.  I was wondering if it does this regardless.  It seems that
> its trying to pull the password from the pw_clear_password field and not
> the encrypted one.  My thoughts are maybe vchkpw doesn't even match
> against the encrypted password, but only matches against the clear text
> password.
> Any thoughts?
> ----- Original Message -----
> From: "nicholas" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 13, 2002 3:39 PM
> Subject: [vchkpw] vpop and mysql problems (migration from linux to
> solaris)
>> hello all
>> Having a little problem here, and thought i would seek help.
>> I have a working vpopmail 5.3.7 on linux with mysql 3.23.32 and qmail,
>> and I want to move the environment over to a solaris box.
>> The solaris box is Solaris 8 with vpopmail 5.3.7 and mysql 3.23.42 and
> qmail.
>> I compile and install vpopmail with nice options on the solaris box,
>> tar up the relevant /home/vpopmail/domains etc temp user and other
>> stuff (no bin or libs of course) and also copy them across to the
>> solaris machine
>> Then on the Linux box I do a mysqldump --opt vpopmail > vpopmail.sql
>> and populate the mysql database on the solaris box with vpopmail.sql I
>> connect to the new sql server and check, the data seems there.
>> but when I telnet to 110 to my new solaris server to see if it all
>> works i get this
>> ok
>> pass xxxxxxxx
>> vmysql: sql error[3]: Unknown column 'pw_clear_passwd' in 'field list'
>> -ERR authorization failed
>> Connection closed by foreign host
>> Now, Im not too up on the tables and fields the vpopmail populates in
>> a mysql database but surely for the same version of vpopmail on
>> different OSes, i should have no problem
>> Can anyone enlighten me on this error, my SQL needs improving.
>> Many thanks
>> nicholas

Reply via email to