0504.html 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. <!DOCTYPE html>
  2. <html lang="en" xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <title>Self-hosted Asset Management System with Snipe-IT on Windows</title>
  5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  6. <meta charset="UTF-8">
  7. <meta name="keywords" content="Browser Based,Home Lab,Home Lab Ideas,Install Guide,Self-Hosted,Web Based,Web Based Tools,Asset Management,IT Asset Management,Free Software,Snipe-IT,Windows,Microsoft Windows,PHP,MySQL,MariaDB,XAMPP,Apache HTTPD,How To,Tutorial,i12bretro">
  8. <meta name="author" content="i12bretro">
  9. <meta name="description" content="Self-hosted Asset Management System with Snipe-IT on Windows">
  10. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11. <meta name="revised" content="12/23/2023 09:44:35 AM" />
  12. <link rel="icon" type="image/x-icon" href="includes/favicon.ico">
  13. <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
  14. <script type="text/javascript" src="includes/js/steps.js"></script>
  15. <link href="css/steps.css" rel="stylesheet" type="text/css" />
  16. </head>
  17. <body>
  18. <div id="gridContainer">
  19. <div class="topMargin"></div>
  20. <div id="listName" class="topMargin">
  21. <h1>Self-hosted Asset Management System with Snipe-IT on Windows</h1>
  22. </div>
  23. <div></div>
  24. <div id="content">
  25. <ol>
  26. <li>Download XAMPP <a href="https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/" target="_blank">Download</a></li>
  27. <li>Download Snipe-IT <a href="https://github.com/snipe/snipe-it/releases/latest" target="_blank">Download</a></li>
  28. <li><label for="cb_li_917989_0">Download Microsoft Visual C++ </label><label for="cb_li_917989_0"><a href="https://aka.ms/vs/16/release/vc_redist.x64.exe" target="_blank">Download</a></label></li>
  29. <li><label for="cb_li_917989_0">Download Composer <a href="https://getcomposer.org/Composer-Setup.exe" target="_blank">Download</a></label></li>
  30. <li>Install Microsoft Visual C++</li>
  31. <li>Right click the downloaded XAMPP .zip file &gt; Extract All...</li>
  32. <li>Right click the downloaded Snipe-IT .zip file &gt; Extract All...</li>
  33. <li>Rename the extracted folder snipe-it</li>
  34. <li>Cut the snipe-it folder inside the XAMPP directory</li>
  35. <li>Copy the extracted XAMPP directory to a safe location to run from, C:\Program Files for example</li>
  36. <li>Run XAMPP/setup_xampp.bat to update the configuration files with the new server location</li>
  37. <li>Navigate to XAMPP/php and edit php.ini</li>
  38. <li>Find the following line and remove the ; to uncomment them
  39. <p>extension=ldap</p>
  40. </li>
  41. <li>Save the changes to php.ini</li>
  42. <li>Navigate to XAMPP/apache/conf and edit httpd.conf</li>
  43. <li>Paste the following configuration at the bottom of the file, update the folder paths as needed
  44. <p>Alias /snipe-it &quot;C:/Program Files/xampp/snipe-it/public/&quot;<br />
  45. &lt;Directory &quot;C:/Program Files/xampp/snipe-it/public&quot;&gt;<br />
  46. Options Indexes FollowSymLinks<br />
  47. AllowOverride All<br />
  48. Require all granted<br />
  49. &lt;/Directory&gt;</p>
  50. </li>
  51. <li>Save the changes to httpd.conf</li>
  52. <li>Install Composer</li>
  53. <li>Navigate to the XAMPP/snipe-it folder &gt; Right click in the white space &gt; Open PowerShell window here...</li>
  54. <li>Run the following command to download dependencies
  55. <div class="codeBlock PS"># create a copy of the sample .env file<br />
  56. cp .\.env.example .\.env<br />
  57. # install dependencies with composer<br />
  58. composer i --no-dev --prefer-source<br />
  59. # generate app key, type yes to confirm generating a new key<br />
  60. php artisan key:generate<br />
  61. # edit .env in notepad<br />
  62. notepad .\.env</div>
  63. </li>
  64. <li>Modifying the following key/value pairs in .env as needed
  65. <p>APP_ENV=production<br />
  66. APP_DEBUG=false<br />
  67. APP_KEY=SomethingSecure<br />
  68. APP_URL=http://debian/snipe_it<br />
  69. APP_TIMEZONE=&#39;America/New_York&#39;<br />
  70. APP_LOCALE=en<br />
  71. <br />
  72. DB_CONNECTION=mysql<br />
  73. DB_HOST=127.0.0.1<br />
  74. DB_DATABASE=snipe_it<br />
  75. DB_USERNAME=snipe_it_rw<br />
  76. DB_PASSWORD=$nip3-IT!<br />
  77. <br />
  78. MAIL_DRIVER=smtp<br />
  79. MAIL_HOST=smtp.i12bretro.local<br />
  80. MAIL_PORT=25<br />
  81. MAIL_USERNAME=null<br />
  82. MAIL_PASSWORD=null<br />
  83. MAIL_ENCRYPTION=null<br />
  84. MAIL_FROM_ADDR=snipe-it@i12bretro.local<br />
  85. MAIL_FROM_NAME=&#39;Snipe-IT&#39;<br />
  86. MAIL_REPLYTO_ADDR=snipe-it@i12bretro.local<br />
  87. MAIL_REPLYTO_NAME=&#39;Snipe-IT&#39;<br />
  88. MAIL_AUTO_EMBED_METHOD=&#39;attachment&#39;</p>
  89. </li>
  90. <li>Save the changes to .env</li>
  91. <li>Run XAMPP/xampp-control.exe</li>
  92. <li>Click the Start button next to Apache and MySQL</li>
  93. <li>Navigate to XAMPP/mysql/bin</li>
  94. <li>Hold the SHIFT key and right click in the white space &gt; Open PowerShell window here...</li>
  95. <li>Type the following in the PowerShell window to setup the Snipe-IT database
  96. <div class="codeBlock PS">.\mysql -u root<br />
  97. CREATE DATABASE snipe_it;<br />
  98. GRANT ALL ON snipe_it.* to &#39;snipe_it_rw&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;$nip3-IT!&#39;;<br />
  99. FLUSH PRIVILEGES;<br />
  100. EXIT;<br />
  101. exit</div>
  102. </li>
  103. <li>Open a web browser and navigate to http://DNSorIP/snipe-it</li>
  104. <li>Review the Pre-Flight Checks summary &gt; Click the Next: Create Database Tables button</li>
  105. <li>Once the database tables are created, Click the Next: Create User button</li>
  106. <li>Create a user by inputting a site name, first name, last name, email address, username and password &gt; Click the Next: Save User button</li>
  107. <li>Welcome to Snipe-IT</li>
  108. </ol> </div>
  109. </div>
  110. </body>
  111. </html>