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
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users