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:

vmysql: sql error[3]:
Sorry, no mailbox here by that name. vpopmail (#5.1.1)

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

[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
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

--- 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 ) "
 #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 ) "

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/

Reply via email to