Doug Lytle
2007-May-02 04:19 UTC
[asterisk-users] MySQL ** DBI connect failed : Too many connections **
Hey everybody, I'm hoping someone can look over the below statement and tell me if I've got something wrong. Yesterday, after running the MySQL addon version 1.2.4 under Asterisk 1.2.17 for a couple months, I started to get connection failures for one of my systems. Logging into the webmin module for MySQL, I saw the above error. I'm currently running MySQL 4.1.12. Am I doing something wrong? exten => s,4,MYSQL(Connect connid 192.168.101.25 anonymous '' speeddials) exten => s,5,MYSQL(Query resultid ${connid} SELECT phone \, name FROM company WHERE number = ${ARG1}) exten => s,6,MYSQL(Fetch fetchid ${resultid} speed.dial speed.name) exten => s,7,MYSQL(Disconnect ${connid}) exten => s,8,MYSQL(Clear ${resultid}) I have several sections like the above that are run on inbound calls. One to check the inbound phone number against our speed dials and if a match, set caller-id name. One to check for blacklisted numbers. One to check if it's a holiday or not. Did I do something wrong on the disconnect? Any suggestions would be appreciated. Doug -- Ben Franklin quote: "Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."