Sponsored by CONduit in Salt Lake City, Utah.

Note: This site uses Stylesheets and Javascript. You appear to have them disabled, or your browser does not correctly support them.

There are likely some hardcoded paths in the code. For reference, the site I run has all of the condb code in a home directory for 'sfcon', so everything is located at:

/home/sfcon/condb

1. PERL SETUP

Install DBI and MySQL modules for perl, from the CPAN archives (cpan.org).

Create a link from the site_perl lib @INC path for ConDB to the condb-1.0/lib directory (ln -s ~wherever/condb-1.0/lib ConDB)

2. WEB SERVER SETUP

2.1. CGI Configuration

Map the CGI directory as appropriate to your web server. Example:

<Location condb>
    Options +ExecCGI
    [...auth bits]
</Directory>

2.2. mod_perl Configuration

Install and setup the core mod_perl, then configure the website to use mod_perl for the condb code:

<Location condb>
    SetHandler  perl-script
    PerlHandler Apache::Registry
    PerlSendHeader On
    Options +ExecCGI
    [...auth bits]
</Directory>

2.3. Web Authentication

Setup authentication for the same HTTP directory, something like:

<Location condb>
    AuthType Basic
    AuthName "Convention Committee"
    AuthUserFile [path to password file]
    require valid-user
</Directory>

ConDB uses REMOTE_USER as defined by Apache, if the user is authenticated.

3. SQL SERVER SETUP

• Create a SQL Database.. in mysql type:

  create database condb;

• Initialize the table definitions, stored in lib/Tables.mysql. You can easilly do this with something like:

  cat *.sql | mysql -u root -p condb

  Create a MySQL user and password used by the programs to access the database, this is not the same as the web/HTTP usernames. The database username/password will need to be stored in Configuration.pm.

  4. PATHS

  Nearly all of the configuration is handled in the Configuration.pm module. Page style is defined in the style/ directory, with the basename being the style name. Things to change in the Configuration module:

  • MySQL database, username and password
  • filesystem paths