Updating Database failed! Failed to open stream!

[george1421]

@Kevin-Talbot This thread is almost 1 month old. I take it, its still an issue?

Can you take a clear screen shot of the error so we can see the context of the error? It sounds like the linux user fog’s account password was changed/is out of sync with the webui. I have a tutorial on how to get everything back in alignment here: https://forums.fogproject.org/topic/11203/resyncing-fog-s-service-account-password

The fog service account should exist on the fog master node the storage node should have their own service account too.

[Kevin Talbot]

@george1421 Hi yes very much still an issue thanks for replying!

I can deploy from and capture to the master fog server perfectly fine.

I can deploy from but NOT capture to the node

Struggling to get the screenshot to upload fails at 97% grrr…

[Kevin Talbot]

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

and storage node have changed as well?

Thanks for the reply Sebastian!

Only the node subnet has changed, I re-ip’d it as per the book!

[george1421]

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

I can deploy from but NOT capture to the node

You can’t normally capture to a storage node. Only the master node in a storage group can be used to capture images. I just want to make sure we are on the same page here.

[Kevin Talbot]

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

node. Only the master node in a storage group can be used to capture im

I’ve always captured to a node, I have a separate storage group with one node in it which is the master for that storage group!

But I think you may have just nailed the problem…when I moved the node I renamed it and re-ip’d it and something tells me I may have deleted the old “named” node and added the newly “named” node but not clicked “master”

[Sebastian Roth]

@Kevin-Talbot Have you checked the storage node settings in the web UI?

[Kevin Talbot]

@Kevin-Talbot I just made the node a master but that has not cured the problem!

[Kevin Talbot]

@Sebastian-Roth yes and master was not ticked! I have ticked it but that has not cured the issue!

[Kevin Talbot]

This post is deleted!

[Kevin Talbot]

@george1421 whats the size limit on uploading an image to the forum please?

[george1421]

@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.

[Kevin Talbot]

@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?

[Kevin Talbot]

@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!

[Kevin Talbot]

@george1421

[george1421]

@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.

[Kevin Talbot]

@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.246

[Kevin Talbot]

@george1421

1. permissions on images and dev folder

[george1421]

@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.

[Kevin Talbot]

@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

[Kevin Talbot]

@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:~$