The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=825
======================================================================
Reported By: Marv-CZ
Assigned To: paul
======================================================================
Project: DBMail
Issue ID: 825
Category: POP3 daemon
Reproducibility: always
Severity: crash
Priority: normal
Status: resolved
target:
Resolution: fixed
Fixed in Version: 2.3.7
======================================================================
Date Submitted: 04-Jan-10 08:21 CET
Last Modified: 04-Jan-10 11:50 CET
======================================================================
Summary: POP3D crash with SQL syntax error
Description:
Jan 4 08:16:47 talita postgres[836]: [2-2] STATEMENT: INSERT INTO
dbmail_authlog (userid, service, login_time, logout_time, src_ip, src_port,
dst_ip, dst_port, status)
Jan 4 08:16:47 talita postgres[836]: [2-3] VALUES
('vilem.oz...@manet.cz', 'pop3', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,
'80.188.116.45', 1299, '212.96.160.175', 110,
Jan 4 08:16:47 talita postgres[836]: [2-4] ''active'') RETURNING id
Jan 4 08:24:58 talita postgres[2754]: [2-1] ERROR: syntax error at or
near "active" at character 241
Jan 4 08:24:58 talita postgres[2754]: [2-2] STATEMENT: INSERT INTO
dbmail_authlog (userid, service, login_time, logout_time, src_ip, src_port,
dst_ip, dst_port, status)
Jan 4 08:24:58 talita postgres[2754]: [2-3] VALUES
('vilem.oz...@manet.cz', 'pop3', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,
'80.188.116.45', 1311, '212.96.160.175', 110,
Jan 4 08:24:58 talita postgres[2754]: [2-4] ''active'') RETURNING id
Jan 4 08:24:58 talita kernel: pid 2753 (dbmail-pop3d), uid 65534: exited
on signal 6
Jan 4 08:25:22 talita postgres[2801]: [2-1] ERROR: syntax error at or
near "active" at character 241
Jan 4 08:25:22 talita postgres[2801]: [2-2] STATEMENT: INSERT INTO
dbmail_authlog (userid, service, login_time, logout_time, src_ip, src_port,
dst_ip, dst_port, status)
Jan 4 08:25:22 talita postgres[2801]: [2-3] VALUES
('vilem.oz...@manet.cz', 'pop3', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,
'80.188.116.45', 1319, '212.96.160.175', 110,
Jan 4 08:25:22 talita postgres[2801]: [2-4] ''active'') RETURNING id
Jan 4 08:25:22 talita kernel: pid 2800 (dbmail-pop3d), uid 65534: exited
on signal 6
======================================================================
----------------------------------------------------------------------
(0002969) paul (administrator) - 04-Jan-10 11:50
http://www.dbmail.org/mantis/view.php?id=825#c2969
----------------------------------------------------------------------
fixed in my master branch
Issue History
Date Modified Username Field Change
======================================================================
04-Jan-10 08:21 Marv-CZ New Issue
04-Jan-10 11:47 jasb Issue Monitored: jasb
04-Jan-10 11:50 paul Note Added: 0002969
04-Jan-10 11:50 paul Assigned To => paul
04-Jan-10 11:50 paul Status new => resolved
04-Jan-10 11:50 paul Resolution open => fixed
04-Jan-10 11:50 paul Fixed in Version => 2.3.7
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
