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