Pulling web sites accessed using bash script

#Squid is also capable of reading files containing lists of web sites with awk

#!/bin/sh
# at3 3-1-09
#source:
#http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch32_:_Controlling_Web_Access_w
ith_Squid#Password_Authentication_Using_NCSA
# description: pulls the url address off the squid access.log file
# usage: ~/home/geturl *must be in squid var/logs diretory
# the delimiters are http:// and /
#geturl.bsh

more $1 | awk -F'http://' '{ print $2 }' | uniq -u | awk -F/ '{ print $1 }' | sort | uniq -u

Added crontab options to shutdown and rotate squid logs

# shutdown at 8am, 4pm, and 12am
0       */8     *       *       *       root    shutdown -p now

# rotating squid logs daily at 10PM logs rotate and 11PM makes access.log readable
0       23      *       *       *       root    chmod 644 /usr/local/squid/var/logs/access.log
0       22      *       *       *       root    /usr/local/squid/sbin/squid -k rotate

Squid Proxy

cache1:~ # /usr/local/squid/sbin/squid -N -d 1 -D

#!/bin/bash #bash file titled 'testSquid.bsh'

sudo tail -f /var/log/squid/access.log &

sudo /usr/sbin/squid -N -D -d 1 & 

sudo /usr/local/squid/sbin/squid -NCd1 #another squid command

The commands above were used on Linux RedHat 9 machine.

http://www.deckle.co.za/squid-users-guide/Starting_Squid

ssh -L3128:localhost:3128 mysquid.house -f -N

putty tunnel

L9999 squid.proxy.ip:9999 ;local ports accept connections from other ports 

click on ssh and turn compression on. 

http://kakku.wordpress.com/2007/11/25/proxy-hacks-final-httptunnel-tcpip-connections-over-plain-old-get-and-post-requests/ 

http://digitalpbk.blogspot.com/2009/05/ssh-proxy-windows-linux-orkut-bypass.html

Purpose of computer lab

I am revisiting the reason why I wanted to help build and maintain this computer network for the church. It is meant to be an out reach program and I cannot handle it alone. "In life, we are given a talent and we are meant to share it with other people."

The network will:

Service the community with internet access for job searches
Service the children in school to work on their homework
Provide computer technical support to other offices and ministries on the church campus.

Limitations:

Restrictions will be enforced on what type of websites they can access
The Computer Lab is not a place to do a start up business, but it can be a place of learning

Update 4-22-2011:


Supporting Operations:

This project also supports the operations part of the organization.  Some of the issues that have to be addressed is documentation, knowledge transfer, training, and finding willing people to help.

Controlling Web Access with squid

"Password Authentication Using NCSA
You can configure Squid to prompt users for a username and password. Squid comes with a program called ncsa_auth that reads any NCSA-compliant encrypted password file. You can use the htpasswd program that comes installed with Apache to create your passwords. Follow the link on how it's done."

Source:
the link

Internet Access

All the computers must access the proxy server to gain internet access. The Proxy Server MUST be on, too. If a browser does not have Internet access, the user must do the following:

1. Open Internet Explorer
2. On the Menu Bar Click Tools, Internet Options.















3. From Internet Options, a tabbed menu will show up.
4. Select the Connection Tab and click on the LAN Settings Button.



















5. The LAN Settings window will show up.
6. Check off the Proxy Server box.
7. Enter the address and port to the proxy server.
It should be written on the board in the room.
















8. Click OK and your browser will gain internet access.

Proxy server used to filter websites visited

The problem with this is the machine running the proxy server software is old and tends to crash alot. The solution would be to update the hardware and place the proxy server software on a newer machine.

Creating a Linux Server

I am gathering parts to create a Pentium II Linux Server. I was looking into getting http://www.freeBSD.org once I get the hardware stable. It was going to be an AMD 500Mhz, but the board keyboard and mouse do not respond anymore. So, I will keep you folks up to date.