[Freeswitch-users] Get registrations via fs_cli or API

[Ken Rice]

you miss the entire point. you do not have to ise sqlite (and infact i recommend you dont for this)

use an external db server such as postgresql or mysql etc. 

the use standard db magic to find what you are looking for. 

there is no opening directories looking for files etc. you define the DSN for where  sofia (and other modules) store the data. and if you need to break ot down in to different tables ok, no problem use a view to consolidate then for querying

Sent from my iPhone

> On Sep 29, 2022, at 00:56, Bernd Krueger-Knauber <bkk at ednt.de> wrote:
> 
> Hi,
> 
> thanks for your response.
> I also checked the sqlite dbs, but this is even more complicated than the sofia solution.
> Because there I need to check the directory (which is not always the same) and have to look
> for the reg sofia dbs, then open them and make the query.
> It is safer and faster to use the sofia status command.
> 
> In general:
> If I know that a command does not work as expected, I don't make it available.
> 
> To use it, find the fault and now to replace it was very time consuming.
> 
> Best regards,
> 
> Bernd
> 
> 
>> Am 29.09.2022 um 03:46 schrieb Ken Rice:
>> show registrations  was intended originally to show all registrations across multiple transport technologies  not just sip.
>> 
>> However it was never fully implemented and may be buggy. (one of the core devs that worked on this can correct me if i am wrong)
>> 
>> Also you know you can push the registartions to a db and just dirct query that table
>> 
>> Sent from my iPhone
>> 
>>>> On Sep 28, 2022, at 04:47, Bernd Krueger-Knauber <bkk at ednt.de> wrote:
>>> 
>>> Hi,
>>> 
>>> today I found something which can't be right:
>>> 
>>> show registrations
>>> 
>>> results in a total of 26.
>>> 
>>> sofia status profile internal reg
>>> 
>>> results in 37 entries
>>> 
>>> show registrations  does not show the 'double' registrations on same extensions.
>>> In my opinion this is a bug.
>>> The way via sofia is complicated, since you need to check all profiles.
>>> And it is also more complicated to parse the output.
>>> 
>>> We are using version 1.10.7
>>> 
>>> Any ideas?
>>> 
>>> Best regrads,
>>> 
>>> Bernd
>>> 
>>> 
>>> _________________________________________________________________________
>>> 
>>> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
>>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
>>> Build your next product on our scalable cloud platform.
>>> 
>>> Join our online community to chat in real time https://signalwire.community
>>> 
>>> Professional FreeSWITCH Services
>>> sales at freeswitch.com
>>> https://freeswitch.com
>>> 
>>> Official FreeSWITCH Sites
>>> https://freeswitch.com/oss
>>> https://freeswitch.org/confluence
>>> https://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
>>> https://freeswitch.com
>> _________________________________________________________________________
>> 
>> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
>> Build your next product on our scalable cloud platform.
>> 
>> Join our online community to chat in real time https://signalwire.community
>> 
>> Professional FreeSWITCH Services
>> sales at freeswitch.com
>> https://freeswitch.com
>> 
>> Official FreeSWITCH Sites
>> https://freeswitch.com/oss
>> https://freeswitch.org/confluence
>> https://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
>> https://freeswitch.com
> 
> 
> -- 
> EDNT GmbH
> Werner-von-Siemens-Strasse 7
> 64625 Bensheim
> www.ednt.de
> 
> Registergericht: Darmstadt
> Registernummer: 24972
> 
> Geschäftsführerin: Kerstin Knapp
> 
> 
> 
> _________________________________________________________________________
> 
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
> Build your next product on our scalable cloud platform.
> 
> Join our online community to chat in real time https://signalwire.community
> 
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
> 
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://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
> https://freeswitch.com