[OpenSIPS-Users] Tracer module integration with Opensips 3.4

[Bogdan-Andrei Iancu]

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, amel.guesmi at sofrecom.com 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 <amel.guesmi at sofrecom.com>
> *Envoyé :* mercredi 8 mai 2024 15:53
> *À :* OpenSIPS users mailling list <users at lists.opensips.org>
> *Cc :* DL FT-FR Sbc TEAM <sbc.team at sofrecom.com>
> *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 <users at lists.opensips.org>
> *Cc :* DL FT-FR Sbc TEAM <sbc.team at sofrecom.com>
> *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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20240611/81f5d452/attachment.html>