RE: [vchkpw] vpop and mysql problems (migration from linux to solaris)
Just curious if you compiled with the --enable-clear-passwd=n and it actually worked. My experience in solaris is that you can use that option but it will set a clear password all the time. I actually had to modify the configure script to get it to not create the clear passwd column. -Original Message- From: nicholas [mailto:nicholas;no-spam.co.uk] Sent: Wednesday, November 13, 2002 6:13 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] vpop and mysql problems (migration from linux to solaris) Nice one! Perfect, it worked. Thanks for the help. Now back to work :) I'll stay on the list and see if i can be of any help in the future nicholas It'd probably be better to just recompile vpopmail without clear passwords. -Clayton -Original Message- From: Marco [mailto:marco;ellusion-networks.com] Sent: Wednesday, November 13, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to solaris) don't mind me, i was just babbling some thoughts earlier without merit. I tested my theory by deleting the clear text password in mysql and i can still authenticate. Anyways, I'm sure it can't hurt to recompiling vpopmail with --enable-clear-passwd=n. For some reason it seems to be trying to access that pw_clear_passwd table which doesnt exist. I really don't know why it is trying to access it. a quick hack might be to create the pw_clear_passwd field, just to satisfy it being there and see if its even gets populated. - Original Message - From: nicholas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:58 PM 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 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
Re: [vchkpw] vpop and mysql problems (migration from linux to solaris)
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 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
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 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
RE: [vchkpw] vpop and mysql problems (migration from linux to solaris)
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 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
Re: [vchkpw] vpop and mysql problems (migration from linux to solaris)
don't mind me, i was just babbling some thoughts earlier without merit. I tested my theory by deleting the clear text password in mysql and i can still authenticate. Anyways, I'm sure it can't hurt to recompiling vpopmail with --enable-clear-passwd=n. For some reason it seems to be trying to access that pw_clear_passwd table which doesnt exist. I really don't know why it is trying to access it. a quick hack might be to create the pw_clear_passwd field, just to satisfy it being there and see if its even gets populated. - Original Message - From: nicholas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:58 PM 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 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
RE: [vchkpw] vpop and mysql problems (migration from linux to solaris)
It'd probably be better to just recompile vpopmail without clear passwords. -Clayton -Original Message- From: Marco [mailto:marco;ellusion-networks.com] Sent: Wednesday, November 13, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to solaris) don't mind me, i was just babbling some thoughts earlier without merit. I tested my theory by deleting the clear text password in mysql and i can still authenticate. Anyways, I'm sure it can't hurt to recompiling vpopmail with --enable-clear-passwd=n. For some reason it seems to be trying to access that pw_clear_passwd table which doesnt exist. I really don't know why it is trying to access it. a quick hack might be to create the pw_clear_passwd field, just to satisfy it being there and see if its even gets populated. - Original Message - From: nicholas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:58 PM 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 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
RE: [vchkpw] vpop and mysql problems (migration from linux to solaris)
Nice one! Perfect, it worked. Thanks for the help. Now back to work :) I'll stay on the list and see if i can be of any help in the future nicholas It'd probably be better to just recompile vpopmail without clear passwords. -Clayton -Original Message- From: Marco [mailto:marco;ellusion-networks.com] Sent: Wednesday, November 13, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to solaris) don't mind me, i was just babbling some thoughts earlier without merit. I tested my theory by deleting the clear text password in mysql and i can still authenticate. Anyways, I'm sure it can't hurt to recompiling vpopmail with --enable-clear-passwd=n. For some reason it seems to be trying to access that pw_clear_passwd table which doesnt exist. I really don't know why it is trying to access it. a quick hack might be to create the pw_clear_passwd field, just to satisfy it being there and see if its even gets populated. - Original Message - From: nicholas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:58 PM 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 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
