similar to: Asterisk Realtime woes

Greetings, I'm having some trouble with the realtime engines. When asterisk loads, everything looks fine, there don't seem to be any problems via notices or anything. Furthermore, cdr_odbc is working, and actively logging my failed call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config:

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'; +----------------+----------+----------------------------------+------+-----

I'm going to be testing the new realtime stuff further in the next few days, and just wanted some clarification on a couple of things before I start on it. I believe I can store any config file in a external config such as mgcp.conf for example, by adding it to extconfig.conf with the below syntax. mgcp.conf => mysql,asterisk,mgcpchans Doing this will require a reload of asterisk to read

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 |

Having problems getting realtime working, I'm trying to use odbc for all of this. I've got Fedora 3 and have been fighting with odbc for a day now. I think I got it working correctly, however I can't seem to get the realtime portion working. In asterisk 'odbc show' shows it connected, I see it on my (odbc) mysql server connected and all, it connects and just idles. So, without

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

Hi All, I'm having an issue where Asterisk continuously sends out a GAZILLION "SIP NOTIFY" messages when a user has a voice message in their INBOX. This issue is only present when my SIP users and peers are configured from my ODBC backend (MySQL). A static configuration of users in sip.conf resolves this and everything works fine. I'd like to confirm the layout of the

Hi; I have entries as below in DB, mysql> select * from sip_buddies; +----+------+----------+------------+---------+------------+--------+------- -----+------------+----------+------+ | id | name | context | defaultip | host | mailbox | type | regseconds | ipaddr | username | port | +----+------+----------+------------+---------+------------+--------+-------

Hello. I'm testing the new Asterisk 1.6 beta 5. I'm using realtime to store extensions and sip users. When a user logs on, everything works fine - calls are also fine. But I keep getting these in the console: [Mar 9 16:31:58] WARNING[10284]: res_config_pgsql.c:195 realtime_pgsql: PostgreSQL RealTime: Could not find any rows in table sip_users. Full log: http://rafb.net/p/LO7DEM95.html

Hi, Realtime SIP and Extensions are working fine but facing some problems with Voicemail. Added an entry to extconfig.conf voicemail => mysql,asterisk,voicemail_users Created the corresponding table and an entry for mailbox 201. This is also reflected in the CLI as shown below. CLI> realtime load voicemail mailbox 201 Column Name Column Value

I have read and followed as much as I can find but I am missing something. What I want to do is get as much as I can running from mysql and keep the *.conf files for static things. So I have setup a SIP users/peers table in a mysql database and I have populated it with a few peers. I have configured asterisk addons and from the asterisk CLI I am able to search the sip users / peers tables using

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'm testing Asterisk with MySql and I would want to insert sip users in a table "sip_users". After I modified extconfig.conf with "sipusers => odbc,asterisk" and I create the table sipusers, which changes must I make to sip.conf? Thank's Maury P.S.: C'? qualche utente italiano nella mailing list? -------------- next part -------------- An HTML attachment

All, I get this whenever trying to dial to a peer when the peer registered to another server. I'm basically trying to use realtime to check for the peer and dial it. Mar 24 09:16:47 VERBOSE[4527]: -- Executing Dial("SIP/brak-f69f", "IAX2/brak-test/107") in new stack Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_users WHERE name =

I am currently in the process of testing out realtime support for sip.conf. I have followed all of the directions that are listed in the Wiki, but for some reason this does not work. When utilizing a flat file, I am able to register endpoints without any problems, and calls can proceed. One interesting side effect that I have noticed is that when I am using realtime for sip, I am unable to see

Hi I am trying to make asterisk 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

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:

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

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 =

Hello, Here is how I do this. The prerequisits are: - MySQL to hold the extensions realtime database. MySQL is synchronized among all servers using the Master/slave replication model. - The phones are spread by some external algorithm over the Asterisk servers (statefull load balancer, statically defined in the config file of the phone, etc.). The idea is to locate on which server the