Step 2 - Database installation

What you need to know and do
 
The Database installation step is where Jomres adds the tables it needs to perform, or upgrades existing tables to bring your installation up to date. This is all done by a script called install_jomres.php. You should always run it after installing or upgrading Jomres.
 
install_jomres.php will either be a link provided by the web installer, or you will need to access it manually. If you need to access it manually, for example after a manual install, launch your web browser and then navigate to where you uploaded Jomres. e.g. if you uploaded to http://www.domain.com/ then you would access the installer/upgrader by going to http://www.domain.com/jomres/install_jomres.php.
 
Once you've run install_jomres.php then assuming that it's found that it can create all the files and directories that it needs then it will give you a GO button. Click this to continue. It will output information about what it's done and when it's finished you can go to your Administration page and begin configuring the system.
 
Further information
 
When it runs install_jomres.php checks that certain directories exist, and if not that it can create them. This is done because the web server needs to ensure that it has write access to those directories. If it can't then the installer script will give you the full path of the directory it needs to create and stop running, and then you'll need to make those directories and/or give the web server write access to them. Typically this is done by creating the folder and changing the ownership of it so that it's owned by the web server, but depending on the server you may meet varying levels of success. This is why it's advisable that you use the web installer wherever possible, and that preferably you are using a SUexec enabled server so that when you want to modify Jomres files later you can without wrestling with file permissions.
 
install_jomres.php does the following :
 
  1. Jomres will do some preliminary checks. Once it is happy it will offer you a "Go" button to begin the database table creation. Click on it to continue.
  2. When you click the Go button Jomres will then check to see if the typical Jomres tables exist in your database. If they do not then a new install is assumed. It will create all of the mySql tables that it needs, it will insert some sample data, it will create your property specific settings and it will make admin a super property manager.
  3. When this is all done you are almost ready to use Jomres, but before you do that you should remove the file ''/jomres/install_jomres.php''.
  4. You can now go to your CMS's administrator area and view your Jomres installation. Don't forget to add Jomres to a menu so that you can view it from the front end, this is where most of your property management is performed.
  5. Joomla 1.6 only : Once you've performed the installation, you'll need to use Joomla 1.6's Discover feature in ''Extensions -> Extension Manager''. Use this to discover and install Jomres. The same goes for any Jomres Joomla modules that are installed via the Jomres Plugin Manager.
 
This document is copyright Vince Wooll/Woollyinwales IT, 2011. All rights reserved.