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

Muhammad Shahzad shaheryarkh at gmail.com
Tue Feb 12 15:08:15 CET 2013


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/5d1d8839/attachment-0001.htm>


More information about the sr-dev mailing list