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

Updating Database failed! Failed to open stream!

Scheduled Pinned Locked Moved Solved
FOG Problems
4
40
6.0k
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.
  • G
    george1421 Moderator @Kevin Talbot
    last edited by george1421 Nov 30, 2018, 7:37 AM Nov 30, 2018, 1:37 PM

    @Kevin-Talbot your image didn’t upload but lets try this.

    In the storage node definition for the remote storage node in question. There is a management user account and password. From your windows computer, can you ftp to that remote storage node using those credentials? Those credentials should match the contents of the /opt/fog/.fogsettings on the remote storage node.

    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!

    K 1 Reply Last reply Nov 30, 2018, 1:48 PM Reply Quote 0
    • K
      Kevin Talbot @george1421
      last edited by Nov 30, 2018, 1:48 PM

      @george1421 Yes I can FTP with Filezilla to the node using “fog” and the very long generated password!

      The DEV folder has the images under folders named by the mac addresses as it should do but clearly cannot rename and move them to the IMAGES folder?

      G 1 Reply Last reply Nov 30, 2018, 2:01 PM Reply Quote 0
      • K
        Kevin Talbot @Sebastian Roth
        last edited by Nov 30, 2018, 1:51 PM

        @Sebastian-Roth said in Updating Database failed! Failed to open stream!:

        /var/www/html/fog/lib/fog/config.class.php and /opt/fog/.fogsettings

        “Check all the IPs you have in /var/www/html/fog/lib/fog/config.class.php and /opt/fog/.fogsettings”

        these check out fine!

        1 Reply Last reply Reply Quote 0
        • K
          Kevin Talbot @george1421
          last edited by Nov 30, 2018, 1:53 PM

          @george1421 0_1543585923745_fog.JPG

          1 Reply Last reply Reply Quote 0
          • G
            george1421 Moderator @Kevin Talbot
            last edited by george1421 Nov 30, 2018, 8:02 AM Nov 30, 2018, 2:01 PM

            @Kevin-Talbot OK let make sure we understand a few things (building a truth table).

            1. The storage node in question is 172.16.220.246?
            2. You were able to ftp to that storage node using the user name of fog and that long password from storage node page?
            3. The image is arriving on the 172.16.220.246 server in /images/dev/<mac_address> directory?
            4. We see the failed to update database message
            5. The actions were it failed are in the FTP section of the code.

            Here is where I’m going:

            1. What does the permissions look like on the /images and /images/dev directory?
            2. Does the linux user fog have rights to move/create files?
            3. Do the permissions on these directories match the FOG Master Server’s directories?

            I believe where the process is falling down is when the target computer connects to the fog server (node) using FTP. At this point it needs to move the images from /images/dev/<mac_address> to /images/<image_name>. It should do that with the ftp mv command. One should be able to do the same steps from a FTP client connected to the remote storage node.

            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!

            K 2 Replies Last reply Nov 30, 2018, 2:06 PM Reply Quote 0
            • K
              Kevin Talbot @george1421
              last edited by Nov 30, 2018, 2:06 PM

              @george1421

              1. the node is 172.16.100.246
              2. yes i was able to ftp to 172.16.100.246 using “fog” and the long password
              3. the image is arriving on 172.16.100.2460_1543586762996_dev.JPG
              G 1 Reply Last reply Nov 30, 2018, 2:11 PM Reply Quote 0
              • K
                Kevin Talbot @george1421
                last edited by Nov 30, 2018, 2:10 PM

                @george1421

                1. permissions on images and dev folder1_1543586972596_images.JPG 0_1543586972595_devper.JPG
                1 Reply Last reply Reply Quote 0
                • G
                  george1421 Moderator @Kevin Talbot
                  last edited by Nov 30, 2018, 2:11 PM

                  @Kevin-Talbot well this isn’t exactly what I asked, but from filezilla logged in as fog, can you move one of the mac directories from /images/dev to /images?

                  For what I asked about with permissions run these commands on both the main fog server and on the remote storage node.

                  ls -la /images
                  ls -la /images/dev
                  sestatus|grep -e "SELinux status"| awk '{print $3}'

                  Hint: If you use putty to ssh into the fog servers you can copy and paste these commands and 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!

                  K 2 Replies Last reply Nov 30, 2018, 2:13 PM Reply Quote 0
                  • K
                    Kevin Talbot @george1421
                    last edited by george1421 Nov 30, 2018, 8:15 AM Nov 30, 2018, 2:13 PM

                    @george1421 For the master (172.16.220.246)

                    itsupport@fog-server:~$ ls -la /images
                    total 64
                    drwxrwxrwx 16 fog  root 4096 Nov 30 13:18 .
                    drwxr-xr-x 26 root root 4096 Nov 30 13:01 ..
                    drwxrwxrwx  3 fog  root 4096 Nov 30 10:14 dev
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:53 Latitude3570Win7-NoOffice-i5
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:21 Latitude3580Win7-NoOffice-i5
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:53 LatitudeE5530Win7-NoOffice-HD3000
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:53 LatitudeE5540Win7-Office2013-i3
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:53 LatitudeE5550Win7-NoOffice-i5
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:53 LatitudeE5570Win7-Office2016-i5
                    -rwxrwxrwx  1 fog  root    0 Nov 26  2017 .mntcheck
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:53 Optiplex3020MWin7-Workshop
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:54 Optiplex3030Win7-NoOffice
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:54 Optiplex3240Win7-NoOffice
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:54 Optiplex380Win7-Office2007
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:23 Optiplex380Win7-Office2010
                    drwxr-xr-x  2 fog  fog  4096 Nov 30 13:54 Optiplex5250Win10
                    drwxrwxrwx  2 fog  root 4096 Nov 26  2017 postdownloadscripts
                    
                    itsupport@fog-server:~$ ls -la /images/dev
                    total 12
                    drwxrwxrwx  3 fog root 4096 Nov 30 10:14 .
                    drwxrwxrwx 16 fog root 4096 Nov 30 13:18 ..
                    -rwxrwxrwx  1 fog root    0 Nov 26  2017 .mntcheck
                    drwxrwxrwx  2 fog root 4096 Nov 26  2017 postinitscripts
                    itsupport@fog-server:~$
                    

                    [Mod note] I fixed the post for readability -Geo

                    G 1 Reply Last reply Nov 30, 2018, 2:16 PM Reply Quote 0
                    • K
                      Kevin Talbot @george1421
                      last edited by george1421 Nov 30, 2018, 8:18 AM Nov 30, 2018, 2:16 PM

                      @george1421 for the node (172.16.100.246)

                      itsupport@259-fog:~$ ls -la /images
                      total 100
                      drwxrwxrwx 22 fog  root  4096 Nov 30 10:53 .
                      drwxr-xr-x 27 root root  4096 Nov 30 10:53 ..
                      drwxrwxrwx  6 fog  root  4096 Nov 30 10:53 dev
                      drwxrwxrwx  2 fog  root  4096 Jun  7 10:17 Latitude3540Win7-Office2013-i3
                      drwxrwxrwx  2 fog  root  4096 Jul  4 11:37 Latitude3570Win7-NoOffice-i5
                      drwxrwxrwx  2 fog  root  4096 Apr 11  2018 Latitude3580Win7-NoOffice-i5
                      drwxrwxrwx  2 fog  root  4096 Oct 26 21:06 Latitude3590-Win10
                      drwxrwxrwx  2 fog  root  4096 Oct 11 12:04 Latitude5490-Win10-k1
                      drwxrwxrwx  2 fog  root  4096 Apr 17  2018 LatitudeE5530Win7-NoOffice-HD3000
                      drwxrwxrwx  2 fog  root  4096 Jul  4 14:21 LatitudeE5540Win7-Office2013-i3
                      drwxrwxrwx  2 fog  root  4096 Jul  5 10:20 LatitudeE5540Win7-Office2013-i5
                      drwxrwxrwx  2 fog  root  4096 Jan  2  2018 LatitudeE5550Win7-NoOffice-i5
                      drwxrwxrwx  2 fog  root  4096 Feb  6  2018 LatitudeE5570Win7-Office2016-i5
                      drwxrwxrwx  2 fog  root 16384 Sep 24 14:13 lost+found
                      -rwxrwxrwx  1 fog  root     0 Sep 24 16:55 .mntcheck
                      drwxrwxrwx  2 fog  root  4096 Jul  6 17:04 Optiplex3020MWin7-Workshop
                      drwxrwxrwx  2 fog  root  4096 Jan  4  2018 Optiplex3030Win7-NoOffice
                      drwxrwxrwx  2 fog  root  4096 Aug 17 10:27 Optiplex3240Win7-NoOffice
                      drwxrwxrwx  2 fog  root  4096 Mar 22  2018 Optiplex380Win7-NoOffice
                      drwxrwxrwx  2 fog  root  4096 Nov 28  2017 Optiplex380Win7-Office2007
                      drwxrwxrwx  2 fog  root  4096 Nov 28  2017 Optiplex380Win7-Office2010
                      drwxrwxrwx  2 fog  root  4096 Oct  4 11:52 Optiplex5250Win10
                      drwxrwxrwx  2 fog  root  4096 Nov 30 10:53 postdownloadscripts
                      
                      itsupport@259-fog:~$ ls -la /images/dev
                      total 24
                      drwxrwxrwx  6 fog root 4096 Nov 30 10:53 .
                      drwxrwxrwx 22 fog root 4096 Nov 30 10:53 ..
                      drwxrwxrwx  2 fog root 4096 Nov 14 07:25 54bf642068ae
                      drwxrwxrwx  2 fog root 4096 Nov 30 14:13 54bf64334d40
                      drwxrwxrwx  2 fog root 4096 Oct 26 12:06 54bf64495fa7
                      -rwxrwxrwx  1 fog root    0 Nov 27  2017 .mntcheck
                      drwxrwxrwx  2 fog root 4096 Nov 30 10:53 postinitscripts
                      itsupport@259-fog:~$
                      
                      G 1 Reply Last reply Nov 30, 2018, 2:22 PM Reply Quote 0
                      • G
                        george1421 Moderator @Kevin Talbot
                        last edited by george1421 Nov 30, 2018, 8:17 AM Nov 30, 2018, 2:16 PM

                        @Kevin-Talbot Ok that raised another question. Why don’t we see the directories with mac addresses like you posted with the screen shot? Never mind I see that is a different host

                        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!

                        1 Reply Last reply Reply Quote 0
                        • G
                          george1421 Moderator @Kevin Talbot
                          last edited by Nov 30, 2018, 2:22 PM

                          @Kevin-Talbot what about selinux status?

                          The permissions look ok? Did you try to drag and drop a mac address directory from /images/dev to /images logged in with the fog account?

                          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!

                          K 2 Replies Last reply Nov 30, 2018, 2:29 PM Reply Quote 0
                          • K
                            Kevin Talbot @george1421
                            last edited by Nov 30, 2018, 2:29 PM

                            @george1421 I just dragged 54bf64334d40 folder to images with no issues0_1543588149440_drag.JPG

                            G 1 Reply Last reply Nov 30, 2018, 2:32 PM Reply Quote 0
                            • K
                              Kevin Talbot @george1421
                              last edited by Nov 30, 2018, 2:31 PM

                              @george1421 the original error appears to indicate it is trying to move 54bf64334d40 on the 172.16.220.246 though?0_1543588313701_error.JPG

                              G 1 Reply Last reply Nov 30, 2018, 2:37 PM Reply Quote 0
                              • G
                                george1421 Moderator @Kevin Talbot
                                last edited by Nov 30, 2018, 2:32 PM

                                @Kevin-Talbot well this is a good one. It “should be” working.

                                In the storage node configuration for this remote node. The image path and ftp path point to /images?

                                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!

                                K 1 Reply Last reply Nov 30, 2018, 2:37 PM Reply Quote 0
                                • G
                                  george1421 Moderator @Kevin Talbot
                                  last edited by Nov 30, 2018, 2:37 PM

                                  @Kevin-Talbot said in Updating Database failed! Failed to open stream!:

                                  @george1421 the original error appears to indicate it is trying to move 54bf64334d40 on the 172.16.220.246 though?0_1543588313701_error.JPG

                                  Ah that explains the not able to find the stream error. I’m looking at the kernel parameters from your post. I don’t see where its referencing 172.16.220.246. From the kernels parameters it should be interacting with 172.16.100.246

                                  Can you post a screen shot of the storage node configuration for this remote node?

                                  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!

                                  1 Reply Last reply Reply Quote 0
                                  • K
                                    Kevin Talbot @george1421
                                    last edited by Nov 30, 2018, 2:37 PM

                                    @george1421 I must be missing something very stupid somewhere…

                                    Both ubuntu firewalls are off btw!

                                    0_1543588613404_node.JPG

                                    G 1 Reply Last reply Nov 30, 2018, 2:39 PM Reply Quote 0
                                    • G
                                      george1421 Moderator @Kevin Talbot
                                      last edited by Nov 30, 2018, 2:39 PM

                                      @Kevin-Talbot We may need to turn this back over to the developers since it should not be doing what its doing.

                                      Just for clarity, are you using the location plugin to direct the clients to the proper storage nodes?

                                      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!

                                      K 1 Reply Last reply Nov 30, 2018, 3:00 PM Reply Quote 1
                                      • K
                                        Kevin Talbot @george1421
                                        last edited by Nov 30, 2018, 3:00 PM

                                        @george1421 said in Updating Database failed! Failed to open stream!:

                                        proper storage nodes?

                                        George you are the HERO thankyou !!!

                                        So a long time ago we did use locations but stopped using them.

                                        However, it appears a colleague has added a new location with the new node name attached and ticked the: Use inits and kernels from this node box…grrrrrr

                                        I added the location to the host and restarted the capture and bingo all sorted!!!

                                        Sorry to waste your time!

                                        G 1 Reply Last reply Nov 30, 2018, 3:04 PM Reply Quote 0
                                        • G
                                          george1421 Moderator @Kevin Talbot
                                          last edited by Nov 30, 2018, 3:04 PM

                                          @Kevin-Talbot Well this is one for the record books.

                                          As always, its the last place you looked is where the problem is found. We should have started looking in the last place first. 😉

                                          I’m glad you have it sorted out. Everything was pointing towards it should have been working…

                                          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!

                                          K 2 Replies Last reply Nov 30, 2018, 3:19 PM Reply Quote 0
                                          • 1
                                          • 2
                                          • 2 / 2
                                          2 / 2
                                          • First post
                                            26/40
                                            Last post

                                          158

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project