Page 1 of 1

"too many connections to db"- err

Posted: Sun Jan 19, 2014 2:52 pm
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

Re: "too many connections to db"- err

Posted: Mon Jan 20, 2014 12:54 am
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).