[Maia-users] "invalid input syntax for type timestamp" - postgresql backend

[Marc G. Fournier]

Damn, I think I did fix this one and didn't post it :(  Posting this to 
the list at the same time ... not sure why they are trying to format with 
the string like that, but the %Y is always 4 digit, %m always 2, etc ...

Try this, in amavisd-maia, maia_store_mail function, around line 3608 ... :

#    my($received_date) = strftime("%04Y-%02m-%02d %02H:%02M:%02S",localtime);
     my($received_date) = strftime("%Y-%m-%d %H:%M:%S",localtime);


On Fri, 15 Sep 2006, Matthew Jarrett wrote:

> Hi Marc,
>
> Thanks for the quick reply, much faster than I expected, appreciate it.
>
> I don't know whats going on there, but I think it has to do with that $isPg
> variable, but can't be 100% certain of this.
>
> So annoying though as mail is being stopped. I was thinking maybe an
> incompatibility between MAIA and Postgres itself.
>
> Not sure if you saw my original post, but will include it here in case you
> have any ideas.
>
> If you happen to get it working, let me know if you can, I'd appreciate it.
>
> Thanks,
> Matt.
>
> PS: Damn annoying programs! Argh!
>
>
>
>
> ------
> Hi All,
>
> We have just started using Amavis with PostgreSQL and Maia Mailguard, and
> are finding we are getting this error
>
> invalid input syntax for type timestamp: "4Y-2m-2d 2H:2M:2S"
>
> In the messages log.
>
> Has anyone else seen this before?
>
> Some further log information from the maillog is below:
>
>> Sep 13 09:36:17 filter amavis[63757]: (63757-05) TROUBLE in
>> check_mail: cached FAILED: DBD::Pg::st execute failed: ERROR:  invalid
>> input syntax
> for
>> type timestamp: "4Y-2m-2d 2H:2M:2S"
>> Sep 13 09:36:17 filter amavis[63757]: (63757-05) PRESERVING EVIDENCE
>> in /usr/local/etc/amavisd/tmp/amavis-20060913T093812-63757
>> Sep 13 09:36:17 filter amavis[63757]: (63757-05) TIMING [total 462 ms]
>> - SMTP EHLO: 3 (1%), SMTP pre-MAIL: 1 (0%), SMTP pre-DATA-flush: 4
>> (1%),
> SMTP
>> DATA: 406 (88%), body_hash: 19 (4%), maia_connect: 7 (1%),
>> maia_read_system_config: 4 (1%), update_cache: 1 (0%),
>> maia_delete_mail:
> 12
>> (3%), maia_disconnect: 2 (1%), rundown: 2 (0%)
>> Sep 13 09:36:17 filter postfix/smtp[63805]: DE0D25C3C:
>> to=<mail at domain.com.au>, relay=127.0.0.1[127.0.0.1]:10024, delay=25,
>> delays=24/0/0.01/0.46, dsn=4.5.0, status=deferred (host
> 127.0.0.1[127.0.0.1]
>> said: 451 4.5.0 Error in processing, id=63757-05, cached FAILED:
> DBD::Pg::st
>> execute failed: ERROR:  invalid input syntax for type timestamp:
>> "4Y-2m-2d 2H:2M:2S" (in reply to end of DATA command))
>
> This has appeared to only affect some emails coming in which seem to have
> attachments included with them, but doesn't affect all and every email that
> has attachments included.
>
> The mail software we are using is Postfix, and the Postgres version is
> 8.1.4.
>
> Any help much appreciated. Have searched around and haven't been able to
> successfully find any information on this so far.
>
>
>
>
> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy at hub.org]
> Sent: Friday, 15 September 2006 12:13 PM
> To: Matthew Jarrett
> Subject: Re: "invalid input syntax for type timestamp" - postgresql backend
>
>
>
> I haven' thad much time of late to dive into the various errors, but
> anything I have been able to fix, I've made sure I've sent back to the
> list :(
>
>
>
> On Fri, 15 Sep 2006, Matthew Jarrett wrote:
>
>> Hi Marc,
>>
>> I have been browsing the MAIA-Mailguard list looking for a solution to
>> this exact below problem.
>>
>> I have tried a few things that you have suggested on the list, as well
>> as some of the other posts, and still haven't gotten rid of this
>> error.
>>
>> I was wondering if you had resolved this issue, or if you are still
>> having the same problem with it, or it not functioning correctly?
>>
>> Any assistance is appreciated, and I appreciate your time reading
>> this.
>>
>> Thanks in advance,
>> Matthew.
>>
>>
>>
>> Matthew Jarrett
>> Technical Manager
>>
>> Norwest IT, Australia.
>>
>> P> 02 9659 9699
>> F> 02 8850 5908
>> W> www.summit.net.au
>> W> www.ofw.com.au
>>
>>
>>
>>
>>> Does anyone happen to have a fix for this one?
>>
>>> Error in processing, id=81568-05, cached FAILED: DBD::Pg::st execute
>>> failed: ERROR: invalid input syntax for type timestamp: \"4Y-2m-2d
>>> 2H:2M:2S\" (in reply to end of DATA command)
>>
>>
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email . scrappy at hub.org                              MSN . scrappy at hub.org
> Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
>
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664