Hi Bogdan-Andrei.
You are right. I have been used the attr_avp, as you explained, to save a
specific information in each new record for table location. It works very well
and such information goes to column attr.
However, I have created today a new column for such table: column callerName.
And I have to save $fn in this new column for each new record too.
So, what I have just tried today is something like this:
modparam("registrar", "attr_avp", "$avp(attr)")
modparam("registrar", "attr_avp", "$avp(callerName)")
...
is_method("REGISTER")) {
$avp(attr) = "my_specific_information";
$avp(callerName) = $fn;
}
...
But, in this case, the $fn overwrites the specific information, because it
seems that attr_avp will pointer always to the same column Attr, no matter what
the name I give to the AVP.
Do you know how to put every information in its correct column?
Is it possble to have two attr_avps related to two different columns in table
location?
Any hint will be very helpful!
Best regards.
RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979
________________________________
De: [email protected] <[email protected]> em nome
de Bogdan-Andrei Iancu <[email protected]>
Enviado: sexta-feira, 10 de junho de 2016 07:39
Para: OpenSIPS users mailling list
Cc: Cleide Aparecida Ribeiro do Prado; Daniel Lopes Fússia
Assunto: Re: [OpenSIPS-Users] How to update table location, but directly on
memory cache (RAM)?
Hi Rodrigo,
What you try to do is not consistent.
Either you use db_mode 1 to be have immediate writting in DB from usrloc module
(see http://www.opensips.org/html/docs/modules/1.11.x/usrloc.html#id294459) ->
it will be safe to run your script query after the save().
Either push the extra info you want to save into DB (and memory cache) via the
attr AVP (see
http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909) and
opensips will do everything for you.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 09.06.2016 17:42, Rodrigo Pimenta Carvalho wrote:
Hi.
My script has the configuration:
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "timer_interval",3)
Always after receiving a new register in table location, I must to execute a
code like this:
avp_db_query("UPDATE location...
That is, an update will complement data in the new register.
However, how could I immediately update table location if data might be in
memory cache (RAM) for 3 seconds. It could fail obviously.
The command avp_db_query UPDATE is acting over the database on hard disc, not
in obviously.
So, is there a way to update table location even still in cache (RAM)? If yes,
when data from RAM is recorded into the database, the register will already be
updated.
Any hint will be very helpful!
Best regards.
RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979
_______________________________________________
Users mailing list
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
