arnaudcoquelet / fusionpbx

Automatically exported from code.google.com/p/fusionpbx
0 stars 0 forks source link

No CDR for incoming calls after update to the latest version #903

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

Debian scripted install with psql.
Everything was working fine until I used apt-get to update FusionPBX on Feb 23d
No incoming calls were logged since then.
After restart now incoming calls are logged but I have error message on CDR 
page for every incoming call:
SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique 
constraint "v_xml_cdr_pkey" DETAIL: Key (uuid)=(random uuid) already exists.

What version of the product are you using? On what operating system?
FreeSWITCH (Version 1.4.17 -2 64bit)
Debian 3.2.65
Fusion PBX 3.7.1

Please provide any additional information below.

Original issue reported on code.google.com by Sergey.M...@gmail.com on 4 Apr 2015 at 9:46

GoogleCodeExporter commented 9 years ago
Incoming calls are logged only if I set log on disk:
<param name="log-http-and-disk" value="true"/>
But this produces SQL error.

Original comment by Sergey.M...@gmail.com on 4 Apr 2015 at 10:05

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Its a bug in FreeSWITCH as they are trying to put unescaped data into the XML 
CDR via HTTP POST. Strangely enough if you configure XML CDR to save to the 
file system and not to do an HTTP POST then it works. In that case you would 
schedule v_xml_cdr_import.php  to run with PHP from the command line.

What version of FreeSWITCH are you using?  Advanced -> Command -> Switch 
command -> version.

Original comment by markjcrane@gmail.com on 6 Apr 2015 at 1:56

GoogleCodeExporter commented 9 years ago
FreeSWITCH Version 1.4.17-2~64bit (-2 64bit)

I don't remember updating switch with apt-get, only FusionPBX files.

Original comment by Sergey.M...@gmail.com on 6 Apr 2015 at 2:30