Hello,
You can use the db_oracle module, along with the avpops module. See
avp_db_query() [1]
[1] http://www.opensips.org/html/docs/modules/devel/avpops#id292393
Regards,
Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com
On 05/17/2012 06:44 AM, azza miled wrote:Hello,
Just to clear some things up, if you leave the second server offline and
only start it after the active is down, then the ongoing dialogs will be
automatically loaded by the secondary server at startup. The dlg_db_sync
command is only useful when you have the second server online, and want
to trigger a refresh of OpenSIPS memory based on what is in the DB.
If you just start the secondary server & do not issue dlg_db_sync, do
you still have the same problem ?
If you can, please send us ( privately or via pastebin ) a full debug
OpenSIPS log of the secondary server ( from startup, until the moment
you want to access a dlg_var ).
Regards,
Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com
On 05/16/2012 08:46 PM, Mariana Arduini wrote:
Hi Vlad,
> Does this also happen if you leave the second server offline, and
start it after the active OpenSIPS is shut down (...) ?
Yes, that's exactly the test I've run.
> At the moment that you run dlg_db_sync, do you see the variables in
the dialog DB table ?
Yes.
After you run dlg_db_sync, you say you cannot access the variables
from the script, but you see them in dlg_list_ctx ?
No, I don't see them in dlg_list_ctx, neither I can access them from
the script.
Thanks.
Mariana.
On Wed, May 16, 2012 at 2:31 PM, Vlad Paiu <[email protected]
<mailto:[email protected]>> wrote:
Hi Mariana,
Does this also happen if you leave the second server offline, and
start it after the active OpenSIPS is shut down, instead of
leaving the second server up and running 'dlg_db_sync' ?
At the moment that you run dlg_db_sync, do you see the variables
in the dialog DB table ?
After you run dlg_db_sync, you say you cannot access the variables
from the script, but you see them in dlg_list_ctx ?
Regards,
Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com
On 05/16/2012 07:57 PM, Mariana Arduini wrote:
Hi Razvan,
Do I need to open a bug about this issue somewhere? I saw
Bogdan's message about OpenSIPS 1.8 Stable being released tomorrow.
I think the problem is the dialog variables are not being fetched
from DB, either when OpenSIPS is restarded, either when we run
the new fifo command dlg_db_sync.
Thanks again!
Mariana.
On Wed, May 16, 2012 at 8:06 AM, Mariana Arduini
<[email protected] <mailto:[email protected]>> wrote:
Hi, Razvan!
Thank you for the $DLG_dir pseudovariable, it worked!
The variables are properly flushed into the DB after 200 OK,
and I can also see them using "opensipsctl fifo
dlg_list_ctx", under context.
Even using the $DLG_dir for the direction of a sequential
request, I still need to access either the caller_contact or
the callee_contact. Is there any other way to have those
apart from the variables?
Thanks again!
Mariana.
Hi!
This is my first project on OpenSIPS.I am trying to route my calls en
function of the callee profile. The problem is that profiles are
stored on an external Oracle data base. Is it possible to consult the
Oracle data base, extract the profile on the calle from it and routing
the call based on this profile. I am thinking to use db_oracle to do
this, am I in the right way???
Best Regards.
_______________________________________________
Users mailing list
[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
