similar to: Realtime Extensions hint priority

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)

Hi I've just had a request from a customer who wants to use Busy Lamp Feed. I've had a look around and it would appear that you have top use the 'hint' priority. We are using asterisk 1.4.17 with realtime and the priority column in the extensions table is a tinyint so obviously I can't put hint in there. Has anyone any experience of working round this problem? Thanks

Can someone shed some light on why the 'hint' feature was implemented in the 'priority' field that is purely an integer in the rest of the dialplan? There seems to be a conflict with realtime and the hint priority, in order to put in the hints you would have to change the priority column in the database from int to char and give up some performance (since int indexes better and

>From voicemail.conf: ; Maximum number of messages per folder. If not specified, a default value ; (100) is used. Maximum value for this option is 9999. ;maxmsg=100 ; Maximum length of a voicemail message in seconds ;maxmessage=180 ; Maximum length of greetings in seconds ;maxgreet=60 I would like to configure these parameters on a per mailbox basis using Realtime voicemail. I

Hello, I have a partially working Realtime Queue using unixODBC and Firebird. I followed the steps on asterisk-guru and the voip-info asterisk message boards but have been having no success. I say that my queue is partially working because callers can join the queue. However the calls do not go to the agents even if the agent is not tied up and is available for calls. So the caller is stuck

Hi All, I was able to insert some extensions in Mysql DB and use them successfully. In Mysql extensions table the priority column is of type tinyint and when I give 's' value for it, it is not accepting that value as it takes only tinyints. Please tell how can I make that column accept values like t,s,i and make it work with asterisk in realtime without any problem? If I change the type

Hello, I installed 1.2.5 and realtime SIP. The connection to the DB is OK because I can get the values from the CLI. Here are my 3 different cases: 1- If I put an unexisting user, I get 404 and I am not able to dial. 2- If I check "Disable registration" within Firefly it does not register but I am able to dial a destination (...) 3- If I leave registration ON, I get the 404 message

So I''ve worked through Agile Web Development with Rails and I''m now trying my first little app to get into the swing of things. Its a task tracking app where people can create tasks and assign them to others, and also log time against the tasks. I''m having trouble working out the model relationships. This is what I''ve got so far, but its not right as

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)

ok so my table looks like this... REATE TABLE `sip` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `accountcode` varchar(20) default NULL, `amaflags` varchar(7) default NULL, `callgroup` varchar(10) default NULL, `callerid` varchar(80) default NULL, `canreinvite` char(3) default 'yes', `context` varchar(80) default NULL, `defaultip`

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

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

I just upgraded from 1.6.0.14 to 1.6.1.6 and now my realtime static configuration for extensions.conf will not load. All other realtime configs work (SIP, IAX2, Voicemail). I cannot find any reference or documentation about the structure of the realtime static database for 1.6.1.x but I have used the same table structure since 1.4.x. CREATE TABLE `ast_config` ( `id` int(11) NOT NULL

Hi all, I am trying to display collective data from 3 MySQL tables: The query I have, so far, is SELECT c . * , COUNT( m.id ) AS `members` FROM `jos_mls_teams` AS `c` LEFT JOIN `jos_mls_teams_members` AS `m` ON m.teamid = c.id RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` AS `u` ) ON u.id = m.userid GROUP BY c.id LIMIT 0 , 30 But get the following error: #1248 - Every derived

Hello asterisk users, here is a little problem pulling out iax peers from real time database I have the following peer configured in my database mysql> select name,username,secret,type,context,host,disallow,allow,defaultip,deny,permit, ipaddr,port from iax_users where name='iaxtermination'; +----------------+----------+----------------------------------+------+-----

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': ==

hi, i'm a bit puzzled because i do not get include and hint to work with the new realtime enginge (cvs-head from 2004-12-09). other things (sipfriends and "normal" extensions) work perfect with the realtime engine. the entries in the static extensions.conf file i used before where: exten => 183,hint,SIP/snom220 exten => 183,1,Macro(stdexten,443,SIP/snom220,183) exten =>

Hi All, I'm testing some realtime extension apps with Asterisk 1.4.28 and addons 1.4.10 using res_mysql. Localhost database is 5.0.32 with Debian Etch. The apps are working fine all syntax is proper, using Set with (REALTIME) function, Set with (CUT) function, calling a Macro with s extensions, and using a few pattern matching extensions as well. I can certainly detail all database rows if

Hi guys, Sorry if I'll be very very stupid but really I write to this conference first. I have problems with configuration of app_meetme in realtime environment. I use last stable release of asterisk 1.6.0.3 Now situation is following. I create database and table in it. Th table is CREATE TABLE IF NOT EXISTS `booking` ( `bookId` int(10) unsigned NOT NULL auto_increment, `clientId` int(10)

Hello, I am struggling with what seems a common unresolved problem, changing the password from voicemailman when using a realtime engine (adaptive_odbc in my case, connected to mysql). I have seen messages dating back to 2007 with this problem and the last one was bug 5168, reported as closed, but without explaining the fix