Perhaps you didnt upgrade qmailadmin, if you even do a reinstall it might get broken again. Qmailadmin statically compiles in some vpopmail conf files inside...
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'd also like to add that qmailadmin does continue to work. I can still log > into qmailadmin and it shows all the proper users. I can also still log in as > the user via imap/pop3. > > This is totally got me crazed, heh. > > -Patrick > > > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > >
