CDR Table - Which Database

1

For FreePBX 14 SNG7, what database is the CDR table stored in? As I understand it we have SQLite, MySQL and MariaDB.

Thanks for your help!

2

SQLite is Asterisk’s internal Database Engine. Its a key value store. You can see it by running asterisk -rx ‘database show’
MySQL is the database engine FreePBX uses in 13.0
MariaDB (A fork of MySQL) is the database engine FreePBX uses in 14.0

The database you are looking for is called asteriskcdrdb

2 Likes
3

Thanks Andrew. Does anyone know if MariaDB is compatible with MySQL Workbench, or if there is a similar interface program for MariaDB? We would like to take the UsrField from the CDR and join it to an independent table we’ve created, for reporting.

4

If you tried to connect yourself you would have seen that it would have worked just fine. The answer is yes. it works just fine.

3 Likes
5

Thanks Andrew.

6

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