Re: [SR-Users] How to run MySQL queries in Kamailio

2016-04-28 Thread SamyGo
Hi Fuad, I think you should put the db return value in am avp before using it in the sl_send_reply. $avp(ip) = $avp(ra=>ip) Or whatever the syntax is. Make sure that the DB query is returning the required value. Also I guess just using a 302 is not enough and you need to set the proper contact hea

Re: [SR-Users] dlg_bridge

2016-04-28 Thread huseyin kalyoncu
Hello Daniel After all Kamailio was not calling set_contact_alias on reply received from itself. So in reply_route block calling following code resolved the issue. if (src_ip == "KAMAILIO_IP_ADDRESS" && status == "200") { if ($fU == "click2call") {

[SR-Users] How to run MySQL queries in Kamailio

2016-04-28 Thread Ahmad Fuad
Dear Support, Kindly find below my Database Table (kamailio.ext). Column names are "ext" and "ip" mysql> select * from ext -> ; +--++ | ext | ip | +--++ | 202 | 192.168.55.157 | | 203 | 192.168.55.158 | | 204 | 192.168.55.159 | +--+-

Re: [SR-Users] kamailio-radius RPM for Centos

2016-04-28 Thread Antonio Reale
Thanks Daniel, just completed the building of all Centos and Redhat rpms with RADIUS support. Regards, Antonio. Il 28/04/2016 17:46, Daniel-Constantin Mierla ha scritto: Hello, thanks for pursuing further on this! I granted you (user r4ndomx) access to kamailio project on opensuse build

Re: [SR-Users] dlg_bridge

2016-04-28 Thread huseyin kalyoncu
Hello Daniel I forgot to mention when I sent the capture file. There is only single Kamailio instance running but It listens multiple ports. 5090 for outside traffic and 5060 for inside traffic (other Kamailio servers, FS servers, etc.) On Wed, Apr 27, 2016 at 7:49 PM, huseyin kalyoncu wrote: >

Re: [SR-Users] kamailio-radius RPM for Centos

2016-04-28 Thread Daniel-Constantin Mierla
Hello, thanks for pursuing further on this! I granted you (user r4ndomx) access to kamailio project on opensuse build service. You can make there the same setting as you did for your repo to get the radius packages built. Let me know if you need anything else. Cheers, Daniel On 27/04/16 19:44,

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
Hi. Try something like this $var(valor)=0; $var(valor) = $dbr(ra=>[0,0]); Use $var(valor) for that purpose. I will check address table if you plan to use some ip authentication or similar. Its more powerful if you are looking for that BR 2016-04-28 16:19 GMT+02:00 Shahid Mehmood : > Tha

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Shahid Mehmood
Thanx ur kind reply sql_query("cb", "select ip from ext where ext='$rU'", "ra"); $var(a)= sql_result_free("ra"); i have an other question . how i get data return from sql query. i get 1 from sql_result_free("ra"); i need ip address like below mysql> select ip from ext where ext=202 -> ; +--

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
Just a point . Its not needed to resend same email every day. Will try to do the best with mailing list, but sometimes we are ill, occupied.. or just do not know what to answer.. BR 2016-04-27 16:18 GMT+02:00 Shahid Mehmood : > Dear All, > i am getting error when i trying to fetch da

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
Ups Sorry #!ifdef WITH_MYSQL loadmodule "db_mysql.so" #!endif modparam("sqlops","sqlcon","cb=>mysql://root:pass@IP/kamailio") if($rU=~"^1[0-9][0-9]$") { sql_query("cb", "select asterisk from x where extension='$rU'","valora"); sql_result_free("valora"); } With no issues.. Any error on mysql¿

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
Hi Im my case modparam("sqlops","sqlcon","ca=>mysql://root:pass@IP/kamailio") 2016-04-28 12:13 GMT+02:00 Shahid Mehmood : > Dear All, > i am getting error when i trying to fetch data from mysql data > base using kamailio. > > i have following code into kamailio.cfg file > > loa

Re: [SR-Users] Kamailio IMS_QOS

2016-04-28 Thread José Seabra
Hi Jason, I understood it, the issue here is that i was trying to use ims_qos module in a non IMS network and my frontend component isn't the Kamailio server. But now I understood that the requirement is having this component in the frontend of network in order to have the correct information fro

[SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Shahid Mehmood
Dear All, i am getting error when i trying to fetch data from mysql data base using kamailio. i have following code into kamailio.cfg file loadmodule "db_mysql.so" loadmodule "sqlops.so" modparam("sqlops","sqlcon","ca=>mysql://root:123456@localhost/ka

Re: [SR-Users] Kamailio IMS_QOS

2016-04-28 Thread Jason Penton
Hi José Ivailo is correct here, you need to have p-cscf *be* the SBC or at least sit in front of one if it is not the SBC. If not you will effectively be sending "junk" to the PCRF and it will be impossible for it to signal the correct setup of bearers between UE and P-CSCF/SBC. Then, re. youre q

Re: [SR-Users] Kamailio IMS_QOS

2016-04-28 Thread José Seabra
Hi Ivo, That answers to my doubts. Thank you Regards José 2016-04-27 23:22 GMT+01:00 Ivailo Dobrev : > Hi Jose, > > Framed IP or some king of hashing over IP/identitiy/APN... is used from > PCRF for session binding. If I understand question right the short answer > is that reservation from P