Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, On 03/05/16 08:18, gmele wrote: > Hello Daniel, > > I add a look to the db_unixodbc and the presence modules. To correct the > ODBC replace query that is visibly not supported by Oracle, I would like to > add a new parameter in the db_unixodbc module : replaceQuery = {0:1}. 0 = > not suppo

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, On 02/05/16 16:22, gmele wrote: > Hello Daniel, > > I'm now investigating the presence notification module problem and the odbc > query: > > replace watchers > (presentity_uri,watcher_username,watcher_domain,event,status,inserted_time,reason > ) values ('sip:xxx@zzz','y',',

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello Daniel, I add a look to the db_unixodbc and the presence modules. To correct the ODBC replace query that is visibly not supported by Oracle, I would like to add a new parameter in the db_unixodbc module : replaceQuery = {0:1}. 0 = not supported, 1 = supported (default). Now, in the presence

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, On 02/05/16 15:25, gmele wrote: > Hello Daniel, > > I found the problem: kamctl tool for oracle created a BLOB for the BODY > column of table PRESENTITY. > > I changed it to CLOB and now it works better. OK, good to know -- perhaps we have to change the definition for oracle sql scripts.

Re: [SR-Users] xmlrpc crash

2016-05-02 Thread Daniel-Constantin Mierla
These ones are no longer related to xmlrpc, but triggered by an sqlops query - first bracktrace, the other two are during the signal handling. The one for sqlops leads quite a bit inside the libmysqlclient, which can happen because there is a buffer overflow in kamailio for the operations in the s

Re: [SR-Users] xmlrpc crash

2016-05-02 Thread Juha Heinanen
Daniel-Constantin Mierla writes: > do you get any error messages in the logs or error code in the xmlrpc > reply? no error messages. the crash does not happen immediate when xmlrpc request is served. in the example below, the crash came about 20 sec later perhaps as result of some garbage colle

[SR-Users] Kamailio Client-Server

2016-05-02 Thread Shiv Patidar
hiii 1.We are writing our own SIP Client to test my Client i am using Kamailio server 2. So i am trying to map the identities used between Client and Server 3. If can possible can u please help me to the steps has to be follower to set identities common between Client and Server. 4. Or if u have so

Re: [SR-Users] Kamailio Client-Server

2016-05-02 Thread Alex Balashov
Shiv, ‎What do you mean by "identities"?‎ -- Alex Balashov | Principal | Evariste Systems LLC 1447 Peachtree Street NE, Suite 700 Atlanta, GA 30309 United States Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ Sent from my

Re: [SR-Users] Kamailio Client-Server

2016-05-02 Thread Olle E. Johansson
> On 02 May 2016, at 17:01, Shiv Patidar wrote: > > hiii > 1.We are writing our own SIP Client to test my Client i am using Kamailio > server > 2. So i am trying to map the identities used between Client and Server > 3. If can possible can u please help me to the steps has to be follower to >

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello Daniel, I'm now investigating the presence notification module problem and the odbc query: replace watchers (presentity_uri,watcher_username,watcher_domain,event,status,inserted_time,reason ) values ('sip:xxx@zzz','y',','presence',1,1462197118,''); This query will insert a

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello Daniel, I found the problem: kamctl tool for oracle created a BLOB for the BODY column of table PRESENTITY. I changed it to CLOB and now it works better. I still have some errors in a query to replace watchers (see below). I'm trying to investigate the problem before boring you with that.

[SR-Users] Using websocket server for events

