Article by Aashish
# yum install httpd* mysql* -y
*** Install Module Needed for Authentication from MySQL databases. ***
# yum install mod_auth_mysql -y
*** Create a database which contains a table holding the username and passwd ***
#mysql -u root -p
password:
mysql> create database httpd;
mysql> use httpd;
mysql> create user ‘apache’@’localhost’ identified by ‘apache’;
mysql> create table users( user_name char(30) NOT NULL, [...]
In: Bushan| Linux| MySQL| Replication
4 Mar 2010TYPES OF MYSQL REPLICATION
*
Statement-based Replication
*
Row-based Replication
*
Mixed
To change the type of Replication modify my.cnf configuration file and change
This article explains the process that will allow you to recover a lost MySQL password:
Stop the MySQL server process
How do I redirect 80 port to 8123 using iptables?
You can easily redirect incoming traffic by inserting rules into PREROUTING chain of the nat table. You can set destination port using the REDIRECT target.
Apache is a powerful and widely-used World-Wide Web (Web) server. One of its strengths is that the modules that it is made of are customizable according to the user’s requirements. Ashish Kumar discusses the benefits and the process of customization, along with a brief introduction to some useful modules.
In: Aashish| Linux| Monitoring| Security| TCP/IP| iptables| ubuntu
18 Feb 2010How do I restrict the number of connections used by a single IP address to my server for port 80 and 25 using iptables?
You need to use the connection limit modules which allows you to restrict the number of parallel TCP connections to a server per client IP address (or address block). This is useful to protect your server or vps box against flooding, spamming or content scraping.
In: Aashish
16 Feb 2010Article by Aashish
Storage resource located on an iSCSI server known as a “target”. An iSCSI target usually represents nothing but hard disk storage. As with initiators, software to provide an iSCSI target is available for most mainstream operating systems.
Article by Aashish
How To Set Red hat / CentOS Linux Remote Backup / Snapshot Server
Q. I am using an HP RAID 6 server running RHEL 5.x. I’d like this box to act as a backup server for my other Red Hat DNS and Web server. The server must keep backup in hourly, daily and monthly [...]
In: Aashish| Linux| Monitoring| MySQL| Scripts
13 Feb 2010MySQL can sometimes create big problems on a server when you have users abusing it.
This article will teach you how to correctly identify the queries that are creating a problem for your server.