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 <myname>@dsinet.be > > +OK > > pass <my_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-----