Re: [sr-dev] [SR-Users] openser db on an external mysql server

Dear Shahzad, Please find the debug detail kamailio -dd -D 2 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring asterisk.bindip 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring asterisk.bindport 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring kamailio.bindip 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring kamailio.bindport 0(4971) DEBUG: <core> [cfg.y:1785]: loading modules under /usr/local/lib64/kamailio/modules_k/:/usr/local/lib64/kamailio/modules/ loading modules under /usr/local/lib64/kamailio/modules_k/:/usr/local/lib64/kamailio/modules/ 0(4971) DEBUG: <core> [cfg.y:1772]: loading module db_mysql.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/db_mysql.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/db_mysql/db_mysql.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/db_mysql.so> 0(4971) DEBUG: <core> [db_query.c:375]: About to allocate sql_buf size = 65535 0(4971) DEBUG: <core> [cfg.y:1772]: loading module mi_fifo.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/mi_fifo.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module kex.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/kex.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: kex 0(4971) DEBUG: <core> [cfg.y:1772]: loading module tm.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/tm.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/tm/tm.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/tm.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module tmx.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/tmx.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: tmx 0(4971) DEBUG: <core> [cfg.y:1772]: loading module sl.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sl.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sl/sl.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/sl.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module rr.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/rr.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: rr 0(4971) DEBUG: <core> [cfg.y:1772]: loading module pv.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/pv.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: pv 0(4971) DEBUG: <core> [cfg.y:1772]: loading module maxfwd.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/maxfwd.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module usrloc.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/usrloc.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module registrar.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/registrar.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: registrar 0(4971) DEBUG: <core> [cfg.y:1772]: loading module textops.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/textops.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module siputils.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/siputils.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module xlog.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/xlog.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: xlog 0(4971) DEBUG: <core> [cfg.y:1772]: loading module sanity.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sanity.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sanity/sanity.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/sanity.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module ctl.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/ctl.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/ctl/ctl.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/ctl.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module cfg_rpc.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/cfg_rpc.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/cfg_rpc/cfg_rpc.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/cfg_rpc.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module mi_rpc.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/mi_rpc.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/mi_rpc/mi_rpc.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/mi_rpc.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module acc.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/acc.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module auth.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/auth.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/auth/auth.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/auth.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module auth_db.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/auth_db.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module debugger.so 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/debugger.so> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/debugger/debugger.so> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/debugger.so> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module uac.so 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/uac.so> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: uac 0(4971) DEBUG: <core> [mem/f_malloc.c:293]: fm_malloc_init: F_OPTIMIZE=16384, /ROUNDTO=2048 0(4971) DEBUG: <core> [mem/f_malloc.c:295]: fm_malloc_init: F_HASH_SIZE=2099, fm_block size=33896 0(4971) DEBUG: <core> [mem/f_malloc.c:296]: fm_malloc_init(0x7ffbe2e78000, 33554432), start=0x7ffbe2e78000 0(4971) DEBUG: <core> [mem/shm_mem.c:203]: shm_mem_init: success 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'mi_fifo' matches module 'mi_fifo' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <fifo_name> in module mi_fifo [/usr/local/lib64/kamailio/modules_k/mi_fifo.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <fifo_name> in module mi_fifo [/usr/local/lib64/kamailio/modules_k/mi_fifo.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' matches module 'tm' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <failure_reply_mode> in module tm [/usr/local/lib64/kamailio/modules/tm.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <failure_reply_mode> in module tm [/usr/local/lib64/kamailio/modules/tm.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' matches module 'tm' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <fr_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <fr_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' matches module 'tm' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <fr_inv_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <fr_inv_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'rr' matches module 'rr' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <enable_full_lr> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <enable_full_lr> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'rr' matches module 'rr' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <append_fromtag> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <append_fromtag> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'registrar' matches module 'registrar' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <method_filtering> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <method_filtering> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'registrar' matches module 'registrar' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <max_expires> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <max_expires> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'registrar' matches module 'registrar' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <gruu_enabled> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <gruu_enabled> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <early_media> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <early_media> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <report_ack> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <report_ack> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <report_cancels> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <report_cancels> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <detect_direction> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <detect_direction> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID [FLT_ACC] value [1] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <log_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <log_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID [FLT_ACCMISSED] value [2] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <log_missed_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <log_missed_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <log_extra> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <log_extra> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID [FLT_ACCFAILED] value [3] 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc' 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <failed_transaction_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <failed_transaction_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so] On Tue, Feb 12, 2013 at 6:38 PM, Muhammad Shahzad < shaheryarkh(a)gmail.com&gt; wrote: > These are not debug logs. I need to see what happens before below line, > > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: > db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on > '192.168.1.170' (4) > > You can enabled debug log either by setting line 143 to 5 OR define > WITH_DEBUG. > > Thank you. > > > On Tue, Feb 12, 2013 at 2:00 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: > >> Dear Shahzad , >> >> Please find the error >> >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >> auth_db [authdb_mod.c:174]: unable to connect to the database >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >> <core> [sr_module.c:896]: init_mod_child(): Error while initializing module >> auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >> <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 2, >> pid 4424, "udp receiver child=1 sock=127.0.0.1:5060" >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: : <core> >> [main.c:1625]: main_loop: Cannot fork >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >> auth_db [authdb_mod.c:174]: unable to connect to the database >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >> <core> [sr_module.c:896]: init_mod_child(): Error while initializing module >> auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >> <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 5, >> pid 4427, "udp receiver child=0 sock=192.168.1.101:5060" >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: : <core> >> [main.c:1625]: main_loop: Cannot fork >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: >> auth_db [authdb_mod.c:174]: unable to connect to the database >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4430]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4431]: ERROR: >> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >> '192.168.1.170' (4) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4439]: : <core> >> [pass_fd.c:293]: ERROR: receive_fd: EOF on 16 >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: >> <core> [sr_module.c:896]: init_mod_child(): Error while initializing module >> auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so) >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: >> auth_db [authdb_mod.c:174]: unable to connect to the database >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: >> usrloc [ul_mod.c:407]: child(1): failed to connect to database >> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: >> <core> [db.c:320]: could not add connection to the pool >> >> With Regards N.Prakash > >> >> On Tue, Feb 12, 2013 at 6:23 PM, Muhammad Shahzad < >> shaheryarkh(a)gmail.com&gt; wrote: >> >>> kamailio.cfg looks OK, can you increase the debug level to 4+, start >>> kamailio and send me logs? May be we can find something in logs. >>> >>> Thank you. >>> >>> >>> On Tue, Feb 12, 2013 at 1:40 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >>> >>>> >>>> Hi Govoiper >>>> >>>> Free Memory on my server 2309 MB >>>> >>>> total used free shared >>>> buffers cached >>>> Mem: 2795 486 2309 0 70 >>>> 180 >>>> -/+ buffers/cache: 234 2561 >>>> Swap: 2927 0 2927 >>>> >>>> >>>> *Kamailio error:* >>>> * >>>> * >>>> ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio >>>> start failed >>>> >>>> >>>> *tail -f /var/log/messages:* >>>> >>>> >>>> Feb 12 23:41:28 localhost /usr/local/sbin/kamailio[4280]: INFO: >>>> <core> [udp_server.c:230]: INFO: udp_init: SO_RCVBUF is finally 262142 >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: >>>> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >>>> '192.168.1.170' (4) >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: >>>> <core> [db.c:320]: could not add connection to the pool >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: >>>> usrloc [ul_mod.c:407]: child(1): failed to connect to database >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: >>>> <core> [sr_module.c:896]: init_mod_child(): Error while initializing module >>>> usrloc (/usr/local/lib64/kamailio/modules_k/usrloc.so) >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>>> db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on >>>> '192.168.1.170' (4) >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>>> <core> [db.c:320]: could not add connection to the pool >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>>> auth_db [authdb_mod.c:174]: unable to connect to the database >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>>> <core> [sr_module.c:896]: init_mod_child(): Error while initializing module >>>> auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so) >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>>> <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 3, >>>> pid 4283, "udp receiver child=2 sock=127.0.0.1:5060" >>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : <core> >>>> [main.c:1625]: main_loop: Cannot fork >>>> >>>> With Regards >>>> >>>> N.Prakash >>>> >>>> ---------- Forwarded message ---------- >>>>> From: SamyGo &lt;govoiper(a)gmail.com&gt; >>>>> Date: Tue, Feb 12, 2013 at 5:49 PM >>>>> Subject: Re: [SR-Users] [sr-dev] openser db on an external mysql >>>>> server >>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) >>>>> - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt; >>>>> Cc: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt;om>, >>>>> sr-dev(a)lists.sip-router.org, Prabhakaran B < >>>>> prabhakaran(a)tevatel.com&gt;gt;, Indu Priya &lt;indu(a)tevatel.com&gt; >>>>> >>>>> >>>>> Hi Prakash, >>>>> >>>>> Please paste All ERROR appearing and Warnings when you start your >>>>> kamailio. What is the free memory situation on your server ? >>>>> >>>>> Regards, >>>>> Sammy >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Feb 12, 2013 at 5:12 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >>>>> >>>>>> Hi Muhammad, >>>>>> >>>>>> Yes, I have define Mysql on top in Kamailio.cfg >>>>>> >>>>>> DBURL "mysql://openser:openserrw@192.168.1.170/openser" >>>>>> >>>>>> >>>>>> I have attached Kamailio.cfg ,please advice >>>>>> >>>>>> With Regards >>>>>> >>>>>> N.Prakash >>>>>> >>>>>> >>>>>> On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad < >>>>>> shaheryarkh(a)gmail.com&gt; wrote: >>>>>> >>>>>>> What is your connection string in kamailio i.e. DBURL? Also make >>>>>>> sure you have defined WITH_MYSQL on the top of kamailio.cfg to load >>>>>>> necessary drivers. >>>>>>> >>>>>>> #!define WITH_MYSQL >>>>>>> >>>>>>> Thank you. >>>>>>> >>>>>>> >>>>>>> On Tue, Feb 12, 2013 at 12:56 PM, Prakash N < >>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>> >>>>>>>> Hi Shahzad , >>>>>>>> >>>>>>>> It is not ,We can able to connect remote mysql ( please >>>>>>>> find the detail below),moreover we can able create openser db from Kamailio >>>>>>>> server to remote mysql server >>>>>>>> >>>>>>>> *Mysql server : 192.168.1.170* >>>>>>>> *Kamailio server : 192.168.1.101* >>>>>>>> >>>>>>>> >>>>>>>> *Mysql output :* >>>>>>>> * >>>>>>>> * >>>>>>>> *mysql -u openser -h 192.168.1.170 -p* >>>>>>>> Enter password: >>>>>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>>>>> Your MySQL connection id is 68 >>>>>>>> Server version: 5.1.67 Source distribution >>>>>>>> >>>>>>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All >>>>>>>> rights reserved. >>>>>>>> >>>>>>>> Oracle is a registered trademark of Oracle Corporation and/or >>>>>>>> its >>>>>>>> affiliates. Other names may be trademarks of their respective >>>>>>>> owners. >>>>>>>> >>>>>>>> Type 'help;' or '\h' for help. Type '\c' to clear the current >>>>>>>> input statement. >>>>>>>> >>>>>>>> mysql> >>>>>>>> >>>>>>>> With Regards >>>>>>>> >>>>>>>> N.Prakash >>>>>>>> >>>>>>>> >>>>>>>>> >>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>> From: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt; >>>>>>>>> Date: Tue, Feb 12, 2013 at 5:16 PM >>>>>>>>> Subject: Re: [sr-dev] [SR-Users] openser db on an external >>>>>>>>> mysql server >>>>>>>>> To: Development mailing list of the sip-router project < >>>>>>>>> sr-dev(a)lists.sip-router.org&gt; >>>>>>>>> Cc: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;om>, >>>>>>>>> sr-users(a)lists.sip-router.org, Indu Priya &lt;indu(a)tevatel.com&gt;om>, >>>>>>>>> Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>>>>> >>>>>>>>> >>>>>>>>> Its not a Kamailio error, it is problem with connecting to >>>>>>>>> mysql server. Error 4 means No MySQL Server Running On Specified Host. >>>>>>>>> >>>>>>>>> May be MySQL server is down or there is some firewall running >>>>>>>>> or MySQL not listening on IP you specified. >>>>>>>>> >>>>>>>>> Thank you. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tue, Feb 12, 2013 at 12:11 PM, Prakash N < >>>>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>>>> >>>>>>>>>> Dear Daniel, >>>>>>>>>> >>>>>>>>>> Thanks for your quick response >>>>>>>>>> >>>>>>>>>> We can able to create operseb db on remote mysql >>>>>>>>>> server ,but Kamailio not getting start >>>>>>>>>> >>>>>>>>>> Error detail: >>>>>>>>>> >>>>>>>>>> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't >>>>>>>>>> connect to MySQL server on '192.168.1.170' (4) >>>>>>>>>> ERROR: <core> [db.c:32 0]: could not add connection to the >>>>>>>>>> pool >>>>>>>>>> ERROR: auth_db [authdb _mod.c:174]: unable to connect to the >>>>>>>>>> database >>>>>>>>>> ERROR: <core> [sr_modu le.c:896]: init_mod_child(): Error >>>>>>>>>> while initializing module auth_db >>>>>>>>>> (/usr/local/lib64/kamailio/modules_k/auth_db.so) >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> I have attached my kamailo.cfg ( we followed Kamailio and >>>>>>>>>> Asterisk real time installation) ,please advice >>>>>>>>>> >>>>>>>>>> With Regards >>>>>>>>>> >>>>>>>>>> N.Prakash >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>>>> From: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; >>>>>>>>>>> Date: Tue, Feb 12, 2013 at 2:41 PM >>>>>>>>>>> Subject: Re: [SR-Users] openser db on an external mysql >>>>>>>>>>> server >>>>>>>>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router >>>>>>>>>>> (SER) - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt;rg>, >>>>>>>>>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com >>>>>>>>>>> Cc: Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Hello, >>>>>>>>>>> >>>>>>>>>>> kamailio database is created with: >>>>>>>>>>> >>>>>>>>>>> kamdbctl create >>>>>>>>>>> >>>>>>>>>>> the host of mysql server has to be specified in kamctlrc >>>>>>>>>>> file via DBHOST variable - kamctlrc is located in same directory as >>>>>>>>>>> kamailio.cfg. >>>>>>>>>>> >>>>>>>>>>> In kamailio.cfg, update the db_url value (or DBURL define) >>>>>>>>>>> to reflect the mysql server host. >>>>>>>>>>> >>>>>>>>>>> Cheers, >>>>>>>>>>> Daniel >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On 2/12/13 4:16 AM, Prakash N wrote: >>>>>>>>>>> >>>>>>>>>>> Hi All, >>>>>>>>>>> >>>>>>>>>>> I am new this Kamailo ,ther is any step by step document >>>>>>>>>>> to set up openser db on an external mysql server ? >>>>>>>>>>> >>>>>>>>>>> With Regards >>>>>>>>>>> >>>>>>>>>>> N.Prakash >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda >>>>>>>>>>> Kamailio World Conference, April 16-17, 2013, Berlin >>>>>>>>>>> - http://conference.kamailio.com - >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> sr-dev mailing list >>>>>>>>>> sr-dev(a)lists.sip-router.org >>>>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Muhammad Shahzad >>>>>>>>> ----------------------------------- >>>>>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>>>>> CISCO Certified Network Associate (CCNA) >>>>>>>>> Cell: +49 176 99 83 10 85 >>>>>>>>> MSN: shari_786pk(a)hotmail.com >>>>>>>>> Email: shaheryarkh(a)googlemail.com >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Muhammad Shahzad >>>>>>> ----------------------------------- >>>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>>> CISCO Certified Network Associate (CCNA) >>>>>>> Cell: +49 176 99 83 10 85 >>>>>>> MSN: shari_786pk(a)hotmail.com >>>>>>> Email: shaheryarkh(a)googlemail.com >>>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users >>>>>> mailing list >>>>>> sr-users(a)lists.sip-router.org >>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> Muhammad Shahzad >>> ----------------------------------- >>> CISCO Rich Media Communication Specialist (CRMCS) >>> CISCO Certified Network Associate (CCNA) >>> Cell: +49 176 99 83 10 85 >>> MSN: shari_786pk(a)hotmail.com >>> Email: shaheryarkh(a)googlemail.com >>> >> >> > > > -- > Muhammad Shahzad > ----------------------------------- > CISCO Rich Media Communication Specialist (CRMCS) > CISCO Certified Network Associate (CCNA) > Cell: +49 176 99 83 10 85 > MSN: shari_786pk(a)hotmail.com > Email: shaheryarkh(a)googlemail.com >