[sr-dev] [SR-Users] openser db on an external mysql server
Muhammad Shahzad
shaheryarkh at gmail.com
Tue Feb 12 16:32:01 CET 2013
syslogs are dumped to /var/log/message in CentOS.
Thank you.
On Tue, Feb 12, 2013 at 3:47 PM, Prabhakaran B <prabhakaran at tevatel.com>wrote:
> 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 at gmail.com>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 <prakash.n at tevatel.com> 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 at gmail.com
>>> > 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 <prakash.n at tevatel.com>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 at gmail.com> 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 <prakash.n at tevatel.com>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 <govoiper at gmail.com>
>>>>>>>> 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" <sr-users at lists.sip-router.org>
>>>>>>>> Cc: Muhammad Shahzad <shaheryarkh at gmail.com>,
>>>>>>>> sr-dev at lists.sip-router.org, Prabhakaran B <prabhakaran at tevatel.com>,
>>>>>>>> Indu Priya <indu at tevatel.com>
>>>>>>>>
>>>>>>>>
>>>>>>>> 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 at tevatel.com>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 at gmail.com> 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 at tevatel.com> 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 <shaheryarkh at gmail.com>
>>>>>>>>>>>> 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 at lists.sip-router.org>
>>>>>>>>>>>> Cc: Daniel-Constantin Mierla <miconda at gmail.com>,
>>>>>>>>>>>> sr-users at lists.sip-router.org, Indu Priya <indu at tevatel.com>,
>>>>>>>>>>>> Prabhakaran B <prabhakaran at tevatel.com>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> 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 at tevatel.com> 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 <miconda at gmail.com>
>>>>>>>>>>>>>> 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 at lists.sip-router.org>,
>>>>>>>>>>>>>> sr-dev at lists.sip-router.org, miconda at gmail.com
>>>>>>>>>>>>>> Cc: Prabhakaran B <prabhakaran at tevatel.com>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 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 at 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 at 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 at hotmail.com
>>>>>>>>>>>> Email: shaheryarkh at 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 at hotmail.com
>>>>>>>>>> Email: shaheryarkh at googlemail.com
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>>>>>>>>> list
>>>>>>>>> sr-users at 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 at hotmail.com
>>>>>> Email: shaheryarkh at 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 at hotmail.com
>>>> Email: shaheryarkh at 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 at hotmail.com
>> Email: shaheryarkh at 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 at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/fccbc635/attachment-0001.htm>
More information about the sr-dev
mailing list