Ticket #5788 (closed Bugs: fixed)

Opened 1 year ago

Last modified 1 year ago

CDR reporting fails for CDR entries on remote mysql server

Reported by: diggelen Assigned to: mickecarlsson
Priority: minor Milestone: 2.11
Component: CDR Version: 2.10-branch
Keywords: CDR reports external DB server Cc:
Confirmation: Unreviewed Distro:
Backend Engine: All Distro Ver:
Backend Ver: SVN Revision (if applicable):

Description

Hello,

We are running asterisk/freepbx version 2.10 We are storing the CDR detail records on an external mysql server (on a host within the same IP subnet). This works fine. All CDR records are written to the external database just fine.

However now the "CDR reports" feature within Asterisk/Freepbx should contact the external database for the CDR records, but it does NOT. The "CDR reports" continues pulling the CDR records from the local database (which is empty).

We modified the /etc/asterisk/cdr_mysql.conf, which now looks like this:

hostname = 172.16.32.90 dbname=asteriskcdrdb password = fpbx user = freepbx userfield=1 port=3306

So this works for writing the CDR records to the database, but apparently the "CDR Reports" feature does not use these settings.

We think this is a bug.

Change History

04/24/12 13:38:09 changed by p_lindheimer

  • status changed from new to closed.
  • resolution set to fixed.

(In [13994]) fixes #5788 allow use of remote DB for CDR Reports

04/24/12 13:45:53 changed by p_lindheimer

(In [13995]) Merged revisions 13994 via svnmerge from http://www.freepbx.org/v2/svn/modules/branches/2.11

........

r13994 | p_lindheimer | 2012-04-24 10:38:08 -0700 (Tue, 24 Apr 2012) | 1 line

fixes #5788 allow use of remote DB for CDR Reports

........

04/25/12 12:20:55 changed by p_lindheimer

(In [14017]) make sure install script all uses remote db for any migrations re #5788

04/25/12 12:23:23 changed by p_lindheimer

(In [14018]) Merged revisions 14017 via svnmerge from http://www.freepbx.org/v2/svn/modules/branches/2.10

........

r14017 | p_lindheimer | 2012-04-25 09:20:54 -0700 (Wed, 25 Apr 2012) | 1 line

make sure install script all uses remote db for any migrations re #5788

........

04/25/12 12:36:03 changed by p_lindheimer

(In [14021]) make sure cel data also comes from remote db re #5788, implication being they are both being logged to same db

04/29/12 11:09:59 changed by p_lindheimer

(In [14027]) syntax error in sql statement re #5782 and proper use of cdr db handle re #5788