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/
