[Serusers] ser can't connect to a remote Mysql database

[Marian Dumitru]

Hi Trung,

your mysql server exceeds the maximum number of connections. To fix this 
just modify in /etc/mysql.my.cnf in [mysqld] section:
	set-variable = max_connections=200

Best regards,
Marian


Trung Nguyen wrote:
> Hi there,
>    I have been looking into the forum for help on this
> issue, but I can't find it. This is the error I got:
> -----
>  1(0) DEBUG: callid: '77eaadff-0 at 172.16.10.11'
>  1(0) DEBUG: init_mod_child (-1): usrloc
>  1(17163) DBG: open_uac_fifo: opening fifo...
>  1(17163) DEBUG: FIFO created @ /tmp/ser_fifo
>  1(17163) DEBUG: fifo /tmp/ser_fifo opened, mode=432
>  2(0) INFO: fifo process starting: 17164
>  2(0) DEBUG: init_mod_child (-2): tm
>  2(0) DEBUG: callid: '77eaadff-0 at 172.16.10.11'
>  2(0) DEBUG: init_mod_child (-2): usrloc
>  1(17163) DEBUG: init_mod_child (-1): acc
>  2(17164) DEBUG: init_mod_child (-2): acc
>  1(17163) DEBUG: init_mod_child (-1): nathelper
>  1(17163) rtpp_test: RTP proxy found, support for it
> enabled
>  1(17163) DEBUG: init_mod_child (-1): domain
>  1(17163) DEBUG: init_mod_child (-1): group
>  1(17163) connect_db(): Can't connect to local MySQL
> server through socket '/tmp/mysql.sock' (2)
>  1(17163) db_init(): Error while trying to connect
> database
>  1(17163) group:init_child(): Unable to connect
> database
>  1(17163) init_mod_child(): Error while initializing
> module group
>  2(17164)  1(17163) connect_db(): Too many connections
> timer: init_child failed
>  2(17164) db_init(): Error while trying to connect
> database
>  2(17164) acc:init_child(): Unable to connect database
>  2(17164) init_mod_child(): Error while initializing
> module acc
>  1(17163)  2(17164) INFO: signal 15 received
> ERROR: open_uac_fifo: init_child failed
>  1(17163)  2(17164) Memory status (pkg):
> opening fifo server failed
>  1(17163) fm_status (0x80c2b20):
>  1(17163)  heap size= 1047440
>  1(17163) dumping free list:
>  1(17163) hash =   1 fragments no.:     7,
> ----------------------
> 
> Here's my ser.cfg
> ------------------
> 
> # $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei
> Exp $
> #
> # simple quick-start config script
> #
> 
> # ----------- global configuration parameters
> ------------------------
> 
> debug=7         # debug level (cmd line: -dddddddddd)
> #fork=yes
> log_stderror=yes        # (cmd line: -E)
> 
> /* Uncomment these lines to enter debugging mode
> debug=7
> fork=no
> log_stderror=yes
> */
> listen=172.16.10.11
> 
> check_via=no    # (cmd. line: -v)
> dns=no           # (cmd. line: -r)
> rev_dns=no      # (cmd. line: -R)
> #port=5060
> #children=4
> fifo="/tmp/ser_fifo"
> 
> # ------------------ module loading
> ----------------------------------
> 
> # Uncomment this if you want to use SQL database
> loadmodule "/usr/local/lib/ser/modules/mysql.so"
> 
> loadmodule "/usr/local/lib/ser/modules/sl.so"
> loadmodule "/usr/local/lib/ser/modules/tm.so"
> loadmodule "/usr/local/lib/ser/modules/rr.so"
> loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
> loadmodule "/usr/local/lib/ser/modules/usrloc.so"
> loadmodule "/usr/local/lib/ser/modules/acc.so"
> loadmodule "/usr/local/lib/ser/modules/registrar.so"
> loadmodule "/usr/local/lib/ser/modules/nathelper.so"
> loadmodule "/usr/local/lib/ser/modules/domain.so"
> loadmodule "/usr/local/lib/ser/modules/textops.so"
> loadmodule "/usr/local/lib/ser/modules/group.so"
> 
> # Uncomment this if you want digest authentication
> # mysql.so must be loaded !
> loadmodule "/usr/local/lib/ser/modules/auth.so"
> loadmodule "/usr/local/lib/ser/modules/auth_db.so"
> 
> # ----------------- setting module-specific parameters
> ---------------
> 
> # -- usrloc params --
> 
> #modparam("usrloc", "db_mode",   0)
> 
> # Uncomment this if you want to use SQL database
> # for persistent storage and comment the previous line
> modparam("usrloc", "db_mode", 2)
> modparam("usrloc", "db_url",
> "mysql://ser:heslo@172.16.10.10/ser")
> 
> # -- auth params --
> # Uncomment if you are using auth module
> #
> modparam("auth_db", "calculate_ha1", yes)
> #
> # If you set "calculate_ha1" parameter to yes (which
> true in this config),
> # uncomment also the following parameter)
> #
> modparam("auth_db", "password_column", "password")
> modparam("auth_db", "db_url",
> "mysql://ser:heslo@172.16.10.10/ser")
> #modparam("auth_db", "use_rpid", 1)
> #modparam("auth", "rpid_prefix", "<sip:")
> #modparam("auth", "rpid_suffix",
> "@unlimitedtalk.net>;party=calling;privacy=full;screen=yes")
> 
> # --acc params--
> modparam("acc", "log_level", 1)
> modparam("acc", "log_flag", 1)
> modparam("acc", "log_missed_flag", 2)
> modparam("acc", "log_fmt", "fimos")
> modparam("acc", "db_url",
> "mysql://ser:heslo@172.16.10.10/ser")
> modparam("acc", "db_missed_flag", 2)
> modparam("acc", "db_flag", 1)
> # -- rr params --
> # add value to ;lr param to make some broken UAs happy
> modparam("rr", "enable_full_lr", 1)
> 
> # !! Nathelper
> modparam("registrar", "nat_flag", 6)
> modparam("nathelper", "natping_interval", 30) # Ping
> interval 30 s
> modparam("nathelper", "ping_nated_only", 1)   # Ping
> only clients behind NAT
> -----------------
> 
> Any help or guidance will be very appreciated.
> 
> 
> Thank you,
> Trung
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Check out the new Yahoo! Front Page. 
> www.yahoo.com 
>  
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 

-- 
Voice Sistem
http://www.voice-sistem.ro