[Freeswitch-users] Get registrations via fs_cli or API

Thu Sep 29 21:03:21 UTC 2022

Yes, this is a very simple solution. It is a good practice to use external
DB as it is more scalable than sqlite. We are even using MS SQL server and
it works like a charm. Then you can query registrations, channels, calls,
etc...

On Thu, 29 Sept 2022 at 22:13, Ken Rice <krice at freeswitch.org> wrote:

> 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
>
> _________________________________________________________________________
>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20220929/8f391830/attachment-0001.html>