This is an update from my previous post about installing Amarok 1.4 on Ubuntu 9.04 (Jaunty Jackalope).

Follow this step:

sudo add-apt-repository ppa:bogdanb/amarok14
sudo apt-get update
sudo apt-get install amarok14

If you have some error messages like:
amarok14: Depends: libmysqlclient15off (>= 5.0.27-1) but it is not installable

download this file, and install
http://security.debian.org/debian-security/pool/updates/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.32-7etch12_i386.deb

This will fix the dependencies problem.

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!

UPDATE (For Ubuntu 10.04 – Lucid Lynx):
Amarok 1.4 on Ubuntu 10.04


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 \ 0x1d7e9dd033e89ba781e32a24b9f1c432ae74ae63

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!!