Re: [Dbmail-dev] [DBMail 0001021]: The version of the libevent is missing
I had the same problem. Fixing the INSTALL file can be done in one minute. Would be nice to have that. Am 23.08.2013 17:48, schrieb Mantis Bug Tracker: == Project:DBMail Issue ID: 1021 Category: Documentation Reproducibility:always Severity: trivial Priority: normal Status: new target: == Date Submitted: 23-Aug-13 17:48 CEST Last Modified: 23-Aug-13 17:48 CEST == Summary:The version of the libevent is missing Description: The version 3.1.0 and higher of the dbmail requires the version 2.0.0 or higher of the libevent by configure script. Perhaps it would be appropriate to indicate the version of the libevent in the file INSTALL. I searched for a long time why I can not use the lower version of the libevent. Thanks for the great application. == ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] Reply for IMAP Mail shows no e-mail address, only real name
Am 28.02.2013 12:53, schrieb Paul J Stevens: On 02/28/2013 09:47 AM, Michael Monnerie wrote: Hello, we still see this bug occuring frequently. Users cannot reply to an address, as only the users real name is written there instead the e-mail address. Is this a dbmail problem or in some library? Any hint would be good so I can solve it. As I asked before in this thread: help make it reproducible by obtaining the IMAP-envelope and full headers of the original message, since my only hypothesis is that the envelope is incorrect. copy the broken message to a 'test' mailfolder, then: nc imapserver imapserver x login username password x select test x fetch * envelope x fetch * rfc822.header x logout Sorry for the long delay, I had to wait to get a customer report, now I have it. This time, the mail has an attachment, which show correctly in squirrelmail, but in Apple Mail, the user sees the attachment as characters, like this: [snipped the beginning of the mail] Diese e-mail wurde über den Zarafa Server der Protéger.at gesendet. http://proteger.at/ Facebook: http://facebook.com/protegerat --=_WtFvmGI2rTzutjLsHAtaeo9sz4Tyl3bIP+ma6GbtGdrwCgva Content-Type: application/pdf; name 13_606.pdf;name*=iso-8859-1''%32%30%31%33%5F%36%30%36%2E%70%64%66 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename 13_606.pdf; filename*=iso-8859-1''%32%30%31%33%5F%36%30%36%2E%70%64%66 JVBERi0xLjMNCjEgMCBvYmoNCjw8IA0KL0xlbmd0aCA0NjkwDQovRmlsdGVyIC9GbGF0ZURl So I guess there's a problem between mail content and attachment beginning? Here the part that you wanted, I'm not sure its interesting in this case: x fetch * envelope x fetch * rfc822.header * 8546 EXISTS * 0 RECENT * FLAGS (\Seen \Answered \Deleted \Flagged \Draft $Forwarded $Junk $NotJunk Forwarded Junk JunkRecorded NotJunk) * OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft $Forwarded $Junk $NotJunk Forwarded Junk JunkRecorded NotJunk \*)] Flags allowed. * OK [UIDNEXT 499203] Predicted next UID * OK [UIDVALIDITY 85] UID value * OK [UNSEEN 1] first unseen message x OK [READ-WRITE] SELECT completed * 8546 FETCH (ENVELOPE (Wed, 01 May 2013 13:30:37 +0200 =?iso-8859-1?Q?AW=3A_Rechnung_2013-606?= ((=?iso-8859-1?Q?Buchhaltung_Prot=E9ger=2Eat?= NIL buchhaltung is.it-management.at)) ((=?iso-8859-1?Q?Michael_Monnerie?= NIL michael.monnerie is.it-management.at)) ((=?iso-8859-1?Q?Buchhaltung_Prot=E9ger=2Eat?= NIL buchhaltung is.it-management.at)) ((=?iso-8859-1?Q?Michael_Braunstorfer?= NIL mib viennapaint.com)) NIL NIL b9b2d60d-bc91-4fda-9c1e-380e0253e...@viennapaint.com zarafa.5180fcdd.4655.7c63028517900...@zarafa16.zmi.at)) x OK FETCH completed * 8546 FETCH (RFC822.HEADER {2148} Received: from protegate54.zmi.at (protegate54.zmi.at [212.69.164.56]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN protegate5.zmi.at, Issuer power4u.zmi.at (not verified)) by mail.viennapaint.com (Postfix) with ESMTPS id 45C4F1800099 for m...@viennapaint.com; Wed, 1 May 2013 13:30:37 +0200 (CEST) X-Envelope-From: buchhalt...@is.it-management.at Received: from localhost (localhost [127.0.0.1]) by protegate54.zmi.at (Postfix) with ESMTP id A5A27145E2 for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) X-Virus-Scanned: amavisd-new at zmi.at Received: from protegate54.zmi.at ([127.0.0.1]) by localhost (protegate54.zmi.at [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 8CieKmD8TV4c for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) X-Envelope-From: buchhalt...@is.it-management.at Received: from zarafa16.zmi.at (zarafa16.zmi.at [212.69.164.59]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN zarafa1.zmi.at, Issuer PositiveSSL CA 2 (verified OK)) by protegate54.zmi.at (Postfix) with ESMTPS id 6DAF2145E1 for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) Received: from zarafa16.zmi.at (localhost [127.0.0.1]) by zarafa16.zmi.at (Postfix) with ESMTP id 563C118A03A5 for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) Subject: =?iso-8859-1?Q?AW=3A_Rechnung_2013-606?= From: Buchhaltung =?iso-8859-1?q?Prot=E9ger=2Eat?= buchhalt...@is.it-management.at To: Michael Braunstorfer m...@viennapaint.com Date: Wed, 1 May 2013 13:30:37 +0200 In-Reply-To: b9b2d60d-bc91-4fda-9c1e-380e0253e...@viennapaint.com References: b9b2d60d-bc91-4fda-9c1e-380e0253e...@viennapaint.com X-Priority: 3 (Normal) X-Mailer: Zarafa 7.1.4-41394 Thread-Index: Ac5GX0fCT0/rBV9YR+CeaMHxt3bvGw== Sender: Michael Monnerie michael.monne...@is.it-management.at Message-Id: zarafa.5180fcdd.4655.7c63028517900...@zarafa16.zmi.at Return-Path: buchhalt...@is.it-management.at MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable ) x OK FETCH completed x logout * BYE x OK LOGOUT completed
Re: [Dbmail] Reply for IMAP Mail shows no e-mail address, only real name
Am 28.02.2013 12:53, schrieb Paul J Stevens: On 02/28/2013 09:47 AM, Michael Monnerie wrote: Hello, we still see this bug occuring frequently. Users cannot reply to an address, as only the users real name is written there instead the e-mail address. Is this a dbmail problem or in some library? Any hint would be good so I can solve it. As I asked before in this thread: help make it reproducible by obtaining the IMAP-envelope and full headers of the original message, since my only hypothesis is that the envelope is incorrect. copy the broken message to a 'test' mailfolder, then: nc imapserver imapserver x login username password x select test x fetch * envelope x fetch * rfc822.header x logout Sorry for the long delay, I had to wait to get a customer report, now I have it. This time, the mail has an attachment, which show correctly in squirrelmail, but in Apple Mail, the user sees the attachment as characters, like this: [snipped the beginning of the mail] Diese e-mail wurde über den Zarafa Server der Protéger.at gesendet. http://proteger.at/ Facebook: http://facebook.com/protegerat --=_WtFvmGI2rTzutjLsHAtaeo9sz4Tyl3bIP+ma6GbtGdrwCgva Content-Type: application/pdf; name 13_606.pdf;name*=iso-8859-1''%32%30%31%33%5F%36%30%36%2E%70%64%66 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename 13_606.pdf; filename*=iso-8859-1''%32%30%31%33%5F%36%30%36%2E%70%64%66 JVBERi0xLjMNCjEgMCBvYmoNCjw8IA0KL0xlbmd0aCA0NjkwDQovRmlsdGVyIC9GbGF0ZURl So I guess there's a problem between mail content and attachment beginning? Here the part that you wanted, I'm not sure its interesting in this case: x fetch * envelope x fetch * rfc822.header * 8546 EXISTS * 0 RECENT * FLAGS (\Seen \Answered \Deleted \Flagged \Draft $Forwarded $Junk $NotJunk Forwarded Junk JunkRecorded NotJunk) * OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft $Forwarded $Junk $NotJunk Forwarded Junk JunkRecorded NotJunk \*)] Flags allowed. * OK [UIDNEXT 499203] Predicted next UID * OK [UIDVALIDITY 85] UID value * OK [UNSEEN 1] first unseen message x OK [READ-WRITE] SELECT completed * 8546 FETCH (ENVELOPE (Wed, 01 May 2013 13:30:37 +0200 =?iso-8859-1?Q?AW=3A_Rechnung_2013-606?= ((=?iso-8859-1?Q?Buchhaltung_Prot=E9ger=2Eat?= NIL buchhaltung is.it-management.at)) ((=?iso-8859-1?Q?Michael_Monnerie?= NIL michael.monnerie is.it-management.at)) ((=?iso-8859-1?Q?Buchhaltung_Prot=E9ger=2Eat?= NIL buchhaltung is.it-management.at)) ((=?iso-8859-1?Q?Michael_Braunstorfer?= NIL mib viennapaint.com)) NIL NIL b9b2d60d-bc91-4fda-9c1e-380e0253e...@viennapaint.com zarafa.5180fcdd.4655.7c63028517900...@zarafa16.zmi.at)) x OK FETCH completed * 8546 FETCH (RFC822.HEADER {2148} Received: from protegate54.zmi.at (protegate54.zmi.at [212.69.164.56]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN protegate5.zmi.at, Issuer power4u.zmi.at (not verified)) by mail.viennapaint.com (Postfix) with ESMTPS id 45C4F1800099 for m...@viennapaint.com; Wed, 1 May 2013 13:30:37 +0200 (CEST) X-Envelope-From: buchhalt...@is.it-management.at Received: from localhost (localhost [127.0.0.1]) by protegate54.zmi.at (Postfix) with ESMTP id A5A27145E2 for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) X-Virus-Scanned: amavisd-new at zmi.at Received: from protegate54.zmi.at ([127.0.0.1]) by localhost (protegate54.zmi.at [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 8CieKmD8TV4c for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) X-Envelope-From: buchhalt...@is.it-management.at Received: from zarafa16.zmi.at (zarafa16.zmi.at [212.69.164.59]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN zarafa1.zmi.at, Issuer PositiveSSL CA 2 (verified OK)) by protegate54.zmi.at (Postfix) with ESMTPS id 6DAF2145E1 for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) Received: from zarafa16.zmi.at (localhost [127.0.0.1]) by zarafa16.zmi.at (Postfix) with ESMTP id 563C118A03A5 for m...@viennapaint.com; Wed, 1 May 2013 13:30:42 +0200 (CEST) Subject: =?iso-8859-1?Q?AW=3A_Rechnung_2013-606?= From: Buchhaltung =?iso-8859-1?q?Prot=E9ger=2Eat?= buchhalt...@is.it-management.at To: Michael Braunstorfer m...@viennapaint.com Date: Wed, 1 May 2013 13:30:37 +0200 In-Reply-To: b9b2d60d-bc91-4fda-9c1e-380e0253e...@viennapaint.com References: b9b2d60d-bc91-4fda-9c1e-380e0253e...@viennapaint.com X-Priority: 3 (Normal) X-Mailer: Zarafa 7.1.4-41394 Thread-Index: Ac5GX0fCT0/rBV9YR+CeaMHxt3bvGw== Sender: Michael Monnerie michael.monne...@is.it-management.at Message-Id: zarafa.5180fcdd.4655.7c63028517900...@zarafa16.zmi.at Return-Path: buchhalt...@is.it-management.at MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable ) x OK FETCH completed x logout * BYE x OK LOGOUT completed
Re: [Dbmail] Reply for IMAP Mail shows no e-mail address, only real name
Am 01.05.2013 14:49, schrieb Paul J Stevens: On 05/01/2013 01:43 PM, Michael Monnerie wrote: Sorry for the long delay, I had to wait to get a customer report, now I have it. This time, the mail has an attachment, which show correctly in squirrelmail, but in Apple Mail, the user sees the attachment as characters, like this: I don't understand. Did the customer forward the 'broken' message as an attachment? If so, that doesn't help. No, I directly logged in to their webmail, moved that message to a test folder, and did what you wanted. Also, I don't see how incorrect displaying of the email address relates to the behavior you describe: incorrect display of an attachment. Both errors only appear since we changed the mailserver from cyrus to dbmail. Before that, there have been no such problems, and the former server was in production for 5+ years. So at least there's some ... incompatibility between Apple Mail and dbmail 3.0.2, but it happens rather seldom. They are about 35 heavy mail users, and only sometimes is a mail damaged. Customer has a 2nd PC at home (also Mac), and he said it happens he can't read a mail at home but it works in the office... and that's puzzling. [snipped the beginning of the mail] Diese e-mail wurde über den Zarafa Server der Protéger.at gesendet. http://proteger.at/ Facebook: http://facebook.com/protegerat --=_WtFvmGI2rTzutjLsHAtaeo9sz4Tyl3bIP+ma6GbtGdrwCgva Content-Type: application/pdf; name 13_606.pdf;name*=iso-8859-1''%32%30%31%33%5F%36%30%36%2E%70%64%66 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename 13_606.pdf; filename*=iso-8859-1''%32%30%31%33%5F%36%30%36%2E%70%64%66 JVBERi0xLjMNCjEgMCBvYmoNCjw8IA0KL0xlbmd0aCA0NjkwDQovRmlsdGVyIC9GbGF0ZURl So I guess there's a problem between mail content and attachment beginning? What makes you think so? Because the mail client displays the whole mail content, while it should recognize the end of mail text, and recognize the rest as an attachment and display it correctly. Currently it shows the attachment inline, which doesn't help too much if you want to read the PDF as a human ;-) I'm sorry for the formatting - Thunderbird is new to me. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Reply for IMAP Mail shows no e-mail address, only real name
Am Mittwoch, 13. Februar 2013, 14:43:13 schrieb Michael Monnerie: User has dbmail 3.0.2 on SLES11 SP2, clients are Apple Mac, access via IMAP. When receiving mails, only the real name part of the sender is displayed, example: Michael Monnerie instead Michael Monnerie lists.michael.monne...@is.it-management.at when the user presses reply, the mail can't be sent because Michael Monnerie is not a valid e-mail address. Any ideas how to fix? Hello, we still see this bug occuring frequently. Users cannot reply to an address, as only the users real name is written there instead the e-mail address. Is this a dbmail problem or in some library? Any hint would be good so I can solve it. -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc | Tel: +43 660 415 6531 XING: https://www.xing.com/profile/Michael_Monnerie Facebook: https://www.facebook.com/michael.monnerie Twitter: @MichaelMonnerie https://twitter.com/MichaelMonnerie LinkedIn: http://lnkd.in/uGx6ug Google+: https://plus.google.com/u/0/100598203632716687928/ Protéger.at Internet Services Austria [gesprochen: Prot-e-schee] http://protéger.at | http://proteger.at Facebook: https://www.facebook.com/protegerat Mitglied im it-management Netzwerk http://it-management.at signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Reply for IMAP Mail shows no e-mail address, only real name
Am Mittwoch, 13. Februar 2013, 14:43:13 schrieb Michael Monnerie: User has dbmail 3.0.2 on SLES11 SP2, clients are Apple Mac, access via IMAP. When receiving mails, only the real name part of the sender is displayed, example: Michael Monnerie instead Michael Monnerie lists.michael.monne...@is.it-management.at when the user presses reply, the mail can't be sent because Michael Monnerie is not a valid e-mail address. Any ideas how to fix? Hello, we still see this bug occuring frequently. Users cannot reply to an address, as only the users real name is written there instead the e-mail address. Is this a dbmail problem or in some library? Any hint would be good so I can solve it. -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc | Tel: +43 660 415 6531 XING: https://www.xing.com/profile/Michael_Monnerie Facebook: https://www.facebook.com/michael.monnerie Twitter: @MichaelMonnerie https://twitter.com/MichaelMonnerie LinkedIn: http://lnkd.in/uGx6ug Google+: https://plus.google.com/u/0/100598203632716687928/ Protéger.at Internet Services Austria [gesprochen: Prot-e-schee] http://protéger.at | http://proteger.at Facebook: https://www.facebook.com/protegerat Mitglied im it-management Netzwerk http://it-management.at signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] Reply for IMAP Mail shows no e-mail address, only real name
User has dbmail 3.0.2 on SLES11 SP2, clients are Apple Mac, access via IMAP. When receiving mails, only the real name part of the sender is displayed, example: Michael Monnerie instead Michael Monnerie lists.michael.monne...@is.it-management.at when the user presses reply, the mail can't be sent because Michael Monnerie is not a valid e-mail address. Any ideas how to fix? -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc | Tel: +43 660 415 6531 XING: https://www.xing.com/profile/Michael_Monnerie Facebook: https://www.facebook.com/michael.monnerie Twitter: @MichaelMonnerie https://twitter.com/MichaelMonnerie LinkedIn: http://lnkd.in/uGx6ug Google+: https://plus.google.com/u/0/100598203632716687928/ Protéger.at Internet Services Austria [gesprochen: Prot-e-schee] http://protéger.at | http://proteger.at Facebook: https://www.facebook.com/protegerat Mitglied im it-management Netzwerk http://it-management.at signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] imapd crashed v3.0.2
User reported can't connect via imap, and the imapd process was gone. dmesg shows this: [4403546.139853] dbmail-imapd[3447]: segfault at 7fff73fad8e0 ip 0041015a sp 7fff73fad8d0 error 6 in dbmail-imapd[40+19000] [6381633.250846] dbmail-imapd[26457]: segfault at 7fff75222fe0 ip 0041015a sp 7fff75222fd0 error 6 in dbmail-imapd[40+19000] [6793855.397886] udev: starting version 147 [8714984.381743] hrtimer: interrupt took 11272256 ns [8828457.899639] dbmail-imapd[6919]: segfault at 7fffcb940550 ip 0041015a sp 7fffcb940540 error 6 in dbmail-imapd[40+19000] [8840173.973974] dbmail-imapd[11437]: segfault at 7fffa35e8bb0 ip 0041015a sp 7fffa35e8ba0 error 6 in dbmail-imapd[40+19000] [9143977.728901] dbmail-imapd[28073]: segfault at 0 ip 7f56900e09a0 sp 7fffafe2fcc8 error 4 in libdbmail.so.0.0.0[7f56900ab000+58000] Any ideas? -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc | Tel: +43 660 415 6531 XING: https://www.xing.com/profile/Michael_Monnerie Facebook: https://www.facebook.com/michael.monnerie Twitter: @MichaelMonnerie https://twitter.com/MichaelMonnerie LinkedIn: http://lnkd.in/uGx6ug Google+: https://plus.google.com/u/0/100598203632716687928/ Protéger.at Internet Services Austria [gesprochen: Prot-e-schee] http://protéger.at | http://proteger.at Facebook: https://www.facebook.com/protegerat Mitglied im it-management Netzwerk http://it-management.at signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] IPv6 on dbmail 2.2.x?
Am Freitag, 25. Januar 2013, 09:30:17 schrieb Paul J Stevens: Anyway, for now use the work-around suggested in the 3.0 man-page, which is use '::' if you are on linux. Perfect - worked! -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc | Tel: +43 660 415 6531 XING: https://www.xing.com/profile/Michael_Monnerie Facebook: https://www.facebook.com/michael.monnerie Twitter: @MichaelMonnerie https://twitter.com/MichaelMonnerie LinkedIn: http://lnkd.in/uGx6ug Google+: https://plus.google.com/u/0/100598203632716687928/ Protéger.at Internet Services Austria [gesprochen: Prot-e-schee] http://protéger.at | http://proteger.at Facebook: https://www.facebook.com/protegerat Mitglied im it-management Netzwerk http://it-management.at signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] IPv6 on dbmail 2.2.x?
Hi, we've enabled IPv6 on our servers, but dbmail-pop3d/imapd don't answer when contacted over IPv6. Is that a matter of recompile, or do we need a higher version? We are on 2.2.15. Our bindip = *, so it should listen everywhere. -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc it-management Internet Services: Protéger http://proteger.at [gesprochen: Prot-e-schee] Tel: +43 660 / 415 6531 XING: https://www.xing.com/profile/Michael_Monnerie Twitter: @MichaelMonnerie https://twitter.com/MichaelMonnerie FaceBook: https://www.facebook.com/michael.monnerie LinkedIn: http://lnkd.in/uGx6ug Google+: https://plus.google.com/u/0/100598203632716687928/ signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] Sieve redirect or workaround
It seems sieve redirect to another e-mail address is not supported in dbmail 2.2. I guess it won't be, so has someone got an idea how to implement a rule like if header :contains From [@important ] { redirect 'ot...@address'; keep; } in postfix for a single recipient? So I want the mail to be delivered locally, plus sent to another address, based on sender, but just for a single mailbox. Would be easy with sieve redirect support. -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc it-management Internet Services http://proteger.at [gesprochen: Prot-e-schee] Tel: 0660 / 415 65 31 ** Aktuelles Radiointerview! ** http://www.it-podcast.at/aktuelle-sendung.html // Wir haben im Moment zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://zmi.at/haus2009/ signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Sieve redirect or workaround
On Dienstag, 14. September 2010 Jorge Bastos wrote: Are you sure? I always used it, with 2.2x or 2.3x Oh, I found I used redirect 'othermailaddress'; while it should really be redirect othermailaddress; Now it works, thanks for your feedback, and sorry for the noise :-) -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc it-management Internet Services http://proteger.at [gesprochen: Prot-e-schee] Tel: 0660 / 415 65 31 ** Aktuelles Radiointerview! ** http://www.it-podcast.at/aktuelle-sendung.html // Wir haben im Moment zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://zmi.at/haus2009/ signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] IMAP connections piling up - Outlook related?
On Donnerstag, 28. Januar 2010 tabris wrote: MAXCONNECTS = 2 MAXCONNECTS = 100 # IMAP prefers a longer timeout than other services. TIMEOUT = 912 IDLE_TIMEOUT = 112 We have a server with some hundred users, mostly Outlook, and no problem. It could be your MAXCONNECTS and TIMEOUT is too low, I remember there was some discussion about this once. -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc it-management Internet Services http://it-management.at Tel: 0660 / 415 65 31 // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15923011 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Large delay with email attachments when using dbmail with PostgreSQL
On Montag, 21. Dezember 2009 Werner Stoop wrote: dbmail starts to consume 99% of the CPU And what does iostats -kx 5 555 say during that time? Is there heavy I/O going on? What does vmstat say? -- mit freundlichen Grüssen, Michael Monnerie, Ing. BSc it-management Internet Services http://it-management.at Tel: 0660 / 415 65 31 // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL
On Montag, 14. Dezember 2009 Daniel Mejia wrote: still, the database size is increasing average 2GB per day Just put a max quota on your users accounts, then they *must* delete some old e-mails. If you don't use quota, people will never delete, as they just don't realize they need some space. For POP accounts, I allow 100MB. IMAP gets 500MB per default. Those who want more pay more. Simple as that. How many users do you have, and how much space do they use on average? Maybe you have some top 5 users who need a lot of space, and the rest is small anyway? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Josh Marshall wrote: I have found that since linux kernel 2.6 series, LVM snapshots have caused system lockups. I used it happily in the 2.4 series. That's why LVM snapshots are not used in XenServer 5.x. They also said it's unstable, especially under high load. Besides that, I did mention *impact-free*. Adding a snapshot and reading from a snapshot severely impacts the speed of the running system. I totally agree with your arguing. Having all together is much easier to administer. Once it's too slow, I'll throw in more hardware. It's cheaper to throw in a new server than to have the extra burden with redundancy, backup/restore, etc... So far, I haven't seen a limit on dbmail, while we had limits with older POP-only systems before, where users had the setting leave mail on server. The server had to copy the flat file all over again for each user, I/O stalled... BTW: we upgraded from PostgreSQL 8.1 to 8.3, which exactly *doubled* the speed of our nightly backups and vacuum/cluster runs. So that was a nice step which I can recommend to everybody. I wonder if 8.4 will bring another improvement. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Daniel Urstöger wrote: Well, one can also do that with a filesystem based storage, you just need something similar to the MySQL replication for flat files. DRDB for example. DRBD puts a burden on the server all the time. For a secure replication you need to wait until the I/O on the remote server is on disk too. Only if you relax that, and allow buffered I/O to the remote, the impact is negligible. But then you risk a munged DB in case your first machine brutally crashes during high I/O, and suddenly you loose some parts of your transactions which the DB does not expect. It's not nice, because the DB claims everything went OK, while some data in some tables is wrong... mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Michael Monnerie wrote: LVM snapshots Another thing to remember: You can only do a snapshot of a single filesystem at a time. So if you have your DB and attachments in different volumes, snapshots are not transactions anymore. Some people may be happy to live with that, though. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Paul J Stevens wrote: Currently, a full body text search will do a full table scan of the mimeparts table and pull in all mimeparts part of the messages in the mailbox being searched. If we want to skip all non text/* mimeparts (as allowed by the imap rfc), we'd have to add some knowledge of the mimetype contained in the mimepart. Doing so would be trivial. And so would fixing the query be that does the search. Sounds like a nice-to-have feature :-) That would be a great reason to upgrade to 2.3. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Tomas Kuliavas wrote: Emails are not raw text. There are at least two ways to write test in email and if you go to 8bit text, number of same text variations multiplies. SQL can't search emails stored in DB, because SQL does not know about encodings, mime formats and character sets So where's the difference? You can SELECT * ... WHERE mailtext LIKE 'test'::utf8 OR mailtext LIKE 'test'::base64 etc. and a flat file server would do the same anyway. The e-mail is stored in original format, so it would also search for test in all encodings. The question is anyway: Does an IMAP SEARCH search in several variations of test? What if it's base64 encoded? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Tomas Kuliavas wrote: Are you sure that syntax of your select query is correct? No, that was pseudo code to demonstrate you can search for variations within one query. how complex select call you will make in order to cover all variations? flowed format, quoted-printable, headers and body that might have text in n different charsets. Just exactly the same amount a server with flat files would have to. There's no difference. SQL is not designed to decode MIME on the fly. It all reduces to search for a certain byte combination. You just have to encode your search string to all variations you need, and put all those in a single SELECT. That was my point. In case you have to decode the mail, you need to retrieve,decode,search, and still this is the same work a flat file mailserver would do. All this discussion is about the speed of searching, and I didn't see an example where a flat file server could search faster than the DB so far. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Donnerstag, 10. Dezember 2009 Tomas Kuliavas wrote: DBMail might find its niche in some setups, but large mailboxes are not in that niche. 750 GB DB proves it. You can't do text search raw email sources. There is no point of storing them in DB. And you believe doing a raw text search on a 750GB flat file mailserver would be fast? dbmail 2.3 is different in that it stores mimeparts separately. Maybe a full text search skips binary attachments there. Paul? What I'd like to know from Daniel: Do you have 750G of real data, or is that just your DB size. It seems your setup is not optimized at all, a lost connection shows your server can't keep up with the load. Maybe all mysql Parameters need tuning anyway. dbmail heavily depends on a good DBA to give good performance. Once you have more than 10GB and 100+ users you see the difference. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Optimizing Dbmail Database
On Freitag, 11. Dezember 2009 Daniel Urstöger wrote: the Full Text Index ( FTI ) is quite bad for searches dbmail doesn't use FTI. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 6531 .network.your.ideas. // // Wir haben zwei Häuser zu verkaufen: // http://zmi.at/langegg/ // http://willhaben.at/iad/realestate/object?adId=15306857 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] :/
On Mittwoch 11 November 2009 Paul Stevens wrote: I'm not aware of any showstoppers. You may need to tweak the pg config to silence spurious warnings about slash-escaping strings - not an issue. escape_string_warning = off Yes, that needs to be in, starting from 8.3 already. Good, openSUSE 11.2 is due tomorrow, so we can start testing soon. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-lmtp: conversation with 127.0.0.1[127.0.0.1] timed out
On Montag 09 November 2009 Paul J Stevens wrote: Reindl, Hihi, that's what comes when writing the surename first. :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] invalid byte sequence for UTF8
Yesterday I saw this error again: Error:[sql] dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (2283941,'','مهند??335?UTF-8?q?ح376tf-8?QD9=85?=اد muhannad1...@hotmail.com')] : [ERROR: invalid byte sequence for encoding UTF8: 0xdd3f HINT: This error can also... Seems dbmail is to blame here, it really must encode the headers correctly before trying to insert them. Or did I miss something? This is v2.2.11 mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] pop3d segfaulting
I've had this yesterday: /var/log/messages: Nov 9 13:53:26 mailsrv1.zmi.at kernel: dbmail-pop3d[12215]: segfault at c ip f7cec943 sp ff8a66d0 error 4 in libc-2.5.so[f7c87000+128000] /var/log/dbmail: Nov 9 13:53:07 mailsrv1.zmi.at dbmail/lmtpd[14330]: Error:[message] dbmail-message.c,_set_content_from_stream(+388): Failed to flush, is your /tmp filesystem full? Nov 9 13:53:07 mailsrv1.zmi.at dbmail/lmtpd[14330]: Error:[lmtp] lmtp.c,lmtp(+578): dbmail_message_new_from_stream() failed I don't believe /tmp was full, there are 2,3GB free now. Could something else be the problem? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] :/
On Dienstag 10 November 2009 Piotr Wadas wrote: - there are still some problems on vacuuming/cleaning up the database, at least with postgresql 8.4+ Paul, is PostgreSQL 8.4 supported in dbmail-2.2 ? I'd be happy and would like to switch. Some time ago we switched from 8.1 to 8.3, and database performance *doubled*. It was a nicemove :-) Piotr, if you have problems with vacuum, you should ask on the postgresql-admin list: pgsql-ad...@postgresql.org The rest is really generic, you should explain what you *want*, not what is not supported. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] Very Offtopic question
On Mittwoch 14 Oktober 2009 Jorge Bastos wrote: Now I understand 100% why many many domains doesn't have an A record on the root domain, lazy people! They just want to create a CNAME on the WWW alias and done. I get mad with that!!! A domain is: domain.com, and not www.domain.com, ok the WWW alias became very used over the years and there's nothing I can do to make users change on their behavior, to use domain.com instead of www.domain.com, they even do when I as: Me: go to the browser and type manual.domain.com User: doesn't work Me: what did you typed? User: www.manual.domain.com Me: grrr I SAID manual.domain.com, NOT www.manual.domain.com I feel with you :-) I hate that too, I always just type domain.com into the browser, and I'm upset when they don't support that. And the users auto-www typing makes me mad too. But that's live ;-) PS: we are a small ISP, and *always* configure domain.com also. :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] DBmail and Django
My question is : can I add columns to DBmail tables without breaking something in DBmail ? Yes, I did so for my extensions to have domains and customers in it’s own tables. I also modified the aliases table without problems. mfg zmi ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] DBMail 2.2.12 released
On Donnerstag 08 Oktober 2009 Jonathan Feally wrote: Did you autoreconf -i ??? That will usually create your configure script and some other stuff. No. Didn't know that command. And package autoconf was not even installed. Usually when downloading a package, all you need to do is ./configure, with the parameters you like, and then make install. This was the case until 2.2.11, so it appears to be a mistake by Paul not to include everything. I tried installing the packages autoconf + automake, and got this: # autoreconf -i configure.in:40: warning: macro `AM_ENABLE_SHARED' not found in library configure.in:41: warning: macro `AM_ENABLE_STATIC' not found in library configure.in:40: error: possibly undefined macro: AM_ENABLE_SHARED If this token and others are legitimate, please use m4_pattern_allow. See the Autoconf documentation. configure.in:41: error: possibly undefined macro: AM_ENABLE_STATIC configure.in:116: error: possibly undefined macro: AC_PROG_LIBTOOL autoreconf: /usr/bin/autoconf failed with exit status: 1 mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[Dbmail-dev] mail to list: error
On Donnerstag 08 Oktober 2009 Mail Delivery System wrote: This is the mail system at host dbmail01.icns.fastxs.net. dbmail-dev@dbmail.org: Command time limit exceeded: /usr/sbin/dbmail-smtp Got this tonight at 2:27, just FYI. I resent my message now. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] DBMail 2.2.12 released
On Donnerstag 08 Oktober 2009 Paul J Stevens wrote: Removing them makes dbmail more portable What would be the correct way to generate them from the current state? I'm curious. The autoreconf -i didn't work for me. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] DBMail 2.2.12 released
On Mittwoch 07 Oktober 2009 Paul J Stevens wrote: Download: http://git.dbmail.eu/cgit/cgit.cgi/paul/dbmail/snapshot/dbmail-2.2.12 .tar.bz2 Thanks. Just tried it, but there are pieces missing: ./configure ./buildtools ./Makefile.in modules/Makefile.in man/Makefile.in ./config.in I copied all that from 2.2.11, but I'm not sure it's OK to simply copy that. Is it that easy? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] Standard for encoded headers (Offtopic)
On Dienstag 29 September 2009 Shane Kerr wrote: I have been getting familiar with the IMAP RFC lately, and it says this: Note that headers (part specifiers HEADER or MIME, or the header portion of a MESSAGE/RFC822 part), MUST be 7-bit; 8-bit characters are not permitted in headers. http://www.faqs.org/rfcs/rfc3501.html A bit off-topic, but: Nice, but there are programs with bugs that generate 8bit headers, namely that Outlook extension that gives the users fancy backgrounds and funny pics to add... what's it's name? Erhmmm... Incredimail. That stupid program, for german setups, creates a time header like this: 10:37 Mitteleuropäische Sommerzeit meaning mid-european summer time - see the umlaut-a (ä) there. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-util physmessage integrity
On Sonntag 27 September 2009 Casper Langemeijer wrote: dbmysql.c,db_query(+290): [The total number of locks exceeds the lock table size] [DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages)] Warning: could not delete orphaned physmessages. Check log. I'm using dbmail 2.2.10 I think this happens because dbmail-util tries to remove all 156629 physmessages in a single statement, therefore all other threads have to wait until this query is finished. Also I'm guessing that this http://www.mail-archive.com/dbmail@dbmail.org/msg15575.html bug report by Michael Monnerie led to the current situation. Because I needed to fix this I built my own php script. It basically works like this: SELECT id FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages) per 100 id's (per id would be way too slow. I found 100 to be a good number of records): That was the behaviour from earlier releases (or was it a single delete per ID?). The change was done because a single transaction normally is much faster in the db server. But I think you're going the wrong way: It should not happen that you get this message: The total number of locks exceeds the lock table size I've googled, and found this: http://bugs.mysql.com/bug.php?id=15667 Recommendation by Valeriy Kravchuk Please, increase your innodb_buffer_pool_size ten times at least if you have a default size. and later: So, this is not a bug. You should just set server variables properly. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] dbmail-util not cleaning messages
On Samstag 19 September 2009 Paul J Stevens wrote: Jorge, You're mixing up tables here. there is *no* direct connection between messages and partlists. There *is* a 1-1 connection between physmessages and partlists, and that is maintained by a database constraint. But mimeparts have a 1-N connection to partlists, so no database constraint there. Any chance to get an ER diagram for the 2.3 series? http://www.dbmail.org/dokuwiki/doku.php/er-model Would be really nice to have a quick overview, and an idea of how things work. I also used it a lot for the 2.2 series to optimize some queries. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] DBMAIL error on SELECT
On Donnerstag 17 September 2009 Paul J Stevens wrote: No way around that without full text indexing. Any chance to have FTI support? PostgreSQL 8.3 has that built-in AFAIK, so it could be interesting. Dbmail could support it if the DB supports it, I just don't know how much effort that would be. Maybe just a configuration line, or auto-detection? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Error messageblks_idnr urgent help
On Donnerstag 17 September 2009 The 7Crewz wrote: Sep 17 05:28:37 dbmail-util[20495]: Error:[sql] dbmysql.c,db_query(+290): [Lost connection to MySQL server during query] [SELECT MIN(messageblk_idnr),MAX(is_header) FROM dbmail_messageblks GROUP BY physmessage_id HAVING MAX(is_header)=0] And? A problem between dbmail and MySQL, lost connection. Your MySQL died? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Fw: Error messageblks_idnr urgent help
On Donnerstag 17 September 2009 The 7Crewz wrote: No my mysql not died Can you reproduce it? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] DBMAIL error on SELECT
On Donnerstag 17 September 2009 Jonathan Feally wrote: FTI would help searching greatly, however on MySQL the default is to only index words 4 chars or longer. Thus it makes it unreliable when searching for a small word of 3 chars or less. You can change it to index 3 chars, which would probably be sufficient, but since this is a global change on the whole database server and would require a restart, not everyone would be able to use it (hosted databases). I am unsure of SQLite FTI. I really can't see support of SQLite remaining beyond 2.4 because of the multi-server over a network requirement of 2.5 Hydra. That's why I said it maybe should be configurable. There's always somebody/something not wanting/supporting that feature, but it could help those with the capabilities to use it. Do you know what PostgreSQL does in as far as what is indexed? No. I just read on the pg-users ML that 8.3 has that, and we are on 8.4 already. So maybe support is even better there. But I never used it, not having a program using it mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] LDAP workflow
On Dienstag 15 September 2009 Peter Rabbitson wrote: I am toying with the idea to migrate all my services (login, web, samba, dbmail) to a centralized ldap setup. While I read a lot about ldap design and general operation principles, I can't quite wrap my head around it. So here goes: Is there some recommended/best practice way of seting up ldap schemas for dbmail consumption? Also is there some sort of GUI tool for ldap administration? While I am comfortable with the CLI, some of the people who will need to eventually administer users are not, and anything flashy and easy to use is a plus. Peter, I'm in the same position. Should you get any info, I'd be glad if you could inform me too. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] IMAP Fails to start on GIT HEAD
On Dienstag 15 September 2009 Jorge Bastos wrote: IMAPD crashed, and when I go to start him this happen. Then the diff seems that the TCP connections are not closed on crash in the one version, while the other does. Or the crash happens in a different path, leaving the connections open. Either way, half-open TCP connections prevent the daemon from being able to connect to the port. So it's not a problem of starting, but a problem of leaving TCP connections open on exit. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] IMAP Fails to start on GIT HEAD
On Dienstag 15 September 2009 Jorge Bastos wrote: Compiled new source. Killed imapd Started IMAPD (lots of LAST_ACK connections), but it complains about the same For the first time, this is expected, as you killed the old imapd which leaves the connections open. Once the new compiled imapd runs, and you kill it, is restarting it working? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] MySQL tweaks?
On Montag 14 September 2009 Jonathan Feally wrote: innodb_flush_log_at_trx_commit=2 Note: Everybody who care about their data, you should leave this setting on it's default 1: innodb_flush_log_at_trx_commit=1 mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] MySQL tweaks?
On Dienstag 15 September 2009 Jonathan Feally wrote: If you have minimal writes and the server is on a UPS, this setting won't make too much difference I have a home server on UPS, and can tell you from real experience what crashes I hade despite all this: 1) Broken power supply - UPS doesn't help 2) My daughter turning the server off - UPS doesn't help But you always risk your transactions for a very small performance gain. Even for your home server, never make a setup that can break your DB. It's better to use faster hardware instead, if you really, really need it. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] DBMAIL error on SELECT
On Donnerstag 10 September 2009 Michael Monnerie wrote: So, this is the query you posted stripped down: SELECT k.messageblk FROM dbmail_messageblks k WHERE k.messageblk ILIKE '%multipart/encrypted%'; He's right, that query doesn't work on PG 8.1 either. OK, this is a bug in dbmail, which can be fixed in PostgreSQL 8.3 and up: http://www.postgresql.org/docs/8.4/interactive/functions-string.html I would have thought convert_from, possibly combined with convert, would do it. And this should really do the magic, but I'm on 8.1 today, will test on 8.3 soon. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] use dbmail-deliver instead of dbmail-lmtpd
On Dienstag 15 September 2009 Jorge Bastos wrote: If this needed? I mean, I REALLY have to add a line per domain? Can I skip that part and stay only with the parts on main.cf master.cf ? Jorge, please read each word: To send all email to DBMail, add this in /etc/postfix/main.cf mailbox_transport = dbmail-deliver: If you want to decide whether or not to send to DBMail per domain, add this in /etc/postfix/transport: domaindbmail-deliver: Especially the *ALL* and *IF YOU WANT...PER DOMAIN* parts. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] DBMAIL error on SELECT
On Donnerstag 10 September 2009 David Young wrote: Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr, v.header value, k.messageblk FROM dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id=p.id JOIN dbmail_messages m ON m.physmessage _id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id WHERE m.mailbox_idnr=53 AND m.status in (0,1) HAVING SUBSTRING(v.headervalue ,0,255) ILIKE '%multipart/encrypted%' OR k.messageblk ILIKE '%multipart/encrypted%'] : [ERROR: operator does not exist: bytea ~~* unkno wn LINE 1: ...55) ILIKE '%multipart/encrypted%' OR k.messageblk ILIKE '%mu... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. ] Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[mailbox] dbmail-mailbox.c,mailbox_search(+1374): could not execute query PostgreSQL 8.3 issue. They started to have tougher type casts. The message explains that You might need to add explicit type casts.. I still don't have it, so I don't know exactly how to cast it. Maybe OR k.messageblk::varchar ILIKE '%multipart/encrypted%' would solve the problem, but you can't cast from bytea to varchar, at least in 8.2. Asking on the PostgreSQL list should help, I'll do that. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] DBMAIL error on SELECT
On Donnerstag 10 September 2009 Michael Monnerie wrote: PostgreSQL 8.3 issue Interesting, I got this answer from a PG dev: There has *never* been a Postgres release that accepted bytea ILIKE something. I'm not sure what you were really doing before, but that wasn't it. So, this is the query you posted stripped down: SELECT k.messageblk FROM dbmail_messageblks k WHERE k.messageblk ILIKE '%multipart/encrypted%'; He's right, that query doesn't work on PG 8.1 either. How did you make dbmail run such a query? Looks like via a search, but I guess that never worked and would be a bug then. So please, how can I reproduce that query? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] imapd Temporary files
On Mittwoch 12 August 2009 Reindl Harald wrote: Has anybody an idea if there is a screw to reduce temp-usage Last friday the disk was full and i had to restart dbmail-imapd There are many files which are deleted and only seen with lsof I think the only thing is to resize that partition or move /tmp to another disk and connect via symlink. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] imapd Temporary files
On Mittwoch 12 August 2009 Reindl Harald wrote: Hm - I think there is a bug because the files are marked as deleted but space is allocated No, that is intended. This is a security measure, as nobody else can access the files anymore. As soon as you stop the daemons, the space will be freed again. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] imapd Temporary files
On Mittwoch 12 August 2009 Reindl Harald wrote: As the disk ran full it was configured to 1000 and i configured to 25 because i am hoping that the processes owning the temp-files will die earlier, but there are also 5 GB of deleted temp-data What is wrong in my logic? If i restart imapd all space gets free because the processes are dying http://www.mail-archive.com/dbmail@dbmail.org/msg16123.html A bit of /tmp use is normal, I thought you just had a lot of imapd processes and that takes more space then. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] AUTH-Methods für dbmail-imapd/dbmail-po p3d
On Mittwoch 12 August 2009 Paul J Stevens wrote: Not *that* simple, but I did it nonetheless. My GIT master tree now supports AUTH=CRAM-MD5. This will however *only* work for people using authsql and plaintext passwords. Thank you. Is that dbmail-2.3 only I guess? BTW, you should be called Scotty, like the guy from Star Trek when he was asked by Captain James T. Kirk how long you need to fix it? Scotty: 3 days, it's very complicated, everythings broken Kirk: you got 20 minutes Scotty: OK :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] stunnel replacement
On Mittwoch 12 August 2009 Jonathan Feally wrote: Of course 2.3.x has native SSL support, making stunnel just added overhead. Oh, that's nice. So I'll stick with stunnel for the moment, just compiled it tonight it's painless. Why I don't want to compile myself is because I don't know about security updates then, that's why I prefer to stick with maintained packages. Thanks to the others too, I'll look at nginx for other reasons also. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] stunnel replacement
In openSUSE 10.2, I used stunnel to provide pop3s/imaps, but that package isn't anymore in 11.1. Anybody got an idea what I could use instead? It would be best if it's included in os11.1, makes life easier ;-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] AUTH-Methods für dbmail-imapd/dbmail-po p3d
On Dienstag 11 August 2009 Reindl Harald wrote: Please do not missunderstand me: Because of this things i got as nearly no sleep searching and patching things that should work out of the box while our customers are standing with a loaded gun behind me By shouting at people you won't get more help. If you offer to pay Paul for a feature you need, or ask very friendly, maybe he'd implement it quickly. Just last week he implemented IPv6 support within a short time. On the other hand, Paul, having secure methods directly implemented would really be nice. Just because the *MD5 methods require plaintext pwds doesn't mean it shouldn't be implemented. It should just be disabled by those having encrypted pwds. (/me having cleartext pwds, so could use the feature now *g*). As far as I could read from your words, it should be easy to implement? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] [DBMail 0000784]: man page of dbmail-smtp wrong
On Mittwoch 29 Juli 2009 Mantis Bug Tracker wrote: The following issue has been CLOSED = = http://dbmail.org/mantis/view.php?id=784 - - (0002867) netvulture (developer) - 29-Jul-09 05:51 http://dbmail.org/mantis/view.php?id=784#c2867 - - Patch pending commit to reflect that debian systems use /etc/dbmail/dbmail.conf vs. /etc/dbmail.conf I use --sysconfdir=/etc/dbmail in the configure script - is the documentation automatically recompiled then? Not that I personally would care, but when a new admin reads the man page, he could be confused. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] [DBMail 0000792]: Lock timeout on lmtpd message insertation during nightly dbmail-util
On Sonntag 26 Juli 2009 Mantis Bug Tracker wrote: I think you can close this. Query's that were not processed got queue by MySQL and inserted when table gets unlocked. To confirm this, i filled an account with 2GB of email, deleted all them, started dbmail-util, and send a messages in this form: echo blabla|mail m...@domain.com -s test1 echo blabla|mail m...@domain.com -s test2 and so on, and get several that gave the lock timeout error, but after dbmail-util finishes, i have all emails on the destination account. So, no problem at all this! I think the problem was when dbmail-util runs so long (30 minutes) that the lmtp process times out on an insert, because there's a limit on how long the DBMS waits for a select/insert etc. What I did not understand: Is it that the e-mail gets lost when that happens? That would be a bug. If it just times out and gets re-queued in postfix, it will be delivered later anyway. Then the only problem is that the query takes too long. AFAIK it's good optimized, so if it takes too long the DBMS or the hardware need some tuning. Please do not split up a good query that works. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[Dbmail] dbmail looses mail address in From: header
Is this a know bug? When I receive mail from this guy, in Zarafa/Outlook it stores the header like this: From: =?windows-1252?Q?M._Oostergo?= m.ooste...@zarafa.com But when received over dbmail, the mail part is lost: From: =?windows-1252?Q?M._Oostergo?= This is dbmail-2.2.11. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] dbmail looses mail address in From: header
On Freitag 24 Juli 2009 Jonathan Feally wrote: Michael Monnerie wrote: Is this a know bug? When I receive mail from this guy, in Zarafa/Outlook it stores the header like this: From: =?windows-1252?Q?M._Oostergo?= m.ooste...@zarafa.com Is this when you retrieve the message from a non-dbmail pop3/imap server? Yes. Over Zarafa (MDA) read with Outlook or IMAP (MTA). But when received over dbmail, the mail part is lost: From: =?windows-1252?Q?M._Oostergo?= Is this when the message is inserted via dbmail-smtp/dbmail-lmtp or an IMAP APPEND? Is it ok when first inserted, but then the client changes it? Received via dbmail-lmtp from postfix. I didn't know the client could change the headers. Do you mean I'd have to read the message from the DB before accessing it via kmail? I could try to read the message via IMAP from Outlook instead kmail, but I doubt it's kmail. Wasn't there a bug im dbmail once with wrong interpreted headers? Something with the lib used to en/decode those strings? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Annoying DONT DELETE THIS MESSAGE with previously used imap inbox folder
On Donnerstag 23 Juli 2009 Piotr Wadas wrote: When administrator migrates mbox folders to dbmail, in some of them is a imap message, common pop3/imap ignores it, but when migrated, this message appears on the list, and frightened users call support, to ask what is this and what shall I do with this. And yes, this is no joke. Any quick sql query to delete from database all messages for all users (envelopes and bodies) with particular SUBJECT header? or for particular user? I'd rather to delete the messages, than delete envelope and let dbmail-util do the rest (it has enough to do with really deleted messages). Probably Net::POP3 perl script would do the same, but removing from tables would be much simplier. select * from dbmail_messages where physmessage_id IN (select physmessage_id from dbmail_subjectfield where subjectfield like 'Annoying%DELETE THIS MESSAGE%'); Instead of select * simply write DELETE and those messages are gone. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Annoying DONT DELETE THIS MESSAGE with previously used imap inbox folder
On Donnerstag 23 Juli 2009 Jonathan Feally wrote: select * from dbmail_messages where physmessage_id IN (select physmessage_id from dbmail_subjectfield where subjectfield like 'Annoying%DELETE THIS MESSAGE%'); Instead of select * simply write DELETE and those messages are gone. mfg zmi I'm glad you responded first. I forgot about those views and was going to give a very nasty query back to do it. That should work in both 2.2.x and 2.3.x :-) Please anybody doing above query be reminded to change the Subject you are searching for - otherwise you delete all mails belonging to this thread ;-) My advise is to make the select first to see if it works, and only afterwards change it to delete. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] URGENT: Accidentally delete mail user with dbmail-users -d
On Montag 20 Juli 2009 Jonathan Feally wrote: Perhaps we should have a status column on dbmail_users like we have on messages. 0 = disabled 1 = enabled 2 = deleted 3 = purge ok Then on the dbmail-util run it will moved deleted to purge - then really delete the purge like we do with messages. +1 for the feature. We've adopted dbmail 2.2, and just have an active flag for the user, and your idea is even better. Can we have the same flag on aliases too? And please, if a user/alias is status=0 (disabled), dbmail should do as if it doesn't exist. No delivery/forwarding etc. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] [Dbmail] request for extension: domain and customers table
On Mittwoch 24 Juni 2009 Michael Monnerie wrote: I've extended dbmail since before we started, in order to have an extra domains and customers table. This has big advantages. Nobody to comment on this? Too complicated, too harsh, or maybe just a stupid idea of me? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] request for extension: domain and customers table
On Mittwoch 24 Juni 2009 Michael Monnerie wrote: I've extended dbmail since before we started, in order to have an extra domains and customers table. This has big advantages. Nobody to comment on this? Too complicated, too harsh, or maybe just a stupid idea of me? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] request for extension: domain and customers table
On Freitag 26 Juni 2009 Paul J Stevens wrote: Even we do very much the same in our main installation, we use LDAP to extend the user model, so the extra tables would be redundant for us. Also, I fail to understand how the additional tables effect dbmail internals. My business logic builds on ldap, and doesn't require any tweaking of the dbmail code or tables. Most of the delivery process is handled by postfix talking to ldap - no dbmail involved. All the lmtp server needs to be able to do is route a message (that already was verified as destined for a valid user) to the correct user's inbox (or sieve script). Can you post your LDAP schema? I guess I really should change and use that. I didn't until now, as I can't see the advantage of LDAP over dbmail (for us). But as you're using it that way, I'd like to change to the same model in order to have the same usage in dbmail-2.3, once we switch. And if others you the same scheme, it'l be easier to understand each other or workout features. I've recently expressed our will to provide our web interface. I'm in the process to do that, but it's tricky as it's heavily using our internals. So using a standard model should be less pain for the 2.3 adopted version. I hope you're able to post your LDAP schema (confidential?), and that I can adopt to use it. Then I could start trying out dbmail-2.3 with that schema already, so migration should be easier also. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] request for extension: domain and customers table
. For example, the per-domain and/or per-customer quotas. Those are currently not implemented in dbmail, but that shouldn't be too hard. We use is from the web interface for a simple display. The customer gets a call in case of heavy use :-) PS: we've also modified dbmail_aliases to include the domain_idnr, visible and active fields. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail-dev] Domain alias problem
I've just setup for the first time a domain forward with dbmail-users -x @gabl.gv.at -t @gabl-bruck.at and this made it correctly into the database. But when sending to f...@gabl.gv.at, LMTP delivers the message somewhere into dbmail, instead of back to postfix in order to deliver it to another server (gabl- bruck.at is not local on this system). Maybe this forward should be done at the postfix level already, but for management reasons I'd prefer dbmail does it, as I don't want to store such redirects in an external table. Trace 5 of lmtp attached. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[serverchild] serverchild.c,select_and_accept(+282): connection accepted Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Message:[serverchild] serverchild.c,PerformChildTask(+349): incoming connection from [127.0.0.1] by pid [16997] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[serverchild] serverchild.c,PerformChildTask(+374): client info init complete, calling client handler Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [LHLO mailsrv1.zmi.at] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+284): command issued :cmd [LHLO], value [mailsrv1.zmi.at] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 0 Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [MAIL FROM:r...@mailsrv1.zmi.at SIZE=424] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+284): command issued :cmd [MAIL], value [FROM:r...@mailsrv1.zmi.at SIZE=424] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 4 Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[misc] misc.c,find_bounded(+375): Found [r...@mailsrv1.zmi.at] of length [20] between '' and '' so next skip [26] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [RCPT TO:c.my...@gabl.gv.at] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+284): command issued :cmd [RCPT], value [TO:c.my...@gabl.gv.at] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 9 Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[misc] misc.c,find_bounded(+375): Found [c.my...@gabl.gv.at] of length [18] between '' and '' so next skip [22] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,dsnuser_init(+202): dsnuser initialized Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,dsnuser_resolve(+578): checking if [c.my...@gabl.gv.at] is a valid username, alias, or catchall. Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+222): checking user [c.my...@gabl.gv.at] in alias table Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+239): checks [0] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('c.my...@gabl.gv.at') AND lower(alias) lower(deliver_to)] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+266): user c.my...@gabl.gv.at not in aliases table Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,address_has_alias(+251): user [c.my...@gabl.gv.at] found total of [0] aliases Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('c.my...@gabl.gv.at')] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,address_is_username(+348): username not found [c.my...@gabl.gv.at] Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,address_is_domain_catchall(+370): user [c.my...@gabl.gv.at] checking for domain forwards. Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,address_is_domain_catchall(+382): domain [...@gabl.gv.at] checking for domain forwards Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+222): checking user [...@gabl.gv.at] in alias table Jun 23 18:37:32
Re: [Dbmail-dev] Domain alias problem
On Dienstag 23 Juni 2009 Paul J Stevens wrote: This is currently *not* supported. OK, so I need to do some MTA magic. I just sent a mail explaining our domains/customers extensions. For that reason, we never needed this magic. But now we have a special case: Customers having Exchange often find it hard to define alias domains. So in order to simplify that, we want to accept mails for @alias1.at, and resend the mail to @realdomain.at (which is on the customers Exchange server). I wanted to keep that in dbmail. We solved such aliasdomains within our system, but making the primarydomain on an external server was never done until now. Maybe I'll just setup new sql table as James suggested. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[Dbmail-dev] Error during backup?
On Mittwoch 24 Juni 2009 Mail Delivery System wrote: dbmail-dev@dbmail.org: Command time limit exceeded: /usr/sbin/dbmail-smtp unnamed Just got my mail back with above error. Maybe caused by backup making the system too slow? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[Dbmail-dev] request for extension: domain and customers table
. For example, the per-domain and/or per-customer quotas. Those are currently not implemented in dbmail, but that shouldn't be too hard. We use is from the web interface for a simple display. The customer gets a call in case of heavy use :-) PS: we've also modified dbmail_aliases to include the domain_idnr, visible and active fields. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] Domain alias problem
On Dienstag 23 Juni 2009 James Greig wrote: I Have to agree with Paul on this one - You're much better off doing this at the postfix level. Infact, we have a separate table within dbmail called dbmail_redirect which holds maps/forwarders it's unnecessary additional work for dbmail long term anyway. Thanks Greg, I created a table zmi_rewritedomains with simply oldname, newname and changed recipient_canonical_maps = pgsql:/etc/postfix/rewritedomains.sql, pgsql:/etc/postfix/recipients-rewrite.sql so that rewritedomains.sql looks like: query = SELECT '%u@' || newname FROM zmi_rewritedomains WHERE oldname = '%d' Quite simple, but I wanted to prevent a schema extension just for this. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[Dbmail] sieve vacation and aliases
Dear list, I have vacation via sieve scripts in the form of: require vacation; vacation :days 5 :subject Abwesenheitsnotiz Danke für Ihre Nachricht. Now we have a customer who have a lot of alias domains. They get mail to x...@dom1.at and that's place to x...@dom-real.at. I just found that sieve then does NOT reply to messages for that alias. In this discussion http://objectmix.com/imap/201068-sieve-vacation-addresses-wildcards.html they say it's a must to setup all alias addresses, is that true for dbmail also or is there a workaround? I must say that we rewrite alias domains in postfix already, so dbmail only sees x...@dom-real.at, not x...@dom1.at (where the people send mail to). Looks like sieve vacation doesn't see the envelope, but the content of the mail To: header. So I guess it won't work on BCC: received mails too? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] sieve vacation and aliases
On Dienstag 23 Juni 2009 Aaron Stone wrote: There is a search for is this message actually addressed to me? -- an important error case being mailing lists that get spammed by people's autoresponders. I can't think of a good workaround to offer you off the cuff. Thanks Aaron, I've made a quick patch to our web tool. When a user now makes a vacation entry, all alias domains of them are searched, and vacation gets a list of :addresses [...], where u...@dom1, u...@dom2, etc. is listed. That solves the problem. Luckily we have a patched dbmail where it's easy to find alias domains :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] New idea 2, log received messages by lmtpd
On Freitag 19 Juni 2009 Jorge Bastos wrote: That's why I think the best way is to make dbmail-lmtpd log this. What do you say? As long as we don't loose e-mails on the way from postfix to dbmail- lmtpd, there's not much urge to implement this IMHO. The only thing ATM that makes this interesting is to log the subject, as you can search for that. But I don't need that really, it's just something I miss a bit in the postfix log. What could also be nice is to log where the e-mail was originally sent to, because sometimes with aliases and BCC spammers can hide where they sent the mail to, and I can't see anymore the original e-mail they used. One more thing that would make it nice is I could do simple stats per domain, to see how many e-mail addresses are active, how many mails and how many bytes received... that's the most interesting thing I could get out of this - and that could make it worthy. After all, it wouldn't use a lot of space or hit performance, so a +1 from me. If developers have time of course ;-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] New idea 2, log received messages by lmtpd
On Freitag 19 Juni 2009 Jorge Bastos wrote: But, I think it's much more robust I never had problems with postfix logs. and secure (in the way that we get the right data) to this log's in dbmail-lmtpd than greping the postfix logs. I don't understand this. You mean, you got other data if postfix logs and into dbmail? And it's more easier for sure, I just don't know how to code it. Why easier? less /var/log/mail is quicker than login to db and select I guess? I'm with you on this feature, but your arguments are ... irreproducible for me. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] MAX_CHILDREN
On Dienstag 16 Juni 2009 Jon Duggan wrote: MAX_CHILDREN limit of 300 in pop3 Are you sure your box has enough RAM to keep 300 pop3 daemons around, plus the memory they need during I/O? Maybe it'd be better to install a 2nd box? If your machine is already swapping, more processes with actually lower your throughput. If the average pop3 user can receive with 100KB/s, your machine would need 30.000 KB/s (about 30Mb/s) Internet connection, and of course your database (same server? or another?) needs to be fast enough also. Sure you don't hit an I/O limit somewhere? Not want to offend, just help. But I don't know for the 300 limit in the code. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] MAX_CHILDREN
On Dienstag 16 Juni 2009 Jon Duggan wrote: The pop3 box is a dedicated quad core with 4gb of ram. And how much memory is used during peak hours? Just curious. Each dbmail-pop3 daemon here is shown as having an RSS footprint of 1-2MB, and a VSZ of 5-10MB. So with 300 users you'd have about 13MB per user available, which should be plenty. 600 users would thus mean ~6MB/user, I guess that would be the hard limit memory wise. What's your average CPU usage during peaks? I guess the pop3 box is not heavy loaded, but what about the db? We push at peak maybe 10mbit/s so no where near the 30mb/s you quote but bandwidth is not an issue (it's as good as unlimited). I forgot that with pop3 users usually remove mail from the server directly after receiving (we have lots of IMAP users). And with that many users, your connect rate may be high, but actual transfer rates not. Do you know about how many % of users choose to leave mail on server for X days? When we had flat-file storage with pop3d, that setting killed the server, as he had to read through the full file to see if there are new messages. You need only some users with a 100MB mailbox connecting every minute, and your server cries for help. But with dbmail, that is no issue anymore. :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] SQL errors in dbmail-mailbox.c (current git)
On Dienstag 09 Juni 2009 Aaron Stone wrote: One concern I remember was about the running configuration being different from the values in the database; basically, did you manually alter the database config values without bouncing the daemon? A dbmail-config utility that managed this table for you would be a great thing, IMHO, to centralize sanity checking and bouncing of daemons, etc. It'd be nice if you could still override those entries via the config file, e.g. when you want to do a quick test. A warning could be spilled that the db-config is overridden by the file-config variable. But maybe that creates confusion? A config util would certainly be helpful, especially as users could create a config dump to send with a request to the list. There should be a special -s (safe mode) dump that excludes hostnames and passwords so everybody can directly dump that to the list. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] SQL errors in dbmail-mailbox.c (current git)
On Montag 08 Juni 2009 Jonathan Feally wrote: I'm not sure if a per user script to move messages is the best approach. Probably just need to add it to dbmail-util to move them from the old structure to the new one. We don't even need to change the phymessage_id, just insert the mimeparts, then the partslist rows. Once those are there, the physmessage_id rows can be deleted from the messageblks. But how do you delete messageblks without their entire message? There are lots of constraints all over the place. You'd need to redefine those. OK, as there will be no more old inserts, it shouldn't really hurt to loose those. If per-user is not good - what would be better? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail-dev] SQL errors in dbmail-mailbox.c (current git)
On Sonntag 07 Juni 2009 Jonathan Feally wrote: Any DBA's out there want to chime in on using views vs. a query that does it all in one? Performance, Best Practice, Pros/Cons?? I would definitely go for a full migration: If I upgrade to 2.4, I want all the DB schema upgraded to 2.4, including the new single instance storage. Otherwise I'd stick do 2.2. The only reason to support the old format would be that 2.2 could be quickly upgraded to 2.4, and then only new messages get the new single instance storage. But then there should be a helper util to convert existing storage on a per-user basis, so I can run it over night/weekend per customer. Something like dbmail-upgrade-si username (si for single instance). That would convert all old style messages of that user. That util should also be able to display users still using one or more old style messages, in order to quickly see what's left to be done. If the new format has advantages - and it clearly should have - then everybody should be willing to convert anyway. Converting per-user helps upgrading a 500+ users mailserver in a convenient way, so you can do it within a week or two without any stress. But really everybody should be more or less forced to update the schema to remove the old cruft. Also, have a single upgrade script to upgrade any schema version to the newest would be very appreciated. So people who have an early 2.2 would also get the newset indices etc. A table version would be nice to have where a single dbmail-schema value is included. Would be good for support also. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] RELEASE: ripdefang-dbmail 0.01
On Freitag 29 Mai 2009 Paul J Stevens wrote: And I have in dbmail.conf: [LMTP] PORT = 24 NCHILDREN = 1 MINSPARECHILDREN = 1 MAXSPARECHILDREN = 2 MAXCHILDREN = 5 That is a *very* narrow pipe for lmtp. You better make damn sure your mta doesn't try to establish more than 1 lmtp connection. It's working on a server with 200 domains... But why 1 lmtp? It starts with 1 plus 1 spare, and goes up to 5 if necessary. And wouldn't postfix just retry later if all 5 are busy? No mail should be lost, right? Can dbmail- smtp loose messages? Only if the disks are full. Remember, dbmail-smtp (pipe) doesn't have a mechanism for telling the MTA what errors might have occurred during delivery. Would it write that to syslog or somewhere? I got about 80 errors on stderr which would explain that no e-mails are sent for that messages, but I'm missing a lot more. There's a -r option to dbmail-smtp, but that would only send me the 80 messages instead of on stderr, right? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] RELEASE: ripdefang-dbmail 0.01
On Donnerstag 28 Mai 2009 Michael Monnerie wrote: http://zmi.at/x/ripdefang-dbmail I just released this very first version of a un-defang tool. It's for everybody who has defanged spams and wants to get the original spam back into the mail system again. Question to Paul: I run above script with formail /tmp/spambox.mbox -s /usr/bin/ripdefang-dbmail and in the dbmail logs I see: May 28 08:19:45 mailsrv1.zmi.at dbmail/lmtpd[17408]: Error:[serverchild] serverchild.c,PerformChildTask(+385): maximum number of connections reached, stopping now And I have in dbmail.conf: [LMTP] PORT = 24 NCHILDREN = 1 MINSPARECHILDREN = 1 MAXSPARECHILDREN = 2 MAXCHILDREN = 5 How can I have the limit reached? 5 messages received by normal e-mail traffic and in the same time dbmail-smtp called? Or is dbmail-smtp running asynchronously? I'll rerun now on a 2nd mailserver, which has no mailtraffic. Still, I'd like to understand what causes the problem. Also, I'm feeding 7000 messages to that script, but only 3300 arrived the first time, and yesterday I reran that script and got 3900 messages. Still a lot missing, but why was there a difference at all? Can dbmail- smtp loose messages? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail-dev] SQL errors in dbmail-mailbox.c (current git)
On Donnerstag 28 Mai 2009 Maxim Podorov wrote: CREATE INDEX dbmail_headervalue_2 ON dbmail_headervalue USING btree (emailname); CREATE INDEX dbmail_headervalue_3 ON dbmail_headervalue USING btree (emailaddr); We've had this issue in 2.2.x already. We could make an index of substring(emailaddr,0,255), but then a) you can't search the whole string, so a search is incorrect b) every statement accessing that table would always need substrint(emailaddr,0,255) instead just emailaddr in order to use that index at all But I think I have a better idea: If we have a headervalue 255 chars, split it at a reasonable point. Example: From: verylongrecipientl...@myotherdomainsaremuchlargeralso.com, verylongrecipientli...@myotherdomainsaremuchlargeralso.com, verylongrecipientl...@myotherdomainsaremuchlargeralso.com, verylongrecipientl...@myotherdomainsaremuchlargeralso.com, Then just split that and INSERT two or more rows into dbmail_headervalue, each with the same fields just the emailaddr split at a comma 255 chars (MySQL just support 255 char wide indices, but maybe for PostgreSQL we could do the split at 2048 to have less entries). Like this, a) we can use the normal index b) a search will be fast and correct in result It needs a lot more brain power to program this once, but I think it's a huge benefit over the currect (2.2.x) situation. On Donnerstag 28 Mai 2009 Jonathan Feally wrote: From the error message below, it looks like we could use a size of 2048. MySQL can only index 255 chars :-( mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: [Dbmail] dbmail performance test
On Donnerstag 28 Mai 2009 Andreja Babic wrote: Database dbmail took 48G while cyrus mail storage had 30G for the same amount of mails. Boah, a very huge difference! I'd love to know what dbmail 2.3 would be in size. What I have got from tests is that search is much faster on dbmail and fetch is much faster on cyrus. For example on the mailbox which had 39661 unread mails search on cyrus imap took 20 seconds. The same operation on identical mailbox on dbmail took 12.7 seconds. Please also compare results of the searches. Dbmail has a bug somewhere (don't remember exactly, lookup archives, maybe of -dev), which will not necessarily find all messages. Please also do different kinds of searches (subject, From:, any header, any content, etc.). On the other side, fetching headers from all mails in inbox with fetch 1:* body[header] took on dbmail 20 seconds while the same operation on cyrus took 3 seconds. Please perform such accesses always 5 times in a row, and remember each time. Caches will change performance on both products, would be interesting to see how much. Are you also able to do this: *) simulate a single user signing in, read list of all mailboxes (should be 20 or so with subfolders), then for every mailbox get list of messages, read some messages. Close. Make other tests with other users, and deliver about 100 messages into that users mailboxes. Reconnect as that user again, get list of new mails. read some of them. close *) then rerun above test with 20 users in parallel. *) then again with 50 users in parallel. Maybe we can see which product scales better. Although we have no idea which hardware you test on. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] RELEASE: ripdefang-dbmail 0.01
http://zmi.at/x/ripdefang-dbmail I just released this very first version of a un-defang tool. It's for everybody who has defanged spams and wants to get the original spam back into the mail system again. Usage is very simple: Take a spam that is defanged by amavis, and resend or forward it to an alias address which calls this script. In my case I use dbmail ( http://dbmail.org/ ), where I created the following alias: # dbmail-users -x undef...@mydomain -t |/usr/bin/ripdefang-dbmail I then grep'ed a sample collection of 7074 mails, saved that to an mbox (if you want it: http://zmi.at/x/spambox.mbox.bz2) and ran a # formail -n 10 spambox.mbox -s /usr/bin/ripdefang but that got me only around 3343 mails, and ATM I don't know what the error is. But it's a start, and maybe others want to help improve the script. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode
On Montag 11 Mai 2009 Paul J Stevens wrote: Not to be nasty with the name, but I think #mobile is not as good a name as #noattach, as I might want #mobile mode also when I'm at an internet cafe, or other environment. ?? Most people are mobile when in a cafe. Also #mobile sounds better (no negative) to me. Ah, different understanding. Mobile here is more interpreted to mobile phone (or Handy, as we call them) or UMTS/GPRS connection, so an Internet cafe would not really be Mobile in the users head. Funny that you'd see no as negative, as in my head noattach gets a positive wow that will be fast to receive on my phone connex. But any way, no problem with any name. Just a thought. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode
On Dienstag 12 Mai 2009 Daniel Urstöger wrote: Usermapped ip/port or via a special 'virtual' username extension '#mobile' or '#noattach' or whatever is decided on. Those are the kinds of changes I am quite sure you are the only one capable of doing that, right? ;) Well, with a good towel, beer and peanuts, and a Vorgon spaceship you could travel to Alpha Centauri to get a three-brained hacker from there. He'd only take 2 years to study the code and do that stuff. On the other hand, there are for sure good hackers on this planet as well, but no one seems to have found his way to dbmail-dev. PS: Those not knowing Douglas Adams are forgiven. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode
On Dienstag 12 Mai 2009 Jorge Bastos wrote: Good to know that I'm forgiven :P Who was he? Oh Lord ;-) Wikipedia rules: http://en.wikipedia.org/wiki/Douglas_Adams mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode
On Montag 11 Mai 2009 Paul J Stevens wrote: Of course, you could have some mailclient use the virtual userid directly without using usermap, but with usermap all you'd have to explain to your mobile device users would be to use an other servername. But that servername needs another IP, right? I'd prefer not to waste an IP just for #mobile mode. Another port is sufficient. It should be possible to use it with another IP, though, as some clients might need that. Not to be nasty with the name, but I think #mobile is not as good a name as #noattach, as I might want #mobile mode also when I'm at an internet cafe, or other environment. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode
On Montag 11 Mai 2009 Josh Marshall wrote: Not sure on your setup, but if you have access to multiple IP addresses, you can put a rule on the firewall to forward port 110 to e.g. 111 on the internal server. Otherwise default to internal clients connect to port 110 and external clients connect to port 111 via a portforward on the firewall. I prefer to KISS, so doing nasty firewall NAT is something I do as a last resort, as it's something that keeps the junior admins bang their heads ;-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode (was: Dbmail Hybrid)
On Donnerstag 07 Mai 2009 Paul J Stevens wrote: The dbmail-httpd would then, after authentication/authorization return the attachment involved with the correct mime headers for the relevant content, i.e. the message, so the client knows how to save the file. Could that be done in a virtual mode? I mean: a) the clients logs in with a special form of username, lets say instead cli...@domain he uses cli...@domain#noattach. This lets dbmail-(pop| imap) switch to URL mode instead. For POP this only works if messages are left on the server of course. (Maybe just forbid to delete mails for POP when in #noattach mode). b) Client gets, instead attachment, an URL like http://dbmailwebserver/virtualurl. Whenever this URL gets called, a script is executed checking login, and if this passes start the download directly from the dbmail database, without needing to copy the file to the filesystem. Maybe that needs to be done, but only as a temporary file that's deleted after the download. What I'd not want is to copy all attach files where an URL is generated to be copied to the filesystem, just in case someone wants to download it. Sounds very nice, all mobile users would love that! mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Offtopic, Question about FTTH
On Dienstag 05 Mai 2009 Jorge Bastos wrote: Who has FTTH? In Austria: About 0%. Lots of cable TV+Internet, giving speeds 20Mb/2Mb up/down like for me :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Dbmail Hybrid
On Montag 04 Mai 2009 Darvin Denmian wrote: DBmail stores Message and the attachments of messages are stored outside Mysql DB. Use cyrus as your mailserver, then everything is a file. A mixture of SQL+file combines the disadvantages of both, not the advantages. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] /tmp full
On Donnerstag 23 April 2009 Guntis Bumburs wrote: MAXCONNECTS = 1 what is the benefit to have it so hight? what would happen if i change it to Paul's suggested 100? A single thread will accept MAXCONNECT connections and then stop, and a fresh one startet. Like this, all memory/disk reservations by that thread will be freed. It has no impact except on very high loaded servers there could be a small performance drop because of permanent thread restarting. No need to worry. It will help to lower it. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] why...?
On Donnerstag 09 April 2009 Josh Marshall wrote: Since dbmail-util tries to recreate date field before the other, missing, field, and fails because the unique restraint stops it, it stops trying to recreate the other header fields. So it never gets to fix the real problem. I'll have a look into a cleanup of the indices, and Paul will fix the rest. I'm just on holidays this week, so it needs to wait a bit. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] System scalability
On Mittwoch 08 April 2009 David Nillesen wrote: Our mailstore is currently around 32,000 users with around 8 million emails on disk at the moment, occupying about 350GB of mail. How well does DBmail scale to these numbers on Postgres? It runs, of course you need competent hardware. I'm working on index optimization for dbmail-2.2, cleaning some indices out or lightening them up. Patches to follow, should help a lot with installations of that size. Is there a solution for user self administration of vacation/autoreply messages? Since we have a large number of accounts self administration for the majority of user issues is important. I have found a few administration webapps for admins, but nothing for users as far as I can see. We have developed a complete toolset which I can offer you for free. It's php based, and you can create customers/domains/users/aliases, and each user can have the right to administer his password/vacation with start/stop dates. I was already planning to release it to GPL as a sf.net project. If others are interested too, I'll do that sooner than later. We use LDAP for aliases, authentication and authorization. Is there any way to tie this to DBmail? My main issue would be with aliases, everything else we can work round with our IAM system executing SQL into Postgres to enable users. Our tool currently directly connects to the db, so some rework would be needed. Shouldn't be a big pain. If you would like to know more about our site and configuration, let me know. If you're interested, let me know per PM. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] OT: DBMail Administrator (DBMA) Performance Fix
On Freitag 03 April 2009 Wallace Tan wrote: SELECT COUNT(*) FROM dbmail_messageblks; 1 row in set (2 min 18.09 sec) After optimizing the SQL, it took 0.27 seconds. SELECT COUNT(*) FROM dbmail_messageblks use index(physmessage_id_index); The question is: Why is MySQL so stupid not to use the index? That should be done automatically by the DBMS, that's its job. I would oppose against changing the query just because MySQL has a bug. Maybe you use a version that's known to be instable? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] OT: DBMail Administrator (DBMA) Performance Fix
On Freitag 03 April 2009 Wallace Tan wrote: select count(1) from t1; That would have been my next question. I've spoken once to Paul, because dbmail uses lots of count(*), but PostgreSQL optimizes this out. Now it seems MySQL would have a performance boost using count(1). Could you please try: 1) first, SELECT COUNT(1) FROM dbmail_messageblks; and afterwards 2) SELECT COUNT(*) FROM dbmail_messageblks; The order is important: After the first select(), the table will be cached, so the 2nd query will be faster. That, BTW, is part of the explanation why your 2nd query was much faster than the 1st. Still, count(1) should be faster than count(*) I would expect from the thread you posted. I do not have a MySQL db with enough data to test around. We're using PostgreSQL because things like that happen to exist in MySQL since years, and I don't need a DBMS where I have to think for it. I wonder why the devs don't manage to work around those problems. But no flames please, everybody should use what they prefer. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail