[Dbmail] Unable to insert error

2004-02-24 Thread David Young
I get the following error from an email generated by the dmail mailing list. The problem is dbmail was unable to save the data as the function call store_message_temp{} failed. Why doesn't this failure generate an error to Postfix? Postfix thinks the mail was delivered so it didn't keep a copy.

Re: [Dbmail] dbmail 2.0 RC2 pipe.c

2004-02-25 Thread David Young
Has anyone else had a chance to test the new changes? I recompiled the binaries with the pipe.c changes and the maximum file size is still 512K. - Original Message - From: "Ilja Booij" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 24, 2004 6:05 AM Subject: Re: [Dbmail] dbmail 2.0 RC2 p

Re: [Dbmail] CAP domain results in "no such user" mail bounce

2004-03-03 Thread David Young
I thought the "user" section is case insensitive as well? [EMAIL PROTECTED] should also accept [EMAIL PROTECTED] Does the RFC not have a requirement for that? The last thing I would want to do is create every combination of the name for each user, John, JoHn, jOhn, etc... I agree with setting da

Re: [Dbmail] DBMail and anti-virus/anti-spam

2004-03-10 Thread David Young
As far as content filters, there seems to be a bug with amavis-new. For some reason, mail often get chopped off when fed back into postfix for delivery. I've posted about this a few weeks back. Anyone else have problems with amavis-new? David - Original Message - From: "Shih Ming-Wei"

Re: [Dbmail] DBMail and anti-virus/anti-spam

2004-03-11 Thread David Young
l and anti-virus/anti-spam > Hi David, > "Chopped off"? > Can you please describe more in detail this bug with amavisd-new that > you are referring to? Maybe I am overseeing this because > I am also using amavisd-new for content-filtering and i do not notice > any probl

Re: [Dbmail] A little modification for those interested

2004-07-14 Thread David Young
LOL - Original Message - From: "Hans Kristian Rosbach" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Wednesday, July 14, 2004 5:31 AM Subject: Re: [Dbmail] A little modification for those interested > > I've made a modification to RT that increases productivity > > among out suppo

[Dbmail] Outlook express to dbmail-imap timestamp issue

2004-08-24 Thread David Young
Hi, I know this topic has been covered, but I am currently unable to access the dbmail archive to look up the solution. I have an outlook express Inbox with mail that I would like to store on dbmail. At first, I tried the select and move method of dragging all my email into my dbmail by sett

[Dbmail] dbmail-smtp error

2004-09-01 Thread David Young
Does anyone know why I'm getting this error? This is from the maillog and I don't know how to go about tracing the problem. I just know I get a lot of these every day. Is there a way for me to make postifx/pipe spit out the exact command it's sending to dbmail-smtp so I can figure out what's

Re: [Dbmail] dbmail-smtp error

2004-09-01 Thread David Young
il mailinglist" Sent: Wednesday, September 01, 2004 7:27 AM Subject: Re: [Dbmail] dbmail-smtp error > There's probably an error in your dbmail-smtp command. Please show us > your entry for dbmail-smtp in master.cf (in the postfix config) > > Ilja > > David Young wrote: > &

Re: [Dbmail] dbmail-smtp error

2004-09-01 Thread David Young
Ilja, there is so much crap going through the maillog that I don't know what I'm looking for exactly. So I copied all the messages around the error. Hopefully, you can help me solve this mystery. The -v command has been added and dbmail smtp has trace level set to 5. Thanks again -- Sep 1

Re: [Dbmail] dbmail-smtp error

2004-09-03 Thread David Young
v > flags= user=dbmail:dbmail argv=/usr/local/sbin/dbmail-smtp -d ${recipient} > > > perhaps you'll get some useful output. Please bear in mind that you'll > get lots of output! > Please also set DBMail's debug level to 5. > > Ilja > > > David Young wr

Re: [Dbmail] dbmail-smtp error

2004-09-03 Thread David Young
thing wrong in the call to > dbmail-smtp.. > You did do a postfix reload, didn't you? > > Ilja > > David Young wrote: > > >ok, i seem to have figured out a way to reproduce the problem. when i send > >email to 2 or more users on the same domain in the same email

Re: [Dbmail] dbmail-smtp error

2004-09-03 Thread David Young
ance it prevents the issue you see as well). > It might be worth pulling amavis out for testing. > > Jn > > > Original Message > From: David Young > To: "DBMail mailinglist" > Subject: Re: [Dbmail] dbmail-smtp error > Sent: Thu, 2 Sep 2004 16:12:14 -0700

[Dbmail] messagesize 0 in phymessage

2004-09-13 Thread David Young
Hi, I recently noticed roughly 4000 entries in my phymessage table that have a messagesize of 0. I also noticed that the internal_date field seems to be a bit screwed up. If I recall correctly, all internal_dates are stored in (-MM-DD HH:MM:SS) format and not (-MM-DD HH:MM:SS.SS)

[Dbmail] anyone use MailScanner with dbmail and postfix>

2004-10-01 Thread David Young
I was wondering if anyone out there has ever setup dbmail with MailScanner and postfix? I have dbmail setup, but I'm not sure what master.cf should look like after MailScanner scans incoming mail and is ready for delivery to dbmail. I did a search in the dbmail archive and not much came up. T

