Ubuntu
asterisk package

Asterisk 1.8.10 from repository cannot write CDR using cdr_pgsql module

Asked by uri b

When precompiled Asterisk 1.8.10.1~dfsg-1ubuntu1 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
https://issues.asterisk.org/jira/browse/ASTERISK-19216

Thanks,
Uri

Question information

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

Is there not a PPA?

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

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 : 		#3

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 1.8.10.1~dfsg-1ubuntu1 on 12.04LTS ).

https://cloud.tntraffic.com/links/3qDKTLrRAiZ

User Discretion is advised :)

HTH,
Uri