Displaying 6 results from an estimated 6 matches for "pgsql_log".
Did you mean:
pgsql_lib
2009 Oct 14
1
PostgreSQL problems
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: Connection
may...
2009 Jun 28
0
BUG in Asterisk 1.6.1.0 and issue in DAHDI 2.1.0.4
...9;ANSWERED','2009-06-25
12:17:01',170,3,170,'4868',8,'1245950051.272',3,'4','4','1245950051.272')
2009-06-25 12:17:01 COT ERROR: column "src" specified more than once
and asterisk shows:
[Jun 25 12:18:07] ERROR[15544]: cdr_pgsql.c:309 pgsql_log: Failed to
insert call detail record into database!
[Jun 25 12:18:07] ERROR[15544]: cdr_pgsql.c:310 pgsql_log: Reason:
ERROR: column "src" specified more than once
[Jun 25 12:18:07] ERROR[15544]: cdr_pgsql.c:311 pgsql_log: Connection
may have been lost... attempting to reconnect.
[Jun 2...
2004 Aug 09
1
Inbound Call Errors...
...4-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,userfield)
VAL...
2009 Sep 02
1
AMI Originate Commands executed in sequential Order problem
...345h72dc0abbm98575110fdeaf108 at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Thanks alot Barry this was really helpful
Can i know which querry is executed to insert record to database...
i am asking this because of
[Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:309 pgsql_log: Failed to insert
call detail record into database!
[Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:310 pgsql_log: Reason: ERROR:
syntax error at or near ")" at character 17
[Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:311 pgsql_log: Connection may
have been lost... attempting to reconnect.
[...
2004 Jan 06
2
Problems compiling cdr_pgsql
...Andy
[root@ASTERISK cdr]# make
cc -o cdr_pgsql.so cdr_pgsql.o -lpq -lz -L/usr/lib
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../crt1.o: In function `_start':
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../crt1.o(.text+0x18): undefined reference to `main'
cdr_pgsql.o: In function `pgsql_log':
cdr_pgsql.o(.text+0x168): undefined reference to `ast_log'
cdr_pgsql.o(.text+0x192): undefined reference to `ast_log'
cdr_pgsql.o(.text+0x4c1): undefined reference to `ast_log'
cdr_pgsql.o(.text+0x506): undefined reference to `ast_log'
cdr_pgsql.o(.text+0x535): undefined refer...
2004 Dec 17
6
Realtime and PostgreSQL
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