Howtos

How to install and configure VNC in Fedora 12

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.

How to fix X11 Forwarding in CentOS 5

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".

How to disable IPV6 in Fedora 12 and CentOS 5.5

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 inside MySQL table

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.

How to update data inside MySQL table

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.

How to insert data into MySQL table

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:

How to convert xls files to csv in Linux

Install xls2csv

yum -y install xls2csv

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

convertxls2csv -x filename.xls -c 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.

#!/bin/bash
for files in *.xls
do
convertxls2csv -x "$files" -c "${files%.*}.csv"
done

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

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.

How to install VirtualBox Open Source Edition in Fedora 12

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

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.

Syndicate content