similar to: Asterisk reltime mode with Postgresql

I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different. http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example Files included with the distribution:

Database on a remote machine res_pgsql.conf: [general] dbhost=172.16.0.2 dbport=5432 dbname=ast_config dbuser=pbx dbpass= dbsock=5432 [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Host: 172.16.0.2 [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Port: 5432 [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime User: pbx [Nov 28

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

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off? Thanks Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others. Created by Mark Spencer <markster at digium.com> Asterisk

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

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 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 '',

I have this code which was taken from the phpagi project page along with the following in extensions_conf and the output from the asterisk CLI. When I call the 311 extension, I does nothing then hangs up. What am I doing wrong?? ----php code------------ #!/usr/local/bin/php -q <?php set_time_limit(30); require('phpagi.php'); $agi = new AGI(); $agi->answer(); $cid =

Hi everybody, I have a Fedora Core 4 x86 32 bit install, which I recently upgraded from asterisk 1.2 to the office 1.4.4 tarball. In the process of doing that I had to upgrade some autoconf/automake stuff, but it worked fine, and my new asterisk works fine. Except that anytime I receive a fax with spandsp and app_rxfax, asterisk seg faults. I have applied the spandsp

Hello asterisk-users, We've been having intermittent issues with chan_sip - it stops responding to cli requests, trying to reload chan_sip from cli doesn't seem to have any effect, initiated calls carry on for a short period, but no new SIP requests are processed ('sip show channels' hangs forever, server stops responding to SIP OPTIONS, or any other SIP messages). We have updated

Hi, I am a beginner who began to use Asterisk in this July. Last week, I made two addons for PostgreSQL (cdr_addon_postgresql.c and res_config_postgresql.c), because I use not usual MySQL but PostgreSQL. # Of course, not scratch build but modified version 1.4.8. But I don't know how to change configure script, menuselect-xxx, ... etc, and how to merge my sources to addons tar-balls. Anyone

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

Dear The Expert, I am very new with this, I have installed AsteriskNow, X-Lite as my SoftPhone, I am using SPA-3102. I have 3 extensions, me at 250, 998 is my Linksys SPA-3102 and 999 for PSTN Line (see below) My problem is, I am unable to call 998, I thought this is registration problem, (because the Linksys screen info said Registration Failed) Could any body please help? Many thanks in

Hi, Anybody seen this before? (using a pre-compiled asterisk from the OBS on a sles11sp1) (I mean, i did the same with a 1.6 without any problem, but i need 1.8) after starting: kc3004:~ # /usr/sbin/safe_asterisk: line 145: 16133 Segmentation fault (core dumped) nice -n $PRIORITY ${ASTSBINDIR}/asterisk -f ${CLIARGS} ${ASTARGS} > /dev/${TTY} 2>&1 < /dev/${TTY} Asterisk ended with

Hello, I am using asterisk realtime with a postgresql database on the same server. In res_pgsql.conf I have specified [general] dbhost=localhost dbport=5432 dbname=asteriskdb dbuser=psql dbsock=/tmp/.s.PGSQL.5432 Since both asterisk and db are on same server, I would like asterisk to connect to db using the local unix socket. However asterisk is not using the local unix socket to connect to

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

Hello, How do I use multiple postgresql databases using res_config_pgsql? I tried creating multiple contexts in res_pgsql.conf, but asterisk is only using the 'general' context. My res_pgsq.conf is [general] ;; Connect to mydb on localhost dbport=5432 dbname=mydb dbuser=pgdbuser requirements=warn [pgwritedb] ;; Connect to mydb2 on another host dbhost=<IP