Snipe-IT : Time not accurate (Wrong Time / Worng Date)

Oops, suddenly I realized that the data that was being saved (Snipe-IT) did not match the current time of the activity taken.

I am really sure that the problem came from Snipe-IT because of no issues from:

• The time and date on the server are accurate.
• There are several applications running that are very dependent on accuracy in time.

The problem came from the "REQUIRED: BASIC APP SETTINGS" on the .env file.

Just change APP_TIMEZONE from 

APP_TIMEZONE='UTC' to APP_TIMEZONE='Asia/Kuala_Lumpur' <depends on your timezone> based on the PHP-supported timezone.

After changing the timezone, just restart the Apache. It should be ok.

Snipe-IT : Changing checkout consumeables directly from database.

There are 2 tables that need to be updated in order for the consumable item to be displayed correctly. Otherwise, your log is messed up.

Table1 : action_logs

Filter by user_id

Filter action_type = checkout <additional>

Changed column target_id

Changed column company_id <additional>

Table2 : consumables_users

Filter by user_id

Cross Check "Date & Time" from table action_logs

Changed column assigned_to

Now it depends on you to create an interface for it or custom your own SQL syntax.

Error 1 : Snipe-IT (your documentroot is set incorrectly)

D'oh. if you're seeing this, your DocumentRoot is set incorrectly. It should be set to the public directory.

1. Open Apache httpd.conf (On default installation, it should be in C:\xampp\apache\conf\httpd.conf)
2. Find DocumentRoot and changed as follows;
   
   DocumentRoot "C:/xampp/htdocs"
   <Directory "C:/xampp/htdocs">
   
   Changed to 
   
   DocumentRoot "C:/xampp/htdocs/snipe-it/public"
   <Directory "C:/xampp/htdocs/snipe-it/public">
   
   
3. Stop and Start Apache

Take note that, this configuration is only for running 1 application or system on 1 server.

Error 2 : Snipe-IT (Error Backup failed...)

 

When I tried to create a backup from admin panel, Error Backup failed because The dump process failed with exitcode 1 : General error : The system cannot find the path specified.

This is most probably a misconfiguration in .env file.

Default configuration in .env file

DB_DUMP_PATH='/usr/bin'

Changed to 

DB_DUMP_PATH='C:\xampp\mysql\bin'

The backup folder will be on C:\xampp\htdocs\snipe-it\storage\app\backups

DB_DUMP_PATH is based on your XAMPP installation folder.

These new configurations allow the execution of backup.

XAMPP 8.1.6 + Snipe-IT-6.0.10

These are the brief step on configuring Snipe-IT ver. 6.1.10 with XAMPP 8.16

1. Install XAMPP as usual.
2. Download Snipe-IT, extract and put into folder C:\xampp\htdocs\snipe-it (location of your XAMPP installation and for this example I'm also using snipe-it as folder name).
   

 

Composer Configuration 

1. Download the latest composer and install it.
   During the installation process, choose C:\xampp\php\php.exe (location of the command-line PHP you want to use).
2. Open Command Prompt (without "Run as Administrator").
3. Changed to the folder location of Snipe-IT that you extracted previously (in Command Prompt).
4. Execute the command: composer install

• If error during the execution of this command (usually on enabling the extension in php.ini), just enabled the extension required. 
  
  
• Personally, I'll execute the command composer update before continuing process no 4.

Snipe-IT Configuration

1. Open the folder of Snipe-IT that you extracted previously (in Windows Explorer).
2. Copy file name .env.example and rename as .env
3. Generate your App key by;
• Open the folder of Snipe-IT (in Command Prompt).
• Execute command php artisan key:generate 
4. Browse PHPMyAdmin and create a database for snipe-it (for this manual, database named snipe-it)
5. Edit .env and changed;
• APP_URL=localhost
• DB_DATABASE=snipe-it
• DB_USERNAME=root

 

Hopefully, this can help you during the deployment of Snipe-IT.