search for: res_pgsql

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

We are using PostgreSQL real-time connector (res_config_pgsql) with Asterisk 1.6.2.15. From time to time, we need to reset our PostgreSQL server, causing all active DB connections to close. While other packages in our system re-connect gracefully when this happens, Asterisk appears to not bother trying. It instead goes into an endless loop complaining that the connection has closed. Question --

...y now and then, on the head office machine, ODBC CEL and CDR logging will stop working. On examination in the CLI, Asterisk behaves as if the config files for ODBC in the /etc directory are just gone. Repeated tests have then proved that the config files (/etc/asterisk/res_odbc.conf, /etc/asterisk/res_pgsql.conf, etc.) ARE in /etc/asterisk folder and are readable and have the correct contents, and are NOT gone. On the branch machine, where we do not use ODBC but FreeTDS to log CDRs to an MSSQL DB, TDS stops working randomly as well, with the cdr_tds.so module refusing to load with a message (I forget...

...e 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 understand correctly) - is there some other generic SQL dialplan function which would allow access to the Postgresql database from the dialplan without configuring ODBC and the rest? Or does anybody know of a simpler way sti...

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

...ephony/asterisk/ The release of Asterisk 1.4.37 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following is a sample of the issues resolved in this release: * Fix issue with decoding ^-escaped characters in realtime (res_pgsql) (Closes issue #17790. Reported denzs. Patched by Qwell) * Don't send a devstate change on poke_noanswer if the state did not change. (Closes issue #17741. Reported, patched by schmidts) * Transmit silence when reading DTMF in ast_readstring. Otherwise you could get issues wit...

...lephony/asterisk/ The release of Asterisk 1.4.37 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following is a sample of the issues resolved in this release: * Fix issue with decoding ^-escaped characters in realtime (res_pgsql) (Closes issue #17790. Reported denzs. Patched by Qwell) * Don't send a devstate change on poke_noanswer if the state did not change. (Closes issue #17741. Reported, patched by schmidts) * Transmit silence when reading DTMF in ast_readstring. Otherwise you could get issues with DTMF...

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 of other db server> d...

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 comes with ABSOLUTELY NO WARRANTY;...

Hi list, After wrestling with the voicemail system for a while (Asterisk 1.4.14, Debian etch), I got it to work, but I still have lots of questions, like: * Why can't I delete any voicemail messages? (Response: "Message undeleted.") * Why can't I listen to the messages in the Old folder? * Why can't I use the advanced options? (Response: