search for: cdr_pgsql

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 [root@ASTERISK cdr...

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: got hostname of localhost Jun 24 21:20:53 DEBUG[1074494336]: cdr_pgsql.c:285 my_load_module: cdr_pgsql: got port of 5432 Jun 24...

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

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 loading module /usr/lib/asterisk/modules/cdr_pgsql.so, aborted A...

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 error at or near ")" LINE 1: INSERT INTO cdr ) VALUES ) ^ [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:311 pgsql_log:...

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 to database server localhost. Calls will not be logged! Aug 23 14:22:33 ERROR[1076245120]: cdr_pgsql.c:300 my_load_module: cdr_pgsql: Reason: could not connect to server: Connection...

In Asterisk 1.4.15 if I try to configure cdr_pgsql.conf , asterisk crash with this message asterisk: symbol lookup error: /usr/lib/asterisk/modules/cdr_pgsql.so: undefined symbol: PQescapeStringConn Is this a knowed error? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-us...

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

....so] => (Microsoft WAV format (8000hz Signed Linear)) == Registered file format wav, extension(s) wav [app_cut.so] => (Cuts up variables) == Registered application 'Cut' [app_softhangup.so] => (Hangs up the requested channel) == Registered application 'SoftHangup' [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found [app_dial.so] => (Dialing Application) == Registered application 'Dial' [pbx_spool.so] => (Outgoing Spool Support) [app_directory.so] => (Extension Directory) == Registered applicat...

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 ("accountcode","calldate","src","clid","dst","src","dcontext","dst","clid","dcontext","channel","...

...AST-2007-026 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in cdr_pgsql | |----------------------+-------------------------------------------------| | Nature of Advisory | SQL Injection | |----------------------+-------------------------------------------------| | Susceptibility | Remote Authenticated...

...AST-2007-026 +------------------------------------------------------------------------+ | Product | Asterisk | |----------------------+-------------------------------------------------| | Summary | SQL Injection issue in cdr_pgsql | |----------------------+-------------------------------------------------| | Nature of Advisory | SQL Injection | |----------------------+-------------------------------------------------| | Susceptibility | Remote Authenticated...

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 searching for -lpq /usr/bin/ld: skipping incompatible /usr/lib/libpq.a when searching for -lpq /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[1]: *** [cdr_pgsql.so] Error 1 m...

Hi Please help to store datas of call history into the pgsql. When I have run ./asterisk -vvvvc then I have faced "== Parsing '/etc/asterisk/cdr_pgsql.conf': Found Aug 23 16:11:38 ERROR[1076245120]: cdr_pgsql.c:299 my_load_module: cdr_pgsql: Unable to connect to database server localhost. Calls will not be logged! Aug 23 16:11:38 ERROR[1076245120]: cdr_pgsql.c:300 my_load_module: cdr_pgsql: Reason: could not connect to server: Connection...

...814e4f0' 2004-08-09 17:36:29 DEBUG[245775]: pbx.c:1255 pbx_extension_helper: Launching 'Congestion' 2004-08-09 17:36:29 DEBUG[245775]: pbx.c:1947 ast_pbx_run: Spawn extension (bogon-calls,h,1) exited non-zero on 'SIP/65.67.76.30-0814e4f0' 2004-08-09 17:36:29 DEBUG[245775]: cdr_pgsql.c:100 pgsql_log: cdr_pgsql: inserting a CDR record. 2004-08-09 17:36:29 DEBUG[245775]: cdr_pgsql.c:103 pgsql_log: cdr_pgsql: SQL command executed: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura tion,billsec,disposition,amaflags,accountcode,uniqueid,...

...sterisk 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? Cheers, Jean-Michel. -- Jean-Michel Hiver - http://ykoz.net/ D?couvrez la R?union des Technologies IP & Telecom TEL: +262 (0)262 55 03 98 - RCS 434 273 330 SAINT PIERRE

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

...ndset even when it is in conversation (I guess that is what is happening now). 2. Asterisk seems to crash at random, sometimes after an hour sometimes after two days. It just exits with a Segfault: I did a trace on asterisk and this is the result: Reading symbols from /usr/lib/asterisk/modules/cdr_pgsql.so...done. Loaded symbols for /usr/lib/asterisk/modules/cdr_pgsql.so Reading symbols from /usr/lib64/libpq.so.3...done. Loaded symbols for /usr/lib64/libpq.so.3 Reading symbols from /lib64/libcrypt.so.1...done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/libnsl.so.1...done....

...to use Asterisk as voicemail. But after Asterisk is ready, we found lot of following warning(WARNING 5126). Is there any solusion of stopping this warning. Please help me. [Warning} | | | WARNING[1024]: File cdr_pgsql.c, Line 194 (my_load_module): Unable to load config for PostgreSQL CDR's: cdr_pgsql.conf == Parsing '/etc/asterisk/enum.conf': Found Asterisk Ready. *CLI> WARNING[5126]: File chan_sip.c, Line 462 (retrans_pkt): Maximum retries exceeded on call 496d26fd7255f1b767391c16291a0a1f@192.1...

Hi, I've just built asterisk on a RedHat 7.2 box from the current cvs which I have built a standalone Asterisk on before. It appears to compile OK but when I attempt to start the daemon I'm seeing the following error messages: [cdr_csv.so] => (Comma Separated Values CDR Backend) [cdr_pgsql.so]WARNING[1024]: File loader.c, Line 239 (ast_load_resource): /usr/kerberos/lib/libk5crypto.so` : shared object not open WARNING[1024]: File loader.c, Line 407 (load_modules): Loading module cdr_pgsql.so failed! There is no Digium hardware in the box and the lib5crypto.so file is in the...