search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
11.01k stars 3.18k forks source link

Snipe-It Installation on IIS (confusing at best) #2883

Closed brudnicke closed 7 years ago

brudnicke commented 7 years ago

Is there a clear, concise, step by step install guide for making Snipe-It work on Windows Server 2012 using IIS? I'm finding bits and pieces here, but they are referencing PHP, database, etc, and no where does it show where I get these programs, what versions, when/where to install.

The IIS setup document only tells me how to create the site, and adjust permissions. The dependencies page only states to download and run composer from the snipe-it directory. That program is asking for some type of PHP command.

brudnicke commented 7 years ago

Thanks. The website came up to the config page. It seems to have passed all the checks, but when I click create database tables, it goes to a “Whoops, something went wrong” page.

The information including any attachments contained in this document is confidential and is for the use only of the intended recipient. If you are not the intended recipient, you should notify the sender and delete this message immediately. Any distribution, disclosure, or copying of this message, or the taking of any action based on its contents is strictly prohibited.

Birkey’s Farm Store, Inc.

JExactly commented 7 years ago

I would check your laravel logs now

JExactly commented 7 years ago

Sounds like your database user doesn't have rights to do what it needs to the snipeit database you created. https://snipe-it.readme.io/v3.0/docs/creating-a-database-and-db-user

JExactly commented 7 years ago

Were you able to resolve this @brudnicke ??

brudnicke commented 7 years ago

No. I’ve gone through the permissions again, and checked the database settings, but it still won’t let me continue on to the ‘configure tables’ portion of setup.

From: JExactly [mailto:notifications@github.com] Sent: Wednesday, November 16, 2016 4:56 PM To: snipe/snipe-it Cc: Brian Rudnicke; Mention Subject: Re: [snipe/snipe-it] Snipe-It Installation on IIS (confusing at best) (#2883)

Were you able to resolve this @brudnickehttps://github.com/brudnicke ??

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/snipe/snipe-it/issues/2883#issuecomment-261099704, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AWLwthsAx0INiGwp6elL-CyeD7sVjinjks5q-4oUgaJpZM4Kpjlt.

The information including any attachments contained in this document is confidential and is for the use only of the intended recipient. If you are not the intended recipient, you should notify the sender and delete this message immediately. Any distribution, disclosure, or copying of this message, or the taking of any action based on its contents is strictly prohibited.

Birkey’s Farm Store, Inc.

JExactly commented 7 years ago

I would check your logs and drop them here

seanandcara commented 7 years ago

@brudnicke, it sounds like @JExactly is correct that your database user might not have permissions to create the tables. Hopefully, this is resolved and you're using Snipe-IT successfully.

However, if not I may be able to help. At this stage of the install process, a co-worker and I were having all sorts of problems with the URL Rewrite rules:

  1. There were already URL Rewrite rules before importing the .htaccess rules, so we cleared those out.
  2. After attempting to import the .htaccess file, the last rule was not able to be understood by IIS - per the developer, I removed the last rule (see https://github.com/snipe/snipe-it/issues/2489).
  3. After fighting with it for a while longer, we also figured out that the first rule was forcing HTTPS, so either you can remove that rule or set up SSL on your server (we chose the latter).

I'll attach the Windows Server/IIS install instructions that I made while going through this process. We have been using Snipe-IT successfully for a few months now and I've used the process on multiple test servers, so I think it's ready to be shared - I hope you find it helpful.

Snipe-IT Install Instructions on IIS - SHARE.pdf

JExactly commented 7 years ago

Nothing is attached, You will likely have to do it through the web.

brudnicke commented 7 years ago

Here is the laravel log.

laravel.TXT

JExactly commented 7 years ago

@brudnicke All the errors in the log that I am reading, It appears that a connection to your database is not happening and therefor it cannot complete its steps. I would recommend double checking the database steps listed here: https://snipe-it.readme.io/v3.6.1/docs/creating-a-database-and-db-user (maybe start over with them to make sure everything is fresh and set properly)

Is this a mysql DB? Can you supply what is listed in your .env file under : `# --------------------------------------------

REQUIRED: DATABASE SETTINGS

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

DB_CONNECTION=mysql DB_HOST=localhost DB_DATABASE=null DB_USERNAME=null DB_PASSWORD=null DB_PREFIX=null DB_DUMP_PATH='

JExactly commented 7 years ago

@brudnicke Did you get this resolved?

brudnicke commented 7 years ago

No. I re-rant the database setup, but I still get the same “whoops, something went wrong” error.

From: JExactly [mailto:notifications@github.com] Sent: Tuesday, December 13, 2016 9:34 AM To: snipe/snipe-it Cc: Brian Rudnicke; Mention Subject: Re: [snipe/snipe-it] Snipe-It Installation on IIS (confusing at best) (#2883)

@brudnickehttps://github.com/brudnicke Did you get this resolved?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/snipe/snipe-it/issues/2883#issuecomment-266770051, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AWLwtnJgVxn1REBcuK1kkr-2gNKVQLVpks5rHrrtgaJpZM4Kpjlt.

The information including any attachments contained in this document is confidential and is for the use only of the intended recipient. If you are not the intended recipient, you should notify the sender and delete this message immediately. Any distribution, disclosure, or copying of this message, or the taking of any action based on its contents is strictly prohibited.

Birkey’s Farm Store, Inc.

JExactly commented 7 years ago

Is your DB located on your localhost?

brudnicke commented 7 years ago

Yes.

From: JExactly [mailto:notifications@github.com] Sent: Tuesday, December 13, 2016 10:10 AM To: snipe/snipe-it Cc: Brian Rudnicke; Mention Subject: Re: [snipe/snipe-it] Snipe-It Installation on IIS (confusing at best) (#2883)

Is your DB located on your localhost?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/snipe/snipe-it/issues/2883#issuecomment-266781015, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AWLwtqzt1NJZIsFJMS-C6w22W1BRh9ipks5rHsNagaJpZM4Kpjlt.

The information including any attachments contained in this document is confidential and is for the use only of the intended recipient. If you are not the intended recipient, you should notify the sender and delete this message immediately. Any distribution, disclosure, or copying of this message, or the taking of any action based on its contents is strictly prohibited.

Birkey’s Farm Store, Inc.

JExactly commented 7 years ago

have you tried updating to the latest version to see if your issue was a bug that was fixed? I know there was mention of fixes related to Pre-flight issues. Which is where you seem to be having problems.