>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
>Closed-Date:
>Last-Modified:
>Originator:     Curt Sampson
>Release:        NetBSD 1.6ZE
>Organization:
>Environment:
System: NetBSD laconic.cynic.net 1.6ZE NetBSD 1.6ZE (GENERIC_DIAGNOSTIC) #0: Thu Nov 6 22:42:40 JST 2003 cjs@ironic.cynic.net:/u/netbsd/build/i386-current/obj/u/netbsd/src-current/sys/arch/i386/compile/GENERIC_DIAGNOSTIC i386
Architecture: i386
Machine: i386
>Description:

    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.

>How-To-Repeat:

    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.

>Fix:

    Upgrade sympa to version 3.4.4.3.
>Release-Note:
>Audit-Trail:
>Unformatted: