I want to create routing for my two Lan Card. First Lan Card (eth0) for Internet access, and second Lan Card (eth1) for my Intranet. So when i access internet, it will route to my eth0 by default. otherwise, with eth1 for intranet access.

Public (eth0):
IP: 201.102.21.201
Netmask: 255.255.255.241
Gateway: 201.102.21.1

Intranet (eth1):
IP: 10.1.10.24
Netmask: 255.255.255.0
Gateway: 10.1.10.1

Basic command for adding route on Linux:

route add [-net|-host] <IP/Net> netmask <Mask> gw <Gateway IP> dev <Int>X

And this is what we do:

route add -net 10.0.0.0 netmask 255.0.0.0 gw 10.1.10.1 dev eth1
route add -net default netmask 0.0.0.0 gw 201.102.21.1 dev eth0

To check the route, simply type “route” with no arguments

route

The output will seen like this:

Kernel IP routing table
Destination     Gateway         Genmask            Flags  Metric Ref    Use Iface
201.102.21.201  *               255.255.255.241     U      1          0        0 eth0
10.1.10.24           *               255.255.255.0          U      1          0        0 eth1
link-local             *               255.255.0.0              U    1000     0        0 eth0
10.0.0.0         10.1.10.1       255.0.0.0                  UG    0          0        0 eth1
default           201.102.21.1    0.0.0.0                   UG    0          0        0 eth0

Now, to keep this route persistent, add this lines to file /etc/networking/interfaces

up route add -net 10.0.0.0 netmask 255.0.0.0 gw 10.1.10.1 dev eth1
up route add -net default netmask 0.0.0.0 gw 201.102.21.1 dev eth0

Restart networking to confirm the changes

sudo /etc/init.d/networking restart

Other method, Create a file called defaultroute in /etc/init.d and make it executable (chmod +x /etc/init.d/defaultroute).
Add the route commands there and do this:

update-rc.d defaultroute defaults 99

.

To repair your Ubuntu GRUB, you need Ubuntu LiveCD, boot from this CD, and open a terminal. Be a root, by typing “sudo su” and enter your password.

Find the partition which your Ubuntu system is installed.

# fdisk -l

On my machine, my Ubuntu partition is on /dev/sda3, so i’ll use this for example.

Create a mountpoint for this:

# mkdir /media/rootgrub
# mount /dev/sda3 /media/rootgrub

Check if your partition is the correct partition

# ls /media/rootgrub

if the output is not like this, then you have the wrong partition

bin dev home lib mnt root srv usr boot etc initrd lib64 opt sbin sys
var cdrom initrd.img media proc selinux tmp vmlinuz

unmount the partition if have the wrong one, then mount the others. To make sure you have the correct partition, run ls /media/root/boot, which should output something like this :

config-2.6.18-3-686     initrd.img-2.6.18-3-686.bak    System.map-2.6.18-3-686
grub lost+found          vmlinuz-2.6.18-3-686             initrd.img-2.6.18-3-686
memtest86+.bin

Now when everything is ok, install the Grub:

# sudo grub-install –root-directory=/media/rootgrub /dev/sda

If you have some warning, try this:

# sudo grub-install –root-directory=/media/rootgrub /dev/sda –recheck

Change /dev/sda to other partition you want to install Grub on. If all goes fine, you will see the output like this:

