<div dir="ltr"><div><br></div><div>line 468 are "modparam("lcr", "db_url", DBURL)"</div><div>it is replacement from previous line "modparam("lcr", "db_url", "mysql://kamailioro:kamailioro@localhost/kamailio")"</div><div><br></div><div>here capture on kamailio.cfg file by "DBURL" filtered.<br></div><div><br></div>kamailio# cat -n kamailio.cfg |grep -i DBURL<br> 122 #!ifndef DBURL<br> 123 #!define DBURL "mysql://kamailio:kamailiorw@localhost/kamailio"<br> 365 modparam("acc", "db_url", DBURL)<br> 374 modparam("usrloc", "db_url", DBURL)<br> 381 modparam("auth_db", "db_url", DBURL)<br> 389 modparam("permissions", "db_url", DBURL)<br> 397 modparam("alias_db", "db_url", DBURL)<br> 403 modparam("speeddial", "db_url", DBURL)<br> 409 modparam("domain", "db_url", DBURL)<br> 416 modparam("presence", "db_url", DBURL)<br> 419 modparam("presence_xml", "db_url", DBURL)<br> 468 modparam("lcr", "db_url", DBURL)<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Pada tanggal Sel, 5 Apr 2022 pukul 17.28 Henning Westerholt <<a href="mailto:hw@gilawa.com">hw@gilawa.com</a>> menulis:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="DE" style="overflow-wrap: break-word;">
<div class="gmail-m_5858664499662413683WordSection1">
<p class="MsoNormal"><span>Hello,<u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Ok, the module is installed. So, what is the line 468 from your cfg that produces the error?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Cheers,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Henning<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">-- <u></u>
<u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Henning Westerholt –
</span><span><a href="https://skalatan.de/blog/" target="_blank"><span lang="EN-GB" style="color:rgb(5,99,193)">https://skalatan.de/blog/</span></a></span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Kamailio services –
</span><span><a href="https://gilawa.com/" target="_blank"><span lang="EN-GB" style="color:rgb(5,99,193)">https://gilawa.com</span></a></span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal" style="margin-left:35.4pt"><b>From:</b> bayu p <<a href="mailto:bayupmail@gmail.com" target="_blank">bayupmail@gmail.com</a>>
<br>
<b>Sent:</b> Tuesday, April 5, 2022 12:09 PM<br>
<b>To:</b> Henning Westerholt <<a href="mailto:hw@gilawa.com" target="_blank">hw@gilawa.com</a>><br>
<b>Cc:</b> Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>><br>
<b>Subject:</b> Re: [SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">What meaning of "system package management tools" ?<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-right:0cm;margin-bottom:12pt;margin-left:35.4pt">
since my kamailio installation process did install below packages:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">user@kamal:/etc/kamailio# dpkg -l |grep -i kamailio<br>
kamailio 5.3.2-1build3 very fast, dynamic and configurable SIP server<br>
kamailio-mysql-modules:amd64 5.3.2-1build3 MySQL database connectivity module for Kamailio<br>
kamailio-outbound-modules:amd64 5.3.2-1build3 SIP Outbound module for the Kamailio SIP server<br>
kamailio-presence-modules:amd64 5.3.2-1build3 SIP presence modules for Kamailio<br>
kamailio-tls-modules:amd64 5.3.2-1build3 TLS support for the Kamailio SIP server (authentication, transport)<br>
kamailio-websocket-modules:amd64 5.3.2-1build3 WebSocket module for the Kamailio SIP server<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Pada tanggal Sel, 5 Apr 2022 pukul 17.02 Henning Westerholt <<a href="mailto:hw@gilawa.com" target="_blank">hw@gilawa.com</a>> menulis:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">
Hello,<u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB">do you’ve installed the mysql module for kamailio with system package management tools?</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB">Cheers,</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB">Henning</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB">-- </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB">Henning Westerholt – </span><a href="https://skalatan.de/blog/" target="_blank"><span lang="EN-GB" style="color:rgb(5,99,193)">https://skalatan.de/blog/</span></a><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB">Kamailio services – </span><a href="https://gilawa.com/" target="_blank"><span lang="EN-GB" style="color:rgb(5,99,193)">https://gilawa.com</span></a><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:35.4pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal" style="margin-left:70.8pt">
<b>From:</b> bayu p <<a href="mailto:bayupmail@gmail.com" target="_blank">bayupmail@gmail.com</a>>
<br>
<b>Sent:</b> Tuesday, April 5, 2022 12:01 PM<br>
<b>To:</b> Henning Westerholt <<a href="mailto:hw@gilawa.com" target="_blank">hw@gilawa.com</a>><br>
<b>Cc:</b> Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>><br>
<b>Subject:</b> Re: [SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-left:70.8pt">
<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
Ok, I got that point about syntax error.<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
I have compared the syntax with the other line format, but the result is "it is the same syntax". <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
It could be related with lcr module error, due to my previous loading of lcr module.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:70.8pt">
<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
Pada tanggal Sel, 5 Apr 2022 pukul 16.24 Henning Westerholt <<a href="mailto:hw@gilawa.com" target="_blank">hw@gilawa.com</a>> menulis:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB">Hello,</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB">You have some syntax errors in your cfg file. Have a look to the mentioned lines in your kamailio.cfg (e.g. line 468).</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB">Cheers,</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:70.8pt">
<span lang="EN-GB">Henning</span><u></u><u></u></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal" style="margin-left:106.2pt">
<b><span lang="EN-GB">From:</span></b><span lang="EN-GB"> sr-users <<a href="mailto:sr-users-bounces@lists.kamailio.org" target="_blank">sr-users-bounces@lists.kamailio.org</a>>
<b>On Behalf Of </b>bayu p<br>
<b>Sent:</b> Tuesday, April 5, 2022 11:04 AM<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>><br>
<b>Subject:</b> [SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"</span><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-left:106.2pt">
<span lang="EN-GB"> </span><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
Dear Expert, <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
I found failure/critical status after restart kamailio 5.3.2. <u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
Could you please to share correct step to install/loading lcr module ?<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
Previously, i did load lcr module in kamailio.cfg, found "error" db_bind_mod(): Module db_mysql not found. When changes lcr db_mysql inside kamailio.cfg file into DBURL, the error messages is transformed into as captured below :<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">
Apr 5 15:08:38 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: syntax error<br>
Apr 5 15:08:38 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: Invalid arguments<br>
Apr 5 15:08:38 kamal kamailio: CRITICAL: <core> [core/cfg.y:3539]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 32:<br>
Apr 5 15:08:38 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: syntax error<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: Invalid arguments<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3539]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 32:<br>
Apr 5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: syntax error<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: Invalid arguments<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3539]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 32:<br>
Apr 5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: syntax error<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: Invalid arguments<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3539]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 32:<br>
Apr 5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: syntax error<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3536]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 27-31: Invalid arguments<br>
Apr 5 15:08:39 kamal kamailio: CRITICAL: <core> [core/cfg.y:3539]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 468, column 32:<br>
Apr 5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized<br>
<br>
<br>
<br>
Kind Regards,<u></u><u></u></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote></div>