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

Capturing image update database failed

Scheduled Pinned Locked Moved
FOG Problems
3
22
3.7k
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.
  • B
    Baessens
    last edited by Sep 2, 2020, 8:07 AM

    Hi there

    FOG version: 1.5.9-RC2

    I’m getting the “failed to update database…” error at the very end of capturing an image.
    This problem occurs when I am trying to capture a Windows 10 UEFI (V2004) image. (see attach. below)

    I use Virtualbox and set my DHCP option 67 to undionly.kpxe to capture, as capturing doesn’t work when i put it on ipxe.efi. (I did this before and never had a problem)

    Weird thing is I don’t have this problem when i capture an image in “legacy mode” on our hyper-v server.

    Knipsel.PNG

    I keep seeing the username “fogproject” in there, but i don’t have a user by that name tho…

    Knipsel2.PNG

    Any help would be appreciated.

    1 Reply Last reply Reply Quote 0
    • Q
      Quazz Moderator
      last edited by Sep 2, 2020, 9:30 AM

      Some time ago, FOG changed the linux user to be ‘fogproject’ instead of simply ‘fog’.

      This is the account the FTP tries to connect to.

      Looks like it can log in successfully, but fails to move the files, indicating a permission problem.

      sudo ls -lah /images
      

      Will show you current permissions.

      More than likely the owner is incorrect.

      sudo chown -R fogproject:root /images
      
      1 Reply Last reply Reply Quote 0
      • B
        Baessens
        last edited by Sep 3, 2020, 2:42 PM

        Thanks for your reply @Quazz .

        I think my permissions are correct.
        eef3f042-7f97-4500-87a8-d8d2f38f1c83-image.png

        Any other ideas?

        Q 1 Reply Last reply Sep 3, 2020, 2:45 PM Reply Quote 0
        • Q
          Quazz Moderator @Baessens
          last edited by Quazz Sep 3, 2020, 8:46 AM Sep 3, 2020, 2:45 PM

          @Baessens What about the files in /images/dev?

          We can assume credentials are fine; otherwise it would complain about that before being unable to create a file (I assume, could be wrong)

          B 1 Reply Last reply Sep 3, 2020, 3:09 PM Reply Quote 0
          • B
            Baessens @Quazz
            last edited by Sep 3, 2020, 3:09 PM

            @Quazz
            I do have 3 other fog servers who sync the images from this one. Maybe that plays a role somehow?

            What about the files in /images/dev
            babc03c1-9e3c-4970-87c4-9b6167255db9-image.png

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Sep 5, 2020, 7:02 AM

              @Baessens Please post the output of the commands mount and df -h here. Text output or picture will do.

              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

              B 1 Reply Last reply Sep 7, 2020, 8:03 AM Reply Quote 0
              • B
                Baessens @Sebastian Roth
                last edited by Sep 7, 2020, 8:03 AM

                @Sebastian-Roth Here you go.

                e0edf85c-9342-44fd-8faa-620e0e2d234c-image.png

                2b97d702-91cb-43d1-9a63-1596b7507aa3-image.png

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Sebastian Roth Sep 7, 2020, 2:55 AM Sep 7, 2020, 8:54 AM

                  @Baessens Thanks for the pictures. Looking good from what I see.

                  Weird thing is I don’t have this problem when i capture an image in “legacy mode” on our hyper-v server.

                  Is this a different FOG server? I really wonder why it would say Could not create file . in one case but not in the other if this is all on the same FOG server.

                  Please move the temporary folders created when capturing last just to make sure:

                  mv /images/dev/0800270d1e06 /images/dev/0800270d1e06_old
                  mv /images/dev/0800275021ae /images/dev/0800275021ae_old
                  

                  Do you have SELinux disabled (in case this is a CentOS server)?

                  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

                  B 1 Reply Last reply Sep 21, 2020, 9:23 AM Reply Quote 0
                  • B
                    Baessens @Sebastian Roth
                    last edited by Baessens Sep 21, 2020, 4:02 AM Sep 21, 2020, 9:23 AM

                    @Sebastian-Roth

                    0a7687bb-47ac-4b02-9639-007df9f1f0e5-image.png

                    It’s an Ubuntu server. (16.04)
                    I just tested it and cannot upload an image anymore at all. I have no problem deploying old images.

                    I also moved the temporary folders before trying to capture.

                    I capture on one fog-server(FOG1) then let it replicate to 3 other FOG servers which are full nodes. Then i just export and import the images list from FOG1 to the others. Maybe there’s a problem over on some other FOG server with creds, i’ll check some things.

                    I last uploaded an image on 25th of august, without issues.

                    Thanks

                    1 Reply Last reply Reply Quote 0
                    • B
                      Baessens
                      last edited by Baessens Sep 21, 2020, 8:14 AM Sep 21, 2020, 1:45 PM

                      @Sebastian-Roth

                      Also: the /images folder is on a different location(virtual hard drive) then the OS.
                      EDIT: i’m now on 1.5.9 and deleted all the storage nodes. Still same problem.

                      1 Reply Last reply Reply Quote 0
                      • S
                        Sebastian Roth Moderator
                        last edited by Sebastian Roth Sep 21, 2020, 1:15 PM Sep 21, 2020, 7:14 PM

                        @Baessens Taking another close look at the error message I found that I got the dot at the end of Could not create file. wrong. It’s not the dot marking the current directory but just a full stop at the end of the sentence.

                        Please grab the FTP connection settings (IP: 10.0.0.40, user: fogproject and password) from your /opt/fog/.fogsettings file, connect to your FOG server using any known FTP client program and try create directory /images/dev/0800275021ae and upload a random file to that new directory.

                        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

                        B 2 Replies Last reply Sep 22, 2020, 7:34 AM Reply Quote 0
                        • B
                          Baessens @Sebastian Roth
                          last edited by Sep 22, 2020, 7:34 AM

                          @Sebastian-Roth Thanks for your reply.
                          The password in the /.fogsettings file is different then the one in the GUI under TFTP server.
                          Should i change the one in the GUI to match the one in /.fogsettings?

                          Also i can upload a random file in there.
                          2e464f2a-c414-41b0-a669-fcac02fb6b0c-image.png

                          1 Reply Last reply Reply Quote 0
                          • B
                            Baessens @Sebastian Roth
                            last edited by Sep 22, 2020, 11:30 AM

                            @Sebastian-Roth I can also create a directory and upload a random file into that new dir.

                            1 Reply Last reply Reply Quote 0
                            • S
                              Sebastian Roth Moderator
                              last edited by Sebastian Roth Sep 22, 2020, 5:58 AM Sep 22, 2020, 11:57 AM

                              @Baessens said in Capturing image update database failed:

                              The password in the /.fogsettings file is different then the one in the GUI under TFTP server.

                              Are the usernames different as well?? When only the password is different we should see a login error in the picture instead of a “Could not create” message I reckon.

                              Please go through this: https://forums.fogproject.org/topic/11203/resyncing-fog-s-service-account-password

                              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

                              B 1 Reply Last reply Sep 22, 2020, 2:01 PM Reply Quote 0
                              • B
                                Baessens @Sebastian Roth
                                last edited by Baessens Sep 22, 2020, 8:02 AM Sep 22, 2020, 2:01 PM

                                @Sebastian-Roth
                                92a89930-4109-40fd-9886-bb614d8cec58-image.png

                                It seems to only be the password that is different.
                                i’ll try that resyncing thing too.

                                1 Reply Last reply Reply Quote 0
                                • B
                                  Baessens
                                  last edited by Sep 22, 2020, 2:41 PM

                                  @Sebastian-Roth I am still getting the same error.
                                  I might just install a whole new server. Can you think of anything else that might be causing the error?

                                  Thanks for all your help allready.

                                  1 Reply Last reply Reply Quote 0
                                  • S
                                    Sebastian Roth Moderator
                                    last edited by Sep 22, 2020, 3:01 PM

                                    @Baessens Too bad. I usually try to dig into things till I find the root cause of it. Though I understand if this just seems unsolvable.

                                    Re-reading most of the topic I saw that you seem to have a subdirectory /images/dev/dev. Though I don’t think this can cause the issue I am wondering where this came from. Please run ls -alR /images/dev/dev and post output here.

                                    Meanwhile I am digging through the code to see what else we can try.

                                    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

                                    B 1 Reply Last reply Sep 22, 2020, 3:08 PM Reply Quote 0
                                    • B
                                      Baessens @Sebastian Roth
                                      last edited by Sep 22, 2020, 3:08 PM

                                      @Sebastian-Roth
                                      Could it have something to do with the SQL creds?

                                      I think it must have happened after an update, either from FOG or Ubuntu.

                                      95542a20-25a8-4884-ab00-730ff232e904-image.png

                                      1 Reply Last reply Reply Quote 0
                                      • S
                                        Sebastian Roth Moderator
                                        last edited by Sep 23, 2020, 1:19 PM

                                        @Baessens said in Capturing image update database failed:

                                        Could it have something to do with the SQL creds?

                                        With SQL creds wrong you’d see completely other issues and wouldn’t even be able to schedule a task in the web UI.

                                        I think it must have happened after an update, either from FOG or Ubuntu.

                                        Don’t think I have ever seen this happen from an update. Possibly something you did when moving images to a differnt disk/partition.

                                        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 Sep 23, 2020, 2:59 PM Sep 23, 2020, 8:59 PM

                                          @Baessens Ohhhhhhhh no!!! Why haven’t I noticed this before??? Can’t believe it. The second picture of your initial post actually has the solution to this riddle in it already. Image is named UEFI01/09/20v2004 and as a forward slash is the directory separator on Linux systems it will fail to rename the uploaded image…

                                          Simply use dashes (-) instead of the slash in both the image name and path and I am sure it will upload just fine.

                                          We don’t get that very often and I actually thought we had some kind of regex check in the web UI to prevent from this but seems like I was wrong.

                                          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

                                          B 2 Replies Last reply Sep 24, 2020, 8:03 AM Reply Quote 2
                                          • 1
                                          • 2
                                          • 1 / 2
                                          • First post
                                            Last post

                                          157

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project