<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-3">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I think , first problem is that Kamailio couldn t open <span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important">route/register.cfg
file. Secondly , Could you share line 278 in kamailio.cfg.</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important">it should be
like
<pre style="font-family: monospace; background-color: rgb(252, 255, 252); border: 1px solid rgb(153, 204, 204); color: rgb(0, 0, 0); padding-left: 15pt; overflow: auto; border-radius: 2.5px; font-size: 15px">modparam("sqlops","sqlcon","cb=>mysql://Mysql:password@localhost/pcscf")</pre>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Cheers.</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Yasin CANER</span></div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> sr-users <sr-users-bounces@lists.kamailio.org> on behalf of Yağız AYDIN <ygzaydns@gmail.com><br>
<b>Sent:</b> Thursday, January 17, 2019 2:41 PM<br>
<b>To:</b> Kamailio (SER) - Users Mailing List<br>
<b>Subject:</b> [SR-Users] Invalid sqlops parameter</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>
<div>Hello,<br>
<br>
</div>
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.<br>
<br>
</div>
<div>While I'm trying to execute pcscf module, following errors appear:</div>
<div><br>
</div>
<div>root@yagiz-HP-ZBook-15:/usr/local/src/kamailio# kamailio -f /etc/kamailio/pcscf/kamailio.cfg -c<br>
loading modules under config path: /usr/lib/x86_64-linux-gnu/kamailio/modules<br>
0(12536) ERROR: sqlops [sql_api.c:669]: sql_parse_param(): invalid sqlops parameter [mysql://Mysql@localhost/pcscf] at [29]<br>
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<br>
0(12536) INFO: pv [pv_shv.c:60]: shvar_init_locks(): locks array size 16<br>
<b><u> 0(12536) CRITICAL: <core> [core/cfg.lex:1599]: sr_push_yy_state(): cannot open included file: route/register.cfg
</u></b>(/etc/kamailio/pcscf/route/register.cfg)<br>
0(12536) : <core> [core/cfg.lex:1308]: yylex(): error at /etc/kamailio/pcscf/kamailio.cfg line 907<br>
</div>
<div><br>
</div>
<div>I have set my sqlops parameter as : <br>
</div>
<div><br>
</div>
<div>#!define SQLOPS_DBURL "mysql://Mysql@localhost/pcscf"<br>
<br>
</div>
<div>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)<br>
<br>
</div>
<div>Here is my pcscf.cfg file<br>
</div>
<div># IP-Adress for incoming SIP-Traffic, in the following format:<br>
<br>
# SIP / UDP<br>
listen=udp:<a href="http://10.3.0.188:5060">10.3.0.188:5060</a><br>
# SIP / TCP<br>
#listen=tcp:<a href="http://11.22.33.44:5060">11.22.33.44:5060</a><br>
# SIP / TCP/TLS<br>
#listen=tls:<a href="http://11.22.33.44:5061">11.22.33.44:5061</a><br>
<br>
alias=<a href="http://pcscf.mnc001.mcc001.3gppnetwork.org">pcscf.mnc001.mcc001.3gppnetwork.org</a><br>
<br>
#!define MY_WS_PORT 80<br>
#!define MY_WSS_PORT 443<br>
<br>
#!define PCSCF_URL "sip:<a href="http://pcscf.mnc001.mcc001.3gppnetwork.org">pcscf.mnc001.mcc001.3gppnetwork.org</a>"<br>
<br>
#!define TCP_PROCESSES 8<br>
<br>
#!subst "/NETWORKNAME/<a href="http://mnc001.mcc001.3gppnetwork.org/">mnc001.mcc001.3gppnetwork.org/</a>"<br>
#!subst "/HOSTNAME/<a href="http://pcscf.mnc001.mcc001.3gppnetwork.org/">pcscf.mnc001.mcc001.3gppnetwork.org/</a>"<br>
<br>
# SIP-Address of capturing node, if not set, capturing is disabled.<br>
##!define CAPTURE_NODE "sip:<a href="http://127.0.0.1:9060">127.0.0.1:9060</a>"<br>
<br>
# Allowed IPs for XML-RPC-Queries<br>
##!define XMLRPC_WHITELIST_1 "127.0.0.1"<br>
##!define XMLRPC_WHITELIST_2 "127.0.0.1"<br>
##!define XMLRPC_WHITELIST_3 "127.0.0.1"<br>
<br>
#!define RTPPROXY_ADDRESS "udp:<a href="http://10.1.2.186:22222">10.1.2.186:22222</a>"<br>
<br>
# Databases:<br>
#!define DB_URL "mysql://Mysql@localhost/pcscf"<br>
##!define DB_URL "mysql://kamailio:kamailiorw@localhost/kamailio/pcscf"<br>
##!define DB_URL2 "con2=>mysql://<a href="http://pcscf:heslo@127.0.0.1/pcscf">pcscf:heslo@127.0.0.1/pcscf</a>"<br>
<br>
#!define SQLOPS_DBURL "mysql://Mysql@localhost/pcscf"<br>
##!define SQLOPS_DBURL "mysql://root@localhost/pcscf"<br>
<br>
#! Optional: Server-URL for Websocket-Requests<br>
##!define WEBSOCKET_WEBSERVER "<a href="http://phone.ng-voice.com">phone.ng-voice.com</a>"<br>
<br>
##!define TRF_FUNCTION "<a href="http://trf.mnc001.mcc001.3gppnetwork.org">trf.mnc001.mcc001.3gppnetwork.org</a>"<br>
<br>
#<br>
# Several features can be enabled using '#!define WITH_FEATURE' directives:<br>
#<br>
# *** To run in debug mode:<br>
# - define WITH_DEBUG<br>
#<br>
# *** To enable nat traversal execute:<br>
# - define WITH_NAT<br>
# - define the connection to the RTP-Proxy: RTPPROXY_ADDRESS<br>
#<br>
# *** To force alls calls through the RTP-Proxy<br>
# - this will automagically enable NAT-Traversal<br>
# - define FORCE_RTPRELAY<br>
#<br>
# *** To enable IPv4/IPv6 Translation (RTPProxy)<br>
# - this will automagically enable NAT-Traversal<br>
# - define WITH_RTPIPV4<br>
#<br>
# *** To enable TCP support execute:<br>
# - define WITH_TCP<br>
#<br>
# *** To enable TLS support execute:<br>
# - adjust CFGDIR/tls.cfg as needed<br>
# - define WITH_TLS<br>
# - this will automagically enable TCP<br>
#<br>
# *** To enable XMLRPC support execute:<br>
# - define WITH_XMLRPC<br>
# - this will automagically enable TCP<br>
#<br>
# *** To enable anti-flood detection execute:<br>
# - adjust pike and htable=>ipban settings as needed (default is<br>
# block if more than 16 requests in 2 seconds and ban for 300 seconds)<br>
# - define WITH_ANTIFLOOD<br>
#<br>
# *** To enable the Rx-Interface:<br>
# - Configure Rx-Diameter-Interface in pcscf.xml<br>
# - define WITH_RX<br>
#<br>
# *** To enable a Homer SIP-Capter-Node:<br>
# - define CAPTURE_NODE with a proper address<br>
#<br>
# *** To enable support for the SEMS-SBC<br>
# - define WITH_SBC<br>
# - configure dispatcher-list with a set of SBC's<br>
<br>
#<br>
# Enabled Features for this host:<br>
##!define WITH_DEBUG<br>
#!define WITH_NAT<br>
#!define WITH_NATPING<br>
#!define FORCE_RTPRELAY<br>
##!define WITH_TLS<br>
##!define WITH_XMLRPC<br>
##!define WITH_IPBLOCK<br>
##!define WITH_ANTIFLOOD<br>
##!define WITH_RX<br>
##!define WITH_RX_REG<br>
##!define WITH_RX_CALL<br>
##!define WITH_TCP<br>
##!define WITH_RTPIPV4<br>
##!define WITH_SBC<br>
##!define WITH_SBC_CALL<br>
##!define WITH_REGINFO<br>
##!define WITH_RTPPING<br>
##!define WITH_WEBSOCKET<br>
</div>
<div><br>
</div>
<div>Any helps would be appreciated,<br>
</div>
<div>Regards,<br>
</div>
<div>Yağız<br>
</div>
<div>
<div>
<div>
<div><br>
-- <br>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr"><br>
<br>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>