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/
