what was the parameters you used last time to configure vpopmail? before the upgrade? for version 5.3.20 ? Evren
On Mon, 18 Aug 2003 [EMAIL PROTECTED] wrote: > > > 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/ > >
