How to install and configure VNC in Fedora 12

Submitted by Richard on Sat, 07/24/2010 - 00:33

Open up your terminal and install tigervnc via yum.
Type this command in your terminal:

yum -y install tigervnc tigervnc-server

Edit the VNC configuration file

vi /etc/sysconfig/vncservers

and append these lines:

VNCSERVERS="1:user"
VNCSERVERARGS[1]="-geometry 800x600 -depth 16"

Where VNCSERVERS= is for configuring the username.  full story »

How to fix X11 Forwarding in CentOS 5

Submitted by Richard on Fri, 07/23/2010 - 19:27

This tutorial describes how to fix the ssh X11 forwarding problem in CentOS 5.5 server.

Autoselected keyboard map en-us
ERROR: Failed to open display:

Make sure that the "xorg-x11-xauth" is also installed in your system. If not, this comm

yum -y install xorg-x11-xauth

Ensure that "X11Forwarding" is enabled in your ssh server configuration file. Edit the file "/etc/ssh/sshd_config".  full story »

How to disable IPV6 in Fedora 12 and CentOS 5.5

Submitted by Richard on Tue, 07/20/2010 - 23:44

This is a quick tutorial on disabling IPV6 in Fedora 12 and CentOS 5.5

echo -e "install ipv6 /bin/true\nblacklist ipv6" > /etc/modprobe.d/blacklist-ipv6.conf

Stop ip6tables service and disable it from starting automatically at system boot.

service ip6tables stop
chkconfig ip6tables off

How to delete data in MySQL table

Submitted by Richard on Tue, 07/20/2010 - 23:30

If you want to delete a record from any MySQL table then you can use the delete command. The delete command is very similar to the update command.

delete from table where where_condition;

The delete statement deletes rows from a table.
The table is the table name.
The where clause specifies the conditions that identify which rows to delete.  full story »

How to update data in MySQL table

Submitted by Richard on Tue, 07/20/2010 - 17:28

Here's how to update existing data into MySQL database table.

update table set column='new_value' where where_condition;

The update statement updates columns of existing rows in the table with new values.
The table is the table name.
The set clause indicates which column to modify and the values they should be given.  full story »

How to insert data into MySQL table

Submitted by Richard on Tue, 07/20/2010 - 00:33

Here is a general form of insert command:

insert into table (column1, column2) values (value1, value2);

The insert statement inserts new row into an existing table. The table is the name of the table into which we want to insert data, column1 and column2 are column names and value1, value2 are values for the respective columns.

Example:  full story »

Converting Excel files to CSV in Linux

Submitted by Richard on Sun, 03/21/2010 - 04:56

Install xls2csv

yum -y install xls2csv

To convert your xls file to csv, just type this command:

xls2csv filename.xls > filename.csv

This script is very useful if you have a lot of excel files to convert. This will help you save a lot of time than converting it one by one.

  1. #!/bin/bash
  2. ls *.xls | while read file
  3. do
  4. filename=`echo $file | cut -d . -f 1`
  5. xls2csv "$file" > "$filename".csv
  6. done

How to configure Java plugin in Google Chrome beta in Fedora 12

Submitted by Richard on Sun, 02/21/2010 - 07:29

If you don't have a Java Runtime Environment installed in your system, you can follow this guide. Download and install the beta version of Google Chrome for linux from here or install it using yum, you can follow my tutorial here.  full story »

How to install VirtualBox Open Source Edition in Fedora

Submitted by Richard on Sun, 02/21/2010 - 07:19

Enable RPM Fusion repository

rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm

Then install Virtualbox by typing this command:

yum -y install VirtualBox-OSE kmod-VirtualBox-OSE

How to install Google Chrome Beta in Fedora 11 and Fedora 12 via yum

Submitted by Richard on Sun, 02/21/2010 - 07:17

Configure Google rpm repository

Google's Linux packages are signed with a GNU Privacy Guard (GPG) key. You must install the public package signing key on your system to prevent warnings or errors when installing packages from the Google Linux software repositories. Download the key and then use rpm to install it.  full story »