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

    Ubuntu is FOG's enemy

    Scheduled Pinned Locked Moved
    Announcements
    12
    25
    32.8k
    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.
    • W
      wanderson
      last edited by

      0_1496340156762_fog_error4.png

      Tom ElliottT 1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott @wanderson
        last edited by

        @wanderson Have you tried replacing 127.0.0.1 with localhost?

        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

        W 1 Reply Last reply Reply Quote 0
        • W
          wanderson @Tom Elliott
          last edited by

          @Tom-Elliott

          BD this mariaDB

          0_1496340406726_fog_error5.png

          1 Reply Last reply Reply Quote 0
          • AvaryanA
            Avaryan
            last edited by

            Which linux distro is most preferred by the developers?

            Wayne WorkmanW 1 Reply Last reply Reply Quote 0
            • W
              wanderson @Tom Elliott
              last edited by

              @Tom-Elliott said in Ubuntu is FOG's enemy:

              ALTER USER

              Command mariadb?

              Tom ElliottT 1 Reply Last reply Reply Quote 0
              • Tom ElliottT
                Tom Elliott @wanderson
                last edited by Tom Elliott

                @wanderson The alter user syntax is only a specific version of mysql and mariadb. IN the case of mariadb I believe it started with version 10.2, and for mysql it started with 5.7.

                So, in your particular case, chances are the version of mariadb is not one that supports the alter user statement. That said, i only recommended the post as it seemed similar to what we’ve recently seen with CentOS 7. It does not mean this was the issue, but trying it wouldn’t hurt anything either.

                The issue that brought you to this posting is most likely related to Max connections being used. I don’t know what settings will fix that for you.

                @Avaryan I try not to specify a specific OS. This posting is mainly just informing users of potential issues we were/are seeing. I’m personally a fan of Fedora/Redhat/CentOS, but I try pretty hard to make our installer distro agnostic. For the most part we support the two main types found (Debian based, and Redhat based). We also support Arch.

                If I had to say which one to use, I’d actually say CentOS as it’s stable, usually minimally offset from Redhat releases. Fedora would probably be the next one on the list, but in a “production” world I wouldn’t recommend it.

                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

                W 1 Reply Last reply Reply Quote 0
                • W
                  wanderson @Tom Elliott
                  last edited by

                  @Tom-Elliott It seems that so far this command has resolved:

                  SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘’);
                  SET PASSWORD FOR ‘root’@‘127.0.0.1’ = PASSWORD(‘’);

                  chown -R apache:root /var/www/

                  Praying that the mistake will not happen again!

                  thanks!!!

                  1 Reply Last reply Reply Quote 0
                  • W
                    wanderson
                    last edited by

                    @Tom-Elliott said in Ubuntu is FOG's enemy:

                    ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password BY ‘’;

                    I still have the error, can not I leave the mysql password blank?

                    W 1 Reply Last reply Reply Quote 0
                    • W
                      wanderson @wanderson
                      last edited by

                      update mysql.user set plugin=‘mysql_native_password’;

                      1 Reply Last reply Reply Quote 0
                      • Wayne WorkmanW
                        Wayne Workman @Avaryan
                        last edited by Wayne Workman

                        @Avaryan said in Ubuntu is FOG's enemy:

                        Which linux distro is most preferred by the developers?

                        CENTOS 7, Debian 8, or RHEL 7 are my preferences for production.

                        Fedora and Debian are my personal favorites for testing and development.

                        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!
                        Daily Clean Installation Results:
                        https://fogtesting.fogproject.us/
                        FOG Reporting:
                        https://fog-external-reporting-results.fogproject.us/

                        J 1 Reply Last reply Reply Quote 0
                        • J
                          Joe Gill @Wayne Workman
                          last edited by

                          @Wayne-Workman

                          How difficult is it to migrate from an existing FOG server / FOG storage node running Ubuntu to Centos from a FOG perspective?

                          Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                          • Wayne WorkmanW
                            Wayne Workman @Joe Gill
                            last edited by

                            @Joe-Gill Easy, here’s the guide: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG

                            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!
                            Daily Clean Installation Results:
                            https://fogtesting.fogproject.us/
                            FOG Reporting:
                            https://fog-external-reporting-results.fogproject.us/

                            1 Reply Last reply Reply Quote 1
                            • J
                              jacoboren
                              last edited by

                              Great I found this as solution for the same problem that suddenly appear here, i remove the “unattended-upgrades” from Ubuntu and I hope that don’t happen again. , solved!

                              Thanks @Tom-Elliott !

                              1 Reply Last reply Reply Quote 0
                              • Wayne WorkmanW
                                Wayne Workman
                                last edited by

                                Hey there Canonical, you’re not doing yourself any favors when you change settings the admin has manually set. I hoped someone on your team would have read this thread and made changes accordingly to prevent the continuance of mayhem, but alas it seems nobody has… Don’t you have Google alerts setup when the words “Canonical” are used on-line?

                                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!
                                Daily Clean Installation Results:
                                https://fogtesting.fogproject.us/
                                FOG Reporting:
                                https://fog-external-reporting-results.fogproject.us/

                                x23piracyX 1 Reply Last reply Reply Quote 0
                                • x23piracyX
                                  x23piracy @Wayne Workman
                                  last edited by

                                  @wayne-workman nice try wayne 🙂

                                  ║▌║█║▌│║▌║▌█

                                  1 Reply Last reply Reply Quote 0
                                  • ?
                                    A Former User
                                    last edited by

                                    Hello!

                                    First of all, my English is terrible!

                                    I downloaded CentOS 7 and FOG 1.4.4 today, with all updates, i follow exactly all the installation steps contained in FOG Wiki, even so i have the same problem described here.

                                    I was able to resolve the issue with the instructions in that topic, in this case, as follows:

                                    PS: At the time of installation I did NOT leave the mysql password blank, I set a password.

                                    sudo -i
                                    mysql -u root
                                    set password for 'root' @ 'localhost' = password('password entered at the time of installation fog');
                                    set password for 'root'@'127.0.0.1' = password('password entered at the time of installation fog');
                                    update mysql.user set plugin = 'mysql_native_password';
                                    

                                    That done, I was able to access the web GUI normally!

                                    @wanderson and @Tom-Elliott, thank you so much!

                                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                    • Wayne WorkmanW
                                      Wayne Workman @A Former User
                                      last edited by Wayne Workman

                                      @haylander Typing in a password during the installer does not set a password for the database, it merely tells the fog installer ‘here, use this password to access the DB’, which won’t work if that password isn’t set prior.

                                      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!
                                      Daily Clean Installation Results:
                                      https://fogtesting.fogproject.us/
                                      FOG Reporting:
                                      https://fog-external-reporting-results.fogproject.us/

                                      ? 1 Reply Last reply Reply Quote 0
                                      • ?
                                        A Former User @Wayne Workman
                                        last edited by

                                        @wayne-workman got it…

                                        so I misunderstood when I thought the database was fully built in the FOG installation…

                                        anyway thank you!

                                        1 Reply Last reply Reply Quote 0
                                        • K
                                          kainwilliam
                                          last edited by

                                          Very informative thread.

                                          1 Reply Last reply Reply Quote 0
                                          • T
                                            Trev-lchs
                                            last edited by

                                            @Tom-Elliott said in Ubuntu is FOG's enemy:

                                            apt-get -y remove unattended-upgrades

                                            This saved my bacon, thank you very much, first command failed but second one worked, i have also run the unattended-upgrades command, once again thank you.

                                            1 Reply Last reply Reply Quote 0
                                            • P processor referenced this topic on
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            160

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project