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

CentOS 7

This guide is created for new unmanaged VPS from A2hosting.com

  • OS: CentOS 7

  • Ram: 1GB

  • Hard drive: 20 GB

  • Bandwidth: 2 TB

INITIAL SETUP

  1. Login into A2 account, service to find the following info:

2. Connect to server using ssh. If you are on a Mac, use Terminal and type in the following command. If you are on a Window, you can use CMD (if CMD does not work, google “connecting to ssh on Window” to find the program

ssh -p xxxx yy@ zz.zz.zz.zz

: xxxx: port number yy: username zz.zz.zz.zz: ip or hostname

Select “Yes” if asked to continue connecting

3. To secure your ssh and your server, set up new user and deactivate root login via SSH by following steps 2, 3, and 5 in this tutorial:

Install sudo by:

yum –y install sudo

5. Following this link to set up LAMP stack:

In step 3, replace this part:

with:

yum –y install firewalld
systemctl start firewalld
firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
firewall-cmd --permanent --zone=public --add-port=7822/tcp
firewall-cmd –reload
systemctl enable firewalld

In step 4: choose PHP7.2

Follow this tutorial from steps 1-5, make sure instruction for specific steps as indicated above

6. Install the following packages to prepare for Open enventory

yum -y install php-mysql php-gd php-mbstring php-pear zlib-devel ghostscript ImageMagick libreoffice
systemctl restart httpd

mkdir download
cd download
wget https://sourceforge.net/projects/enventory/files/open_enventory_2018-02-21.zip
unzip open_enventory_2018-02-21.zip
cp -rp open_enventory_2018-02-21/. /var/www/html/oe

With xx.xx.xx.xx: is the server’s ip address

9. The OE website should load like screenshot below

  • Database: choose the desired database’s name

  • Username: root

  • Password: use the mariadb password that was set up in step 5 of this tutorial

10. If successful, this page will load:

11. Modify .htaccess file

vi /var/www/html/oe/.htaccess

Modify the content of the file as in this screenshot. Important: these setting is for the server with configuration as indicated in the top of this tutorial

Save the file (hit Esc, type “:wq” and then Enter) and restart httpd service

systemctl restart httpd

12. Modify mysqld config:

vi /etc/my.cnf.d/server.cnf

Right after [mysqld], add:

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

Save the file (hit Esc, type “:wq” and then Enter) and restart httpd and mariadb services

systemctl restart httpd mariadb

You are done with the initial set up here. Open enventory is ready to be used at this time.

PreviousHoneywell MS9520 Barcode ScannerNextMac OSX

Last updated 5 years ago

Was this helpful?

If there is a problem, follow this link:

4. Optional: Setting up time by following this link:

7. Create a “download” folder; download OE (get the exact link from website: ); unzip OE and copy to the right location:

8. Go to

https://www.a2hosting.com/kb/getting-started-guide/accessing-your-account/using-ssh-secure-shell
https://www.digitalocean.com/community/tutorials/initial-server-setup-with-centos-7
https://www.tecmint.com/set-time-timezone-and-synchronize-time-using-timedatectl-command/
https://www.howtoforge.com/tutorial/centos-lamp-server-apache-mysql-php/
https://sourceforge.net/projects/enventory/files/?source=navbar
http://xx.xx.xx.xx/oe