Skip to main content

Posts

Showing posts from June, 2007

America could do Better

USA, the land of opportunity & freedom, they say, is going through a changing phase. While Germans obsess about catching up with America, here's a few things America could do better:

http://news.zdnet.com/2100-9588_22-6192744.html?part=rss&tag=feed&subj=zdnn

phpMyAdmin - Database Passwords Stop Working

Very reluctantly, I had to install phpMyAdmin (PMA) 2.10.2 (beta) on my Debian production server. Before I booed for doing this, let me just note that it was out of sheer compulsion that I had to do this.

Anyways, I noticed that CLI scripts from SellerBay stopped being able to connect to confero24.com's OSC database, incessantly throwing this error:
sb09@ottawa:~$ ./app/scripts/OSC/osc2sb_orders.pl 1 -real
[Sat Jun 16 18:01:53 2007] osc2sb_orders.pl: DBI connect('host=localhost;database=confero_2007_01',' confero',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /home/sb09/app/lib/Markets/OSC/OSCDB.pm line 33It turns out that PMA's database libraries use a different password encryption algorithm than those used by the Perl installation SellerBay uses. I'm not yet sure why at all the passwords were re-saved after the PMA installation, as I didn't d…

.htaccess Redirect for SEO

Search Engines like to see a website's keywords embedded into the URL. So if I'm selling energy saving washing machines, most SE's, I am told, (Google included) like to see a URL that looks like:
www.energy-saving-washing-machines.comBut if you don't have access to that fancy domain name, then the next best chance is to use something like:
www.whatever-domain-name-you-have.com/energy-saving-washing-machinesThis can be setup using a .htaccess file in the document root directory of the www.whatever-domain-name-you-have.com website. Simply create a .htaccess file and drop in the redirection directive as follows:
Redirect /energy-saving-washing-machines "http://www.whatever-domain-name-you-have.com"So anybody clicking on http://www.whatever-domain-name-you-have.com/energy-saving-washing-machines will be redirected to http://www.whatever-domain-name-you-have.com/

No need to restart/reload Apache

For any such redirections to start working, Apache doesn't need to b…