Ok. A bug. Dunno how that one got in. It's not in cvs-head, and I've used those packages intensively until
last thursday.
It's fixed now. Upload just finished.
Please note that I've fixed the version numbering. I switched to 2.0.0-1 too early. That versioning should not
have been uploaded. Now on debian.nfgd.net is 2.0.0-0.20040919 so please make sure you do:
apt-get update; apt-get remove dbmail-pgsql; apt-get install dbmail-pgsql
That should fix both errors.
April Lorenzen wrote:
Using postgres. I see an error in mail.log from dbmail-smtp. I thought that the
word INTO was required for postgres INSERT? This query inserts a record ok if I
paste it manually and execute the query on postgres - only if I add the word
INTO after INSERT. Other details of my config at end.
Sep 18 22:44:12 crunch-a dbmail/smtp[590]: dbpgsql.c, db_query: Error executing
query [INSERT dbmail_messageblks (is_header,messageblk,blocksize, physmessage_id
) VALUES ('1','Return-Path: <[EMAIL PROTECTED]> Received: from web60108.mail.
yahoo.com (web60108.mail.yahoo.com [216.109.118.87]) ^Iby crunch-a.mailcruncher.
com (8.13.1/8.13.1/Debian-13) with SMTP id i8J2iBWL000587 ^Ifor <[EMAIL
PROTECTED]>; Sat, 18 Sep 2004 22:44:12 -0400 Message-ID: <20040919024406.61221.qmai
[EMAIL PROTECTED]> Received: from [68.9.200.247] by web60108.mail.yahoo.
com via HTTP; Sat, 18 Sep 2004 19:44:06 PDT Date: Sat, 18 Sep 2004 19:44:06 -070
0 (PDT) From: April Lorenzen <[EMAIL PROTECTED]> Subject: test 20 To: [EMAIL
PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii ',
'621', '329')] : [ERROR: syntax error at or near "dbmail_messageblks" at character 8 ]
dbmail version is the debian one available today by apt-get install dbmail-pgsql
sendmail installed fresh today from apt-get install sendmail/testing which is
8.13
Used dbmail.m4 from here:
http://www.helgrim.com/dbmaildocs/files/dbmail.m4
Sendmail is working. Postgres is v 7.4.5 and is working. SELECT queries done by
dbmail-smtp are showing up successful such as finding aliases in the postgres
table etc.
Am I correct that INSERT INTO is the required syntax, if so, how can I cause
the word INTO to be added into these queries?
I saw some postings in the dbmail list archives where other people's queries had the INTO in them.
Thank you,
- April
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
