Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-30 Thread Nathan Angelacos
Hi yaron, On 06/30/10 20:44, yaron nahcum wrote: Hi Daniel, I looked at the module and it seems more suitable for my needs. I have two questions regarding this module: Let's say your proprietary database has a table with "username" as one of the columns. For example, a table "Users" with the

Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-30 Thread Alex Balashov
On 06/30/2010 11:44 PM, yaron nahcum wrote: 1. It says that it is possible to use psuedo variables in the query. How is it done? I would like to make a query of the from username. Just include them straight in the literal query: sql_query("ca", "SELECT * FROM users WHERE username = '$fU'",

Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-30 Thread yaron nahcum
look for a specific value? The only way is to go over all the values with a loop? Yaron. From: Daniel-Constantin Mierla To: yaron nahcum Cc: sr-users@lists.sip-router.org Sent: Tue, June 29, 2010 6:57:53 PM Subject: Re: [SR-Users] using avpops for querying an

Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-29 Thread Daniel-Constantin Mierla
. *From:* Daniel-Constantin Mierla *To:* yaron nahcum *Cc:* sr-users@lists.sip-router.org *Sent:* Tue, June 29, 2010 6:57:53 PM *Subject:* Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2 Hello, look at sqlops module, it is more suitable

Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-29 Thread Henning Westerholt
On Tuesday 29 June 2010, yaron nahcum wrote: > Now, I am using the avpops module. I have been able to make it work using > the following configuration: > [..] > The thing is that I don't need to match the string CENTREX against the > domain- it is something I added because I couldn't find another

Re: [SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-29 Thread Daniel-Constantin Mierla
Hello, look at sqlops module, it is more suitable for custom sql queries: http://kamailio.org/docs/modules/stable/modules_k/sqlops.html Cheers, Daniel On 6/29/10 5:47 PM, yaron nahcum wrote: Hi, I have recently installed a kamailio server with release 3.0.2. I would like to use the kamilio as

[SR-Users] using avpops for querying an external db on kamailio 3.0.2

2010-06-29 Thread yaron nahcum
Hi, I have recently installed a kamailio server with release 3.0.2. I would like to use the kamilio as a redirect server that would recieve REGISTER messages from users and query a proprietary database that holds users information - if the users are registered to the serviceĀ it would redirect th