Cannot connect to database after Ubuntu update and putting a password on MySql database
-
the “update/install failed” was because it couldn’t connect to the database, because fog didn’t have the database password set
now that you’re on 1.2.0, you need to edit the password in <web-root>/fog/lib/fog/Config.class.php -
thank you Junkhacker. i went into the Config.class file and added the password i had inadvertently added when i did the first Ubuntu update. It is still not working. One question, how do you gracefully exit Vi after editing? I typed zz and that did seem to close the file out but i didnt know how to get back to the prompt i know and love. So, i shutdown the server and restarted it. (I know, right?) I went back into the file to make sure the changes were there but got an error about the file still being open or not having been closed correctly and was walked thru fixing it. Well, the file now has the password in it, but still when I try to access Fog from the browser it prompts to install/upgrade the database and still bombs out. #anotherdaywasted I gotta head back up the beach. This server is 60 miles away from my office. Maybe some suggestions for tomorrow? Thanks so much for any help, i’m sure it is apparent, i have no idea what i am doing.
-
@obxmaureen said:
One question, how do you gracefully exit Vi after editing?
:w means write
:q means quit
:wq means write then quit
:q! means quit without savingThese are in the tutorial I linked.
-
@obxmaureen said:
One question, how do you gracefully exit Vi after editing?
:w means write
:q means quit
:wq means write then quit
:q! means quit without savingThese are in the tutorial I linked. https://wiki.fogproject.org/wiki/index.php/Vi
-
thanks Wayne, i did use those commands. q or q! never took me back to the prompt. They never really moved my cursor out of the file. zz moved the cursor down to the bottom of the screen but never gave me the prompt. Believe me, your info and the link for Vi was valuable indeed and i appreciated it. I now have the password in the file but still get prompted to install/upgrade the database when i hit fog from the browser. And then the task fails
am i SOL with this thing at this point?
-
i recommend opening the file and making sure the changes were saved
-
@obxmaureen said:
thanks Wayne, i did use those commands. q or q! never took me back to the prompt. They never really moved my cursor out of the file.
You have to hit the “Esc” key to exit insert mode and go into command mode. Only in command mode does commands work.
-
@Junkhacker I did, they are. Still getting an error trying to upgrade the database in the browser.
-
@Wayne-Workman i realized i was missing the colon before the commands. oops. but i did manage to get the file changed. Still cant get the database to update. I have to leave for a couple days. Tom was trying to help me remotely but i think he was having issues with teamview. Maybe it’s just gonna have to be a wash. UGH!
-
@obxmaureen Vi works terribly through TeamViewer… Vim works perfectly though with TeamViewer.
I’d say perhaps try to uninstall mysql and mysql-server and try to install mariadb on the box, and then run the installer.
You’ll need to figure out how to take off mysql and this site looks like a good walk through for installing mariadb.
http://www.liquidweb.com/kb/how-to-install-mariadb-5-5-on-ubuntu-14-04-lts/ -
@Wayne-Workman but then wouldnt i lose all my info? Would i have to recreate the images? I hope you know, i do appreciate all this feedback!
-
@Wayne-Workman and i think Tom was having a hard time just staying connected, he never got farther that getting a putty session open. No biggie, he tried and i do appreciate that.
-
@obxmaureen said:
@Wayne-Workman but then wouldnt i lose all my info? Would i have to recreate the images? I hope you know, i do appreciate all this feedback!
If you can connect to the DB manually, you can easily export the entire DB.
There are examples here:
https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQLAlso, the information in the DB is not your actual images. Your images are files located in the /images directory. The data in the DB is simply information about your images. We call this information the Image Definition.
-
@Wayne-Workman ok, yeah, i understand my images are separate but i just wanted to make sure they wouldnt lose their DB identity. This may be a little above my area of expertise or even more than i have time for, but i will give it a look tomorrow and tackle it thursday if i am back down this way, or next monday. (I bet you cant wait!) Thanks so much, really, thanks
