Using a database backend (SQLServer, Oracle or MySQL)

Big Brother version 4.20 is the first BBPE release to support archiving data into a database. The BB server database component uses ODBC and support Oracle, MySQL and SQLServer. If you have ODBC installed and setup, you can use the following procedures to archive BB data into a supported DB.

MySQL (UNIX/Linux/Windows)

SQLServer (Windows)

MySQL (UNIX/Linux/Windows):

1. Connect to your MySQL database as root:
	mysql -u root -p (The -p will prompt you for the root password.)
2. As root, create the 'bb' user:
	create user bb identified by 'bb';
3. Create the database for Big Brother:
	create database bigbro;
4. Login to MySQL as the 'bb' user and connect to the bigbro database:
	mysql -u bb -p bigbro
5. Create the BB objects:
	source mysql_createtable.sql

After setting up the database environment for Big Brother, configure your BBServer to use the MySQL database:

6. Enable the database in the RUNOPTS variable (etc/bbdef-server.sh):
	RUNOPTS="SAVE_IN_DB SAVE_IN_FILES USEDB"
7. Edit the bbdb.cfg file.
	Define correct values for: DATA_SOURCE, USER_DB, PASSWORD_DB and SAVEALL_DB.
8. Restart the BBServer.

Top

SQLServer (Windows):

Top