similar to: Asterisk with 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 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, 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 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

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

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

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

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?

On 02/17/2016 07:08 AM, Michael H wrote: > On 17/02/16 13:01, Johnny Hughes wrote: >> I normally just let the daily announce post to this list show what >> is available for updates, but there is a CVE (CVE-2015-7547) that >> needs a bit more attention which will be on today's announce list >> of updates. >> >> We released a new glibc yesterday for

On 02/17/2016 08:10 AM, Michael H wrote: >> The easy answer is yes .. glibc requires so many things to be restarted, >> that is the best bet. Or certainly the easiest. >> >> Note: in CentOS 7, there is also a kernel update which is rated as >> Important .. so you should boot to that anyway: >>

Hi, I have Fedora Core 2 running with a T1 card. I try to put the log on db but I get the error: Aug 20 15:17:47 ERROR[262160]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database exists and I try with "mysqlaccess localhost asteriskcdrdb" and I get: Access-rights for USER 'localhost', from HOST

I am getting this error when reload my asterisk "cdr_addon_mysql.c:264 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf" I don't have res_mysql.conf in /etc/asterisk/. I have res_odbc.conf which is attached Res_odbc.conf ============== ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes