RE: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Larry Rosenman
Ya know, this is a royal pain. I tried running the message that failed with gdb, and it worked. There is something weird going on here. I'm going to see what I can do to trap this error Suggestions on what/where to put some debugging would be appreciated! LER -- Larry Rosenman

[Dbmail] dbmail postfix 2.3 postgresql 8.2 libpq

2006-12-15 Thread Kevin Scott
just curious if anyone has a working setup with postfix 2.3 & postgresql 8.3 apparently the libpq libraries have been updated. Thanks in advance. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Larry Rosenman
On Fri, 15 Dec 2006, Matthew O'Connor wrote: Larry Rosenman wrote: On Fri, 15 Dec 2006, Matthew O'Connor wrote: Right, but the test program (as best I can tell) calls char2date_str with a date string created by a call to the OS which will most likely give us a sane representation. I think t

[Dbmail] Re: alias mapping

2006-12-15 Thread Bernard Johnson
On Fri, Dec 15, 2006, Bernard Johnson <[EMAIL PROTECTED]> said: What I get is that the lmtp process connects to the lmtpd daemon. Something happens (haven't bothered to get a trace debug yet) and the connection is dropped and postfix marks it as "delivery temporarily suspended to 127.0.0.1[127.0.0

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Matthew O'Connor
Larry Rosenman wrote: On Fri, 15 Dec 2006, Matthew O'Connor wrote: Right, but the test program (as best I can tell) calls char2date_str with a date string created by a call to the OS which will most likely give us a sane representation. I think the problem is that gmime (or what ever code it

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Aaron Stone
No no, you're right. I do have more functions to look at. On Fri, Dec 15, 2006, Matthew O'Connor said: > Right, but the test program (as best I can tell) calls char2date_str > with a date string created by a call to the OS which will most likely > give us a sane representation. I think the pr

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Larry Rosenman
On Fri, 15 Dec 2006, Matthew O'Connor wrote: Right, but the test program (as best I can tell) calls char2date_str with a date string created by a call to the OS which will most likely give us a sane representation. I think the problem is that gmime (or what ever code it is in DBMail that inte

Re: [Dbmail] UTF-8 encoding issue

2006-12-15 Thread Matthew O'Connor
Paul J Stevens wrote: Matthew O'Connor wrote: I think that is a rather drastic statement and not what I understood. There are problems when a message has a header that is UTF8 encoded, but I believe that is against the spec isn't it? Yep. Headervalues are /supposed/ to be us-ascii, but 8bit s

Re: [Dbmail] Re: alias mapping

2006-12-15 Thread Aaron Stone
On Fri, Dec 15, 2006, Bernard Johnson <[EMAIL PROTECTED]> said: > Aaron Stone wrote: >>> All mail for @example1.com gets forwarded tot @example2.com. >> >> Does this work!? I've been thinking through the code all morning, and I >> just don't think that this can possibly work as expected -- you'r

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Matthew O'Connor
Right, but the test program (as best I can tell) calls char2date_str with a date string created by a call to the OS which will most likely give us a sane representation. I think the problem is that gmime (or what ever code it is in DBMail that interprets the headers) is getting confused by the

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Aaron Stone
The query we see in Larry's log files is only present in the db_insert_physmessage_with_internal_date function. The two test programs I wrote trace back from char2date_str which is present in that function. Since it didn't fail, I'm at a loss right now to understand what's broken. Aaron On Fri,

[Dbmail] Re: alias mapping

2006-12-15 Thread Bernard Johnson
Aaron Stone wrote: > On Fri, Dec 15, 2006, Marc Dirix <[EMAIL PROTECTED]> said: > >> You can use a forward. >> >> dmail-users -x @example1.com -t @example2.com >> >> All mail for @example1.com gets forwarded tot @example2.com. > > Does this work!? I've been thinking through the code all morning,

Re: [Dbmail] UTF-8 encoding issue

2006-12-15 Thread Paul J Stevens
Matthew O'Connor wrote: > Aaron Stone wrote: >> On Fri, 2006-12-15 at 12:11 +0200, VladK wrote: >>> Hi All. >>> I'm using dbmail-2.2.1; libsieve-2.2.1. >>> On the delivery stage I have got such error: >> [snip] >>> OR", 0.01000, content="FrontPage+Editor, 0.01000')] : [ERROR: invalid >>> byte se

Re: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Matthew O'Connor
Sorry if I'm stating the obvious here, but the problem is that PG doesn't accept "1166132546-05-07 15:42:45" as a valid timestamp because it isn't. The question is, where did that malformed year come from? This sounds like DBMail (or gmime) isn't interpreting the date value correctly from the

Re: [Dbmail] Allowing alias log in

2006-12-15 Thread Jesse Norell
There've been a few related posts for this lately. It would be nice to come up with a unified and flexible approach to rewriting / handling these issues for both delivery and authentication. Even a non- backwards-compatible update of how aliases work might be in order (it's been mentioned before,

RE: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Aaron Stone
Ok, I'm stumped. I'll think about it some more and see what I can do. On Fri, Dec 15, 2006, Larry Rosenman said: > I did already, to both programs. > > On Behalf Of Aaron Stone: > > I posted a test program to try to isolate the issues, give it a shot. > > > Aaron _

RE: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Larry Rosenman
I did already, to both programs. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [Dbmail] Allowing alias log in

2006-12-15 Thread Rod K
Jesse, Thanks! That's exactly what I need. Wasn't aware of usermaps (just migrated from 2.0.11). It doesn't look like it would allow: login: @aliasdomain.tld userid: @domain.tld but even if I have to import all I can live with it. Gotta love scripting :) Thanks again, Rod Jesse Norell

Re: [Dbmail] UTF-8 encoding issue

2006-12-15 Thread Matthew O'Connor
Aaron Stone wrote: On Fri, 2006-12-15 at 12:11 +0200, VladK wrote: Hi All. I'm using dbmail-2.2.1; libsieve-2.2.1. On the delivery stage I have got such error: [snip] OR", 0.01000, content="FrontPage+Editor, 0.01000')] : [ERROR: invalid byte sequence for encoding "UTF8": 0xb5 ] Dec 15 05:00

