[OpenSIPS-Users] OpenSIPS and external Database.

[Vlad Paiu]

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 <vladpaiu at opensips.org 
> <mailto:vladpaiu at opensips.org>> 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
>>     <marianarduini at gmail.com <mailto:marianarduini at gmail.com>> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120517/38b487ca/attachment.htm>