AH I SEE you should recompile without enable clear passwords (which doesnt seem to be in your configure options anyhow, weird) or perhaps if it is enabled automatically for some weird reason in newer versions you just have to add the disabling option perhaps the only difference is that you dont have cleartext password field in your mysql because you werent using, but as it seems your new installation wants to use it. got the point? :p
On Mon, 18 Aug 2003 [EMAIL PROTECTED] wrote: > Quoting "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > > > > > > > I was successfully running vpopmail-5.3.20. I decided to upgrade to > > vpopmail-5.3.24 and now I'm getting the following bounce messages: > > > > [snip] > > <[EMAIL PROTECTED]>: > > vmysql: sql error[3]: > > Sorry, no mailbox here by that name. vpopmail (#5.1.1) > > [/snip] > > > > I used the following parameters to configure vpopmail: > > > > ./configure --enable-mysql=y --enable-roaming-users=y \ > > --enable-defaultquota=100000000S,10000C --enable-learn-passwords=y \ > > --enable-mysql-replication=y --enable-logging=p --enable-mysql-logging=y > > > > Before I did my make install, I made sure to edit vmysql.h with the proper > > database settings. The user and password is identical to my old vmysql.h. > > > > The user [EMAIL PROTECTED] does still exist in vpopmail's database > > as > > well as its mailbox exists in vpopmail's directory. What baffles me is that I > > thought vdominfo also reads from the database to pull out information as > > well. > > > > Upon doing a vdominfo for perfectservers (or any other domain on the box), I > > get > > this: > > > > [EMAIL PROTECTED]:/usr/local/vpopmail/bin# ./vdominfo perfectservers.com > > domain: perfectservers.com > > uid: 89 > > gid: 89 > > dir: /usr/local/vpopmail/domains/perfectservers.com > > users: 4 > > > > But doing a vuserinfo, I get: > > > > [EMAIL PROTECTED]:/usr/local/vpopmail/bin# ./vuserinfo > > [EMAIL PROTECTED] > > vmysql: sql error[3]: > > no such user [EMAIL PROTECTED] > > > > I couldn't even begin to guess what is wrong, but it has something obviously > > to > > do with vpopmail reading the mysql db. I've double and triple checked the > > user/pass in vmysql.h > > > > And just to show I have, I diff'ed the two vmyqsl.h files and this is the > > output > > difference: > > > > --- vmysql.h Mon Aug 18 10:20:43 2003 > > +++ ../vpopmail-5.3.20/vmysql.h Fri Jul 11 20:44:29 2003 > > @@ -48,11 +48,11 @@ > > primary key (pw_name, pw_domain ) " > > #else > > #define TABLE_LAYOUT "pw_name char(32) not null, \ > > -pw_domain char(64) not null, \ > > +pw_domain char(64) not null, > > pw_passwd char(40), \ > > pw_uid int, pw_gid int, \ > > pw_gecos char(48), \ > > -pw_dir char(160), \ > > +pw_dir char(160), > > pw_shell char(20), \ > > primary key (pw_name, pw_domain ) " > > #endif > > > > Everything I've googled for seems to show that the 'mysql server has gone > > away'. > > But the mysql server is running just fine for everything else. I can > > connect > > as the vpopmail user and query the vpopmail db just fine as well. > > > > Does anyone have any suggestions? > > > > Thank you for your time. > > -Patrick Lahni > > > > ------------------------------------------------- > > This mail sent through IMP: http://horde.org/imp/ > > > > > > I think I may have found the problem. Was there a structural change from 5.3.20 > to 5.3.24 in the mysql database? > > Just to see if I could create a new domain and have it work, I did the > following: > > [EMAIL PROTECTED]:/usr/local/vpopmail/bin# ./vadddomain blah.com > Please enter password for postmaster: > enter password again: > vmysql: sql error[3]: Table 'vpopmail' already exists > vmysql: sql error[3]: > vmysql: sql error[2]: Unknown column 'pw_clear_passwd' in 'field list' > Error: Unable to chdir to vpopmail/users directory > > > Any ideas on how how to fix this problem now? > > Thanks. > > -Patrick > > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > >
