Home › Monthly archive

October 2009

How to make totem media player play wma, mp3 and real audio in Fedora 11

Submitted by Richard on Thu, 10/29/2009 - 00:02

Install xine backend.

yum install xine-lib xine-lib-extras xine-lib-extras-freeworld xine-plugin totem-xine

Since totem uses gstreamer as its default backend, we need to change its backend to use xine. To do it, just type the command:

totem-backend -b xine

You can now play mp3, wma and real audio using totem media player. To know more about xine, please click this link.

How to install latest flash plugin for firefox in Fedora 11

Submitted by Richard on Wed, 10/28/2009 - 23:56

Adobe flash player is available via yum. To download flash player, enable adobe yum repo using this command:

rpm -Uvh http://linuxdownload.adobe.com/adobe-release/adobe-release-i386-1.0-1.noarch.rpm

After enabling the repo, install the flash player plugin. Type this command:

yum install flash-plugin

Flash player is now installed in your system, just restart your firefox if is currently running and you can now watch flash content in your browser.

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

Submitted by Richard on Thu, 10/15/2009 - 08:16

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

Enter "3" to change it to your newly installed Java Runtime Environment.
Verify your version of java using this command:  full story »

RPM Fusion's Kdenlive error

Submitted by Richard on Wed, 10/14/2009 - 07:13

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

Kdenlive error in Fedora 11

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?

Submitted by Richard on Wed, 10/14/2009 - 06:17

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

desc user;

or

describe user;

The display would be as follows:  full story »

How display database tables in MySQL?

Submitted by Richard on Wed, 10/14/2009 - 06:13

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.  full story »

How to delete MySQL database?

Submitted by Richard on Wed, 10/14/2009 - 06:09

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?

Submitted by Richard on Wed, 10/14/2009 - 06:04

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

mysqladmin create database_name

How to create MySQL database?

Submitted by Richard on Wed, 10/14/2009 - 06:01

Login to your MySQL database server

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;

  1. +--------------------+
  2. | Database           |
  3. +--------------------+
  4. | information_schema |
  5. | mysql              |
  6. | test               |
  7. | test_db            |
  8. +--------------------+
  9. 4 rows in set (0.00 sec)