I was trying to setup cacti on my ubuntu desktop to gather metrics from few new database servers we were planning to replace. Installed cacti using the following command

apt-get install cacti

Then the next step was to download and the install the cacti mysql templates from http://code.google.com/p/mysql-cacti-templates/. Thanks to Baron, was able to get this up and running fast using the templates. But had one problem though, while importing the mysql template “cacti_host_template_x_mysql_server_ht_0.8.6i-sver1.1.7.xml” cacti bombed with the below error

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 41 bytes) in /usr/share/cacti/site/lib/xml.php on line 32

The fix was to edit “/etc/php5/apache2/php.ini” change the parameter “memory_limit” from 16M to 32M and …

So we all know about the good old LAMP stack... Linux, Apache, MySQL, and PHP. It's a beautiful thing. I recently just started early development on a web application and instead of using Tomcat, Struts, Spring, Hibernate, or any of the Java-based frameworks that I am familiar with I've decided to take a step back to my programming past and use PHP with MySQL. Except this time, I'm using a Mac...

Let's start with my setup. I have a MacBook with OS X 10.5 (Leopard) so if you are running anything older this may not apply. Apache 2 and PHP 5 are shipped with 10.5 and I will talk about enabling them later.

The only piece we are missing is MySQL, and lucky us, they now make Mac binaries that you can find at www.mysql.com. Download the binary for the Mac (if you want to build the source get the tar.gz) and do the normal Mac install procedure. Once …