Re: [Dbmail] Allowing alias log in

2006-12-15 Thread Rod K
Aaron Stone wrote: On Fri, Dec 15, 2006, Rod K <[EMAIL PROTECTED]> said: We have a legacy system running qmail/vpopmail with a couple thousand users that we'd like to migrate. With vpopmail having an aliased domain, the user can sign in as [EMAIL PROTECTED] or [EMAIL PROTECTED] Due to so

Re: [Dbmail] Allowing alias log in

2006-12-15 Thread Jesse Norell
Hello, There are 2 sides, delivery and authentication, and they're handled differently. What I'd do if I were you is have my mta rewrite the destination addresses to something consistent (ie. rewrite all aliased addresses to the standard domain), and then use the dbmail_usermap table to handle

Re: [Dbmail] Allowing alias log in

2006-12-15 Thread Aaron Stone
On Fri, Dec 15, 2006, Rod K <[EMAIL PROTECTED]> said: > We have a legacy system running qmail/vpopmail with a couple thousand > users that we'd like to migrate. With vpopmail having an aliased > domain, the user can sign in as [EMAIL PROTECTED] or > [EMAIL PROTECTED] Due to some legacy issues

Re: [Dbmail] alias mapping

2006-12-15 Thread Aaron Stone
On Fri, Dec 15, 2006, Marc Dirix <[EMAIL PROTECTED]> said: > > You can use a forward. > > dmail-users -x @example1.com -t @example2.com > > All mail for @example1.com gets forwarded tot @example2.com. Does this work!? I've been thinking through the code all morning, and I just don't think that

[Dbmail] Allowing alias log in

2006-12-15 Thread Rod K
Setup: dbmail 2.2 postgres 8.1.4 We have a legacy system running qmail/vpopmail with a couple thousand users that we'd like to migrate. With vpopmail having an aliased domain, the user can sign in as [EMAIL PROTECTED] or [EMAIL PROTECTED] Due to some legacy issues, we have 3 domains aliase

RE: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Aaron Stone
On Fri, Dec 15, 2006, Larry Rosenman said: > I figured that out. Any ideas on Bug 475, though? That's causing random > messages to fail. I posted a test program to try to isolate the issues, give it a shot. Aaron ___ DBmail mailing list DBmail@dbma

Re: [Dbmail] Non existing user in alias domain

2006-12-15 Thread Marc Dirix
Although it seems at first that the lmtp daemon should do this lookup, your argumentation doesn't add up. Either way if the lmtp daemon rejects your message you're getting bounce because your mta already has accepted the message as being valid, it is just being rejected at delivery time. Ultimate

Re: [Dbmail] alias mapping

2006-12-15 Thread Marc Dirix
You can use a forward. dmail-users -x @example1.com -t @example2.com All mail for @example1.com gets forwarded tot @example2.com. Groet, Marc ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Non existing user in alias domain

2006-12-15 Thread Michael Monnerie
On Freitag, 15. Dezember 2006 12:38 Michael Monnerie wrote: > So at LMTP level I receive a "250 Recipient <[EMAIL PROTECTED]> OK", > but in the end it's rejected. But we really need a "4xx" or "5xx" > (should be configurable) message when an address does not exist. > Otherwise it creates a lot of b

Re: [Dbmail] UTF-8 encoding issue

