Monthly Archives: April 2013

ReSync MySQL Master Slave

Posted on April 16, 2013 by vicki

At the master: RESET MASTER; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; And copy the values of the result of the last command somewhere. Wihtout closing the connection to the client (because it would release the read lock) issue … Continue reading →

Posted in Linux, MySQL | Comments Off on ReSync MySQL Master Slave

Unique hits to apache site

Posted on April 13, 2013 by vicki

cat access.log | awk ‘{print $1}’ | sort | uniq -c | sort -g

Posted in Linux | Comments Off on Unique hits to apache site

mysqlbinlog command

Posted on April 13, 2013 by vicki

The “mysqlbinlog” command reads the binary logs and outputs them in SQL format. As a result, you can use it to create a database dump and then modify that file by hand. For example, let’s say that everything since April … Continue reading →

Posted in Linux | Comments Off on mysqlbinlog command

To prevent an apt package from auto updating

Posted on April 13, 2013 by vicki

Using apt you can hold a package using sudo apt-mark hold package_name and remove the hold with sudo apt-mark unhold package_name

Posted in Linux | Comments Off on To prevent an apt package from auto updating

Preventing access to a website from specific IP addresses with Deny/Allow

Posted on April 11, 2013 by vicki

Configure the Virtual Host as follows: Order Deny,Allow Deny from all Allow from 11.211.0.0/15 Allow from 12.212.0.0/15 Require valid-user Satisfy all AuthName “Restricted Area” AuthType Basic AuthUserFile /home/web/.htpasswd Require valid-user Create file with the following command: htpaddwd /home/web/.htpasswd Another option: … Continue reading →

Posted in Linux | Comments Off on Preventing access to a website from specific IP addresses with Deny/Allow

Password Protecting a web site

Posted on April 11, 2013 by vicki

Add the following to .htaccess: CentOS: AuthType Basic AuthName “Restricted” AuthUserFile /etc/httpd/htaccess-pass Require valid-user #Order deny,allow #Deny from All #Satisfy any Create the file as follows: htpasswd /etc/httpd/htaccess-pass username You will then be prompted for a password Ubuntu: AuthType Basic … Continue reading →

Posted in Linux | Comments Off on Password Protecting a web site