[OpenSIPS-Users] OpenSIPS and external Database.

[azza miled]

Thanks Vlad, I am trynig to do that :))

2012/5/17 Vlad Paiu <vladpaiu at opensips.org>

> **
> 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 <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 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 <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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> 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/20120519/ed01ad1f/attachment.htm>