similar to: Problems with Asterisk 1.6.2.1 working in Realtime with PostgreSQL

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

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,

I am using asterisk 1.6.1.6 and have been setting up a system to use a Postgresql database as the realtime DB via the ODBC route. I have got extensions and voicemail working but am having trouble with SIP The problem seems to be with using a schema. If I put the table "sip" in the schema "foo" then I add this entry to extconfig.conf sippeers => odbc,psqldb,foo.sip Restart

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:

I would like to access a Postgresql database directly from my dialplan (to lookup names based on callerid numbers for incoming calls). Based on everywhere I looked - it seems the only way to do this is with func_odbc. Considering that Asterisk seems to be able to access Postgresql databases directly using res_pgsql for the purposes of realtime functionality (without using odbc - if I

As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Is there any down side to PostgreSQL over mySQL or will it be a big win? Our database servers are linux but we access them

Hi All, I am trying to configure asterisk realtime. But i am unable to get the extensions listed successfully when i type "sip show peers" in the asterisk CLI . i am unable to see any failure logs when i do a reload i can able to connect to the data source through "odbc show" in the CLI, Any hep in this regard is highly appreciated. Following is the configuration

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

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

I'm currently running a setup that's worked great with MySQL in the past, but we're migrating to ODBC for when we actually integrate the system into our current legacy/voip network. The database I'm trying to use is PostgreSQL, and I've got it working great for Realtime, and if I use cdr_pgsql for the cdr records. However, if I try to use cdr_odbc against the same

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

i have installed the asterisk 1.6 before that installed the necessary packages in Debian, * i followed the steps as follows, root at astserver: ~# apt-get install unixodbc unixodbc-dev odbc-postgresql postgresql-8.1 postgresql-contrib postgresql-dev * then i installed the asterisk 1.6 version with the odbc modules as in the selected list. * then i created the database as asterisk and the user

hi,all when i upgrade from 1.4.28 to 1.6.2.1, i can't connect to mysql database anymore, error as follow: [Jan 25 15:38:25] WARNING[3003]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: asterisk (check res_mysql.conf) the content of res_mysql.conf is: http://www.pastebin.org/81966 i've try command " mysql -uroot -proot" ,i can connect to

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

The Asterisk Development Team has announced the release of Asterisk 1.6.2.1. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk/ The release of Asterisk 1.6.2.1 resolved several issues reported by the community, and would have not been possible without your participation. Thank you! * CLI 'queue show' formatting fix. (Closes issue

The Asterisk Development Team has announced the release of Asterisk 1.6.2.1. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk/ The release of Asterisk 1.6.2.1 resolved several issues reported by the community, and would have not been possible without your participation. Thank you! * CLI 'queue show' formatting fix. (Closes issue

Hello, I wonder if anybody is using PJSIP realtime in production environment? I've started to play with it and encountered many problems. Here's my config: sorcery.conf: [res_pjsip] endpoint=realtime,ps_endpoints extconfig.conf: [settings] ps_endpoints => pgsql,users,pjsip_endpoints_v pjsip_endpoints_v is postgresql view. 1. The biggest problem: if I have small number of endpoints

The Asterisk Development Team has announced releases of Asterisk-Addons version 1.4.11, 1.6.0.5, 1.6.1.3, and 1.6.2.1. These releases are available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk/ These releases resolve several issues reported by the community: * Fix reading samples from format_mp3 after ast_seekstream/ast_tellstream. (Closes issue #15224.

The Asterisk Development Team has announced releases of Asterisk-Addons version 1.4.11, 1.6.0.5, 1.6.1.3, and 1.6.2.1. These releases are available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk/ These releases resolve several issues reported by the community: * Fix reading samples from format_mp3 after ast_seekstream/ast_tellstream. (Closes issue #15224.

Hello, I'm experimenting with Asterisk and MySQL. Up to know I've just put iax.conf in a MySQL database and it seems to work: when a Iax2 client registers the corrispondent row in db is updated. Good. However when I have many asterisk boxes pointing to the same db a problem arises: I need an additional column in iax_buddies table called for example "Asterisk ID" which tells me on