similar to: RE: Best way to access MySQL data from dial plan

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

For those strugling as me for the long time with question: "how the hack i can read a value from registred family name using realtime?" and not to use dbodbc or odbcexec , here's the sollution: RealTime(<family>|<colmatch>|<value>[|<prefix>]) All unique column names will be set as channel variables with optional prefix to the name. e.g. prefix of

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,

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

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.

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

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

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Hello, I'm trying to use MySQL for Dialplans and have followed the Asterisk RealTime Extensions setup. The MySQL table is called "extensions" and I have entered two records.. ext 1000 and 2000. I also added switch => Realtime/default@extentions in extensions.conf and extensions => mysql,asterisk,extensions in extconfig.conf I do a *CLI> dialplan reload but when I show

Hi i am not a expert on Asterisk and search a lot of small information : I use Asterisk 1.6.1.4 with MySQL. That's work and in my extension.conf, i have: [as5300-incoming] switch => Realtime and in extconfig.conf extensions => mysql,general,VOIP_Extensions A lot of Extension are into the table VOIP_Extensions. I am search to know if i can add a :

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

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass =

Guys, I'm having a hellava time getting realtime to work, focused on sipusers right now, followed the wiki and other examples but still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database

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

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=

11-10-2004 there was a subject: Re: Where did USE_SIP_MYSQL_FRIENDS go?: on asterisk.user list. >All db specific code has been removed from the code in favor of the >currently-in-development "RealTime" method of configuration from >database. >You are most likely not using the 1.0 stable branch. >You need to use the new RealTime configuration method. And currently,

Hi to all. I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem, the asterisk don't connect in the base and show this message: [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'asterisk_teste' (check res_mysql.conf) I checked the asterisk config file (res_mysql.conf) and the configuration

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

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 am currently in the process of testing out realtime support for sip.conf. I have followed all of the directions that are listed in the Wiki, but for some reason this does not work. When utilizing a flat file, I am able to register endpoints without any problems, and calls can proceed. One interesting side effect that I have noticed is that when I am using realtime for sip, I am unable to see