Image Capture/Upload gets to 100%, then Updating Database task fails

[erikd]

@Wayne-Workman said:

@erikd Just an FYI, 1.3.0 doesn’t exist yet We call the pre-1.3.0 “fog trunk”.

What OS have you installed FOG Trunk on? Did you set a mysql password? Can you give us more information about the hardware you’re uploading from?

Hi Wayne, thanks for your help. Yes I am on FOG Trunk not 1.3.0, sorry :-). It’s installed on Ubuntu 14.04.

I did not set a mysql password.

The hardware I’m trying to capture/upload an image from is a Dell Optiplex 790. When I was using the last version of FOG (different server), which I believe was 1.2.0 (?), I didn’t have any problems with these (we have lots of them).

One thing I should have mentioned in my original post: When I first did setup, I messed up the DHCPD.conf file and wasn’t intelligent enough to back it up first. So I re-ran the installer to re-create that file - could that have led to this problem?

[erikd]

@Sebastian-Roth said:

@erikd Is your web interface working fine? I guess it is if you are able to schedule an upload task. I am asking because “Updating Database” is just sending a HTTP request to the FOG webserver. Why would that fail?

Do you see any messages in your apache error log when this happens (/var/log/apache2/error.log)??

Can you please check if /var/www/fog/service/Post_Stage2.php (possibly it’s /var/www/html/fog/service/Post_Stage2.php) exists on your FOG server. Then try accessing this URL (http://your.fog.ip.address/fog/service/Post_Stage2.php) from any of your computers. You’ll probably see an error (“No Active Task found for Host”) but just to make sure this is kind of working as it should.

Hi Sebastian, thanks for your help.

As I just stated in the reply to Wayne, one thing I should have mentioned in my original post: When I first did setup, I messed up the DHCPD.conf file and wasn’t intelligent enough to back it up first. So I re-ran the installer to re-create that file.

To answer your questions, I have no problems I can find in the web interface - everything seems good.

I did find some errors in my Apache error.log:

[Mon Feb 08 16:21:58.567011 2016] [:error] [pid 4153] [client 192.168.1.1:49335] PHP Fatal error:  Uncaught exception 'Exception' with message 'FOGFTP: Login failed. Host: 192.168.1.1, Username: fog, Password: m59gl25QR3i/sjCNfH3KRn7aG+VJ1ECF279QzZ3V2cA=, Error: ftp_login(): Login incorrect.' in /var/www/html/fog/lib/fog/fogftp.class.php:29\nStack trace:\n#0 /var/www/html/fog/lib/pages/fogconfigurationpage.class.php(741): FOGFTP->connect()\n#1 [internal function]: FOGConfigurationPage->log()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(67): call_user_func(Array)\n#3 /var/www/html/fog/management/index.php(24): FOGPageManager->render()\n#4 {main}\n  thrown in /var/www/html/fog/lib/fog/fogftp.class.php on line 29, referer: http://192.168.1.1/fog/management/index.php?node=about&sub=client-updater

When I go to …/fog/service/Post_Stage2.php on the FOG server itself, I see the error “Invalid MAC Address!”

[erikd]

@Quazz said:

Can you tell us what revision you are on?

Hi Quazz, thanks for your help.

I am on revision 6213.

[Wayne Workman]

@erikd said:

When I first did setup, I messed up the DHCPD.conf file and wasn’t intelligent enough to back it up first. So I re-ran the installer to re-create that file - could that have led to this problem?

Nope. The DHCP config that fog builds for you is solid, I’ve been working to improve it.

Sounds like your issue might be FTP related. Check all the FTP credentials related stuff here in this article: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP

[Sebastian Roth]

Well, the FTP error is definitely not good and should be fixed but I don’t find this being related to the client not being able to update the database after uploading.

The “Invalid MAC Address” error is ok I think as you are accessing the page from a computer not registered in FOG. At least this php file seams ok!

Sure you don’t have any error in apache log when you see the error after upload?

[Tom Elliott]

@Sebastian-Roth The Upload task might fail if the image could not be FTP’d to the /images directory.

[Wayne Workman]

@Tom-Elliott Is there a way to get more specific errors from the upload script? Any way to check to see if the FTP move succeeded?

[Tom Elliott]

@Wayne-Workman Sorry, i’m not that good.

[erikd]

Thanks everyone, following the steps under Credentials / Passwords section in the following link fixed the issue.
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP#Credentials_.2F_Passwords

Really appreciate all your help - I got quicker support here than most of my paid support contacts!

[Wayne Workman]

@erikd said:

Really appreciate all your help - I got quicker support here than most of my paid support contacts!

Why don’t more people point this out ???

I mean really - quite honestly, greater than 90% of people here get a reply in under 10 minutes if they post during sane hours. And not just a “Thank you for posting, we will get with you” reply, but an actual answer or suggestion or advice.

And to imagine, we are volunteer powered.

FOG is something special, let me tell you. People here - seems like - race to answer first. and that’s an amazing thing! It’s the open source mind set. Learn, explore, share, and help others freely and openly. As open source freely flows, so to does information flow freely into and out of the helpers here. It’s a mind set. We don’t hoard information and answers for ourselves. If you ask us, we will give you our best answers, or try damn hard to find the best answers so that not only you can know, but so we can know too!

[Wayne Workman]

Problem and solution documented in the Wiki here: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP#Updating_Database...Failed

[darius]

@Wayne-Workman I had the same problem! This worked great Thanks

[virtuarafa]

@Wayne-Workman Thanks a lot, this did the trick, I had the exact same problem!