-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 15
-
Fix Version/s: 15
-
Component/s: CDR Reports
-
Labels:None
-
ToDo:
-
Asterisk Version:16.1.1
FreePBX 15.0.2.10
CDR Reports 15.0.5
FreePBX*CLI> cdr set debug on
0x74200aa0 - Created CDR for channel PJSIP/12-00000001
0x74200aa0 - Transitioning CDR for PJSIP/12-00000001 from state NONE to Single
0x74200aa0 - Set answered time to 1546287856.524993
0x74200aa0 - Beginning finalize/dispatch for PJSIP/12-00000001
0x74200aa0 - Dispatching CDR for Party A PJSIP/12-00000001, Party B <none>
FreePBX*CLI> cdr set debug off
CDR debugging disabled
FreePBX*CLI> cdr show status
Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No
- Registered Backends
-------------------
Adaptive ODBC
root@FreePBX:~# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.1.37-MariaDB-0+deb9u1 Raspbian 9.0
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
--------------------
| Database |
--------------------
| asterisk |
| asteriskcdrdb |
| information_schema |
| mysql |
| performance_schema |
--------------------
5 rows in set (0.01 sec)
MariaDB [(none)]> use asteriskcdrdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [asteriskcdrdb]> show tables;
-------------------------
| Tables_in_asteriskcdrdb |
-------------------------
| cdr |
-------------------------
1 row in set (0.00 sec)
MariaDB [asteriskcdrdb]> describe cdr;
----------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
----------------------------------------------------------+
| calldate | datetime | NO | MUL | 1000-01-01 00:00:00 | |
| clid | varchar(80) | NO | |||
| src | varchar(80) | NO | |||
| dst | varchar(80) | NO | MUL | ||
| dcontext | varchar(80) | NO | |||
| channel | varchar(80) | NO | |||
| dstchannel | varchar(80) | NO | |||
| lastapp | varchar(80) | NO | |||
| lastdata | varchar(80) | NO | |||
| duration | int(11) | NO | 0 | ||
| billsec | int(11) | NO | 0 | ||
| disposition | varchar(45) | NO | |||
| amaflags | int(11) | NO | 0 | ||
| accountcode | varchar(20) | NO | MUL | ||
| uniqueid | varchar(32) | NO | MUL | ||
| userfield | varchar(255) | NO | |||
| did | varchar(50) | NO | MUL | ||
| recordingfile | varchar(255) | NO | MUL | ||
| cnum | varchar(80) | NO | |||
| cnam | varchar(80) | NO | |||
| outbound_cnum | varchar(80) | NO | |||
| outbound_cnam | varchar(80) | NO | |||
| dst_cnam | varchar(80) | NO | |||
| linkedid | varchar(32) | NO | |||
| peeraccount | varchar(80) | NO | |||
| sequence | int(11) | NO | 0 |
----------------------------------------------------------+
26 rows in set (0.01 sec)
MariaDB [asteriskcdrdb]> select * from cdr;
Empty set (0.01 sec)
