similar to: populating asterisk realtime tables from config files

Here is my file to parse and load extensions. No wise cracks about my code.... DB.php is the Pear DB module. (pear.php.net) <?php include('DB.php'); $db_host = ''; $db_name = ''; $db_login = ''; $db_pass = ''; $db_table = 'extensions_table'; define(DBINFO,"mysql://$db_login:$db_pass@$db_host/$db_name"); $db =

Hi All, In the realtime voicemail table the column 'customer_id' is used, for my purpose, to specify the customers accountcode. The column name 'accountcode' is used in the iax and sip tables. To keep this consistent throughout the tables, is there any reason I should NOT switch the column name 'customer_id' to 'accountcode' in the voicemail table? Does Asterisk

Howdy, My first forray into using res_mysql.conf for realtime access of sip users and extensions. I have the following relevant section of extensions.conf: --- [trunklocal] exten => _NXXXXXX,1,Dial(${GLOBAL(TRUNK)}/${EXTEN:${GLOBAL(TRUNKMSD)}}) [local] include => trunklocal include => trunktollfree [longdistance] include => local include => trunkld [international] include

Hello ppl, Am using realtime odbc storage for voicemail, sip users/peers, static for extensions and so on. My issue is I am not getting MWI for any fones, even tho I've got rtcachefriends=yes in sip.conf WIth tcpdump, I always see the NOTIFY going as Messages-Waiting:.no Voice-Message:.0/0.(0/0) even tho there are legitimate voicemails in the INBOX path for that particular users in the

Hi All, I'm having an issue where Asterisk continuously sends out a GAZILLION "SIP NOTIFY" messages when a user has a voice message in their INBOX. This issue is only present when my SIP users and peers are configured from my ODBC backend (MySQL). A static configuration of users in sip.conf resolves this and everything works fine. I'd like to confirm the layout of the

Hello, Right now there is not a table build script at: http://www.voip-info.org/wiki-Asterisk+RealTime+IAX Therefore I have taken the SIP build script and added a few fields that I use from my iax.conf (could be more out there, please see the complete build script below): `dbsecret` varchar(100) default '', `notransfer` varchar(100) default '', `inkeys` varchar(100)

hi, is it possible use asterisk static realtime and config files simultaneously in asterisk 11? i want [globals] from extensions.conf in database, but dialplan in extensions.conf config file i saw this can be configured in stasis.conf in asterisk 13 thanks -- --------------------------------------- Marek Cervenka ======================================= -------------- next part

Hello, I'm experimenting with Asterisk and MySQL. Up to know I've just put iax.conf in a MySQL database and it seems to work: when a Iax2 client registers the corrispondent row in db is updated. Good. However when I have many asterisk boxes pointing to the same db a problem arises: I need an additional column in iax_buddies table called for example "Asterisk ID" which tells me on

I am a fairly novice Asterisk 1.4 user who used to use CallWeaver, based on asterisk 1.2. I used Realtime MySQL with CallWeaver and am currently using the very same MYSQL tables (and columns) with Asterisk 1.4.11 and things are working well. The questions I have are, since new configuration variables have been added into Asterisk 1.4, can I simply add columns in my MySQL sippeers table for

I was looking for MySQL table structures for ARA (Asterisk 1.8.X). I found one for SIP friends on, https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure But it seems that it is not as per the Asterisk 1.8 SIP options. i.e. it contains 'call-limit' which is deprecated in 1.8 and not the 'callcounter' as one of the fields. Pardon my ignorance, but are

It took me a whole lot of reading to catch what is likely not all that subtle to many, but it was subtle to me. Static: Is the global config stuff from voicemail.conf mailboxes aren't done in the voicemail.conf file. The perl script, ast2sql.pl will parse a given config and put it into a SQL db (MySQL in my case). /etc/asterisk/extconfig.conf

Hello I'm about to set up a voicemail system for multiple wholesale customers. So I use a realtime mysql config for the mailboxes. All single mailboxes have their information about the number, emailaddress, password in the database. This works fine. Now the notification emails of course should be customized per wholesale customer. I added a 'mandate' table to the database and

I'm going to be testing the new realtime stuff further in the next few days, and just wanted some clarification on a couple of things before I start on it. I believe I can store any config file in a external config such as mgcp.conf for example, by adding it to extconfig.conf with the below syntax. mgcp.conf => mysql,asterisk,mgcpchans Doing this will require a reload of asterisk to read

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 have a default installation of asterisk 1.6.1.9-2 When i create a user in users.conf via asterisk-gui, calls, voicemail etc works. But if i create a user realtime (and my realtime caching is available too) i can see the realtime user with sip show peers. But, my local dial rules does not work. I can call from realtime user to static users(the ones in users.conf) and if they are not

I am trying to configure RealTime Voicemail with MySQL. I downloaded compiled and installed the CVS HEAD for asterisk, and for asterisk-addons. MySQL seems to be loading correctly (the cdr table is recording incoming calls). But the RealTime Voicemail doesn't seem to be checking the database table for the voicemail users. When trying to login to voicemailMain if I use a user in the

Hi all, A week or so down the list, i read that not many people were using realtime on an Asterisk18, so i had this afternoon a go at it... [sorry for the inconveneant line-wraps] First i did: mysql> create database asterisk; mysql> grant all on asterisk.* to 'voipadmin'@'localhost' identified by next i used the info from the wiki: CREATE TABLE `sip_devices` ( `id`

How "real time" is realtime? If the extensions.conf is stored in the database, does * query it row by row or is it "cached"? In other words, given the following exerpt: exten => 5001,1,Dial(IAX2/test@test/s,30,g) exten => 5001,2,Voicemail(u5001) exten => 5001,102,Voicemail(b5001) exten => 5001,103,Hangup exten => 5002,1,Dial(IAX2/test2@test2/s,30) exten =>

Hi, Case1: --------- --> extensions.conf exten => 1023,1,Voicemail(101) exten => 1023/101,1,MeetMe(200) Case2: --------- -> extensions table (using realtime extensions) +----+---------+----------+--------+----------+---------+ | id | context | exten |priority| app | appdata | +----+---------+----------+--------+----------+---------+ | 29 | default | 1023 | 1 |

Hi All, I'm running 1.2.9.1. I can prune sip realtime peers and users and iax realtime peers but no command to prune iax realtime users. Was this implemented in a later version? Thanks. JR -- JR Richardson Engineering for the Masses