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

[Asterisk Team (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-26170?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=231277#comment-231277 ] 

Asterisk Team commented on ASTERISK-26170:
------------------------------------------

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

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