Hi.
I try to migrate to a new server. On the new server an Ubuntu 12.04 is
running. The DSPAM version is 3.10.1, installed from the Ubuntu
Repositories. PostgreSQL is in version 9.1 installed, also via Ubuntu
Repositories.
The problem is, that I always get an
dspam[15233]: FATAL: password authentication failed for user "dspam"
If I try to connect to the dspam DB via socket or TCP/IP connections
with the psql program, the connection works. I've copied the password
from dspam's postgres config file, so it cannot be an typo.
This is the pg_hba.conf:
-- snip --
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all dspam md5
local all all peer
local all sqlgrey peer
##local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
-- snap --
And this is the pgsql.conf:
-- snip --
#PgSQLServer 127.0.0.1
PgSQLServer /var/run/postgresql
PgSQLPort 5432
PgSQLUser dspam
PgSQLPass V3ryS3cr3TP4ssw0rd
PgSQLDb dspam
-- snap --
First I got some gotchas, but found this in the logs:
ERROR: invalid byte sequence for encoding "UTF8"
so I reconfigured postgres and set
standard_conforming_strings=off
And now DSPAM is unwilling to work :(
Any hints or ideas?
Thanks in advance.
Cheers,
Holger
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
