The mailing list for listmasters using Sympa

[Straub Herbert <address@concealed>]

Title: AW: [sympa-users] Sympa and Postgresql on Debian Woody

I'm using the following configuration (Debian Woody):
/etc/sympa/sympa.conf:
host         all         127.0.0.1     255.0.0.0           password

and /etc/sympa/sympa.conf:
## Database driver (DBD)
db_type         Pg

## Name of your database
db_name         sympa

## Your database hostname
db_host         localhost

## Username to connect to the DB
db_user         myuser

## Password for the user
db_passwd       topsecret

#-- Database configuration end

And don't forget the Postgresql Table Permissions:
psql -U sympa sympa
sympa=> \dp
       Access privileges for database "sympa"
      Table       |        Access privileges
------------------+---------------------------------
 subscriber_table | {=,postgres=arwdRxt,sympa=arwd}
 user_table       | {=,postgres=arwdRxt,sympa=arwd}
(2 rows)

sympa=>

HTH Herbert Straub

-----Ursprüngliche Nachricht-----
Von: Johann Spies
Betreff: [sympa-users] Sympa and Postgresql on Debian Woody

I then put the following in /etc/sympa/sympa.conf:

# Database
db_type Pg
db_name sympa
db_host localhost
db_port 5432
db_user sympa
db_passwd ""

In my /etc/postgresql/pg_hba.conf I have:

local        all                                          ident sameuser
host         all         127.0.0.1      255.0.0.0          md5 admins
host         rtad4email  <ip>           255.255.255.255    md5 admins
host         rtad4email  <ip>           255.255.255.255    md5 admins
host         all         0.0.0.0       0.0.0.0             reject

So I thought then a password for sympa would not work because when user sympa access database sympa the first line would kick in.

Any advice on how to get it working would be appreciated.