<div>Here you go</div>
<div> </div>
<div>#set module path<br>mpath="/usr/local/lib64/opensips/modules/"</div>
<div>/* uncomment next line for MySQL DB support */<br>loadmodule "db_mysql.so"<br>loadmodule "signaling.so"<br>loadmodule "sl.so"<br>loadmodule "tm.so"<br>loadmodule "rr.so"<br>
loadmodule "uac.so"<br>loadmodule "maxfwd.so"<br>loadmodule "usrloc.so"<br>loadmodule "registrar.so"<br>loadmodule "textops.so"<br>loadmodule "mi_fifo.so"<br>loadmodule "mi_datagram.so"<br>
loadmodule "uri.so"<br>loadmodule "acc.so"<br>loadmodule "avpops.so"<br>/* uncomment next lines for MySQL based authentication support <br> NOTE: a DB (like db_mysql) module must be also loaded */<br>
loadmodule "auth.so"<br>loadmodule "auth_db.so"<br>/* uncomment next line for aliases support<br> NOTE: a DB (like db_mysql) module must be also loaded */<br>loadmodule "alias_db.so"<br>/* uncomment next line for multi-domain support<br>
NOTE: a DB (like db_mysql) module must be also loaded<br> NOTE: be sure and enable multi-domain support in all used modules<br> (see "multi-module params" section ) */<br>loadmodule "domain.so"<br>
/* uncomment the next two lines for presence server support<br> NOTE: a DB (like db_mysql) module must be also loaded */<br>loadmodule "group.so"<br>loadmodule "presence.so"<br>loadmodule "presence_mwi.so"<br>
loadmodule "presence_xml.so"<br>loadmodule "presence_dialoginfo.so"<br>loadmodule "pua.so"<br>loadmodule "pua_dialoginfo.so"<br>loadmodule "pua_usrloc.so"<br>loadmodule "pua_mi.so"<br>
loadmodule "pua_bla.so"<br>loadmodule "presence_xcapdiff.so"<br>loadmodule "dialog.so"<br>#loadmodule "pdt.so"<br>loadmodule "nat_traversal.so"<br>loadmodule "nathelper.so"<br>
loadmodule "mediaproxy.so"<br>loadmodule "cfgutils.so"<br>#loadmodule "siptrace.so"<br>loadmodule "aaa_radius.so"<br>#loadmodule "exec.so"<br>#loadmodule "pike.so"<br>
loadmodule "localcache.so"<br>loadmodule "rls.so"<br>#loadmodule "stun.so"<br>#loadmodule "call_control.so"<br>#loadmodule "mi_xmlrpc.so"<br>loadmodule "permissions.so"<br>
#loadmodule "b2b_entities.so"<br>#loadmodule "b2b_logic.so"<br>loadmodule "closeddial.so"</div>
<div># ----------------- setting module-specific parameters ---------------</div>
<div><br># ----- mi_fifo params -----<br>modparam("mi_fifo", "fifo_name", "/var/run/opensips/fifo")<br>modparam("mi_fifo", "fifo_user", "opensips")<br>modparam("mi_fifo", "fifo_group", "opensips")</div>
<div># ----- mi_datagram params -----<br>modparam("mi_datagram", "socket_name", "/var/run/opensips/socket")<br>modparam("mi_datagram", "unix_socket_user", "opensips")<br>
modparam("mi_datagram", "unix_socket_group", "opensips")</div>
<div># ----- rr params -----<br># add value to ;lr param to cope with most of the UAs<br>modparam("rr", "enable_full_lr", 1)<br># append from tag to the RR (no need for this script)<br>modparam("rr", "append_fromtag", 1)</div>
<div><br># ----- mi_xmlrpc params -----<br>#modparam("mi_xmlrpc", "port", 8080)<br>#modparam("mi_xmlrpc", "log_file", "/var/log/opensipsxmlrpc.log")</div>
<div># ----- registrar params -----<br>/* uncomment the next line not to allow more than 10 contacts per AOR */<br>#modparam("registrar", "max_contacts", 10)<br>modparam("registrar", "received_avp", "$avp(i:42)")<br>
modparam("registrar", "default_expires", 3600)<br>modparam("registrar", "default_q", 380) # <--- Value can be no greater than 1000 (Q Value is between 0.00 and 1.00</div>
<div># ----- dialog params -----<br>modparam("dialog", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>modparam("dialog", "dlg_flag", 4)<br>modparam("dialog", "profiles_with_value", "ConcurrentCalls") #This is needed so Intercom doesn't work when someone is on a call and also for limiting<br>
# how many calls a user can receive</div>
<div><br># ----- usrloc params -----<br>modparam("usrloc", "db_mode", 3) # -- This Mode is required in order for avp_db_query() changes to the Location table to be reflected in realtime<br>modparam("usrloc", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>
modparam("usrloc", "use_domain", 1)<br>modparam("usrloc", "nat_bflag", 6) # This is set for the Mediaproxy Relay</div>
<div># ----- uri params -----<br>modparam("uri", "use_uri_table", 0)<br>modparam("uri", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>modparam("uri", "use_domain", 1)</div>
<div># ----- acc params -----<br>/* what sepcial events should be accounted ? */<br>modparam("acc", "early_media", 0)<br>modparam("acc", "report_ack", 0)<br>modparam("acc", "report_cancels", 0)<br>
/* by default ww do not adjust the direct of the sequential requests.<br> if you enable this parameter, be sure the enable "append_fromtag"<br> in "rr" module */<br>modparam("acc", "detect_direction", 0)<br>
/* account triggers (flags) */<br>modparam("acc", "failed_transaction_flag", 1)<br>modparam("acc", "log_level", 1)<br>modparam("acc", "log_flag", 1)<br>modparam("acc", "log_missed_flag", 1)<br>
#modparam("aaa_radius", "radius_config", "/usr/local/etc/opensips/radius/client.conf")<br>#modparam("acc", "aaa_url", "radius:/usr/local/etc/opensips/radius/client.conf")<br>
modparam("acc", "aaa_flag", 1)<br>modparam("acc", "aaa_missed_flag", 1)<br># <a href="http://n2.nabble.com/How-can-handle-bye-event-in-Opensips-wesip-td2969309.html#a2969309">http://n2.nabble.com/How-can-handle-bye-event-in-Opensips-wesip-td2969309.html#a2969309</a><br>
# This is the config I used for ACC flags<br>modparam("acc", "aaa_extra", "User-Name=$Au; \<br> Calling-Station-Id=$from; \<br> Called-Station-Id=$avp(s:called_station_id); \<br>
Sip-Translated-Request-URI=$ru; \<br> Sip-RPid=$avp(s:rpid); \<br> Source-IP=$avp(s:source_ip); \<br> Source-Port=$avp(s:source_port); \<br>
SIP-Proxy-IP=$avp(s:sip_proxy_ip); \<br> Canonical-URI=$avp(s:can_uri); \<br> Billing-Party=$avp(s:billing_party); \<br>
Divert-Reason=$avp(s:divert_reason); \<br> User-Agent=$hdr(user-agent); \<br> Contact=$hdr(contact); \<br>
Event=$hdr(event); \<br> ENUM-TLD=$avp(s:enum_tld); \<br> From-Header=$hdr(from); \<br> SIP-Application-Type=$avp(s:sip_application_type)")</div>
<div># ----- auth_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br> authentication */<br>modparam("auth_db", "calculate_ha1", 0)<br>modparam("auth_db", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>
modparam("auth_db", "password_column", "ha1")<br>###### The following will be for Memcached passwords<br>modparam("auth_db", "load_credentials", "$avp(i:55)=ha1")</div>
<div># ----- auth params -----<br>modparam("auth", "disable_nonce_check", 1) # This fixes the issue where OpenSIPS proxies that are far away from the MySQL<br> # Database and when the proxies queries the database the latency<br>
# messes up calls<br>###### The following will be for Memcached passwords and usernames<br>modparam("auth","username_spec","$avp(i:54)")<br>modparam("auth","password_spec","$avp(i:55)")</div>
<div># ----- alias_db params -----<br>modparam("alias_db", "db_url","mysql://opensips:********@173.x.x.219/opensips")<br>modparam("alias_db", "user_column", "username")<br>
modparam("alias_db", "domain_column", "domain")<br>modparam("alias_db", "alias_user_column", "alias_username")<br>modparam("alias_db", "alias_domain_column", "alias_domain")<br>
#modparam("alias_db", "use_domain", 1)<br>modparam("alias_db", "domain_prefix", "sip.")</div>
<div># ----- domain params -----<br>/* uncomment the following lines to enable multi-domain detection<br> support */<br>modparam("domain", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>
modparam("domain", "db_mode", 1) # Use caching</div>
<div><br># ----- group params -----<br>/* uncomment the following lines to enable multi-domain detection<br> support */<br>modparam("group", "db_url", "mysql://opensips:********@173.x.x.219/opensips")</div>
<div><br># ----- avpops params -----<br>modparam("avpops","db_url","mysql://opensips:********@173.x.x.219/opensips")<br>modparam("avpops","avp_table","usr_preferences")<br>
modparam("avpops", "use_domain", 1)</div>
<div><br># ----- uac params -----<br>#modparam("uac","credential","XXXXXXX:XXXXXX :XXXXX")<br>modparam("uac","auth_realm_avp","$avp(i:10)")<br>modparam("uac","auth_username_avp","$avp(i:11)")<br>
modparam("uac","auth_password_avp","$avp(i:12)")<br>modparam("uac","credential","$avp(i:11):$avp(i:10):$avp(i:12)")</div>
<div><br># ----- nat_traversal params -----<br>modparam("nat_traversal", "keepalive_interval", 90)<br>modparam("nat_traversal", "keepalive_method", "OPTIONS")<br>modparam("nat_traversal", "keepalive_from", "sip:keepalive@ae")<br>
modparam("nat_traversal", "keepalive_state_file", "/var/run/opensips/keepalive_state")</div>
<div><br># ----- nathelper params -----<br>modparam("nathelper", "sipping_bflag", 7)<br>modparam("nathelper","received_avp", "$avp(i:42)")<br>modparam("nathelper", "sipping_from", "sip:pinger@ae")<br>
modparam("nathelper", "natping_interval", 30)</div>
<div> </div>
<div># ----- mediaproxy params -----<br>modparam("mediaproxy", "mediaproxy_socket", "/var/run/mediaproxy/dispatcher.sock")</div>
<div><br># ----- tm params -----<br>modparam("tm", "fr_inv_timer", 100) #When ringing callee and receive a 180 RINGER reply after x seconds failover<br>modparam("tm", "fr_inv_timer_avp", "$avp(s:fr_inv_timer)")</div>
<div><br># ----- permissions params -----<br>modparam("permissions","db_url","mysql://opensips:********@173.x.x.219/opensips")</div>
<div><br># ----- B2BUA params -----<br>#modparam("b2b_entities", "server_address", "sip:b2bua@173.x.x.252:5060")<br>#modparam("b2b_entities", "script_req_route", "b2b_request")<br>
#modparam("b2b_entities", "script_reply_route", "b2b_reply")<br>#modparam("b2b_logic", "script_scenario", "/usr/local/etc/opensips/B2BUA/scenario_script.xml")</div>
<div><br># ----- pua params -----<br>modparam("pua", "db_url", "mysql://opensips:********@173.x.x.219/opensips")</div>
<div><br># ----- pua_usrloc params -----<br>modparam("pua_usrloc", "default_domain", "ae")<br>modparam("pua_usrloc", "presence_server", "sip:173.x.x.252:5060")</div>
<div><br># ----- pua_bla params -----<br>modparam("pua_bla", "server_address", "sip:173.x.x.252:5060")<br>modparam("pua_bla", "default_domain", "ae")<br>modparam("pua_bla", "header_name", "Sender")<br>
modparam("pua_bla", "presence_server", "sip:pa@ae")</div>
<div><br># ----- presence params -----<br>/* uncomment the following lines if you want to enable presence */<br>modparam("presence", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>
modparam("presence", "server_address", "sip:sa@173.x.x.252:5060")<br>modparam("presence", "mix_dialog_presence", 1)<br>modparam("presence", "clean_period", 30)<br>
modparam("presence", "fallback2db", 1)</div>
<div> </div>
<div># ----- presence_xml params -----<br>modparam("presence_xml", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>modparam("presence_xml", "force_active", 1)<br>
modparam("presence_xml", "pidf_manipulation", 1)<br>modparam("presence_xml", "integrated_xcap_server", 1)</div>
<div># -- pua_dialoginfo params --<br>modparam("pua_dialoginfo", "presence_server", "sip:sa@173.x.x.252:5060")<br>modparam("pua_dialoginfo", "callee_spec_param", "$avp(i:20)") # This is needed for Call Pickup<br>
modparam("pua_dialoginfo", "caller_spec_param", "$avp(i:21)") # This is needed for Call Pickup</div>
<div><br># -- rls params --<br>modparam("rls", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br>modparam("rls", "server_address", "sip:173.x.x.252:5060")<br>
modparam("rls", "to_presence_code", 5)<br>modparam("rls", "integrated_xcap_server", 1)<br>modparam("rls", "presence_server", "sip:173.x.x.252:5060")<br>
modparam("rls", "rls_event", "xcap-diff")<br>modparam("rls", "rls_event", "ua-profile")</div>
<div> </div>
<div># -- closeddial params -- <br>modparam("closeddial", "db_url", "mysql://opensips:********@173.x.x.219/opensips")<br><br><br></div>
<div class="gmail_quote">On Wed, Dec 8, 2010 at 12:00 PM, Anca Vamanu <span dir="ltr"><<a href="mailto:anca@opensips.org">anca@opensips.org</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div bgcolor="#ffffff" text="#000000">Hi Duane,<br><br>Can you please give the list of loaded modules ( it would help investigating) ?<br><br>Regards,<br><font color="#888888"><pre cols="72">--
Anca Vamanu
<a href="http://www.voice-system.ro/" target="_blank">www.voice-system.ro</a></pre></font>
<div>
<div></div>
<div class="h5"><br><br>On 12/04/2010 11:27 PM, Duane Larson wrote:
<blockquote type="cite">
<div>One other piece of information on this issue.</div>
<div> </div>
<div>The last couple of days I have been trying to set up Redundant High-Availability. Because of this my client phones are not talking to the OpenSIPS service. So there has been absolutely no SIP messages going to the service yet it has still done random coredumps throughout the day and night. Very odd.</div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Nov 30, 2010 at 1:20 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Hi Duane,<br><br>yes, that is...but fortunately does not provide the information I was hoping for....<br>
<br>Is it ok if I will send you a patch that will enable kind of hunting for this bug ?<br><br>Regards,<br>Bogdan<br><br>Duane Larson wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>I believe this is what you wanted<br> (gdb) frame 2<br>#2 0x00007f176faf8f22 in db_mysql_delete (_h=0x812f20, _k=0x7fff61728980, _o=0x7fff61728960, _v=0x7fff61728900, _n=2) at dbase.c:893<br>893 ret = db_mysql_do_prepared_query(_h, &query_holder, _v, _n, NULL, 0);<br>
<br>(gdb) print _h<br>$2 = (const db_con_t *) 0x812f20<br><br>(gdb) print _h->curr_ps<br>$3 = (db_ps_t *) 0x7f176c46d2b0<br><br>(gdb) print (struct prep_stmt*)(*(_h)->curr_ps)<br>$4 = (struct prep_stmt *) 0x813650<br>
<br>(gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts<br>$5 = (struct my_stmt_ctx *) 0x814d10<br><br>(gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s<br>$6 = 0x814d48 "watchersdelete from watchers where inserted_time<? AND status=?.26705.61.7"<br>
<br>(gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s<br>$7 = 0x814d50 "delete from watchers where inserted_time<? AND status=?.26705.61.7"<br><br></div>
<div>On Wed, Nov 24, 2010 at 5:29 AM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a> <mailto:<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>>> wrote:</div>
</blockquote></blockquote></div></blockquote><br></div></div></div><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>