[Pkg-dspam-misc] Bug#719663: Postgresql driver leads to errors on console

[Erwan David]

Package: dspam
Version: 3.10.2+dfsg-8
Severity: normal

At each mail that dspam handles I get the following message on console :

WARNING:  nonstandard use of \\ in a string literal
LINE 1: ...ES (1,'520b09db156066170345973',1016,CURRENT_DATE,'\\x526563...

It reminds of a former bug in postgresql driver.



-- System Information:
Debian Release: jessie/sid
  APT prefers testing-proposed-updates
  APT policy: (900, 'testing-proposed-updates'), (900, 'testing'), (800, 'stable'), (500, 'proposed-updates'), (400, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.10-2-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages dspam depends on:
ii  libc6                2.17-92
ii  libdspam7            3.10.2+dfsg-8
ii  libdspam7-drv-pgsql  3.10.2+dfsg-8
ii  libpq5               9.1.9-2+b1
ii  lsb-base             4.1+Debian12
ii  perl                 5.14.2-21

Versions of packages dspam recommends:
ii  dspam-doc  3.10.2+dfsg-8
ii  procmail   3.22-20

Versions of packages dspam suggests:
ii  clamav-daemon      0.97.8+dfsg-1
ii  dspam-webfrontend  3.10.2+dfsg-8

-- Configuration Files:
/etc/default/dspam changed:
START=yes
USER=dspam
MAINTENANCE_OPTIONS="--with-sql-autoupdate --with-sql-optimization"
RUN_NOTIFY="yes"

/etc/dspam/default.prefs changed:
trainingMode=TEFT
spamAction=deliver
enableBNR=on
enableWhitelist=on
statisticalSedation=5
signatureLocation=headers
whitelistThreshold=10
showFactors=off

/etc/dspam/dspam.conf [Errno 13] Permission denied: u'/etc/dspam/dspam.conf'
/etc/dspam/dspam.d/extlookup.conf [Errno 13] Permission denied: u'/etc/dspam/dspam.d/extlookup.conf'
/etc/dspam/txt/firstrun.txt changed:
To: $u at rail.eu.org
From: Technical Support <support at rail.eu.org>
Subject: Spam Filtering is Active
Dear Valued Customer,
This email is to inform you that spam filtering has been activated on this account and provide you with some basic instructions to assist in filtering spam from your email. The filtering software we are using is called DSPAM and is capable of dynamically learning your specific email behavior. We have started you off with a pre-configured spam dictionary which will help filter a limited amount of spam immediately for you. As you continue to receive email, your specific email patterns will be learned by the spam software, which will result in increasing accuracy in catching spam. For this reason, it is important that you forward any spam you receive for this email account into the filtering software. By forwarding your spam, the software is capable of learning from its mistakes and will improve itself to do better next time.
To forward a spam into the system, please use the 'Forward' button in whatever email client you are using and send the spam to spam-$u at rail.eu.org. It is not necessary to provide an explanation of the message, as it will not be opened by a human, but processed by the software.
The software also quarantines all messages that it believes are spam. From time to time, you should check this quarantine to insure that it has not caught any legitimate email. This too plays a significant role in the learning process. To check your quarantine, use a web browser and go to the following URL:
https://mail.rail.eu.org/dspam/
You will be prompted for your username and password. Use the same login and password you use to check your email. From here, you can peruse your quarantine box. If any legitimate messages have been caught, click on the message and then click 'THIS IS NOT SPAM!'. The message will then be delivered and the software will re-learn so as not to make the same mistake next time. Once you have marked any legitimate messages, you may delete the messages in your quarantine by clicking the 'DELETE ALL' button at the bottom of the page.
Thank you, and please feel free to contact us if you have any questions.
Technical Support
support at rail.eu.org

/etc/dspam/txt/firstspam.txt changed:
To: $u at rail.eu.org
From: Technical Support <support at rail.eu.org>
Subject: Your first spam has been caught
Dear Valued Customer,
This email is to inform you that our spam filtering software, DSPAM, has caught its first spam for your account.  This message will only be sent once and contains useful information for accessing your quarantine box.
Your quarantine box contains all messages that our software believed were spam.  You should check your quarantine periodically to insure that no legitimate messages have been accidentally caught.  To check your quarantine, use a web browser and go to the following URL:
https://mail.rail.eu.org/dspam/
You will be prompted for your username and password.  Use the same login and password you use to check your email.  From here, you can peruse your quarantine box.  If any legitimate messages have been caught, click on the message and then click 'THIS IS NOT SPAM!'.  The message will then be delivered and the software will re-learn so as not to make the same mistake next time.  Once you have marked any legitimate messages, you may delete the messages in your quarantine by clicking the 'DELETE ALL' button at the bottom of the page.
Thank you, and please feel free to contact us if you have any questions.
Technical Support
support at rail.eu.org

/etc/dspam/txt/quarantinefull.txt changed:
To: $u at rail.eu.org
From: Technical Support <support at rail.eu.org>
Subject: Your quarantine box is getting full
Dear Valued Customer,
This email is to inform you that your spam quarantine box is growing quite large and should be checked to insure that no legitimate messages were caught.  
Your quarantine box contains all messages that our spam filtering software, DSPAM, believed were spam.  You should check your quarantine periodically to insure that no legitimate messages have been accidentally caught.  To check your quarantine, use a web browser and go to the following URL:
https://mail.rail.eu.org/dspam/
You will be prompted for your username and password.  Use the same login and password you use to check your email.  From here, you can peruse your quarantine box.  If any legitimate messages have been caught, click on the message and then click 'THIS IS NOT SPAM!'.  The message will then be delivered and the software will re-learn so as not to make the same mistake next time.  Once you have marked any legitimate messages, you may delete the messages in your quarantine by clicking the 'DELETE ALL' button at the bottom of the page.  
Thank you, and please feel free to contact us if you have any questions.
Technical Support
support at rail.eu.org


-- no debconf information