mysql_auth squid

# wget http://freshmeat.net/redir/mysql_auth/34350/url_tgz/mysql_auth-0.8.tar.gz
# tar zxvf mysql_auth-0.8.tar.gz
# cd mysql_auth-0.8/
# nano -w Makefile

dari

install:
$(INSTALL) -o nobody -g nogroup -m 755 mysql_auth /usr/local/squid/libexec/mysql_auth
$(INSTALL) -o root -g root -m 700 mypasswd /usr/local/bin/mypasswd
$(INSTALL) -o nobody -g nogroup -m 600 $(CONF) /usr/local/squid/etc/mysql_auth.conf
$(INSTALL) -o nobody -g nogroup -m 600 $(CONF) /usr/local/squid/etc/mysql_auth.conf.default

ubah menjadi

install:
$(INSTALL) -o squid_ -g squid_ -m 755 mysql_auth /usr/squid/libexec/mysql_auth
$(INSTALL) -o root -g wheel -m 700 mypasswd /usr/sbin/mypasswd
$(INSTALL) -o squid_ -g squid_ -m 600 $(CONF) /usr/squid/etc/mysql_auth.conf
$(INSTALL) -o squid_ -g squid_ -m 600 $(CONF) /usr/squid/etc/mysql_auth.conf.default

# nano -w src/mysql_auth.conf

hostname        l72.16.0.123
user            squid_
password        squid_
database        squid_
mysqld_socket   /var/run/mysql/mysql.sock
table           data
user_column     user
password_column password
encrypt_password_form   NO

#nano -w src/define.h
sesuaikan dengan mysql_auth.conf

# make && make install

# nano -w scripts/create_script

DROP DATABASE IF EXISTS squid_;

USE mysql;
DELETE FROM user WHERE User LIKE ’squid_’;
DELETE FROM db WHERE User LIKE ’squid_’;
DELETE FROM tables_priv WHERE User LIKE ’squid_’;

CREATE DATABASE squid_;

USE squid_;

CREATE TABLE data
(user VARCHAR(16) NOT NULL PRIMARY KEY,
password VARCHAR(64) BINARY NOT NULL);

GRANT SELECT,INSERT,UPDATE,DELETE ON squid_.data TO squid_@192.168.10.1 IDENTIFIED BY ’squid_’;

# scp scripts/create_script tonix@172.16.0.123:/home/tonix/

# squidconf

auth_param basic program /usr/squid/libexec/mysql_auth
auth_param basic realm -Niax Jelek-
auth_param basic children 5
auth_param basic credentialsttl 2 hours
acl maxuser max_user_ip -s 2
acl password proxy_auth REQUIRED

http_access allow route.net  password !maxuser

# mypasswd toni jelek
# mysql_auth
toni
jelek
OK

*Login ke 172.16.0.123
#mysql -uroot -p squid_ < create_script

requestnya harus bisa di redirect ketampilan tertentu.

explore lagi explore lagi deh …