Re: [SR-Users] avp_db_query

Ok, thanks El 18/09/2016 a las 11:16, Federico Cabiddu escribió: Hi, you may use sqlops module for executing queries from routing script: http://www.kamailio.org/docs/modules/4.0.x/modules/sqlops.html Cheers, Federico On 17 Sep 2016 13:38, "Angel Elena"

Re: [SR-Users] avp_db_query

Hi, you may use sqlops module for executing queries from routing script: http://www.kamailio.org/docs/modules/4.0.x/modules/sqlops.html Cheers, Federico On 17 Sep 2016 13:38, "Angel Elena" wrote: > Hi, good moorning. > > I have a Kamailio 4.0 with avp module working. > > Now,

[SR-Users] avp_db_query

Hi, good moorning. I have a Kamailio 4.0 with avp module working. Now, I need write some values in my database and I don't find and example for this. if (avp_db_query("update subscriber set bloqueado=0 where name=x")) { } Is possible make this operation with avp_db_query

Re: [SR-Users] avp_db_query = affected rows

Hello, Thank you for the clarification. David On 13-07-15 09:53 AM, Alex Balashov wrote: On 07/15/2013 09:52 AM, David K wrote: Are you saying that avp_db_query is obsolete? It's not obsolete in the sense of deprecated, it's just not the most flexible, modern way to access SQL databases.

[SR-Users] avp_db_query = affected rows

Hello, I want to run an SQL UPDATE command from my kamailio script. I am using the command 'avp_db_query'. How can I get the number of affected rows after the UPDATE runs? David ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users

Re: [SR-Users] avp_db_query = affected rows

On 07/15/2013 09:40 AM, David K wrote: Hello, I want to run an SQL UPDATE command from my kamailio script. I am using the command 'avp_db_query'. How can I get the number of affected rows after the UPDATE runs? This is a very legacy, obsolete approach to custom SQL query interactions.

Re: [SR-Users] avp_db_query = affected rows

Hello, Are you saying that avp_db_query is obsolete? Thanks for the clarification, David On 13-07-15 09:44 AM, Alex Balashov wrote: On 07/15/2013 09:40 AM, David K wrote: Hello, I want to run an SQL UPDATE command from my kamailio script. I am using the command 'avp_db_query'. How can I

Re: [SR-Users] avp_db_query = affected rows

On 07/15/2013 09:52 AM, David K wrote: Are you saying that avp_db_query is obsolete? It's not obsolete in the sense of deprecated, it's just not the most flexible, modern way to access SQL databases. It was the only way to do it before 'sqlops' came along. -- Alex Balashov - Principal

Re: [SR-Users] avp_db_query = affected rows

Hello, Thank you for the clarification. David On 13-07-15 09:53 AM, Alex Balashov wrote: On 07/15/2013 09:52 AM, David K wrote: Are you saying that avp_db_query is obsolete? It's not obsolete in the sense of deprecated, it's just not the most flexible, modern way to access SQL databases.

[SR-Users] avp_db_query - closing the connection

Hi all, I have been using more and more avps for per-call queries populated by custom mysql queries. I would like to know how the connections of mysql queries are being closed. I tried to locate a command to do such, but unable to locate. Do they close on their own, after a certain timeout

Re: [SR-Users] avp_db_query() question

please keep the mailing list cc-ed all the time. Thanks, Daniel On 1/20/11 1:49 PM, ?? wrote: many thanks I've fixed the problem. http://problem.Your Using $(avp(s:name)) instead of $avp(s:name) Your http://problem.your/ solution is OK too. At 2011-01-20 18:10:40??Daniel-Constantin Mierla

Re: [SR-Users] avp_db_query() question

Hello, maybe is better to use sqlops module, it more suitable for queries with many records in result. http://kamailio.org/docs/modules/stable/modules_k/sqlops.html Cheers, Daniel On 1/19/11 2:58 PM, Klaus Darilion wrote: looks fine. try to increase debug level - then you should see the

[SR-Users] avp_db_query() question

Hello avp_db_query(query[,dest]) can get a database query and store the results in the avps. But what if the results returns many rows,and how can I get all the results? How to set the [dest] parameter ? I've tried the method describered inhttp://www.kamailio.org/docs/avp_db_query.html,but it

Re: [SR-Users] avp_db_query() question

looks fine. try to increase debug level - then you should see the query and the results in syslog regards klaus Am 18.01.2011 12:07, schrieb ??: Hello |avp_db_query(query[,dest]) can get a database query and store the results in the avps.| |But what if the results

Re: [SR-Users] avp_db_query returning wrong data

Hi All, I applied the following patch which fixed the issue. http://sip-router.org/tracker/index.php?do=detailstask_id=97 Are we going to merge this patch to Kamailio 3.1.x? Thanks Jijo On Wed, Nov 24, 2010 at 9:35 AM, Jijo realj...@gmail.com wrote: I'm using kamailio 3.1.0, so this is

Re: [SR-Users] avp_db_query returning wrong data

I'm using kamailio 3.1.0, so this is already in place.. Is there any other change happened after 3.1.0 release? On Wed, Nov 24, 2010 at 3:41 AM, Daniel-Constantin Mierla mico...@gmail.com wrote: On 11/24/10 12:59 AM, Alex Balashov wrote: On 11/23/2010 06:41 PM, Jijo wrote: Yes it work

[SR-Users] avp_db_query returning wrong data

Hi All, While doing 5 REGISTER/second, i observed that that avp_db_query is returning data from a different db entry. This happens only with TCP with more than 1 tcp_children. it works fine with UDP. It also work with TCP with tcp_children as 1. Is there any relation between the TCP

Re: [SR-Users] avp_db_query returning wrong data

Does it work with many UDP children? -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/ On Nov 23, 2010, at 6:13 PM, Jijo realj...@gmail.com wrote: Hi All,