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.
----- 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
> [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.
> 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
> 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
> pass <my_pass>
> vmysql: sql error: 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