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 &lt;sr-users-bounces(a)lists.kamailio.org&gt; on behalf of Yağız AYDIN &lt;ygzaydns(a)gmail.com&gt; 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: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 --