Snipe-it: Whoops, looks like somethign went wrong

Created on 1 Dec 2017 · 7Comments · Source: snipe/snipe-it

Expected Behavior (or desired behavior if a feature request)

I have tried setting up a new Server 2016 VM to set up Snipe IT, and followed this video to do so:

https://www.youtube.com/watch?v=hnWqxbqN2Us

However, when I get to the point of trying to browse to http://localhost im greeted with "Whoops, looks like something went wrong.

Ive checked mysql details in the env, and seem to be ok. What I have ntoiced that only 2 of the 3 services are running. The mysql service isn't running, and won't run.

Actual Behavior

However, when I get to the point of trying to browse to http://localhost im greeted with "Whoops, looks like something went wrong.

Ive checked mysql details in the env, and seem to be ok. What I have ntoiced that only 2 of the 3 services are running. The mysql service isn't running, and won't run.

Please confirm you have done the following before posting your bug report:

[ ] I have enabled debug mode
[x ] I have read checked the Common Issues page

Provide answers to these questions:

Is this a fresh install or an upgrade? New
Version of Snipe-IT you're running 4.1..6
Version of PHP you're running - 7.0.23
Version of MySQL/MariaDB you're running - 5.7.19
What OS and web server you're running Snipe-IT on - Windows Server 2016
What method you used to install Snipe-IT (install.sh, manual installation, docker, etc) manual
WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
What specific Snipe-IT page you're on, and what specific element you're interacting with to trigger the error - http://localhost
If a stacktrace is provided in the error, include that too.
Any errors that appear in your browser's error console.
Confirm whether the error is reproduceable on the demo: https://snipeitapp.com/demo.
Include any additional information you can find in app/storage/logs and your webserver's logs.
Include what you've done so far in the installation, and if you got any error messages along the way.
Indicate whether or not you've manually edited any data directly in the database

Please do not post an issue without answering the related questions above. If you have opened a different issue and already answered these questions, answer them again, once for every ticket. It will be next to impossible for us to help you.

https://snipe-it.readme.io/docs/getting-help

not sure if bug

Source

paulod1982

Most helpful comment

Also, enable debug mode mate.

snug on 4 Dec 2017

👍3

All 7 comments

Sorry, forgot to add this from the .env file:

# --------------------------------------------
# REQUIRED: BASIC APP SETTINGS
# --------------------------------------------
APP_ENV=production
APP_DEBUG=false
APP_KEY=ChangeMe
APP_URL=null
APP_TIMEZONE='UTC'
APP_LOCALE=en

# --------------------------------------------
# REQUIRED: DATABASE SETTINGS
# --------------------------------------------
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_DATABASE=asset
DB_USERNAME=root
DB_PASSWORD=null
DB_PREFIX=null
DB_DUMP_PATH='/usr/bin'
DB_CHARSET=utf8mb4
DB_COLLATION=utf8mb4_unicode_ci

# --------------------------------------------
# OPTIONAL: SSL DATABASE SETTINGS
# --------------------------------------------
DB_SSL=false
DB_SSL_KEY_PATH=null
DB_SSL_CERT_PATH=null
DB_SSL_CA_PATH=null
DB_SSL_CIPHER=null

# --------------------------------------------
# REQUIRED: OUTGOING MAIL SERVER SETTINGS
# --------------------------------------------
MAIL_DRIVER=smtp
MAIL_HOST=email-smtp.us-west-2.amazonaws.com
MAIL_PORT=587
MAIL_USERNAME=YOURUSERNAME
MAIL_PASSWORD=YOURPASSWORD
MAIL_ENCRYPTION=null
[email protected]
MAIL_FROM_NAME='Snipe-IT'
[email protected]
MAIL_REPLYTO_NAME='Snipe-IT'

# --------------------------------------------
# REQUIRED: IMAGE LIBRARY
# This should be gd or imagick
# --------------------------------------------
IMAGE_LIB=gd

# --------------------------------------------
# OPTIONAL: SESSION SETTINGS
# --------------------------------------------
SESSION_LIFETIME=12000
EXPIRE_ON_CLOSE=false
ENCRYPT=false
COOKIE_NAME=snipeit_session
COOKIE_DOMAIN=null
SECURE_COOKIES=false

# --------------------------------------------
# OPTIONAL: SECURITY HEADER SETTINGS
# --------------------------------------------
REFERRER_POLICY=same-origin
ENABLE_CSP=false

# --------------------------------------------
# OPTIONAL: CACHE SETTINGS
# --------------------------------------------
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync

# --------------------------------------------
# OPTIONAL: REDIS SETTINGS
# --------------------------------------------
REDIS_HOST=null
REDIS_PASSWORD=null
REDIS_PORT-null

