<!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()&nbsp; [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 &amp; 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">
        &gt; 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">
        &gt;&nbsp;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">&lt;<a moz-do-not-send="true"
              href="mailto:vladpaiu@opensips.org" target="_blank">vladpaiu@opensips.org</a>&gt;</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">&lt;<a
                              moz-do-not-send="true"
                              href="mailto:marianarduini@gmail.com"
                              target="_blank">marianarduini@gmail.com</a>&gt;</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>