[fog] Broken from the Beginning

[MrSchism]

I figured it was about time I try out Fog, so I tossed it on my 'buntu box. I didn't realize that I had an SQL issue going on.

 

I was getting the error when trying to log into my fog server (192.168.1.4).

 

I read somewhere that I needed to go in and remove the passwords for my root SQL accounts. Having done that, the error is gone... but the problem persists.

 

Now, however, I'm left with a white screen.

 

Come to find out, my installation of fog isn't making any databases right off the bat...

 

All it's doing is installing (supposedly with success) and turning on my services.

 

I have no idea where to start or what I'm missing (if anything).

 

So... any help would be appreciated.

[cpjitservices]

i'd uninstall SQL, and FOG then install SQL again from fresh - set a root password because I'm sure somewhere in the installation of FOG it asks for a SQL password and it can't be blank - SO install SQL again and then install FOG and also re-install Apache and do it before you start installing FOG again 0 then once FOGS installed again give it another go.

[MrSchism]

I was hoping for a solution that was more direct in case that fails.

 

As I said, there was no fog database made.

[morganw]

The installer isn't designed to run on a production system, it's designed to be run on a previously unconfigured server. It's also possible to have problems running the installer behind a proxy, I think I had to manually install the tftp server package as well as ensuring my proxy was set in apt.conf.

[bart21]

When installing fog did you select the option for normal server or storage node?

[MrSchism]

Morgan: I'm not behind a proxy nor am I using it as one.

 

Bart: Normal.

 

Is Fog supposed to make a fog database during its installation? I read a config file and it said that it needed a

database named fog...

 

Yet there was none.

[netadmin]

I think Fog will prompt you to create a database the first time you login to the web console (rather than creating it during the install). Edited April 25, 2011 by netadmin

[MrSchism]

Does anyone have a clean install of Fog that I could get a copy of? I can edit the necessary file lines.... I just have a feeling that something is wrong.

[cpjitservices]

The installer isn't designed to run on a production system, it's designed to be run on a previously unconfigured server. It's also possible to have problems running the installer behind a proxy, I think I had to manually install the tftp server package as well as ensuring my proxy was set in apt.conf.

 

Yep. It's designed to run on a new unconfigured machine - I'd try and find another machine thats been wiped to stick it on or wipe the machine itself and start again.

[Chad]

I can see exactly where Bart21 is coming from in asking if you selected a Normal or Storage Node install - Storage Nodes present you with a blank screen from the web browser. FOG will "remember" which install you initially chose though so it may be worth checking the content of your /var/www/fog/management/index.php from the console of the server.

 

If it contains:

Then it thinks it's a storage node.

 

The "remembered" settings are in /opt/fog/.fogsettings so you can delete this file prior to a reinstall to ensure it asks all the questions again.

 

You don't necessarily have to remove your MySQL root pw - just ensure you enter it into these files after the fog install:

 

/var/www/fog/commons/config.php (values MYSQL_USERNAME and MYSQL_PASSWORD)

 

and the services file:

 

/opt/fog/service/etc/config.php (again, MYSQL_USERNAME and MYSQL_PASSWORD)

 

It's worth sticking with as it's a great piece of software when up and running.

 

Chad

[MrSchism]

Okay, I started with a blank-white screen. MySQL and Fog were both set to use a username of root with no password.

 

I replaced the password on the mysql root accounts (127.0.0.1 and localhost). It now gives me the "Unable to connect to Database

Msg: Failed to connect to server: localhost Server returned: Access denied for user 'root'@'localhost' (using password: NO)" error.

 

I go into /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php and set the password (for the sake of testing, it is currently "password").

 

It returns to an only-white screen.

 

Having used Fog before, I know it's a valuable piece of software when up and running. As wiping this machine... not possible. As well, I don't currently have another that isn't in use.

 

As for the aforementioned line about it being a storage node... that line of code is not present.

[bart21]

Hi

 

Firstly in the root of www ( or in the root of the fog dir if in a sub folder) please create a file named .htaccess in that file please copy the following line:

 

php_flag display_errors on

 

This will display any errors that it is giving.

 

Also in IE please go to page, and view source just check the page looks ok. Eg are the HTML tags both there at the top and bottom. Just trying to check the page is loading properly.

 

There are some other error options in the php.ini file which will display even deeper errors if the htaccess one failed. If you need them give me a shout after 9 when I will be infront of a server to refresh my memory.

 

Other than that, try creating an empty DB called fog and see if that triggers it.

 

Feel free to pm me if you want.

 

Nick

 

Ps is it a linux box or a win box?

Edited April 26, 2011 by bart21

[MrSchism]

Okay. I forgot to turn on the server before I left the house so I can't post all of the information or make any of the changes at the moment, but I can address some questions/suggestions.

 

This machine is technically a Kubuntu 10.10 machine. I created an empty database named fog. I'm going to see what happens when I delete the database (which may be making part of the issue). Any errors that are presented will be posted here. Should nothing occur, I'll recreate the fog database. I may even try to get a clean fog database and see what is in the database.

 

When I get home, I'll also make the .htaccess file. I'll check the HTML of the page to make sure everything's present and accounted for.

[MrSchism]

Okay... that may be part of the problem. I access 192.168.1.4/fog/management with the white screen... and there's nothing in the page source.

 

Okay. Good cause of the problem... now, a solution....

 

Please?

[Chad]

Have you had a look in the /var/log/apache2/error.log - any pointers in there?

[MrSchism]

Okay. I put a .htaccess file in the /var/www directory and one in the /var/www/fog directory (as well as one in the /opt/fog directory). No errors were thrown on the website.

 

I'm including the error.log as a text file: error.txt. Hopefully this will help in some way.

 

A gist of it is that a lot of stuff seems to just not exist... nor does it seem to get made when I install following the directions in the wiki.

[bart21]

I would say fog is not installed properly, if you delete the fog settings that someone mentions further up the thread, rename the www/fog to fogold anfd the same in the opt dir, and run the installfog.sh again.

 

nick

[MrSchism]

I got it! Thanks for the support, everyone.

 

I did a full uninstall/reinstall. When I went to edit the /var/www/fog/commons/config.php file, I think I accidentally entered in the password in the define( "DB_PASSWORD", MYSQL_PASSWORD );

 

Then when I tried by making the fog db, it screwed everything up.

 

On an aside, is it okay to delete the default user now that it's installed and I created a user or is that a no-no?

 

I know some programs rely on the default user they create... and I just got this working; I don't want to break it already.

[bart21]

Fog does rely on the default user. It uses it for FTP tasks( image renaming etc)

 

Nick

Edited April 27, 2011 by bart21

[MrSchism]

As a security buff, that kinda bothers me.

 

So, I can't delete the "username: fog

password: password" account...

 

Can I change it's password?

[bart21]

The ubuntu user fog password password needs to stay as it is.

 

You can remove the console user fog as that does nothing.

 

Nick

[MrSchism]

Awesome. That makes me feel better.