# --------------------------------------------
# OPTIONAL: AWS S3 SETTINGS
# --------------------------------------------
AWS_SECRET=null
AWS_KEY=null
AWS_REGION=null
AWS_BUCKET=null

# --------------------------------------------
# OPTIONAL: LOGIN THROTTLING
# --------------------------------------------
LOGIN_MAX_ATTEMPTS=5
LOGIN_LOCKOUT_DURATION=60

# --------------------------------------------
# OPTIONAL: MISC
# --------------------------------------------
APP_LOG=single
APP_LOG_MAX_FILES=10
APP_LOCKED=false
FILESYSTEM_DISK=local
APP_TRUSTED_PROXIES=192.168.1.1,10.0.0.1
ALLOW_IFRAMING=false
APP_CIPHER=AES-256-CBC

paulod1982 on 1 Dec 2017

Please provide answers to the questions you deleted.

Include any additional information you can find in app/storage/logs and your webserver's logs.

enlkq1k

snipe on 2 Dec 2017

Also, enable debug mode mate.

snug on 4 Dec 2017

👍3

Sorry guys, been out the office...

Ive turned debug mode on and now getting the following:

(3/3) QueryException SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from information_schema.tables where table_schema = asset and table_name = users)

in Connection.php (line 647)
at Connection->runQueryCallback('select * from information_schema.tables where table_schema = ? and table_name = ?', array('asset', 'users'), object(Closure))in Connection.php (line 607)
at Connection->run('select * from information_schema.tables where table_schema = ? and table_name = ?', array('asset', 'users'), object(Closure))in Connection.php (line 326)
at Connection->select('select * from information_schema.tables where table_schema = ? and table_name = ?', array('asset', 'users'))in MySqlBuilder.php (line 18)
at MySqlBuilder->hasTable('users')in Facade.php (line 221)
at Facade::__callStatic('hasTable', array('users'))in Setting.php (line 63)
at Setting::setupCompleted()in CheckForSetup.php (line 22)
at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php (line 17)
at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php (line 18)
at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php (line 17)
at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php (line 18)
at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php (line 17)
at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php (line 64)
at StartSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php (line 102)
at Pipeline->then(object(Closure))in Kernel.php (line 151)
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php (line 116)
at Kernel->handle(object(Request))in index.php (line 58)

I think I said above that MySQL service won't start, so I assume thats something to do with the connection being refused?

paulod1982 on 5 Dec 2017

The mysql service isn't running, and won't run.

Yep. That sounds like the problem. You'll need to figure out why MySQL won't start before you can continue.

snipe on 5 Dec 2017

Yeah, I don't think this is a bug in Snipe IT.

There is documentation all about hosting it on windows, WAMP and XAMPP.

I'd recommend going through the documentation at https://snipe-it.readme.io instead of just following a YouTube video.

snug on 6 Dec 2017

Hi,
i have similar issue with other exceptions. i don't understand where it is coming from.

Provide answers to these questions:
Is this a fresh install or an upgrade? - Fresh
Fresh install in a docker container. I am create a docker for Alpine OS. - No
Version of Snipe-IT you're running - latest
Version of PHP you're running - 5.6.36
Version of MySQL/MariaDB you're running - MarianDB 5.5.56
What OS and web server you're running Snipe-IT on - CentOS 7
What method you used to install Snipe-IT (install.sh, manual installation, docker, etc) - using git clone on composer
WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error

3/3) QueryException SQLSTATE[HY000] [2002] Permission denied (SQL: select * from information_schema.tables where table_schema = snipeit_data and table_name = users)

in Connection.php (line 647)
at Connection->runQueryCallback('select * from information_schema.tables where table_schema = ? and table_name = ?', array('snipeit_data', 'users'), object(Closure))in Connection.php (line 607)
at Connection->run('select * from information_schema.tables where table_schema = ? and table_name = ?', array('snipeit_data', 'users'), object(Closure))in Connection.php (line 326)
at Connection->select('select * from information_schema.tables where table_schema = ? and table_name = ?', array('snipeit_data', 'users'))in MySqlBuilder.php (line 19)
at MySqlBuilder->hasTable('users')in Facade.php (line 221)
at Facade::__callStatic('hasTable', array('users'))in Setting.php (line 68)
at Schema::hasTable('users')in Setting.php (line 68)
at Setting::setupCompleted()in CheckForSetup.php (line 22)
at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in TrustProxies.php (line 56)
at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php (line 17)
at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php (line 18)
at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php (line 17)
at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php (line 18)
at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php (line 17)
at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php (line 64)
at StartSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php (line 102)
at Pipeline->then(object(Closure))in Kernel.php (line 151)
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php (line 116)
at Kernel->handle(object(Request))in index.php (line 59)