[Support] Linuxserver.io - Snipe-it


Recommended Posts

linuxserver_medium.png?v=4&s=4000

 

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 by linuxserver.io
Link to comment
17 hours ago, vuribe1221 said:

I get errors on install.
image.png.c36df8b092ac39c0136c78d4719c7251.png

 

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.

Link to comment
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.

Link to comment
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.

 

image.png.4a16298cc02e8c0d141e3988e538ce83.png

It says connection refused, so your database doesn't let snipe-it connect.

Link to comment
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.

 

Link to comment
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.

Link to comment

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:

root@localhost:# /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,

Link to comment
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:

root@localhost:# /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?

Link to comment
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.

Link to comment
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.

Link to comment
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 by Zambuck
clarification
Link to comment

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?
image.png.e07ec4b04e6aae89f029326512c26e38.png

 

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.
image.png.39de5e04e6f39a01bb24a2f3340b741b.png

 

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 by vuribe1221
Link to comment
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?
image.png.e07ec4b04e6aae89f029326512c26e38.png

 

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.
image.png.39de5e04e6f39a01bb24a2f3340b741b.png

 

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.

Link to comment

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.

image.png.68bcb147662c0c2f7874ae274b259d08.png


Thanks,

Link to comment
  • 3 weeks later...
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.

image.png.68bcb147662c0c2f7874ae274b259d08.png


Thanks,

I have this same issue. Where did you find the .env file though?

Link to comment
  • 3 weeks later...

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? 

Link to comment
  • 2 months later...
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:

root@localhost:# /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.

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.