asterisk users - May 2007 - MySQL ** DBI connect failed : Too many connections**

http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html

Max connections is set to 100+1 by default.  Maybe you just need to
raise that number.  Otherwise, figure out why connections are staying
open if they are.

Thanks,
Steve Totaro
http://www.asteriskhelpdesk.com/component/option,com_wrapper/Itemid,37/
KB3OPB
 
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Doug Lytle
> Sent: Wednesday, May 02, 2007 7:20 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: [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."
> 
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

Steve Totaro wrote:
> http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
>   

Thanks for the link, I now have a few commands that I can try if it 
happens again.

Doug


-- 
 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."