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@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@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@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
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@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@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
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@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@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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com