Testing SnipeIT on Fedora

JaredBusch

That pull request went live, so Snipe will now install on Fedora.

Someone else also added a bit to open the firewall for HTTP to the CentOS 7 section, so I just made a new pull request to turn that into a subroutine and called it from both the CentOS 7 and Fedora sections.

https://github.com/snipe/snipe-it/pull/4366

stacksofplates

@eddiejennings said in Testing SnipeIT on Fedora:

@jaredbusch said in Testing SnipeIT on Fedora:

@eddiejennings said in Testing SnipeIT on Fedora:

@jaredbusch said in Testing SnipeIT on Fedora:

@eddiejennings said in Testing SnipeIT on Fedora:

@jaredbusch said in Testing SnipeIT on Fedora:

@eddiejennings This is how you install minimal

https://mangolassi.it/topic/13498/how-to-install-fedora-25-minimal/

The software selection options are quite different for the Fedora 26 installer I'm using (such as no mention of a Minimal Install), but it seems that choosing the Fedora Custom Operating System with no addons achieves "minimal."

My SnipeIT install failed the first time. About to try it again with the aforementioned minimal.

You must have started form the DVD install and not the netinstall media.

I did. I ought to have followed my hunch that said netinstall media = minimal.

Netinstall = less than minimal. It has to download all the packages.

/sigh Attention-to-detail fail. I just reread your minimal install of Fedora 25 thread again and somehow missed the first sentence

I'll give it (and SnipeIT) a go tomorrow after work and concert.

If you’re running KVM, virt-builder has a very minimal image and it already has the serial redirect in GRUB so you can just do virsh console vs using a VNC or SPICE client.

hobbit666

Is this still the method of getting snipe on Fedora?

How would you do upgrades when new releases come out?

JaredBusch

@hobbit666 said in Testing SnipeIT on Fedora:

Is this still the method of getting snipe on Fedora?

Yes. It is in the native repository now. So follow the official instructions, do not use my github.

@hobbit666 said in Testing SnipeIT on Fedora:

How would you do upgrades when new releases come out?

If you are on a new/current version you use

sudo -u apache php /var/www/html/snipeit/upgrade.php

https://snipe-it.readme.io/docs/upgrading

Obsolesce

I ran the install.sh script on Fedora 28 minimal install.

As far as I know, that takes care of all dependencies, prerequisites, including cloning the SnipeIT git repository and .env configurations.

After install, browsing to the page results in blank white page.

For troubleshooting purposes, i put SELinux in permissive state and gave the whole /var/www/html/snipeit directory 0777 permissions, just to rule out SELinux and permissions.

What else could it be?

hobbit666

I think I've got it down now to install a clean setup.
Just waiting to get my Hyper-V server running to do a production VM.

Once I do I'll post the steps I did. Might not be the best method but it works well seems to.

Obsolesce

What I didn't do is install Fedora 28, then immediately run the install script before doing anything else. I'll try that in the meantime. This time I'll be taking a checkpoint of the VM pre-install so I can keep trying.

I'd really like to get this going because it'll save a lot of time having this over using our other system.

If I can get it going in the next few hours that'd be great, otherwise, I'm tryign to do this while I'm waiting on someone to get something else done so I can continue with that which is higher priority. So I'm worried if I can get it working today it'll have to wait... because again, priorities

black3dynamite

@obsolesce said in Testing SnipeIT on Fedora:

What I didn't do is install Fedora 28, then immediately run the install script before doing anything else. I'll try that in the meantime. This time I'll be taking a checkpoint of the VM pre-install so I can keep trying.

I'd really like to get this going because it'll save a lot of time having this over using our other system.

If I can get it going in the next few hours that'd be great, otherwise, I'm tryign to do this while I'm waiting on someone to get something else done so I can continue with that which is higher priority. So I'm worried if I can get it working today it'll have to wait... because again, priorities

I haven't tried installing Snipe-IT on Fedora using the script. I've only done it manually.

Obsolesce

@black3dynamite said in Testing SnipeIT on Fedora:

@obsolesce said in Testing SnipeIT on Fedora:

What I didn't do is install Fedora 28, then immediately run the install script before doing anything else. I'll try that in the meantime. This time I'll be taking a checkpoint of the VM pre-install so I can keep trying.

