Thanks Vlad, I am trynig to do that :)) 2012/5/17 Vlad Paiu <[email protected]>
> ** > 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 Developerhttp://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 Developerhttp://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]> 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 Developerhttp://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] >> > 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 > [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 > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
