GlucoAware - A web-based system for the monitoring of Type 1 Diabetes, currently under development.

Port Listings - A list of all currently registered TCP/IP network ports.

Developer Pit - Online resources for developers.

The Story of Mel - A "Real Programmer"

 

MySQL & PHP password issue

MySQL 4.1 and above use a hashing algorithm for passwords that is incompatable with
older versions of clients. Clients may fail with the following message;

Client does not support authenticiation protocol requested by the server;
consider upgrading MySQL client.



In PHP, the MySQL extension doesn't support the new algorithm, regardless of the
version of PHP in use. The new algorithm is supported by the MySQLi library.

The other solution is to enter the following command into your MySQL database;

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('newpass');

 

 

Backup and Restore of MySQL database

Backup MySQL in Windows

  mysqldump.exe --add-drop-table -u username -p -h localhost database > "c:\database.backup"

Note that since the command is executed by the service, the run command window will close immediately. However the backup file won't appear for a few minutes, depending on the size of your database and the load on the server.

For backups on a running server the hotbackup tool is more appropriate.

Restore MySQL in UNIX environment

   mysql -h host -u username -p database < database.backup


Both these tasks can be done through phpMyAdmin which can be downloaded from SourceForge. phpMyAdmin is a great tool for administering your databases from a browser.

 

Firefox Pop-ups

Like you, I love Firefox for many reasons, including popup blocking. So over the last few weeks I’ve been surprised to see occasional popups.
It turns out that some clever people figured out that you could launch popups from Flash, getting around the Firefox default settings.

Fortunately, you can get around it:

1. Type about:config into the Firefox location bar.
2. Right-click on the page and select New and then Integer.
3. Name it privacy.popups.disable_from_plugins
4. Set the value to 2.

The possible values are:

* 0: Allow all popups from plugins.
* 1: Allow popups, but limit them to dom.popup_maximum.
* 2: Block popups from plugins.
* 3: Block popups from plugins, even on whitelisted sites.


Firefox Memory Usage Issue

So if you've used Firefox you've probably noticed that it suffers from what can be described as a fairly harsh "memory leak".
The main cause of the problem appears to lie within the plugin for Flash content. There are 2 workarounds that I've located.

The first is rather straightforward and simple but wasn't practical for me. All you have to do is un-install/remove the flash plugin and performance increases significantly.

The other option (and the one I'm using) requires you to make some changes to the Firefox configuration. This is how you fix this "memory leak" problem. (It's not actually a leak, it just doesn't flush the cache it has.)

1)  Type about:config into the location bar and press enter
2)  Right click any line to bring up a sub-menu
3)  Choose "new">"integer"
4)  paste this into the dialogue that appears: browser.cache.memory.capacity
5)  Next click Okay
6)  Specify the amount in kb (about 60000 should do) in the next dialogue that appears.
7)  Restart Firefox and happy surfing.