Thursday, December 23, 2010

Catching Emails w/ Gmail's Multiple Inboxes

The Problem
I've got 2-4 different sources I need to keep a very close eye on.  They all come in through email so it's just a matter of organizing them well.  Here's my criteria:
  1. If there's an important email I don't want to miss it.
  2. I don't want to have to check multiple accounts to stay on top of things.
  3. I don't want to have email from different sources mixed in with my personal email.
The Solution 
A combination of email forwarding and a gmail tool called 'multiple inboxes.'  You can see below that items from Stardust and Business Travel Connect show up in their own little blocks, and not in my inbox.


However, once I've read messages in those inboxes (or marked them as read) they slide out of the way and into little messages that tell me everything is cool.



How-To

Step 1: If all the emails are being sent to the same address, go to the next step.  Otherwise set up your other email accounts (outlook, yahoo, etc) to forward to your gmail account.  This is probably preferable to redirecting email so that you always have the originals somewhere else.

Step 2: Configure your gmail filters to automatically A) apply a label and B) archive them.

Step 3: Add google lab's multiple inbox to your account.

Step 4: Configure the multiple inboxes under gmail's settings tab.   The only important option is your 'search query.'  Type in "is:[your-label-name] is:unread".



Now when you go back to your inbox all messages that are both unread and have the labels you selected will show up in their new inboxes.  Once you've read them they will disappear from the inbox.  Or if you have a copy in another email account you can just delete them.  Good luck!

~ Micah

Thursday, December 9, 2010

Avoiding MySQL 4.1+ Old Authentication Error

What I Wanted
  • connect to mysql
I have a functioning site and working database running remotely on a LAMP system.  I just want to get it going locally using a WAMP system.

PROBLEM:
When I try to run the site on localhost I get
Warning: mysql_connect(): OK packet 6 bytes shorter than expected in C:\wamp\www\conn\connection.php on line 2 
Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\wamp\www\conn\connection.php on line 2 
Could not Connectmysqlnd cannot connect to MySQL 4.1+ using old authentication  

SOLUTION:
Lots of people ran into this same problem, but very few posts were any help.  I followed this guy's hints.  My wamp installation was using PHP 3.0 but my server where the code was working fine used PHP 5.2.6.  I'd like to know why this is a problem, but not badly enough to spend my time on it.  Do this:
  1. Figure out what the functioning version of PHP is Create a phpinfo page, put it where you can see it, check the version and then delete it:
    <?php phpinfo(); ?>

  2. Download that version of WAMP
    Go here to do it.  Just pick the correct version & click to download.

  3. Install itShutdown WAMP if you have it running and then double click - it's self installing.

  4. Restart WAMP and select your version of PHPSelecting the php version is as simple as clicking on the tray icon, going to the PHP directory, going to the 'version' directory and picking your version.  When you click on it WAMP will restart using that executable.
     
  5. Check it in the browser
    God I hoped that worked...