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,