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, [...]
This howto will show you howto store your users in LDAP and authenticate some of the services against it. I will not show howto install particular packages, as it is distribution/system dependant. I will focus on “pure” configuration of all componenets needed to have LDAP authentication/storage of users.
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
keepalived provides a strong and robust health checking for LVS clusters. It nginx implements a framework of health checking on multiple layers for server failover, and VRRPv2 stack to handle director failover. How do I install and configure Keepalived for reverse proxy server such as nginx or lighttpd?
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.
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.
Openvpn is an open source software, allows us to create a Virtual Private Network.
1. Istalling openvpn
install these packages openvpn openssh-server openssl:
laptop:~$ sudo apt-get install openvpn openssh-server openssl
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.
To interact with amazon S3, we have many languages we can use as well as python. I chose python because it’s a scripting language. That means we don’t need to compile and we don’t need a virtual machine to run it, only an interpreter is needed.