Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated using 4PSA automated script


Note

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.

Code Block
cat /etc/voipnow/.sqldb

The output will provide a single line like the one below.

Code Block
main:<DB_USER>:<DB_PASS>


STEP 3:
Run the next command.

Code Block
mysql -u<DB_USER> -p<DB_PASSWD> voipnow

Note that you may equally run this command:
Code Block
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.

Content by Label
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("database","mysql","queries","server") and space = currentSpace()
labelskb-how-to-article

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 4.0 International.