similar to: Problem with asterisk and postgresql

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:

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

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:

Hi Hekuran I have installed asterisk-1.0-RC2.tar.gz, asterisk-prepaid-0.3.1 and postgresql. When I tried to call from any IAX client to another IAX client and also sip client to sip client it worked fine. And also the cdr table filled properly. Now I tried to configure asterisk-prepaid-0.3.1 with asterisk. I have compiled asterisk-prepaid-0.3.1 and also copy the configure file. I

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

Hi Every one and Lerale Erwan I have briefly describe my problem and I have provide the steps as follows: I have intalled redhat properly and from the konsole I checked with mysql. "rpm -qa | grep mysql" and the konsole provide me the message: mysql-3.23.54a-11 mysql-server-3.23.54a-11 Then I have download the asterisk and addons: By the using of : cd /usr/src export

Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Thanks!

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

Hello all I already install and able 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

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 All, I have an equipment loaded with 4 X100P (numbered 1-4)) and one T400P (numbered 5-8). Everything works fine except that I cannot use one of the FXS ports (number 5). If I configure zapata.conf to recognize it, the whole system voice quality suffers. I've tried already to switch PCI slots, with no results. Below is a snapshot of my /proc/interrupts, maybe this can shed some light on

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-users/attachments/20071201/a3aecc1d/attachment.htm

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

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

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

I tried to add the databases from the localhost to the database server and changed the every /etc/asterisk/*.conf from host=localhost to host=192.168.10.10 (my dababase server) When I restart asterisk, I do not get any errors, but after a phone call I see: Jun 7 18:11:56 ERROR[7877]: cdr_addon_mysql.c:400 my_load_module: Failed to connect to mysql database cdr on 192.168.10.10 Or if I try

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

Hi all, I am running Fedora Core 5 on an Intel Server board with 2GB memory and kernel 2.6.18-1.2798.fc6 . I am running asterisk-1.2.10 from bristuff-0.3.0-PRE-1s. I have a mysql-version of app_prepaid which builds properly but when I run asterisk -gc I get the following: [root@myserver /]# asterisk -gc Asterisk 1.2.10-BRIstuffed-0.3.0-PRE-1s, Copyright (C) 1999 - 2006 Digium, Inc. and others.

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?