Subject: pkg/23577: Sympa does not work with PostgreSQL.
To: None <>
From: None <>
List: netbsd-bugs
Date: 11/26/2003 16:34:34
>Number:         23577
>Category:       pkg
>Synopsis:       Sympa does not work with PostgreSQL.
>Confidential:   no
>Severity:       critical
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Wed Nov 26 16:35:00 UTC 2003
>Originator:     Curt Sampson
>Release:        NetBSD 1.6ZE
System: NetBSD 1.6ZE NetBSD 1.6ZE (GENERIC_DIAGNOSTIC) #0: Thu Nov 6 22:42:40 JST 2003 i386
Architecture: i386
Machine: 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