similar to: Dynamic Music on Hold

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 >

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': ==

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,

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

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

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

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

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=

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 ([])

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

I have been playing with res_odbc in these last days, but it doesn't want to work. This is the output when starting Asterisk, so everything seems OK: [res_odbc.so] => (ODBC Resource) == Parsing '/etc/asterisk/res_odbc.conf': Found Jul 7 20:11:32 NOTICE[-1084915040]: res_odbc.c:132 load_odbc_config: registered database handle 'mysql' dsn->[MySQL-asterisk] Jul 7

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

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

Hi, Can somebody tell me what I've been doing wrong for the res_config_odbc not to work properly. I already looked on the mailing list for some answer but I can't find one. The closes subject I found is "res_odbc not working". Btw, I already followed BKW reply on that subject. I guessed the log below can tell us res_odbc.so is succefully loaded, so it easy to presumed it

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

I've been continuing to experiment with MySQL. I'm having absolutely no luck getting asterisk to read voicemail configuration data and mailbox configuration data from mysql tables instead of from voicemail.conf. The default Asterisk setup that reads from voicemail.conf and extensions.conf works fine. I'm using Asterisk CVS-v1-0-12/12/04-15:58:29 on a Whitebox Enterprise Linux box.

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