Versions Compared
compared with
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.
Related Articles
Content by Label | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 4.0 International.