The mailing list for listmasters using Sympa

[Michelle Murrain <address@concealed>]

Johann Spies wrote:
> I am new to this list.  Searching on google did not really answer my
> question.
>
> I am trying to get sympa to work with postgresql on Debian Woody.  The
> installation script did not succeed in the configuration.  What I did
> then, was to become user postgres, create a postgresql-user and
> database "sympa", and use psql with the sample script
> /usr/share/doc/sympa/examples/config/create_db.Pg to create the
> correct table(s).
>
> 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.

This looks like a standard postgresql security issue, rather than a 
sympa question.

The basic problem I see is that you have md5 admins as the 
authentication scheme, and it should be "password".

That should solve your problem, because everything else looks fine. (And 
using a blank password is a Bad Idea - add a password to the sympa user 
by updating that line in pg_shadow.
--
.Michelle

--------------------------
Michelle Murrain
mmurrain at dbdes dot com
413-222-6350 ph
617-889-0929 ph
952-674-7253 fax <--- new
Page: address@concealed
AIM:pearlbear0 ICQ:129250575
Y!: michelle_murrain Jabber: address@concealed

"Work like you don't need the money. Love like you've never been hurt. 
Dance like nobody's watching." - Satchel Paige