CCCP repository database: Firebird 1.5.x

Download Firebird 1.5.x from Firebird

The following screendumps shows how to install Firebird 1.5.x on Windows XP:

























Please note that the default superuser credentials for Firebird is username SYSDBA with password masterkey.

In the above example, Firebird was installed in directory C:\Programmer\Firebird\Firebird_1_5, so it's binaries are in C:\Programmer\Firebird\Firebird_1_5\bin. On Unix/Linux your firebird binaries will probably be in the PATH allready (/usr/bin)

On Windows, start the Command Prompt from START -> RUN, then type cmd before hitting the <ENTER> key. When Command Prompt starts up, type:

SET PATH=%PATH%;C:\Programmer\Firebird\Firebird_1_5\bin

Keep the Command Prompt window open, as we will use it in the next chapter.

In the allready open Command Prompt window (or in your shell on Unix/linux), change directory to where you unzipped CCCP-<version>-production.zip. For instance if you unzipped it in C:\temp, type:

cd /d C:\temp\CCCP-<version>-production

On Unix/Linux you would for example type:

cd /tmp/CCCP-<version>-production

Then go into the sql/firebird directory by typing:

cd sql/firebird

First create the cccp user by typing:

gsec -user sysdba -password masterkey
GSEC> ADD cccp -pw cccp
GSEC> quit

To create the CCCP repository database you must first open the file database.sql in a text editor. By default it looks like this:

CREATE DATABASE '/home/firebird/cccp.fdb' USER 'cccp' PASSWORD 'cccp' PAGE_SIZE 8192;

The entry /home/firebird/cccp.fdb means where on disk shall your CCCP repository database be created. This must be an existing directory in which you have write access. On Windows you would probably prefer database.sql to look slightly like this:

CREATE DATABASE 'C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb' USER 'cccp' PASSWORD 'cccp' PAGE_SIZE 8192;

Now that the file database.sql is ready, you can create the database with the following command:

isql -u SYSDBA -p masterkey -i database.sql

Now load all the tables needed by CCCP Common Clan Portal by running the following commands, and please note that isql command requires the location of the database you just created as it's first argument:

isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i countries.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i gametypes.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i groups.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i ims.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i clanwars.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i clan_properties.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i forum.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i gameservers.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i history.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i idlers.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i links.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i sponsors.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i tagwall.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i users.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i visitors.sql
isql C:\Programmer\Firebird\Firebird_1_5\data\cccp.fdb -u cccp -p cccp -i news.sql

Voila, your CCCP repository database is installed and ready for use.

Now continue to the chapter Pircbot Plugin Framework (PPF) 0.4