[asterisk-bugs] [JIRA] (ASTERISK-26170) Problem with CDR using ODBC PSQL

[Celso Annes (JIRA)]

Celso Annes created ASTERISK-26170:
--------------------------------------

             Summary: Problem with CDR using ODBC PSQL
                 Key: ASTERISK-26170
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26170
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: CDR/cdr_odbc
            Reporter: Celso Annes
            Severity: Minor


Hi,
I am getting the follow error when I hang up a call.
{noformat}
[Jul  1 16:07:59] WARNING[26140]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2016-07-01 16:07:56'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )
[Jul  1 16:07:59] ERROR[26140]: cdr_odbc.c:189 odbc_log: CDR direct execute failed
{noformat}

I am using *cdr_odbc.conf* and I have used the *contrib/realtime/postgresql/postgresql_cdr.sql* to create the table.

To solve the problem I had to add the following cell:
{noformat}
calldate timestamp with time zone NOT NULL DEFAULT now()
{noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)