Direct Access to the VoIP Detective Database

VoIP Detective runs off of a MariaDB database, which accepts the same commands as MySQL.  Through the command line menu, you can create a user that can directly access the call database.  You will be able to view all CDR and CMR data contained in VoIP Detective.

This feature is available in VoIP Detective version 1.904 and greater.

To enable database access, log into your command line interface

Choose the option to configure Linux OS services

Choose the option to configure MariaDB

Finally, choose the option to enable remote database access.

You'll be prompted to create a user and password.  Once that is complete, you can remotely access the database.

Sample connection string

mysql -u your_username -p -h remote_host_ip_or_hostname -P remote_port

Replace the following placeholders with your actual information:

your_username: Your MySQL username
remote_host_ip_or_hostname: The IP address or hostname of the remote server
remote_port: The port on which MySQL is running on the remote server - 3306

Removing access to the Database

Should you wish to disable remote access to your database, simply choose that option from the command line interface.  This will not remove the user that has been created, however it will close the firewall port 3306.