[SR-Users] Invalid sqlops parameter

Thu Jan 17 12:53:01 CET 2019

Hello,

I think , first  problem is that Kamailio couldn t open route/register.cfg file.  Secondly , Could you share line 278 in kamailio.cfg.

it should be like

modparam("sqlops","sqlcon","cb=>mysql://Mysql:password@localhost/pcscf")

Cheers.

Yasin CANER

________________________________
From: sr-users <sr-users-bounces at lists.kamailio.org> on behalf of Yağız AYDIN <ygzaydns at gmail.com>
Sent: Thursday, January 17, 2019 2:41 PM
To: Kamailio (SER) - Users Mailing List
Subject: [SR-Users] Invalid sqlops parameter

Hello,

I'm trying to install Kamailio IMS for my Ubuntu 18.04 device. I have followed the configuration files which are provided by installation, but I have a problem about sqlops module.

While I'm trying to execute pcscf module, following errors appear:

root at yagiz-HP-ZBook-15:/usr/local/src/kamailio# kamailio -f /etc/kamailio/pcscf/kamailio.cfg -c
loading modules under config path: /usr/lib/x86_64-linux-gnu/kamailio/modules
 0(12536) ERROR: sqlops [sql_api.c:669]: sql_parse_param(): invalid sqlops parameter [mysql://Mysql@localhost/pcscf] at [29]
 0(12536) CRITICAL: <core> [core/cfg.y:3449]: yyerror_at(): parse error in config file /etc/kamailio/pcscf/kamailio.cfg, line 278, column 60: Can't set module parameter
 0(12536) INFO: pv [pv_shv.c:60]: shvar_init_locks(): locks array size 16
 0(12536) CRITICAL: <core> [core/cfg.lex:1599]: sr_push_yy_state(): cannot open included file: route/register.cfg (/etc/kamailio/pcscf/route/register.cfg)
 0(12536) : <core> [core/cfg.lex:1308]: yylex(): error at /etc/kamailio/pcscf/kamailio.cfg line 907

I have set my sqlops parameter as :

#!define SQLOPS_DBURL "mysql://Mysql@localhost/pcscf"

PS: I have created necessary databases and tables which are mentioned on usrloc files ( which are ims_usrloc_pcscf-create.sql and ims_usrloc_scscf-create.sql)

Here is my pcscf.cfg file
# IP-Adress for incoming SIP-Traffic, in the following format:

# SIP / UDP
listen=udp:10.3.0.188:5060<http://10.3.0.188:5060>
# SIP / TCP
#listen=tcp:11.22.33.44:5060<http://11.22.33.44:5060>
# SIP / TCP/TLS
#listen=tls:11.22.33.44:5061<http://11.22.33.44:5061>

alias=pcscf.mnc001.mcc001.3gppnetwork.org<http://pcscf.mnc001.mcc001.3gppnetwork.org>

#!define MY_WS_PORT 80
#!define MY_WSS_PORT 443

#!define PCSCF_URL "sip:pcscf.mnc001.mcc001.3gppnetwork.org<http://pcscf.mnc001.mcc001.3gppnetwork.org>"

#!define TCP_PROCESSES 8

#!subst "/NETWORKNAME/mnc001.mcc001.3gppnetwork.org/<http://mnc001.mcc001.3gppnetwork.org/>"
#!subst "/HOSTNAME/pcscf.mnc001.mcc001.3gppnetwork.org/<http://pcscf.mnc001.mcc001.3gppnetwork.org/>"

# SIP-Address of capturing node, if not set, capturing is disabled.
##!define CAPTURE_NODE "sip:127.0.0.1:9060<http://127.0.0.1:9060>"

# Allowed IPs for XML-RPC-Queries
##!define XMLRPC_WHITELIST_1 "127.0.0.1"
##!define XMLRPC_WHITELIST_2 "127.0.0.1"
##!define XMLRPC_WHITELIST_3 "127.0.0.1"

#!define RTPPROXY_ADDRESS "udp:10.1.2.186:22222<http://10.1.2.186:22222>"

# Databases:
#!define DB_URL "mysql://Mysql@localhost/pcscf"
##!define DB_URL "mysql://kamailio:kamailiorw@localhost/kamailio/pcscf"
##!define DB_URL2 "con2=>mysql://pcscf:heslo@127.0.0.1/pcscf<http://pcscf:heslo@127.0.0.1/pcscf>"

#!define SQLOPS_DBURL "mysql://Mysql@localhost/pcscf"
##!define SQLOPS_DBURL "mysql://root@localhost/pcscf"

#! Optional: Server-URL for Websocket-Requests
##!define WEBSOCKET_WEBSERVER "phone.ng-voice.com<http://phone.ng-voice.com>"

##!define TRF_FUNCTION "trf.mnc001.mcc001.3gppnetwork.org<http://trf.mnc001.mcc001.3gppnetwork.org>"

#
# Several features can be enabled using '#!define WITH_FEATURE' directives:
#
# *** To run in debug mode:
#     - define WITH_DEBUG
#
# *** To enable nat traversal execute:
#     - define WITH_NAT
#     - define the connection to the RTP-Proxy: RTPPROXY_ADDRESS
#
# *** To force alls calls through the RTP-Proxy
#     - this will automagically enable NAT-Traversal
#     - define FORCE_RTPRELAY
#
# *** To enable IPv4/IPv6 Translation (RTPProxy)
#     - this will automagically enable NAT-Traversal
#     - define WITH_RTPIPV4
#
# *** To enable TCP support execute:
#     - define WITH_TCP
#
# *** To enable TLS support execute:
#     - adjust CFGDIR/tls.cfg as needed
#     - define WITH_TLS
#     - this will automagically enable TCP
#
# *** To enable XMLRPC support execute:
#     - define WITH_XMLRPC
#     - this will automagically enable TCP
#
# *** To enable anti-flood detection execute:
#     - adjust pike and htable=>ipban settings as needed (default is
#       block if more than 16 requests in 2 seconds and ban for 300 seconds)
#     - define WITH_ANTIFLOOD
#
# *** To enable the Rx-Interface:
#     - Configure Rx-Diameter-Interface in pcscf.xml
#     - define WITH_RX
#
# *** To enable a Homer SIP-Capter-Node:
#     - define CAPTURE_NODE with a proper address
#
# *** To enable support for the SEMS-SBC
#     - define WITH_SBC
#     - configure dispatcher-list with a set of SBC's

#
# Enabled Features for this host:
##!define WITH_DEBUG
#!define WITH_NAT
#!define WITH_NATPING
#!define FORCE_RTPRELAY
##!define WITH_TLS
##!define WITH_XMLRPC
##!define WITH_IPBLOCK
##!define WITH_ANTIFLOOD
##!define WITH_RX
##!define WITH_RX_REG
##!define WITH_RX_CALL
##!define WITH_TCP
##!define WITH_RTPIPV4
##!define WITH_SBC
##!define WITH_SBC_CALL
##!define WITH_REGINFO
##!define WITH_RTPPING
##!define WITH_WEBSOCKET

Any helps would be appreciated,
Regards,
Yağız

--

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190117/006f0a28/attachment.html>