This guide is created for new unmanaged VPS from A2hosting.com
OS: CentOS 7
Ram: 1GB
Hard drive: 20 GB
Bandwidth: 2 TB
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
Select “Yes” if asked to continue connecting
If there is a problem, follow this link:
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:
4. Optional: Setting up time by following this link:
5. Following this link to set up LAMP stack:
with:
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
7. Create a “download” folder; download OE (get the exact link from website: ); unzip OE and copy to the right location:
8. Go to
9. The OE website should load like screenshot below
10. If successful, this page will load:
11. Modify .htaccess file
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
12. Modify mysqld config:
Right after [mysqld], add:
Save the file (hit Esc, type “:wq” and then Enter) and restart httpd and mariadb services
You are done with the initial set up here. Open enventory is ready to be used at this time.
ssh -p xxxx yy@ zz.zz.zz.zzyum –y install sudoyum –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 firewalldyum -y install php-mysql php-gd php-mbstring php-pear zlib-devel ghostscript ImageMagick libreoffice
systemctl restart httpdmkdir 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/oevi /var/www/html/oe/.htaccesssystemctl restart httpdvi /etc/my.cnf.d/server.cnfsql_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 memorysystemctl restart httpd mariadb



