Max wrote:
Hi to all,
I've a prob with dbmail+mysql ....
Looking at /var/log/mail.log I've seen error that said (more or less):
"Error inserting into dbmail_messageblks ... the table is full ..." and
running "mailq" there were a lot of messagge not sent for "Temporary
failure".
At this point I've deleted some msg stocked on the imap server and then
I've runned "/usr/sbin/dbmail-util -cturpd -l 24h -qq". All now works
fine but ...
I've checked the tables on the dbmail database and they are all under
10000 KB ...
My question is: how can I solve this prob for the next time? (I mean:
... the table is full ...)
Many thanks in advance.
max
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
First check if your kernel has LFS (large file support), then run the
following MySQL command:
ALTER TABLE messageblks MAX_ROWS=1000000000 AVG_ROW_LENGTH=33178;
(taking the average row length from dbmail-administrator's handy
output). Hope it works!
--
Dominic Amann, Linux Based Solutions Ltd., <http://www.lbs.ca/>
18 Candlewood Cr, Toronto, ON M3J 1G8
Tel: (416) 678-2297
