Hi Tom,

Attached is MySQL error log file. The forum won’t let me post it.

[url=“/_imported_xf_attachments/1/1004_MySqlerrorLog.txt?:”]MySqlerrorLog.txt[/url]

Hi Tom,

Do you think I should downgrade to 0.32? This was the version we had before the upgrade.
Luckily I created the database backup before upgrading to 1.1.0; and we’ve got images that were created with the 0.32. Will these images work after the downgrade?

Also how do I go about the downgrade?

Thanks.

An update:

I’ve just had a look at my /var/log/apache2/error.log after trying to login to the web UI unsuccessfully; the error log says:

[COLOR=#ff0000][Mon Jun 16 08:34:19 2014] [error] [client 200.168.212.226] PHP Fatal error: Call to a member function mainMenu() on a non-object in /var/www/fog/management/index.php on line 70, referer:[URL=‘http://<ip_address>/fog/management/?node=login’][COLOR=#ff0000]http://200.168.212.226/fog/management/?node=login[/COLOR][/URL][/COLOR]

And below is a copy of my install.log from /var/log/foginstall.log:

Script started on Mon 16 Jun 2014 07:53:39 BST

   ..#######:.    ..,#,..     .::##::.   

.:###### .:;####:…;#;…
…##… …##;,;##::::.##…
,# …##…##:::## …::
## .::###,##. . ##.::#.:######::.
…##:::###::…#. … .#…#. #…#:::.
…:####:… …##…##::## … #
# . …##:,;##;:::#: … ##…
.# . .:;####;::::.##:::;#:…
# …:;###…
###########################################

FOG

Free Computer Imaging Solution

[url]http://www.fogproject.org/[/url]

Developers:

Chuck Syperski

Jian Zhang

Peter Gilchrist

Tom Elliott

GNU GPL Version 3

###########################################
Version: 1.1.0 Installer/Updater

• Found FOG Settings from previous install at: /opt/fog/.fogsettings
• Performing upgrade using these settings…
  Starting Debian / Ubuntu / Kubuntu / Edubuntu Installtion.

#####################################################################
FOG now has everything it needs to setup your server, but please
understand that this script will overwrite any setting you may
have setup for services like DHCP, apache, pxe, tftp, and NFS.

It is not recommended that you install this on a production system
as this script modifies many of your system settings.
This script should be run by the root user on Redhat or with sudo on Ubuntu.
** Notice ** Redhat users will need to disable SELinux and iptables in
order to use FOG
Please see our wiki for more information at [url]http://www.fogproject.org/wiki[/url]

Here are the settings FOG will use:
Base Linux: Debian
Detected Linux Distribution: Ubuntu
Installation Type: Normal Server
Server IP Address: 200.168.212.226
DHCP router Address: 200.168.212.220
DHCP DNS Address:
Interface: eth0
Using FOG DHCP: 1
Internationalization: 0
Donate: 0

Are you sure you wish to continue (Y/N) y
Installation Started…
Installing required packages, if this fails
make sure you have an active internet connection.

• Preparing apt-get
• Installing package: apache2
• Installing package: php5
• Installing package: php5-json
• Installing package: php5-gd
• Installing package: php5-cli
• Installing package: php5-mysql
• Installing package: php5-curl
• Installing package: mysql-server
  We are about to install MySQL Server on
  this server, if MySQL isn’t installed already
  you will be prompted for a root password.
  Press enter to acknowledge this message.
  Reading package lists…
  Building dependency tree…
  Reading state information…
  mysql-server is already the newest version.
  The following packages were automatically installed and are no longer required:
  libtommath0
  Use ‘apt-get autoremove’ to remove them.
  0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
• Installing package: mysql-client
• Installing package: isc-dhcp-server
• Installing package: tftpd-hpa
• Installing package: tftp-hpa
• Installing package: nfs-kernel-server
• Installing package: vsftpd
• Installing package: net-tools
• Installing package: wget
• Installing package: xinetd
• Installing package: sysv-rc-conf
• Installing package: tar
• Installing package: gzip
• Installing package: build-essential
• Installing package: cpp
• Installing package: gcc
• Installing package: g++
• Installing package: m4
• Installing package: htmldoc
• Installing package: lftp
• Installing package: openssh-server
• Installing package: php-gettext
• Installing package: clamav-freshclam
  Confirming package installation.
• Checking package: apache2…OK
• Checking package: php5…OK
• Checking package: php5-json…OK
• Checking package: php5-gd…OK
• Checking package: php5-cli…OK
• Checking package: php5-mysql…OK
• Checking package: php5-curl…OK
• Checking package: mysql-server…OK
• Checking package: mysql-client…OK
• Checking package: isc-dhcp-server…Failed!
• Checking for legacy package: dhcp3-serverOK
• Checking package: tftpd-hpa…OK
• Checking package: tftp-hpa…OK
• Checking package: nfs-kernel-server…OK
• Checking package: vsftpd…OK
• Checking package: net-tools…OK
• Checking package: wget…OK
• Checking package: xinetd…OK
• Checking package: sysv-rc-conf…OK
• Checking package: tar…OK
• Checking package: gzip…OK
• Checking package: build-essential…OK
• Checking package: cpp…OK
• Checking package: gcc…OK
• Checking package: g++…OK
• Checking package: m4…OK
• Checking package: htmldoc…OK
• Checking package: lftp…OK
• Checking package: openssh-server…OK
• Checking package: php-gettext…OK
• Checking package: clamav-freshclam…OK
  Configuring services.
• Setting up fog user…Exists
• Setting up and starting MySql…OK
• Backing up user reports…OK
• Did you leave the mysql password blank during install? (Y/n) Y
• Setting up and starting Apache Web Server…OK
  You still need to install/update your database schema.
  This can be done by opening a web browser and going to:
  [url]http://200.168.212.226/fog/management[/url]
  Press [Enter] key when database is updated/installed.
• Configuring Fresh Clam…OK
• Setting up storage…OK
• Setting up and starting NFS Server…OK
• Setting up and starting DHCP Server…OK
• Setting up and starting TFTP and PXE Servers…OK
• Setting up and starting VSFTP Server…OK
• Setting up sudo settings…OK
• Setting up FOG Snapins…OK
• Setting up and building UDPCast…OK
• Installing init scripts…OK
• Setting up FOG Services…OK
• Starting FOG Multicast Management Server…OK
• Starting FOG Image Replicator Server…OK
• Starting FOG Task Scheduler Server…OK
• Setting up FOG Utils…OK

Would you like to notify the FOG group about this installation?
* This information is only used to help the FOG group determine
if FOG is being used. This information helps to let us know
if we should keep improving this product.
Send notification? (Y/N)N
NOT sending notification.

Setup complete!
You can now login to the FOG Management Portal using
the information listed below. The login information
is only if this is the first install.
This can be done by opening a web browser and going to:
[url]http://200.168.212.226/fog/management[/url]
Default User:
Username: fog
Password: password

Script done on Mon 16 Jun 2014 08:06:43 BST

Just in case, I’m running Ubuntu 10.04 OS.

Any ideas?

Hello,

I’ve now ran the installer again this time leaving the MySQL password blank. However, I can’t still login to the FOG web UI with the default login “fog” and “password” that I’ve always used.

This is happening when I try to login to the web UI on the FOG server itself and from a client PC.

Any ideas?

Thanks.

OK, I can re-run the installer again; then this time leaving MySQL password blank.

Thanks

And this is the issue as reported in web UI…

[url=“/_imported_xf_attachments/0/997_FOGISSUE.jpg?:”]FOGISSUE.jpg[/url]

This is the prompt I got with or without MySQL password in Config.php when I typed “MySQL -u root fog” command at the Terminal…

[url=“/_imported_xf_attachments/0/996_FOG2.jpg?:”]FOG2.jpg[/url]

No I’m afraid, still not working.
Seems a strange problem.

Password removed.

Thanks.

Yes.

Typed that in and it took me straight to MySQL> prompt. There was no prompt for credentials.

Thanks.

I’ve changed the ‘localhost’ to the server’s IP address and restarted MySQL but still didn’t resolve the issue.

Is there a way I can test MySQL login via Terminal to see if it prompts me for the credentials?

Thanks.

Yes the password was set by the installer after I ran the re-install. The host is set as ‘localhost’.

Thanks.

Just checked, the password has already being set there by the installer but can’t perform the schema upgrade via the web UI still.

Thanks.

I’ve restarted the database; still not working.

Just in case, I’ve now set a password to MySQL during re-install - which I previously left blank. Is there any way I can make FOG use this new password?

Thanks.

No, I’m afraid.

I tried doing a re-install - with a view of correcting the problem but when I try to upgrade via the web UI; I get the following error on the web browser.

The error was very long, abt 87 pages on a Word doc. I’ve only shown some here.

Any ideas please?

Thanks.
[SIZE=6][B]Database Schema Installer / Updater[/B][/SIZE]

Update/Install Failed!
[SIZE=5][B]The following errors occured[/B][/SIZE]

[B]Update ID:[/B] 1 - 0
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE DATABASE fog

[B]Update ID:[/B] 1 - 1
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE TABLE fog.groupMembers (
gmID int(11) NOT NULL auto_increment,
gmHostID int(11) NOT NULL,
gmGroupID int(11) NOT NULL,
PRIMARY KEY (gmID),
KEY new_index (gmHostID),
KEY new_index1 (gmGroupID)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

[B]Update ID:[/B] 1 - 2
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE TABLE fog.groups (
groupID int(11) NOT NULL auto_increment,
groupName varchar(50) NOT NULL,
groupDesc longtext NOT NULL,
groupDateTime datetime NOT NULL,
groupCreateBy varchar(50) NOT NULL,
groupBuilding int(11) NOT NULL,
PRIMARY KEY (groupID),
KEY new_index (groupName)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Lol…I was typing in fog (without the single quotation marks).

Just to clarify the second line of the command looked like this:

UPDATE fog.users SET uPass = MD5(‘mypassword’) WHERE users.uName=‘fog’;

Thanks.

Hi Tom,

I’ve tried that now and I’m afraid it hasn’t fixed the issue.

Just in case, I’ve typed the command in within Terminal and changed the ‘PASSWORDFORFOGWEBGUIUSER’ to my desired password. Correct?

The user I wanted to login with was ‘fog’.

Thanks.

OK, will try that now and let you know straightaway.

Thanks.

Hi Tom,

Thanks for your response.

No I hadn’t set a password on my root account; certainly not since the upgrade was done on Wednesday.