similar to: cdr_pgsql error in 1.4.15

Hi folks, I am struggling to install cdr_pgsql in asterisk 1.6.0.26. When I do the ./configure, it complains about the function PQescapeStringConn not existing in -lpq, so when I do a make menuconfig, I can't select the cdr_pgsql module. I am using CentOS 5.4 with the yum PGDG repository for 8.4 version. Some of the installed packages are postgresql-libs, compat-postgresql-libs,

I've just upgrade to the latest head (20843) and I get the following error .Apr 17 08:41:07 WARNING[8527]: loader.c:726 __load_resource: new style cdr_pgsql.so (0x0) loaded RTLD_LOCAL Apr 17 08:41:07 WARNING[8527]: loader.c:744 __load_resource: Key routine returned NULL in module /usr/lib/asterisk/modules/cdr_pgsql.so Apr 17 08:41:07 WARNING[8527]: loader.c:753 __load_resource: 5 errors

Hi, Having installed postgresql-devel-7.4-0.3 and postgresql-libs-7.4-0.3 I'm having probs. compiling cdr_pgsql, can anyone offer any pointers as to what I might be missing? I'm hoping I've just missed out something like postgresql-wibblewobble-7.4-0.3 or something ... Below is the result of a make in the cdr source dir which may help those of you in the know thanks... Andy

Hello Everybody, I am trying to configure Asterisk to listen into a database which is created in PostgreSQL. Whenever asterisk starts up, it is unable to connect to the pg database and gives the following error: [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found Jun 24 21:20:53 DEBUG[1074494336]: cdr_pgsql.c:284 my_load_module: cdr_pgsql:

Asterisk Project Security Advisory - AST-2007-026 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in cdr_pgsql |

Asterisk Project Security Advisory - AST-2007-026 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in cdr_pgsql |

Hi to all!! Here's my problem: [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:298 my_load_module: cdr_pgsql: Unable to connect to database server localhost. Calls will not be logged! May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:299 my_load_module: cdr_pgsql: Reason: could not connect to server:

Folks, I know this must be a configuration problem. Just changed servers last nite -- an interim server running 1.6.1.6. Copied all of /etc/asterisk to the new server and fired it up. Now I'm getting: [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:309 pgsql_log: Failed to insert call detail record into database! [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:310 pgsql_log: Reason: ERROR: syntax

Hi Every one and Fabio Donaggio Fabio Donaggio you have faced same type of problem with postgresql with asterisk. Did you solved your problem. Please help me. The problem is as follows: When i reload the asterisk I had got this error "== Parsing '/etc/asterisk/cdr_pgsql.conf': Found Aug 23 14:22:33 ERROR[1076245120]: cdr_pgsql.c:299 my_load_module: cdr_pgsql: Unable to connect

Hi, I am trying to install asterisk-1.2.34 but facing following issue. I have gone through it and found that there are files in /usr/lib libpq.a libpq.so libpq.so.4 libpq.so.4.1 make[1]: Entering directory `/usr/src/asterisk-1.2.34/cdr' gcc -shared -Xlinker -x -o cdr_pgsql.so cdr_pgsql.o -lpq -lz -L/usr/lib/pgsql /usr/bin/ld: skipping incompatible /usr/lib/libpq.so when

I have searched all over the web and have not really found anything related to this error.... The only thing I found is related to a system stops responding on DTMF, which does not happen here... THe following is the output from the CLI: *CLI> 2004-08-09 17:36:29 DEBUG[229390]: chan_sip.c:2332 sip_alloc: Allocating new SIP call for 640E2D47-E98B11D8-8FDBE54A-5FB5A0CB@65.67.76.30

Hi, I'm testing Asterisk 1.4.15 with the -g option. When it crash didn?t generate core file in the /tmp folder. What is happening?? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20071130/dc693449/attachment.htm

Hi list! I'm having some problems with chan_sccp and a Kirk IP600. Basically the handsets work (they emulate a Cisco 7940) but I have the following issues: 1. If a handset is in a conversation and there is a new incoming call, the incoming audio is muted (but the other party can still hear anything spoken on the handset). What is normal Asterisk behaviour, that a handset is left alone

I tested POP3 access from my laptop's Outlook which is on the same subnet as the dovecot/postfix server (so there's no firewall in between them & was able to get the emails in Outlook with following statuses shown when "Test Connection" is clicked: > Tasks Status > ===================== ========

Hi List, Yesterday night after a power off due to a faulty UPS my asterisk doesn't want to start anymore. Here is what I get on the CLI: Asterisk Ready. *CLI> Disconnected from Asterisk server: Bad file descriptor. Executing last minute cleanups == Destroying musiconhold processes Asterisk uncleanly ending (0). I use 1.2.7 I think on a debian sarge and cdr_pgsql too. Any ideas?

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 i am upgrading an asterisk server from 1.2.4 to 1.4. i've installed libpri 1.4 i've installed zaptel 1.4 I've installed the new version of misdn with the script of beronet. i use this configure script: ./configure --with-postgres=/usr/local/pgsql then: make menuselect [*] 1. cdr_csv [*] 2. cdr_custom [*] 3. cdr_manager XXX 4. cdr_odbc [*] 5. cdr_pgsql XXX 6. cdr_radius

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

Is there any way to do this? Thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120307/77764e4b/attachment.htm>

Starting playing with asterisk 1.6.1.0 i found the following problems: In the cdr_pgsql, the sql statement is wrong: 2009-06-25 12:17:01 COT LOG: statement: INSERT INTO cdr