Actually the problem wasn't with dbmail, but it affected dbmail.
Today suddenly people using imap could not see the message contents any
more. New emails arrived in folders with proper subjects and to/from
fields. Everything worked fine except all the messages (new and old)
were empty, zero bytes. Not even the message headers were there. As if
the data from the messageblks table was missing, while the data from
other tables was there.
This problem was seen on different Outlook clients as well as Thunderbird.
I tried to find the problem for hours. I tested pop3, which turned out
to have exactly the same problem. Restarted dbmail and mysql, analyzed
and checked the tables. Ran dbmail-util etc. To no avail.
However, what finally and suddenly solved the problem, was a reload of
the iptables firewall rules. Simply adding/deleting rules to the chains
did not solve the problem, but at point I did an iptables-restore from
file and boom, it worked again.
I haven't touched anything on the mail server for more than a month. I
guess, there's some kind of bug in my version of kernel/iptables, that
started blocking or losing big packets once some counter or whatever got
full. That's my wild theory.
I tried to restore the iptables file I made during the time the problem
occurred with the -c option (restore counters) hoping I could replicate
the problem. But it didn't recreate the problem.
FYI, I'm running SLES10SP2, kernel-smp-2.6.16.60-0.31.
I have to say, that smtp and ssh worked absolutely fine the whole time.
The ONLY problem was the missing message content in imap and pop3. Also,
dbmail is connecting to mysql using a socket, not tcp/ip.
In the imapd debug logs I couldn't find any problems either.
So just beware, if you suddenly lose your message content, try not to
panic and simply reload iptables. Maybe it'll work for you too.
Of course, there's a chance something else happened at the same time I
did the iptables reload that solved the problem. For all I know, it
might have been aliens playing a prank on me.
If you have a better idea of what happened, please share.
Regards,
--
Aleksander Kamenik
System Administrator
Krediidiinfo AS
an Experian Company
Phone: +372 665 9649
Email: [EMAIL PROTECTED]
http://www.krediidiinfo.ee/
http://www.experiangroup.com/
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
