Backing up database - Failed - Rev 5952

[GFm]

I tried updating to the latest svn, but it gives me the backing up database… Failed error.

I tried doing it with the command no_proxy=“localhost” ./installfog.sh -y and it still does the same thing.

Any ideas?

Thanks!

[Wayne Workman]

@GFm inside of /opt/fog/.fogsettings change snmysqlhost= to localhost and try again. If that fails, change it to 127.0.0.1 and try again.

[Wayne Workman]

What OS & version is this on?

Are you running as root? If so, what command do you use to become root?

[Tom Elliott]

@Wayne-Workman I think it’s the line concat issue as described elsewhere which is corrected for in RC 10

[GFm]

@Wayne-Workman sorry! Ubuntu 13.10, fog rev5952 - Yes, running sudo no_proxy=“localhost” ./installfog.sh -y

[GFm]

@Tom-Elliott Anything you suggest I try?

Thanks guys!!

[Wayne Workman]

@GFm Just please wait for RC-10, or go back to RC-8 or 9.

[GFm]

@Wayne-Workman Gotcha… thank you!

[GFm]

@Wayne-Workman Sorry… how to I go about downgrading back to RC-9? I’ve used svn up on my trunk folder over and over, so I don’t have the last version downloaded.

Thanks again!

[Wayne Workman]

@GFm Go to Sourceforge and find the commit number you want. Look at the commit messages to figure this out. Then follow the bottom of this, where it says “Update to revision”.
https://wiki.fogproject.org/wiki/index.php?title=Upgrade_to_Revision

[GFm]

@Wayne-Workman Great, thank you!

[GFm]

@Wayne-Workman @Tom-Elliott
I tried going backwards (rc-8 and 5934 as well), but now I get the attached pic.

I checked out that config.class.php and it shows the correct settings to my DB, and I also restarted the mysql service, but no luck.

I can open a new post if you want since this is kind of separate, just let me know.

Thanks!

[Wayne Workman]

@GFm So you attempted updating… a day ago, and it failed? You should find a db backup inside of /home with a date and time in it’s name. Just import that, and then try to move to RC-9.

The way you import them (without mysql pass) is:
mysql < file

with a password:
mysql -u root -p < file

This is covered in more detail here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Manually_export_.2F_import_Fog_database

[GFm]

@Wayne-Workman When I look at this, all the backups from recent show 0. The last backup with data is April, but I know I updated in July and see no backups.

I went into my fog database in mysql… Inside it had data, so it is there. Any other ideas to try and get this working since I can’t restore one of those mysql backups?

Thanks a lot!

[Wayne Workman]

@GFm well… I guess this makes sense. Your installation fails at “backing up db” and the backups are 0 size.

@Tom-Elliott do you have thoughts on what is best to do?

I guess you could move to working-RC-10. This requires some special commands, message me for details.

[GFm]

@Wayne-Workman Tried updating to RC-10 and it gave me the same error as before about invalid database. Here is my config.class.php fil that it said to check out… Are my settings OK?

[Tom Elliott]

@GFm from terminal what happens if you run mysql -u root

[Wayne Workman]

@GFm inside of /opt/fog/.fogsettings change snmysqlhost= to localhost and try again. If that fails, change it to 127.0.0.1 and try again.

[GFm]

@Tom-Elliott

[Tom Elliott]

@GFm and same command but with -h 127.0.0.1

[GFm]

@Wayne-Workman same as before… tried both and restarted mysql service each time