similar to: Asterisk realtime and metrics

Here is what happens on startup: Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM settings WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Everything is fine. Sep

I did an ngrep trace of what Asterisk realtime static does when it queries the database. Here's what I saw SELECT category, var_name, var_val, cat_metric FROM rt_pbx1_sip_vw WHERE filename='sip.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id; Firstly, why does it order in DESCENDING order by cat_metric? Shouldn't it be

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:

I'm having a few issues with the MySQL realtime configuration in CVS-HEAD. I tested it initially with realtime extensions (realtime_ext => mysql,asterisk,extensions) and a realtime switch in extensions.conf and that works fine, So I though I'd go back and test a static configuration mapping. I used the table structure from the asterisk guru postgres howto to create something

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,

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

Ok I'm a little confused about realtime static. The wiki has the database schema but no explanation of what fields are for what. I would appreciate if someone can confirm or deny how I think the schema works. cat_metric = sort order for category var_metric = sort order for vars filename = equivalent .conf file in /etc/asterisk category = anything that would be enclosed in braces ([])

Hello list, scrambling different pieces of info together I've come with the following : I want to have my "register =>" statements in a MySQL-database, so I've made the following table. table ast_config : id 1 cat_metric 0 var_metric 0 commented 0 filename sip.conf category general var_name register var_val username:password at sip.provider.net In ext_config

Starting with Asterisk 1.2 I have always used realtime static to load my extensions.conf into Asterisk. It worked perfectly up to version 1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I can see that the extensions.conf file is mapped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': ==

Hello everyone, I'm Andrea, and I've started working with Asterisk a couple of weeks ago, so I'm still a newbie. :) I was reading about Asterisk Realtime, and I was wondering if I can mix Static realtime and "Real" realtime configuration. For instance: can I have a "Static Realtime" extensions.conf and use "Real Realtime" sippeers and sipusers? Moreover,

I just upgraded from 1.6.0.14 to 1.6.1.6 and now my realtime static configuration for extensions.conf will not load. All other realtime configs work (SIP, IAX2, Voicemail). I cannot find any reference or documentation about the structure of the realtime static database for 1.6.1.x but I have used the same table structure since 1.4.x. CREATE TABLE `ast_config` ( `id` int(11) NOT NULL

Hi folks, I'm really confused, so please help me, or at least give me some pointers to clarify this issue. Can I mix "Static" and "Real" realtime? Is there a way to easily switch from one to another, say, for sip.conf? Which are the major benefits of "Real" realtime? Please help me! Thanks in advance, -- Andrea Spadaccini Multimedia Technologies Institute

Hi List: Can someone hlep to provide one or two examples to data entry for sip.conf under the table structure? CREATE TABLE `sip_conf` ( `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 '',

Hello everybody, I'd like to hear some success stories about the use of Asterisk Realtime in medium-large contexts, like > 50 extensions. Don't you think that in those contexts the system could be overloaded from the excessive number of queries to the DB? So.. is anybody using ARA in those kind of deployments? Thanks in advance, -- Andrea Spadaccini Multimedia Technologies

Hi folks, I used the ast2sql.pl script (found on www.voip-info.org) to put into the database a simple sip.conf. Among other entries, you could find: [general] context=sip-in ;incoming sip calls Well, the script put the comment into the database entry, and asterisk started complaining about a 'sip-in ;incoming sip calls' context not found in extensions.conf. IMHO the comments should be

On 2/23/15 3:03 AM, Yaron Nachum wrote: > Hello everyone, > I am trying to activate Music On Hold using DB on Asterisk 13. > It works fine but in order to use new Music On hold definitions I have > to reload the moh module. > > - The following is my configuration in extconfig.conf - I added the > following line: > musiconhold.conf => mysql,asterisk,bit_ast_config >

Guys, I need you help on this one. Don't know when this broke but we have a custom gui that runs on top of Asterisk running a real-time static for configurations. Nothing has changed with the database other than upgrades of Asterisk 10. Customer complained that there password was not changing when they called into voicemail and changed it. Database is running standard ast_config with the

Hello everyone, I am trying to activate Music On Hold using DB on Asterisk 13. It works fine but in order to use new Music On hold definitions I have to reload the moh module. - The following is my configuration in extconfig.conf - I added the following line: musiconhold.conf => mysql,asterisk,bit_ast_config - The following is the table in the database: mysql> select * from

Hi I have been playing with trying to get voicemail.conf from DB, I am using cvs-head, but when I start asterisk, it dies a horrible death, because it cant load any voicemil setting. I looked at my mysql logs to see what query was being sent, and I get SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY

Hi. I can't figure this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings=