Apache And MySQL Monitoring With Bijk On Debian Lenny - Page 2
On this page
- 7.5 - Restart your Apache server with this command:
- 7.5.1 - Edit file:
- 7.5.2 - Add/change the following node (**other** and **default** are simply instance names):
- 7.5.3 - Restart Bijk-node:
- 7.5.4
- 8.1
- 8.2 - Restart the Bijk-node deamon:
- 8.3 - Run the mysql console with root permissions (or with permissions to create new user)
- 8.4 - Create a new 'bijk' user without database permissions and access only from the localhost:
- 8.5 - To verify this user access, you can issue the following command from localhost shell:
- 8.6 - Your MySQL graphs will be online in Bijk within 30 minutes of changing these settings.
7.5 - Restart your Apache server with this command:
/etc/init.d/apache2 restart
You need to have the module **mod_status.c** installed.
This module is included with Apache2 in Debian by default.
You can **check** your previous changes with:
links http://127.0.0.1/server-status?auto
lynx http://127.0.0.1/server-status?auto
If your Apache2 does not listen to the localhost IP on a standard port (127.0.0.1:80 or 0.0.0.0:80 - you can check with command
netstat -tlpn | grep apache
), you will have to do the following:
7.5.1 - Edit file:
nano /etc/bijk/plugins.yml
7.5.2 - Add/change the following node (**other** and **default** are simply instance names):
apache:
default: http://YOUR_IP:YOUR_PORT/server-status?auto
other: http://OTHER_IP:OTHER_PORT/server-status?auto
7.5.3 - Restart Bijk-node:
/etc/init.d/bijk-node restart
7.5.4
Add the primary IP address of your server to the "<Location /server-status>" section of your Apache configuration file and restart the Apache server.
Step 8 - Configure MySQL graphs
8.1
In the file /etc/bijk/plugins.yml, under the 'mysql' node, set the variable 'user' to 'bijk' and the variable 'pass' to your required password (the default is just an instance name):
mysql:
default:
user: bijk
pass: s3cr3t
8.2 - Restart the Bijk-node deamon:
/etc/init.d/bijk-node restart
8.3 - Run the mysql console with root permissions (or with permissions to create new user)
mysql
8.4 - Create a new 'bijk' user without database permissions and access only from the localhost:
CREATE USER 'bijk'@'localhost' IDENTIFIED BY '{random_password}';
FLUSH PRIVILEGES;
8.5 - To verify this user access, you can issue the following command from localhost shell:
mysql -u bijk -p{random_password}
(There is no space between -p and {random_password}.)
8.6 - Your MySQL graphs will be online in Bijk within 30 minutes of changing these settings.
That's it. Bijk will create all your performance graphs like CPU, load and traffic. Here's a screenshot of Bijk in action:
