Applies to VoipNow 3 and higher! |
To execute queries on the MySQL database, you must access the command line MySQL client.
Step-by-step guide
STEP 1: Log in to your VoipNow server as root via SSH using your favorite console (e.g. Putty).
STEP 2: Execute the following command.
cat /etc/voipnow/.sqldb |
The output will provide a single line like the one below.
main:<DB_USER>:<DB_PASS> |
STEP 3: Run the next command.
mysql -u<DB_USER> -p<DB_PASSWD> voipnow |
Note that you may equally run this command:
mysql -u`cat /etc/voipnow/.sqldb| awk -F':' '{print $2}'` -p`cat /etc/voipnow/.sqldb| awk -F':' '{print $3}'` -h `cat /etc/voipnow/sqldbase.conf | grep DB_MASTER | awk -F':' '{print $2}'` voipnow |
STEP 4: Use the values obtained for the <DB_USER> and <DB_PASSWD> parameters.
STEP 5: Now you will be connected to your MySQL server and you will be able to run queries in the database.