similar to: authoritative sql definitions for Asterisk Realtime Architecture ARA

Hi I am having problems with Asterisk 1.4.18 and realtime architecture. I use Postgresql-8.3 as the database. Everything works OK; all sip phones (their configs are in the database) are able to register to the server and I can make calls (dialplan is in the database), but each time Asterisk reads the information from the database it shows me this on the console: [Feb 17 12:32:50] WARNING[620]:

Has anyone had any luck with PostgreSQL and Realtime? The realtime instructions on voip-info seem pretty straight forward... just not woking for me. I've included all of my config files below, and my console output. Entire console bootup output: [root@abox asterisk]# /usr/sbin/asterisk -vvvvvvc == Parsing '/etc/asterisk/asterisk.conf': Found == Parsing

hi, all i try to confiture realtime queue, but not work, details as below: Insert into queue_table(name)value('95040654321'); INSERT INTO queue_member_table VALUES ('', 'Zhang Shukun', '95040654321', 'SIP/1001', 2, 1); INSERT INTO queue_member_table VALUES ('', 'Li Aiwei', '95040654321', 'SIP/1002', 2, 1); INSERT INTO

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

Hi, I have a problem with IAX accounts... I set up a few months ago an Asterisk server, with mysql support to load iax accounts. Settings seems fine because apparently the system works as expected. Yesterday I tried to add another iax account in the iax.conf directly. And I have a problem with this new account (named 444). I can authenticate from 444 to the server, and I can receive calls from

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,all i have just upgrade from 1.4.28 to 1.6.2.1. all works fine now except realtime queue. it seems queue_table works fine, but queue_member_queue not work, the two tables works fine when in 1.4.28. is that something changed related to realtime queue configuration? more detail about two table definition and data stored in , please see: http://pastebin.com/m33f9539e the extconfig.conf file,

Hi all, I try to make a call from my Openser(SIP Proxy) to the asterisk in different machine. I use my asterisk as a trunking gateway. I can make a call from my openser to some trunking gateway such as my cisco 5300 or welltech 5250. In the same method, I try to make a call to asterisk ( sip listen on udp 5060 ) I use ngrep on my asterisk machine and list as below. But I can't find any sip

I have configured my mysql database by following this link http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue The only difference is that I am using ODBC instead of MySQL with Realtime. Within extensions.conf I have the following for my queue exten => 9**2**1611,1,Answer exten => 9**2**1611,2,Queue(irock.com,tT,,,300) exten => *50,1,Answer exten =>

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Does someone here configured RealTime Extensions using ODBC connecting to Oracle DB? Im having a problem in dialplan patterns, it doesnt work. Pls. help! -Chris __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context |

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context | secret |

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context |

Hi, I am using RT engine to log queue_log to a mysql database. My extconfig is [settings] queue_log => mysql,asterisk16_production Logging to mysql is working fine. But I find that the queue_log file now only has QUEUESTART lines for eg: 1250519094|NONE|NONE|NONE|QUEUESTART| 1250519186|NONE|NONE|NONE|QUEUESTART| How can I have queue_log in both db as well as in a file? thanks and

Hello, Is there a way to either store login/logout agent information in a database or at least send an email when an agent logs in or out of a queue? Thanks, Michael -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110812/84130e1a/attachment.htm>

hi, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote: > i tested this > > # cat /etc/asterisk/extconfig.conf > [settings] > queue_log => sqlite3,cdrDb > > # cat /etc/asterisk/res_config_sqlite3.conf > [cdrDb] > dbfile = /var/lib/asterisk/realtime.sqlite3 > > sqlite3 /var/lib/asterisk/realtime.sqlite3 > > CREATE TABLE

Sorry to post a C compile error on this mailing list but this is Asterisk related. Basically, I was following http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queu e_logging to patch logger.c and Makefile in Asterisk 1.4.* in order to write queue_log to mySQL database. When I ran make, it complained: In function `write_mysql_logger': [...]

What third party programs are available for parsing the queue_log file and CDR file? I know about XC-AST, but management would prefer a php based solution. What have other admins done to retrieve detailed call information about the queue system? Anyone develop their own that they don't mind sharing? --johann