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:
    IP or hostname (if the domain name has been set up/registered)
    Ssh username
    SSH password
    SSH port
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
1
ssh -p xxxx [email protected] zz.zz.zz.zz
Copied!
: 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:
1
yum –y install sudo
Copied!
5. Following this link to set up LAMP stack:
In step 3, replace this part:
with:
1
yum –y install firewalld
2
systemctl start firewalld
3
firewall-cmd --permanent --zone=public --add-service=http
4
firewall-cmd --permanent --zone=public --add-service=https
5
firewall-cmd --permanent --zone=public --add-port=7822/tcp
6
firewall-cmd –reload
7
systemctl enable firewalld
Copied!
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
1
yum -y install php-mysql php-gd php-mbstring php-pear zlib-devel ghostscript ImageMagick libreoffice
2
systemctl restart httpd
Copied!
7. Create a “download” folder; download OE (get the exact link from website: https://sourceforge.net/projects/enventory/files/?source=navbar ); unzip OE and copy to the right location:
1
mkdir download
2
cd download
3
wget https://sourceforge.net/projects/enventory/files/open_enventory_2018-02-21.zip
4
unzip open_enventory_2018-02-21.zip
5
cp -rp open_enventory_2018-02-21/. /var/www/html/oe
Copied!
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
1
vi /var/www/html/oe/.htaccess
Copied!
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
1
systemctl restart httpd
Copied!
12. Modify mysqld config:
1
vi /etc/my.cnf.d/server.cnf
Copied!
Right after [mysqld], add:
1
sql_mode = NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
2
max_allowed_packet = 64M # (or higher)
3
innodb_buffer_pool_size = 1024M # to about 50% of the available memory
Copied!
Save the file (hit Esc, type “:wq” and then Enter) and restart httpd and mariadb services
1
systemctl restart httpd mariadb
Copied!
You are done with the initial set up here. Open enventory is ready to be used at this time.
Last modified 1yr ago
Export as PDF
Copy link