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