search for: var_metric

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

Thank you... but "just update the database" - hmm, what database? Did you mean ARI? I still can't find the command! The asterisk wiki is somewhat, um... spread around! On Sat, 13 Jun 2020 at 16:56, Steve Edwards <asterisk.org at sedwards.com> wrote: > > On Sat, 13 Jun 2020, Jonathan H wrote: > > > I need to ensure that a MusicOnHold stream is only running when

...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'...

...ack 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 d...

I swear I read somewhere on one of the MANY pages that there is a script out there that can read the extensions.conf file and create the MySQL DB records on the fly. Anyone know where I look for such a thing? Sure speeds up migration! Chris Coulthurst chris@shuksan.com

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 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Found 13 rows. Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: VM Review Option disabled globally Sep 15 13:23:51...

...dbsock = /var/run/mysqld/mysqld.sock #### ####Debug Log#### Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Everything is fine. Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Query: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf...

...stgreSQL] Description=PostgreSQL ODBC driver for Linux and Windows Driver=/usr/local/lib/psqlodbc.so Setup=/usr/lib/odbc/libodbcpsqlS.so Debug = 1 CommLog = 1 root@pbx:# echo "select * from ast_config where filename='iax.conf' and commented=0 order by filename,cat_metric desc,var_metric asc,category,var_name,var_val,id" | isql Asterisk <lot of output from table> SQLRowCount returns 39 39 rows fetched So the odbc thingy works! root@pbx:# cat res_config_odbc.conf [settings] table = ast_config connection = myconn root@pbx:# cat res_odbc.conf [myconn] d...

...ed the following line: musiconhold.conf => mysql,asterisk,bit_ast_config - The following is the table in the database: mysql> select * from bit_ast_config; +----+------------+-------------+----------------+-----------------------+-----------+---------------+----------+ | id | cat_metric | var_metric | commented | filename | category | var_name | var_val | +----+------------+-------------+----------------+-----------------------+-----------+---------------+----------+ | 2 | 0 | 0 | 0 | musiconhold.conf | yaron | directory |...

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 ([]) var_name = variable/command/directive such as an extension, global variable, etc.. var_val = value for var_name Also, I'm assuming the metric starts at 1 for each c...

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 ASCENDING order? The docs imply that you use cat_metric to specify the order that you want your contexts to appear. If Asterisk sorts in descending order, they will be reversed!...

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 '', `category` varchar(128) NOT NULL default 'default', `var_name` varchar(128) NOT NULL default '', `var_val` varchar(128) NOT NULL de...

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 (text file) I have : sipusers => mysql,AsteriskDB,sip_buddies sippeers => mysql,AsteriskDB,sip_buddies sip.conf => mysql,AsteriskDB,ast_config In sip.con...

...xtensions.conf and agents.conf are static, all other configs use the regular realtime engine and they all work fine. This is the table structure I have been using since 1.2: CREATE TABLE `ast_config` ( `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, `category` varchar(128) NOT NULL, `var_name` varchar(128) NOT NULL, `var_val` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `filename_comment` (`filename`,`comm...

...engine Aug 7 16:38:43 DEBUG[16384]: config.c:779 __ast_load: Parsing /etc/asterisk/res_config_odbc.conf Aug 7 16:38:43 WARNING[16384]: res_config_odbc.c:103 config_odbc: SQL select error! [select * from ast_config where filename='sip.conf' and commented=0 order by filename,cat_metric desc,var_metric asc,id] Aug 7 16:38:43 DEBUG[16384]: config.c:810 __ast_load: No file to parse: /etc/asterisk/sip.conf Aug 7 16:38:43 NOTICE[16384]: chan_sip.c:8249 reload_config: Unable to load config sip.conf, SIP disabled Aug 7 16:38:43 DEBUG[16384]: channel.c:198 ast_channel_register_ex: Registered handler...

...me=*** password=*** pre-connect=yes ; [settings] table = ast_config connection = mysql And that's what I have in my ast_config table: +----+------------+------------+-----------+-------------+-----------+-------------+-----------------------------------------------------+ | id | cat_metric | var_metric | commented | filename | category | var_name | var_val | +----+------------+------------+-----------+-------------+-----------+-------------+-----------------------------------------------------+ | 27 | 0 | 0 | 0 | queues.conf | test | Me...

...ies 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 filename, cat_metric desc, var_metric asc, category, var_name, var_val, id; which is in no way related to the table I created following the example on the wiki. Is there another table format , I have +-------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra...

...----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | cat_metric | int(11) | NO | | 0 | | | var_metric | int(11) | NO | | 0 | | | commented | int(11) | NO | | 0 | | | filename | varchar(128) | NO | | | | | category | varchar(128) | NO | | default | | | var_name | varchar(128) | NO...

...some more and found http://www.voip-info.org/wiki-Asterisk+res_config Decided to try these instructions as well. So: 5) I created the ast_config table as directed: Here is the data: +----+------------+------------+-----------+----------------+----------+----------+---------+ | id | cat_metric | var_metric | commented | filename | category | var_name | var_val | +----+------------+------------+-----------+----------------+----------+----------+---------+ | 1 | 0 | 0 | 0 | voicemail.conf | default | | | +----+------------+------------+-----------+----...

...musiconhold.conf => mysql,asterisk,bit_ast_config > > - The following is the table in the database: > mysql> select * from bit_ast_config; > +----+------------+-------------+----------------+-----------------------+-----------+---------------+----------+ > | id | cat_metric | var_metric | commented | filename | > category | var_name | var_val | > +----+------------+-------------+----------------+-----------------------+-----------+---------------+----------+ > | 2 | 0 | 0 | 0 | > musiconhold.conf | yaron...