• 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

      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

        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

          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 Reply Quote 0
          • Q
            Quazz Moderator @Baessens
            last edited by Quazz

            @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 Reply Quote 0
            • B
              Baessens @Quazz
              last edited by

              @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

                @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 Reply Quote 0
                • B
                  Baessens @Sebastian Roth
                  last edited by

                  @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

                    @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 Reply Quote 0
                    • B
                      Baessens @Sebastian Roth
                      last edited by Baessens

                      @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

                        @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

                          @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 Reply Quote 0
                          • B
                            Baessens @Sebastian Roth
                            last edited by

                            @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

                              @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

                                @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 Reply Quote 0
                                • B
                                  Baessens @Sebastian Roth
                                  last edited by Baessens

                                  @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

                                    @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

                                      @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 Reply Quote 0
                                      • B
                                        Baessens @Sebastian Roth
                                        last edited by

                                        @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

                                          @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

                                            @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 Reply Quote 2
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            155

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project