The mailing list for listmasters using Sympa

[Gary D McClellan <address@concealed>]

Back-story: We've run Sympa 5.2.1 for years on an older Solaris 8 
machine using Oracle as the DB. I'm now trying to bring up a test 
instance of Sympa 6.0.1 under Redhat Linux Enterprise 5, perl 5.8.8, and 
again using Oracle for the DB.

I can send a message to myself from the Sympa web interface and receive 
it intact. The Sympa server responds to commands sent in email just 
fine. I can send to a test list from an email client or post via the web 
interface and the messages are readable in the archive, but the 
distributed messages, however, are received with a blank subject line, 
and empty body.

With log level 4, the logs show:

-- May 27 15:36:34 mork sympa[714]: List::load() List::load(testlist, 
classlist2.nau.edu, )
May 27 15:36:34 mork sympa[714]: main::DoMessage() Processing message 
for testlist with priority 5, <address@concealed>
May 27 15:36:34 mork sympa[714]: main::DoMessage() Message for testlist 
from address@concealed accepted (0 seconds, 1 sessions, 3 
subscribers), message-id=<address@concealed> , size=2232
May 27 15:36:35 mork bulk[722]: mail::reaper() Reaper unwaited pids : 
Open = 0
May 27 15:36:35 mork bulk[722]: Bulk::next() Bulk::next
May 27 15:36:35 mork bulk[722]: List::db_get_handler() List::db_get_handler
May 27 15:36:35 mork bulk[722]: Bulk::messageasstring() 
Bulk::messageasstring(513c992f3c4c76e448c9ab6edfb5db52)

-> May 27 15:36:35 mork bulk[722]: internal error : current packet 
'messagekey= 513c992f3c4c76e448c9ab6edfb5db52 contain a ref to a null 
message

May 27 15:36:35 mork bulk[722]: mail::smtpto() 
mail::smtpto(address@concealed, 
address@concealed,address@concealed,address@concealed, )
May 27 15:36:35 mork bulk[722]: mail::smtpto() Open = 0
May 27 15:36:36 mork bulk[722]: Bulk::remove() 
Bulk::remove(513c992f3c4c76e448c9ab6edfb5db52,edd8f31c402e8505b2fbce6512a264ea)
May 27 15:36:36 mork bulk[722]: Done sending message 
513c992f3c4c76e448c9ab6edfb5db52 to list address@concealed 
(priority 5) in 2 seconds since scheduled expedition date. Now sending VERP.

On the DB side, I see data for "messagekey" and "message" in the 
bulkspool_table, but no data entries at all in the bulkmailer_table.
I suspect the bulkmailer_table isn't being written to

Any hints or suggestions on how I might further debug this would be 
appreciated.

--
Gary McClellan - Unix Systems Administrator Senior - (928) 523-6508
address@concealed -  http://jan.ucc.nau.edu/~gdm44 for PGP/GPG key
Northern Arizona University - Info. Technology Srvs. - Flagstaff AZ 86011

Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are, by
definition, not smart enough to debug it. -- Brian Kernighan