SquidGuard is a URL redirector used to use blacklists with the proxysoftware Squid. There are two big advantages to squidguard: it is fast and it is free.
MySQL Sandbox
Primary tabs
Installation
The easiest way to install MySQL Sandbox is to use CPAN:
perl -MCPAN -e shell
install MySQL::Sandbox
exit
MySQL Sandbox is meant to be run as a non-root user, so create one and switch to it:
adduser mysandbox
su mysandbox
cd ~
Download a binary tarball of MySQL. Latest version, at time of writing, was 5.1.41:
cd /extra/src
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.41-linux-i686-glibc23.tar.gz/from/http://mirror.csclub.uwaterloo.ca/mysql/
Create a single MySQL sandbox
Assuming you are logged in as the mysandbox
user,
cd ~
make_sandbox ~/mysql-5.1.41-linux-i686-glibc23.tar.gz
A bunch of configuration defaults will be displayed and you will be prompted to accept them. As this is our first sandbox, agree to the options and it will be installeded in /home/mysandbox/sandboxes/msb_5_1_41
. The default MySQL port will be 5141, user and password will be msandbox, and the socket /tmp/mysql_sandbox5141.sock
.
You can confirm that the new sandbox is functioning by logging into it using an already installed copy of MySQL and the sandbox's socket /usr/local/mysql/bin/mysql -u msandbox -p -S /tmp/mysql_sandbox5141.sock
. However, a much easier way is the scripts that are installed in ~/sandboxes/msb_5_1_41/
:
start
- start the serverstop
- stop the serverclear
- remove any data so you can begin anewuse
- a wrapper that runs themysql
command-line tool, connecting to the instance- Export a database:
./use db_name > /path/to/sql/dump
- Import a database:
./use db_name < /path/to/sql/dump
send_kill
- sendskill -TERM
and then, if necessarykill -KILL
to the server processmy
- starts one ofmysqldump
,mysqladmin
,mysqlbinlog
using credentals frommy_sandbox.cnf
phpMyAdmin
phpMyAdmin can be used to manage a sandbox's database. When configuring the server in phpMyAdmin:- Server port - eg. 5141
- Server socket - eg.
/tmp/mysql_sandbox5141.sock
- Connection type -
socket
Extra Resources
at Linux Magazine- Export a database:
- Log in to post comments