Re: [Dbmail] Repeated Folder Names
I started seeing this regression after upgrading to 2.2.11 from 2.2.10 yes. 2.2.10 has other bugs which are solved in 2.2.11. Marc -- Dipl.-Ing. Marc Dirix Electronics Design Bouwensstraat 24 6369BG Simpelveld Tel.: +31(45)7440744 E-Mail: m...@electronics-design.nl Internet: www.electronics-design.nl ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Repeated Folder Names
I think 2.2.10 does not seem to suffer from it. As I tried to downgrade earlier I got into problems with strtoul. Regards, Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Problem starting dbmail-timsieved
Attached the trace.txt I also tried some output tests: If in config.c I put printf("%s\n",port_string); in line 263, it writes "5434" to the command line before the error. Then second try, line 262, I write printf("%d\n",strtoul(port_string, NULL, 10)); which also writes "5434" to the command line, so the parsing by strtoul does not seem to be the problem. Now, why does errno get filled with some value, while strtoul does the job as expected? If I set errno=0; in line 260 of config.c, dbmail-timesieved starts as expected. I'm not sure this is the right fix in the right place, as I don't understand why errno is not redefined in strtoul. Please confirm this. Regards, Marc execve("/usr/sbin/dbmail-timsieved", ["/usr/sbin/dbmail-timsieved"], [/* 15 vars */]) = 0 brk(0) = 0x804d000 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) mmap2(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f29000 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/i686/sse2/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/i686/sse2/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/i686/sse2/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/i686/sse2", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/i686/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/i686/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/i686/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/i686", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/sse2/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/sse2/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/sse2/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/sse2", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/tls/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/tls", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/i686/sse2/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/i686/sse2/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/i686/sse2/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/i686/sse2", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/i686/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/i686/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/i686/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/i686", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/sse2/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/sse2/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/sse2/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/sse2", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail/cmov", 0xbfd71b80) = -1 ENOENT (No such file or directory) open("/usr/lib/dbmail/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/dbmail", {st_mode=S_IFDIR|0755, st_size=1024, ...}) = 0 open("/etc/ld.so.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=41423, ...}) = 0 mmap2(NULL, 41423, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7f1e000 close(3)= 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/libcrypt.so.1", O_RDONLY)= 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 \7\0\0004\0\0\0008"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=38296, ...}) = 0 mmap2(NULL, 201052, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7eec000 mmap2(0xb7ef5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x8) = 0xb7ef5000 mmap2(0xb7ef7000, 155996, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7ef7000 close(3)= 0 open("/usr/lib/dbmail/libgmodule-2.0.so.0", O_RDONLY) = -1 ENOENT (No such file or
Re: [Dbmail] Problem starting dbmail-timsieved
Are you perhaps then starting the wrong daemon, or one looking at the wrong dbmail.conf? Try: strace -o /tmp/trace.txt -ff /usr/sbin/dbmail-timsieved grep dbmail.conf /tmp/trace.txt or something similar. I already tried that. There is only one daemon in the path. dbmail-timsieved -V gives 2.2.11 Also the right configfile /etc/dbmail/dbmail.conf Furthermore, as of now also dbmail-pop3d and dbmail-lmtp are not working anymore (because I restarted them). As a short-term sollution I have used rinetd to map the standard postgresql port to the one I use, and start the daemons without the sqlport setting which seems to be running ok. Regards, Marc No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.76/2183 - Release Date: 06/17/09 05:53:00 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Problem starting dbmail-timsieved
This means the value specified for sqlport cannot be parsed into a 'long long unsigned int'. Something *must* have changed on your system. I did do an debian upgrade, and reinstalled dbmail from the nfg server. (first tried a downgrade to a manual compiled 2.2.10 which introduced the problem first). How can my system not know a long long unsigned int? And is that not an exceptionally large number for a port-number? Regards, Marc Dirix No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.76/2183 - Release Date: 06/17/09 05:53:00 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Problem starting dbmail-timsieved
Paul J Stevens schreef: Marc Dirix wrote: Jun 18 12:39:37 gamma dbmail-timsieved[5934]: FATAL:[config] config.c,GetDBParams(+263): wrong value for sqlport in config file This means the value specified for sqlport cannot be parsed into a 'long long unsigned int'. Something *must* have changed on your system. Additionally, In dbmail.conf I have: sqlport = 5434 Regards, Marc No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.76/2183 - Release Date: 06/17/09 05:53:00 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Problem starting dbmail-timsieved
Hi Paul, I am a bit out of it, this is a level TRACE_STDERR of 5, is that not the highest value? r...@gamma:/var/src/dbmail# dbmail-timsieved Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+262): server will create [2] children Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+275): children will make max. [100] connections Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+288): timeout [300] seconds Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+293): no value for TIMEOUT in config file Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+300): login_timeout [60] seconds Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+305): no value for SOCKET in config file Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+308): socket [] Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+320): binding to PORT [2000] Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+341): binding to IP [127.0.0.1] Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+348): no value for BACKLOG in config file. Using default value [16] Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+362): not resolving client IP Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+371): no value for SIEVE_BEFORE_SMTP in config file Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+376): Disabling SIEVE-before-SMTP Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+388): effective user shall be [dbmail] Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+400): effective group shall be [dbmail] Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+412): will maintain minimum of [2] spare children in reserve Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+424): will maintain maximum of [4] spare children in reserve Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+436): will allow maximum of [10] children Jun 18 12:39:37 gamma dbmail-timsieved[5934]: FATAL:[config] config.c,GetDBParams(+263): wrong value for sqlport in config file Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] Problem starting dbmail-timsieved
Hi, Although I did not change my config file, now dbmail-timsieved does not start anymore. Version: 2.2.11 It says: Jun 18 11:40:57 gamma dbmail-timsieved[10118]: FATAL:[config] config.c,GetDBParams(+263): wrong value for sqlport in config file failed failed! The database is on a non-default port, and I'm using postgres. Strangely enough dbmail-imapd and dbmail-pop3d and dbmail-smtp start normal. Any thoughts? Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] LIST command in 2.2.11
Hi, Is there any chance the LIST command in 2.2.11 is going te be fixed? Or do you recommend downgrade to 2.2.10 / upgrade to 2.3? Best regards, Marc Dirix -- Dipl.-Ing. Marc Dirix Electronics Design Bouwensstraat 24 6369BG Simpelveld Tel.: +31(45)7440744 E-Mail: m...@electronics-design.nl Internet: www.electronics-design.nl ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] #noattach mode
http://lmgtfy.com/?q=douglas+adams Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] mysterious from-address
> Oops. The README clearly states: > > Rewrite "user" to "u...@$myorigin" > > This feature is controlled by the boolean append_at_myorigin > parameter (default: yes). You should never turn off this feature, > because a lot of Postfix components expect that all addresses have the > form "u...@domain". > > > > > I have set it to "no" because of this problem (to see if it would make a difference, which it doesn't). It also seems not to be related, because $myorigin is not "gamma.electronics-design.nl" which is the string which is add in the from header. Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] mysterious from-address
> dbmail doesn't do this, afaict. The only set_header call we do during > normal delivery is for 'Return-Path'. What do the postfix logs tell you? > > Nothing intelligible, the rcpt-to address (in the message envelope) is correct. I can't find an option for postfix where it enables / disables it to change the message from header? I have in main.cf: append_dot_mydomain = no append_at_myorigin = no Regards, Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] mysterious from-address
> Marc > I'm not convinced that it is dbmail or gmime adding a host part. Do you > have an > example of the full message headers? > John > Yes, I'm however pretty sure postfix does not change the from address. I have furthermore spamassassin and clamavsmtp running. But online the ones with a messed-up gmime decoding end up with an added @gamma.electronics-design.nl The header is taken from the message-view in mutt. Regards, Marc >From j...@sending.com.ar Wed May 6 14:50:13 2009 Received: from gamma.electronics-design.nl by netserver.l.theworksevents.com with POP3 (fetchmail-6.3.9-rc2) for (single-drop); Wed, 06 May 2009 14:50:13 +0200 (CEST) Received: from gamma.electronics-design.nl (unknown [172.30.100.2]) by gamma.electronics-design.nl (Postfix) with ESMTP id 00C687E51F for ; Wed, 6 May 2009 14:50:08 +0200 (CEST) Received: by gamma.electronics-design.nl (Postfix, from userid 65534) id D801E7E519; Wed, 6 May 2009 14:50:08 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on gamma.electronics-design.nl X-Spam-Level: X-Spam-Status: No, score=-1.2 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, SUBJ_ALL_CAPS autolearn=no version=3.2.5 Received: from solucionx.com (mail.solucionx.com [190.7.59.131]) by gamma.electronics-design.nl (Postfix) with ESMTPS id 136CA7E519 for ; Wed, 6 May 2009 14:49:51 +0200 (CEST) Received: (qmail 23350 invoked from network); 6 May 2009 12:49:32 - Received: by simscan 1.4.0 ppid: 23340, pid: 23348, t: 0.3945s scanners: regex: 1.4.0 Received: from unknown (HELO joselaptop) (j...@sending.com@190.220.41.57) by mail.solucionx.com with SMTP; 6 May 2009 12:49:31 - From: =?iso-8859-1?q?jos=e9_m._joa...@gamma.electronics-design.nl To: "'Linda Neven-Wenmaekers (The Works Events)'" References: <20090429130253.02412280...@beta.electronics-design.nl> In-Reply-To: <20090429130253.02412280...@beta.electronics-design.nl> Subject: INCALFER ARGENTINA - LCD RENT Date: Wed, 6 May 2009 09:49:31 -0300 Message-ID: X-Mailer: Microsoft Office Outlook 12.0 thread-index: AcnIytwhYz8L2eG9QkyOcSdZGskRcgFfh6NA Disposition-Notification-To: =?iso-8859-1?Q?Jos=E9_M._Joao?= X-Virus-Scanned: ClamAV using ClamSMTP Return-Path: j...@sending.com.ar MIME-Version: 1.0 Content-Type: multipart/related; boundary="=_NextPart_000_00A7_01C9CE2F.F52335C0" Content-Language: es-ar Status: RO X-Status: A Content-Length: 12026 Lines: 439 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] mysterious from-address
My Point was not the part about not being able to decode, but the part where dbmail (or gmime) adds an @host.domain after the non-decodable address. This confuses things. -- Groet, Marc Dirix On Thu, May 07, 2009 at 10:44:42PM +0200, Paul J Stevens wrote: > John Fawcett wrote: > > It's likely a bug of the sending client (probably a webmail service). > > Shouldn't the from header contain only ascii encoding? > > That's not the point. Even if you are correct (I would assume rfc2047 > would apply to From_ headers as well), we'd like dbmail to gracefully > degrade. > > > John > > > > Aaron Stone wrote: > >> I've noticed this, too. It's not an added header, it's a mis-decoded > >> header. I suspect a GMime bug; perhaps Paul has identified which versions > >> of GMime are buggy in this way? > > Stay current on gmime-2.2. That is the only version I really test. Gmime > is a fast moving target! 2.4 is api/abi incompatible, and 2.6 (already > being worked on) will break that again. Jeff has done some fixes in this > area, and dbmail has it's own share of work-around faulty encodings on > top of that. Running the unit-tests (./configure --with-check; make > check) might help in exposing the trouble spots. > > > > -- > > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlandshttp://www.nfg.nl > ___ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] mysterious from-address
Although I could live with mis-encoding. The addition of @host.domain is somewhat annoying as it makes outlook think the email address is valid, and does not complain to the user. Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] mysterious from-address
Hi I'm on 2.2.11. Often some customers receive emails with incorrect (or strangely encoded) From headers. This From header then gets mangled at some point between reception and delivery. The newly formed From header has been mangled, and @host.domain of the mailserver has been added. See here a resulting header: =?iso-8859-1?q?jos=e9_m._joa...@gamma.electronics-design.nl If now the customers replies to this, obviously the email is not delivered to the original sender. Is it possible dbmail at some point adds the header? Er should I be looking through spamassassin or postfix? Regards, Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] bugs in 2.2.11??
Hi, I recently went from 2.2.10 to 2.2.11. Current regressions are that the LIST commands outputs folders more than once? See ngrep output below. And furthermore, it sends for every root folder a "\noselect" regardles of the parameter in the dbmail_mailboxes folder. This makes it impossible to store mail in a parent folder in thunderbird! Regards, Marc ## T 90.145.42.10:34493 -> 212.125.143.250:143 [AP] 176 list "" "%". # T 212.125.143.250:143 -> 90.145.42.10:34493 [AP] * LIST (\hasnochildren) "/" "Drafts". ## T 212.125.143.250:143 -> 90.145.42.10:34493 [AP] * LIST (\hasnochildren) "/" "INBOX". * LIST (\hasnochildren) "/" "Notes". * LIST (\hasnochildren) "/" "Sent". * LIST (\hasnochildren) "/" "Sent Messages". ## T 212.125.143.250:143 -> 90.145.42.10:34493 [AP] * LIST (\noselect \haschildren) "/" "bedrijf". * LIST (\noselect \haschildren) "/" "bedrijf". * LIST (\noselect \haschildren) "/" "bedrijf". * LIST (\noselect \haschildren) "/" "bedrijf". * LIST (\noselect \haschildren) "/" "bedrijf". * LIST (\noselect \haschildren) "/" "bedrijf". * LIST (\noselect \haschildren) "/" "bedrijf". ## T 212.125.143.250:143 -> 90.145.42.10:34493 [AP] * LIST (\noselect \haschildren) "/" "prive". * LIST (\noselect \haschildren) "/" "prive". * LIST (\noselect \haschildren) "/" "prive". * LIST (\noselect \haschildren) "/" "prive". * LIST (\noselect \haschildren) "/" "prive". * LIST (\noselect \haschildren) "/" "prive". * LIST (\noselect \haschildren) "/" "prive". ## -- Groet, Marc Dirix ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] sieve reject
Hi, I have currently a setup where I want to use the sieve reject feature. Have set it up as: elsif not header :contains "From" "u...@domain.nl" { reject "This messages has been rejected. Please contact marc for further assistance."; stop; } However the notice that is postfix sends back to the sender is: Permanent Failure Address Status Bad destination mailbox address (in reply to end of DATA command)) Is this normal? Should the reject not have been send? -- Marc ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Segfault in the git
Joan Moreau schreef: I will provide the updated file in the evening, You will have to transform it into a patch as I do not know how to make it If you're using git, try : git diff Just email the output. Regards, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] correctnes of bodystructure
Now, in the first example, the message clearly is not a multipart message. How is it that extension data still is being returned? Because the rfc says we must do so: Ah. Sorry, I was to quick to the gun. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] correctnes of bodystructure
Hi, If I let a client fetch the bodystructure of messages I get the following 2 examples: BODYSTRUCTURE ("text" "plain" ("charset" "us-ascii") NIL NIL "7BIT" 125 12 NIL ("inline" NIL) NIL NIL)) BODYSTRUCTURE (("text" "plain" ("charset" "us-ascii") NIL NIL "7bit" 324 14 NIL NIL NIL NIL)("text" "html" ("charset" "us-ascii") NIL NIL "quoted-printable" 1601 36 NIL NIL NIL NIL) "alternative" ("boundary" "=_NextPart_000_0008_01C98611.CBB36EF0") NIL NIL NIL)) RFC3501 it says that Extension data follows the multipart subtype. Extension data is never returned with the BODY fetch, but can be returned with a BODYSTRUCTURE fetch. Extension data, if present, MUST be in the defined order. Now, in the first example, the message clearly is not a multipart message. How is it that extension data still is being returned? Referring to " NIL ("inline" NIL) NIL NIL". The same is for the sub-parts of the second multipart message Referring to " NIL NIL NIL NILu" after 14 and after 36. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] IMAP Protocol
Hello, Again a bit off topic. Does anyone know of a good document source on how the imap "BODYSTRUCTURE" is build? I'm looking for a definition of the meaning and ordering of the values inside. Regards, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Performance, IMAP backend, etc.
> I've tried kmail, Outlook, and Evolution, and they all cache the damn > messages (or, at least, the headers) locally. I want the client to > leverage dbmail, here, and it's irksome to have the client think it > knows better. Have you tried Mutt? > > So that, in a nutsehll, is the answer. ;-) Make more sense now? The caching is intentional. IMAP RFC3501 (as I understand it) encourages caching of messages localy. That's what UIDVALIDITY and UID are for. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] POP3 retrieve and deliver (offtopic)
On Sun, Jan 18, 2009 at 04:18:53PM -, Jorge Bastos wrote: >I'm sorry, > >I'm looking for a tool that is capable of get the email from the origin >POP3 server, deliver it to the destination POP3 server, and delete the >retrieved messages from the origin after deliver them on the destination. There are numerous tools. fetchmail, retchmail or the one I wrote and use http://www.dirix.nu/popcollector.html These tools do pop3->smtp. mine is especially written to have better spamchecking in the smtp server (as fetchmail is also capable of). Regards, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] [Slightly OffTopic] Backing up dbmail ( error 2013 )
This is not the same. > 1) flush all pending writes and lock the database as read-only Postgres does not flush pending writes, and also does not set the database read-only. > 2) force a binlog rotation so you know exactly where the snapshot was taken > 3) make a LV snapshot (takes care of all sync()s at fs level) > 4) unlock everything (the lock persists while the snapshto is created, > which lasts about half a second) > > Then I go ahead and slowly backup/compress/whatever I want the database > files from the snapshot volume > > > When shit hits the fan: > === > > 1) Stop the database > 2) Unpack the mysql data directory saved from the latest snapshot (since > the snapshot was made within a read-lock, the database is guaranteed to > be consistent) With PITR you can recover to *any* point in time. Not just your snapshot time. It is completely different. PITR is a query log which starts from your snapshot onward. So sunday snapshot day (without locking or read-only) then continueing with query logs up to crash day. However, I would not even think about using it with dbmail. Because it slows down your database. For every INSERT and UPDATE query the data has to be saved twice. Once in the database and once in the log. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] imap protocol
>> I've found mutt to just emptying cache between mailbox changes and >> re-fetching everything >> headers and body. > > Down boy! sit! > > Perhaps mutt is put-off by 2.2.x incorrect expunge responses in some > circumstances, and tries to work-around it like this. Sorry I have not explained the above right. Mutt re-fetches everything when the client changes from selected mailbox back and forth. Not when the selected mailbox changes. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] imap protocol
Maybe not quite on topic. What is a clean way to check for deleted (expunged) message between mailbox checks inside a session. i.e. Client A selects to mailbox INBOX and finds 22 messages there, and caches them. Client A selects to a different mailbox lets say DBMAL Client B selects to mailbox INBOX and deletes 4 messages Client A selects mailbox INBOX and per EXISTS is informed there are 19 messages, 1 new. Now what is the clean way to find out which messages should be deleted from cache? I'm thinking doing a FETCH on UID would do the trick. But what if an "EXPUNGE" is send between FETCHES? Is there an other better approach? I've found mutt to just emptying cache between mailbox changes and re- fetching everything headers and body. Regards, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] IMAP folders
>altough I understand very well that this is not a dbmail issue and I also >know why it's happening, I was wondering is there's something dbmail could >implement to avoid the common problem of having duplicated folders when >using different mail client. This is a well known issue, and has been a feature request for some time. Noone implemented it though. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] storage issue
> well this is not clear in the doc, does the dbmail store the body, > from, to part of the mail as such? after sending the mail i could able > to see flags in the dbmail_mailboxes. I couldn't able to see the mail > body or the any of the header stored. What are you trying to do? verify that your email actually is in the database? You can find emails in dbmail_messageblks by combining the right message parts. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] storage issue
Hi, You could start by reading sendmail/lmtp instructions from the dbmail.org wiki page and take it from there. http://www.dbmail.org/dokuwiki/doku.php?id=sendmail_howto Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] imap login fails
> evolution on ubuntu 7.10, imap login fails. > > any ideas as to why? We need more information, can you provide level5 logs of the dbmail installation? ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] what table and field hold the email message body?
> Is the message body information isolated anywhere within the schema, or do I > have to parse it > manually? IIRC the dbmail_messageblks table contains the full message split into parts. You need to combine these parts to get the full message back. Ordering of the blocks is done on the primary key. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Db growing size
> I belive thats something importante to investigate for Paul, because the > differences in the size are huge. > I think you should start paying paul for one-on-one support ;). ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Db growing size
On Sat, Aug 02, 2008 at 04:37:38PM +0100, Jorge Bastos wrote: > Curmail_size is intended to be the current mail in use that being true, I would not use it in the way you are and make assumptions about it. Certainly not while you are using the development branch. Still interesting though, the size of both the mimeparts and messageblocks table. Then, and only then it is possible to make assumptions about where there is a difference. curmail_size <=> actual size <=> maintainance. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Db growing size
> Yes but i have quota for all users, unless me. > So counting the maxmail_size for everyone, the db only could grow up to that > value of 22GB, not 65GB > This is not true, if you don't do maintainance. (database, not dbmail) ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Db growing size
> > In 2.3x version, with the new database design, the size that the > > database has, it???s not the real size. > > > > I have now 52GB of DB Size, but comparing with the email that is stored > > in this very moment: > > > > ???SELECT round((sum(curmail_size)/1024)/1024,2) FROM dbmail_users ;??? Why do you think "curmail_size" is the /real/ size? Mayb a regression in 2.3 does not calculated the field the right way? First thing to investigate is the actual mail size in the tables. And as Paul mentioned before, in 2.3 this is not only dbmail_messageblks anymore. The bulk goes in the mimepart tables now. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Problems with flags and status
> > - a way to disable it. > > /etc/dbmail.conf: > LAST_ACCESS=[YES|NO] There is no need to have dbmail do this. Creating a deffered trigger in the database should be enough, and wouldn't loose that much performance. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Headers reformated
Please provide more information! Database backend, database locale, dbmail config. Encoding problems in 2.2.9 should have been ironed out. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Snappermail problem
Maybe you can post your patch on this list. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] automatic filtering
> The problem with this approach is that sieve scripts are per user only. So > you'd have to create a script for each user. One could make a simple > bash/perl/whatever script that inserts and updates all the users' scripts, > but you won't be able to offer the custom sieve functionality to them. This being true, I tend to create a basic sieve script per user, with webinterface for vacation message etc. Then allow users to create custom scripts if they want, but only if they explicitly ask for it and take notice they need to filter spam themselfs. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Local Recipient Verification
> If I set mytestdomain in mydestination, I can deliver to it. Otherwise I > just get relaying denied. Is there a reasonably sane way to have > mydestination set so that the list comes from the dbmail mysql backend > while still including local host names ($myhostname, localhost) for > /var/spool/mail delivery? The config allows to have multiple parameters after eachother. So you can concatenate $myhostname and a database query. > > However, I also have to set, in main.cf > local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf > > where sql-recipients.cf is the mysql access config file as per the dbmail > wiki. This works fine for dbmail users, but it also causes local > recipients to get rejected (e.g. [EMAIL PROTECTED]). Is there a way to > additionally add local users to the allowed map? Also here, you can add a second hash containing local users. However, IMHO there is no need for local users, just put them in DBMail also. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Local Recipient Verification
> Seems people use dbmail differently than we do. We have a "dbmail mail > server", which *only* does > - run dbmail-* daemons to connect to the db > - have postfix for incoming e-mail from our mailgate (which does spam We have a seperate dbmail server for our main setup. Some smaller setups contain both. There is however no reason for it to contain yet another postfix / sendmail install to deliver mail. dbmail-lmtp is all you need at the dbmail server end. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Local Recipient Verification
On Mon, Apr 28, 2008 at 06:51:57PM -0400, Colin Wetherbee wrote: > Marc Dirix wrote: >> Your best way, is to get over the sendmail advantages, and start using >> postfix. > > It's been about eight years since I set up my first mail server, and > I've never heard anyone say sendmail has advantages over postfix. I > have used postfix for every mail server in those eight years. It is not going to cause a flame-war I hope. Sendmails main advantage, is the support for milters. Although postfix has some milter support, it is not close to sendmail's implementation, making milters I used to use not-working. The only drop-in replacement are postfix's after-queue filters, which has the disadvantage of having already accepted malicient mails. Also, I think configuration for some more advanced setups are a hassle in postfix, having to have a main.cf for options, and seperate master.cf containing option for different connections (I have multiple smtp setups one 1 server). Maybe, when sendmailX is done I'll switch back. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Local Recipient Verification
> The problem with this is that sendmail will accept all mail restined for > the local domains, regardless of whether the users exist. The > undeliverables will the either backscatter or sit in the queue as > undeliverable until they eventually bounce into the local postmaster's > mailbox. > > Is there a workaround for this? Is there a way to make the MTA check that > the recipient exists before accepting the mail? With sendmail? No! There is a sendmail-sql plugin somewhere, but it inconvienient. Your best way, is to get over the sendmail advantages, and start using postfix. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Retaining deleted messages
> Since I'm doing this on my own, don't expect a final 2.4 release before > october, unless a sponsorship deal comes along... Maybe as a side/note suggestion. If redoing the message delete funcions, it maybe is possible to replace the integer "status" with a date field. This way, the deleting of deleted message can be a configured expire-time option in dbmail.conf, instead of the the number of dbmail-util runs. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] sql error.
> where is the log from the query that is actually causing the aborted > transaction? I'll send you the part completely privately, to not disclose any mailaddresses. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] sql error.
Any thoughts about this? On Tue, Apr 22, 2008 at 04:41:41PM +0200, Marc Dirix wrote: > Hi, > > Today I found this error in my log: > (dbmail 2.2.10). > > [ERROR: index row size 4504 exceeds btree maximum, 2712 HINT: Values > larger than 1/3 of a buffer page cannot be indexed. Consider a function > index of an MD5 hash of the value, or use full text indexing. ] > Apr 22 11:55:37 gamma dbmail/lmtpd[7004]: Error:[message] > dbmail-message.c,_header_cache(+1038): insert headervalue failed > Apr 22 11:55:37 gamma dbmail/lmtpd[7004]: Error:[sql] > dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_tofield > (physmessage_id, toname, toaddr) VALUES > (145324,'Bauws-Dettmann','[EMAIL PROTECTED]')] : [ERROR: > current transaction is aborted, commands ignored until end of > transaction block ] > > The message seems to have a lott of emailaddressess in the "TO" field. > I think dbmail should check size of the field before inserting? > > > Marc > > ___ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Login via E-Mail-Adress
> I wonder if it is possible to let the users log in via pop and imap by > sending their email-adress as username. Unfortunately I couldn't find > something in the docs :( Username and aliases are seperated, because one user can have multiple aliases. If you want to force this you can either 1) Set userid = emailaddress 2) Play with dbmail_usermap / acls tables. However, this will be a maintainance hassle. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] sql error.
Hi, Today I found this error in my log: (dbmail 2.2.10). [ERROR: index row size 4504 exceeds btree maximum, 2712 HINT: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing. ] Apr 22 11:55:37 gamma dbmail/lmtpd[7004]: Error:[message] dbmail-message.c,_header_cache(+1038): insert headervalue failed Apr 22 11:55:37 gamma dbmail/lmtpd[7004]: Error:[sql] dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (145324,'Bauws-Dettmann','[EMAIL PROTECTED]')] : [ERROR: current transaction is aborted, commands ignored until end of transaction block ] The message seems to have a lott of emailaddressess in the "TO" field. I think dbmail should check size of the field before inserting? Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Dummy pop3-server
No! Apart from my dislike of perl syntax (pike resembles C), I have the same issue about no use to have another interpreter, as Roxen Webserver already is running on pike. You are however free to use the source and rewrite it in perl ;) Marc On Wed, Apr 16, 2008 at 02:29:04PM +0200, Simon Lange wrote: > Good Idea, but i would prefer perl. No need for installing another > interpreter if perl is already aboard. > You may have a perl version? > > Simon > > > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag > von Marc Dirix > Gesendet: Mittwoch, 16. April 2008 13:41 > An: DBMail mailinglist > Betreff: [Dbmail] Dummy pop3-server > > As someone already requested, I also needed a dummy pop3 server > for maintainance (database upgrade). > > I've created a small pike script, that does just that. > For those interested it can be found here: > > http://www.dirix.nu/dummypop.pike.gz > > You need to have a running pike interpreter installed > > It takes optionally 2 parameters: > > -p bind port default 110 > -i bind ip, default all IP's. > > The script does not check authentication, and is not able to do apop. > I had however no complaints during my maintainance round. > > > Marc > ___ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] Dummy pop3-server
As someone already requested, I also needed a dummy pop3 server for maintainance (database upgrade). I've created a small pike script, that does just that. For those interested it can be found here: http://www.dirix.nu/dummypop.pike.gz You need to have a running pike interpreter installed It takes optionally 2 parameters: -p bind port default 110 -i bind ip, default all IP's. The script does not check authentication, and is not able to do apop. I had however no complaints during my maintainance round. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] duplicate key on dbmail_headername_1
> Lost, or thrown > back at postfix which retries again later? Horrible would be an error > back to the sender (looks unprofessional). How will that look more unprofessional than loosing an email? Case a) sender gets note message was not delivered and tries again. Case b) sender calls reciptient "did you not get this message?" recipient calls you "why did I not get this message?" your response? "My mailserver had a bug, and your message was lost?" ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] data loss
If I'm correct, you should be able to ditch data from dbmail_fromfield and dbmail_header***, then import in postgresql, and run dbmail-util on the database to restore table-data ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] piping messages
Is it possible to pipe a message through a program just before inserting it into database (that is after has been decided which mailbox and user the message goes to)? Purpose? "Personal spamfiltering" for example. It is possible to get spamassassin to have user-defined variables in a sql database. But they only work if there is only one recipient. Therefor this is not possible at MDA. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] piping messages
Is it possible to pipe a message through a program just before inserting it into database (that is after has been decided which mailbox and user the message goes to)? Obviously the dbmail should read on stdin to get the message back and insert it into the database. I know it is possible to pipe the message with a alias chain (alias => pipe => dbmail-smtp => alias2 => mailbox) but that is a maintainance hassle. Or is it possible to pipe from sieve? Regards, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] symbian mail
Same problem here. If I only get one message, it is persistent for me until I remove/install client settings. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] postgres 8.3 support
What is the postgres 8.3 support status in 2.2.10? Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Errors / Crash's
Sorry for being "borring" Maybe you can try reading through mailinglist history, and only ask if you didn't find the answer. No, you can't revert back because the database backend is different. Turning back to 2.2.x would mean losing messages received since you went to 2.3. If losing email is no problem for you, you can turn back without changing the schema. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] aliases field "deliver_to" with user_idnr numbers - behaviour and best practise
] Let me guess: your primary alias was the same as the username value? If you have: alias:[EMAIL PROTECTED]>deliver_to:777 alias:[EMAIL PROTECTED]>deliver_to:777 alias:[EMAIL PROTECTED]>deliver_to:[EMAIL PROTECTED] Sorry, I probably misread the original message, I always do: alias:[EMAIL PROTECTED]>deliver_to:777 alias:[EMAIL PROTECTED]>deliver_to:[EMAIL PROTECTED] That way I can get enough permutations (1 address for home and work, one only home one only work) for each user account. It is however a wasps nest for a given user with numerous aliases to find where which email goes, not in the least due to the logging (level 3) being somewhat hard to read. My example is clearly different from the above stated, in which [EMAIL PROTECTED] should *not* get delivered to [EMAIL PROTECTED] Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] aliases field "deliver_to" with user_idnr numbers - behaviour and best practise
This makes all e-mail sent to [EMAIL PROTECTED] appear on the dbmail user "[EMAIL PROTECTED]", as well as a forward on [EMAIL PROTECTED] Simple. BUT if now he has an alias [EMAIL PROTECTED] -> [EMAIL PROTECTED] this was already replaced with [EMAIL PROTECTED] -> 777 and then [EMAIL PROTECTED] would only go to local user 777 and not the [EMAIL PROTECTED] e-mail, and this is not easy to find. If that is the case, this surely is a regression. I did formerly use aliasses (the one with the number) and forwards together. And they should both be delivered. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] mail encryption
> That is what is solved by PGP: The CEO types an e-mail, his *PC* > encrypts it and sends it to the CFO. This encrypted text is stored in > the DB, and transferred over the Internet and all other cables > encrypted. Only on the PC of the CFO the e-mail will be decrypted. When > she answers, it's again encrypted on her PC and decrypted on the PC of > the CEO. All other occurences are encrypted. Who says the CEO as a /he/ and the CFO a /she/ ? Maybe you've been reading their emails? (No offence meant, just joking...) Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] mail encryption
On Tue, Jan 29, 2008 at 11:19:45AM +0200, Sim Zacks wrote: > The problem is having the data encrypted as it is stored. Paul Stevens said > in one of his posts that this is a *bad* idea. Is this because of the > amount of time it would take, or is there another problem here? What I was > thinking is that if I had the encryption library on the server then on the > insert code for the messageblks table (only for non header parts, > obviously) I could call the encrypt function using the public key of the > user it is being inserted into. Then when he opens the email on his client, > his private key would open it automatically. > Then the only thing I would have to worry about is sniffers and people > accessing the computer to read email, which I am really not worried about. No, it just doesn't make sense to encrypt on the server, because both public as private keys should be /on/ the server before communicating with the client. It adds extra load, but no security. If the private key is on the client side, only he is able to decrypt. Communication and storage will be encrypted, without the database application even having to know the message is encrypted. Also, you don't have to be worried about sniffers anymore, because communication is encrypted. When using a /good/ email tool encryption/decryption should be done automatically at client side, only requesting the private key password at the user when opening it. The CEO only has to spread a public key to his senders, and they can (automatically using a good email client) encrypt all messages send to him. So generalizing: 1) Encrypting server-side is a bad idea, because it makes no sense. 2) Encrypting client-side is. Either use gnuPG or PGP. 3) Trusting sysadmins is just something you have to get over with. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] mail encryption
IMAP, especially on a database, changes the picture because while the sys admin is doing routine maintenance it is so easy and untraceable to search for keywords (such as his name or the word salary) that even a "trusted" system administrator will do this. When the CFO gets salary information emailed to her, (internally, never hits the Internet) she would like that to be not easily accessible to the system administrator. Can he log on to her machine and read her email? Yes Will he? Probably not. Will he search through the database out of curiosity? Probably. Again, gnuPG or PGP should be all you need. The content will be stored encrypted, where only the receiver is able to decrypt. And provides the same security as your password encrypted documents. They can be cracked if one logs onto the CEO computer. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Can dbmail cope with 1.000 e-mails/s ?
That smells like POP3 access. Like Marc's suggestion, perhaps we should offer a pop3-storage only mode (no headercaching, no envelope caching, etc). But that would not be possible on a per-user basis, only on a per-dbmail-instance basis. Not without changing the delivery chain very significantly. Sorry Marc. I'm all for it. (Although per user would be even better). It should be peanuts to have 2 instances of dbmail one for imap and one for pop. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] LDAP over SSL
Hi John, Maybe you can add this to the wiki? Marc On Fri, Jan 11, 2008 at 03:04:16AM -0500, John T. Guthrie III wrote: > > John T. Guthrie III wrote: > > > Hello all, > > > > > > Does anyone know if there is any support for connectig to an LDAP server > > > that uses SSL? I haven't seen anything in the config or on the website > > > that > > > suggests how to do this if it's possible. > > > > That is not supported at the moment. > > So I just managed to find my own solution. I was able to get a secure > connection to LDAP by using stunnel in client mode. I had an stunnel on the > same host as the dbmail-imapd process listen on port 389, and I configured it > to connect to port 636 on the LDAP server. Here is a sample config for an > stunnel service: > > > [ldap] > CAfile = /path/to/file/cacert/list > client = yes > accept = 389 > connect = ldap_host:636 > > > Now run stunnel and that's it! Note that if you generate your own > certificates, > then make certain that either your local CA or the self-signed cert for your > LDAP server are in that cacert list file. Note that I am using stunnel 4.x. > I > think that earlier versions of stunnel would put all of this config on the > command line instead of in a file. Like this: > > stunnel -c -d 389 -r ldap_host:636 > > I'm not certain about this syntax since I haven't used any earlier versions of > stunnel. If anyone knows any better, please feel free to correct me. > > JTG > ___ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] mailbox alias
Just a thought. Isn't it enough to have "mailbox_idnr" not unique in dbmail_mailboxes? I don't mind in one or the other client showing up a second mailbox, I just want their contents to be the same. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Basic Question
dbmail-users -x [EMAIL PROTECTED] -t [EMAIL PROTECTED] dbmail-users -x [EMAIL PROTECTED] -t [EMAIL PROTECTED] Marc On 06 Jan 2008, at 13:48, Jorge Bastos wrote: Guys, sorry my dumbness but i fell like i woke up today and I just forgot everything I’ve learned. How do I make an forward for 2 emails, without the email that is being forwared being an account? Ex: [EMAIL PROTECTED] => [EMAIL PROTECTED] ð [EMAIL PROTECTED] so every email that comes to [EMAIL PROTECTED] will send an copy to [EMAIL PROTECTED] and [EMAIL PROTECTED] and [EMAIL PROTECTED] isn’t an account, no login or pwd for it. I could do it with sieve but, I don’t want [EMAIL PROTECTED] to be an account. Thanks, Jorge ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: AW: [Dbmail] enormous DB Traffic using imapsync
Yes. I still think MySQL has core-problems, which are due to the original project goal (being fast for small applications, instead of feature rich, stable or sql compliant). Furthermore, last time I checked it was not possible to have 2 mysql cluster servers, with 2 *seperate* dbmail-lmtp daemons on both, at least not without doing a serial trick. If that is not the case, then I'm sorry to have been misinformed. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] enormous DB Traffic using imapsync
Hmm, Looks like you guys should consider mysql clustering, this should resolve most of these kind of troubles. MySQL clustering is like trying to create an industrial robot with LEGO mindstorms. Also the serial problem, of having inserts at multiple locations is not solved using clustering. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] enormous DB Traffic using imapsync
My experience with imapsync with dbmail is that it sucks. Using a pc-client to move messages from one account to the other is often faster and has no failures. marc. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] db server -- 64 bit, or 32 bit?
I'd like to see a proposal on how to change the schema to do that. So what fields can safely be changed from int8 to int4, what fields need extra precautions or even code changes, and what fields do warrant int8. All INT8 can be changed into INT4 on small to middle installs. We have them all INT4 with 10K users. On large installs for dbmail_physmessage.id, dbmail_messages.message_idnr: These can be INT4 by creating code that can handle possible wrap around, (if it wraps search for the next "free" value) or leave it at INT8 for now. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] db server -- 64 bit, or 32 bit?
Also, the schema in the dbmail sources makes heavy use of the INT8 data type. PG handles those much better on an -m64 compile than on a -m32 compile. The speed increase I got when I converted my personal mail store to use INT4 everywhere INT8 is currently specified -- except for the dbmail_users table; my curmail_size is greater than 2 Gigs -- was significant. And I cut my disk space usage by about half. I second that! Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] db server -- 64 bit, or 32 bit?
> > "And on other hand,32-bit code on the AMD64 CPU family is not > > native, and that is why 32-bit code is significant slower on this CPU > > family." > > If that's in the Postgres FAQ, then I'm surprised at the FUD they've got > masquerading as fact. Try the MySQL FAQ instead :) Taking the article which is closed to what you'd like to expect is not always sience. I presume the postgresql group has done some testing with Solaris and 32/64 bit mode on amd. As also the MySQL team on a linux 32/64bit AMD. > > There is NO speed difference between 32 and 64 bit on AMD processors. > It runs natively either way. If you run on an Itanium, then it's a > different story - they do some fancy code conversion if given 32 bit > binaries. > > The main difference for database use is that 64 bit processors can > address MUCH more memory, so your DB software doesn't have to do nasty > tricks ( that slow things down ) to deal with large databases. So essentially you say here, I believe MySQL is right, there is no speed difference between 32 and 64 bit AMD, but the 32 bit is slower? Native does NOT mean no speed difference, it just means there is no fancy stuff scaling 32 bit operations to 64 bit. If a pointer is 64 bit on the other hand, it has to be scaled to 32 bit in 32 bit mode, which is done automatically / native (as has been done in the whole 32bit era) , but still results in 32 bits of the adres generater being unused. This will result in more calculation which can be done in 1 when it was in 64 bit mode. More calculation is more time. However, dbmail uses a lott of (IMHO unnecessary) BIG INT variables. Which is by default more efficient if calculated in 64bit mode. Also indexing/indices with on BIG INT columns will work better. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-imapd eating CPU
Perhaps put some $ towards a developer if it bothers you enough or submit a patch yourself. Winging and bad mouthing people who are giving you stuff for free isn't particularly nice, or likely to motivate people to help you. My thought also! Please adjust the tone of your mail to open-source talk. BTW, Paul thanks for the fix! ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-imapd eating CPU
I can confirm this problem, with using these same steps, dbmail 2.1.7-svn. On Wed, Nov 21, 2007 at 02:12:19PM +0300, umask wrote: > wake up :) > > this bug is big security hole provides DoS and 100% CPU utilization. > > Please fix ASAP. > > > 21.11.07, 08:18, umask ([EMAIL PROTECTED]): > > > It's big bug :( > > Steps to reproduce. > > telnet imap.server.net 143 > > Trying 192.168.1.1... > > Connected to imap.server.net. > > Escape character is '^]'. > > * OK IMAP4 ready > > a001 login [EMAIL PROTECTED] password > > a001 OK LOGIN completed > > a002 noop > > a002 OK NOOP completed > > a003 SELECT INBOX > > * 1 EXISTS > > * 0 RECENT > > * FLAGS (\Seen \Answered \Deleted \Flagged \Draft) > > * OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft)] > > * OK [UIDNEXT 791936] Predicted next UID > > * OK [UIDVALIDITY 72365] UID value > > a003 OK [READ-WRITE] SELECT completed > > a004 SEARCH UID 1:279261 > > * SEARCH 1 > > a004 OK SEARCH completed > > a005 FETCH -14:1 (UID FLAGS) > > And dbmail-imapd proccess which handle IMAP connections enter in loop. > > 20.11.07, 18:39, Marc Dirix ([EMAIL PROTECTED]): > > > I don't think the top or ps outputs are that helpfull, > > > can you provide: > > > 1) mailbox size, message nummer etc for the mailbox that triggers te > > > problem > > > 2) Message, if you can determine which message triggers the problem. > > > 3) Client, is it mailclient related? > > > And maybe a Level5 log, so dev's can parse it. > > > (please remove passwords, and sensitive data). > > > Marc > > > ___ > > > DBmail mailing list > > > DBmail@dbmail.org > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > ___ > > DBmail mailing list > > DBmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > ___ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-imapd eating CPU
I don't think the top or ps outputs are that helpfull, can you provide: 1) mailbox size, message nummer etc for the mailbox that triggers te problem 2) Message, if you can determine which message triggers the problem. 3) Client, is it mailclient related? And maybe a Level5 log, so dev's can parse it. (please remove passwords, and sensitive data). Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-imapd eating CPU
Also, IIRC I reported the lmtpd problem before you Jorge ;) On Tue, Nov 20, 2007 at 10:35:42AM +0100, Paul J Stevens wrote: > > Incorrect. This report is totally unrelated to the problem Jorge reported > where lmtpd started looping and eating the cpu. > > In this case something else entirely appears to be going on. > > Jorge Bastos wrote: >> Umask, >> It's fixed in libgmime 2.2.11. >> I had the same problem (in fact it was me who started this :P) >> Update to last gmime and reconpile dbmail, it's fixed. >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >> Behalf >> Of umask >> Sent: terça-feira, 20 de Novembro de 2007 5:51 >> To: dbmail@dbmail.org >> Subject: [Dbmail] dbmail-imapd eating CPU >> Hi! >> Part of dbmail-imapd processes eating CPU from Nov 19, 2007 19:00. >>> From top: >> 4317 dbmail dbmail dbmail25 0 11716 5408 1892 R 19.9 0.3 >> 196:16.51 0 63080 stext /usr/sbin/dbmail-imapd 12902 dbmail >> dbmail dbmail25 0 11280 4872 1892 R 19.9 0.2 >> 150:54.52 0 64080 stext /usr/sbin/dbmail-imapd 12908 dbmail >> dbmail dbmail25 0 11708 5472 1892 R 19.9 0.3 >> 7:32.57 0 62360 stext /usr/sbin/dbmail-imapd 12909 dbmail >> dbmail dbmail25 0 11740 5588 1892 R 19.9 0.3 >> 209:11.51 0 61520 stext /usr/sbin/dbmail-imapd 13103 dbmail >> dbmail dbmail25 0 11272 4868 1892 R 19.6 0.2 >> 157:19.76 0 64040 stext /usr/sbin/dbmail-imapd dbmail-imapd -V >> This is DBMail version 2.2.7 >> OS: CentOS 5.0 (32-bit). >> Strace out nothink for pids of dbmail-imapd processes and logs contaions >> same for all problem pids: >> Nov 19 20:46:32 massmail-1 dbmail/imap4d[13103]: Error:[imapsession] >> dbmail-imapsession.c,dbmail_imap_session_readln(+1585): timeout occurred >> in >> dbmail_imap_session_readln >> Nov 19 21:11:37 massmail-1 dbmail/imap4d[13103]: Error:[imapsession] >> dbmail-imapsession.c,dbmail_imap_session_readln(+1585): timeout occurred >> in >> dbmail_imap_session_readln >> Nov 19 21:16:32 massmail-1 dbmail/imap4d[13103]: Error:[imapsession] >> dbmail-imapsession.c,dbmail_imap_session_readln(+1585): timeout occurred >> in >> dbmail_imap_session_readln >> But now $ date >> Tue Nov 20 08:50:46 MSK 2007 >> Somebody have ideas about this trouble? >> -- >> Ilyas >> ___ >> DBmail mailing list >> DBmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> ___ >> DBmail mailing list >> DBmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > -- > > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlandshttp://www.nfg.nl > ___ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] encoding problem again.
Thanks Paul, It's up and running, I'll report as soon as I get these broken mails in my inbox! Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] encoding problem again.
Hi, I'm sorry to report Paul, the problem is not fixed so it seems. Nov 11 21:18:11 gamma dbmail/lmtpd[9564]: Error:[sql] dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (77281,'','PS^_^H^P')] : [ERROR: invalid byte sequence for encoding "U TF8": 0xe92008 HINT: This error can also happen if the byte sequence does not m atch the encoding expected by the server, which is controlled by "client_encodin g". ] Again from the same mailer, with same recipients! This is DBMail version 2.2.7 Best Regards, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Checking users quota
select userid from dbmail_users where maxmail_size!=0 and maxmail_size < curmail_size; ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-lmtpd eating cpu!
Im going to save the raw message, and then delete it. And after 1/2 hours check if the dbmail-lmtpd processes stoped eating the CPU. Does it need to restart postfix or dbmail? (maybe doesn't matter at all) You need to restart dbmail-lmtp, because it doesn't get out of the tight spot, even if you empty the queue. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] stunnel
accept = 993 If you use stunnel from inetd, you must *not* set this value. Jani's config is right! If you set accept, stunnel tries to connect to port 993, which is claimed by inetd! Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail-lmtpd eating cpu!
Jorge, To start debugging this, what do you want/need? Please try to determine which messages causes this by moving them out of the postfix queue one by one. Then, please mail the message. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] sieve bug?
Sorry te be re-replying again. I upgraded libsieve (2.2.3 it seems to be in debian) to 2.2.6 and it is working now! Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] sieve bug?
libsieve2-1 from debian packages are ok, or do I need to grab the source somewhere? The debian package installs "/usr/lib/libsieve1.0.5" which seems in contrast to version 2? Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] sieve bug?
Should this actually work or not? Are there any restrictions in dbmail as to what adresses are allowed to be set? Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] sieve bug?
Hi, I'm trying to create a vacation reply which sets the "from" of the reply explicitly. According to the sieve vacation standard this should be possible, however dbmail does not comply. I've setup a testuser, which gets email for "[EMAIL PROTECTED]". The vacation reply always has the from header set to "[EMAIL PROTECTED]" inspite of the explicit setting inside the script. this is my script: require "vacation"; vacation :days 1 :subject "ahum" :from "[EMAIL PROTECTED]" "Blablabl"; The sieve vacation standard says: 4.3. Subject and From Parameters A ":from" parameter may be used to specify an alternate address to use in the From field of vacation messages. The string must specify a valid [RFC2822] mailbox-list. Implementations SHOULD check the syntax and generate an error when a syntactically invalid ":from" parameter is specified. Implementations MAY also impose restrictions on what addresses can specified in a ":from" parameter; it is suggested that values which fail such a validity check simply be ignored rather than causing the vacation action to fail. 5.4. From Unless explicitly overridden with a :from parameter, the From field SHOULD be set to the address of the owner of the Sieve script. -- regards, Marc Dirix ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] CPU LOAD
You might try ltrace, too. No, also no output. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] CPU LOAD
If strace shows nothing, it likely means we're in a loop without any syscalls. If you can pinpoint a message that causes lmtpd to explode, that'd be awesome, we can run under gdb and see where the problem could be caught. It is indeed a very tight loop, without any syscalls. We currently have no message saved which triggers this problem. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] CPU LOAD
Have a lmtpd process with 100% cpu usage, and it still with the same usage, going to restart dbmail and tomorrow morning I'll see if there's any diference. Empty the queue?? No angry customers? As soon as a message messes a lmtp daemon up (although dbmail should work around this) it keeps on using 100% cpu. Just try killing the daemon which is eating cpu, and see if the problem returns. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] CPU LOAD
We see these problems all the time. Mostly because of some spam message not getting through gmime. Jorge, please review which message triggers it, and remove it from the queue. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Sieve error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 IIRC If your database is not UTF8, sieve chokes on characters like "ä" . Actually, at inserting them, sievecmd should already have reported the problem. Marc -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (Darwin) iD8DBQFG96BP2M1B/aDfmXsRAjxNAJ94KSBHsMGzKGQvawaMTkREVTMcBQCeJ8ud 3T1+nemh5PED7i6wGMqg5Xw= =U0eu -END PGP SIGNATURE- ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] sieve notify
Well that was pretty stupid of me :-[ I'll either fix the extension advertisement or fix the code this week. Thanks for pointing this out. Did you have time to get to this? ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Log table
Putting the log_level to 3 , that yes is going to kill the server. This is so not true! Our logs are also a lott bigger than 80MB a day. I must say, dbmail logging (@level 3) is still lacking (as stated before), however since I didn't patch it myself I should really not keep going on it. However it should *not* be replaced by database logging just because the current syslog is lacking. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Log table
A server with that kind of simultaneous logins will not be a P4 3.0GHZ with HT and 1GB of RAM for sure. Please stop assuming that the key to add more scalability is to throw more (expensive) hardware at it. DBMail already is pretty generous in the harddisk space it takes, adding more to it will slow it down exponentially. Although I can see the point in having more database statistics in the sort of "last_login, total_bytes, total_messages", dissagree implementing this in a growing table fashion. But agree with Josh and Vladimir and Paul: we do *not* want to replace syslog, syslog is in general sufficient for admins to look into mailproblems. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Sieve error
Please post your script. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] massive runtime improvement for dbmail-util ?
Op 27-aug-2007, om 9:54 heeft Paul J Stevens het volgende geschreven: Then why do I keep hearing noises on this list that JOINs are faster than sub-SELECTS ?? It depends on the amount of data returned from the subselect. Subselects in general are executed first and put in an temporary table. If this temporary table is large, the subselect will be much slower than the JOIN. A join can be slower if the WHERE fields are put in wrong order. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Extensions of catch-all addresses
You can do this easily in postfix using an regexp table for the time being. /user@(.*)/ [EMAIL PROTECTED] Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] dbmail not accepting emails
Aug 14 10:30:39 db1 postfix/smtpd[32276]: 875CAC14159: client=localhost[127.0.0.1] Aug 14 10:30:47 db1 postfix/cleanup[32278]: 875CAC14159: message- id=<[EMAIL PROTECTED]> Aug 14 10:30:47 db1 postfix/qmgr[24856]: 875CAC14159: from=<[EMAIL PROTECTED]>, size=372, nrcpt=1 (queue active) Aug 14 10:30:47 db1 postfix/pickup[32105]: 6A09CC1415B: uid=65534 from=<[EMAIL PROTECTED]> Aug 14 10:30:47 db1 postfix/cleanup[32278]: 6A09CC1415B: message- id=<[EMAIL PROTECTED]> Aug 14 10:30:47 db1 postfix/qmgr[24856]: 6A09CC1415B: from=<[EMAIL PROTECTED]>, size=536, nrcpt=1 (queue active) Aug 14 10:30:47 db1 postfix/pipe[32280]: 875CAC14159: to=<[EMAIL PROTECTED]>, relay=dbmail-smtp, delay=13, delays=13/0/0/0.05, dsn=2.0.0, status=sent (delivered via dbmail- smtp service) Aug 14 10:30:47 db1 postfix/qmgr[24856]: 875CAC14159: removed This looks like a normal delivery. If it bounces, after delivery, and gets deleted there should be a configuration error in dbmail. a) Which version of dbmail? (Try dbmail-users -V) b) Please post your configuration of aliases (dbmail-users -l ) c) Do you have sievescripts active? Have you inserted any? Post them here. (dbmail-sievecmd -u USERNAME -l) Well, I most likely made a newbie misstake, like maybe I have to tell dbmail for which domains it should accept emails instead of just creating an alias [EMAIL PROTECTED], anyhow I hope you can give me a hand. creating an alias should be enough to deliver the message. Try inserting a message by hand with the dbmail-smtp script, or telnet to localhost lmtp port (lmtp takes the same commands as smtp). If the above is working, then move on to postfix. Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] SMTP AUTH
Op 14-aug-2007, om 1:36 heeft Jim Douglas het volgende geschreven: This is the output to the MAIL LOG, Aug 13 19:15:57 cpe-94-973-964-82 postfix/smtp[24382]: 80FC438C0807: to=<[EMAIL PROTECTED]>, relay=smtp-auth.no-ip.com [24.126.222.92]:3325, delay=0.42, delays=0.05/0.01/0.26/0.1, dsn=5.7.1, status=bounced (host smtp-auth.my.com[24.126.222.92] said: 554 5.7.1 : Client host rejected: Access denied (in reply to RCPT TO command)) This is the AUTH LOG, Aug 13 19:30:51 cpe-94-973-964-82 postfix/smtpd[24656]: sql auxprop plugin using mysql engine Is it normal the bounce has an earlier timestamp than the authlog notice? Aren't there anymore log notices in authlog about the same connection? Did you create the symlinks to your postfix directory? Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail