similar to: res_config

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 want to let Asterisk read its configuration from a mysql database. I configured everything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf =>

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=

Hi iam using 1.2.17 does any one have information meetme in realtime and store in mysql i dont see any document could some one help me is this possible ? ram -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070606/36d236c2/attachment.htm

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

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

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

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

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

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,

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

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

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

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

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 have recently started experimenting with Asterisk. I am running the system the other side of the a NAT router and trying to connect to FWD. I have opened UDP ports and have configured sip.conf to handle NAT. The problem: I can call from the FWD phone and the extension on Asterisk rings and there is two way sound so no problem. Now if in the extension.conf file I have, exten =>