Installation finished. No error reported. This is the contents of the device map /boot/grub/device.map. Check if this is correct or not. If any of the lines is incorrect, fix it and re-run the script `grub-install’.

(hd0) /dev/sda

Restart to your harddrive (not to LiveCD) and see, your GRUB should be AUTOMAGICALLY appear!

I love Amarok. On every Linux Distros i installed, i must have Amarok as my default media player. Too bad, at new release Ubuntu (9.04 a.k.a Jaunty Jackalope) they replaced Amarok 1.4 with new Amarok 2. I really don’t like it. Looks so ugly with all gray interface. Remind me of Windows 311 era.

I tried Amarok-2 for a few days. and i gave up. I have to back to Amarok 1.4, the best Media Player (at least in my opinion).
I must find a way to installed Amarok 1.4 from repository. Compile manually? no.. Please dont!
And thanks God, they still keep the Amarok 1.4 version at PPA.

Here’s the step for installing Amarok 1.4 at Ubuntu 9.04 (Jaunty Jackalope)

1. Add the PPA repositories to your sources list.

sudo pico /etc/apt/sources.list.d/amarok.list

Then add this:

deb http://ppa.launchpad.net/bogdanb/ppa/ubuntu jaunty main
deb-src http://ppa.launchpad.net/bogdanb/ppa/ubuntu jaunty main

2. Add the key for the PPA:

sudo apt-key adv –recv-keys –keyserver keyserver.ubuntu.com \ 0×1d7e9dd033e89ba781e32a24b9f1c432ae74ae63

if its not working, try with this:

sudo apt-key adv –keyserver subkeys.pgp.net –recv-keys AE74AE63

3. When successful, update your sources.

sudo apt-get update

remove Amarok 2

sudo apt-get remove amarok

Install the Amarok 1.4

sudo apt-get install amarok14

.

Terrible, just setup a new server, then i forgot root password for mysql database. So i need to reset the root password.

This is the way i do:
1. Login to our server machine as root (system administrator). Yes! we must have root access to our machine.

2. Shutdown mysql server (if already running). Make sure no other mysql daemon running.

$ /etc/init.d/mysql stop

3. Create a text file and place the following statements in it. Replace the password with the password that you want to use.

UPDATE mysql.user SET Password=PASSWORD(‘YourNewPasswordHere’) WHERE User=’root’;
FLUSH PRIVILEGES;

The UPDATE and FLUSH statements each must be written on a single line. And make sure we have statement “where user=’root’“, to make sure, only our root password is updated.

4. Save the text file into our home directory, or somewhere else. Example, i saved this as: “/home/vandai/mysql-reset”

5. Start the MySQL server with the special –init-file option:

mysqld_safe –init-file=/home/vandai/mysql-reset &

This will execute the contents of the file named by the –init-file option at startup, changing each root account password.

6. Don’t forget to delete mysql-reset file immediately!!

Now we will be able to login to MySql database as root with our new password.

Never forget the password again!!

OpenOffice.org 3 is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used completely free of charge for any purpose.

Ubuntu 8.10 has been released on october, 30th 2008. Too bad, its bundled with Openoffice.org 2.4, not Openoffice.org 3.0!.

Explanation from Ubuntu developer why they exlude OpenOffice.org 3.0 from Ubuntu 8.10 can be found here:
http://www.tectonic.co.za/?p=3447

You can install Openoffice.org 3.0.0 in 2 ways. Do clean install by installing it from source, or upgrade your current installation by updating your package.

Install Openoffice from source

Here’s step by step to install Openoffice.org 3.0 from source.

1. Download OOO 3.0 source from Openoffice.org
   http://download.openoffice.org/index.html
   .
   for IIX User:
   ftp://kambing.ui.ac.id/openoffice/stable/
   .
2. Extract downloaded files, and go to created directory.
   $ tar zxvf OOo_3.0.0_LinuxIntel_install_en-US_deb.tar.gz
   $ cd OOO300_m9_native_packed-1_en-US.9358
   .
3. Make sure you have remove older Openoffice.org installation.
   $ sudo apt-get remove openoffice.org-core
   .
4. Go to “DEBS” directory, and install all files.
   $ cd DEBS
   $ sudo dpkg -i *.deb
   .
5. To make your Openoffice.org 3.0 shown in application menus, go to directory “desktop-integration” (DEBS/desktop-integration/), then install the files.
   $ cd desktop-integration
   $ sudo dpkg -i *.deb
   .
6. In some case,  you’ll get error messages, saying that there’s conflict with other Openoffice package when installing openoffice.org3.0-debian-menus_3.0-9354_all.deb
   To resolve this, go to synaptic package manager, and remove all Openoffice.org installation from here. And restart from step 4.
   .