ZM 1.9.5 BUG?: mysql threads are left open - please try this

[loop]

Hi,
I thought I've solved this problem but I didn't:
SUSE 9.1 PRO with original mysql and apache
ZM 1.9.5

After a few days using ZM suddenly after opening the ZM window in browser I cannot see the camera list in console any more. The problem is to high number of open connections in mysql.

You can check how many open mysql connections you have by typing in command prompt "mysql zm" and then in mysql type "status". Threads: ## shows the number of open mysql threads.

Threads ## is incremented for 1 or 2 when I click to view the real time video and it should come back to the previous number when I close the view window. But it doesn't, it is still higher for 1 or 2 then before I started the video. And when it comes to 100 mysql denies any more connections.

Please check if you experience similar problem, I don't know what could be the problem.

Best regards,
DN

[sdel]

what version of mysql is it? the only thing i might suggest is changing the persistant connection to a regular connection.

in zm_db.php, change the mysql_pconnect() function to mysql_connect()

this line in the file looks like this:

Code: Select all

$conn =mysql_pconnect( ZM_DB_SERVER, ZM_DB_USER, ZM_DB_PASS ) or die("Could not connect to database: ".mysql_error())ql_pconnect( ZM_DB_SERVER, ZM_DB_USER,
ZM_DB_PASS ) or die("Could not connect to database: ".mysql_error());

just change mysql_pconnect to mysql_connect. i don't have the same problem and i'm on mysql version 4.0.22 with php version 4.3.10.
________
Lincoln premiere

[loop]

Thank you sdel, that did the trick.

You say mysql on this SUSE9.1 PRO is making problems? Or just some setting? I'm asking this because I also wrote some java application to browse the zm mysql databases.

mysql --version gives:
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)

Regards, DN

[sdel]

i don't understand why it would be a SUSE thing exclusively. you are on an old version of php. perhaps that may be causing the problem.

does SUSE have a package manager that makes it easy to upgrade php and mysql? php very well may be the problem.
________
Top penny stocks