Server Installation
You must have a valid installation of mysql (i've been using 3.23.47 in development).
  1. If you downloaded the win32 exe, simply double click this file and follow the prompts for installation. The install will create a new system variable called OOPS_HOME, which points to where you installed OOPS.
    If you downloaded the zip file, unzip the files into a desired directory and create a new system property pointing to this directory called OOPS_HOME
  2. Browse to the installation directory and locate the oops.sql file. This file contains the correct db structure for OOPS. Execute the sql in this file against a new database.
  3. Step 3: Locate your oops.properties file and modify the settings to suite your environment. As the server administrator you should have all the information you need. In any case, example values are described in the properties file.
  4. Step 4: Start up a dos prompt and browse the directory tree to your oops installation. Go to the same directory as the file oops-setup.bat. Execute this file with the following command:

    C:\oops> oops-setup.bat

    This will execute a class file that checks for database connectivity and checks for an administrative user in the database. If one is not found, it will create one with the default settings.

  5. Execute the oops.bat file with the following command:

    C:\oops> oops.bat

    This will start the application and prompt you to login. Enter the default user name and password described in step 4. Go to File > My Details in the menu and modify the settings there to suite - i highly recommend changing the username and password.

  6. Create other users as required, giving them the required permissions to add projects, users, components and releases.
  7. I suggest locking down the database, giving your users only the rights to perform the desired functions against the oops database. Each user will require at least the ability to SELECT/CREATE/MODIFY/DELETE rows in all the oops tables. You may want to restrict their rights against other databases you may have. In any case I suggest you read some or all of the following in regards to setting up mySQL permissions:

    - www.devshed.com

    - www.mysql.org

  8. Your done. You should now be able to set up your client users.