Developers of Sympa

[Straub Herbert <address@concealed>]

Title: List.pm::db_connect with Postgresql V 7.1 Error

I use debian sid (unstable) and after the last upgrade the following error occured (sympa.log)

May 16 12:19:55 koala postgres[16693]: [1] DEBUG:  connection: host=[local] user=sympa database=sympa@localhost
May 16 12:19:55 koala postgres[16693]: [2] FATAL 1:  Database "sympa@localhost" does not exist in the system catalog.
May 16 12:19:55 koala bounced[16690]: Can't connect to Database DBI:Pg:dbname=sympa\@localhost as sympa

I changed the connect string in List::db_connect

from

$connect_string = sprintf 'DBI:%s:dbname=%s\@%s', $Conf{'db_type'}, $Conf{'db_name'}, $Conf{'db_host'};

to

$connect_string = sprintf 'DBI:%s:dbname=%s;host=%s', $Conf{'db_type'}, $Conf{'db_name'}, $Conf{'db_host'};

for the db_type "Pg" and then sympa works.

Versions:

Debian: sid
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name           Version        Description
+++-==============-==============-============================================
ii  sympa          3.0.3-5        Modern mailing list manager
ii  sympa-db       3.0.3-5        Database support for Sympa                   
ii  wwsympa        3.0.3-5        Web interface for administrating Sympa
ii  postgresql     7.1.1-2        Object-relational SQL database, descended fr
ii  postgresql-cli 7.1.1-2        Front-end programs for PostgreSQL
ii  postgresql-doc 7.1.1-2        Documentation for the PostgreSQL database.
ii  libdbi-perl    1.15-1         The Perl5 Database Interface by Tim Bunce
ii  libdbd-pg-perl 0.98-1         a PostgreSQL interface for Perl 5 using DBI. 

Herbert Straub