Dominic Amann wrote:
Dominic Amann wrote:
I spent most of the last 72 hours implementing a new server with
dbmail-mysql, and postfix. It was working, I was slowly (and
painfully) populating the database with messages from the old system
(were in uw-mbx format) using fetchmail.
Until about 4:30pm today, messages were succesfully received. Since
then every attempt to deliver a message into the system has resulted
in a log message of:
insert_messages(): error inserting msgblock [header]
Does anyone have any clues for this tragic end?
Ahh, never mind. I cranked up my log level and found that my messageblk
file is 4GB. New question: how can I increase my max file size in Debian
woody?
Ahh, never mind: my kernel has LFS (large file support, so I found the
required info in mysql:
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
