Updating Database failed! Failed to open stream!
-
Hi Guys please help!
Master Fog on VM Running Version 1.4.4 SVN Revision: 6077and single Node on pc, both running Ubuntu server 16.04.3
Recently physically moved the Node to new building and subnet. Renamed the node and re-ip’d it.
Also put a bigger Hard Drive in the Node
DEPLOY WORKS FINE FROM NODE !!!
But on Capture at 100% - Getting Database failed! Failed to open stream: no such file or directory
ran the following on the node and rebooted:
sudo chmod -R 777 /images
Also just changed all the passwords to match in the following locations and rebooted both:
Web Interface -> Storage Management -> [Your storage node] -> Management Username & Management Password
Web Interface -> FOG Configuration -> FOG Settings -> TFTP Server -> FOG_TFTP_FTP_USERNAME & FOG_TFTP_FTP_PASSWORD
The local ‘fog’ user’s password on the Linux FOG server
Server file: /opt/fog/.fogsettings -> password (For recent FOG Trunk versions only. 1.2.0 does not have this setting. 1.3.0 will though.)
Server file: /opt/fog/.fogsettings -> username (For recent FOG Trunk versions only. 1.2.0 does not have this setting. 1.3.0 will though.)But now getting:
Updating Database failed! Login incorrect
Please help as I think I am making it worse?
-
This post is deleted! -
I have rolled back the passwords and now back to: Updating Database failed! Failed to open stream: no such file or directory
However, I can actually Capture to the master fog node, just not to the separate node!
Must be permissions I think?
-
@Kevin-Talbot said:
Failed to open stream: no such file or directory
Never seen this error before but searching the web I found this on stackoverflow. Without having more details I cannot see where exactly it fails. So please take a look at the apache and fpm error log on your storage node and post here. See my signature on where to find those logs.
-
Can anyone help please?
-
@Kevin-Talbot Have you checked the error logs as suggested?
Rereading your initial post I noticed that you say you moved to a different subnet as well. Meaning IPs of master and storage node have changed as well?
Check all the IPs you have in /var/www/html/fog/lib/fog/config.class.php and /opt/fog/.fogsettings
-
@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-passwordThe fog service account should exist on the fog master node the storage node should have their own service account too.
-
@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…
-
@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!
-
@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.
-
@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”
-
@Kevin-Talbot Have you checked the storage node settings in the web UI?
-
@Kevin-Talbot I just made the node a master but that has not cured the problem!
-
@Sebastian-Roth yes and master was not ticked! I have ticked it but that has not cured the issue!
-
This post is deleted! -
@george1421 whats the size limit on uploading an image to the forum please?
-
@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.
-
@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?
-
@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!
-