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