28 Aug
2012
28 Aug
'12
5:09 p.m.
Hi,
I would to query the Cassandra database for other information with either CQL or other
commands.
Could this be done through means of either avpops or sqlops, like an MySQL database.
This could be done through an external script but I would like to utilize the connection
that is already
established.
Thanks,
Bou
28 Aug
28 Aug
6:48 p.m.
Hello,
I am not familiar with the insights of cassandra module, but sqlops is
designed to deal with raw sql queries, so it might not work at all with
cassandra module.
Using avpops could work with avp_db_load(), because that function is
using the internal DB API INSERT which is in use by generic insert
operations, like storing the location records. But avp_db_query()
requires again sql query access, so it might not work.
Cheers,
Daniel
On 8/28/12 4:09 PM, Boudewyn Ligthart wrote:
Hi,
I would to query the Cassandra database for other information with
either CQL or other commands.
Could this be done through means of either avpops or sqlops, like an
MySQL database.
This could be done through an external script but I would like to
utilize the connection that is already
established.
Thanks,
Bou
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - http://asipto.com/u/kat
3 Sep
3 Sep
12:36 p.m.
Hi Daniel,
Thanks for the information.
The cassandra module does indeed not implement the raw_queries entry point. However I
have added this and the handling /parsing to allow
CQL queries to be passed by the script. I have tested this through means of AVPOPS module
and this is working.
What is the best way to feed this back to the Kamailio project?
Cheers,
Bou
From: Daniel-Constantin Mierla [mailto:miconda@gmail.com]
Sent: 28 August 2012 16:49
To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Cc: Boudewyn Ligthart
Subject: Re: [SR-Users] Cassandra module - query question
Hello,
I am not familiar with the insights of cassandra module, but sqlops is designed to deal
with raw sql queries, so it might not work at all with cassandra module.
Using avpops could work with avp_db_load(), because that function is using the internal DB
API INSERT which is in use by generic insert operations, like storing the location
records. But avp_db_query() requires again sql query access, so it might not work.
Cheers,
Daniel
On 8/28/12 4:09 PM, Boudewyn Ligthart wrote:
Hi,
I would to query the Cassandra database for other information with either CQL or other
commands.
Could this be done through means of either avpops or sqlops, like an MySQL database.
This could be done through an external script but I would like to utilize the connection
that is already
established.
Thanks,
Bou
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org<mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - http://asipto.com/u/kat
2:34 p.m.
Am Montag, 3. September 2012, 11:36:11 schrieb Boudewyn Ligthart:
The cassandra module does indeed not implement the
raw_queries entry point.
However I have added this and the handling /parsing to allow CQL queries to
be passed by the script. I have tested this through means of AVPOPS module
and this is working.
What is the best way to feed this back to the Kamailio project?
Hello Boudewyn,
sounds good, thank you. Just send your patch to our developer list, Anca will
probably then comment to it. You can also add it to our tracker, at:
http://sip-router.org/tracker/index.php
Best regards,
Henning
4:28 p.m.
Hi Henning,
Will do. Thanks.
Bou
-----Original Message-----
From: Henning Westerholt [mailto:hw@kamailio.org]
Sent: 03 September 2012 12:35
To: sr-users(a)lists.sip-router.org
Cc: Boudewyn Ligthart; miconda(a)gmail.com
Subject: Re: [SR-Users] Cassandra module - query question
Am Montag, 3. September 2012, 11:36:11 schrieb Boudewyn Ligthart:
The cassandra module does indeed not implement the
raw_queries entry point.
However I have added this and the handling /parsing to allow CQL
queries to be passed by the script. I have tested this through means
of AVPOPS module and this is working.
What is the best way to feed this back to the Kamailio project?
Hello Boudewyn,
sounds good, thank you. Just send your patch to our developer list, Anca will probably
then comment to it. You can also add it to our tracker, at:
http://sip-router.org/tracker/index.php
Best regards,
Henning
4466
days inactive
4472
days old
4 comments
3 participants
participants (3)
-
Boudewyn Ligthart -
Daniel-Constantin Mierla -
Henning Westerholt