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(a)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(a)gmail.com>
*Sent:* Tuesday, April 5, 2022 12:09 PM
*To:* Henning Westerholt <hw(a)gilawa.com>
*Cc:* Kamailio (SER) - Users Mailing List <sr-users(a)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(a)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(a)gmail.com>
*Sent:* Tuesday, April 5, 2022 12:01 PM
*To:* Henning Westerholt <hw(a)gilawa.com>
*Cc:* Kamailio (SER) - Users Mailing List <sr-users(a)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(a)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(a)lists.kamailio.org> *On Behalf Of *bayu
p
*Sent:* Tuesday, April 5, 2022 11:04 AM
*To:* Kamailio (SER) - Users Mailing List <sr-users(a)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,