aC forum: MySQL connections not disconnecting http://www.activecollab.com/forums/topic/2583/ Recent posts on topic: MySQL connections not disconnecting en-us Sat, 30 Aug 2008 15:30:00 UTC http://www.activecollab.com/forums/post/12076/#post12076 http://www.activecollab.com/forums/post/12076/#post12076 Post #3 by Ilija Studen Ilija Studen You are talking about v1.0 or v0.7.1?

activeCollab 1.0 always opens persistent connections. In order to use mysql_connect() instead of mysql_pconnect() open AngieApplication class located in /activecollab/angie/classes/application/AngieApplication.class.php and change this line:

$database_connect = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, true, DB_CHARSET);


Into:

$database_connect = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, false, DB_CHARSET);

]]> Wed, 12 Mar 2008 16:53:53 UTC http://www.activecollab.com/forums/post/12075/#post12075 http://www.activecollab.com/forums/post/12075/#post12075 Post #2 by vrillusions vrillusions After doing more searching I found the options to fix it on the mysql end (source). Important lines from that are wait_timeout=60 and interactive_timeout=120. Both default to 28800 seconds, or 8 hours... yeah. I kept the wait timeout at 60 but set interactive to 300 seconds since I'll be on there to debug queries every so often.

]]> Wed, 12 Mar 2008 16:39:26 UTC http://www.activecollab.com/forums/post/12074/#post12074 http://www.activecollab.com/forums/post/12074/#post12074 Post #1 by vrillusions vrillusions Someone reported this issue in 0.7.1 at http://www.activecollab.com/forums/topic/1413/ but thought I'd reopen it here as it's still occurring.

My configuration:
Debian 4.0
Apache 2.2.3
PHP 5.2.0
MySQL 5.0.32

Problem is config/config.php doesn't have a DB_PERSIST option. When I add it and set it to false, it makes no difference. I am pretty sure I just used the my-large.cnf sample config file and tweaked a couple settings as needed. Is there any other way to disable DB_PERSIST and/or just fix mysql so it doesn't hold open connections?

]]> Wed, 12 Mar 2008 16:20:42 UTC