[sr-dev] [SR-Users] openser db on an external mysql server
Prakash N
prakash.n at tevatel.com
Tue Feb 12 14:54:46 CET 2013
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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/80c98476/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: putty.log
Type: application/octet-stream
Size: 60962 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/80c98476/attachment-0001.obj>
More information about the sr-dev
mailing list