http://www.hackadmin.com Tue, 16 Mar 2010 21:31:57 +0000 http://backend.userland.com/rss092 en 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 ... http://www.hackadmin.com/2010/03/16/how-to-implement-htaccess-with-mysql/ Article by Aashish 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. ... http://www.hackadmin.com/2010/03/05/ldap-authentication-in-linux/ via Bhushan TYPES OF MYSQL REPLICATION Statement-based Replication Row-based Replication Mixed To change the type of Replication modify my.cnf configuration file and change binlog_format=mixed | row | statement mysql> SHOW VARIABLES LIKE 'binlog_format'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | binlog_format | MIXED +---------------+-------+ Processes/Threads inside MySQL that are responsible for replication MASTER - Binlog Dump Thread SLAVE - I/O Thread SQL Thread ... http://www.hackadmin.com/2010/03/04/mysql-server-replication-with-ssl/ Article by Aashish 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? If ... http://www.hackadmin.com/2010/02/22/ip-failover-for-web-cluster/ Article by Aashish This article explains the process that will allow you to recover a lost MySQL password: Stop the MySQL server process Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password. Connect to mysql server as the root user. Setup new mysql root account password. Exit and ... http://www.hackadmin.com/2010/02/20/how-to-recover-a-lost-mysql-password/ Article by Aashish 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. Syntax The syntax is as follows to redirect tcp $srcPortNumber port to $dstPortNumber: iptables -t nat ... http://www.hackadmin.com/2010/02/19/port-redirection-through-the-iptables/ Article by Aashish Apache Performance ModulesApache 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 ... http://www.hackadmin.com/2010/02/18/apache-modules-and-their-functions/ Article by Aashish How 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 ... http://www.hackadmin.com/2010/02/18/how-to-create-connection-limits-with-iptables/ Article by Khaled Openvpn is an open source software, allows us to create a Virtual Private Network. 1. Installing openvpn install these packages openvpn openssh-server openssl: laptop:~$ sudo apt-get install openvpn openssh-server openssl Now the ssh server is installed we can control it and access to it from anywhere on the web using the IP ... http://www.hackadmin.com/2010/02/17/openvpn-tutorial/ Article 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. iSCSI initiator (client) An initiator functions as an iSCSI client. An initiator ... http://www.hackadmin.com/2010/02/16/iscsi-target-server/