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