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.