2016-05-02 Thread Yuriy Gorlichenko
Hi is there is a valy to send websocket events (not only SIP) on remote subscribed client from config file? I just want make shure that i need to use redis for this staff insead of native websocket events ___ SIP Express Router (SER) and Kamailio (OpenSE

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Mele Giovanni
Hello Daniel, It seems oracle is expecting the body value converted as an hex string. i.e: opensip:giovanni.m...@ims-nagra.test 2016-05-02T11:06:54Z Should be 3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e3c70726573656e636520786d6c6e733a646d3d2275726e

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, I wrote in a previous email as well -- it seems that oracle doesn't like '\n' characters in the xml doc for presence. Can you check the docs for oracle and see if needs some special format in such case or maybe a special column definition? The xml is sent by the client, kamailio just has to

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, On 02/05/16 12:56, gmele wrote: > Hello, > > your patched fixed the problem! Thx. ok, thanks for testing and reporting the results. > > Now, I'm able to go further in my tests with Oracle and found some problem > during the REGISTER: The error is related to presence handling, not registrat

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello, it seems kamailio has a problem inserting a value in the oracle BLOB column BODY in the PRESENTITY table. I executed the command without the BLOB value and all is working fine. As soon as I try to insert the BLOB, it fails. Is there some incompatibility handling Oracle blobs? Regards

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello, your patched fixed the problem! Thx. Now, I'm able to go further in my tests with Oracle and found some problem during the REGISTER: May 2 12:42:50 newvm1 /usr/sbin/kamailio[554]: INFO: ims_auth [authorize.c:893]: authenticate(): UE said: 952ef9a21b01989f1b7000625f040e44 and we expect 95

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, indeed, the length without quotes was not adjusted. I pushed another patch, can you try again? Cheers, Daniel On 02/05/16 11:42, gmele wrote: > Hello Daniel, > > I patched our kamailio 4.4.0 with the following modified files: > > lib/srdb1/db_ut.h > lib/srdb1/db_ut.c > modules/urloc/dlist

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, you have to recompile everything, there was a patch in an internal library. You can also build the rpms by yourself. Cheers, Daniel On 02/05/16 10:53, Mele Giovanni wrote: > > Thx Daniel! > > > > I will get the code from git. What do I need to recompile? Only > unixodbc module? Any oth

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello Daniel, I patched our kamailio 4.4.0 with the following modified files: lib/srdb1/db_ut.h lib/srdb1/db_ut.c modules/urloc/dlist.c I recompiled and replaced libsrdb1.so.1.0 and usrloc.so. Now when kamailio starts, it still reports error: May 2 11:33:43 newvm1 /usr/sbin/kamailio[15899]: E

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Mele Giovanni
Thx Daniel! I will get the code from git. What do I need to recompile? Only unixodbc module? Any other lib? We are using installation done with the official rpm and would like to keep an environment as clean as possible and just change the modified libs. Thx for this quick support. Regards

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, hopefully I found and fixed the issue. The usrloc was setting the value for time already quoted and then the db api was quoting again. I guess you were using db-only mode for usrloc. Can you try again with latest git branch 4.4 or master? Report back the results in order to know if the iss

Re: [SR-Users] unixODBC failure/bug?

2016-05-02 Thread Nagorny, Dimitry
Von: sr-users [mailto:sr-users-boun...@lists.sip-router.org] Im Auftrag von Nagorny, Dimitry Gesendet: Montag, 2. Mai 2016 10:15 An: Kamailio (SER) - Users Mailing List Betreff: Re: [SR-Users] unixODBC failure/bug? Hi Daniel, I didn't have an example I just tried around with the unixODBC-module

Re: [SR-Users] unixODBC failure/bug?

2016-05-02 Thread Nagorny, Dimitry
Hi Daniel, I didn't have an example I just tried around with the unixODBC-module URL until it worked. The current state is as follows: odbcinst.ini: [MARIADB] Description=MariaDB ODBC Driver=/usr/lib64/libmyodbc5w.so Setup=/usr/lib64/libmyodbc5S.so Trace=no Server=10.250.5.16 Port=3306 UID= PWD=

Re: [SR-Users] SIP Notifications

2016-05-02 Thread Daniel-Constantin Mierla
At Kamailio World 2015 there was a presentation from Federico Cabiddu about Kamailio usage for mobiles (iirc, on the second day), the presentation can be found at: - http://www.kamailio.org/events/ The video recording is on KamailioWorld youtube channel. That should help you getting started fo

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Mele Giovanni
Hello, It is two single quote characters ('). If I try with one double quote character ("), it also fails. The only way to make it work is to have one single quote character surrounding the date. Regards Giovanni From: sr-users [mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of Dani

Re: [SR-Users] SIP Notifications

2016-05-02 Thread Safdar Khan
I mean, was the push notifications On Mon, May 2, 2016 at 12:59 PM, Daniel-Constantin Mierla wrote: > Hello, > > the subject and body are confusing, one is about SIP notifications (whch > are related to sip presence extensions) and the other one is about push > notifications (which are related t

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, are there two single quote characters or one double quotes character? Can you test if it works with double quotes instead of single quotes? Cheers, Daniel On 02/05/16 09:42, gmele wrote: > Hello Daniel, > > thx for your quick answer. > > After having failed with db_oracle module, we effe

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread gmele
Hello Daniel, thx for your quick answer. After having failed with db_oracle module, we effectively tried db_unixodbc. But even with unixodbc, we got some strange errors when kamailio tries to do queries including dates in the where clause: Example of an error reported by kamailio: May 2 08:30

Re: [SR-Users] unixODBC failure/bug?

2016-05-02 Thread Daniel-Constantin Mierla
OK, great it was sorted out. Btw, did you see any example using unixODBC for kamalio modules URLs? If yes, let us know, we need to correct that. Cheers, Daniel On 29/04/16 12:54, Nagorny, Dimitry wrote: > > Thanks a lot Daniel, that was the culprit. > > > > > > Best Regards > > *Dimitry Nago

Re: [SR-Users] set_body_multipart and memory leak

2016-05-02 Thread Daniel-Constantin Mierla
Hi Sergey, yes, they will be backported -- on my short to-do list. Cheers, Daniel On 29/04/16 13:08, Sergey Basov wrote: > Hi Daniel. > > Thank you, for commit, and sorry for wrong format. > > Can you apply this patches for kamailio 4.4 branch ? > > -- > Best regards, > Sergey Basov

Re: [SR-Users] SIP Notifications

2016-05-02 Thread Daniel-Constantin Mierla
Hello, the subject and body are confusing, one is about SIP notifications (whch are related to sip presence extensions) and the other one is about push notifications (which are related to mobile specific messaging to wake up apps). Which one are you actually looking for? Cheers, Daniel On 29/04

Re: [SR-Users] Kamailio and Oracle database

2016-05-02 Thread Daniel-Constantin Mierla
Hello, you have to use db_unixodbc for connecting to oracle. The db_oracle was not maintained for log time and perhaps it should be moved to obsolete folder. Cheers, Daniel On 29/04/16 17:17, gmele wrote: > Hello, > > we are trying to connect our Kamailio SIP to an Oracle database. We tried > b

Re: [SR-Users] xmlrpc crash

2016-05-02 Thread Daniel-Constantin Mierla
Hello, do you get any error messages in the logs or error code in the xmlrpc reply? In frame 2 the msg structure is NULL, should be the associated sip-http request. Cheers, Daniel On 01/05/16 15:48, Juha Heinanen wrote: > i was sending some xmlrpc requests to kamailio and got crash. > > -- juha