[Dbmail] What script do I use to migrate from 2.0rc3 to 2.0rc8

2004-10-14 Thread David Young
Hi, how do i go about migrating dbmail 2.0rc3 to 2.0rc8? i am using postgresql and the SQL script on the dbmail.org website says it's for migrating from 1.x to 2.x. Can I use the same script to migrate between 2.0 release candidates? Thanks in advance for your help David

[Dbmail] Re: Migrating from 2.0 release candidate 3 to 2.0.0

2004-10-15 Thread David Young
Hi, I had asked this before but received no reply. Is it possible to to migrate the earlier 2.0 release candidate database to the new 2.0.0 database structure? the included upgrade scripts do not work. Thanks, David - Original Message - From: David Young To: dbmail@dbmail.org

Re: [Dbmail] Re: Migrating from 2.0 release candidate 3 to 2.0.0

2004-10-15 Thread David Young
der to upgrade from 2.0 rc to 2.0.0, all I had to do was rename my > tables to add the 'dbmail_' prefix and add the 'is_header' column to the > messageblks table. > > David Young wrote: > > > Hi, I had asked this before but received no reply. Is it pos

Re: [Dbmail] Problem with dbmail-stmp delivery

2005-03-30 Thread David Young
Hi, I'm having a similar problem when I try and sort my SPAM mails with procmail. I am trying to delivery all mail with "Subject: SPAM" into a folder called SPAM. The problem is that procmail delivers the email correctly, but dbmail-smtp doesn't seem to see the "-m SPAM" option and delivers the m

[Dbmail] Possible DBMAIL bug?

2005-03-30 Thread David Young
Hi, I'm hoping someone can help me with this. I noticed that I have several thousand messages in the messages table that are owned by the dbmail internal user [EMAIL PROTECTED]@__. Is that normal? This is the query I ran: select count(*) from messages where mailbox_idnr=2 Result: (16602)

Re: [Dbmail] Problem with dbmail-stmp delivery

2005-03-30 Thread David Young
" Sent: Tuesday, March 29, 2005 11:07 PM Subject: Re: [Dbmail] Problem with dbmail-stmp delivery David Young wrote: Hi, I'm having a similar problem when I try and sort my SPAM mails with procmail. I am trying to delivery all mail with "Subject: SPAM" into a folder called SPA

Re: [Dbmail] Problem with dbmail-stmp delivery

2005-03-30 Thread David Young
inal Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Tuesday, March 29, 2005 11:07 PM Subject: Re: [Dbmail] Problem with dbmail-stmp delivery David Young wrote: Hi, I'm having a similar problem when I try and sort my SPAM m

[Dbmail] Errors from dbmail-util

2005-05-21 Thread David Young
I ran the dbmail-util command got the following messages. My question is about the NULL physmessages and the incorrect is_header flags. What do they mean and do I need to be concerned about a possible loss of emails with the NULL physmessages? Thanks, David dbmail-util -a --

Re: [Dbmail] TIME_WAIT processes

2005-07-01 Thread David Young
David, how did you verify that the connections are from DBMAIL? The reason I ask is that I run postfix on the frontend and I do database lookups for transport and aliases against postgres. Those connections aren't always persistent so I get a lot of disconnects resulting in some TIME_WAITs.

[Dbmail] Dbmail 2.0.4 to 2.0.10

2006-06-09 Thread David Young
Hi all, I upgraded my dbmail from 2.0.4 to 2.0.10 successfully. However, the release notes said that there were some database side changes (mainly adding of ON UPDATE CASCADE). What is the proper way to do this update so that I can incorporate the changes into my database? Thanks, David

[Dbmail] dbmail-util hangs on physmessage in 2.2.11

2009-09-02 Thread David Young
Hi list, I apologize if this question as already been answered. I did a search in the archives and didn't see anyone with my exact setting. My dbmail-util is hanging on repairing DBMAIL physmessages. I saw an email that the problem was fixed in 2.2.6 so just want to know if anyone else is exper

[Dbmail] DBMAIL error on SELECT

2009-09-09 Thread David Young
Hi, I recently upgraded my dbmail to 2.2.11 and decided to create a new email account/mailbox to make sure everything is working correctly. I sent myself an email and retrieved it via outlook using dbmail-imapd. Below is the error I received in dbmail.err The email displays correctly, but wonder

Re: [Dbmail] DBMAIL error on SELECT

2009-09-09 Thread David Young
Running CentOS 5.2, Postgres 8.3.7. On Wed, Sep 9, 2009 at 8:24 PM, Jonathan Feally wrote: > What database server and version are you using? This seems like an older > database not able to handle that query. > > -Jon > > David Young wrote: > > Hi, I recently upgraded

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread David Young
First I created a new user on dbmail with dbmail-user with the following options (-a -s -w -p MD5-HASH). DBMAIL created the new user/mailbox successfully. Next, I created an IMAP mailbox using Outlook 2003 SP3. Connected to dbmail-imapd. Outlook showed a single mailbox (Inbox). I sent an email

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread David Young
'%LS0tLUJFR0lOIFBHUC%'] : [ERROR: operator does not exist: bytea ~~* unknown LINE 1: ...255) ILIKE '%LS0tLUJFR0lOIFBHUC%' OR k.messageblk ILIKE '%LS... ^ HINT: No operator matches the given name and argument type(s). You might need