About this module

• The inventory module is an external application that can be used to track inventory in relation with helpdesk tickets/issues.
• The module does not have to be on the same server as the helpdesk application, but needs to have access to the helpdesk database.
• You could use the same database for both, but it is not recommended.
• The inventory module is written entirely in PHP.

Installation

1. Download the inventory source and unpack it into the directory you want it in.
2. Create a database for your inventory module, and execute the initial SQL found in the sql directory.

   mysql  -udb_user  -pdb_pass  -hdb_host  db_name < tables-mysql.sql

3. Copy the config-dist.php file to config.php:

   bash@localhost:/var/www/helpdesk/$ cd inventory/includes/
   bash@localhost:/var/www/helpdesk/inventory/includes$ cp config-dist.php config.php

4. Update the configuration document to reflect your helpdesk / server configuration:

   ...
   define("INVENTORY_SERVER", "someotherserver.net");
   define("INVENTORY_USERNAME", "inventory");
   define("INVENTORY_PASSWORD", "");
   define("INVENTORY_DB_NAME", "inventory");
   
   define("HELPDESK_SERVER", "someserver.net");
   define("HELPDESK_USERNAME", "helpdesk");
   define("HELPDESK_PASSWORD", "");
   define("HELPDESK_DB_NAME", "helpesk");
   
   define("HELPDESK_ROOT_URL", "http://yourdomain.com/helpdesk/");   // this should end with a '/'
   define("INVENTORY_ROOT_URL", "http://yourdomain.com/helpdesk/inventory");  // this should NOT end with a '/'
   ...

5. Update your defines.php on lines 8 and 28 to enable authentication for the inventory application:

   ...
   //set this to false if not going to connect to an inven db
   define ("USING_INVEN",true);
   ...
   if(USING_INVEN){
     $inven_groups = array("1" => "techs","2"=>"managers","3"=>"admins");
   }
   ...

   Line 28 defines which helpdesk groups are allowed to use the inventory module.

6. Update your helpdesk parameters to enable the inventory module and set the database information for your inventory database. These are at the bottom of the params page (Click on "Parameters", scroll to bottom and look for inven_* settings).
7. You should now be able to access the application from the URL you defined in the last line of your config above (INVENTORY_ROOT_URL).