© 1996-2003 Jan Wolter, Steve Weiss
Prev: Part II: Compilation
Next: Part IV: Installation (with Backtalk Accounts or with Unix Accounts)
(1) Create the SQL Database
If you are not using a pre-existing database, then this is the time to create one. The normal name for the database would be 'backtalk' but anything can be used. The database must be accessible from whatever account the CGI's run on.
If your server is run by an ISP, they will probably have provided a web interface through which you can create and administer databases. Use that. You'll probably need to give a name for the database, and create a user with a login and a password who has access to that database. You will be given the database servers hostname and the port number to be used. Note all of this down.
If you on a server you administer yourself, you'll probably have to use the command line interface to create a database. The commands to create a database will vary for different SQL servers. For PostgreSQL, you might create a database from the shell with the command:
For MySQL, you might run the "mysql -u root -p" command. (If you don't have a password on your mysql root account omit the '-p' flag. Or better yet, set a password!) Then issue the command:
create database backtalk;You will also want to create a username and password for Backtalk to log in as and permit the database to be accessible only to that account. Whether this is needed depends on your configuration, but generally tighter access restrictions are better.
A typical mysql command that creates a mysql account named 'btuser' with password 'btpass' that can access the 'backtalk' database from the local server (only) would be:
grant select,insert,update,delete,create,drop on backtalk.* to 'btuser'@'localhost' identified by 'btpass';
(2) Edit the Runtime Configuration File
If you are upgrading a system that uses SQL, you will probably want to copy the `backtalk.conf' file that is installed in the backtalk etc directory into misc/backtalk.conf.
At this point, all you need to define are the SQL server settings. There are other settings in that file that you can configure, but they need not be set before installation. If your SQL server is running on the same machine as Backtalk, the database is called 'backtalk', and no login or password is needed to connect, you can probably use he default configuration file without changes. Otherwise, you may want to set the following options: