Re: [SR-Users] Invalid sqlops parameter

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@lists.kamailio.org on behalf of Yağız AYDIN ygzaydns@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@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:5060http://10.3.0.188:5060 # SIP / TCP #listen=tcp:11.22.33.44:5060http://11.22.33.44:5060 # SIP / TCP/TLS #listen=tls:11.22.33.44:5061http://11.22.33.44:5061

alias=pcscf.mnc001.mcc001.3gppnetwork.orghttp://pcscf.mnc001.mcc001.3gppnetwork.org

#!define MY_WS_PORT 80 #!define MY_WSS_PORT 443

#!define PCSCF_URL "sip:pcscf.mnc001.mcc001.3gppnetwork.orghttp://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:9060http://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:22222http://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/pcscfhttp://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.comhttp://phone.ng-voice.com"

##!define TRF_FUNCTION "trf.mnc001.mcc001.3gppnetwork.orghttp://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

--