[Freeswitch-users] Presence with shared database

[Emrah]

Hi there,
Has there been any changes on this end?
I am trying to store presence data in PGSQL in order to distribute it among a cluster of FS servers.
Is this achievable now?

Best,
Emrah
> On Aug 10, 2015, at 12:55 PM, Leo Noordergraaf <leo.noordergraaf at deanconnect.nl> wrote:
> 
> Hi Adam,
> 
> We ran into the same issue and created ticket
> https://freeswitch.org/jira/browse/FS-7485 <https://freeswitch.org/jira/browse/FS-7485> for it.
> For some reason it has been closed but the issue still remains open.
> 
> Like you we changed the select en update statements but it would be nice
> if it was solved by the freeswitch team.
> 
> regards,
> Leo Noordergraaf
> 
> On 08/10/15 12:08, Adam Kuśmirek wrote:
>> Hello,
>> 
>> Yes we enabled manage-presence.
>> According to documentation dbname is used to share presence between
>> profiles.
>> 
>> What we want to achieve is to share presence between hosts.
>> 
>> We investigated some presence source code and found that there are sql
>> queries that ask for specific FS host. We modified SELECT statements and
>> UPDATES of version parameter, so they have no host in WHERE clause.
>> After mod_sofia recompilation everything works fine.
>> 
>> It seems that the only way to share presence between hosts is to set the
>> same hostname in switch.xml for every FS node, but we cannot do this
>> because we need host information for other services.
>> 
>> I wonder why FS checks whether the subscription was made on a host that
>> sets up the connection. Maybe this is a bug in the concept and it should
>> be removed.
>> 
>> Regards
>> Adam Kusmirek
>> 
>> 
>> 
>>        ---------- Wiadomość przekazana dalej ----------
>> 
>>    From: "Ítalo Rossi" <italorossib at gmail.com
>>    <mailto:italorossib at gmail.com <mailto:italorossib at gmail.com>>>
>>    To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org <mailto:freeswitch-users at lists.freeswitch.org>
>>    <mailto:freeswitch-users at lists.freeswitch.org <mailto:freeswitch-users at lists.freeswitch.org>>>
>>    Cc: 
>>    Date: Fri, 7 Aug 2015 22:42:37 -0500
>>    Subject: Re: [Freeswitch-users] Presence with shared database
>>    Hard to say without more info, where's your configs?
>> 
>>    Did you enabled the manage-presence in your profile? and set the dbname?
>> 
>> 
>> 
>> 
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services: 
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>> 
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> http://www.cluecon.com
>> 
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>> 
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services: 
> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org <http://www.freeswitch.org/>
> http://confluence.freeswitch.org <http://confluence.freeswitch.org/>
> http://www.cluecon.com <http://www.cluecon.com/>
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org <mailto:FreeSWITCH-users at lists.freeswitch.org>
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users>
> http://www.freeswitch.org <http://www.freeswitch.org/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160604/0e6c1f30/attachment-0001.html