5 Oct
2007
5 Oct
'07
11:19 p.m.
Is there a better way to talk to a database directly than to use
avp_db_query()? I need to use my own schemas; I have a platform
that absolutely does not lend itself to storing data in the avpops'
schema. Luckily, avp_db_query() saved the day. Is there anything
even easier, or is this the definitive and methodologically correct
way to go?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
6 Oct
6 Oct
12:04 a.m.
Try using Perl (to query the database and set an AVP value), and AVPops
(to modify the URI or whatever).
In your perl script (sets avp alias 39 to the value in $outuri:
OpenSER::AVP::add(39, "$outuri");
In your openser config file:
modparam("perl", "filename", "script_name.pl") # enables
perl script
avp_aliases="ouri=i:39" # define avp alias 39 (alias ouri)
route {
..
..
perl_exec("script_name.pl");
avp_pushto("$ru","$avp(ouri)"; # set your URI to ouri
}
Of course, you'll have to setup your perl script to do a meaningful
database query. There are some good samples in the source code to
understand the perl scripts.
Alex Balashov wrote:
Is there a better way to talk to a database directly than to use
avp_db_query()? I need to use my own schemas; I have a platform
that absolutely does not lend itself to storing data in the avpops'
schema. Luckily, avp_db_query() saved the day. Is there anything
even easier, or is this the definitive and methodologically correct
way to go?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
12:14 a.m.
Thank you, this is very interesting; I was not aware.
I imagine there is a perceptible performance impact that comes with
calling an external script, though, in that it has to open a new
database connection handle each time and so on and so forth. Thus,
presumably it would be worth it only for situations in which the
database interaction is sufficiently complex that it warrants
outboarding it as opposed to trying to entertain it within the
OpenSER config logic.
I've gotten around this requirement for the most part and kept things
clean by using Postgres stored procedures extensively, so there is
considerable incentive at this point to keep the operations monolithicised
within OpenSER.
However, this provides me with a very good conceptual foundation for
situations where extensive IPC is required.
Thank you very much for that suggestion!
On Fri, 5 Oct 2007, Mik Cheez wrote:
Try using Perl (to query the database and set an AVP
value), and AVPops (to
modify the URI or whatever).
In your perl script (sets avp alias 39 to the value in $outuri:
OpenSER::AVP::add(39, "$outuri");
In your openser config file:
modparam("perl", "filename", "script_name.pl") # enables
perl script
avp_aliases="ouri=i:39" # define avp alias 39 (alias ouri)
route {
..
..
perl_exec("script_name.pl");
avp_pushto("$ru","$avp(ouri)"; # set your URI to ouri
}
Of course, you'll have to setup your perl script to do a meaningful database
query. There are some good samples in the source code to understand the perl
scripts.
Alex Balashov wrote:
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
Is there a better way to talk to a database directly than to use
avp_db_query()? I need to use my own schemas; I have a platform
that absolutely does not lend itself to storing data in the avpops'
schema. Luckily, avp_db_query() saved the day. Is there anything
even easier, or is this the definitive and methodologically correct
way to go?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
12:45 a.m.
I use this to connect to a SQL2000 box using FreeTDS and the Sybase Perl
DB module. My servers handle a very high load with virtually no
latency. I had to go this route our routing is broken down as far as 10
digits domestic (US) and international is just crazy.
You can look to see if the Postgres DB module allows for persistent
connections, so you don't have to worry about opening and closing for
each DB call.
Alex Balashov wrote:
Thank you, this is very interesting; I was not aware.
I imagine there is a perceptible performance impact that comes with
calling an external script, though, in that it has to open a new
database connection handle each time and so on and so forth. Thus,
presumably it would be worth it only for situations in which the
database interaction is sufficiently complex that it warrants
outboarding it as opposed to trying to entertain it within the
OpenSER config logic.
I've gotten around this requirement for the most part and kept things
clean by using Postgres stored procedures extensively, so there is
considerable incentive at this point to keep the operations
monolithicised within OpenSER.
However, this provides me with a very good conceptual foundation for
situations where extensive IPC is required.
Thank you very much for that suggestion!
On Fri, 5 Oct 2007, Mik Cheez wrote:
Try using Perl (to query the database and set an
AVP value), and
AVPops (to modify the URI or whatever).
In your perl script (sets avp alias 39 to the value in $outuri:
OpenSER::AVP::add(39, "$outuri");
In your openser config file:
modparam("perl", "filename", "script_name.pl") # enables
perl script
avp_aliases="ouri=i:39" # define avp alias 39 (alias ouri)
route {
..
..
perl_exec("script_name.pl");
avp_pushto("$ru","$avp(ouri)"; # set your URI to ouri
}
Of course, you'll have to setup your perl script to do a meaningful
database query. There are some good samples in the source code to
understand the perl scripts.
Alex Balashov wrote:
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
Is there a better way to talk to a database directly than to use
avp_db_query()? I need to use my own schemas; I have a platform
that absolutely does not lend itself to storing data in the avpops'
schema. Luckily, avp_db_query() saved the day. Is there anything
even easier, or is this the definitive and methodologically correct
way to go?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
7 Oct
7 Oct
7:15 a.m.
On Fri, 5 Oct 2007, Mik Cheez wrote:
You can look to see if the Postgres DB module allows
for persistent
connections, so you don't have to worry about opening and closing for
each DB call.
Wouldn't that be impossible so long as the Perl script / Perl
interpreter has to get invoked each time? Or does the Postgres inline
Perl module have some sort of mod_perl like functionality where it keeps
a persistent interpreter open?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
9:19 p.m.
For genuine SER, there is the dbops module which would be for sure easy to port
to openser.
For use examples, see the oob config file, where in a timer route expired usrloc
entried are deleted, and presence of new domains is checked for.
-jiri
https://cvs.berlios.de/cgi-bin/viewcvs.cgi/ser/sip_router/etc/Attic/ser-oob…
At 22:19 05/10/2007, Alex Balashov wrote:
Is there a better way to talk to a database directly
than to use avp_db_query()? I need to use my own schemas; I have a platform
that absolutely does not lend itself to storing data in the avpops'
schema. Luckily, avp_db_query() saved the day. Is there anything
even easier, or is this the definitive and methodologically correct
way to go?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
--
Jiri Kuthan http://iptel.org/~jiri/
9 Oct
9 Oct
10:48 a.m.
Hi Alex,
The only formatted why to do it is via avp_db_load/save(), but for
custom queries, there is no way than using either the raw query (avpops
module), either external scripts - perl (as Mik suggested) or whatever
(via exec module).
But, from performance considerations, avp_db_query() is much faster.
regards,
bogdan
Alex Balashov wrote:
Is there a better way to talk to a database directly than to use
avp_db_query()? I need to use my own schemas; I have a platform
that absolutely does not lend itself to storing data in the avpops'
schema. Luckily, avp_db_query() saved the day. Is there anything
even easier, or is this the definitive and methodologically correct
way to go?
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : +1-678-954-0670
Direct : +1-678-954-0671
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6257
days inactive
6261
days old
6 comments
4 participants
participants (4)
-
Alex Balashov -
Bogdan-Andrei Iancu -
Jiri Kuthan -
Mik Cheez