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

2012-02-13 Thread Paul J Stevens
On 02/10/2012 07:25 PM, Reindl Harald wrote: > how do i get these idiotic warnings mysql speaks about? http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html > why do i get "could not fetch reply_body" for every single lmtp-delivery > independent if the user has a reply defined? > > mysql>

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-13 Thread Paul J Stevens
On 02/10/2012 08:35 PM, drsyst...@globalcerts.net wrote: > mysql>show innodb status; > > 120210 14:15:46 Error in foreign key constraint of table > dbmail/#sql-5c9_3ed: > > FOREIGN KEY (`user_idnr`) REFERENCES `dbmail_users` (`user_idnr`) > ON DELETE CASCADE ON UPDATE CASCADE: > Canno

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread ITronic Harald Leithner
Hi, I hope thats correct. Harald Am 11.02.2012, 21:12 Uhr, schrieb Paul J Stevens : On 02/10/2012 10:04 PM, ITronic Harald Leithner wrote: 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 exam

[Dbmail] Dublicated entries in envelope table

2012-02-13 Thread ITronic Harald Leithner
Hi Paul, while trying to upgrade dbmail I came to the problem that I have 300.000 duplicated or tripled entries in dbmail_envelope, they have the same physmessage_id and envelope value but with a different id values. Can I delete the duplicated entries? thx Harald _

Re: [Dbmail] Dublicated entries in envelope table

2012-02-13 Thread Paul J Stevens
On 02/13/2012 12:07 PM, ITronic Harald Leithner wrote: > Hi Paul, > > while trying to upgrade dbmail I came to the problem that I have 300.000 > duplicated or tripled entries in dbmail_envelope, they have the same > physmessage_id and envelope value but with a different id values. > > Can I delet

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

2012-02-13 Thread Reindl Harald
Am 13.02.2012 09:09, schrieb Paul J Stevens: > On 02/10/2012 07:25 PM, Reindl Harald wrote: > >> how do i get these idiotic warnings mysql speaks about? > http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html thanks, even after 10 years in business each day learning new things! >> why do i

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

2012-02-13 Thread Paul J Stevens
On 02/13/2012 01:30 PM, Reindl Harald wrote: > Incorrect datetime value: 'NOW()' Fixed in GIT now. -- Paul J Stevenspjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy *

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

