At 2022-Sept, the User report tries to export all assets to a CSV file at Snipe-IT but missing some asset records. ( but the asset record is showing on Snipe-IT web UI ) so I search it on the database, but it works...... so I think it is PHP or Snipe-IT problem. When I try to submit a support ticket to Snipe-IT, that reminds me: update to the last version, but I am using an all-in-one TurnKey Linux version, so I try to update Snipe-IT with git actions.
1/ backup system, the TurnKey + Snipe-IT is running on Proxmox, so just using Proxmox Backup Server to make a full backup.
2/Open Shell, rename the current Snipe-IT directory and clone the latest version via git.
cd /var/www
mv snipe-it snipe-it-backup
git clone https://github.com/snipe/snipe-it
3/Upgrade PHP to the new version
sudo apt install apt-transport-https lsb-release
sudo wget -O /etc/apt/trusted.gpg.d/php.gpg https://packages.sury.org/php/apt.gpg
sudo sh -c 'echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" > /etc/apt/sources.list.d/php.list'
sudo apt-get update && sudo apt-get upgrade
4/Change apache run PHP new version
a2dismod php7.3
a2enmod php8.1
systemctl restart apache2
5/ Fix permissions, enter the snipe-it dir and install dependencies with composer:
chown -R www-data:www-data snipe-it
cd snipe-it
turnkey-composer install --no-dev --prefer-source
6/When it's done, copy in the required old files:
cp -R ../snipe-it-backup/public/uploads/* public/uploads
cp -R ../snipe-it-backup/storage/private_uploads/* storage/private_uploads
cp -R ../snipe-it-backup/storage/app/backups/* storage/app/backups
cp -R ../snipe-it-backup/.env ./
cp -R ../snipe-it-backup/storage/oauth-private.key storage/oauth-private.key
cp -R ../snipe-it-backup/storage/oauth-public.key storage/oauth-public.key
7/Migrate DB, clear cache
runuser - www-data -s /bin/bash -c "cd /var/www/snipe-it && php upgrade.php"
8/ Done
Reference
