I'm trying to use the API sofia_count_reg but all I'm getting is an error or -1. If I do "sofia_count_reg 1000" - whether there's multiple bindings or the user doesn't exist, I get -1. When I try "sofia_count_reg 1000@domain.com" I get an sql error: 2011-09-08 08:22:29.381355 [ERR] switch_core_sqldb.c:825 ERR: [select count(*) from sip_registrations where (sip_user='' or dir_user='1102') and (sip_host='1102' or presence_hosts like '%sip.getbestfone.com%')] [STATE: 42S22 CODE 1054 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10-log]Unknown column 'dir_user' in 'where clause' Thanks! -Avi
This should be reported to Jira with the missing column -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.com.
This should be reported to Jira with the missing column -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.com.
Even after adding the column, all I can get is a 0 or -1 response regardless of what I put in. sofia_count_reg 1000@domain -> 0 sofia_count_reg 1000@ -> -1 on: git-10d2e80 2011-09-08 22-35-20 -0500 So, broken, or I'm just using it completely wrong? -Avi On Thu, Sep 8, 2011 at 7:26 PM, Jeff Lenk <jeff@jefflenk.com> wrote:
This should be reported to Jira with the missing column
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.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 http://www.freeswitch.org
I looks like that method needs rework. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.com.
Have a look at git head from today and verify the functionality of both : sofia_reg_count user@domain sofia_reg_count @domain should now work. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.com.
Ok, updated... Both seem to work now. Great! It's sofia_count_reg by the way. I meant to jira it but I've been busy.. My point to using this was a better way to route a hunt script - e.g. if my sofia_count_reg is 2, the hard & softphone is on and I'm in the office. Otherwise, if only 1, I'm probably not, so ring my hardphone and my cell via the PSTN. -Avi On Tue, Sep 13, 2011 at 7:04 PM, Jeff Lenk <jeff@jefflenk.com> wrote:
Have a look at git head from today and verify the functionality of both :
sofia_reg_count user@domain sofia_reg_count @domain
should now work.
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.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 http://www.freeswitch.org
Thanks for testing! -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/How-to-use-sofia-count-reg-tp6... Sent from the freeswitch-users mailing list archive at Nabble.com.
participants (2)
-
Avi Marcus
-
Jeff Lenk