Cannot connect to database after Ubuntu update and putting a password on MySql database

[Wayne Workman]

@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 saving

These are in the tutorial I linked.

[Wayne Workman]

@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 saving

These are in the tutorial I linked. https://wiki.fogproject.org/wiki/index.php/Vi

[obxmaureen]

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?

[Junkhacker]

i recommend opening the file and making sure the changes were saved

[Wayne Workman]

@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.

[obxmaureen]

@Junkhacker I did, they are. Still getting an error trying to upgrade the database in the browser.

[obxmaureen]

@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!

[Wayne Workman]

@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/

[obxmaureen]

@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!

[obxmaureen]

@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.

[Wayne Workman]

@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_MySQL

Also, 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.

[obxmaureen]

@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