similar to: realtime sip channel configuration -> insecure option

Hi all I've been doing some testing on realtime using mysql, an have a little question that could not find the answer to or maybe its not posible at this time. Is there a way use "register=>......" on a DB using realtime. For the moment I use it in sip.conf. It will help me a lot if this could be store on a DB somehow. commets or sugestions .... ? thanks Billy

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

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

Guys, I'm having a hellava time getting realtime to work, focused on sipusers right now, followed the wiki and other examples but still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database

Hi... I just had a real quick and simple question... I have a asterisk implementation setup w/ real time off of a mySQL database for SIP peers and queues, voicemail, agents etc... I after the upgrade to asterisk 1.4.3 there are some new configuration features i would like to use. I was wondering if i could just add to the database table a column for the new config option? if this will work or

Hello, I am just asking this because I am note sure if the problem is on my side or not, I saw some comments on SIP realtime today so I was wondering, has anybody has SIP realtime working with a softfone ? If yes, please confirm, that would give me a light. My previous message to the list is below. Thanks. Frederic ----- Original Message ----- From: Frederic Jean To:

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:

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 List: Can someone hlep to provide one or two examples to data entry for sip.conf under the table structure? CREATE TABLE `sip_conf` ( `id` int(11) NOT NULL auto_increment, `cat_metric` int(11) NOT NULL default '0', `var_metric` int(11) NOT NULL default '0', `commented` int(11) NOT NULL default '0', `filename` varchar(128) NOT NULL default '',

Hi, ? I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk

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 |

Paste your extensions.conf section that is relevant. -Matthew ----- Original Message ----- From: "Greg - Cirelle Enterprises" <gcirino@cirelle.com> To: <asterisk-dev@lists.digium.com> Sent: Monday, December 27, 2004 4:32 PM Subject: [Asterisk-Dev] realtime voicemail > Let me clarify my last message. > > If I put in the wrong password I get polled > again for

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

Guys, I need you help on this one. Don't know when this broke but we have a custom gui that runs on top of Asterisk running a real-time static for configurations. Nothing has changed with the database other than upgrades of Asterisk 10. Customer complained that there password was not changing when they called into voicemail and changed it. Database is running standard ast_config with the

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

Hi all, From the web, I can find a table scheme of sipusers for ARA using. However, I can't find any meaning of each field, especially for the field regserver which is new in the table. Can any tell me more detail about the usage of each field? CREATE TABLE `sip_buddies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `host` varchar(31) NOT NULL

Hello list, using asterisk 1.4.30. When setting up the MySQL table 'musiconhold' as described in http://www.voip-info.org/wiki/view/Asterisk+config+musiconhold.conf , what is the meaning of the fields : `*digit*` char(1) NOT NULL default '', `*sort*` varchar(16) NOT NULL default '', and what are there default values ?! What is the default value of :

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

It seems that when setting qualify = 200 or qualify = yes in the database for a sip friend/peer, RealTime does not update the registration status like it should. I also have several peers which have been offline and Asterisk still reports them as registered, even though the registration seconds are only 200. Asterisk Ver: CVS HEAD 12/1/2004 Layout of sip_buddies: mysql> describe