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

    Updating Database....Failed

    Scheduled Pinned Locked Moved
    FOG Problems
    3
    21
    5.3k
    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.
    • N
      nickkcsd
      last edited by

      Hi,

      I am trying to re-run the fog installer after updating fog settings and now when I go to run it, it is failing at updating database. I am running trunk version 7959.

      This is what I am seeing in the error log.
      Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Synchronizing state of mysql.service with SysV init with /lib/systemd/systemd-sysv-install…
      Executing /lib/systemd/systemd-sysv-install enable mysql
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Operation failed: No such file or directory
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Operation failed: No such file or directory
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted
      Failed to get D-Bus connection: Operation not permitted

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

        Why is it asking for a password? Where did you copy/paste this from? What OS & version is FOG running on?

        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/

        N 1 Reply Last reply Reply Quote 0
        • N
          nickkcsd @Wayne Workman
          last edited by

          @Wayne-Workman Under the error logs folder under /root/fogproject/bin/error_logs. I am running Ubuntu 15.10 and Fog trunk version 7959.

          Thanks

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

            @nickkcsd Is the database password protected?

            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/

            N 1 Reply Last reply Reply Quote 0
            • N
              nickkcsd @Wayne Workman
              last edited by

              @Wayne-Workman Yes it is. However I was able to connect to it using the instructions in this Wiki.

              https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

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

                @nickkcsd Ok, so if the DB is password protected, you need to define the user and password inside of /opt/fog/.fogsettings There are fields in there for this called something like snmysqluser and such. Then after this is done and saved, re-run your installer.

                More information on fog passwords is here:
                https://wiki.fogproject.org/wiki/index.php?title=Password_Central

                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/

                N 1 Reply Last reply Reply Quote 0
                • N
                  nickkcsd @Wayne Workman
                  last edited by

                  @Wayne-Workman So “snmysqluser” is set to root and the password is set to what I tested the connection with. Any other suggestions?

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

                    @nickkcsd and you re-run the installer?

                    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/

                    N 1 Reply Last reply Reply Quote 0
                    • N
                      nickkcsd @Wayne Workman
                      last edited by

                      @Wayne-Workman Yes, it is still failing on setting up and starting MySQL.

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

                        @nickkcsd would you be interested in doing a TeamViewer session?

                        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/

                        N 1 Reply Last reply Reply Quote 0
                        • N
                          nickkcsd @Wayne Workman
                          last edited by

                          @Wayne-Workman Yeah I would be interested in that. Thanks.

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

                            @Developers @george1421

                            I remoted in to take a look around. After dredging through the source code and stepping through and figuring out what is going on,

                            systemctl is getting set to yes. That’s what’s causing the issue.

                            I hard-coded a line after line 920 to read systemctl="no" into the configureMySQL function inside of lib/common/functions.sh and it worked. This lead me to hunting what is setting systemctl to yes…

                            The line that is setting it to yes is this one inside of bin/installfog.sh
                            Line 65 and 66 in the current:

                            command -v systemctl >>$workingdir/error_logs/fog_error_${version}.log 2>&1
                             [[ $? -eq 0 ]] && systemctl="yes"
                            

                            This server was running Ubuntu 15. Here’s a snapshot of the results of the command, and the server OS version:

                            0_1465944178759_systemctl on ubuntu 15.png

                            Immediately after line 66, systemctl is set to yes. And then restarting mysql with systemctl in Ubuntu 15 fails. And it produces those crazy errors.

                            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/

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

                              @Wayne-Workman What’s the output of:

                              systemctl restart mysql
                              systemctl -l status mysql
                              

                              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

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

                                @Tom-Elliott I tried the systemctl restart mysql one, it fails with exactly the errors in the error log he posted. I didn’t try the other. I’m not remoted in anymore. Maybe @nickkcsd can provide the output?

                                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
                                • Tom ElliottT
                                  Tom Elliott
                                  last edited by

                                  Maybe this will help?

                                  http://askubuntu.com/questions/615129/systemd-mysql-wont-stop

                                  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

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

                                    @Tom-Elliott ah-ha… Wonder if he updated from older Ubuntu?

                                    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/

                                    N 1 Reply Last reply Reply Quote 0
                                    • N
                                      nickkcsd @Wayne Workman
                                      last edited by

                                      @Wayne-Workman Yes, I did update from a older version of Ubuntu (13.10).

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

                                        @nickkcsd And this is why I strongly advise against “upgrading” to a newer OS. I’ll always advise a clean fresh (and beautiful) new install.

                                        So, you can try to fix it, or rebuild. If you rebuild, just go with Ubuntu 16. There are some steps here (just two small extra steps) to get FOG Trunk going on Ubuntu 16:
                                        https://forums.fogproject.org/topic/7131/fog-on-ubuntu-16-04-php7/27

                                        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/

                                        N 1 Reply Last reply Reply Quote 0
                                        • N
                                          nickkcsd @Wayne Workman
                                          last edited by

                                          @Wayne-Workman What would you suggest I do at this point?

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

                                            @nickkcsd Well right now your server should be running fine. The issue isn’t pressing anymore.

                                            You can either try to fix the systemctl issue and get that working properly, or build a separate new server (Ubuntu 16), or blast this server and build Ubuntu 16 with fog trunk.

                                            Again though, you’re up and running so it’s not pressing - so schedule this when you have an open window large enough to work on it. If you’ve got imaging to do, do that first.

                                            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/

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

                                            192

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project