search for: extensions_table

Displaying 20 results from an estimated 25 matches for "extensions_table".

2005 Jan 20
1
Realtime Engine
...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...
2008 Nov 06
1
Asterisk Realtime Configuration
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)...
2005 Mar 11
1
Trouble with Realtime
...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...
2005 Jun 28
2
Asterisk Realtime and ODBC
...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...
2005 Aug 10
1
asterisk query mysql problem or bug?
...| 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 |...
2005 Jan 18
2
Realtime Voicemail ...
...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...
2006 Dec 05
1
Question about Realtime static table
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 '...
2005 Jan 14
2
Realtime / sip.conf
...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
2005 Jan 05
7
Realtime
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:
2004 Dec 28
1
Chan IAX2 errors while calling Toll Free numbers using IAXTEL
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
2005 Aug 10
2
app_voicemail.c still looking for config file even I try to configure the voicemail from database.
...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 | +...
2010 Feb 18
1
Realtime extensions
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
2013 Oct 16
1
Use Asterisk Realtime Extensions with Switch-statement and include-statement
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...
2007 Oct 09
2
Asterisk Realtime woes
...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...
2005 May 04
4
Problem with realtime SIP
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
2005 Sep 13
1
populating asterisk realtime tables from configfiles
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 =...
2007 Apr 05
1
Dialplan not reading MySQL table
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
2008 Feb 07
2
Goto in Realtime extensions
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
2008 Oct 21
2
[help] Realtime Swich any context dinamically
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 =>
2007 Nov 20
0
iaxpeers from Realtime
...| 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 | +-----+----------------+-------+----------+------+----------------------...