Hi,
For sure it's because of the missing db_mysql module - check *ALL* the
opensips logs, most probably the module failed to load.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
https://www.siphub.com
On 07.06.2024 15:54, [email protected] wrote:
Hello Bogdan,
Yes we load the module
"db_mysql.so" /* This is a module which provides MySQL
connectivity for OpenSIPS *
BR, Amel
Hi,
Quick one: do you load the db_mysql.so module too ?
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
https://www.siphub.com
*De :*GUESMI Amel SOFRECOM <[email protected]>
*Envoyé :* mercredi 8 mai 2024 15:53
*À :* OpenSIPS users mailling list <[email protected]>
*Cc :* DL FT-FR Sbc TEAM <[email protected]>
*Objet :* RE: Tracer module integration with Opensips 3.4
Hello,
Any help please regarding my question ?
Thank you
BR, Amel
*De :*GUESMI Amel SOFRECOM
*Envoyé :* lundi 29 avril 2024 10:57
*À :* OpenSIPS users mailling list <[email protected]>
*Cc :* DL FT-FR Sbc TEAM <[email protected]>
*Objet :* Tracer module integration with Opensips 3.4
Hello Everyone,
I need your support to add tracer module in order tostore
incoming/outgoing SIP messages in database.
I already add some configs to my opensips.cfg file:
*### Tracer ###*
*loadmodule "tracer.so"*
*modparam("tracer", "trace_on", 1)*
*modparam("tracer", "trace_local_ip", "opensips:5060")*
*modparam("tracer",
"trace_id","[tid]uri=mysql://opensips:opensipsrw@ossdb/opensips;table=sip_trace;")
**….*
*if ( is_method("INVITE")) {*
*record_route();*
*do_accounting("db|log", "cdr|missed", "acc");*
*trace($var(trace_id), "d", "sip|xlog", $var(user));*
**
* t_relay();*
*exit;*
*}*
**
The error in Opensips logs is:
ERROR:core:db_check_api: module db_mysql does not export db_use_table
function
2024-04-25 09:29:10 Apr 25 10:29:10 [52] ERROR:tracer:get_db_struct:
*unable to bind database module*
2024-04-25 09:29:10 Apr 25 10:29:10 [52]
ERROR:tracer:parse_siptrace_id: Invalid parameters extracted!url
<mysql://opensips:opensipsrw@ossdb/opensips>! table name <sip_trace>!
2024-04-25 09:29:10 Apr 25 10:29:10 [52] ERROR:tracer:parse_trace_id:
*failed to parse tracer uri []*
2024-04-25 09:29:10 Apr 25 10:29:10 [52] CRITICAL:Traceback (last
included file at the bottom):
2024-04-25 09:29:10 Apr 25 10:29:10 [52] CRITICAL: 0.
/etc/opensips/opensips.cfg
2024-04-25 09:29:10 Apr 25 10:29:10 [52] CRITICAL:core:yyerror: parse
error in /etc/opensips/opensips.cfg:53:19-20: *Parameter <trace_id>
not found in module <tracer> - can't set*
2024-04-25 09:29:10 Apr 25 10:29:10 [52] CRITICAL:modparam("tracer",
"trace_on", 1)
2024-04-25 09:29:10 Apr 25 10:29:10 [52] CRITICAL:modparam("tracer",
"trace_local_ip", "opensips:5060")
2024-04-25 09:29:10 Apr 25 10:29:10 [52] CRITICAL:modparam("tracer",
"trace_id","[tid]uri=mysql://opensips:opensipsrw@ossdb/opensips;table=sip_trace;")
I think that the module should store the messages in sip_trace table
but I didn’t understand how to configure properly the trace_id with
mysql module.
Could you help me please ?
Thank you.
Best Regards,
Amel on behalf of my colleague Chaker
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
