18 Aug
2010
18 Aug
'10
7:25 p.m.
Hello,
first, keep the mailing list on cc, otherwise future emails will be ignored.
Then, the -ddd and -E parameters are for kamailio, not kamctl.
Just run:
kamailio -ddd -E
of course, if you have a custom path to your config, keep you -c
/path/to/cfg parameter.
Cheers,
Daniel
On 8/18/10 6:20 PM, truong ngoc THANH wrote:
thanks Daniel,
thanks for help, but i cannot start :kamctl -ddd -E
or kamctl -ddd
or kamctl -E.
and can you show me how it work, or how the result when i declare the
parameter, and how do I know the parameter is used for ?
so nice too get your help.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
------------------------------------------------------------------------
*From:* Daniel-Constantin Mierla <miconda(a)gmail.com>
*To:* truong ngoc THANH <ngoc217thanh(a)yahoo.com>
*Cc:* kamailio <sr-users(a)lists.sip-router.org>
*Sent:* Wed, August 18, 2010 10:47:58 PM
*Subject:* Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
Hello,
not a user of this module, however, start kamailio with parameters
-ddd -E and paste the output here.
Do you declare my.route_addr in config file as well? Might be that the
parameter is declared in cfg_custom table, the startup debug log
should give more hints.
Thanks,
Daniel
On 8/18/10 7:13 AM, truong ngoc THANH wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com/
Hi all ,
I try to configure with cfg_db, but after create and insert value
into tables in mysql , I cannot start kamailio.
I add My config in kamalio.cfg
==============
Loadmodule “cfg_db.so <http://cfg_db.so>”
modparam("cfg_db", "db_url",
"mysql://openser:openserrw@localhost/kamailio")
modparam("cfg_db", "transl_tbl", "cfg_transl")
modparam("cfg_db", "custom_tbl", "cfg_custom")
I add and insert in mysql as:
===============
cfg_transl table:
group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field
core|use_dst_blacklist|cfg_dns|||
core|dst_blacklist_mem|cfg_dns|||
core|dst_blacklist_expire|||
my|route_addr|cfg_my|my_group_name|my_name|my_value ; overrides
<default> values
my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value
*|*|||| ; matches all param ids, points to tables defined in row
<default>
<default>||cfg_var|group_name|name|value ; default cfg_table* values
cfg_custom table:
group_name|name|value_type|min_value|max_value|description
my|route_addr|S|||Routing address
my|use_rtp_proxy|I|0|1|Use RTP proxy
cfg_var table:
group_name|my_name|value
core|debug|4
cfg_my table:
my_group_name|my_name|my_value
my|route_addr|127.0.0.1
my|use_rtp_proxy|1
cfg_dns table:
group_name|name|value
dns|use_dst_blacklist|1
dns|dst_blacklist_mem|1024
dns|dst_blacklist_expire|60
when I start kamailio the log show :
===============
Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]: INFO:
usrloc [hslot.c:53]: locks array size 512
Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]: ERROR:
<core> [cfg/cfg_script.c:80]: ERROR: new_cfg_script_var(): variable
already exists: my.route_addr
Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]: ERROR:
cfg_db [cfg_db.c:335]: cfg_db: Error declaring cfg int 'my.route_addr'
Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]: ERROR:
<core> [sr_module.c:860]: init_mod(): Error while initializing module
cfg_db
Thanks for looking.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://www.asipto.com/
18 Aug
18 Aug
7:34 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
Thanks so much,
but the log is more.
0(2285) DEBUG: <core> [main.c:1800]: read 972552225 from /dev/urandom
0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with 2254742755
0(2285) DEBUG: <core> [main.c:1810]: test random numbers 1619886338 1418625528
2344803195
loading modules under
/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
0(2285) WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname: could not
rev. resolve 192.168.1.40
Listening on
udp: 192.168.1.40:5060
Aliases:
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new config
group has been registered: 'core' (num=35, size=140)
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new config
group has been registered: 'tcp' (num=24, size=96)
0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with *ticks=52682242
0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list between 0xb5f49268
and 0xb5f6b268
0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as the io
watch method (auto detected)
0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set to 4294967295
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: db_mysql
0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client version is 5.0.77
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: mi_fifo
0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo existance ...
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: kex
0(2289) DEBUG: <core> [statistics.c:105]: statistics manager successfully
initialized
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm
[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM - (sizeof
cell=3152, sip_msg=860) initializing...
0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization: '5fffff36'
0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock initialization
started
0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers: fr=480 fr_inv=1920 wait=80
delete=4 t1=8 t2=64 max_inv_lifetime=2880 max_noninv_lifetime=512
0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new config
group has been registered: 'tm' (num=33, size=136)
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
203c2e849e2a007f7c0b097d3f734545
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
78d79373441c680dd4e4ed1a014efb8e
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <load_tm>
in
module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<register_tmcb> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_newtran>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_tcp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_udp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_relay>
in
module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_reply_with_body> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_is_local>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_get_trans_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_lookup_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_add_blind> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_forward_nonack> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_within> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_outside> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_response_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<update_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_request_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<set_dlg_target> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <free_dlg>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<print_dlg>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_gett>
in
module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<calculate_hooks> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_uac> in
module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac_with_ids> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_release>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_unref>
in
module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<run_failure_handlers> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_all_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_suspend>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_continue>
in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl
more and more....
i have just see one error in my cfg_custom table. after i corect it. i start
kamailio ok, but i don`t see any change when cfg_db work ?
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com
To: truong ngoc THANH <ngoc217thanh(a)yahoo.com>om>; SR-Users
<sr-users(a)lists.sip-router.org Sent: Wed, August 18,
2010 11:25:29 PM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
Hello,
first, keep the mailing list on cc, otherwise future emails will be ignored.
Then, the -ddd and -E parameters are for kamailio, not kamctl.
Just run:
kamailio -ddd -E
of course, if you have a custom path to your config, keep you -c
/path/to/cfg parameter.
Cheers,
Daniel
On 8/18/10 6:20 PM, truong ngoc THANH wrote:
thanks Daniel,
--
Daniel-Constantin Mierla
http://www.asipto.com/
thanks for help, but i cannot start :kamctl -ddd -E
or kamctl -ddd
or kamctl -E.
and can you show me how it work, or how the result when i declare the
parameter, and how do I know the parameter is used for ?
so nice too get your help.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com To: truong ngoc THANH
<ngoc217thanh(a)yahoo.com Cc: kamailio
<sr-users(a)lists.sip-router.org Sent: Wed,
August 18, 2010 10:47:58 PM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio
3.0.1
Hello,
not a user of this module, however, start kamailio with parameters
-ddd -E and paste the output here.
Do you declare my.route_addr in config file as well? Might be that
the parameter is declared in cfg_custom table, the startup debug log
should give more hints.
Thanks,
Daniel
On 8/18/10 7:13 AM, truong ngoc THANH wrote:
>Hi all ,
>I try to configure with cfg_db, but after create and insert
>value into tables in mysql , I cannot start kamailio.
>I add My config in kamalio.cfg
>==============
>Loadmodule “cfg_db.so”
>modparam("cfg_db", "db_url",
>"mysql://openser:openserrw@localhost/kamailio")
>modparam("cfg_db", "transl_tbl",
"cfg_transl")
>modparam("cfg_db", "custom_tbl",
"cfg_custom")
>
>I add and insert in mysql as:
>===============
>cfg_transl table:
>
>group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field
> core|use_dst_blacklist|cfg_dns|||
> core|dst_blacklist_mem|cfg_dns|||
> core|dst_blacklist_expire|||
> my|route_addr|cfg_my|my_group_name|my_name|my_value ; overrides
><default> values
> my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value
> *|*||||; matches all param ids, points to tables
>defined in row <default >
<default>||cfg_var|group_name|name|value ; default cfg_table* values
>
> cfg_custom table:
> group_name|name|value_type|min_value|max_value|description
> my|route_addr|S|||Routing address
> my|use_rtp_proxy|I|0|1|Use RTP proxy
>
> cfg_var table:
> group_name|my_name|value
> core|debug|4
>
> cfg_my table:
> my_group_name|my_name|my_value
> my|route_addr|127.0.0.1
> my|use_rtp_proxy|1
>
> cfg_dns table:
> group_name|name|value
> dns|use_dst_blacklist|1
> dns|dst_blacklist_mem|1024
> dns|dst_blacklist_expire|60
>
>when I start kamailio the log show :
>===============
>Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]:
>INFO: usrloc [hslot.c:53]: locks array size 512
>Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]:
>ERROR: <core> [cfg/cfg_script.c:80]: ERROR:
>new_cfg_script_var(): variable already exists: my.route_addr
>Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]:
>ERROR: cfg_db [cfg_db.c:335]: cfg_db: Error declaring cfg int
>'my.route_addr'
>Aug 18 12:04:56 appliance /usr/local/sbin/kamailio[2771]:
>ERROR: <core> [sr_module.c:860]: init_mod(): Error while
>initializing module cfg_db
>
>Thanks for looking.
>
TRUONG NGOC THANH
>Telecommunications Engineer
>Tel: 0984 480 646
>Y!M: ngoc217thanh
>
_______________________________________________ SIP Express Router (SER) and
>Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org
>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
--
Daniel-Constantin Mierla
http://www.asipto.com/
8:16 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
Hello,
On 8/18/10 6:34 PM, truong ngoc THANH wrote:
Thanks so much,
but the log is more.
0(2285) DEBUG: <core> [main.c:1800]: read 972552225 from /dev/urandom
0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with 2254742755
0(2285) DEBUG: <core> [main.c:1810]: test random numbers 1619886338
1418625528 2344803195
loading modules under
/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
0(2285) WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname:
could not rev. resolve 192.168.1.40
Listening on
udp: 192.168.1.40:5060
Aliases:
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new
config group has been registered: 'core' (num=35, size=140)
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new
config group has been registered: 'tcp' (num=24, size=96)
0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with
*ticks=52682242
0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list between
0xb5f49268 and 0xb5f6b268
0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as
the io watch method (auto detected)
0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set to
4294967295
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: db_mysql
0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client version is
5.0.77
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: mi_fifo
0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo existance ...
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: kex
0(2289) DEBUG: <core> [statistics.c:105]: statistics manager
successfully initialized
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm
[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM - (sizeof
cell=3152, sip_msg=860) initializing...
0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization: '5fffff36'
0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock
initialization started
0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers: fr=480
fr_inv=1920 wait=80 delete=4 t1=8 t2=64 max_inv_lifetime=2880
max_noninv_lifetime=512
0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new
config group has been registered: 'tm' (num=33, size=136)
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
203c2e849e2a007f7c0b097d3f734545
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
78d79373441c680dd4e4ed1a014efb8e
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<load_tm> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<register_tmcb> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_newtran> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_tcp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_udp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_reply_with_body> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_is_local> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_get_trans_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_lookup_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_add_blind> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_forward_nonack> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_within> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_outside> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_response_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<update_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_request_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<set_dlg_target> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<free_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<print_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_gett> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<calculate_hooks> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac_with_ids> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_release> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_unref> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<run_failure_handlers> in module tm
[/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_all_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_suspend> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_continue> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl
more and more....
i have just see one error in my cfg_custom table. after i corect it. i
start kamailio ok, but i don`t see any change when cfg_db work ?
yes, the log is
more, and I do not see the error message here. What do
you mean with last question, does it start ok now?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
8:20 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
i don`t know, the kamailio is start ok, but my configure in cfg_db is not work.
please suggest what i do and what happen ?
thanks for help me.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com>
To: truong ngoc THANH <ngoc217thanh(a)yahoo.com>
Cc: kamailio <sr-users(a)lists.sip-router.org>
Sent: Thu, August 19, 2010 12:16:40 AM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
Hello,
On 8/18/10 6:34 PM, truong ngoc THANH wrote:
Thanks so much,
but the log is more.
0(2285) DEBUG: <core> [main.c:1800]: read 972552225 from /dev/urandom
0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with 2254742755
0(2285) DEBUG: <core> [main.c:1810]: test random numbers 1619886338
1418625528 2344803195
loading modules under
/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
0(2285) WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname:
could not rev. resolve 192.168.1.40
Listening on
udp: 192.168.1.40:5060
Aliases:
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new
config group has been registered: 'core' (num=35, size=140)
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new
config group has been registered: 'tcp' (num=24, size=96)
0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with
*ticks=52682242
0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list between
0xb5f49268 and 0xb5f6b268
0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as the
io watch method (auto detected)
0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set to
4294967295
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: db_mysql
0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client version is
5.0.77
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: mi_fifo
0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo existance ...
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: kex
0(2289) DEBUG: <core> [statistics.c:105]: statistics manager
successfully initialized
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm
[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM - (sizeof
cell=3152, sip_msg=860) initializing...
0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization: '5fffff36'
0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock
initialization started
0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers: fr=480 fr_inv=1920
wait=80 delete=4 t1=8 t2=64 max_inv_lifetime=2880
max_noninv_lifetime=512
0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new
config group has been registered: 'tm' (num=33, size=136)
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
203c2e849e2a007f7c0b097d3f734545
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
78d79373441c680dd4e4ed1a014efb8e
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<load_tm> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<register_tmcb> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_newtran> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_tcp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_udp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_reply_with_body> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_is_local> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_get_trans_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_lookup_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_add_blind> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_forward_nonack> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_within> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_outside> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_response_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<update_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_request_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<set_dlg_target> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<free_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<print_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_gett> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<calculate_hooks> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac_with_ids> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_release> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_unref> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<run_failure_handlers> in module tm
[/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_all_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_suspend> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_continue> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl
more and more....
i have just see one error in my cfg_custom table. after i corect it. i
start kamailio ok, but i don`t see any change when cfg_db work ?
yes, the log is more, and I do not see the error message here. What do you
mean with last question, does it start ok now?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
8:26 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
On 8/18/10 7:20 PM, truong ngoc THANH wrote:
i don`t know, the kamailio is start ok,
is command 'ps auxw|grep kamailio' showing you some running kamailio
processes?
but my configure in cfg_db is not work.
please suggest what i do and what happen ?
How you figure out is not working? How do you use those variables in
your config?
Cheers,
Daniel
thanks for help me.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
------------------------------------------------------------------------
*From:* Daniel-Constantin Mierla <miconda(a)gmail.com>
*To:* truong ngoc THANH <ngoc217thanh(a)yahoo.com>
*Cc:* kamailio <sr-users(a)lists.sip-router.org>
*Sent:* Thu, August 19, 2010 12:16:40 AM
*Subject:* Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
Hello,
On 8/18/10 6:34 PM, truong ngoc THANH wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com/
Thanks so much,
but the log is more.
0(2285) DEBUG: <core> [main.c:1800]: read 972552225 from /dev/urandom
0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with 2254742755
0(2285) DEBUG: <core> [main.c:1810]: test random numbers 1619886338
1418625528 2344803195
loading modules under
/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
0(2285) WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname:
could not rev. resolve 192.168.1.40
Listening on
udp: 192.168.1.40:5060
Aliases:
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def():
new config group has been registered: 'core' (num=35, size=140)
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def():
new config group has been registered: 'tcp' (num=24, size=96)
0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with
*ticks=52682242
0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list between
0xb5f49268 and 0xb5f6b268
0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as
the io watch method (auto detected)
0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set to
4294967295
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: db_mysql
0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client version is
5.0.77
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: mi_fifo
0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo existance ...
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: kex
0(2289) DEBUG: <core> [statistics.c:105]: statistics manager
successfully initialized
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm
[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM -
(sizeof cell=3152, sip_msg=860) initializing...
0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization: '5fffff36'
0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock
initialization started
0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers: fr=480
fr_inv=1920 wait=80 delete=4 t1=8 t2=64 max_inv_lifetime=2880
max_noninv_lifetime=512
0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def():
new config group has been registered: 'tm' (num=33, size=136)
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
203c2e849e2a007f7c0b097d3f734545
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
78d79373441c680dd4e4ed1a014efb8e
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<load_tm> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<register_tmcb> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_newtran> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_tcp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_udp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_reply_with_body> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_is_local> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_get_trans_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_lookup_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_add_blind> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_forward_nonack> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_within> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_outside> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_response_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<update_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_request_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<set_dlg_target> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<free_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<print_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_gett> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<calculate_hooks> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac_with_ids> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_release> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_unref> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<run_failure_handlers> in module tm
[/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_all_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_suspend> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_continue> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl
more and more....
i have just see one error in my cfg_custom table. after i corect it.
i start kamailio ok, but i don`t see any change when cfg_db work ?
yes, the log is
more, and I do not see the error message here. What do
you mean with last question, does it start ok now?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
8:36 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
dear Daniel,
my configure as :
I add My config in kamalio.cfg
==============
Loadmodule “cfg_db.so”
modparam("cfg_db", "db_url",
"mysql://openser:openserrw <at>
localhost/kamailio")
modparam("cfg_db", "transl_tbl",
"cfg_transl")
modparam("cfg_db", "custom_tbl",
"cfg_custom")
I add and insert in mysql as:
===============
cfg_transl table:
group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field
core|use_dst_blacklist|cfg_dns|||
core|dst_blacklist_mem|cfg_dns|||
core|dst_blacklist_expire|||
my|route_addr|cfg_my|my_group_name|my_name|my_value ; overrides
<default> values
my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value
*|*||||; matches all param ids, points to tables
defined in row <default
<default>||cfg_var|group_name|name|value ; default cfg_table* values
cfg_custom table:
group_name|name|value_type|min_value|max_value|description
my|route_addr|S|||Routing address
my|use_rtp_proxy|I|0|1|Use RTP proxy
cfg_var table:
group_name|my_name|value
core|debug|4
cfg_my table:
my_group_name|my_name|my_value
my|route_addr|127.0.0.1
my|use_rtp_proxy|1
cfg_dns table:
group_name|name|value
dns|use_dst_blacklist|1
dns|dst_blacklist_mem|1024
dns|dst_blacklist_expire|60
so please suggest me to test or insert some variables to make it work.
thanks so much.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com
To: truong ngoc THANH <ngoc217thanh(a)yahoo.com
Cc: kamailio <sr-users(a)lists.sip-router.org
Sent: Thu, August 19, 2010 12:26:27 AM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
On 8/18/10 7:20 PM, truong ngoc THANH wrote:
i don`t know, the kamailio is start ok,
is command 'ps auxw|grep kamailio' showing you some running kamailio
processes?
but my configure in cfg_db is not work.
TRUONG NGOC THANH
--
Daniel-Constantin Mierla
http://www.asipto.com/
please suggest what i do and what happen ?
How you figure out is not working? How do you use those variables in your
config?
Cheers,
Daniel
thanks for help me.
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com To: truong ngoc THANH
<ngoc217thanh(a)yahoo.com Cc: kamailio
<sr-users(a)lists.sip-router.org Sent: Thu,
August 19, 2010 12:16:40 AM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio
3.0.1
Hello,
On 8/18/10 6:34 PM, truong ngoc THANH wrote:
Thanks so much,
>but the log is more.
>0(2285) DEBUG: <core> [main.c:1800]:
read 972552225 from
>/dev/urandom
> 0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with
>2254742755
> 0(2285) DEBUG: <core> [main.c:1810]: test random numbers
>1619886338 1418625528 2344803195
>loading modules under
>/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
> 0(2285) WARNING: <core> [socket_info.c:896]: WARNING:
>fix_hostname: could not rev. resolve 192.168.1.40
>Listening on
> udp: 192.168.1.40:5060
>Aliases:
> 0(2285) DEBUG: <core>
[cfg/cfg.c:172]: DEBUG:
>register_cfg_def(): new config group has been registered:
'core'
>(num=35, size=140)
> 0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG:
>register_cfg_def(): new config group has been registered:
'tcp'
>(num=24, size=96)
> 0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with
>*ticks=52682242
> 0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list
>between 0xb5f49268 and 0xb5f6b268
> 0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using
>epoll_lt as the io watch method (auto detected)
> 0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set
>to 4294967295
> 0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod:
>db_mysql
> 0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client
>version is 5.0.77
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod:
>mi_fifo
> 0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo
>existance ...
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: kex
> 0(2289) DEBUG: <core> [statistics.c:105]: statistics manager
>successfully initialized
> 0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm
>[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM -
>(sizeof cell=3152, sip_msg=860) initializing...
> 0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization:
>'5fffff36'
> 0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock
>initialization started
> 0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers: fr=480
>fr_inv=1920 wait=80 delete=4 t1=8 t2=64 max_inv_lifetime=2880
>max_noninv_lifetime=512
> 0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG:
>register_cfg_def(): new config group has been registered: 'tm'
>(num=33, size=136)
> 0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
>203c2e849e2a007f7c0b097d3f734545
> 0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
>78d79373441c680dd4e4ed1a014efb8e
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <load_tm> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <register_tmcb> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_newtran> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_relay_to_tcp> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_relay_to_udp> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_relay> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_reply_with_body> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_is_local> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_get_trans_ident> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_lookup_ident> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_add_blind> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_forward_nonack> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_request_within> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_request_outside> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_request> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <new_dlg_uac> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <dlg_response_uac> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <new_dlg_uas> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <update_dlg_uas> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <dlg_request_uas> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <set_dlg_target> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <free_dlg> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <print_dlg> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_gett> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <calculate_hooks> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_uac> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_uac_with_ids> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_release> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_unref> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <run_failure_handlers> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <cancel_uacs> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <cancel_all_uacs> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_suspend> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
>found <t_continue> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl
>more and more....
>i have just see one error in my cfg_custom table. after i corect
>it. i start kamailio ok, but i don`t see any change when cfg_db
>work ?
>
yes, the log is more, and I do not see the error message here. What
do you mean with last question, does it start ok now?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
8:45 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
Hello,
that is only the part to configure the cfg_db module. That creates the
config variables, but you need to use them somewhere in routing blocks,
like:
if($sel(cfg_get.my.route_addr)=="some value") ...
Or at least you can use xlog to print the value of this variable:
xlog("my var value is: $sel(cfg_get.my.route_addr)\n");
Then you can see if the right value is loaded.
Cheers,
Daniel
On 8/18/10 7:36 PM, truong ngoc THANH wrote:
dear Daniel,
my configure as :
I add My config in kamalio.cfg
==============
Loadmodule “cfg_db.so <http://cfg_db.so/>”
modparam("cfg_db", "db_url", "mysql://openser:openserrw
<at>
localhost/kamailio")
modparam("cfg_db", "transl_tbl", "cfg_transl")
modparam("cfg_db", "custom_tbl", "cfg_custom")
I add and insert in mysql as:
===============
cfg_transl table:
group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field
core|use_dst_blacklist|cfg_dns|||
core|dst_blacklist_mem|cfg_dns|||
core|dst_blacklist_expire|||
my|route_addr|cfg_my|my_group_name|my_name|my_value ; overrides
<default> values
my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value
*|*|||| ; matches all param ids, points to tables defined in row <default>
<default>||cfg_var|group_name|name|value ; default cfg_table* values
cfg_custom table:
group_name|name|value_type|min_value|max_value|description
my|route_addr|S|||Routing address
my|use_rtp_proxy|I|0|1|Use RTP proxy
cfg_var table:
group_name|my_name|value
core|debug|4
cfg_my table:
my_group_name|my_name|my_value
my|route_addr|127.0.0.1
my|use_rtp_proxy|1
cfg_dns table:
group_name|name|value
dns|use_dst_blacklist|1
dns|dst_blacklist_mem|1024
dns|dst_blacklist_expire|60
so please suggest me to test or insert some variables to make it work.
thanks so much.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
------------------------------------------------------------------------
*From:* Daniel-Constantin Mierla <miconda(a)gmail.com>
*To:* truong ngoc THANH <ngoc217thanh(a)yahoo.com>
*Cc:* kamailio <sr-users(a)lists.sip-router.org>
*Sent:* Thu, August 19, 2010 12:26:27 AM
*Subject:* Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
On 8/18/10 7:20 PM, truong ngoc THANH wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com/
i don`t know, the kamailio is start ok,
is command 'ps auxw|grep kamailio' showing you some running kamailio
processes?
but my configure in cfg_db is not work.
please suggest what i do and what happen ?
How you figure out is not working? How do you use those variables in
your config?
Cheers,
Daniel
thanks for help me.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
------------------------------------------------------------------------
*From:* Daniel-Constantin Mierla <miconda(a)gmail.com>
*To:* truong ngoc THANH <ngoc217thanh(a)yahoo.com>
*Cc:* kamailio <sr-users(a)lists.sip-router.org>
*Sent:* Thu, August 19, 2010 12:16:40 AM
*Subject:* Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
Hello,
On 8/18/10 6:34 PM, truong ngoc THANH wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com/
Thanks so much,
but the log is more.
0(2285) DEBUG: <core> [main.c:1800]: read 972552225 from /dev/urandom
0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with 2254742755
0(2285) DEBUG: <core> [main.c:1810]: test random numbers 1619886338
1418625528 2344803195
loading modules under
/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
0(2285) WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname:
could not rev. resolve 192.168.1.40
Listening on
udp: 192.168.1.40:5060
Aliases:
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def():
new config group has been registered: 'core' (num=35, size=140)
0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def():
new config group has been registered: 'tcp' (num=24, size=96)
0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with
*ticks=52682242
0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list between
0xb5f49268 and 0xb5f6b268
0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as
the io watch method (auto detected)
0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set to
4294967295
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: db_mysql
0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client version is
5.0.77
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: mi_fifo
0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo existance ...
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: kex
0(2289) DEBUG: <core> [statistics.c:105]: statistics manager
successfully initialized
0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm
[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM -
(sizeof cell=3152, sip_msg=860) initializing...
0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization: '5fffff36'
0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock
initialization started
0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers: fr=480
fr_inv=1920 wait=80 delete=4 t1=8 t2=64 max_inv_lifetime=2880
max_noninv_lifetime=512
0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def():
new config group has been registered: 'tm' (num=33, size=136)
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
203c2e849e2a007f7c0b097d3f734545
0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
78d79373441c680dd4e4ed1a014efb8e
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<load_tm> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<register_tmcb> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_newtran> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_tcp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay_to_udp> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_relay> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_reply_with_body> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_is_local> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_get_trans_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_lookup_ident> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_add_blind> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_forward_nonack> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_within> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request_outside> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_request> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_response_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<new_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<update_dlg_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<dlg_request_uas> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<set_dlg_target> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<free_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<print_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_gett> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<calculate_hooks> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_uac_with_ids> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_release> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_unref> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<run_failure_handlers> in module tm
[/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<cancel_all_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_suspend> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<t_continue> in module tm [/usr/local/lib/kamailio/modules/tm.so]
0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl
more and more....
i have just see one error in my cfg_custom table. after i corect it.
i start kamailio ok, but i don`t see any change when cfg_db work ?
yes, the log is
more, and I do not see the error message here. What
do you mean with last question, does it start ok now?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
9:02 p.m.
New subject: help to config cfg_db module in kamailio 3.0.1
dear Daniel,
when i add
xlog("my var value is: $sel(cfg_get.my.route_addr)\n");
i see that kamailio load right value.
my scenarios as:
my kamailio server(192.168.1.40) and the $sel(cfg_get.my.route_addr) is
192.168.1.110
i register with 1(a)192.168.1.40 and 2(a)192.168.1.40
then i make call is ok
so the route ip is ???
and why i can make call ?
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com
To: truong ngoc THANH <ngoc217thanh(a)yahoo.com
Cc: kamailio <sr-users(a)lists.sip-router.org
Sent: Thu, August 19, 2010 12:45:54 AM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1
Hello,
that is only the part to configure the cfg_db module. That creates the
config variables, but you need to use them somewhere in routing blocks,
like:
if($sel(cfg_get.my.route_addr)=="some value") ...
Or at least you can use xlog to print the value of this variable:
xlog("my var value is: $sel(cfg_get.my.route_addr)\n");
Then you can see if the right value is loaded.
Cheers,
Daniel
On 8/18/10 7:36 PM, truong ngoc THANH wrote:
dear Daniel,
TRUONG NGOC THANH
--
Daniel-Constantin Mierla
http://www.asipto.com/
--
Daniel-Constantin Mierla
http://www.asipto.com/
my configure as :
I add My config in kamalio.cfg
==============
Loadmodule “cfg_db.so”
modparam("cfg_db", "db_url", "mysql://openser:openserrw
<at>
localhost/kamailio")
modparam("cfg_db", "transl_tbl", "cfg_transl")
modparam("cfg_db", "custom_tbl", "cfg_custom")
I add and insert in mysql as:
===============
cfg_transl table:
group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field
core|use_dst_blacklist|cfg_dns|||
core|dst_blacklist_mem|cfg_dns|||
core|dst_blacklist_expire|||
my|route_addr|cfg_my|my_group_name|my_name|my_value ; overrides
<default> values
my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value
*|*||||; matches all param ids, points to tables defined in
row <default
<default>||cfg_var|group_name|name|value ; default cfg_table* values
cfg_custom table:
group_name|name|value_type|min_value|max_value|description
my|route_addr|S|||Routing address
my|use_rtp_proxy|I|0|1|Use RTP proxy
cfg_var table:
group_name|my_name|value
core|debug|4
cfg_my table:
my_group_name|my_name|my_value
my|route_addr|127.0.0.1
my|use_rtp_proxy|1
cfg_dns table:
group_name|name|value
dns|use_dst_blacklist|1
dns|dst_blacklist_mem|1024
dns|dst_blacklist_expire|60
so please suggest me to test or insert some variables to make it
work.
thanks so much.
TRUONG NGOC THANH
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com To: truong ngoc THANH
<ngoc217thanh(a)yahoo.com Cc: kamailio
<sr-users(a)lists.sip-router.org Sent: Thu,
August 19, 2010 12:26:27 AM
Subject: Re: [SR-Users] help to config cfg_db module in kamailio
3.0.1
On 8/18/10 7:20 PM, truong ngoc THANH wrote:
i don`t know, the kamailio is start ok,
is command 'ps auxw|grep
kamailio' showing you some running kamailio
processes?
but my configure in cfg_db is not work.
please suggest what i do and what happen ?
How you figure out is not working? How do you use those variables in
your config?
Cheers,
Daniel
thanks for help me.
Telecommunications Engineer
Tel: 0984 480 646
Y!M: ngoc217thanh
________________________________
From: Daniel-Constantin Mierla <miconda(a)gmail.com To: truong ngoc THANH <ngoc217thanh(a)yahoo.com Cc: kamailio
<sr-users(a)lists.sip-router.org Sent: Thu, August 19,
2010 12:16:40 AM
Subject: Re: [SR-Users] help to config cfg_db module in
kamailio 3.0.1
Hello,
On 8/18/10 6:34 PM, truong ngoc THANH wrote:
Thanks so much,
>but the log is more.
>0(2285) DEBUG: <core> [main.c:1800]:
read 972552225 from
>/dev/urandom
> 0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with
>2254742755
> 0(2285) DEBUG: <core> [main.c:1810]: test random
>numbers 1619886338 1418625528 2344803195
>loading modules under
>/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/
> 0(2285) WARNING: <core> [socket_info.c:896]: WARNING:
>fix_hostname: could not rev. resolve 192.168.1.40
>Listening on
> udp: 192.168.1.40:5060
>Aliases:
> 0(2285) DEBUG: <core>
[cfg/cfg.c:172]: DEBUG:
>register_cfg_def(): new config group has been
>registered: 'core' (num=35, size=140)
> 0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG:
>register_cfg_def(): new config group has been
>registered: 'tcp' (num=24, size=96)
> 0(2285) DEBUG: <core> [timer.c:270]: init_timer:
>starting with *ticks=52682242
> 0(2285) DEBUG: <core> [timer.c:312]: init_timer:
>timer_list between 0xb5f49268 and 0xb5f6b268
> 0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using
>epoll_lt as the io watch method (auto detected)
> 0(2289) DEBUG: <core> [daemonize.c:364]: core dump
>limits set to 4294967295
> 0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG:
>init_mod: db_mysql
> 0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL
>client version is 5.0.77
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG:
>init_mod: mi_fifo
> 0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo
>existance ...
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG:
>init_mod: kex
> 0(2289) DEBUG: <core> [statistics.c:105]: statistics
>manager successfully initialized
> 0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG:
>init_mod: tm
>[root@appliance kamailio]# 0(2289) DEBUG: tm
>[tm.c:706]: TM - (sizeof cell=3152, sip_msg=860)
>initializing...
> 0(2289) DEBUG: tm [callid.c:101]: Call-ID
>initialization: '5fffff36'
> 0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize:
>lock initialization started
> 0(2289) DEBUG: tm [timer.c:242]: tm: tm_init_timers:
>fr=480 fr_inv=1920 wait=80 delete=4 t1=8 t2=64
>max_inv_lifetime=2880 max_noninv_lifetime=512
> 0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG:
>register_cfg_def(): new config group has been
>registered: 'tm' (num=33, size=136)
> 0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5
>calculated: 203c2e849e2a007f7c0b097d3f734545
> 0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5
>calculated: 78d79373441c680dd4e4ed1a014efb8e
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG:
>init_mod: tmx
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <load_tm> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <register_tmcb> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_newtran> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_relay_to_tcp> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_relay_to_udp> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_relay> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_reply_with_body> in module
>tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_is_local> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_get_trans_ident> in module
>tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_lookup_ident> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_add_blind> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_forward_nonack> in module
>tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_request_within> in module
>tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_request_outside> in module
>tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_request> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <new_dlg_uac> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <dlg_response_uac> in module
>tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <new_dlg_uas> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <update_dlg_uas> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <dlg_request_uas> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <set_dlg_target> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <free_dlg> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <print_dlg> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_gett> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <calculate_hooks> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_uac> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_uac_with_ids> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_release> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_unref> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <run_failure_handlers> in
>module tm [/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <cancel_uacs> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <cancel_all_uacs> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_suspend> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:506]:
>find_export_record: found <t_continue> in module tm
>[/usr/local/lib/kamailio/modules/tm.so]
> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG:
>init_mod: sl
>more and more....
>i have just see one error in my cfg_custom table. after
>i corect it. i start kamailio ok, but i don`t see any
>change when cfg_db work ?
>
yes, the log is more, and I do not see the error message
here. What do you mean with last question, does it start ok
now?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
5240
days inactive
5240
days old
7 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
truong ngoc THANH