open mind - sharing ideas and experiences

How to install Sun Java Runtime Environment (JRE) in Fedora 11

webmaster — Thu, 15 Oct 2009 00:16:30 +0000

This is a straightforward tutorial on how to install Sun Java Runtime Environment (JRE) in Fedora 11.
1. Go to the site below and grab the latest version of Java Runtime Environment.
http://java.sun.com/javase/downloads/index.jsp
2. After downloading the file, make the file executable

chmod ug+x jre-6u16-linux-i586-rpm.bin

and install.

./jre-6u16-linux-i586-rpm.bin

3. After the installation, you need to configure your system to use the newly installed Java Runtime Environment.

alternatives --install /usr/bin/java java /usr/java/default/bin/java 5

alternatives --config java

During the installation of your Fedora 11 CD or DVD, the OpenJDK 6 development and runtime packages are installed by default.

There are 3 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
*+ 1           /usr/lib/jvm/jre-1.6.0-openjdk/bin/java
   2           /usr/lib/jvm/jre-1.5.0-gcj/bin/java
   3           /usr/java/default/bin/java

Enter to keep the current selection[+], or type selection number: 3

RPM Fusion's Kdenlive error

webmaster — Tue, 13 Oct 2009 23:13:32 +0000

I've got this strange error below when I upgraded my Kdenlive 0.7.4 to 0.7.5 from "RPM Fusion repository".

To fix the problem, you have to delete the file "~/.kde/share/config/kdenliverc" because of wrong MLT binary name in it.

How to show MySQL table details?

webmaster — Tue, 13 Oct 2009 22:17:51 +0000

Issue this command in your MySQL prompt to show table column detail.

desc user;

describe user;

The display would be as follows:

How display database tables in MySQL?

webmaster — Tue, 13 Oct 2009 22:13:56 +0000

Switch to a database you want to use using this command:

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Once you have selected the database, just type this command to show all the tables inside it.

mysql> show tables;

The database tables are shown below.

How to delete MySQL database?

webmaster — Tue, 13 Oct 2009 22:09:09 +0000

To delete MySQL database, just simply type this command inside MySQL terminal.

mysql> drop database test_db;

Query OK, 0 rows affected (0.07 sec)

How to create MySQL database using mysqladmin command?

webmaster — Tue, 13 Oct 2009 22:04:54 +0000

To create MySQL database using mysqladmin command, type this command in your terminal.

mysqladmin create database_name

How to create MySQL database?

webmaster — Tue, 13 Oct 2009 22:01:21 +0000

mysql -u root -p

and type this command:

mysql> create database test_db;

Query OK, 1 row affected (0.00 sec)

To check your newly created database, type this command:

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| test               |

| test_db            |

+--------------------+

4 rows in set (0.00 sec)

Preventing KDE4 applications to start in fullscreen mode on opening in Fedora 11

webmaster — Sun, 06 Sep 2009 00:46:21 +0000

I am experiencing problems with most of my KDE4 applications installed in my Fedora 11 box. I've recently installed digikam, konqueror, konversation, ktorrent etc. and everytime I open each of these applications, its always opening in full screen mode.

How to fix this problem?

After googling, I found out that Compiz Fusion is the one causing this problem. To fix it, open Compizconfig Settings Manager and go "Utility Section" and click "Workarounds" then untick the "Legacy Fullscreen Support". Cheers!

Password less ssh login using RSA/DSA authentication in Fedora 11

webmaster — Sat, 05 Sep 2009 12:01:56 +0000

The Goal of this tutorial

Get a secure, encrypted connection to a remote machine without typing in a password.

What is OpenSSH ?

OpenSSH is a secure way of connecting to remote computers and transfering files. The OpenSSH suite includes the following programs (among others)

How to install tftp server in fedora 11

webmaster — Wed, 02 Sep 2009 22:40:36 +0000

What is TFTP?

Trivial File Transfer Protocol (TFTP) is a file transfer protocol, with the functionality of a very basic form of File Transfer Protocol (FTP). TFTP server is commonly used to upload and download executable images and configurations of routers and switches. To install tftp server, type this command in the console: