Thx for the explanation Daniel.
Regards
Giovanni
From: sr-users [mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of
Daniel-Constantin Mierla
Sent: mercredi 11 mai 2016 11:45
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Kamailio and Oracle database
Hello Giovanni
Hello Giovanni,
it was a bit too late to get it in 4.4.1 -- the main reason for that is
that we do not add new features in stable branches and also avoid
breaking config file and database compatibility. This is not really a
new feature, but it introduces a new config mod param and didn't want to
Hello Daniel,
I see that the unixodbc changes have not been merged in branch 4.4. Should I
have done something on my side to have it merged on the 4.4 branch?
Thx
Giovanni
--
View this message in context:
Hello,
on the master branch (development). Then the commits will be backported
to stable branches using "git cherry-pick".
An important detail is to format the commit log messages as recommended
by the guidelines at:
-
Hello,
thx, I'll do it!
Tell me: do you want me to work on the main branch or on version 4.4.0?
Regards
Giovanni
--
View this message in context:
http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148288.html
Sent from the Users mailing list archive at
Hello,
thanks for pursuing this further and coming back with fixes!
You have to clone (fork) the kamailio repository to your github account,
commit your changes there and then make a pull request.
See the documentation at gihub.com for how to do it:
-
Hello Daniel,
I've updated the db_unixodbc module and tested it on our kamailio server:
all is working fine now and the watcher table is correctly updated.
Now, I'd like to push my modification on github. I'm totally new in using
github and need some help here.
I've created a github account,
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
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
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
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.
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.
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
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
>
>
>
>
> Giovanni
>
>
>
> *From:*Daniel-Constantin Mierla [mailto:mico...@gmail.com]
> *Sent:* lundi 2 mai 2016 10:49
> *To:* Mele Giovanni; Kamailio (SER) - Users Mailing List
> *Subject:* Re: [SR-Users] Kamailio and Oracle database
>
>
>
> Hello,
>
>
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]:
Giovanni
From: Daniel-Constantin Mierla [mailto:mico...@gmail.com]
Sent: lundi 2 mai 2016 10:49
To: Mele Giovanni; Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Kamailio and Oracle database
Hello,
hopefully I found and fixed the issue. The usrloc was setting the value for
time
ter surrounding the date.
>
>
>
> Regards
>
>
>
> Giovanni
>
>
>
> *From:*sr-users [mailto:sr-users-boun...@lists.sip-router.org] *On
> Behalf Of *Daniel-Constantin Mierla
> *Sent:* lundi 2 mai 2016 09:49
> *To:* Kamailio (SER) - Users Mailing List
>
ehalf Of
Daniel-Constantin Mierla
Sent: lundi 2 mai 2016 09:49
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Kamailio and Oracle database
Hello,
are there two single quote characters or one double quotes character? Can you
test if it works with double quotes instead of single q
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
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
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
>
Hello,
we are trying to connect our Kamailio SIP to an Oracle database. We tried
both db_oracle and db_unixodbc modules to connect to the DB.
With db_oracle, Kamailio core dumps when trying to access the
active_watchers table (caused by the oracle CLOB?). Here is the kamailio
logs:
Apr 29
25 matches
Mail list logo