2006-12-15 Thread Aaron Stone
On Fri, 2006-12-15 at 12:11 +0200, VladK wrote: > Hi All. > I'm using dbmail-2.2.1; libsieve-2.2.1. > On the delivery stage I have got such error: [snip] > OR", 0.01000, content="FrontPage+Editor, 0.01000')] : [ERROR: invalid > byte sequence for encoding "UTF8": 0xb5 ] > Dec 15 05:00:57 tigercat

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Matthew O'Connor
Larry Rosenman wrote: Matthew O'Connor wrote: I running PG 8.1 with a UTF-8 encoded DB, it was painful during the 2.1 dev tree, but at this point everything works. Every once in while I'll get a message that fails to deliver because of an invalid UTF sequence, but that's very rare a this point.

RE: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Larry Rosenman
Matthew O'Connor wrote: > Michael Monnerie wrote: >> On Freitag, 15. Dezember 2006 09:22 Paul J Stevens wrote: >>> Presently, dbmail is highly US-ASCII centric. One of the goals for >>> 2.4 is to make it more UTF-8 oriented. >> >> Uhm, does that mean I'm going to have problems with my postgresql >

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Matthew O'Connor
Michael Monnerie wrote: On Freitag, 15. Dezember 2006 09:22 Paul J Stevens wrote: Presently, dbmail is highly US-ASCII centric. One of the goals for 2.4 is to make it more UTF-8 oriented. Uhm, does that mean I'm going to have problems with my postgresql database created with encoding=UTF-8 ?

RE: [Dbmail] Random return messages from dbmail-smtp?

2006-12-15 Thread Larry Rosenman
Aaron Stone wrote: > On Thu, Dec 14, 2006, Larry Rosenman said: > >> How do I see what dbmail-smtp is whining about?: >> >> Dec 14 16:24:10 thebighonker exim[59028]: 1Guyzm-000FLt-9u ** > |/usr/local/sbin/dbmail-smtp -v -v -u ler -m "$1" > R=userforward T=address_pipe: return message ge

Re: [Dbmail] dbmail-lmtpd crashed - no value for NCHILDREN in config file

2006-12-15 Thread Paul J Stevens
Why are you running 2.1.7 ?? Please upgrade to 2.2.1. Rostislav Gaidov wrote: > Yes, it's true. But I don't know again about this: > > I install dbmail-2.1.7-1 and all dependencies, but error on start dbmail > occured: > > /etc/init.d/dbmail: line 153: log_end_msg: command not found > invoke-rc

[Dbmail] Re: alias mapping

