Moving Images and changing image location

[Tim.Trageser]

This is what is filling the apache logs:

[Tue May 26 16:23:52.091869 2015] [:error] [pid 10042] [client 172.25.100.46:58826] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 146, referer: http://172.25.5.80/fog/management/index.php?node=home
[Tue May 26 16:23:53.348758 2015] [mpm_prefork:notice] [pid 10036] AH00169: caught SIGTERM, shutting down

[Tim.Trageser]

I am going to move the Apache issue to the Technical Help I think since it is now turning into something that is truely broken.

[Wayne Workman]

On the modified storage node, can you un-check the “Is Graph Enabled
(On Dashboard)” just to see if it makes a difference?

[Tim.Trageser]

I wish I could. Since Apache is not starting I can’t get to the Webpage.

[Wayne Workman]

@Tim.Trageser said:

move the Apache issue to the Technical Help I think since it is now turning into something

Can you re-run your installer?

[Tim.Trageser]

Already did, no change.

[Tom Elliott]

@Tim-Trageser Can you rerun installer, but as:

sudo ./installfog.sh --recreate-vhost --recreate-CA --recreate-keys

[Tim.Trageser]

No change still get * Setting up and starting Apache Web Server…Failed!

[Wayne Workman]

What exact distro of Linux and version are you running for this?

[Tim.Trageser]

Ubuntu 14.04 LTS
Fog - SVN 3463

[Tom Elliott]

Can you update and then try the installer command below?

[Wayne Workman]

Do what Tom says first. If that doesn’t work, then try this:

Can we try moving your DB to a new spot temporarily?

[CODE]mv /var/lib/mysql /var/lib/mysqlOLD[/CODE]

Then try re-starting apache and/or re-installing FOG.

[Tim.Trageser]

Well Apache starts now, but I get a blank screen when I open up the webpage.

[Wayne Workman]

Shift + F5

[Tim.Trageser]

Refreshing with Shift+F5 did not work. Just for transparency I did what Tom said and that fixed Apache. I did not do what Wayne suggested.

[Tom Elliott]

@Tim.Trageser said:

Refreshing with Shift+F5 did not work. Just for transparency I did what Tom said and that fixed Apache. I did not do what Wayne suggested.
Can you get a copy of the Apache error logs

[Tim.Trageser]

This is a snippet of the bottom of the log:

Apache Error Log

Any more ideas about getting the page to show properly, rather than just white? Should I do what Wayne suggested?

[Wayne Workman]

Well… What i suggested can easily be un-done by just swapping the directories back.

You might ought to export your DB before hand.

backup:
[CODE]mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql[/CODE]

restore:
[CODE]mysql -u root -p[root_password] [database_name] < dumpfilename.sql[/CODE]

Move the db out:
[CODE]mv /var/lib/mysql /var/lib/mysqlOLD[/CODE]

Put the db back:
[CODE]mv /var/lib/mysqlOLD /var/lib/mysql[/CODE]

After moving the DB out of there, you should be presented with the DB schema updater. Go ahead and do it. It can always be undone later by moving the files back.

[Tom Elliott]

Can you check that MySQL is running and if you have a MySQL password that it is properly set in config?

[Tim.Trageser]

MySQL is running and .fogsettings has the password set properly