Sunday, October 20, 2019

How To install Snipe-IT with LAMP On Ubuntu 18.04 LTS

Video Tutorial -  https://youtu.be/GEzvdyIk85Q

 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Snipe-IT is a free and open source web application for IT assets management. It is written on the Laravel 5.2 framework and uses MySQL to store its data. Snipe-IT is a complete and comprehensive solution for assets management, software license management, and much more.
LAMP-
Short for Linux, Apache, MySQL and PHP, an open-source Web development platform, also called a Web stack.
Offcial Website:https://snipeitapp.com/
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y ; apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

Create Mariadb Database :
mysql -u root -p
CREATE DATABASE snipeit_db character set utf8;
GRANT ALL PRIVILEGES ON snipeit_db.* TO 'snipeit_user'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
quit

curl -sS https://getcomposer.org/installer | php ; mv composer.phar /usr/local/bin/composer ; chmod +x /usr/local/bin/composer
cd /var/www/ ; git clone https://github.com/snipe/snipe-it snipe-it
cd /var/www/snipe-it ; cp .env.example .env
leafpad .env &>/dev/null
DB_CONNECTION=mysql
DB_HOST=localhost
DB_DATABASE=snipeit_db
DB_USERNAME=snipeit_user
DB_PASSWORD=password
DB_PREFIX=null
DB_DUMP_PATH='/usr/bin'
composer install --no-dev --prefer-source
php artisan key:generate
php artisan migrate
chown -R www-data:www-data /var/www/ ; chmod -R 755 /var/www/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/snipe-it/public/
     ServerName www.yourdomain.com

     <Directory /var/www/snipe-it/public/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

2 comments:

  1. i am able to complete the installation without any errors, but when i try opening the link in the browser, it ends up showing connection timed out. please help me out here

    ReplyDelete
    Replies
    1. Moreover, when I try opening the index.html file in var/www/snipe-it/ the output shows "
      D'oh. If you're seeing this, your DocumentRoot is set incorrectly. It should be set to the public directory." My config file reads as:


      ServerAdmin admin@yourdomain.com
      DocumentRoot /var/www/snipe-it/public
      ServerName www.yourdomain.com


      Options FollowSymlinks
      AllowOverride All
      Require all granted


      ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
      CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

      Delete