2012-02-13 Thread Reindl Harald
Am 13.02.2012 13:46, schrieb Paul J Stevens: > On 02/13/2012 01:30 PM, Reindl Harald wrote: >> Incorrect datetime value: 'NOW()' > > Fixed in GIT now. partly confirmed but this did it not make it into dbmail3 :-( https://github.com/pjstevns/dbmail/commit/f887d2e01c5a288fcd2f6ecb1639b6fb0dba203

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

2012-02-13 Thread Paul J Stevens
On 02/13/2012 02:05 PM, Reindl Harald wrote: > > > Am 13.02.2012 13:46, schrieb Paul J Stevens: >> On 02/13/2012 01:30 PM, Reindl Harald wrote: >>> Incorrect datetime value: 'NOW()' >> >> Fixed in GIT now. > > partly confirmed > > but this did it not make it into dbmail3 :-( > https://github.co

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

2012-02-13 Thread Reindl Harald
Am 13.02.2012 14:41, schrieb Paul J Stevens: > On 02/13/2012 02:05 PM, Reindl Harald wrote: >> Am 13.02.2012 13:46, schrieb Paul J Stevens: >>> On 02/13/2012 01:30 PM, Reindl Harald wrote: Incorrect datetime value: 'NOW()' >>> >>> Fixed in GIT now. >> >> partly confirmed >> >> but this did it

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

2012-02-13 Thread Paul J Stevens
On 02/13/2012 03:00 PM, Reindl Harald wrote: > so we have only the problem with ".cssclass" while forwarding remaining > and a small log error below, if weg get this cleaned dbmail3 is perfect > from my point of view Please check your sendmail option in dbmail.conf. The code for forwarding messag

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread Reindl Harald
hi is there a really good reason dropping all foreign keys and create them new? this queries are running a very long time (i am testing your convert-sql this moment) from me this feels a little to invasive, the last convertion took in summary 1 hour, i fear this would be increased a lot now | 2

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread Paul J Stevens
On 02/13/2012 03:24 PM, Reindl Harald wrote: > hi > > is there a really good reason dropping all foreign keys > and create them new? this queries are running a very > long time (i am testing your convert-sql this moment) This script was changed to be more robust in the face of slightly different

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread Reindl Harald
Am 13.02.2012 15:35, schrieb Paul J Stevens: > On 02/13/2012 03:24 PM, Reindl Harald wrote: >> hi >> >> is there a really good reason dropping all foreign keys >> and create them new? this queries are running a very >> long time (i am testing your convert-sql this moment) > > > This script was

Re: [Dbmail] Dublicated entries in envelope table

2012-02-13 Thread ITronic Harald Leithner
Looks better now thx. Am 13.02.2012, 12:28 Uhr, schrieb Paul J Stevens : On 02/13/2012 12:07 PM, ITronic Harald Leithner wrote: Hi Paul, while trying to upgrade dbmail I came to the problem that I have 300.000 duplicated or tripled entries in dbmail_envelope, they have the same physmessage_id

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread ITronic Harald Leithner
Can you show me your create statement for dbmail_sievescripts? Am 13.02.2012, 16:06 Uhr, schrieb Reindl Harald : Am 13.02.2012 15:35, schrieb Paul J Stevens: On 02/13/2012 03:24 PM, Reindl Harald wrote: hi is there a really good reason dropping all foreign keys and create them new? this qu

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

2012-02-13 Thread Reindl Harald
Hi thank you, replies are now working as expected forwarding is definitly broken! Am 13.02.2012 15:20, schrieb Paul J Stevens: > On 02/13/2012 03:00 PM, Reindl Harald wrote: > >> so we have only the problem with ".cssclass" while forwarding remaining >> and a small log error below, if weg get th

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread Reindl Harald
AFAIK this is from Fedora 10/11 2009 maybe they have backported constraints which was originally not there and with not exactly the same name :-( dbmail_sievescripts | CREATE TABLE `dbmail_sievescripts` ( `owner_idnr` bigint(10) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL, `

Re: [Dbmail] Mysql 2.2->3.0 Update Script

2012-02-13 Thread ITronic Harald Leithner
schaut so aus... I have a key called owner_idnr_2 this key is a index on owner_idnr and name. (looks like the update from 2.0 to 2.2). You have the same fields as unique key from 2.2.5 to 2.3.0 maybe the sql script should be changed to consider this. Am 13.02.2012, 16:27 Uhr, schrieb Reindl

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

2012-02-13 Thread Paul J Stevens
On 02/13/2012 04:19 PM, Reindl Harald wrote: > Hi > > thank you, replies are now working as expected > forwarding is definitly broken! > > Am 13.02.2012 15:20, schrieb Paul J Stevens: >> On 02/13/2012 03:00 PM, Reindl Harald wrote: >> >>> so we have only the problem with ".cssclass" while forward

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

2012-02-13 Thread Reindl Harald
Am 13.02.2012 16:50, schrieb Paul J Stevens: > On 02/13/2012 04:19 PM, Reindl Harald wrote: >> Hi >> >> thank you, replies are now working as expected >> forwarding is definitly broken! >> >> Am 13.02.2012 15:20, schrieb Paul J Stevens: >>> On 02/13/2012 03:00 PM, Reindl Harald wrote: >>> so

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

2012-02-13 Thread Paul J Stevens
On 02/13/2012 04:56 PM, Reindl Harald wrote: > but i am running the identical postfix-2.9 packages on both machines > these are from the internal repo and the whole machine is a clone > > how can sendmail from postfix act different and do any change to the > message if the only different binary i

Re: [Dbmail] dbmail3: forwarding problem

2012-02-13 Thread Reindl Harald
Am 13.02.2012 16:58, schrieb Paul J Stevens: > On 02/13/2012 04:56 PM, Reindl Harald wrote: > >> but i am running the identical postfix-2.9 packages on both machines >> these are from the internal repo and the whole machine is a clone >> >> how can sendmail from postfix act different and do any ch

Re: [Dbmail] Dublicated entries in envelope table

2012-02-13 Thread Alan Hodgson
On Monday, February 13, 2012 12:28:59 PM Paul J Stevens wrote: > On 02/13/2012 12:07 PM, ITronic Harald Leithner wrote: > > Hi Paul, > > > > while trying to upgrade dbmail I came to the problem that I have 300.000 > > duplicated or tripled entries in dbmail_envelope, they have the same > > physmes

Re: [Dbmail] Dublicated entries in envelope table

2012-02-13 Thread Paul J Stevens
Alan Hodgson schreef: >On Monday, February 13, 2012 12:28:59 PM Paul J Stevens wrote: >> On 02/13/2012 12:07 PM, ITronic Harald Leithner wrote: >> > Hi Paul, >> > >> > while trying to upgrade dbmail I came to the problem that I have >300.000 >> > duplicated or tripled entries in dbmail_envelope,

Re: [Dbmail] Dublicated entries in envelope table

2012-02-13 Thread Alan Hodgson
On Monday, February 13, 2012 07:47:34 PM Paul J Stevens wrote: > Alan Hodgson schreef: > >This will happen on every upgrade to 3.0. Reported in: > > > >http://dbmail.org/mantis/view.php?id=897 > > That bug was fixed last week. Awesome, thanks. ___ DBmai

[Dbmail] dbmail3: RFC 821?

2012-02-13 Thread Reindl Harald
Hi Paul please change the topic from "forwarding multi-mime messages broken" to "any line starting with a dot is broken" attached 3 files * HTML-Source with 3 css-classes * one time sent as plain -> appears with ".." instead "." in the MUA * one time sent as multimime -> HTML part appears with "

Re: [Dbmail] dbmail3: RFC 821?

2012-02-13 Thread Jorge Bastos
Paul, > please change the topic from "forwarding multi-mime messages broken" > to "any line starting with a dot is broken" > > attached 3 files > > * HTML-Source with 3 css-classes > * one time sent as plain -> appears with ".." instead "." in the MUA > * one time sent as multimime -> HTML part