Invalid sqlops parameter - sr-users

17 Jan 2019

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@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
# SIP / TCP
#listen=tcp:11.22.33.44:5060
# SIP / TCP/TLS
#listen=tls:11.22.33.44:5061

alias=pcscf.mnc001.mcc001.3gppnetwork.org

#!define MY_WS_PORT 80
#!define MY_WSS_PORT 443

#!define PCSCF_URL "sip:pcscf.mnc001.mcc001.3gppnetwork.org"

#!define TCP_PROCESSES 8

#!subst "/NETWORKNAME/mnc001.mcc001.3gppnetwork.org/"
#!subst "/HOSTNAME/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"

# 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"

# 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"

#!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"

##!define TRF_FUNCTION "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

--