October 2009

How to make wma, wmv, mp3, mpeg, mp4, dvd, mov, real audio and video playble in Fedora 11 using Totem with xine backend.

Totem is the default multimedia player for Fedora 11. It uses gstreamer backend by default, but also works with xine backend. Witht the xine library in use, totem can play all media formats with the exception of encrypted/drm’d media and blu-ray/hd-dvd.

This tutorial will show you how to force totem to use xine as a default backend.

To install xine backend, the the command below as root:

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

How to install latest Flash Player plugin for Firefox on Fedora 11

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

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:

How to fix Kdenlive (from rpmfusion repo) MLT error in Fedora 11

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?

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

desc user;

or

describe user;

The display would be as follows:

How display database tables in MySQL?

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?

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?

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

mysqladmin create database_name

How to create MySQL database?

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;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| mysql              | 
| test               | 
| test_db            | 
+--------------------+
4 rows in set (0.00 sec)