"too many connections to db"- err

Forum for questions and support relating to the 1.26.x releases only.
Locked
uzid
Posts: 4
Joined: Sun Jan 19, 2014 2:47 pm

"too many connections to db"- err

Post by uzid »

hello,
when im connecting more the 15 cammrers to the "zonminder"
im getting this err""too many connections to db"

how can i provent this err ?

best regards
uzi
chippy99
Posts: 66
Joined: Wed Aug 30, 2006 5:38 pm
Location: Barnet, Herts. UK

Re: "too many connections to db"- err

Post by chippy99 »

I think mysql defaults to 150 connections so unless you have set the variable max_connections to a lower figure this is surprising. Try typing mysql -uroot -p'whatever_password_is' and then at mysql> prompt type 'show processlist'. This will show number of active connections. To increase number of permitted connections you need to edit your mysql configuration file, normally in /etc/mysql/my.cnf and set max_connections to an appropriate value and then restart mysql ( shutdown ZM before doing this).
Locked