[SR-Users] help to config cfg_db module in kamailio 3.0.1

[truong ngoc THANH]

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



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100817/103817cb/attachment-0001.htm>