search for: extensions_table

...EN} exten => _XXXXXXXXXX,4,Hangup switch =>Realtime/@ exten => _XXXXXXXXXX,6,VoiceMail,u${EXTEN} exten => _XXXXXXXXXX,7,Hangup exten => _XXXXXXXXXX,107,VoiceMail,b${EXTEN} exten => _XXXXXXXXXX,108,Hangup Then in my extensions table I will have data like the following INSERT INTO `extensions_table` VALUES (1, 'inbound', '_5172078354', 5,'DIAL', 'SIP/5172078354'); INSERT INTO `extensions_table` VALUES (2, 'inbound', '_5172078355', 5, 'DIAL', 'SIP/5172078355'); INSERT INTO `extensions_table` VALUES (3, 'inbound', '_5...

Hi, Having some issues here with getting asterisk realtime for the dialplan (extensions.conf) setup: mysql> desc extensions_table; +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | MUL | NULL | auto_increment | | context | varchar(255)...

...same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config: Extconfig.conf (Under the [settings] section) sipusers => odbc,voip,sip_users sippeers => odbc,voip,sip_users voicemail => odbc,voip,voicemail_users extensions => odbc,voip,extensions_table res_odbc.conf [asterisk] dsn => MySQL-asterisk username => voip password => temp123 pre-connect => yes Under extensions.conf, in the [from-sip] context: switch => Realtime/from-sip@extensions. Running isql MySQL-asterisk voip <pass> connects to the DB, and queries return t...

...uot; and "isql" utilities, and Ethereal for network monitoring. Everything worked perfectly. Then we set up asterisk as follows: <extconfig.conf> [settings] sip.conf => odbc,asterisk,ast_config sipusers => odbc,asterisk,sip_buddies sippeers => odbc,asterisk,sip_buddies extensions_table => odbc,asterisk,extensions_table <extensions.conf> [default] switch => Realtime/default@extensions_table <res_odbc.conf> [asterisk] dsn => "our DSN name" username => "our username" password => "our password" pre-connect => yes <mo...

...| 2000 | 5060 | | 2 | 2001 | from-sip | 10.1.2.220 | dynamic | 2001@local | friend | 1123733888 | 10.1.1.220 | 2001 | 5080 | +----+------+----------+------------+---------+------------+--------+------- -----+------------+----------+------+ 2 rows in set (0.01 sec) mysql> select * from extensions_table; +----+----------+-------+----------+---------------+----------------+ | id | context | exten | priority | app | appdata | +----+----------+-------+----------+---------------+----------------+ | 1 | from-sip | 2000 | 1 | Dial | SIP/2000,20 | | 2 | from-sip |...

...ssword 201 fullname Mailbox 201 stamp 20050118164309 CLI> When I try to log into the Voicemailmain, it cribs for incorrect login as shown below. Where am I going wrong ? Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions_table WHERE exten = '8500' AND context = 'default' AND priority = '1' Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Everything is fine. Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions_table WHERE exten LIKE '\_%' AND context = 'defaul...

Hi All: I'd like to use Realtime Static in terms of the performance concern about dynamic realtime. Assume that I create a table: as following: CREATE TABLE `extensions_table` ( `id` int(11) NOT NULL auto_increment, `context` varchar(20) NOT NULL default '', `exten` varchar(20) NOT NULL default '', `priority` tinyint(4) NOT NULL default '0', `app` varchar(20) NOT NULL default '', `appdata` varchar(128) NOT NULL default '...

...just commenting out the sipfriends line in extconfig.conf the problem goes away. I do have the system utilizing realtime for Voicemail and Extensions, and I do not have any problems. Has anyone seen this problem before? extconfig.conf =-==-=-=-=-=-= [settings] realtime_ext => mysql,asterisk,extensions_table voicemail => mysql,asterisk,voicemail_table sipfriends => mysql,asterisk,sip_extensions *CLI> realtime mysql status Connected to asterisk@127.0.0.1, port 3306 with username asterisk for 10 minutes, 22 seconds. -Brian

Hi, Jan 6 01:43:09 WARNING[12209]: pbx.c:796 pbx_find_extension: No such switch 'Realtime' What does this message mean ? Something wrong with the switch statement in my extensions.conf or maybe is the module net correctly installed ? Thnx. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi List, While trying to calling Toll Free numbers using IAXTEL, the call connects, I hear about 2 seconds of voice and then the voice drops off and I get the following error message which keeps scrolling across my console screen. WARNING[-167797840]: chan_iax2.c:5967 socket_read: Received mini frame before first full voice frame Asterisk shows that the format of this call is GSM. However if I

...terisk load config from database, so far I get the sip, extension working, but voicemail seems still looking for config file, not from the database. the extconfig.conf looks like ... sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies extensions => mysql,asterisk,extensions_table voicemail => mysql,asterisk,voicemail_users .. the table looks like mysql> select * from voicemail_users; +----------+-------------+---------+---------+----------+----------+-------- ---------------+------+ | uniqueid | customer_id | context | mailbox | password | fullname | email | page | +...

Hello list ! Can realtime dialplan be combined with 'hardcoded' dialplan in extensions.conf ?? Does a context need completely be written or in extensions.conf or in the mysql-table 'extensions_table' ? Or can I combine the two with the 'switch'-statement ?? Kind regards, Jonas. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100218/9f6dea67/attachment.htm

Hello, Is it possible to use the switch => statement in extensions.conf (http://www.voip-info.org/wiki/view/Asterisk+RealTime+Extensions) to point to a database and in the database use the include-statement ? In extconfig.conf I would have : extensions => mysql,asterisk,extensions_table In extensions.conf I would then have : [includecontext] switch => Realtime/includecontext at realtime_ext in database : INSERT INTO `my_extensions_table` VALUES (NULL, 'includecontext', 'include', =>, 'context1', ''); INSERT INTO `my_extensions_table` VAL...

...al at extensions res_mysql.conf [general] dbhost = 10.100.1.32 dbname = asterisk dbuser = asterisk dbpass = *********** dbport = 3306 dbsock = /var/lib/mysql/mysql.sock extconfig.conf sipusers => mysql,asterisk,sip_users sippeers => mysql,asterisk,sip_users extensions => mysql,asterisk,extensions_table And heres the DB config.... mysql> select * from extensions_table; +----+----------+-------+----------+--------+-----------+ | id | context | exten | priority | app | appdata | +----+----------+-------+----------+--------+-----------+ | 1 | internal | 111 | 1 | Dial | SIP/tim...

Hi Guys, We have just set up Asterisk (CVS Head) for a realtime enviorment using MySQL & Asterisk Addons. I have populated the "sip_buddies" table with the same information that is came from our sip.conf, however registration seems to fail for the softphone we have set up. Does anyone have any idea as to what I should be looking for here? I'm not getting any error messages

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 = DB::CONNECT(DBINFO); if(!DB::isError($db)) { //we got the db connection $extensions = file('extensions.conf'); foreach($extensions as $extension) { $application =...

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

Hello, I'm having troubles while using the "Goto" function in a realtime extension. Here is the error message : -- Executing Goto("SIP/siemens1-081f56b0", "script_13_0|s|1") -- Goto (script_13_0,s,1) [Feb 7 13:24:21] WARNING[28666]: pbx.c:2455 __ast_pbx_run: Channel 'SIP/siemens1-081f56b0' sent into invalid extension 's' in context

when i wnat to working with realtime and mysql for any context i have to insert (switch => Realtiem/context at extensions) statment into extensions.conf for example if i want to have 10 context, i have to insert these lines into extension.conf : [context1] switch => Realtiem/context1 at extensions [context2] switch => Realtiem/context2 at extensions [context3] switch =>

...| gsm;alaw;ulaw | NULL | NULL | NULL | NULL | 0 | +----------------+----------+----------------------------------+------+----- -----------+--------------+----------+---------------+-----------+------+--- -----+--------+------+ And the extension to use it is.. mysql> select * from extensions_table where context='iaxtermination' order by context,exten,priority; +-----+----------------+-------+----------+------+-------------------------- --------------+ | id | context | exten | priority | app | appdata | +-----+----------------+-------+----------+------+----------------------...