Connect Google Docs to a MySQL Server

Needed some quick and dirty reports from a MySQL Server based website to a User that used Google docs.

Found this
https://developers.google.com/apps-script/guides/jdbc#reading_from_a_database

Open a Google spreadsheet click Tools->Script Manager create a new script and paste. Change host, instance (Schema), user and password and put some SQL in and you are done Googles end. Then you need to enable your server to let in Googles servers. There may be a more secure way than this using netmasks but this worked for me.

Create users with ip ranges of Googles servers to keep out the nasties.



When you run foo it copies data into the root of the spreadsheet.

Moving from Outlook XP (2000) to Outlook 2010

Recently I installed Office2010 H&B (which includes Outlook) on a laptop that had been running Outlook2000Pro happliy for many years (are you listening MS?).

Dutifully I copied the folders where the PSTs reside - just in case.
I aslo exported iaf files for the two Email Accounts, and I made a copy of the wab.

All went well, I just needed the Email account password but everything else seemed to come across fine.
I just Opened an Outlook data file - rather than tried any tricky replacement of the new file it created. this way I could be sure any converting would happen a t that point.
Then old emails could be copied or moved over to the new clean uncluttered Inboxes.

So all went smoothly, you ask?

Not entirely, the Calendar was not copied across and no way could the old version of Outlook be loaded to open it.

Perhaps an export of the data or sync to some online service first may have been wise.
But the lease I should have done was PRINT off the next few weeks. Luckily there were only a handful of entries. But all the history was gone.

Live and learn.

IE10 breaks RWW

Guess what? A recent update of IE from 9 to 10 stops Remote Web Workplace from working!
One solution is to click the compatibility mode button and thus lets you connect.
However, my rww opened with scroll bars bottom and right - so I assumed it was not a 100% fix.

(I had forgotten to run IE at 100% zoom - as any other zoom will cause the remote page to load with scroll bars - even when set to Full Screen).

So I UNinstalled the IE10 update (Hint: Use the Search box on the Installed Updates to quickly find the "Internet Explorer 10" update.)
Voila.
Here's a picture of the cause and the effect ;)

Oh, and you may need to HIDE the IE10 update form Windows Updates or else it will rise like a Phoenix to haunt you!

(This screenshot shows the AutoUpdate of IE10 and later Unticked..but it was ticked by defaulkt when I first encountered it)

Google Apps Sync supports only Outlook 2003 or greater

Take that.
Upgrade your client/s to 2003 from 2000 or 97 first...?

Reissue a certificate on SBS2008

Every few years the self-issued certificate that allows remote access to the remote web workplace expires, and needs to be reissued.
Here is an illustrated guide of the steps which I completed successfully:

From the SBS console, there were errors reported - followed my nose till I got this;







Ignore the configure modem - you do not want to be changing this
(I should have unticked all but the certificate - but there's only one way to find out!)


Nothing went wrong.

Check the date and time to make sure they are the fresh ones.

Your next challenge is to get them to the client PCs. RDP direct to the server and copy the file if you can. Zip the folder, rename it as a .txt and attache to a gmail? Or get out your sneakers and usb thumbdrive :)

Ah - I remember know how I started the process:
(See also the useful url on the screenshot)
And if adding a third party (purchased) certificate then I suppose you would use the link above the one highlighted?

Steps to get RWW working

The first time you run a RWW site that needs the Activex you should get prompted



Then you right click the yellow area to accept the diag



Then you'll get the login, BUT NOTE THE RED CERTIFICATE ERROR in all the above screens so far!



This means you need to run the InstallCertificate app from the folder where the certificate is that you issued from your SBS2008 server and copied to the local PC:



(Note - you may have needed to reissue the certificate on the server - see this post )

Now you can finally connect to the local PC including mapping local printers and clipboard. Note the address bar is no longer red..

Job done. :D

iExpert?

Ok. So I am the iExpert?
Scenario 1
Neighbours kids come to me for help on their new iPod to redeem a $20 voucher. The catch: kid is twelve and has no email yet and no credit/debit card. Oh, and its Saturday afternoon when I should be mowing or watching America's Cup!
Payment: 1 bottle of cheap red.

Scenario 2
iMac, iPad, iPhone, setup with 7 (yes seven) email accounts from 4 different providers must all be visible on all devices including the sent, trash and drafts, oh, and must work overseas, oh, and a new assistant must be able to use one of the accounts.
Payment: $60 hourly rate

Scenario 3
Retired gentleman is tired of his old Windows7 stuff, but likes his new iPad and iPhone, so gets me to help him order the latest greatest iMac and AppleTV. Now "just" have to it all up so he can "do" stuff like photos, music and so on.
Payment: $60 hourly rate


Which would you prefer.. And how would you go about it?

Lessons
1
An AppleId is required, and user must be 13 years old (so amend accordingly the first time you try, or it will fail when you try again!)
A credit card is NOT required. However to get past this step during the AppleID sign up, you MUST do it on the iPod by selecting a free app to install from the App Store. (The option is missing if try from iTunes on iPod or on the computer) horror

2
Patience, perseverance, perspicacity. Get a new gmail account. Use this as the main coalescing point, and use the Chrome interface exclusively. No more trouble. Oh, and never change passwords again ;)

3
Read up on what AppleTV can do ahead of the job. Oh, and use all your cunning obtained from past experience mixed with enthusiasm for the product, hubris for the wonderful outcomes.