Published on : September 26, 2014 by Felix
The modsecparse.pl cronjob producing the following modsecparse.pl database connection error Solution Try reproducing the error by running the cron job manually: If it shows the same error, make sure the password used on the “my $dbpassword” 19th line in /etc/cron.hourly/modsecparse.pl matches the “modsec” password in MySQL. my $dbpassword = ‘sample’; You can reset the “modsec” MySQL […]
Published on : September 24, 2014 by Mithun S.
cPHulk is a brute force protection system. cPHulk blocks the IP addresses that have more than one invalid login attempt within a fixed time interval. We are here trying to explain how the cPHulk whitelist IP can be done. cPHulk stores all of its information in a database called cphulkd. There are two tables of interest: logins and brutes. […]
Published on : September 21, 2014 by George K.
Have you ever forgotten the root password on one of our clients MySQL servers? No worries, please follow these five steps to do the MySQL root password reset. 1. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords. Or […]
Published on : September 14, 2014 by George K.
Sometimes due to lack of Disk space in /var various activities such as logging gets affected and it may have severe impact on service and server uptime. In some cases, it is observed that default MySQL installation occupies large chunk of space in the /var partition due to the db data present in the default […]
Published on : August 18, 2014 by Irshad K.
Sphinx is a Linux and Windows based search engine service which allows full text searching of extremely large databases in a very efficient and quick manner We are here providing the steps for sphinx mysql integration . 1. Identify the current version of MySQL The current version is mysql-5.5.31-1.el6.remi.x86_64 2. Download the MySQL source file As you […]