Install postgres, pgadmin in Ubuntu 12.04

Installing postgres database to Ubuntu 12.04 run

1. sudo apt-get install postgresql
2. sudo apt-get install postgresql-contrib
3. sudo apt-get install pgadmin3

There is nice article what you can to do further in postgres database.

To allow connection to postgres database from host computer these steps are necessary:

1. In VirtualBox NAT Advanced settings add port forwarding 5432 -> 65432
2. In guest start sudo vim /etc/postgresql/9.1/main/pg_hba.conf and add these lines
   host    all    all             192.168.0.0/16          md5
   host    all    all             10.0.0.0/8              md5
3. sudo vim /etc/postgresql/9.1/main/postgresql.conf
   listen_addresses = '*'
4. sudo -u postgres psql and execute
   create user vagrant with password 'vagrant';
   create database pentaho;
   GRANT ALL PRIVILEGES ON DATABASE pentaho to vagrant;
   alter user vagrant with superuser;
   \c pentaho
   CREATE SCHEMA repo;
   CREATE SCHEMA target;
   
5. In host pgadmin III create new connection
   Name: local
   Host: localhost
   Port: 65432
   Maintenance DB: pentaho
   Username: vagrant
   Password: vagrant

Add shared folder in VirtualBox

In Win7 host, Ubuntu 12.04 guest I tried to add Shared folder, but there are some simple tricks to know.

1. Add shared folder in VirtualBox (Settings -> Shared Folder -> Machine Folders)
2. Make sure that the additions are installed, and that you have added your username as a member of the vboxsf group (sudo usermod -aG vboxsf <your username>).
3. After restart shared folder  /media/sf_shared should be in place

How to install manually guest additions in linux
$ sudo apt-get install build-essential module-assistant linux-headers-$(uname -r) dkms -y
$ wget -c http://download.virtualbox.org/virtualbox/4.0.16/VBoxGuestAdditions_4.0.16.iso
$ sudo mount VBoxGuestAdditions_4.0.16.iso -o loop /mnt

Install Oracle Java 7 to Ubuntu 12.04

Easiest way to do it is to run in terminal

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

Nice thing is that it keeps java version up-to-date. There is longer explanation with different alternatives in Ubuntu site.

Optional: add to .bashrc
export JAVA_HOME=/usr/lib/jvm/java-7-oracle

Install Ubuntu Desktop in Virtualbox

My idea was to use Vagrant to install and start Ubuntu Desktop. First step is to downloaded Vagrant and then start command line and move into new empty directory.  Next step is to download Ubuntu server

vagrant box add ubuntu64-13.04 http://cloud-images.ubuntu.com/vagrant/saucy/current/saucy-server-
cloudimg-amd64-vagrant-disk1.box

and start it

vagrant init ubuntu64-13.04
vagrant it


ssh into new server and install graphical user interface


vagrant ssh
sudo apt-get install ubuntu-desktop

allow graphical user interface in configuration file Vagrant


config.vm.provider :virtualbox do |vb|
  vb.gui = true
  vb.customize ["modifyvm", :id, "--memory", "1024"]
end

restart the system


vagrant reload

Actually it came out that Ubuntu Desktop graphics is really slooow, so I give up and started install Ubuntu Desktop without Vargant from scratch. Lesson that I learned today: dont use hammer when you have screws. Vargant is not meant to use with graphical desktop.

 

How to check that site is down.

I had problem with Zulutrade website and I try to figure out is problem in my pc/office network or is server actually down. I found simple service http://www.isitdownrightnow.com, where everybody who has problems can report.
Nice service and it works!

Installing ODI 11.1.1.7.0 on Windows 7 64bit

It sould be easy to install any software nowadays, but it is not. Specially painful is installation of packages from big companies, because these are huge packages with lot of dependencies.

My last challenge was to install Oracle ODI Studio on my laptop and it was real problem to even start the installer. After some investigation I find this article from google, that solve my problem.

Some important points that I discovered:

1. Win7 64bit jre and oracle installer are working together (despite some posts that claim otherwise)
2. Command order to start Oracle ODI installer
   run cmd.exe as Administrator (It does not work without it, despite installer asks Administrator password)
   setup.exe -jreLoc C:\Progra~1\Java\jdk1.7.0_29

Honestly I am disappointed that this information is not provided in Oracle readme :-(

Nexus 4 upgrade JWR66V -> JWR66Y

I have rooted Nexus 4 with Clockmod Recovery and there are always problems with OTA upgrades. After JWR66Y upgrade, which actually go smoothly. The problem is that SuperSU will be overwritten during upgrade and its not accessible anymore.

There is many articles in internet about this issue, but this one is really short description and it works :-). Another question - is rooting really needed, because it can be also security issue, but this is another story.