If you’re a Techie, Geek or just love technology (and let’s face it, if you didn’t you wouldn’t be here reading this), then you know that the Consumer Electronics Show (CES) for 2010 is currently taking place. If you aren’t lucky enough to be able to attend the show (Like me) then you are going to want to keep your face glued in to some of the lastest and greatest announced, like the HP Tablet (I smell a Tablet fight between HP/Microsoft and Apple brewing…… Better bring me some popcorn to this).
The error is due to a bug in a Perl library Munin uses which causes $PATH variable to be lost, and then causes the plugin cannot find the mysqladmin program which it needs to retrieve the numbers to populate in the graphs. Uninstall and reinstall Munin Service Monitor may make it works again, however, a more permanent solution is to hardcode the path of the program, which will fix the problem. Here the guide on how to specify the path to mysqladmin to Munin.
Fix for Munin installed by cPanel/WHM
1. Determine where is mysqladmin program located with the one of the following command:
which mysqladmin
type mysqladmin
locate mysqladmin
If should return a path to mysqladmin which looks similar or the same to /usr/bin/mysqladmin.
2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file, and modify the [mysql*] to look like below:
[mysql*]
user root
group wheel
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts –defaults-extra-file=/root/.my.cnf Read the rest of this entry…
Phpmyadmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. Since Windows doesn’t include a GUI managment tool for Mysql, you will need to install phpMyadmin to acess a GUI rather than administratering Mysql via the command line interface.
Please be sure that your php installation already has the GD/GD2 Library, Mysql and MBString extensions active. You can see this by going to your IIS server and accessing the php test page. If you do not have one, you can make one by going to “C:\inetpub\wwwroot\ and my creating a text with the following line;
<? phpinfo(); ?>
Save the file as phptest.php.
This will allow you to goto Http://localhost/phptest.php. If you don’t see the Mysql or MBstring sections, you will need to have them enabled to proceed as phpMyadmin requires this. Read the rest of this entry…
I just want to take a minutes to wish everyone who uses this tech blog, a Happy and Safe Holiday! Enjoy those tech gadgets and I’ll see you all next year…. GOGO 2010!
Nothing more than a “make sure you do this”, not really a knowledge base. It’s come to my attention that when people make changes to the httpd.conf on a server that is running Cpanel, that they don’t update the distiller file. So when they recompile apache, they lose any changes they made. Please be sure when you manually update httpd.conf that you save the changes to the distiller file by running the following;
/usr/local/cpanel/bin/apache_conf_distiller --update --main
*make sure if you copy and paste the command that it doesn’t replace the “-” with a “.”
Make sure that you modify the proper files when making the changes. For example to modify the number of servers that the Apache process can run, you will need to modify /usr/local/apache/conf/extra/httpd-mpm.conf .
If you need to modify the Time out settings, yo will need to modify the/usr/local/apache/conf/extra/httpd-default.conf.
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 150
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off
It will confirm that the changes were saved and this will save the changes to the main distiller config, saving them for all apache compiles.
You can test this by running the following to reload the httpd.conf and confirm the change;
