Developers of Sympa

[Olivier LACROIX <address@concealed>]

Hello.

I found a problem when using postgres.

When sympa is started, it initialises the connection with the database. I saw 
that in debug, the connection kept actiove, but not in the "normal" mode. 
However, in the code, the test :
        ## Check database connection
        unless ($dbh and $dbh->{Active}) {
                return undef unless &db_connect();
        }
returns true, so the db_connect function was never restarted.

In fact, in the normal mode, when the fork is done, the sympa starting 
process 
exits ... and the connection to postgres was closed (it is a normal 
operation). But the test  $dbh and $dbh->{Active} always returns true.


So I patch sympa.pl to start another times the database connection after the 
fork and it's ok.

But if the postgres daemon (postmaster) is stopped and restarted, the problem 
appears again.

Is this problem exist only with postgres ?
-- 

 Olivier LACROIX

 C.I.R.I.L.
 Cellule Réseau StanNet
 Chateau du Montet      |  Tel   : +33 3.83.44.74.29
 Rue du Doyen Roubault  |  Fax   : +33 3.83.44.02.62
 F - 54500 VANDOEUVRE   |  email : address@concealed