Displaying 20 results from an estimated 1000 matches similar to: "voicemail.conf from DB"
2020 Jun 14
2
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,
2005 Aug 11
5
Realtime + MYSQL
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
2005 Sep 15
1
Can not get realtime static voicemail.conf to work
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
2005 May 24
1
realtime static
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 ([])
2004 Dec 31
1
Help With Configuration From Odbc
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=
2020 Jun 14
1
Any api (agi/ari/ami) equivalent of "core show calls"?
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
2020 Jun 14
0
Any api (agi/ari/ami) equivalent of "core show calls"?
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:
2015 Feb 23
2
Dynamic Music on Hold
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
2005 Jun 10
1
Convert extensions.conf INTO MySQL script
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
2020 Jun 14
2
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
2006 Dec 05
1
Need some examples for configuring Asterisk under Realtime static
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 '',
2006 Nov 02
0
Static Realtime Select from Database
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
2010 Aug 03
1
sip.conf register in realtime DB
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
2009 Oct 08
1
Realtime static does not work in 1.6.1 or 1.6.2
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': ==
2004 Jul 07
1
res_odbc not working
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
2013 Nov 11
1
Asterisk Realtime Static Voicemail
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
2005 Feb 11
1
Still stuck trying to make Asterisk read MySQL
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.
2004 Aug 07
1
res_config_odbc not working
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
2001 Dec 18
1
[PATCH]: Fix environment variable size restriction in Cygwin version
Hi,
the following patch changes the Cygwin specific function copy_environment()
to not restricting the strlen of a single environment variable to 512 byte.
The PAM specific function do_pam_environment() (also in session.c) has
the same problem but I don't know if that's important for PAM since
only PAM specific environment variables are copied in that function.
The below patch fixes
2011 Dec 16
3
ODBC problem - static realtime file not loading
Hi all
I'm trying to configure my Asterisk setup to load the musiconhold.conf file from an ODBC connection to MySQL, working through the example given in the excellent book "Asterisk: The Definite Guide". I'm using Asterisk 1.4.19 and MySQL 5.1.58. I've configured the ODBC bit and in my GeneralLog on MySQL I can see the asterisk user connecting and sending a few SQL