VoIP Mailing List Archives

[bkk at ednt.de]

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@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

[krice at freeswitch.org]

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

[bkk at ednt.de]

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:

[krice at freeswitch.org]

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

[gregor at infomedia.si]

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 (krice@freeswitch.org)> wrote: