asterisk users - Jun 2020 - Any api (agi/ari/ami) equivalent of "core show calls"?

Way back in the mists of time, I built my asterisk installation with SNMP
support.

It's a bit tedious to get the sub-agent for snmpd set up but once you have
it you can poll the OID for the asterisk sub-agent and it will tell you how many
calls are up at that
moment in time.

That said, I actually prefer ARA/ARI to flat file configuration of endpoints and
dialplans.  Changes are more or less instantaneous and easily shared between
instances. The ODBC
way is a pain, so I tend to just use the native MySQL method for ARA
configuration as well as CDR collection.  CDR reports are just a SQL query away.

Only problem is all of the web ui's for Asterisk seem to be PHP that
presumes the flatfiles.



On 6/14/20 2:55 PM, Telium Technical Support wrote:
>
> Just run ‘core show calls’ as a command  from the AMI, and parse the
results.  I don’t think there is an equivalent pure AMI command.
>
> *From:*asterisk-users [mailto:asterisk-users-bounces at lists.digium.com]
*On Behalf Of *Jonathan H
> *Sent:* Sunday, June 14, 2020 5:45 PM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
> *Subject:* Re: [asterisk-users] Any api (agi/ari/ami) equivalent of
"core show calls"?
>
> Wow! I've been *-ing for about 6 years and had literally no idea about
that!
>
> I can see a way I could put it to a different use, but it seems to be a bit
of a sledgehammer to crack the walnut of "how many current callers"
compared to one line of (albeit
> hacky) dialplan.
>
> That's making me sound ungrateful. I don't mean to be!
>
> On Sun, 14 Jun 2020, 22:39 Steve Edwards, <asterisk.org at sedwards.com
<mailto:asterisk.org at sedwards.com>> wrote:
>
>     On Sun, 14 Jun 2020, Jonathan H wrote:
>
>     > Thank you... but "just update the database" - hmm, what
database?
>
>     I used MySQL.
>
>     > Did you mean ARI? I still can't find the command! The asterisk
wiki is
>     > somewhat, um... spread around!
>
>     ARA as in Asterisk RealTime Architecture
>
>    
https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration
>     https://www.voip-info.org/asterisk-realtime/
>
>     As I recall (back from 2015), you tell Asterisk which
'configuration file'
>     you want to read from MySQL like this:
>
>     # /etc/asterisk/extconfig.conf
>
>     [settings]
>              musiconhold.conf                = mysql,vchat,static
>     ;       musiconhold.conf                = mysql,vchat,musiconhold
>
>     I have no idea if this will help, but here are the tables as I defined
them back in 2015.
>
>              create  table   if not exists   static
>                      (
>                        id                    int(11) not null
auto_increment
>                      , cat_metric            int(11) not null default
'0'
>                      , var_metric            int(11) not null default
'0'
>                      , commented             int(11) not null default
'0'
>                      , filename              varchar(128) not null default
''
>                      , category              varchar(128) not null default
'default'
>                      , var_name              varchar(128) not null default
''
>                      , var_val               varchar(128) not null default
''
>                      , primary key           (id)
>                      )
>                      ;
>
>     -- defaults
>              set @CAT_METRIC                 = 0;
>              set @FILENAME                   = 'musiconhold.conf';
>              set @VAR_METRIC                 = 0;
>
>     -- Funk Dance
>              set @COMMENTED                  = 0;
>              set @NAME                       = 'Funk Dance';
>              insert into static set
>                        cat_metric            = @CAT_METRIC
>                      , category              = @NAME
>                      , commented             = @COMMENTED
>                      , filename              = @FILENAME
>                      , var_metric            = @VAR_METRIC
>                      , var_name              = 'directory'
>                      , var_val               =
concat('/source/src/tmp/T2/moh/', @NAME, '/')
>                      ;
>              insert into static set
>                        cat_metric            = @CAT_METRIC
>                      , category              = @NAME
>                      , commented             = @COMMENTED
>                      , filename              = @FILENAME
>                      , var_metric            = @VAR_METRIC
>                      , var_name              = 'mode'
>                      , var_val               = 'files'
>                      ;
>              insert into static set
>                        cat_metric            = @CAT_METRIC
>                      , category              = @NAME
>                      , commented             = @COMMENTED
>                      , filename              = @FILENAME
>                      , var_metric            = @VAR_METRIC
>                      , var_name              = 'sort'
>                      , var_val               = 'random'
>                      ;
>              insert into static set
>                        cat_metric            = @CAT_METRIC
>                      , category              = @NAME
>                      , commented             = @COMMENTED
>                      , filename              = @FILENAME
>                      , var_metric            = @VAR_METRIC
>                      , var_name              = 'type'
>                      , var_val               = 'preset'
>                      ;
>     --      insert into static set
>     --                cat_metric            = @CAT_METRIC
>     --              , category              = @NAME
>     --              , commented             = @COMMENTED
>     --              , filename              = @FILENAME
>     --              , var_metric            = @VAR_METRIC
>     --              , var_name              = 'application'
>     --              , var_val               = '/usr/bin/mpg123 --mono
-b 0 -f 8192 -q -r 8000 -s -@ http://206.190.136.141:5022/Live'
>     --              ;
>
>     -- FILES
>     --      set @COMMENTED                  = 0;
>     --      insert into static set
>     --                cat_metric            = @CAT_METRIC
>     --              , category              = 'FILES'
>     --              , commented             = @COMMENTED
>     --              , filename              = @FILENAME
>     --              , var_metric            = @VAR_METRIC
>     --              , var_name              = 'directory'
>     --              , var_val               =
'/var/lib/asterisk/moh/'
>     --              ;
>     --      insert into static set
>     --                cat_metric            = @CAT_METRIC
>     --              , category              = 'FILES'
>     --              , commented             = @COMMENTED
>     --              , filename              = @FILENAME
>     --              , var_metric            = @VAR_METRIC
>     --              , var_name              = 'mode'
>     --              , var_val               = 'files'
>     --              ;
>
>              create  table   if not exists   musiconhold
>                      (
>                        name                  varchar(80) not null
>                      , mode                  varchar(80) not null default
''
>                      , directory             varchar(255) not null default
''
>                      , application           varchar(255) not null default
''
>                      , digit                 char(1) not null default
''
>                      , sort                  varchar(16) not null default
''
>                      , format                varchar(16) not null default
''
>                      , stamp                 timestamp
>                      )
>                      ;
>
>              insert into musiconhold set
>                        name                  = 'default'
>                      , directory             =
'/var/lib/asterisk/moh'
>                      , application           = ''
>                      , mode                  = 'files'
>                      , digit                 = ''
>                      , sort                  = 'random'
>                      , format                = ''
>                      ;
>
>              insert into musiconhold set
>                        application           = '/usr/bin/mpg123 --mono
-b 0 -f 8192 -q -r 8000 -s -@
http://streaming.radionomy.com/80sFunkDanceMusic'
>                      , mode                  = 'custom'
>                      , name                  = 'foobar'
>                      ;
>
>     Hope this helps rather than hinders :)
>
>     -- 
>     Thanks in advance,
>    
-------------------------------------------------------------------------
>     Steve Edwards sedwards at sedwards.com <mailto:sedwards at
sedwards.com>     Voice: +1-760-468-3867 PST
>     https://www.linkedin.com/in/steve-edwards-4244281
>
>     -- 
>     _____________________________________________________________________
>     -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
>     Check out the new Asterisk community forum at:
https://community.asterisk.org/
>
>     New to Asterisk? Start here:
>     https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
>     asterisk-users mailing list
>     To UNSUBSCRIBE or update options visit:
>     http://lists.digium.com/mailman/listinfo/asterisk-users
>
>

On Monday 15 June 2020 at 00:41:14, Bruce Ferrell wrote:
> Way back in the mists of time, I built my asterisk installation with SNMP
> support.
Heh... I never even knew that was possible :)
> That said, I actually prefer ARA/ARI to flat file configuration of
endpoints
> and dialplans.  Changes are more or less instantaneous and easily shared
> between instances.
Agreed - ARA is a great system, and I really like that it can be combined with 
flatfile configs on a single server.
> The ODBC way is a pain, so I tend to just use the native MySQL method
Oh?

What makes you say ODBC is a pain?  I have two files (/etc/odbc.ini and 
/etc/idbcinst.ini, which are 8 lines and 3 lines in size respectively) and I 
had to install one file /usr/local/lib/libmaodbc.so to make it work with 
MariaDB.

What's easier about the native MySQL method?
> for ARA configuration as well as CDR collection.  CDR reports are just a
SQL
> query away.
Yes:

a) efficient

b) can be done on a machien remote from the call processing

c) is realtime - call ends, CDRs are immediately available for analysis

d) can even include triggers on DB updates, for example to raise anti-fraud 
alerts.


Regards,


Antony.

-- 
Python is executable pseudocode.
Perl is executable line noise.

                                                   Please reply to the list;
                                                         please *don't* CC
me.

On 6/14/20 4:52 PM, Antony Stone wrote:
> On Monday 15 June 2020 at 00:41:14, Bruce Ferrell wrote:
>
>> Way back in the mists of time, I built my asterisk installation with
SNMP
>> support.
> Heh... I never even knew that was possible :)
>
>> That said, I actually prefer ARA/ARI to flat file configuration of
endpoints
>> and dialplans.  Changes are more or less instantaneous and easily
shared
>> between instances.
> Agreed - ARA is a great system, and I really like that it can be combined
with
> flatfile configs on a single server.
>
>> The ODBC way is a pain, so I tend to just use the native MySQL method
> Oh?
>
> What makes you say ODBC is a pain?  I have two files (/etc/odbc.ini and
> /etc/idbcinst.ini, which are 8 lines and 3 lines in size respectively) and
I
> had to install one file /usr/local/lib/libmaodbc.so to make it work with
> MariaDB.
ODBC can get fussy about language definitions between the DB and ODBC.  ODBC
make's it so you can use ANY db, but try Informix or Oracle... Just LOADS of
fun getting the language
code page settings right (Yes, I actually had a customer want Informix -
SHUDDER).

The MySQL connection has it's own configuration fuss, but I understand it
and HATE trying to debug ODBC configs.

> What's easier about the native MySQL method?
>
>> for ARA configuration as well as CDR collection.  CDR reports are just
a SQL
>> query away.
> Yes:
>
> a) efficient
>
> b) can be done on a machien remote from the call processing
>
> c) is realtime - call ends, CDRs are immediately available for analysis
>
> d) can even include triggers on DB updates, for example to raise anti-fraud
> alerts.
>
YES!  and most non-MySQL/Marias type don't realize that those triggers and
stored procedures can actually execute routines external to the DB... At least
in MySQL/MariaDB

> Regards,
>
>
> Antony.
>