• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

FOG Auto Installation MYSQL issues

Scheduled Pinned Locked Moved Solved
FOG Problems
3
7
670
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.
  • T
    TBuzaTechnician
    last edited by TBuzaTechnician Oct 9, 2019, 7:03 AM Oct 4, 2019, 7:13 PM

    Hello Everyone!

    I am currently installing fog using my settings placed in .fogsettings found in /opt/fog/. I run the .installfog script with the -y and -S settings. I need it to install forcing HTTPS with a Mysql password for the root account. (Mysql installs during the FOG installation, I added the following line to the bottom of the .installfog script)

    mysqladmin --user=root password "newpassword" 
    

    Either I get the error “Updating DB… Failed” and can only connect to the page once I manually run the above mysql command. Or I get a worse error stating,

    “Compiling iPXE binaries that trust our SSL certificate… Failed!”

    In this case, I can connect to the DB, but I cannot connect to iPXE because it does not exist.

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Oct 4, 2019, 7:24 PM

      run the installer as:

      snmysqlpass='newpassword' ./installfog.sh -y
      

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator
        last edited by Oct 4, 2019, 7:46 PM

        @TBuzaTechnician @Tom-Elliott I have started working on improving DB security in the last weeks and I have the impression that setting the DB root password simply won’t work with the install Script ad it exists right now. This is due to different behavior of the various MySQL/MariaDB versions we need to support in CentOS, Ubuntu, Debian, Fedora and so on.

        @TBuzaTechnician I am on the road right now and cannot work on this until I get back home. Feel free to play with the scripts and let us know what you find. I think using mysqladmin is a good idea because from what I have tried so far this seems to work across all versions.

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        T 1 Reply Last reply Oct 4, 2019, 8:17 PM Reply Quote 0
        • T
          Tom Elliott @Sebastian Roth
          last edited by Oct 4, 2019, 8:17 PM

          @Sebastian-Roth, @TBuzaTechnician

          If you run mysqladm --user root password "newpassword", you should not do it as a part of the installation script (eventually yes, but as of right now no.)

          After you set the password, then you can run it with snmysqlpass='newpassword' ./installfog.sh -y

          Eventually, I know we want to create a separate user and password pair for mysql for security reasons, but in the mean time, the above should work.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          T 1 Reply Last reply Oct 9, 2019, 12:41 PM Reply Quote 1
          • T
            TBuzaTechnician @Tom Elliott
            last edited by Oct 9, 2019, 12:41 PM

            @Tom-Elliott Thanks for the help. Just to Clarify, I should Install FOG, then run:

            snmysqlpass='newpassword' ./installfog.sh -y
            

            Which would re-run the installer to change the configuration?

            T 1 Reply Last reply Oct 9, 2019, 12:52 PM Reply Quote 0
            • T
              Tom Elliott @TBuzaTechnician
              last edited by Oct 9, 2019, 12:52 PM

              @TBuzaTechnician You would need to run the mysqladmin command first, then do the command.

              That should set your mysql password and ensure FOG will install using that now set password.

              Thank you,

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              1 Reply Last reply Reply Quote 0
              • S
                Sebastian Roth Moderator
                last edited by Sebastian Roth Nov 25, 2019, 1:27 PM Nov 25, 2019, 7:27 PM

                @TBuzaTechnician Just a quick update here. I finally found the time to work on this. Currently we have a major set of changes regarding database security in a testing stage. Looks pretty good so far and it will all be part of the next release.

                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                1 Reply Last reply Reply Quote 0
                • 1 / 1
                • First post
                  Last post

                201

                Online

                12.0k

                Users

                17.3k

                Topics

                155.2k

                Posts
                Copyright © 2012-2024 FOG Project