Installing Pentaho BI

For a customer proof of concept, I needed to create a Pentaho VM.

1. Installed Sun JDK and JRE and dos2unix.
$ sudo apt-get install tofrodos
$ sudo apt-get install sun-java6-jdk sun-java6-jre

2. Updated profile for pentaho user

$ vi ~/.bashrc
inserted:
JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_HOME

3. Created directory tree for Pentaho

$ cd /opt
$ sudo mkdir pentaho
$ sudo chown pentaho:pentaho pentaho -R
$ cd pentaho

7. From http://sourceforge.net/projects/pentaho/files/ downloaded latest versions of:
Report Designer
BI Server
Data Integration
Metadata
Extracted the files into the pentaho directory

8. Set Publisher password
$ cd /opt/pentaho
$ vi biserver-ce/pentaho-solutions/system/publisher_config.xml

9. Convert console.xml into UNIX file type.
$ dos2unix administration-console/resource/config/console.xml

11. Set up admin console

$ vi administration-console/resource/config/console.xml

./../biserver-ce/pentaho-solutions

./../biserver-ce/tomcat/webapps/pentaho

12. Edited the log4j.xml so the log file would appear in the home directory

13. Set the hostname directly and added ip address for client machines in web.xml

$sudo vi /opt/pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/web.xml

from:

http://localhost:8080/pentaho/

to:

http://xxx.xxx.x.xxx:8080/pentaho/

added ip addresses for client machines for administration to the trusted ip list.

Some of these instructions come from here and here




How I decided on Drupal

When deciding on which CMS to use, I used the following criteria:

1. Drupal is based on PHP, mysql and CSS - three technologies I'm which are already familiar with.

2. www.whitehouse.gov recently chose Drupal. I'm going to assume that means that their experts believe that Drupal is secure and scaleable. I know this is lazy thinking; it could also mean that it will take a team of hundreds to keep Drupal secure and scaleable, but I'll test that out!

3. The Drupal ecosystem is so active that even the themes and modules have variations and plugins.

4. The Drupal sites I looked up look both attractive - and somewhat similar to each other. This suggests to me that the developers are able to get a lot out of the basics.

5. Adding my own applications to Drupal looks reasonably easy.

Setting up a Drupal Development Environment

My development environment runs in a Ubuntu 8.04LTS running in a VM. I followed these instructions which worked very well.

I'm migrating my database to InnoDB: I guess that means I'm running Oracle

I'm migrating a few tables to start with - I'm hoping I don't take too much of a hit to performance. I just really want those proper foreign key definitions.

An hour with Windows 7 RC reminds me why I don't miss Windows

I've been Windows free for the past 6 months or so - and really, I don't think I miss it.

I grabbed a copy of Windows 7 RC candidate just to have a look at it running in Virtualbox and see if I can maybe use it to easily stream to my Xbox360.

I boot it up again and I get a message on my desktop saying that my copy of Windows is not genuine. This could mean one of two things. Either someone snuck into my house, deleted the copy of Windows I downloaded and installed into Virtualbox, and reinstalled a "Non Genuine" copy, or Microsoft is subtly twisting the meaning of Genuine.

Not wanting to feel like a criminal, I click on the message. Nothing happens, its not clickable. I cudgel my head for a few seconds but can't really think of where I can go in WIndows to make it connect to the mothership and validate or whatever I need to do to make my Windows "genuine".

While I'm hunting around for the validation option, I notice a little flag waving from the toolbar. It says I have important tasks - such as searching the internet for an antivirus package and running a backup. Fair enough. But why should I need to search the internet for virus software? Haven't they heard of package managers?

So I do the search. It displays a bunch of logos. Several of them I don't recognise, and some of them remind me of paying $99 a year for something that doesn't improve my life. I remember that AVG offers a decent free anti-virus software, so I click on the AVG logo.

AVG offers me two options (working from memory here). One is Expensive and the other is More Expensive. Dang it, I'm sure that they had a free option. Oh well. I enter "Windows 7 Free Antivirus" into Bing and I get a link to AVG. This time, I get three options! Free, Expensive and More Expensive. I guess they think that people coming from Microsoft's page are more in the mood to spend money.

Several mouse clicks later, I've downloaded and installed AVG. At no time was I prompted for any kind of Root password. I thought this thing was supposed to be more secure!

AVG wants me to install make Yahoo search my default. I have no idea why this would benefit me, but I guess Yahoo is paying AVG for the begging space. No thanks, I'd rather have a few more pixels for looking at websites than some irritating toolbar. Especially since Yahoo is now powered by Bing and Bing is already the Windows 7 default search engine.

AVG has installed a desktop shortcut for itself. Thanks for nothing. But easily deleted.

But then I go back into IE, and AVG has installed a toolbar anyway! And it includes Yahoo search! Now I have two seach boxes and a toolbar with a bunch of links I don't need. And the toolbar has no close button. To get rid of it, I need to go into Advanced Settings, ask it to be moved above the tabs and only then do I get a close button. Sigh.

No sooner have I run AVG, I get another warning on my toolbar. Now Windows Defender wants to scan my PC. Now that I have AVG, do I need to run Windows Defender? Or did I not really need AVG in the first place. Who knows? I don't have time to research this.

But luckily this takes me a few minutes to figure out. Because during those minutes, Windows has gotten really upset about not being Genuine and has faded my desktop to an ominous black. Its telling me I need to Activate NOW and its offering me a box to type my activation key into. Along with some useless messages about finding the key on some sticker. I get a key from the Release Candidate website, enter it, and my windows copy is now a "Genuine" "Evaluation Copy". Sweet.

Some requests for the next version of Windows:
- a package manager which allows me to install and update all kinds of commonly used software with a unified interface
- a default security model which requires an admin password too be entered when I'm installing new software
- a new culture of not pestering users with addons that aren't going to benefit them

And AVG - please be more respectful of your users. I don't mind being pestered to buy the More Expensive version, but don't hide the Free one from me just because you paid Microsoft for a link to their Windows 7 Antivirus page!

And now that I've wasted an hour or so figuring this out, I've run out of time to figure out the Xbox streaming. Back to real work!

File Uploads in PHP

Once I got PHP working on my Dev server, still another hurdle - file upload wouldn't work because PHP wasn't handling the file upload temp directory (which is set in php.ini). To fix this, I added www-data, the user that PHP runs under, to the right group for the temp directory.

Mounting a shared drive in Virtualbox

I wanted to share a directory from my main machine so I could import Second Life logs into my VM development environment. (I could try SL ona VM, but I'm guessing I need all the performance I can get!).

Two things to remember:

1. Apparently mount doesn't like you naming the share the same as the mountpoint. This was causing mounting failed with the error: Protocol error.
2. Because you need to run the mount as sudo, the mounted directory is owned by root. I used -o uid=mwgjordan,gid=mwgjordan to get around this.