Create a MySQL Database and Authorized User
BCOE&M must have access to a MySQL database to function. The database can either be one dedicated to your installation or one that is shared with other applications.
For a dedicated MySQL database:
- Using your web hosting provider's chosen methodology, create a database to connect your BCOE&M installation to. Consult your hosting provider's documentation as needed.
- Create and/or add an authorized user to the database. Again, consult your hosting provider's documentation as needed.
- Make sure the user has the following privileges (at minimum):
For use with a shared database:
- Obtain the database name and authorized user credentials.
- See Upload Files to Your Webserver below.
Upload Files to Your Webserver
- Unzip the BCOE&M archive file locally.
- Locate the "sites" sub-folder in unzipped archive.
- Using a text editor or your favorite WYSIWYG editor, open the config.php file in the "sites" folder.
- Add username, password, and database variables for your BCOE&M installation's MySQL database.
- If the installation will be using a shared MySQL database, you must designate a prefix in the $prefix variable (e.g. comp_).
- Change the $setup_free_access variable to TRUE. Set up cannot be run if this variable is set to FALSE.
- Connect to your webserver via FTP.
- Upload all files and folders in the unzipped archive.
- Change the CHMOD permissions for the "mods" folder and the "user_images" folder to 755 - this allows for uploads.
- Finally, if you are receiving server errors after trying to access your installation, check here.
Proceed Through the Set Up Process
Browse to your installation's web address.
- If you receive any errors such as Table 'xxx.system' doesn't exist, try accessing the setup script directly by going to [your website address]/setup.php?section=step0.
You'll be taken through a series of steps to install the needed database tables and to customize your installation.
- Do not skip these steps. Vital information is collected that optimize the installation's behavior and display of data.
- During the set up process you will:
- Add the necessary database tables.
- Create the administrator's user file and credentials.
Define the site's preferences.
Input information about your competition (e.g., rules, award structure, etc.)
Input drop-off locations.
Input judging locations.
Define the BJCP styles accepted.
Define judging preferences (e.g., whether to use queued judging, flight size, maximum number of rounds, etc.).
- EDIT the config.php file. Change the $setup_free_access variable back to FALSE and re-upload to your server. This is a security measure.
That's it! After set up, you can browse to your installation's address, log in and further customize it, and/or distribute the web address to begin collecting participant data and their associated entries.
Enjoy your favorite fermented beverage.