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

Dear Shahzad Im usig centos 6.3, im not able to find the sylog i have defined debug on kamailio.cfg if i give kamailio -dd -D 2 to et the debug message please advice anyother way to get debug message for our issue With Regards B.Prabhakaran On Tue, Feb 12, 2013 at 7:37 PM, Muhammad Shahzad < shaheryarkh(a)gmail.com&gt; wrote: > There is no mysql error in logs. > > Set debug=4 on line 143 instead of defining WITH_DEBUG, since that > flag force kamailio to listen on localhost address only while db is on > 192.168.1.x. Then send me debug log file again (logs will appear in syslog). > > Thank you. > > > On Tue, Feb 12, 2013 at 2:54 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: > >> 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 < >>>>>>> prakash.n(a)tevatel.com&gt; 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" < >>>>>>>>>>>>> sr-users(a)lists.sip-router.org&gt;gt;, >>>>>>>>>>>>> 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 >>> >> >> > > > -- > 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 >