LogoLogo
Modified Version by KVOriginal Source CodeContact
KV.2020-02-01
KV.2020-02-01
  • Overviews
  • Download
  • Contact
  • User Guides
    • Chemical Inventory
      • Database
        • Database Backup and Restore
        • Best Practice for SQL Users Backup
      • Chemicals
        • Search Chemicals
        • Add a single chemical
        • Import a list of chemicals
        • Edit Chemicals
        • Edit Multiple Chemical Containers
        • Move multiple chemical containers
        • Borrow and Return Chemicals
        • Delete a chemical container
        • Delete multiple chemical containers
      • Users
        • Create a New User
        • Create a Guest Account
        • Create Multiple Users
        • Change User Password
        • Modify User Permission, Information
        • Delete a User
        • Inactivate a User
      • Storages/Locations
      • Terminal Mode
        • Set Up a Terminal User
        • Borrow and Return Chemicals
        • Change Chemical Location
        • Get Information on a Chemical
        • Dispose of Chemicals
      • TODO
    • Electronic Lab Notebook
      • Getting Started with ELN
    • Barcode Scanner Settings
      • Taotronic Wireless Barcode Scanner
      • Honeywell MS9520 Barcode Scanner
  • Installation
    • CentOS 7
    • Mac OSX
    • Windows
    • Raspbian on Raspberry pi 3B
  • Advanced Settings
    • OE Settings
      • Turn On Import and Edit function for Chemical Containers
    • Useful SQL commands
    • Hosting Server Related
    • Resources for Setting Up New Server
    • Other Supporting Programs for OE
      • Find Missing SDS
      • Find Missing Structure
    • Docker Build
  • Change Logs
    • Versions
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Installation

Windows

PreviousMac OSXNextRaspbian on Raspberry pi 3B

Last updated 5 years ago

Was this helpful?

Step 1: Install this XAMPP from

Step 2: Copy/extract Open Enventory files into C://XAMPP/htdocs/ . Write down the folder name because this will be the web address. In this case the folder is named ‘enventory’

Step 3: Start XAMPP and start Apache and MySQL

Step 5: Change php.ini content by clicking on Config button on the same row with Apache on XAMPP panel to match the following:

  • error_reporting = E_ALL & ~E_WARNING & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED (otherwise some warnings being displayed will break the functionality)

  • safe_mode=Off

  • magic_quotes_gpc=Off

  • upload_max_filesize=64M # (or higher)

  • post_max_size=64M # (or higher)

If still warnings appear in the generated HTML code (breaking open enventory), you should set:

  • display_errors=Off # (especially on PHP 7+)

Step 6: Change my.cnf (or my.ini) content by clicking on Config button on the same row with MySQL on XAMPP panel to match the following under [mysqld] section:

[mysqld]
sql_mode = NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_allowed_packet = 64M # (or higher)

innodb_buffer_pool_size = 1024M # to about 50% of the available memory
innodb_log_file_size = 128M # to about 10% of the available memory

Step 7: Restart both Apache and MySQL service by clicking on Stop and then Start for each service.

  • "Database": <database-name> "database-name" can be whatever you choose but should not have blank space and unique; I suggest short name is better as well.

  • "Username": root (It has to be the exact word "root" for this set up first)

  • "Password": the root password that we set in the step above

  • Then click on "Inventory".

Step 9: If successful, it will bring up something similar to this page:

If you are locked from login due to incorrect entries of username and password (for 30 min), find the file named “openenv.log” which you can find in a similar path given below: C:\Users\sr\AppData\Local\Temp\ openenv.log

Step 4: setting up root password for MySQL. This changes with XAMPP version so consult this for specific details.

Step 8: Open this link in your web browser: and log in with the following info:

Open the file with any text editor program (Notepad), delete the content, save and restart XAMP and then try to access Open Enventory again ()

FAQ
http://localhost/enventory/
http://localhost/enventory/
https://www.apachefriends.org/download.html
XAMPP Panel
Example of display page after first successful login