How to install Infobright on Ubuntu

Recently, I have to investigate an opensource data warehousing software and my first choice is Infobright (http://www.infobright.org/).

The installation process is pretty simple except one error:

/usr/bin/strings: ‘/lib/libc.so.6’ : No such file

This can be solved easily by creating a symlink to the location of the file

1. Locate the file

locate libc.so.6

2. Create a symbolic link

# ln -s /path/to/libc.so.6 /lib/libc.so.6

Then you need to have MySql (if you haven’t had one)

> sudo apt-get install mysql-server

Installation process

1. Download the deb file from infobright website: http://www.infobright.org/

2. Make sure you are root

> su –

3. Navigate to a directory, ie /usr/local

# cd /usr/local

4. Install infobright

# dpkg -i /path/to/file.deb

5. Make sure that infobright is working properly.

More information about infobright can be found at http://www.infobright.org/wiki/

Recover Reset MySql Root Password

It has been a few weeks since I last touched the server and I couldn’t remember the root password for MySql. I’m lucky enough to find the following website, which tells me how to get around it.

http://blog.taragana.com/index.php/archive/how-to-recover-mysql-root-password/

The whole idea is very clever, all we need to do is to stop MySql process and start it without the permission mode. Then we can choose to reset the password and restart the MySql again.

$ sudo /etc/init.d/mysql stop

$ sudo mysqld_safe –skip-grant-tables &

$ mysql -u root

Now that we are in …

> use mysql

> UPDATE user SET password = PASSWORD(‘NEW-PASSWORD’) WHERE user = ‘root’;

> flush privileges;

> quit

Then re can restart the MySql and try to login with the new password.

$ sudo /etc/init.d/mysql restart

# mysql -u root -p

Free up spaces on Ubuntu machine

This is a follow up post after upgrading the ubuntu on my eeepc. I found that I only have a few hundred megabytes left on my netbook. The space can be checked by running a command: df

Of course, I’m a nerd. I love using Terminal — nah not really. It’s just that from time to time I always find myself struggling with finding the buttons that I want. So, I perfer using the commandline way of doing things.

Ok, let’s go back to our topic of freeing up some spaces. Firstly, I cleaned apt cache by running this command:

sudo apt-get autoclean

But, that’s not really enough so I did:

sudo rm -rf /var/cache/apt/archives/*.deb

This line is used to remove the unnecessary files that we don’t need after installation.

Then I removed everything from /tmp because I believe that it’s under /tmp, which mean temporary. I should be able to remove it without any problem. (Please don’t trust me entirely lol)

sudo rm -rf /tmp/*

Then I removed a few applications that I have never used to save a few hundred megabytes, such as, thunderbird, evolution, games and so on. Most applications can be removed by:

sudo apt-get autoremove APPLICATION NAME

For example, sudo apt-get autoremove evolution.

At the end I’m pretty happy with the result and nothing has crashed yet, which is great. Please feel free to try it and let me know how happy you are when getting a few hundreds MBs back.

Upgrading Ubuntu on EEEPC

I have an old EEEPC running ubuntu 8.10. I spent a lot of time seeking for a method to perform in order to upgrade it to the current version of ubuntu, which is 9.10. The only problem that I found is I don’t have enough space to perform an upgrade. After spending a few hours researching, here is a list of steps that I’ve done:

1. Download ubuntu alternate iso images for 9.04 and 9.10
2. Find a thumbdrive, something like 1GB will work just fine
3. Copy the image to the thumbdrive, start with 9.04
4. Plug it into a netbook, in my case it’s a 4GB eeepc
5. Open a Terminal. If you can’t find it, it’s under Applications > Accessories > Terminal
6. Type:

sudo mount /path/to/file.iso /cdrom -o loop

In my case, it was: sudo mount /media/UNTITLED/ubuntu9-4.iso /cdrom -o loop
(If you noticed my laziness on the thumb drive name, it’s a yes, I don’t bother renaming my thumb drive after formatting)
7. Perform an upgrade with a little trick by running this command

sudo /cdrom/cdromupgrade

8. Follow the usual upgrade steps

9. Remove the “cdrom” from apt sources.list

sudo vi /etc/apt/sources.list

10. Repeat [3] for ubuntu 9.10

Ok, there is the explanation of what it does:
Since there is not enough space on my netbook, I decided to perform and upgrade based on CD. However, this funky netbook does not have a CD rom or DVD and I don’t want to spend a few bucks on an external DVD. Therefore, I mount the usb image as an actual CD rom on the system. Yes, it’s pretty neat 🙂 Then I go to my “virtual CD rom” and perform an upgrade.

Enabling dock on Ubuntu

Dock can be enabled on Ubuntu by installing gnome-do

sudo apt-get gnome-do

More information about Gnome-do can be accessed from – http://do.davebsd.com/wiki/index.php?title=Docky

How to install Piwik Statistics System

Today I’m going to write about how to install Piwik Statistics System. This is an opensource web analytic, an alternative to Google analytic. A website for Piwik is http://piwik.org/

Firstly, I downloaded the zip file from the above website and unziped it.

Then I checked if my server has PDO installed by looking at php info. This can be done by creating an empty page with this code:

<?php

phpinfo();

?>

Another requirement is the GD image library. To enable this, open a terminal and type:

sudo apt-get install php5-gd

Then:

sudo /etc/init.d/apache restart

The next requirement is to have a memory of 128M. This can be done by editing the php.ini file under /etc/php5/apache2

sudo vi /etc/php5/apache2/php.init

Change memory limit to:

memory_limit = 128M

and restart the server with:

sudo /etc/apache2 restart

Copied piwik folder to the webserver directory.

Once that’s done, I went to http://localhost/piwik/ and followed the install instruction.

If it asked for chmod, it could mean that apache cannot write to this directory. There are 2 solutions to this problem.

1. To perform a change mode to 777, which allows everyone to be able to read, write and execute to that folder (possibly including subfolders.) !!!This is NOT recommended!!!

sudo chmod -R 777 /var/www/piwik

2. To change the owner of the folder to apache user. A default apache user is www-data. This is a lot better solution:

sudo chown -R www-data:www-data /var/www/piwik

Installing The Fascinator on Ubuntu 9.04

Today I attempted to install the Fascinator on Ubuntu 9.04.

The Fascinator is a software platform for eResearch. Development started in 2008 as an attempt to create a clean and usable Institutional Repository user interface.

from: http://fascinator.usq.edu.au/

I first get the documentation from: http://fascinator.usq.edu.au/documentation/installation/Easy_Install_The_Fascinator.htm#id6

To install,

1. I download the installer.sh file from the server.

2. Then I made it executable by running chmod a+x install.sh

3. Run the installer: sudo ./install.sh

4. The installer will ask for install directory, passwords, and proxy.

Then I leave it running, while getting a coffee 🙂

When I came back, I have the fascinator running. It’s so good!