Apache And MySQL Monitoring With Bijk On Debian Lenny - Page 2

Want to support HowtoForge? Become a subscriber!
 
Submitted by zdenek (Contact Author) (Forums) on Fri, 2010-06-25 15:26. ::

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:


Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.