SSH looks for the user config file in ~/.ssh/config. A sample might look like: Code: ForwardX11 yes Protocol 2,1 Using ForwardX11 yes is the same as specifying -X on the command line. The Protocol line tells SSH to try SSH2 first and then fall back to SSH1. If you want to use only SSH2, delete [...]

Palm has made the webOS 1.2 update available via over-the-air download and brought a slew of new features in this update. Earlier this month Palm webOS 1.2 update was leaked with better copy-paste, remote App approval, LED notifications and other features. A major feature in this update is the app purchases support from App Catalog [...]

This howto describes how to install and configure Cacti quickly on a CentOS server. Cacti packages are available from the RPMforge repository. Read this for information about the RPMForge repository. But beware, some repositories do not mix well. The rest of this HOWTO assumed that your system is set up to use the RPMforge repository. For those who [...]

SFTP, or secure FTP, is a program that uses SSH to transfer files. Unlike standard FTP, it encrypts both commands and data, preventing passwords and sensitive information from being transmitted in the clear over the network. It is functionally similar to FTP, but because it uses a different protocol, you can’t use a standard FTP [...]

Open the page containing your horizontal menu bar in Dreamweaver. It doesn’t matter if your page is a one, two or three column website. Move your mouse over the menu bar until you see the highlighted blue caption “Spry Menu Bar MenuBar1″. (Note: if you have more than one menu bar on your page, the [...]

To create a database in MySQL, you use the CREATE DATABASE statement as follows: CREATE DATABASE [IF NOT EXISTS] database_name; CREATE DATABASE statement will create the database with the given name you specified. IF NOT EXISTS is an option part of the statement, this part prevents you from error if there is a database with [...]

The first step is to look at rkhunter and see if it reports anything that is bad. If rkhunter reports that the server has been rooted it is probably going to best to reimage the server once the method of intrusion has been determined. Download and unzip rkhunter —–command—– cd /usr/local/src/ wget http://downloads.rootkit.nl/rkhunter-1.2.1.tar.gz tar -zxf [...]

The mirrored contents should be available through HTTP and FTP; both are optional but of course at least one should be there. In addition, you might provide rsync access — this is highly optional. Your http/ftp servers should return correct status for non-existent files (HTTP 404, FTP 550). Your mirror should be updated on a [...]

In many cases, the GRUB boot loader can mistakenly be deleted, corrupted, or replaced by other operating systems. The following steps detail the process on how GRUB is reinstalled on the master boot record: Boot the system from an installation boot medium. Type linux rescue at the installation boot prompt to enter the rescue environment. Type chroot [...]

Hybrid RAID implementations have become very popular with the introduction of inexpensive RAID controllers, implemented using a standard disk controller and BIOS (software) extensions to provide the RAID functionality. The operating system requires specialized RAID device drivers that present the array as a single block based logical disk. Since these controllers actually do all calculations [...]

Now we create a database called pureftpd and a MySQL user named pureftpd which the PureFTPd daemon will use later on to connect to the pureftpddatabase: mysql -u root -p CREATE DATABASE pureftpd;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO ‘pureftpd’@’localhost’ IDENTIFIED BY ‘ftpdpass’;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO ‘pureftpd’@’localhost.localdomain’ IDENTIFIED BY [...]

Open the terminal Stop MySQL with the command sudo /etc/init.d/mysql stop Copy the existing data directory (which is located in/var/lib/mysql) using the commandsudo cp -R -p /var/lib/mysql /path/to/new/datadir All you need are the data files. Delete the others with the commandsudo rm /path/to/new/datadir (You will get a message about not being able to delete some directories, [...]

The table used in this case is a user subscription table. Generally this table keeps records of users’ subscription details: which topic they subscribed, when they last viewed their topics subscribed, who last replied a topic and when, when a default subscription will be expired (not used currently). Formerly we  wanted to use multiple tables. [...]

We can get the number of rows or records present in a table by using mysql_num_rows() function. This function is to be used along with mysql select query. We can add condition by using mysql where clause to the select query and get the conditional rows. This function is widely used in different php scripts [...]

MySQL provides a bunch of statements to allow you to maintain database table more efficiently. Those statements enable you to analyze, optimize, check, and repair the database table. Here you will learn them all together with examples. Analyze table statement Basically analyze table statement allow you to update cardinality of an index column. By updating [...]