FengOffice-OpenGoo not closing MySQL connections

[gopala]

Hi,

I see a problem with openGoo that I have on a windows server, using apache and mysql version 5.1


When I run "SHOW PROCESSLIST" I see a lot of open connections for the database opengoo, and they are all in sleep mode. The time value is way beyond the execution time, sometimes it went to high as 2000 seconds!

I tried changing the config to use non-persistent connections, but it stayed the same.

I have another 8 different php applications that all use mysql on the same server, using the same apache, and none of them has this problem.

I saw this issue on version 1.5.3, and now I upgraded to 1.6 and the problem remains.

Thank you,
Gopala

[ignacio]

Database connections should be closed automatically after the script finishes executing, as stated here.

But try if this solves your problem. Edit file 'application/functions.php', line 45 and change from:

Code: [Select]

function __shutdown() {
$logger_session = Logger::getSession();
to:

Code: [Select]

function __shutdown() {
DB::close();
$logger_session = Logger::getSession();

Or add DB::close(); at the end of file 'init.php', before the ?> characters.