I'd really like to get this going because it'll save a lot of time having this over using our other system.

If I can get it going in the next few hours that'd be great, otherwise, I'm tryign to do this while I'm waiting on someone to get something else done so I can continue with that which is higher priority. So I'm worried if I can get it working today it'll have to wait... because again, priorities

I haven't tried installing Snipe-IT on Fedora using the script. I've only done it manually.

Yeah I was going to do it manually, but I wanted to save time and use the script... jokes on me I guess.

I'm trying it from a 100% fresh install, except for installing wget.

Obsolesce

Now I'm running into this issue:
https://github.com/snipe/snipe-it/issues/3787#issuecomment-325171989

black3dynamite

@obsolesce said in Testing SnipeIT on Fedora:

Now I'm running into this issue:
https://github.com/snipe/snipe-it/issues/3787#issuecomment-325171989

I think that's the issue they on their website too.
https://snipe-it.readme.io/v4.0/docs/upgrading-to-v4

Known Issues

Users running MariaDB 10.2.7 and later may have an issue upgrading or installing, due to a change in the way MariaDB stores null defaults. This issue will be fixed once the open pull request in the Doctrine repo is merged and a new version of Doctrine is released with these fixes. You can read more about that issue here.

Obsolesce

I found a way to get it going... steps incoming...

Obsolesce

To install Snipe-IT on a fresh Fedora 28 minimal install:

Install Fedora Server 28 minimal from NetISO.
Okay to install the typical packages:
dnf install -y wget cockpit cockpit-storaged net-tools dnf-automatic
Download and run the Snipe-IT install script:
wget https://raw.githubusercontent.com/snipe/snipe-it/master/install.sh
chmod 744 install.sh
./install.sh
By default, the laravel log has bad permissions and needs to be fixed for Pre-Flight to work:
chmod 0755 /var/www/html/snipeit/storage/logs/laravel.log
chown apache:apache /var/www/html/snipeit/storage/logs/Laravel.log
By default, you won't be able to send mail with SELinux, allow it to:
setsebool -P httpd_can_network_connect 1
setsebool -P httpd_can_sendmail 1
Pre-flight will now show and pass. Click the next button, it will fail. Then run this command to fix the DB issue:
reference: https://github.com/snipe/snipe-it/issues/5242#issue-307531010
mysql -u root -p
ALTER TABLE snipeit.assets CHANGE `_snipeit_mac_address` `_snipeit_mac_address_1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL NULL ;

Now go back to the Pre-flight page, and it should continue on as normal.

hobbit666

What permissions should the .env file be set to?

As when I've done the manual git clone method the preflight keeps telling me to make sure it's protected from the outside world

Obsolesce

@hobbit666 said in Testing SnipeIT on Fedora:

What permissions should the .env file be set to?

As when I've done the manual git clone method the preflight keeps telling me to make sure it's protected from the outside world

640 should be fine.

Are you able to browse to the .env file on your web browser? You should get a 404 when trying to.

hobbit666

@obsolesce it seemed to do that no matter what I set the permissions to

hobbit666

@obsolesce Gives me a oops something went wrong so guess it's alright.

hobbit666

@obsolesce Are you using MariaDB or MySQL? Also what versions.

I'm getting SQL Syntax errors on the pre-flight but looking on line i can see a post about version 10.2 causing issues.

hobbit666

Even the install script seem to be giving me jip as well.
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '''' at line 1 (SQL: ALTER TABLE assets CHANGE _snipeit_mac_address _snipeit_mac_address_1 VARCHAR(191) DEFAULT ''NULL'')

hobbit666

@hobbit666 said in Testing SnipeIT on Fedora:

@obsolesce Are you using MariaDB or MySQL? Also what versions.

I'm getting SQL Syntax errors on the pre-flight but looking on line i can see a post about version 10.2 causing issues.

Even the install script seem to be giving me jip as well.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '''' at line 1 (SQL: ALTER TABLE assets CHANGE _snipeit_mac_address _snipeit_mac_address_1 VARCHAR(191) DEFAULT ''NULL'')

Oops should have looks up a bit can see @Obsolesce has already posted about this