On Sun October 19 2003 15:26, Florian Overkamp wrote:
> Hi,
>
> I'm seeing oddness with CDR logging to PSQL. It seems whenver a call is
> coming in through CAPI it cannot be logged properly:
> -- CAPI Hangingupr_pgsql.c, Line 127 (pgsql_log): cdr_pgsql: Failed to
> insert call detail record into database.
>
> Calls made from the internal phones toward CAPI are logged properly.
Use the attached patch for now.
Can someone please advise what the maximum lengths for the fields should be.
--
Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
Index: postgres_cdr.sql
===================================================================
RCS file: /usr/cvsroot/asterisk/postgres_cdr.sql,v
retrieving revision 1.1
diff -u -r1.1 postgres_cdr.sql
--- postgres_cdr.sql 13 Oct 2003 18:18:15 -0000 1.1
+++ postgres_cdr.sql 28 Oct 2003 14:28:42 -0000
@@ -18,8 +18,8 @@
src VARCHAR(45) NOT NULL default '',
dst VARCHAR(45) NOT NULL default '',
dcontext VARCHAR(45) NOT NULL default '',
- channel VARCHAR(45) NOT NULL default '',
- dstchannel VARCHAR(45) NOT NULL default '',
+ channel VARCHAR(100) NOT NULL default '',
+ dstchannel VARCHAR(100) NOT NULL default '',
lastapp VARCHAR(45) NOT NULL default '',
lastdata VARCHAR(45) NOT NULL default '',
duration INTEGER NOT NULL default '0',