Freepbx CDR is blank after i link asteriskcdrdb to external server

FreePBX Applications / Modules
1

hi there
I’m using freepbx 12

i followed http://wiki.freepbx.org/display/FPG/Remote+CDR
to host asteriskcdrdb on external server and its fine

but when i go to freepbx cdr i see blank reports

is there a way to tell freepbx cdr to point records from remote mysql server ?

cheers

1 Like
2

Add CDR MySQL details to Settings, Advanced Settings.

http://wiki.freepbx.org/pages/viewpage.action?pageId=66256961

3

already did that and it worked on remote DB

my question is why the cdr is blank now ?

4

any help ?

5

have you logged onto mysql on the remote db and checked the records are getting written.

also check httpd logs to see if that shows any hints

6

Make sure the remote database allows the asteriskcdrdb user has write permissions to the database based on the host address (or from the “%” host).

7

yes the notifications are being sent to the remote DB and logged in the CDR table

the problem is only from the GUI CDR reports , its not viewing the remote DB items

no errors in httpd access log or mysql log

cheers

1 Like
8

the db has full permission to the user

9

Im not sure that the remote DB settings in Freepbx do more than set teh DB to be written to a remote location , not sure and not looked to see if tehy change the GUI location

Ian

10

Is there anythink new to this topic? Iam at the exact same problem. All permissions are set correctly and FreePBX is logging the cdrs into the external database. But when it comes to the cdr-report in the FreePBX-GUI - the report is just blank.

Any ideas?

Philipp

11

You are probably better off just adding a new cdr 'backend ’ to the cdr setup ( not possible from the GUI)

http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/database_storing-cdr.html

That way there can be no arguing about who gets ehat

12

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.