Progeny42 Posted September 5, 2020 Share Posted September 5, 2020 (edited) Snipe-IT is an Asset Management System. This guide will help you to install it and get it running. Database Backend Installing MariaDB Snipe-IT requires MySQL or MariaDB as its database backend. We’ll be using MariaDB. Head over to Community Applications and pull MariaDB. I left the Host Port as 3306, but ensure it doesn’t conflict with any existing containers. If you change it you will need to use the custom value in the Snipe-IT configuration later. You’ll need to setup a root password in Key 3, and it must be at least 4 characters long. Now Apply to install the container. Creating a Database and User Snipe-IT requires that we setup a Database and User in preperation for the installation, so let’s do that. In the Docker tab, click on mariadb and select the Console option, which will open a Bash shell into the container. To login to the database, you’ll need to execute the following command: mysql -u root -p It will now ask for the password. This is the root password that we just configured in the template. To create a database, user and password for Snipe-IT, execute the following commands: CREATE DATABASE databasename; CREATE USER username IDENTIFIED BY 'password'; GRANT ALL ON databasename.* TO 'username'; Disabling Strict Mode Snipe-IT requires that Strict Mode is disabled for installation and setup. To ensure we put it back correctly after installation, we’ll be collecting the current values first. Execute the following command in the Bash shell to select all values. SELECT @@SQL_MODE; Copy all of the modes. Mine were; STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Repeat this process for @@GLOBAL.SQL_MODE using the below command: SELECT @@GLOBAL.SQL_MODE; Now to disable Strict Mode, execute the following two commands: SET @@SQL_MODE = ''; SET @@GLOBAL.SQL_MODE = ''; Installing Snipe-IT I’ve put together a template for Snipe-IT in Community Applications, so it should just be a process of filling out the required values. Head over to Community Applications and search for snipe-it, and install it. There are quite a lot of options that need filling out, but they are all required. My configuration looks like this (fill out your own details where applicable) MySQL Database Name: databasename MySQL Username: username MySQL Password: password MySQL Database Host: 192.168.0.3 MySQL Database Port: 3306 SMTP Address: smtp.mail.yahoo.com SMTP Port: 465 SMTP From Address: [email protected] SMTP From Name: john doe SMTP Encryption: tls SMTP Username: [email protected] SMTP Password: your email password App Key: LEAVE THIS BLANK FOR NOW App URL: http://192.168.0.3:8087 App Timezone: Europe/London App Locale: en-GB Port: 8087 Ensure that Port and App URL use the same port number in the event that you change it. Ensure that MySQL Database Port is correct. Before hitting apply, we need to generate the App Key! Open the Unraid Terminal and run the following command: openssl rand -base64 32 This should produce something along the lines of: cbWIMLG/JSqLhEvZsRh7v37KfKL2CAwApn64oEEOTjI= Copy the value, and in the App Key field, enter base64:yourappkeyhere. Your App Key field should look like the following: base64:cbWIMLG/JSqLhEvZsRh7v37KfKL2CAwApn64oEEOTjI= Hit Apply to install the container. Setup Snipe-IT Once installed, go to the Docker tab and open the Web-UI for Snipe-IT. UPDATE: Whoops, looks like something went wrong. If you see the error "Whoops, looks like something went wrong.", this is likely an issue with your App Key (As experienced by myself and another member). Unfortunately, the Container log file won't say that the App Key is the problem. Go back in this guide, and ensure that your App Key is setup and valid. If the problem persists, check the Container log file for anything else, hopefully it will indicate why it's not loading properly. If everything went well, you should be presented with the Snipe-IT Pre-Flight page. Unfortunately, SMTP isn’t working for me, I’m not sure why, as I’ve setup SMTP using the same settings elsewhere. UPDATE: I've had confirmation that other email's are working, so it's likely just something to do with Yahoo accounts. Assuming all is green (except for Email), hit the Next: Create Database Tables button – BE PATIENT! I’m running this container on an SSD and it took nearly 2 minutes for this step to complete. Once complete, hit the Next: Create User button. At this point, fill out your details as appropriate, and then you should be presented with the User Interface. Re-Enabling Strict Mode We want to ensure that MariaDB maintains its integrity, especially if you currently / will use it for other uses. Open up a Bash shell for MariaDB again, and log in using the command from earlier. Once in, execute the following command, substituing your SQL_MODES save from earlier where applicable. My command looked like: SET @@SQL_MODE = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; Again, perform this command for @@GLOBAL.SQL_MODE. And that’s it, you should be all up and running! Now to spend hours inputting all my data… Edited September 7, 2020 by Progeny42 Update to SMTP, and App Key problems 1 Quote Link to comment
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.