Category Archives: Linux

This is where all my linux pages will live.

Tomcat stuff

Posted on May 10, 2013 by vicki

How to connect apache and tomcat mod_proxy_ajp is an Apache module which can be used to forward a client HTTP request to an internal Tomcat application server using the AJP protocol. Make sure this line is in the httpd.conf: LoadModule … Continue reading →

Posted in Linux | Comments Off on Tomcat stuff

Making files only executable locally

Posted on May 8, 2013 by vicki

Add the following to your .htaccess file to prevent files from being accessible from external sites: Order deny,allow Deny from all Allow from localhost 127.0.0.0/8 ::1 externalIP/32

Posted in Linux | Comments Off on Making files only executable locally

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

Useful netstat commands

Posted on March 28, 2013 by vicki

To show which IP addresses are currently connected to your server: netstat -nt

Posted in Linux | Comments Off on Useful netstat commands

Connecting to an external MySQL server through an SSH tunnel

Posted on March 8, 2013 by vicki

Scenario: You’re at home, and you want to connect to a mysql server on the other side of a firewall. There is a machine with ssh open on it that you can use as a gateway. On your home machine: … Continue reading →

Posted in Linux, SSH | Comments Off on Connecting to an external MySQL server through an SSH tunnel