br-list-01 at squall
Jan 22, 2009, 10:20 PM
Post #1 of 3
(452 views)
Permalink
|
|
DbMail 2.2.10 LMTPd Problem AND pgsql schema question
|
|
I have been trying to put together a dbmail installation recently and
have been having a bit of trouble. I am currently running dbmail on
another server, but I am trying to move that installation and making a
few setup tweaks to make it work better for my needs.
Is anybody successfully using dbmail against pgsql 8.3 with the tables
in a named schema? (instead of public, I have one called dbmail, the
dbmail user's default schema is also set as dbmail)
I am also having a problem with LMTPd, during the DATA section, when
entering the CRLF . CRLF, the connection drops with no debug or any
log entries of any kind coming from dbmail-lmtpd (I have debugging
set to 5 and have also tried 128, I seriously get nothing). I get
this on the pgsql side:
--- SNIP ---
INSERT INTO dbmail.dbmail_tofield (physmessage_id, toname, toaddr)
VALUES (45647,'','BR39290[at]SILICONSEA.NET')
INSERT INTO dbmail.dbmail_tofield (physmessage_id, toname, toaddr)
VALUES (45648,'','BR39290[at]SILICONSEA.NET')
INSERT INTO dbmail.dbmail_fromfield (physmessage_id, fromname,
fromaddr) VALUES (45647,'','returns[at]redboxdvd.net')
INSERT INTO dbmail.dbmail_fromfield (physmessage_id, fromname,
fromaddr) VALUES (45648,'','returns[at]redboxdvd.net')
INSERT INTO dbmail.dbmail_datefield (physmessage_id, datefield) VALUES
(45647,'2009-01-23 01:04:44')
INSERT INTO dbmail.dbmail_datefield (physmessage_id, datefield) VALUES
(45648,'2009-01-23 01:05:17')
INSERT INTO dbmail.dbmail_subjectfield (physmessage_id, subjectfield)
VALUES (45647,'Return Confirmation for ""Traitor""')
INSERT INTO dbmail.dbmail_subjectfield (physmessage_id, subjectfield)
VALUES (45648,'Return Confirmation for ""City of Ember""')
"unexpected EOF on client connection"
"disconnection: session time: 0:02:21.052 user=dbmail
database=mail_system host=<snip> port=43872
"unexpected EOF on client connection"
disconnection: session time: 0:02:22.198 user=dbmail
database=mail_system host=<snip> port=62758
--- SNIP ---
Here is what postfix reports:
Jan 23 05:23:47 mail2 postfix/lmtp[25883]: E36FB37D0046: to=<BR39290[at]siliconsea.net
>, relay=xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]:24, delay=15361,
delays=15360/0.38/0.17/0.61, dsn=4.4.2, status=deferred (lost
connection with xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx] while sending end of
data -- message may be sent more than once)
*********
What can I do to help figure this issue out?
*********
The system is an OpenSolaris system running NexentaCP 1.0.1, dbmail
was custom built along with certain dependencies.
root[at]mail1:/opt/dbmail/sbin# ldd dbmail-lmtpd
libdbmail.so.0 => /opt/dbmail/lib/dbmail/libdbmail.so.0
libgmime-2.0.so.2 => /opt/gmime220/lib/libgmime-2.0.so.2
libgmodule-2.0.so.0 => /usr/lib/libgmodule-2.0.so.0
libgthread-2.0.so.0 => /usr/lib/libgthread-2.0.so.0
libz.so.1 => /usr/lib/libz.so.1
libsocket.so.1 => /lib/libsocket.so.1
libnsl.so.1 => /lib/libnsl.so.1
libgobject-2.0.so.0 => /usr/lib/libgobject-2.0.so.0
libglib-2.0.so.0 => /usr/lib/libglib-2.0.so.0
libintl.so.3 => /lib/libintl.so.3
libc.so.1 => /lib/libc.so.1
libiconv.so.2 => /lib/libiconv.so.2
libcrypt.so.1 => /usr/lib/libcrypt.so.1
libresolv.so.2 => /lib/libresolv.so.2
libgcc_s.so.1 => /lib/libgcc_s.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libscf.so.1 => /lib/libscf.so.1
libgen.so.1 => /lib/libgen.so.1
libuutil.so.1 => /lib/libuutil.so.1
libm.so.2 => /lib/libm.so.2
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
signature.asc
