Mysql connections not closing.

[funkho]

All,

I have searched, but was unable to find anything regarding an issue I am having. I have Teamspeak installed on a Linux server, and I have configured it to use mySQL. The only thing I have done to customize the server is to hack the SQL statements so that the passwords are now md5 encrypted. This works like a champ, but I have another issue.

For some reason, the mysql connections being made from the teamspeak server do not appear to be dying. Eventually, mysql runs out of open connections available to it and the server no longer works.

The only change I made to the SQL is the following:

cat read_client_login.sql
select * from ts2_clients where i_client_server_id = :iServerID and s_client_name = :sName and s_client_password=md5(:sPassword)

Then, I update the user table with md5 passwords.

This is all working wonderfully, and I'm quite happy with it. However, I keep having to restart the mysql server because of too many open connections.

Is anyone else seeing this kind of issue with their TS server reading from a mysql database?

Here is the server info..
mysql server version: 4.1.12-standard
Linux kernel: 2.6.5-1.358

Any help would be greatly appreciated.

Thanks...

[louig1]

well if ts dosn't keep the open connections then the server will freeze and no one can connect the best thing you can do is change the max connections on your box check the my.cnf file it should be /etc or /etc/mysql depending on your server config.