Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Paul J Stevens
On 02/04/2012 04:12 PM, Reindl Harald wrote: > Feb 4 16:05:58 dbmail-test postfix/cleanup[7673]: 59812BC: > message-id=<20120204150558.5981...@dbmail-test.thelounge.net> > Feb 4 16:05:58 dbmail-test postfix/qmgr[7603]: 59812BC: > from=, size=454, nrcpt=1 (queue > active) > Feb 4 16:05:58 dbmail

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Reindl Harald
Am 10.02.2012 13:12, schrieb Paul J Stevens: > On 02/04/2012 04:12 PM, Reindl Harald wrote: >> Feb 4 16:05:58 dbmail-test postfix/cleanup[7673]: 59812BC: >> message-id=<20120204150558.5981...@dbmail-test.thelounge.net> >> Feb 4 16:05:58 dbmail-test postfix/qmgr[7603]: 59812BC: >> from=, size=4

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Paul J Stevens
On 02/10/2012 01:24 PM, Reindl Harald wrote: > so this is really a showstopper because there are many people which > would kill me if i break autoreplies with a update, so currently > i can update the "small server" tomorrow night because there are > no replies and no backend communicated to users

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-10 Thread drsystems
Paul, I have been modifying the 2_2-3_0.sql as you suggested. Almost there, it is a struggle to get all foreign keys right. I have read the UPGRADING doc but please clarify: on old host: I backup first, then apply my modified 2_2-3_0.sql, and then I use mysqldump to transfer to the new host. on

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-10 Thread Paul J Stevens
On 02/10/2012 02:34 PM, drsyst...@globalcerts.net wrote: > Paul, > > I have been modifying the 2_2-3_0.sql as you suggested. Almost there, it > is a struggle to get all foreign keys right. > > I have read the UPGRADING doc but please clarify: > on old host: > I backup first, then apply my modifie

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Paul J Stevens
On 02/10/2012 03:55 PM, Reindl Harald wrote: > problem exists also with > dbmail-3.0.0-6.fc15.20120210.rh.b745a81d39b75d9f335779cc8af3a906b4eb01e1.x86_64 > > another debug-log attached, here the debug-output of the reply-query, rest as > attachment (lines 665-669 are interesting) > > BTW - why is

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Reindl Harald
Am 10.02.2012 16:10, schrieb Paul J Stevens: > On 02/10/2012 03:55 PM, Reindl Harald wrote: >> problem exists also with >> dbmail-3.0.0-6.fc15.20120210.rh.b745a81d39b75d9f335779cc8af3a906b4eb01e1.x86_64 >> >> BTW - why is the host-name messed up in the log? > > Good question. What locale are you

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Paul J Stevens
On 02/10/2012 04:39 PM, Reindl Harald wrote: > but this is not the problem, hostname is truncated and the special chars are > something added while truncate, the following line of a cat in terminal shows > the truncate without special char Heh, a stack-overflow. fixed it. -- __

[Dbmail] dbmail3: forwarding breaks HTML mail again

2012-02-10 Thread Reindl Harald
ouch, a dbmail2 error is reintroduced somewhere after august/september 2009 this was fixed in dbmail-2.2, as far as i remember the dot of css-classs in HTML was doubled, in dbmail3 currently three dots in the source of received mail .test1{color:red;} .test2{color

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Reindl Harald
Am 10.02.2012 17:22, schrieb Paul J Stevens: > On 02/10/2012 04:39 PM, Reindl Harald wrote: > >> but this is not the problem, hostname is truncated and the special chars are >> something added while truncate, the following line of a cat in terminal shows >> the truncate without special char > >

Re: [Dbmail] dbmail3: auto-replies not working

2012-02-10 Thread Reindl Harald
Am 10.02.2012 16:10, schrieb Paul J Stevens: > On 02/10/2012 03:55 PM, Reindl Harald wrote: >> problem exists also with >> dbmail-3.0.0-6.fc15.20120210.rh.b745a81d39b75d9f335779cc8af3a906b4eb01e1.x86_64 >> >> another debug-log attached, here the debug-output of the reply-query, rest as >> attachm

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-10 Thread drsystems
I have modified the script dbmail-3.0.0-rc3/sql/mysql/2_2-3_0.mysql. It works and I tested moving one message from a 2.2 to a 3.0 dbmail. But there are three foreign keys that are not getting put back. These are: dbmail_auto_replies_ibfk_1 dbmail_messageblks_ibfk_1 dbmail_headervalue_ibfk_1 I have

[Dbmail] Mysql 2.2->3.0 Update Script

2012-02-10 Thread ITronic Harald Leithner
Hi, first there is an inconsistent in the create_table.sql and the upgrade 2_2-3_0.sql in create_table the some bigint columns are not unsigned for example: part_id, physmessage_id, headername_id, headervalue_id but in the upgrade file all bigint columns are unsigned, so I think that all columns