linuxserver.io Posted September 27, 2020 Share Posted September 27, 2020 (edited) Application Name: Snipe-IT Application Site: https://github.com/snipe/snipe-it Docker Hub: https://hub.docker.com/r/linuxserver/snipe-it/ Github: https://github.com/linuxserver/docker-snipe-it Please post any questions/issues relating to this docker you have in this thread. If you are not using Unraid (and you should be!) then please do not post here, rather use the linuxserver.io forum for support. Edited September 27, 2020 by linuxserver.io Quote Link to comment
sysco Posted September 29, 2020 Share Posted September 29, 2020 I'm unable to access the webui, because docker won't pass port 8000 through. I'm using bridged networking. Could that be an issue? Quote Link to comment
SpyKiIIer Posted September 29, 2020 Share Posted September 29, 2020 I am seeing this same issue. Quote Link to comment
saarg Posted September 29, 2020 Share Posted September 29, 2020 (edited) 12 hours ago, sysco said: I'm unable to access the webui, because docker won't pass port 8000 through. I'm using bridged networking. Could that be an issue? Post your docker run command and container log. Edited September 29, 2020 by saarg Quote Link to comment
vuribe1221 Posted September 30, 2020 Share Posted September 30, 2020 I get errors on install. not sure what is relevant or helpful at this point but the debug logger gives be the above error. I already checked the port for mysql and user/pass as well yet it doesn't work. Any help is appreciated. Thanks snipeit.txt Quote Link to comment
saarg Posted September 30, 2020 Share Posted September 30, 2020 17 hours ago, vuribe1221 said: I get errors on install. not sure what is relevant or helpful at this point but the debug logger gives be the above error. I already checked the port for mysql and user/pass as well yet it doesn't work. Any help is appreciated. Thanks snipeit.txt 6 kB · 0 downloads You need to give the right permission to the snipe-it user in the database. You probably didn't allow any access outside the database container. Quote Link to comment
vuribe1221 Posted October 1, 2020 Share Posted October 1, 2020 I got passed the other error. I guess the username password wan't taking. My new question is, do I need to setup the database or should it setup the tables it needs to work. Seems like its asking for the schema of "users" table and "snipeit" table but they're empty. Quote Link to comment
SpyKiIIer Posted October 2, 2020 Share Posted October 2, 2020 On 9/29/2020 at 9:16 AM, SpyKiIIer said: I am seeing this same issue. When I attempt to load the application in my browser, all I get is a white screen. I am not seeing the errors the vuribe1221 is seeing. Looking at the database that was created, there doesn't seem to be any table created on the docker startup. Quote Link to comment
saarg Posted October 2, 2020 Share Posted October 2, 2020 6 hours ago, vuribe1221 said: I got passed the other error. I guess the username password wan't taking. My new question is, do I need to setup the database or should it setup the tables it needs to work. Seems like its asking for the schema of "users" table and "snipeit" table but they're empty. It says connection refused, so your database doesn't let snipe-it connect. Quote Link to comment
sysco Posted October 2, 2020 Share Posted October 2, 2020 On 9/29/2020 at 10:03 PM, saarg said: Post your docker run command and container log. docker run -d --name='snipe-it' --net='br0.10' --ip='192.168.210.101' -e TZ="Europe/Budapest" -e HOST_OS="Unraid" -e 'TCP_PORT_80'='8000' -e 'MYSQL_PORT_3306_TCP_ADDR'='192.168.210.100' -e 'MYSQL_PORT_3306_TCP_PORT'='3306' -e 'MYSQL_DATABASE'='snipe-it' -e 'MYSQL_USER'='root' -e 'MYSQL_PASSWORD'='Rr9p^vn3n(Q>Twxu' -e 'APP_URL'='192.168.210.101:8000' -e 'MAIL_PORT_587_TCP_ADDR'='' -e 'MAIL_PORT_587_TCP_PORT'='' -e 'MAIL_ENV_FROM_ADDR'='' -e 'MAIL_ENV_FROM_NAME'='' -e 'MAIL_ENV_ENCRYPTION'='' -e 'MAIL_ENV_USERNAME'='' -e 'MAIL_ENV_PASSWORD'='' -e 'APP_LOCALE'='' -e 'APP_DEBUG'='false' -e 'PUID'='99' -e 'PGID'='100' -v '/mnt/user/appdata/snipe-it':'/config':'rw' 'linuxserver/snipe-it' [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 01-envfile: executing... [cont-init.d] 01-envfile: exited 0. [cont-init.d] 10-adduser: executing... ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io ------------------------------------- To support the app dev(s) visit: Snipe-IT: https://snipeitapp.com/donate To support LSIO projects visit: https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-config: executing... [cont-init.d] 20-config: exited 0. [cont-init.d] 30-keygen: executing... using keys found in /config/keys [cont-init.d] 30-keygen: exited 0. [cont-init.d] 40-config: executing... [cont-init.d] 40-config: exited 0. [cont-init.d] 99-custom-files: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-files: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. Quote Link to comment
saarg Posted October 3, 2020 Share Posted October 3, 2020 13 hours ago, sysco said: docker run -d --name='snipe-it' --net='br0.10' --ip='192.168.210.101' -e TZ="Europe/Budapest" -e HOST_OS="Unraid" -e 'TCP_PORT_80'='8000' -e 'MYSQL_PORT_3306_TCP_ADDR'='192.168.210.100' -e 'MYSQL_PORT_3306_TCP_PORT'='3306' -e 'MYSQL_DATABASE'='snipe-it' -e 'MYSQL_USER'='root' -e 'MYSQL_PASSWORD'='Rr9p^vn3n(Q>Twxu' -e 'APP_URL'='192.168.210.101:8000' -e 'MAIL_PORT_587_TCP_ADDR'='' -e 'MAIL_PORT_587_TCP_PORT'='' -e 'MAIL_ENV_FROM_ADDR'='' -e 'MAIL_ENV_FROM_NAME'='' -e 'MAIL_ENV_ENCRYPTION'='' -e 'MAIL_ENV_USERNAME'='' -e 'MAIL_ENV_PASSWORD'='' -e 'APP_LOCALE'='' -e 'APP_DEBUG'='false' -e 'PUID'='99' -e 'PGID'='100' -v '/mnt/user/appdata/snipe-it':'/config':'rw' 'linuxserver/snipe-it' [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 01-envfile: executing... [cont-init.d] 01-envfile: exited 0. [cont-init.d] 10-adduser: executing... ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io ------------------------------------- To support the app dev(s) visit: Snipe-IT: https://snipeitapp.com/donate To support LSIO projects visit: https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-config: executing... [cont-init.d] 20-config: exited 0. [cont-init.d] 30-keygen: executing... using keys found in /config/keys [cont-init.d] 30-keygen: exited 0. [cont-init.d] 40-config: executing... [cont-init.d] 40-config: exited 0. [cont-init.d] 99-custom-files: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-files: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. I would suggest you read up on how docker containers work 🙂 If you give your container it's own IP on a custom bridge, you are in reality running in host mode and port mapping don't apply. So you have to use the container port, which is 80. Just go to the IP you gave it, and it should work. You also need to change the app URL. Quote Link to comment
Tabraxis Posted October 4, 2020 Share Posted October 4, 2020 Hello, I'm getting an "HTTP Error 500" when trying to visit the WebGUI link: http://192.168.3.7:8000/ Here's my container command compile: [email protected]:# /usr/local/emhttp/plugins/dynamix.docker.manager/scripts/docker run -d --name='snipe-it' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e 'MYSQL_PORT_3306_TCP_ADDR'='192.168.3.7' -e 'MYSQL_PORT_3306_TCP_PORT'='3306' -e 'MYSQL_DATABASE'='snipe-it' -e 'MYSQL_USER'='snipe-it' -e 'MYSQL_PASSWORD'='snipe-it' -e 'APP_URL'='192.168.3.7:8000' -e 'MAIL_PORT_587_TCP_ADDR'='' -e 'MAIL_PORT_587_TCP_PORT'='' -e 'MAIL_ENV_FROM_ADDR'='' -e 'MAIL_ENV_FROM_NAME'='' -e 'MAIL_ENV_ENCRYPTION'='' -e 'MAIL_ENV_USERNAME'='' -e 'MAIL_ENV_PASSWORD'='' -e 'APP_LOCALE'='' -e 'APP_DEBUG'='false' -e 'PUID'='99' -e 'PGID'='100' -p '8000:80/tcp' -v '/mnt/cache/appdata/snipe-it':'/config':'rw' 'linuxserver/snipe-it' 22ec63376d8a7c92c092ca72e8e2300521fce3991ea85ca1cfa060a088915c92 The command finished successfully! I have mariadb, instead of MySQL, could this be an issue or i'm missing something simple? (we are preparing to use this at work and I'm interested in playing around with this at home). Please let me know if you need any further information. Thanks, Quote Link to comment
saarg Posted October 4, 2020 Share Posted October 4, 2020 4 hours ago, Tabraxis said: Hello, I'm getting an "HTTP Error 500" when trying to visit the WebGUI link: http://192.168.3.7:8000/ Here's my container command compile: [email protected]:# /usr/local/emhttp/plugins/dynamix.docker.manager/scripts/docker run -d --name='snipe-it' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e 'MYSQL_PORT_3306_TCP_ADDR'='192.168.3.7' -e 'MYSQL_PORT_3306_TCP_PORT'='3306' -e 'MYSQL_DATABASE'='snipe-it' -e 'MYSQL_USER'='snipe-it' -e 'MYSQL_PASSWORD'='snipe-it' -e 'APP_URL'='192.168.3.7:8000' -e 'MAIL_PORT_587_TCP_ADDR'='' -e 'MAIL_PORT_587_TCP_PORT'='' -e 'MAIL_ENV_FROM_ADDR'='' -e 'MAIL_ENV_FROM_NAME'='' -e 'MAIL_ENV_ENCRYPTION'='' -e 'MAIL_ENV_USERNAME'='' -e 'MAIL_ENV_PASSWORD'='' -e 'APP_LOCALE'='' -e 'APP_DEBUG'='false' -e 'PUID'='99' -e 'PGID'='100' -p '8000:80/tcp' -v '/mnt/cache/appdata/snipe-it':'/config':'rw' 'linuxserver/snipe-it' 22ec63376d8a7c92c092ca72e8e2300521fce3991ea85ca1cfa060a088915c92 The command finished successfully! I have mariadb, instead of MySQL, could this be an issue or i'm missing something simple? (we are preparing to use this at work and I'm interested in playing around with this at home). Please let me know if you need any further information. Thanks, What does the container log say? Quote Link to comment
Tabraxis Posted October 4, 2020 Share Posted October 4, 2020 8 minutes ago, saarg said: What does the container log say? Hi, they don't say much different than sysco's... ErrorWarningSystemArrayLogin [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 01-envfile: executing... [cont-init.d] 01-envfile: exited 0. [cont-init.d] 10-adduser: executing... ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io ------------------------------------- To support the app dev(s) visit: Snipe-IT: https://snipeitapp.com/donate To support LSIO projects visit: https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-config: executing... [cont-init.d] 20-config: exited 0. [cont-init.d] 30-keygen: executing... using keys found in /config/keys [cont-init.d] 30-keygen: exited 0. [cont-init.d] 40-config: executing... [cont-init.d] 40-config: exited 0. [cont-init.d] 99-custom-files: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-files: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. Quote Link to comment
Z3RO Posted October 7, 2020 Share Posted October 7, 2020 On 10/2/2020 at 5:29 AM, SpyKiIIer said: When I attempt to load the application in my browser, all I get is a white screen. I am not seeing the errors the vuribe1221 is seeing. Looking at the database that was created, there doesn't seem to be any table created on the docker startup. Double check your database settings (db name, user and privileges) in the container and in your database. I had accidentally granted privileges to the wrong user and also got a blank white screen. I cleared the privileges on the incorrect user and then granted to the correct user and it worked. Quote Link to comment
Zambuck Posted October 10, 2020 Share Posted October 10, 2020 (edited) On 10/2/2020 at 4:31 PM, saarg said: It says connection refused, so your database doesn't let snipe-it connect. Try modifying your snipe-it user similar to this, by running the command as the root MySQL user, to ensure it uses mysql password authentication: alter user snipe-it identified with mysql_native_password by 'newpassword'; Make sure the password matches what's in your snipe-it docker setup of course. Edited October 10, 2020 by Zambuck clarification Quote Link to comment
vuribe1221 Posted October 12, 2020 Share Posted October 12, 2020 (edited) In the end I needed to delete the mariadb image and delete the docker instance for the correct user/pass to take effect. I used this guide in the end to setup the image (the key is generated automatically now so you can skip that step for the Snipe-IT docker). I'm on to a new issue. Is there a guide anywhere to setup the certs for ssl with Let's Encrypt or better yet the SWAG app? Using the docker I noticed it was http and it seems like the https port wasn't forwarded so as a temporary workaround I made the http port 90 and the https port 80. I'm looking to make the install work "as intended" with certs/https and general security practices followed. I also would like to use the SnipeIT app (for android if it matters) but I get an error that says "java.security.cert.CertPathValidatorException:..." and if I try to input the api key manually it says "It seems that https://empoleon:8000 is not a valid Snipe-IT Server". The dns does resolve correctly to my unraid server by the way and am able to reach and login to the app in Firefox on mobile using the name. Followed steps here for android app setup with no luck. https://github.com/diegogarciadev/android_snipeitapp_config Thanks Edited October 12, 2020 by vuribe1221 Quote Link to comment
saarg Posted October 12, 2020 Share Posted October 12, 2020 19 hours ago, vuribe1221 said: In the end I needed to delete the mariadb image and delete the docker instance for the correct user/pass to take effect. I used this guide in the end to setup the image (the key is generated automatically now so you can skip that step for the Snipe-IT docker). I'm on to a new issue. Is there a guide anywhere to setup the certs for ssl with Let's Encrypt or better yet the SWAG app? Using the docker I noticed it was http and it seems like the https port wasn't forwarded so as a temporary workaround I made the http port 90 and the https port 80. I'm looking to make the install work "as intended" with certs/https and general security practices followed. I also would like to use the SnipeIT app (for android if it matters) but I get an error that says "java.security.cert.CertPathValidatorException:..." and if I try to input the api key manually it says "It seems that https://empoleon:8000 is not a valid Snipe-IT Server". The dns does resolve correctly to my unraid server by the way and am able to reach and login to the app in Firefox on mobile using the name. Followed steps here for android app setup with no luck. https://github.com/diegogarciadev/android_snipeitapp_config Thanks You use https to swag and then internally from swag to snipe-it you use http. No need to change the http port and add https as port 80. Quote Link to comment
vuribe1221 Posted October 13, 2020 Share Posted October 13, 2020 (edited) Used this tutorial for setting up swag and reversed my previous port changes. Now I'm over at the swag topic nagging about getting a config file so the container is forwarded properly. https://www.youtube.com/watch?v=I0lhZc25Sro Thanks saarg Edited October 13, 2020 by vuribe1221 Quote Link to comment
saarg Posted October 13, 2020 Share Posted October 13, 2020 32 minutes ago, vuribe1221 said: Used this tutorial for setting up swag and reversed my previous port changes. Now I'm over at the swag topic nagging about getting a config file so the container is forwarded properly. https://www.youtube.com/watch?v=I0lhZc25Sro Thanks saarg Nagging won't help. The proxy-confs are often supplied by the users and not us. 1 Quote Link to comment
Tabraxis Posted October 18, 2020 Share Posted October 18, 2020 Hello All, Does anyone know where to change the date in the docker? for some reason mine thinks its Oct 25, 2020 around 3:29pm (as of today's date.) i went looking for .env and managed to change it to EST from PST, but i'm not seeing a line for the date, my Unraid is verified correct date/time. Thanks, Quote Link to comment
azzilla Posted November 3, 2020 Share Posted November 3, 2020 Has anyone had problems uploading logos? I can not see my uploaded logos after i saved them. Quote Link to comment
azzilla Posted November 3, 2020 Share Posted November 3, 2020 On 10/18/2020 at 5:32 PM, Tabraxis said: Hello All, Does anyone know where to change the date in the docker? for some reason mine thinks its Oct 25, 2020 around 3:29pm (as of today's date.) i went looking for .env and managed to change it to EST from PST, but i'm not seeing a line for the date, my Unraid is verified correct date/time. Thanks, I have this same issue. Where did you find the .env file though? Quote Link to comment
santiman717 Posted November 20, 2020 Share Posted November 20, 2020 I recently upgraded my snipe-IT docker container. I'm running into an issue where my user list doesn't display. I turned on debug and has this in the messages section. Quote 05:21:47] LOG.error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessories_users.note' in 'field list' in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:64 Stack trace: From what I understand this is caused by them adding new fields to the website, but then a migrate task doesn't happen correctly on the database side. From what I have seen from the Snipe-IT documentation, I need to run some commands in the project root. Specifically "php artisan migrate" Anyone had similar issues? Quote Link to comment
MiamiFinsFan13 Posted February 14, 2021 Share Posted February 14, 2021 On 10/4/2020 at 1:09 PM, Tabraxis said: Hello, I'm getting an "HTTP Error 500" when trying to visit the WebGUI link: http://192.168.3.7:8000/ Here's my container command compile: [email protected]:# /usr/local/emhttp/plugins/dynamix.docker.manager/scripts/docker run -d --name='snipe-it' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e 'MYSQL_PORT_3306_TCP_ADDR'='192.168.3.7' -e 'MYSQL_PORT_3306_TCP_PORT'='3306' -e 'MYSQL_DATABASE'='snipe-it' -e 'MYSQL_USER'='snipe-it' -e 'MYSQL_PASSWORD'='snipe-it' -e 'APP_URL'='192.168.3.7:8000' -e 'MAIL_PORT_587_TCP_ADDR'='' -e 'MAIL_PORT_587_TCP_PORT'='' -e 'MAIL_ENV_FROM_ADDR'='' -e 'MAIL_ENV_FROM_NAME'='' -e 'MAIL_ENV_ENCRYPTION'='' -e 'MAIL_ENV_USERNAME'='' -e 'MAIL_ENV_PASSWORD'='' -e 'APP_LOCALE'='' -e 'APP_DEBUG'='false' -e 'PUID'='99' -e 'PGID'='100' -p '8000:80/tcp' -v '/mnt/cache/appdata/snipe-it':'/config':'rw' 'linuxserver/snipe-it' 22ec63376d8a7c92c092ca72e8e2300521fce3991ea85ca1cfa060a088915c92 The command finished successfully! I have mariadb, instead of MySQL, could this be an issue or i'm missing something simple? (we are preparing to use this at work and I'm interested in playing around with this at home). Please let me know if you need any further information. Thanks, Did you ever find a solution for this? I'm getting the same error (although i am using MySql). The error occurs right after I advance to creating the tables in the setup. The tables are created in the DB so I'm not sure what the issue could be. Quote Link to comment
Recommended Posts
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.