stuck on ubuntu 10.04 LTS Database

[dat]

When I click on Install/Upgrade Now, I get this message. .
I tried doing this but it didn’t work.

sudo nano /opt/fog/.fogsettings
Fill in the following portions
snmysqluser=“{root}”
snmysqlpass=“{password if you have one}”
snmysqlhost=“{localhost}”
Reset the mySQL database password to be what is in the config files
run
sudo dpkg-reconfigure mysql-server-5.5
replace the last two numbers if using a different version of mySQL
enter in the new password
From that point on it should stay working after rebooting.

Any ideas?

[Tom Elliott]

Based on the footer, it appears this is FOG 1.2.0?

Did you set a mysql root password?

[dat]

It is the FOG 1.2.0.

I changed the snmysqlpass=“{my password}”

and then entered it into the

sudo dpkg-reconfigure mysql-server-5.5

I get this and it kind of just pauses before bringing me back to #

160329 16:51:27 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
160329 16:51:27 [Note] /usr/sbin/mysqld (mysqld 5.5.47-0ubuntu0.14.04.1) starting as process 3755 …
mysql start/running, process 3887

Thanks for the help!

[Sebastian Roth]

@dat Usually when it’s a credentials issue you will see “access denied” or something like this. But I cannot see this on the sceenshot. Something wrong with the DB? Try on the command line? mysql --user=root -p…

[dat]

@Tom-Elliott I did.

[Tom Elliott]

@dat When you set this up in the /opt/fog/.fogsettings file, did you re-run the fog installer?

[dat]

@Sebastian-Roth It looks like I am able to get into MySQL

**Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.5.47-0ubuntu0.14.04.1 (Ubuntu)

Copyright 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> **

But I still can’t get the Database Schema Installer / Updater to work. Any thoughts?

Thanks for the help!!

[Sebastian Roth]

@dat In the mysql command line client try the same things as you see from the schema updater:

mysql> CREATE DATABASE fog;
...
...

[dat]

So I have the bad habit of doing tab to finish a line and removed udpcast-20120424.tar.gz and not udpcast-20071228.tar.gz . After I corrected the issue everything worked. Thanks @Sebastian-Roth and @Tom-Elliott for your help.

[Sebastian Roth]

@dat How did you solve the issue?! I am lost with what you are saying about udpcast… not related to mysql issue!?

[Tom Elliott]

@Sebastian-Roth just a guess but when it asks for password it set the db password with a tab.

[dat]

@Sebastian-Roth under the Update and Install Packages on https://wiki.fogproject.org/wiki/index.php?title=Ubuntu_14.04 it ask that you run this

cd Desktop/
cd fog_0.32/
cd packages
wget https://svn.code.sf.net/p/freeghost/code/trunk/packages/udpcast-20120424.tar.gz
rm -f udpcast-20071228.tar.gz
sed -i ‘s:udpcastout=“udpcast-20071228”:udpcastout=“udpcast-20120424”:’ …/lib/common/config.sh
sed -i ‘s:udpcastsrc=“…/packages/udpcast-20071228.tar.gz”:udpcastsrc=“…/packages/udpcast-20120424.tar.gz”:’ …/lib/common/config.sh
cd …/bin/
sudo ./installfog.sh

during the “rm -f udpcast-20071228.tar.gz” I hit tab and it did this “rm -f udpcast-udpcast-20120424.tar.gz”.

So I erased the tar.gz that I just downloaded. So it couldn’t find the package which I assume caused the errors.

I hope that clarifies things.