Snipe-IT is a free and open source web based application for IT asset management, to enable IT departments to track who has which laptop, when it was purchased, which software licenses and accessories are available, and so on.
This means there there is no executable file (aka no .exe files), and it must be run on a web server and accessed through a web browser. Some of it's features are listed below, have a look at them:
Easily see which assets are assigned, to whom, and their physical location
Require User Acceptance on Checkout
Email alerts for expiring warrantees and licenses
Add your own custom fields for additional asset attributes
Easily import and export assets
Optional digital signatures on asset acceptance
You'll need a CentOS 7 server and a normal user with root user privileges over it to follow this guide for installing Snipe-IT on your server. You can switch between non root user to root user using sudo -i command. It is recommended to install Snipe-IT on a freshly updated server so run below given command and it'll do the job for you.
yum -y update
Installing Apache Web Server
Once the system is updated, you can install the dependencies required. To install Snipe-IT you will need to install the Apache web server along with MaraiDB and PHP with a few extensions.
Run the following command to install the Apache web server.
yum -y install httpd
Now you can start Apache and enable it to start at boot time, using the following commands.
You can check status of mariaDB using this below given command and you should see following output.
systemctl status mariadb.service
[root@Sajid ~]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-02-08 14:47:40 UTC; 22s ago
Main PID: 18035 (mysqld_safe)
├─18035 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─18192 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/ma...Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: The latest information about MariaDB is available at http://mariadb.org/.
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: You can find additional information about the MySQL part at:
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: http://dev.mysql.com
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: Support MariaDB development by buying support/new features from MariaDB
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: Corporation Ab. You can contact us about this at email@example.com.
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: Alternatively consider joining our community based development effort:
Feb 08 14:47:38 ip-172-31-22-142 mariadb-prepare-db-dir: http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Feb 08 14:47:39 ip-172-31-22-142 mysqld_safe: 170208 14:47:39 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Feb 08 14:47:39 ip-172-31-22-142 mysqld_safe: 170208 14:47:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Feb 08 14:47:40 ip-172-31-22-142 systemd: Started MariaDB database server.
We recommend you make sure that this installation is secure and to do so run following command.
You'll be asked to provide a root password so enter an appropriate password and answer yes to all questions by pressing Y.
Now you'll have to create a database for Snipe-IT so please follow the instructions.
mysql -u root -p
You'll be asked to enter password so simply enter a password and now execute the following queries to create a new database.
CREATE DATABASE snipeit_data;
The above query will create a database named snipeit_data. For the database you can use any name you prefer in the place of snipeit_data. Make sure that you use semicolon at the end of each query as a query always ends with a semicolon. Once the database is created you can create a new user and grant the required permissions to the user for the database.
CREATE USER 'snipeit_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username snipeit_user. You can use any preferred username instead of snipeit_user. Replace StrongPassword with a strong password.
Now provide the appropriate privileges to your database user over the database you have created. Run the following query to do so.
GRANT ALL PRIVILEGES ON snipeit_data.* TO 'snipeit_user'@'localhost';
Now run the following query to immediately apply the changes on the database privileges.
Now you can exit from MariaDB prompt using following command.
We will have to install PHP to install Snipe-IT as we know it is written using Laravel framework. So run below given commands to install PHP.
We have installed all the dependencies required to install Snipe-IT and now we are ready to install it from git.
If in case you don't have git already installed on your server then you can install it using yum -y install git.
Now switch to web root directory of apache web server and clone the latest version of Snipe-IT using these commands:
cd /var/www/git clone https://github.com/snipe/snipe-it snipe-it
Create the .env file like shown below and replace filename with your own filename.
cd /var/www/snipe-itcp .env.filename .env
Next, edit .env file using any text editor here we are using nano text editor.
nano .env Find the following lines and edit the values.
APP_URL=null #Provide yourdomainname or IP address here
APP_TIMEZONE='UTC' #Change it according to your country
DB_DATABASE=null #Provide the database name you created earlier
DB_USERNAME=null #Provide database user's username
DB_PASSWORD=null #Provide the DB user's password
Save the file and exit from the text editor.
Next, you'll have to set proper ownership and file permission, So run following commands.
nano /etc/httpd/conf.d/snipeit.example.com.conf Add below given content to the file then save and exit from text editor.
Options Indexes FollowSymLinks MultiViews
allow from all
Finally restart your apache web server using systemctl restart httpd
You've installed Snipe-IT on your CentOS 7 server completely and now you can configure it through your web browser. Open up your favourite web browser and point it to IP address of your CentOS server http://YourServerIP and finish the installation wizard.
In this tutorial you've learned how to install Snipe-IT on your CentOS 7 server. you also learned to configure Snipe-IT and we hope now you have enough knowledge to work with Snipe-IT.
Truth be told, it’s difficult for a web application that doesn’t have some kind of identification, even if you don’t see it as a security measure in and of itself. The Internet is a kind of lawless land, and even on free services like Google’s, authentication ensures that abuses will...
Although data persistence is almost always a fundamental element of applications, Node.js has no native integration with databases. Everything is delegated to third-party libraries to be included manually, in addition to the standard APIs. Although MongoDB and other non-relational databases are the most common choice with Node because if you...