line 468 are "modparam("lcr", "db_url", DBURL)"
it is replacement from previous line "modparam("lcr", "db_url", "mysql://kamailioro:kamailioro@localhost/kamailio")"

here capture on kamailio.cfg file by "DBURL" filtered.

kamailio# cat -n kamailio.cfg |grep -i DBURL
   122  #!ifndef DBURL
   123  #!define DBURL "mysql://kamailio:kamailiorw@localhost/kamailio"
   365  modparam("acc", "db_url", DBURL)
   374  modparam("usrloc", "db_url", DBURL)
   381  modparam("auth_db", "db_url", DBURL)
   389  modparam("permissions", "db_url", DBURL)
   397  modparam("alias_db", "db_url", DBURL)
   403  modparam("speeddial", "db_url", DBURL)
   409  modparam("domain", "db_url", DBURL)
   416  modparam("presence", "db_url", DBURL)
   419  modparam("presence_xml", "db_url", DBURL)
   468  modparam("lcr", "db_url", DBURL)

Pada tanggal Sel, 5 Apr 2022 pukul 17.28 Henning Westerholt <hw@gilawa.com> menulis:

Hello,

 

Ok, the module is installed. So, what is the line 468 from your cfg that produces the error?

 

Cheers,

 

Henning

 

--

Henning Westerholt – https://skalatan.de/blog/

Kamailio services – https://gilawa.com

 

From: bayu p <bayupmail@gmail.com>
Sent: Tuesday, April 5, 2022 12:09 PM
To: Henning Westerholt <hw@gilawa.com>
Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: Re: [SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"

 

What meaning of "system package management tools" ?

since my kamailio installation process did install below packages:

user@kamal:/etc/kamailio# dpkg -l |grep -i kamailio
kamailio                                   5.3.2-1build3                       very fast, dynamic and configurable SIP server
kamailio-mysql-modules:amd64               5.3.2-1build3                       MySQL database connectivity module for Kamailio
kamailio-outbound-modules:amd64            5.3.2-1build3                       SIP Outbound module for the Kamailio SIP server
kamailio-presence-modules:amd64            5.3.2-1build3                       SIP presence modules for Kamailio
kamailio-tls-modules:amd64                 5.3.2-1build3                       TLS support for the Kamailio SIP server (authentication, transport)
kamailio-websocket-modules:amd64           5.3.2-1build3                      WebSocket module for the Kamailio SIP server

 

Pada tanggal Sel, 5 Apr 2022 pukul 17.02 Henning Westerholt <hw@gilawa.com> menulis:

Hello,

 

do you’ve installed the mysql module for kamailio with system package management tools?

 

Cheers,

 

Henning

 

--

Henning Westerholt – https://skalatan.de/blog/

Kamailio services – https://gilawa.com

 

From: bayu p <bayupmail@gmail.com>
Sent: Tuesday, April 5, 2022 12:01 PM
To: Henning Westerholt <hw@gilawa.com>
Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: Re: [SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"

 

Ok, I got that point about syntax error.

I have compared the syntax with the other line format, but the result is "it is the same syntax". 

 

It could be related with lcr module error, due to my previous loading of lcr module.

 

 

Pada tanggal Sel, 5 Apr 2022 pukul 16.24 Henning Westerholt <hw@gilawa.com> menulis:

Hello,

 

You have some syntax errors in your cfg file. Have a look to the mentioned lines in your kamailio.cfg (e.g. line 468).

 

Cheers,

 

Henning

From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of bayu p
Sent: Tuesday, April 5, 2022 11:04 AM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"

 

Dear Expert, 

I found failure/critical status after restart kamailio 5.3.2. 

Could you please to share correct step to install/loading lcr module ?

 

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 :

 

 

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
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
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:
Apr  5 15:08:38 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
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
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
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:
Apr  5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
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
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
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:
Apr  5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
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
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
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:
Apr  5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
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
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
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:
Apr  5 15:08:39 kamal kamailio: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized



Kind Regards,