database update failed after capture

[alansopro]

When trying to capture a new image when it completes and gives me an error ‘Update database failed’. Any ideas?

Running FOG 1.3.0 RC4

[george1421]

Is this a new install of FOG? Meaning you just spun up a new fog server?

Can you confirm that the fog (linux) user has the correct password set? Try to log into your fog server using ftp with the fog (linux) user account. This user ID and password will be on the storage node page.

[Tom Elliott]

@alansopro “It’s not working” is not a good way to inform us of a problem.

Can you show us what the actual message says?

Can you provide the apache and/or the installer error logs?

[Quazz]

@alansopro This is typically caused by FTP password issues.

[alansopro]

The error is ‘Update database failed’ right after it finishes capturing an image it repeats that line and then restarts and tries to capture an image again. Not sure how else to explain it…

I was running FOG 1.2.0 which was working fine and upgraded to FOG 1.3.0 RC4. Since then I can’t capture a new image. The only difference is I had to change the storage node to /images/EXT/ last week and @Tom-Elliott was able to resolve that issue for me last week. When trying to capture an image now though it won’t work. Does an FTP directory /user need to be added access you think?

[Quazz]

@alansopro https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP#Credentials_.2F_Passwords

[alansopro]

@Quazz Okay. So it looks like that password was incorrect i updated and I’m trying to capture a new image again when it’s done I will update. Thank you.

[alansopro]

After updating the password field and restarting FOG it seems I no longer can PXE boot. If I remove the task it will load the FOG menu but when trying to start capturing an image it says the following.

http://ip/fog/service/ipxe/boot.php......input/output error Could not boot.

I’m wondering if the problem isn’t the computer itself though…

[george1421]

@alansopro You can’t pxe boot for a known or unknown device?

If its either than please post the results of this url
http://<fog_server_ip>/fog/service/ipxe/boot.php?mac=00:00:00:00:00:00

Please post the results in the forum. But it sounds like your fog sql password is now a mismatch. Your fog (linux) and fog (sql) passwords are not linked by design. Its strange that both would get out of sync when you upgraded. I know that the fog (linux) password gets reset sometimes during the upgrade.

Also it might be interesting to tail the apache error log to see if apache threw an error when you tried to boot.

[Quazz]

@alansopro Is Secure Boot enabled per chance?

[alansopro]

@Quazz No just regular PXE boot.

@george1421 I updated a field in the file .fogsettings called ‘password’. I will login to mysql and set them all the same and try again before going into more detail.

[alansopro]

@george1421 i went to the address you said and the page reads out as…

#!ipxe
set fog-ip <server ip>
set fog-webroot fog
set boot-url http://$(fog-ip)/$(fog-webroot)

I’ve updated the passwords for MySQL and also changed them in the .fogsettings. Still giving me the I/O error. I’m wondering if it’s the PC itself. I’m going to try plugging in another one.

[george1421]

@alansopro Please check the apache error log in /var/log/http/error_log or where ever ubuntu puts it in error.log This will give more details on what is wrong.

In the case of the output from boot.php I’m going to say the fog sql password is wrong. You should be able to see this user id and password from the web gui too. Then try to login to mysql with something like, mysql -u fog -p fog and then enter the fog (sql) password.

[alansopro]

@george1421

I did just realize there was a newer version of FOG out. RC5. I was upgrading to it and at the end it did give me a failed message when starting up the NFS server.

‘Setting up and starting NFS server: Failed!’

Could this be cuasing my I/O error and how would I go about resolving this one?

[george1421]

@alansopro No you are not that far yet. It still may be an issue, but not in this case. FOG uses mysql data to build out the reset of the boot.php page. There is a bunch of text missing from what you posted.

[alansopro]

@george1421 The only users I have listed in my MySQL is fogstorage and root. I have no fog user. I looked in the web config directory where the login is defined and the DB is fog using the login root and the password.

[george1421]

@alansopro Ok then we need the error message from apache error log.

[Tom Elliott]

I’m oh so very lost in what’s happening here.

@alansopro, you’ve gone through the FTP steps, and NOW the pxe boot doesn’t work? How isn’t it working? Is there an error message, or something we can help you troubleshoot further?

That said, resetting your password would have 0 impact on the booting capability of PXE. So unless there’s something seriously misconfigured we need a lot more information please.

Preferrably, Apache error logs, Installation Error logs, pictures, and more details than “I did this, now that ain’t working”.

[george1421]

@Tom-Elliott Tom, in this post https://forums.fogproject.org/topic/8236/database-update-failed-after-capture/11 FOG is only filling out the top section of the iPXE menu when boot.php is called directly. My guess is that something is wrong with access the msql server, but that is only a guess.

The OP does have 2 issues. One was resolved with correcting the ftp (linux) user password.

[alansopro]

@george1421 The problem was the actual computer. I plugged in another one and it PXE boots fine but now the NFS server isn’t starting so i can’t capture image due to that.