<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
You can use the db_oracle module, along with the avpops module. See
avp_db_query() [1] <br>
<br>
[1] <a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/devel/avpops#id292393">http://www.opensips.org/html/docs/modules/devel/avpops#id292393</a><br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">Vlad Paiu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a> </pre>
<br>
On 05/17/2012 06:44 AM, azza miled wrote:Hello,<br>
<br>
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.<br>
<br>
If you just start the secondary server & do not issue
dlg_db_sync, do you still have the same problem ?<br>
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 ).<br>
<br>
Regards,
<pre class="moz-signature" cols="72">Vlad Paiu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a> </pre>
<br>
On 05/16/2012 08:46 PM, Mariana Arduini wrote:
<blockquote
cite="mid:CABHUZgD2tbgr6yFu_nVvaX=VWog0FPGX3BSkoVhbQ8Sbk5Lriw@mail.gmail.com"
type="cite">Hi Vlad,
<div><br>
</div>
<div>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
> Does this also happen if you leave the second server
offline, and start it after the active OpenSIPS is shut down
(...) ?</div>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<div><br>
</div>
<div>Yes, that's exactly the test I've run.</div>
<div><br>
</div>
<div>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
> At the moment that you run dlg_db_sync, do you see the
variables in the dialog DB table ?</div>
<div><br>
</div>
<div>Yes.</div>
<div><br>
</div>
<div>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
After you run dlg_db_sync, you say you cannot access the
variables from the script, but you see them in dlg_list_ctx ?</div>
<div><br>
</div>
<div>No, I don't see them in dlg_list_ctx, neither I can access
them from the script.</div>
<div><br>
</div>
<div>Thanks.</div>
<div>Mariana.</div>
<div><br>
<div class="gmail_quote">On Wed, May 16, 2012 at 2:31 PM, Vlad
Paiu <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:vladpaiu@opensips.org" target="_blank">vladpaiu@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> Hi Mariana,<br>
<br>
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' ?<br>
<br>
At the moment that you run dlg_db_sync, do you see the
variables in the dialog DB table ?<br>
After you run dlg_db_sync, you say you cannot access the
variables from the script, but you see them in
dlg_list_ctx ?<br>
<br>
Regards,<br>
<pre cols="72">Vlad Paiu
OpenSIPS Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a> </pre>
<div>
<div class="h5"> <br>
On 05/16/2012 07:57 PM, Mariana Arduini wrote:
<blockquote type="cite">Hi Razvan,
<div><br>
</div>
<div>Do I need to open a bug about this issue
somewhere? I saw Bogdan's message about OpenSIPS
1.8 Stable being released tomorrow.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thanks again!</div>
<div>Mariana.<br>
<div><br>
<div class="gmail_quote">On Wed, May 16, 2012 at
8:06 AM, Mariana Arduini <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:marianarduini@gmail.com"
target="_blank">marianarduini@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:
0pt 0pt 0pt 0.8ex; border-left: 1px solid
rgb(204, 204, 204); padding-left: 1ex;">Hi,
Razvan!
<div><br>
</div>
<div>Thank you for the $DLG_dir
pseudovariable, it worked!</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Thanks again!</div>
<div><span><font color="#888888">Mariana.</font></span>
<div>
<div><br>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<blockquote
cite="mid:CAGQdkzRvnJEkVDr5YmPbSUZzdZCLta4bG6OnmBu8w8k_LN30HQ@mail.gmail.com"
type="cite">
<div dir="ltr">Hi!
<div>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???</div>
<div>Best Regards.</div>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>