<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt">Thanks so much,<br>but the log is more.<br><br>0(2285) DEBUG: <core> [main.c:1800]: read 972552225 from /dev/urandom<br> 0(2285) DEBUG: <core> [main.c:1806]: seeding PRNG with 2254742755<br> 0(2285) DEBUG: <core> [main.c:1810]: test random numbers 1619886338 1418625528 2344803195<br>loading modules under /usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/<br> 0(2285) WARNING: <core> [socket_info.c:896]: WARNING: fix_hostname: could not rev. resolve 192.168.1.40<br>Listening on<br> udp: 192.168.1.40:5060<br>Aliases:<br><br> 0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new config group has been registered: 'core' (num=35,
size=140)<br> 0(2285) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new config group has been registered: 'tcp' (num=24, size=96)<br> 0(2285) DEBUG: <core> [timer.c:270]: init_timer: starting with *ticks=52682242<br> 0(2285) DEBUG: <core> [timer.c:312]: init_timer: timer_list between 0xb5f49268 and 0xb5f6b268<br> 0(2285) INFO: <core> [tcp_main.c:4150]: init_tcp: using epoll_lt as the io watch method (auto detected)<br> 0(2289) DEBUG: <core> [daemonize.c:364]: core dump limits set to 4294967295<br> 0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: db_mysql<br> 0(2289) DEBUG: db_mysql [km_db_mysql.c:92]: MySQL client version is 5.0.77<br> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: mi_fifo<br> 0(2289) DEBUG: mi_fifo [mi_fifo.c:122]: testing mi_fifo existance ...<br> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod:
kex<br> 0(2289) DEBUG: <core> [statistics.c:105]: statistics manager successfully initialized<br> 0(2289) DEBUG: <core> [sr_module.c:857]: DEBUG: init_mod: tm<br>[root@appliance kamailio]# 0(2289) DEBUG: tm [tm.c:706]: TM - (sizeof cell=3152, sip_msg=860) initializing...<br> 0(2289) DEBUG: tm [callid.c:101]: Call-ID initialization: '5fffff36'<br> 0(2289) DEBUG: tm [lock.c:87]: DEBUG: lock_initialize: lock initialization started<br> 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<br> 0(2289) DEBUG: <core> [cfg/cfg.c:172]: DEBUG: register_cfg_def(): new config group has been registered: 'tm' (num=33, size=136)<br> 0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated: 203c2e849e2a007f7c0b097d3f734545<br> 0(2289) DEBUG: <core> [md5utils.c:87]: DEBUG: MD5 calculated:
78d79373441c680dd4e4ed1a014efb8e<br> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: tmx<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <load_tm> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <register_tmcb> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_newtran> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 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]<br> 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]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record:
found <t_relay> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 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]<br> 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]<br> 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]<br> 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]<br> 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]<br> 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]<br> 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]<br> 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]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_request> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 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]<br> 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]<br> 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]<br> 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]<br> 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]<br> 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]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <free_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <print_dlg> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_gett> in module tm
[/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <calculate_hooks> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_uac> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 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]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_release> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_unref> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 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]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <cancel_uacs> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 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]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_suspend> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:506]: find_export_record: found <t_continue> in module tm [/usr/local/lib/kamailio/modules/tm.so]<br> 0(2289) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: sl<br><br><br>more and more....<br>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 ?<br><div> </div>TRUONG NGOC THANH<br>Telecommunications
Engineer<br>Tel: 0984 480 646<br>Y!M: ngoc217thanh<div><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Daniel-Constantin Mierla <miconda@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> truong ngoc THANH <ngoc217thanh@yahoo.com>; SR-Users <sr-users@lists.sip-router.org><br><b><span style="font-weight: bold;">Sent:</span></b> Wed, August 18, 2010 11:25:29 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [SR-Users] help to config cfg_db module in kamailio 3.0.1<br></font><br>
<title></title>
Hello,<br>
<br>
first, keep the mailing list on cc, otherwise future emails will be
ignored.<br>
<br>
Then, the -ddd and -E parameters are for kamailio, not kamctl.<br>
<br>
Just run:<br>
<br>
kamailio -ddd -E<br>
<br>
of course, if you have a custom path to your config, keep you -c
/path/to/cfg parameter.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
On 8/18/10 6:20 PM, truong ngoc THANH wrote:
<blockquote type="cite">
<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">thanks Daniel,<br>
thanks for help, but i cannot start :kamctl -ddd -E<br>
or kamctl -ddd<br>
or kamctl -E.<br>
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 ?<br>
so nice too get your help.<br>
<div> </div>
TRUONG NGOC THANH<br>
Telecommunications Engineer<br>
Tel: 0984 480 646<br>
Y!M: ngoc217thanh
<div><br>
</div>
<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br>
<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2">
<hr size="1"><b><span style="font-weight: bold;">From:</span></b>
Daniel-Constantin Mierla <a rel="nofollow" class="moz-txt-link-rfc2396E" ymailto="mailto:miconda@gmail.com" target="_blank" href="mailto:miconda@gmail.com"><miconda@gmail.com></a><br>
<b><span style="font-weight: bold;">To:</span></b> truong
ngoc THANH <a rel="nofollow" class="moz-txt-link-rfc2396E" ymailto="mailto:ngoc217thanh@yahoo.com" target="_blank" href="mailto:ngoc217thanh@yahoo.com"><ngoc217thanh@yahoo.com></a><br>
<b><span style="font-weight: bold;">Cc:</span></b>
kamailio <a rel="nofollow" class="moz-txt-link-rfc2396E" ymailto="mailto:sr-users@lists.sip-router.org" target="_blank" href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br>
<b><span style="font-weight: bold;">Sent:</span></b> Wed,
August 18, 2010 10:47:58 PM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [SR-Users] help to config cfg_db module in kamailio
3.0.1<br>
</font><br>
Hello,<br>
<br>
not a user of this module, however, start kamailio with
parameters -ddd -E and paste the output here.<br>
<br>
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.<br>
<br>
Thanks,<br>
Daniel<br>
<br>
<br>
On 8/18/10 7:13 AM, truong ngoc THANH wrote:
<blockquote type="cite">
<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">
<style>
<!--
filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"sans-serif";}
span.EmailStyle15
{font-family:"sans-serif";color:windowtext;}
.MsoChpDefault
{}
filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<p class="MsoNormal">Hi all ,</p>
<p class="MsoNormal">I try to configure with cfg_db, but
after create and insert value into tables in mysql , I
cannot start kamailio.</p>
<p class="MsoNormal">I add My config in kamalio.cfg</p>
<p class="MsoNormal">==============</p>
<p class="MsoNormal">Loadmodule “<a rel="nofollow" target="_blank" href="http://cfg_db.so">cfg_db.so</a>”</p>
<p class="MsoNormal">modparam("cfg_db", "db_url",
"mysql://openser:openserrw@localhost/kamailio")</p>
<p class="MsoNormal">modparam("cfg_db", "transl_tbl",
"cfg_transl")</p>
<p class="MsoNormal">modparam("cfg_db", "custom_tbl",
"cfg_custom")</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I add and insert in mysql as:</p>
<p class="MsoNormal">===============</p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;">cfg_transl table:</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>group_name|name|cfg_table|cfg_table_group_name_field|cfg_table_name_field|cfg_table_value_field</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>core|use_dst_blacklist|cfg_dns|||</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>core|dst_blacklist_mem|cfg_dns|||</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>core|dst_blacklist_expire|||</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my|route_addr|cfg_my|my_group_name|my_name|my_value<span style=""> </span>; overrides <default>
values</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my|use_rtp_proxy|cfg_my|my_group_name|my_name|my_value</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>*|*||||<span style=""> </span>; matches all param ids, points
to tables defined in row <default></span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span><default>||cfg_var|group_name|name|value<span style=""> </span>; default cfg_table* values</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span></span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>cfg_custom
table:</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>group_name|name|value_type|min_value|max_value|description</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my|route_addr|S|||Routing
address</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my|use_rtp_proxy|I|0|1|Use
RTP proxy</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span></span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>cfg_var table:</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>group_name|my_name|value</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>core|debug|4</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span></span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>cfg_my table:</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my_group_name|my_name|my_value</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my|route_addr|127.0.0.1</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>my|use_rtp_proxy|1</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span></span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>cfg_dns table:</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>group_name|name|value</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>dns|use_dst_blacklist|1</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>dns|dst_blacklist_mem|1024</span></p>
<p class="MsoNormal" style=""><span style="font-size: 10pt;"><span style=""> </span>dns|dst_blacklist_expire|60</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">when I start kamailio<span style="">
</span>the log show :</p>
<p class="MsoNormal">===============</p>
<p class="MsoNormal">Aug 18 12:04:56 appliance
/usr/local/sbin/kamailio[2771]: INFO: usrloc
[hslot.c:53]: locks array size 512</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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'</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks for looking.</p>
<div> </div>
TRUONG NGOC THANH<br>
Telecommunications Engineer<br>
Tel: 0984 480 646<br>
Y!M: ngoc217thanh
<div><br>
</div>
</div>
<br>
<pre><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a rel="nofollow" class="moz-txt-link-abbreviated" ymailto="mailto:sr-users@lists.sip-router.org" target="_blank" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><span><span>
<a target="_blank" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</span></span></pre>
</blockquote>
<br>
<pre class="moz-signature">-- <br>Daniel-Constantin Mierla<br><span><span><a target="_blank" href="http://www.asipto.com/">http://www.asipto.com/</a></span></span>
</pre>
</div>
</div>
</div>
<br>
</blockquote>
<br>
<pre class="moz-signature">-- <br>Daniel-Constantin Mierla<br><a rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="http://www.asipto.com/">http://www.asipto.com/</a>
</pre>
</div></div>
</div><br>
</body></html>