ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Testing SnipeIT on Fedora

    IT Discussion
    snipe-it fedora
    12
    62
    9.9k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • hobbit666H
      hobbit666
      last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • ObsolesceO
        Obsolesce
        last edited by 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 😞

        black3dynamiteB 1 Reply Last reply Reply Quote 0
        • black3dynamiteB
          black3dynamite @Obsolesce
          last edited by

          @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.

          ObsolesceO 1 Reply Last reply Reply Quote 0
          • ObsolesceO
            Obsolesce @black3dynamite
            last edited by

            @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.

            1 Reply Last reply Reply Quote 0
            • ObsolesceO
              Obsolesce
              last edited by

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

              black3dynamiteB 1 Reply Last reply Reply Quote 0
              • black3dynamiteB
                black3dynamite @Obsolesce
                last edited by

                @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.
                
                1 Reply Last reply Reply Quote 0
                • ObsolesceO
                  Obsolesce
                  last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • ObsolesceO
                    Obsolesce
                    last edited by Obsolesce

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

                    1. Install Fedora Server 28 minimal from NetISO.
                    2. Okay to install the typical packages:
                      dnf install -y wget cockpit cockpit-storaged net-tools dnf-automatic
                    3. 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
                    4. 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
                    5. 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
                    6. 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.

                    ObsolesceO 1 Reply Last reply Reply Quote 1
                    • hobbit666H
                      hobbit666
                      last edited by

                      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

                      ObsolesceO 1 Reply Last reply Reply Quote 0
                      • ObsolesceO
                        Obsolesce @hobbit666
                        last edited by 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.

                        hobbit666H 3 Replies Last reply Reply Quote 0
                        • hobbit666H
                          hobbit666 @Obsolesce
                          last edited by

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

                          1 Reply Last reply Reply Quote 0
                          • hobbit666H
                            hobbit666 @Obsolesce
                            last edited by

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

                            1 Reply Last reply Reply Quote 0
                            • hobbit666H
                              hobbit666 @Obsolesce
                              last edited by

                              @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.

                              hobbit666H ObsolesceO 2 Replies Last reply Reply Quote 0
                              • hobbit666H
                                hobbit666
                                last edited by

                                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'')

                                1 Reply Last reply Reply Quote 0
                                • hobbit666H
                                  hobbit666 @hobbit666
                                  last edited by

                                  @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 🙂

                                  1 Reply Last reply Reply Quote 0
                                  • ObsolesceO
                                    Obsolesce @hobbit666
                                    last edited by

                                    @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.

                                    MariaDB, latest repo version... 10.2.

                                    Look at #6 here:

                                    @obsolesce said in Testing SnipeIT on Fedora:

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

                                    1. Install Fedora Server 28 minimal from NetISO.
                                    2. Okay to install the typical packages:
                                      dnf install -y wget cockpit cockpit-storaged net-tools dnf-automatic
                                    3. 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
                                    4. 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
                                    5. 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
                                    6. 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.

                                    hobbit666H 1 Reply Last reply Reply Quote 0
                                    • hobbit666H
                                      hobbit666 @Obsolesce
                                      last edited by

                                      @obsolesce Yeah did your Alter table and i'm up and running and also imported my data from the old version.

                                      Now to get it to work from behind a NGINX proxy

                                      1 Reply Last reply Reply Quote 0
                                      • hobbit666H
                                        hobbit666
                                        last edited by

                                        Now got issues adding machines, or doing anything add/edit wise. While in debug can see it all relating to the SQL stuff.

                                        Guess its down to how i've exported and imported the database.

                                        ObsolesceO JaredBuschJ 2 Replies Last reply Reply Quote 0
                                        • ObsolesceO
                                          Obsolesce @hobbit666
                                          last edited by

                                          @hobbit666 said in Testing SnipeIT on Fedora:

                                          Now got issues adding machines, or doing anything add/edit wise. While in debug can see it all relating to the SQL stuff.

                                          Guess its down to how i've exported and imported the database.

                                          Yeah probably due to that. I can add/edit fine using the instructions I provided.

                                          hobbit666H 1 Reply Last reply Reply Quote 0
                                          • JaredBuschJ
                                            JaredBusch @hobbit666
                                            last edited by

                                            @hobbit666 said in Testing SnipeIT on Fedora:

                                            Now got issues adding machines, or doing anything add/edit wise. While in debug can see it all relating to the SQL stuff.

                                            Guess its down to how i've exported and imported the database.

                                            If oyu were not on the same version things will be bad.
                                            because they update the database between versions for bugs or enhancemnts, etc.

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 2 / 4
                                            • First post
                                              Last post