Mysql usage inside freepbx


I am writing as follow-up of a previous post which result in this command:

mysql -sb  asteriskcdrdb -e 'SELECT * FROM cdr  WHERE calldate >= NOW() - INTERVAL 10 MINUTE'|tr '\t' ',' 

My company IT man is facing some issues generating this file. He is not sure about where the asteriskcdrdb is located and if would we need user and password -u USER -p PASSWORD. Can someone help us?

The FreePBX mysql creds are in the file /etc/freepbx.conf. By default, that user is limited to localhost, so you prob want to create a new user and grant privs as needed.

1 Like

Thanks, and what about the path of the database?