SQL not working after update to 1.3.0 RC10

[maveriick]

I have updated this morning to Running Version 1.3.0-RC-10
SVN Revision: 5955 via GIT method
I have tried to update the SQL Database but it is failing.
Keeps coming back to the same screen

Any help would be appreciated
Thanks,
Rob

[Wayne Workman]

What OS & version is the fog server running?

[maveriick]

debian 8.5

[Wayne Workman]

@maveriick Try to run the installer like this:
snmysqlhost='127.0.0.1' ./installfog.sh -y

[maveriick]

Ok, So I tried that and the installer went all the way through.
But when I try to log in i get the same thing.
You guys are awesome and I look forward to getting this back up and running!

[Wayne Workman]

@maveriick so, inside of /opt/fog/.fogsettings change snmysqlhost= to 127.0.0.1, save, and re-run the installer, you should be good.

[maveriick]

Getting the same thing.
Gonna sleep on it tonight… C-ya in the AM.
Rob

[Wayne Workman]

@maveriick that’s weird. So, same thing as in the installer fails, or same thing with the web interface?

[maveriick]

The installer comes to the update database Schema. Then when I go to the Fog Management page as directed I attempt to install/upgrade now and it just is stuck in that loop. If I add in the switch and arguments below it also comes to that page. It does seem very weird.
Not sure where to go next.

[Tom Elliott]

@maveriick can you manually create the fog database then try the schema update? I think it’s failing due to the debug method call. So it never returns to allow the queries to run

[maveriick]

Ok, Being not overly informed on SQL and databases. How do I manually create the database?
Thanks,
Rob

[Tom Elliott]

@maveriick run on cli mysql -u root

Then just run create database fog

[maveriick]

Tom,
Not sure how long this should take…

I ran this about 20 minutes ago.
Thanks,
Rob

[Thiago]

@maveriick enter the ; and press enter to terminate the command…
all command must have ended with ;

[maveriick]

Thanks,
That at least gets me a bit more…
I received an error 1007 (hy000): Can’t create database ‘fog’; database exists.
I am assuming I need to move or delete the DB? If so how do I do that?

[Thiago]

@maveriick
Always make a backup first. Using fog suggestion should work (cd; mysqldump --allow-keywords -x -v fog > fogbackup.sql)
To drop a database : drop database fog;

[maveriick]

@Thiago I have done the recommendation without issue. But am still looping on the Fog Management… What could I be doing wrong?
Thanks,
Rob

[Thiago]

@maveriick After dropped the database, did you created another one? (just like @Tom-Elliott said)

[maveriick]

@Thiago Yes I did. I also rebooted and ran this again.
Still with the same issues.
Thanks,
Rob