Thanks for the pointer to the tool, Phil...
Unfortunately, it appears that the # of users "bug" is a symptom, not
the real problem. Using navicat, I have repaired the # of users entry in
the dir_control field.
However, my users on this system all remain unable to receive email.
(same error)
I have also verified (to the best of my limited ability) that the
remaining mysql table entries (for dir_control, and the domain) are
"sane" by comparing their entries with another server's tables...
The users are able to SEND messages just fine -- it's just their inbound
mail that's bouncing. So I believe chkuser is working fine... what I
next need to know is what other facility within qmail-smtp could result
in this bounce message, and how can I test it to see where its failing?
Thanks again in advance for any help!
Dan
PS: I have to admit -- I'm getting frustrated with the whole
qmail-toaster idea -- being a sys-admin for decades, I'm not used to
deploying systems that are "magic boxes" -- I like to know HOW things
work (and WHY they work)... but sendmail was a BITCH (always has been),
and I was impressed with what other people had said about the toaster.
I'm beginning to think I should learn POSTFIX. <sigh> at least then,
when things broke, I'd have some better ideas about where to look and
what to tweak!
hopefully, someone will show me a DUH item that will restore my faith in
the qmail-toaster idea....
Daniel McAllister, President
IT4SOHO, LLC
2171 Wrens Way
Clearwater, FL 33764
877-IT4SOHO: Toll Free
727-647-7646 In Pinellas
813-464-2093 In Hillsborough
727-507-9435 Fax Only
"When did you do your last backup?"
Ask me about unattended backup solutions...
to protect your business, not just your data!
Phil Leinhauser wrote:
Do a google search for a product called navicat. It's an admin tool MySQL.
Once you connect to your MySQL, you'll see the tables. When you right click on
a table or group of tables, you have the option to check tables. It will
report the state back as ok, crashed, corrupted, etc. On the bad tables, you
can right click repair tables. It will then fix any errors it found. I have
found Navicat to be a pretty invaluable tool for MySQL. You can get a full
feature 30 day demo I think.
Phil
-----Original message-----
From: Dan McAllister [EMAIL PROTECTED]
Date: Mon, 16 Jul 2007 12:29:13 -0400
To: qmailtoaster-list@qmailtoaster.com
Subject: [qmailtoaster] Domain bouncing mail, vuser says user is fine
OK... this is the 3rd time this has happened to me, and the "fix" I've
used in the past just isn't feasible this time...
I've got a domain on a qmail-toaster (I've tried migrating to qtplus,
but the sandbox creation always fails because of the symbolic links and
additional mounted filesystems (backup and home are on separate
drives)... but that's another story)...
The issue is that after running fine for a while, a domain's mysql
database gets reasonably well corrupted. At current, if I do a vdominfo
on the domain, it shows what I suspect is an error associated with doing
signed arithmetic on an unsigned value, or vice-versa. The number of
users is being reported as 2147483647 (which is 7FFFFFFF in hex).
If I run vuserinfo, all the expected users show just fine, however
/something/ in qmail-smtp is reporting that there are no users in the
domain (all users are bouncing mail as "no mailbox here by that name")
-- so I suspect qmail-smtp is using the # of users value and finds it
too large.
I've had this problem before, but on much smaller domains. Previously,
to resolve this problem, I have backed up the old mailboxes, deleted the
entire domain (vdeldomain), deleted ALL of the mysql databases (rm -rf
/var/lib/mysql/*), re-started mysql (to generate new base databases in
/var/lib/mysql), reset the mysql default password, added the vpopmail
mysql database, re-added each of the users (plus aliases, forwards,
etc.) manually into the vpopmail database, verified correctness, then
finally restoring the old mailbox entries.
*There has to be a better way! *(With this particular domain, that'll be
an all-day project! Over 150 users!)
Surely this mysql database entry that has counted the # of users can be
fixed somehow WITHOUT starting from scratch! I'm no database guy, but I
am a pretty astute Linux (UNIX) admin... so I'm hoping someone out there
with the MYSQL knowhow can lead me in the right direction to fix this ASAP!
Thanks in advance,
Dan
Daniel McAllister, President
IT4SOHO, LLC
2171 Wrens Way
Clearwater, FL 33764
877-IT4SOHO: Toll Free
727-647-7646 In Pinellas
813-464-2093 In Hillsborough
727-507-9435 Fax Only
"When did you do your last backup?"
Ask me about unattended backup solutions...
to protect your business, not just your data!
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]