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