《2022年用户认证功能的SQUID代理服务器Mysql教程.docx》由会员分享，可在线阅读，更多相关《2022年用户认证功能的SQUID代理服务器Mysql教程.docx（8页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、2022年用户认证功能的SQUID代理服务器Mysql教程SQUID和MYSQL的安装采纳了SUN发布的二进制安装包，它在software_companion_x86 CD中可以找到；MYSQL_AUTH用GOOGLE搜寻就可以找到。一、安装配置SQUID+MYSQL1.建立用户和组# groupadd squid# useradd -g squid -d /dev/null -s /bin/false squid# groupadd mysql# useradd -g mysql -s /bin/false mysql2. 安装MYSQL# mount F hsfs o ro /dev/ds
2、k/c1t0d0p0 /cdrom # cd /cdrom/components/i386/Packages # pkgadd -d ./ -s /var/spool/pkg SFWmysql SFWgcmn # pkgadd SFWgcmn SFWmysql # chown -R root /opt/sfw/mysql # chgrp -R mysql /opt/sfw/mysql # chown -R mysql /opt/sfw/mysql/var # /opt/sfw/mysql/bin/mysql_install_db # /opt/sfw/mysql/bin/mysqld_safe
3、 # cp /opt/sfw/mysql/share/mysql/my-f /etc/f # vi /etc/f bind-address = 127.0.0.1设置启动脚本：# cp /opt/sfw/mysql/share/mysql/mysql.server /etc/init.d/mysql.server # ln /etc/init.d/mysql.server /etc/rc3.d/S79mysql # ln /etc/init.d/mysql.server /etc/rc0.d/K00mysql # ln /etc/init.d/mysql.server /etc/rc1.d/K
4、00mysql # ln /etc/init.d/mysql.server /etc/rc2.d/K00mysql # ln /etc/init.d/mysql.server /etc/rcS.d/K00mysql # chown root:sys /etc/init.d/mysql.server /etc/rc3.d/S79mysql # chmod 0744 /etc/init.d/mysql.server /etc/rc3.d/S79mysql设置ROOT密码：# mysqladmin -u root password llzqq3安装SQUID# pkgadd -d ./ -s /va
5、r/spool/pkg SFWsquid # pkgadd SFWsquid # cd /opt/sfw/squid/etc # cp squid.conf.default squid.conf # cp mime.conf.default mime.conf4.配置SQUID.CONFhttp_port 192.168.0.1:3128 cache_mgr llzqqnero.3322.org error_directory /opt/sfw/squid/share/errors/Simplify_Chinese dns_nameservers 202.99.160.68 202.99.16
6、8.8 visible_hostname nero.3322.org httpd_accel_uses_host_header on httpd_accel_host virtual httpd_accel_port 80 httpd_accel_with_proxy on cache_mem 20 MB maximum_object_size 4096 KB minimum_object_size 0 KB maximum_object_size_in_memory 30 KB minimum_object_size_in_memory 0 KB cache_swap_low 85 cach
7、e_swap_high 90 cache_dir ufs /opt/sfw/squid/var/cache cache_effective_user squid cache_effective_group squid #http_access allow manager localhost #http_access allow localhost #http_access deny manager #http_access deny !Safe_ports #http_access deny CONNECT !SSL_ports #http_access deny all http_reply
8、_access allow all icp_access allow all miss_access allow all - # chown R squid:squid /opt/sfw/squid/var # /opt/sfw/squid/sbin/squid -z5. SQUID启动脚本# vi /etc/rc3.d/S78squid = S78squid = #!/sbin/sh # # Copyright (c) 2022 by llzqq, Inc # llzqq # All rights reserved. # #ident (#)squid 1.1 04/05/24 SMI ca
9、se $1 in start) /opt/sfw/squid/sbin/squid -s ; stop) /opt/sfw/squid/sbin/squid -k shutdown pkill squid ; *) echo Usage: $0 { start | stop } exit 1 ; esac exit 0 = S78squid = # chown root:sys /etc/rc3.d/S78squid # chmod 744 /etc/rc3.d/S78squid # ln -s /etc/rc3.d/S78squid /etc/rc2.d/
10、K78squid二、 安装MYSQL_AUTH# gzip -d mysql_auth-0.6beta.tar.gz # tar vxf mysql_auth-0.6beta.tar # cd mysql_auth-0.6betaMakefile中须要修改的内容如下：# vi Makefile CFLAGS = -I/opt/sfw/mysql/include -L/opt/sfw/mysql/lib/mysql INSTALL = /usr/ucb/install $(INSTALL) -o root -g sys -m 700 mypasswd /usr/local/bin/myp
11、asswd $(INSTALL) -o squid -g squid -m 755 mysql_auth /usr/bin/mysql_auth $(INSTALL) -o squid -g squid -m 600 $(CONF) /etc/mysql_auth.conf $(INSTALL) -o squid -g squid -m 600 $(CONF) /etc/mysql_auth.conf.defaultsrc/define.h中须要修改的内容如下：# vi +5 src/define.h #define CONFIG_FILE /etc/m
12、ysql_auth.conf #define DEF_MYSQLD_SOCKET /tmp/mysql.socksrc/mysql_auth.conf中须要修改的内容如下：# vi src/mysql_auth.conf mysqld_socket /tmp/mysql.sock # /usr/ccs/bin/make # /usr/ccs/bin/make install创建用户数据库：# cd scripts# mysql -u root -p* < create_script测试MYSQL_AUTH1.添加一个测试用户# mypasswd llzqq 123456Password
13、record ADDED succesfully.2.验证刚才建立的用户# mysql_authllzqq 1234560K3.删除一个已经建立的用户用这个吩咐# mypasswd d username三、在SQUID.CONF中增加MYSQL_AUTH认证部分# vi /etc/squid/squid.conf添加下面的代码到SQUID.CONF中“TAG: acl”一节的后面auth_param basic program /usr/bin/mysql_auth auth_param basic realm LLZQQS CACHING SERVER auth_param basic ch
14、ildren 5 auth_param basic credentialsttl 2 hours acl password proxy_auth REQUIRED http_access allow password authenticate_ip_ttl 2 hours http_access deny all四、客户端设置在阅读器的代理服务器设置中填写SQUID服务器的IP和端口：192.168.0.1:3218在下载软件FLASHGET的代理服务器设置中填写SQUID服务器的IP、端口、用户和密码：192.168.0.1:3218user:llzqqpasswd:123456五、留意事项在进行以上安装前要先安装GCC否则不能编译MYSQL_AUTH，另外在添加用户前须要设置ROOT用户的LD_LIBRARY_PATH变量中有这个路径：/opt/sfw/mysql/lib/mysql