RE: [vchkpw] differences mysql user-table in vpopmail versions 4.9.10 and 5.2.1?
Yuppers, there's a README.tren file that details how to convert from 4.9.10 to the 5.0 series enabling plain text password support. Tren -Original Message- From: Andrea Cerrito [mailto:ml@;centromultimediale.it] Sent: Friday, November 01, 2002 12:52 PM To: Vpopmail List Cc: Michael Bowe Subject: RE: [vchkpw] differences mysql user-table in vpopmail versions 4.9.10 and 5.2.1? -BEGIN PGP SIGNED MESSAGE- Search the new vpopmail doc in the tar.gz: you should find a doc to upgrade from old mysql table to 5.2 one. Anyway, if my mind isn't corrupted :), the only change is the new column pw_clear_password. Andrea Cerrito IT Manager +39. 0744. 5441. 1 +39. 348. 4912. 581 www.centromultimediale.tv Vincitore del 35° Smau Industrial Design ICOGRADA Excellence Award 2002 www.centromultimediale.it www.etad.it == /history Due giovani e uno meno giovane si trovano proiettati a causa di una serie di fatalita' in un mondo parallelo dove non esistono le leggi del business ma solo follia e dolore. > -Original Message- > From: Michael Bowe [mailto:mbowe@;pipeline.com.au] > Sent: Friday, November 01, 2002 12:38 PM > To: [EMAIL PROTECTED] > Subject: Re: [vchkpw] differences mysql user-table in vpopmail > versions 4.9.10 and 5.2.1? > > > You should be able to compare the table layouts by looking in the > vmysql.h file for both versions. > > I am sure there have been some changes made along the way. > > Michael. > > > - Original Message - > From: "Jan Reilink" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 01, 2002 10:12 PM > Subject: [vchkpw] differences mysql user-table in vpopmail versions > 4.9.10 and 5.2.1? > > > > [Let's hope this is the correct mailinglist, I'm new here] > > > > Unable to find an answer on the Net, I'm trying here. Is there a > > difference in the mysql user-table between the vpopmail versions > > 4.9.10 and 5.2.1? > > > > We are trying to install a new mailserver running qmail and vpopmail > > and doing so we tried to copy the database 1 on 1 to the new server. > > After we did this and tried to telnet to localhost:110 we got a > > table structure error[1]. > > > > We have approx. 10,000 virtual domains with a possible 100,000 users > > (10 POP accounts per domain), so you can understand our problem :) > > Did anyone else encounter this problem? If yes, how did you/he/she > > solve this? I noticed there is a 17 pages Changelog between these > > versions, so it wouldn't suprise me if there has changed something > > in the databse :) > > > > The domain dsinet.be (my test domain :) is already running on the > > new mailserver, telnetting to it gives me this: telnet pop.dsinet.be > > 110 user @dsinet.be > > +OK > > pass > > vmysql: sql error[3]: Unknown column 'pw_clear_passwd' in 'field > > list' -ERR authorization failed > > Connection closed by foreign host. > > > > Thanks in advance for any pointers/urls/help. > > > > -- > > Best regards, > > > > Jan reilink > > VEVIDA Services > > > > > > > > -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQEVAwUBPcLbW/o9HK4+yTI3AQFR4Qf9G1MDEoYMgXHYvTezLknr8ga95Gbq7gLL TEE7YpTzgcDunOByU0cgnLW2z8CXcwRNeF9dbYSVoVPV7XhStRekFyZi0DRSABvq DMaWXo7orcf3ljuarFDDUm6yDzINC2jbcQnDjrsEHkndxN0qBpK4mMYAmpCqjEMe nMjC+hHCux+4zmsyW+4/ZmbuGuqLzp6Ywy36TzD6b/XEiXSJhWVYIZzoJgWshdc2 3Nar0XaXfUb9sJp1hDvZ3U1UYzx3eGe2eWyw7gy6JVwXa5j4nIroAlVVLp+QuXKb JGMlrt0z2Ko+58uAqvwT1XZsPwYi9EIcRUJ62aA+zEX4/vKhtPd5hA== =5qpn -END PGP SIGNATURE-
RE: [vchkpw] differences mysql user-table in vpopmail versions 4.9.10 and 5.2.1?
-BEGIN PGP SIGNED MESSAGE- Search the new vpopmail doc in the tar.gz: you should find a doc to upgrade from old mysql table to 5.2 one. Anyway, if my mind isn't corrupted :), the only change is the new column pw_clear_password. Andrea Cerrito IT Manager +39. 0744. 5441. 1 +39. 348. 4912. 581 www.centromultimediale.tv Vincitore del 35° Smau Industrial Design ICOGRADA Excellence Award 2002 www.centromultimediale.it www.etad.it == /history Due giovani e uno meno giovane si trovano proiettati a causa di una serie di fatalita' in un mondo parallelo dove non esistono le leggi del business ma solo follia e dolore. > -Original Message- > From: Michael Bowe [mailto:mbowe@;pipeline.com.au] > Sent: Friday, November 01, 2002 12:38 PM > To: [EMAIL PROTECTED] > Subject: Re: [vchkpw] differences mysql user-table in vpopmail > versions 4.9.10 and 5.2.1? > > > You should be able to compare the table layouts by looking in the > vmysql.h file for both versions. > > I am sure there have been some changes made along the way. > > Michael. > > > - Original Message - > From: "Jan Reilink" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 01, 2002 10:12 PM > Subject: [vchkpw] differences mysql user-table in vpopmail versions > 4.9.10 and 5.2.1? > > > > [Let's hope this is the correct mailinglist, I'm new here] > > > > Unable to find an answer on the Net, I'm trying here. Is there a > > difference in the mysql user-table between the vpopmail versions > > 4.9.10 and 5.2.1? > > > > We are trying to install a new mailserver running qmail and > > vpopmail and doing so we tried to copy the database 1 on 1 to the > > new server. After we did this and tried to telnet to > > localhost:110 we got a table structure error[1]. > > > > We have approx. 10,000 virtual domains with a possible 100,000 > > users (10 POP accounts per domain), so you can understand our > > problem :) Did anyone else encounter this problem? If yes, how > > did you/he/she solve this? > > I noticed there is a 17 pages Changelog between these versions, > > so it wouldn't suprise me if there has changed something in the > > databse :) > > > > The domain dsinet.be (my test domain :) is already running on the > > new mailserver, telnetting to it gives me this: > > telnet pop.dsinet.be 110 > > user @dsinet.be > > +OK > > pass > > vmysql: sql error[3]: Unknown column 'pw_clear_passwd' in > > 'field list' > > -ERR authorization failed > > Connection closed by foreign host. > > > > Thanks in advance for any pointers/urls/help. > > > > -- > > Best regards, > > > > Jan reilink > > VEVIDA Services > > > > > > > > -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQEVAwUBPcLbW/o9HK4+yTI3AQFR4Qf9G1MDEoYMgXHYvTezLknr8ga95Gbq7gLL TEE7YpTzgcDunOByU0cgnLW2z8CXcwRNeF9dbYSVoVPV7XhStRekFyZi0DRSABvq DMaWXo7orcf3ljuarFDDUm6yDzINC2jbcQnDjrsEHkndxN0qBpK4mMYAmpCqjEMe nMjC+hHCux+4zmsyW+4/ZmbuGuqLzp6Ywy36TzD6b/XEiXSJhWVYIZzoJgWshdc2 3Nar0XaXfUb9sJp1hDvZ3U1UYzx3eGe2eWyw7gy6JVwXa5j4nIroAlVVLp+QuXKb JGMlrt0z2Ko+58uAqvwT1XZsPwYi9EIcRUJ62aA+zEX4/vKhtPd5hA== =5qpn -END PGP SIGNATURE-
Re: [vchkpw] differences mysql user-table in vpopmail versions 4.9.10 and 5.2.1?
You should be able to compare the table layouts by looking in the vmysql.h file for both versions. I am sure there have been some changes made along the way. Michael. - Original Message - From: "Jan Reilink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 01, 2002 10:12 PM Subject: [vchkpw] differences mysql user-table in vpopmail versions 4.9.10 and 5.2.1? > [Let's hope this is the correct mailinglist, I'm new here] > > Unable to find an answer on the Net, I'm trying here. Is there a > difference in the mysql user-table between the vpopmail versions 4.9.10 > and 5.2.1? > > We are trying to install a new mailserver running qmail and vpopmail and > doing so we tried to copy the database 1 on 1 to the new server. After > we did this and tried to telnet to localhost:110 we got a table > structure error[1]. > > We have approx. 10,000 virtual domains with a possible 100,000 users (10 > POP accounts per domain), so you can understand our problem :) > Did anyone else encounter this problem? If yes, how did you/he/she solve > this? > I noticed there is a 17 pages Changelog between these versions, so it > wouldn't suprise me if there has changed something in the databse :) > > The domain dsinet.be (my test domain :) is already running on the new > mailserver, telnetting to it gives me this: > telnet pop.dsinet.be 110 > user @dsinet.be > +OK > pass > vmysql: sql error[3]: Unknown column 'pw_clear_passwd' in > 'field list' > -ERR authorization failed > Connection closed by foreign host. > > Thanks in advance for any pointers/urls/help. > > -- > Best regards, > > Jan reilink > VEVIDA Services > > >
[vchkpw] differences mysql user-table in vpopmail versions 4.9.10 and 5.2.1?
[Let's hope this is the correct mailinglist, I'm new here] Unable to find an answer on the Net, I'm trying here. Is there a difference in the mysql user-table between the vpopmail versions 4.9.10 and 5.2.1? We are trying to install a new mailserver running qmail and vpopmail and doing so we tried to copy the database 1 on 1 to the new server. After we did this and tried to telnet to localhost:110 we got a table structure error[1]. We have approx. 10,000 virtual domains with a possible 100,000 users (10 POP accounts per domain), so you can understand our problem :) Did anyone else encounter this problem? If yes, how did you/he/she solve this? I noticed there is a 17 pages Changelog between these versions, so it wouldn't suprise me if there has changed something in the databse :) The domain dsinet.be (my test domain :) is already running on the new mailserver, telnetting to it gives me this: telnet pop.dsinet.be 110 user @dsinet.be +OK pass vmysql: sql error[3]: Unknown column 'pw_clear_passwd' in 'field list' -ERR authorization failed Connection closed by foreign host. Thanks in advance for any pointers/urls/help. -- Best regards, Jan reilink VEVIDA Services
