[SR-Users] CRITICAL after solve kamailio.cfg "module db_mysql not found"

bayu p bayupmail at gmail.com
Tue Apr 5 12:47:38 CEST 2022


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 at 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 at gmail.com>
> *Sent:* Tuesday, April 5, 2022 12:09 PM
> *To:* Henning Westerholt <hw at gilawa.com>
> *Cc:* Kamailio (SER) - Users Mailing List <sr-users at 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 at 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 at 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 at gmail.com>
> *Sent:* Tuesday, April 5, 2022 12:01 PM
> *To:* Henning Westerholt <hw at gilawa.com>
> *Cc:* Kamailio (SER) - Users Mailing List <sr-users at 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 at 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 at lists.kamailio.org> *On Behalf Of *bayu
> p
> *Sent:* Tuesday, April 5, 2022 11:04 AM
> *To:* Kamailio (SER) - Users Mailing List <sr-users at 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,
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20220405/9aea430e/attachment.htm>


More information about the sr-users mailing list