Subject: pkg/23577: Sympa does not work with PostgreSQL.
To: None <firstname.lastname@example.org>
From: None <email@example.com>
Date: 11/26/2003 16:34:34
>Synopsis: Sympa does not work with PostgreSQL.
>Arrival-Date: Wed Nov 26 16:35:00 UTC 2003
>Originator: Curt Sampson
>Release: NetBSD 1.6ZE
System: NetBSD laconic.cynic.net 1.6ZE NetBSD 1.6ZE (GENERIC_DIAGNOSTIC) #0: Thu Nov 6 22:42:40 JST 2003 firstname.lastname@example.org:/u/netbsd/build/i386-current/obj/u/netbsd/src-current/sys/arch/i386/compile/GENERIC_DIAGNOSTIC i386
Sympa does not work at all if you use PostgreSQL as the database.
This is because the current pkgsrc version of PostgreSQL has schema
support, and the current pkgsrc version of DBD-Pg returns the schema
names in the tables list, but sympa doesn't understand the schema
names, thinks that its tables are not present, and thus the various
programs refuse to start.
Note that using a database is not optional with sympa; it's required.
Install mail/sympa and databases/postgresql. Configure sympa to use the
Pg DBD driver ("db_type Pg" in the config file) and create the database
schema. Note that none of the sympa programs can start because they
believe that their tables do not exist in the database.
Upgrade sympa to version 126.96.36.199.