2006-12-15 Thread Bernard Johnson
Lars Kneschke wrote: > Bernard Johnson <[EMAIL PROTECTED]> schrieb: >> There seems to be two types of catchall aliases: domains (@domain) and >> local parts (user@). >> >> Is there anyway to map something like: >> @example1.com -> @example2.com >> >> such that: >> >> [EMAIL PROTECTED] -> [EMAIL PRO

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Paul J Stevens
Michael Monnerie wrote: > On Freitag, 15. Dezember 2006 09:22 Paul J Stevens wrote: >> Presently, dbmail is highly US-ASCII centric. One of the goals for >> 2.4 is to make it more UTF-8 oriented. > > Uhm, does that mean I'm going to have problems with my postgresql > database created with encod

Re: [Dbmail] alias mapping

2006-12-15 Thread Lars Kneschke
Bernard Johnson <[EMAIL PROTECTED]> schrieb: > There seems to be two types of catchall aliases: domains (@domain) and > local parts (user@). > > Is there anyway to map something like: > @example1.com -> @example2.com > > such that: > > [EMAIL PROTECTED] -> [EMAIL PROTECTED] > [EMAIL PROTECTED] -

[Dbmail] alias mapping

2006-12-15 Thread Bernard Johnson
There seems to be two types of catchall aliases: domains (@domain) and local parts (user@). Is there anyway to map something like: @example1.com -> @example2.com such that: [EMAIL PROTECTED] -> [EMAIL PROTECTED] [EMAIL PROTECTED] -> [EMAIL PROTECTED] [EMAIL PROTECTED] -> [EMAIL PROTECTED] etc.

Re: [Dbmail] Problem with lmtp

2006-12-15 Thread Michael Monnerie
On Freitag, 15. Dezember 2006 12:24 Michael Monnerie wrote: > I can't see a problem, when I send manually it's OK. What can I do? What I see is that at the end of DATA, I do not receive a return code - the connection is just dropped. There should be some [245]xx return code at the end, or no? m

[Dbmail] Non existing user in alias domain

2006-12-15 Thread Michael Monnerie
I found something that's really not nice. I have an alias @datamatix.net -> @datamatix.eu And no User [EMAIL PROTECTED] Here's the output of my LMTP test: 220 mailsrv DBMail LMTP service ready to rock lhlo x 250-mailsrv 250-PIPELINING 250-ENHANCEDSTATUSCODES 250 SIZE mail from: <[EMAIL PROTECTED]>

[Dbmail] Problem with lmtp

2006-12-15 Thread Michael Monnerie
Hi, I've got a problem with a message to an alias domain: postfix/lmtp[12790]: 892C0D6F7: to=<[EMAIL PROTECTED]>, relay=localhost[127.0.0.1], delay=0, status=deferred (lost connection with localhost[127.0.0.1] while sending end of data -- message may be sent more than once) The log of lmtp is

Re: [Dbmail] dbmail-lmtpd crashed - no value for NCHILDREN in config file

2006-12-15 Thread Rostislav Gaidov
Yes, it's true. But I don't know again about this: I install dbmail-2.1.7-1 and all dependencies, but error on start dbmail occured: /etc/init.d/dbmail: line 153: log_end_msg: command not found invoke-rc.d: initscript dbmail, action "start" failed. What is log_end_msg and why it did not install

[Dbmail] UTF-8 encoding issue

2006-12-15 Thread VladK
Hi All. I'm using dbmail-2.2.1; libsieve-2.2.1. On the delivery stage I have got such error: Dec 15 05:00:57 tigercat dbmail/smtp[6102]: Error query failed [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (85,3341 35,'27, � 0.00161, , 0.00174, ѵ, 0.0026

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Paul J Stevens
Well, afaik 8bit addresses are not yet in actual usage at the moment, right? Blake Mitchell wrote: > Paul J Stevens wrote: > ... >> is to make it more UTF-8 oriented. >> >> There are more candidates for conversion to BYTEA: >> >> dbmail_headervalues.headervalue >> dbmail_subjectfield.subjectfield

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Michael Monnerie
On Freitag, 15. Dezember 2006 09:22 Paul J Stevens wrote: > Presently, dbmail is highly US-ASCII centric. One of the goals for > 2.4 is to make it more UTF-8 oriented. Uhm, does that mean I'm going to have problems with my postgresql database created with encoding=UTF-8 ? mfg zmi -- // Michael

Re: [Dbmail] dbmail-lmtpd crashed - no value for NCHILDREN in config file

2006-12-15 Thread Paul J Stevens
Come to think of it: > > open("/etc/dbmail/dbmail.conf", O_RDONLY) = 4 > > read(4, "# $Id: dbmail.conf,v 1.1.1.1.2.3"..., 4096) = 3131 That version $Id looks like it's from before dbmail-2.0. That's a CVS id, and we switched to SVN right after 2.0.0 came out. Please try using a fresh dbm

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Blake Mitchell
Paul J Stevens wrote: ... is to make it more UTF-8 oriented. There are more candidates for conversion to BYTEA: dbmail_headervalues.headervalue dbmail_subjectfield.subjectfield dbmail_users.userid dbmail_users.passwd dbmail_mailboxes.name come to mind. Did I miss any? Would aliases be a can

Re: [Dbmail] DBMail mantis uses RFC2822 from of [EMAIL PROTECTED]: should be your own host....

2006-12-15 Thread Paul J Stevens
That's a bug in the mantis config. I'll see what I can do. Larry Rosenman wrote: > When I signed up for the mantis account, my exim rejected the original > password mail because example.com is in ahbl. > > I whitelisted the IP, but the config ought to be changed. For reference, > here are th

Re: [Dbmail] IMAPish question for new DBMail user

2006-12-15 Thread Paul J Stevens
Larry Rosenman wrote: > I think I can see why the IMAP complaint (changing levels of "directories"), > but * OK dbmail imap (protocol version 4r1) server 2.2 ready to run 1 login testuser1 test 1 OK LOGIN completed 2 create testbox 2 OK CREATE completed 3 rename testbox sub/sub1/sub2/testb

Re: [Dbmail] dbmail-lmtpd crashed - no value for NCHILDREN in config file

2006-12-15 Thread Rostislav Gaidov
In dbmail.conf all NCHILDREN=5 2006/12/15, Paul J Stevens <[EMAIL PROTECTED]>: Rostislav Gaidov wrote: > open("/etc/dbmail/dbmail.conf", O_RDONLY) = 4 > read(4, "# $Id: dbmail.conf,v 1.1.1.1.2.3"..., 4096) = 3131 > > And what does it mean? Is this correct? So what is NCHILDREN in /etc/dbmail

Re: [Dbmail] dbmail-lmtpd crashed - no value for NCHILDREN in config file

2006-12-15 Thread Paul J Stevens
Rostislav Gaidov wrote: > open("/etc/dbmail/dbmail.conf", O_RDONLY) = 4 > read(4, "# $Id: dbmail.conf,v 1.1.1.1.2.3"..., 4096) = 3131 > > And what does it mean? Is this correct? So what is NCHILDREN in /etc/dbmail/dbmail.conf > > 2006/12/13, Paul J Stevens < [EMAIL PROTECTED]