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).
-Clayton -----Original Message----- From: nicholas [mailto:nicholas@;no-spam.co.uk] Sent: Wednesday, November 13, 2002 1:58 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to solaris) 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 nicholas > 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]> > To: <[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 >> >> user <[EMAIL PROTECTED]> >> ok >> pass xxxxxxxx >> vmysql: sql error: 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