Asterisk 1.8.10 from repository cannot write CDR using cdr_pgsql module

Asked by uri b

When precompiled Asterisk on 12.04LTS is attempting to write CDR to PostgreSQL 9.1 server With PostgreSQL 8.3 it does not issue that message (change is query checks I assume)

Asterisk console prints out:
[Jan 15 15:37:53] ERROR[23295]: cdr_pgsql.c:320 pgsql_log: Reason: ERROR: column "calldate" specified more than once
LINE 1: ...","disposition","amaflags","uniqueid","userfield","calldate"...
consistent with this Asterisk bug fixed in Feb 2012


Question information

English Edit question
Ubuntu asterisk Edit question
No assignee Edit question
Solved by:
uri b
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said :

Is there not a PPA?

Revision history for this message
uri b (urib) said :

You mean Asterisk Repo on PPA?
First, nothing from what I found is newer then 1.8.7.
Second, The Digium repo does not support "Percise".
and Last, Why should I opt for a third party package when I have what I need on the official repo?
It's a bug, and it was fixed in a lower version then the one in the repo, which makes things very confusing.

Revision history for this message
uri b (urib) said :

I've "Fixed" the problem by recompiling the cdr_pgsql module using the current asterisk source.
I've attached a link containing the source and the compiled module (for Asterisk on 12.04LTS ).

User Discretion is advised :)