Paulds
November 20, 2022, 12:30am
1
I want to use the Grafana MYSQL datasource connector to view more
custom statisticvs and graphs.
This only has to be for the CDR/CEL data.
How can I get this data?
I have tried connecting via mysql and using the username and passwork in the /etc/asterisk files but that didn’t let me in.
Is there a another way i can access the data in semi-real time. So within 30 minutes would be ideal?
Thanks
I suspect this is a FreePBX question, not an Asterisk one. With raw Asterisk, you provide the database, so you really should know how to access it.
If it is a FreePBX question, you want https://community.freepbx.org/
Paulds
November 20, 2022, 7:03pm
3
Ahh I thought CDR/CEL was an Aserisk thing.
Thanks.
They are Asterisk, but getting them somewhere depends on configuration, etc. For example, the sample configuration file for Asterisk puts CDRs in a flat file
;
; CHOOSING A CDR "BACKEND" (what kind of output to generate)
;
; To choose a backend, you have to make sure either the right category is
; defined in this file, or that the appropriate config file exists, and has the
; proper definitions in it. If there are any problems, usually, the entry will
; silently ignored, and you get no output.
;
; Also, please note that you can generate CDR records in as many formats as you
; wish. If you configure 5 different CDR formats, then each event will be logged
; in 5 different places! In the example config files, all formats are commented
; out except for the cdr-csv format.
;
; Here are all the possible back ends:
;
; csv, custom, manager, odbc, pgsql, radius, sqlite, tds
; (please note, also, that other backends can be created, by creating
; a new backend module in the source cdr/ directory!)
;
; Some of the modules required to provide these backends will not build or install
; unless some dependency requirements are met. Examples of this are pgsql, odbc,
and I think it still throws out CEL completely.
; be recorded to various backend modules.
;
[general]
; CEL Activation
;
; Use the 'enable' keyword to turn CEL on or off.
;
; Accepted values: yes and no
; Default value: no
;enable=yes
; Application Tracking
;
; Use the 'apps' keyword to specify the list of applications for which you want
; to receive CEL events. This is a comma separated list of Asterisk dialplan
; applications, such as Dial, Queue, and Park.
;
; Accepted values: A comma separated list of Asterisk dialplan applications
Enabling them to a database, and providing access to that database, is something that FreePBX does.
system
Closed
December 20, 2022, 7:19pm
5
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.