On Sun, Aug 05, 2012 at 04:19:44PM +0200, Holger wrote: > 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 >
You need to use dspam-3.10.2. It includes support for PostgreSQL 9.1. Cheers, Ken ------------------------------------------------------------------------------ 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
