Reset MySQL password on Ubuntu in about 1 second*
* It may take a little longer depending on your server and finger speeds!
dpkg-reconfigure mysql-server-5.0
System Monitoring on Ubuntu in 30 seconds
Installing munin has to be the fastest and simplest way of installing a visual system monitor on Linux.
Website Blurb:
Munin the monitoring tool surveys all your computers and remembers what it saw. It presents all the information in graphs through a web interface. Its emphasis is on plug and play capabilities. After completing a installation a high number of monitoring plugins will be playing with no more effort.
Yahoo GeoLocation API
The Yahoo Maps API is the best API I've found for using on in internal site. Google won't let me access theirs from a non-public site.
MySQL Tuning Server Parameters
These are some of the handy MySQL 5.0 tweaks I do to get the most out a MySQL database;
I adjust the following to suit my server, I try to give MySQL as much resource as possible.
Ubuntu sources.list Generatror
I had a problem with some slow Ubuntu sources today, instead of changing the whole sources.list manually, I stumbled over Ubuntu Nederland's Source-O-Matic.
Slam in the country you want and it generates you a nice new file. Saves at least 30 seconds!
imagegrabwindow() and imagegrabscreen()
I stumbled over these two new functions in the PHP CVS today. They are only available in Windows as they use COM, but interesting non the least.
Nicer Pagination with ADOdb
Or should that be Nicr? To follow in an annoying theme.
Olavo Alexandrino wrote a nice well rounded class for record set pagination in ADOdb. If you've ever used ADOdb's version, you will know it is not very good, to say the least.
Although Olavo did a fantastic job on the logic, the presentation left a little to be desired from my perspective.
I am providing my modifed version for download below, it provides a few logic updates and better presentation.
Idiot Proof Lightbox
I've just made some modifications to my Gallery code which is part of i9000's small site CMS software.
It adds some client side logic to make sure the images Lightbox 2 creates fit the users screen perfectly. Previous to this some customers were complaining that the images they uploaded were too big for their visitor's screen.
This allows us to present the largest possible image to the user without scrolling around the page.
