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
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',',
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
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.
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
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
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
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
> 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
>
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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=
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
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
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
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
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
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
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
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
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
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
34 matches
Mail list logo