Wake-Up task

TheWizardUk

think i might have found the issue

mysqli::mysqli(): (28000/1045): Access denied for user ‘root’@‘localhost’ (using password: NO)

TheWizardUk

maybe not the password is in /var/www/fog/commons config.php

Tom Elliott

From what I’m seeing in your information, your /var/www/fog/commons/config.php does not have a password set for the sql user. However, you most likely have one set for the database which could be the problem being encountered. How you were able to get to the screen in the first place is a little strange to me though. It shouldn’t have allowed you to access the FOG GUI at all, at the most redirecting to the schema updater page.

TheWizardUk

in config .php

define(‘DATABASE_PASSWORD’,‘Mypassword’);

is set

TheWizardUk

i have 122 entries of below in today’s Apache log. why is it using password: NO?

[Sat Jun 14 09:45:18 2014] [error] [client 172.18.129.59] PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user ‘root’@‘localhost’ (using password: NO) in /var/www/fog/lib/db/MySQL.class.php on line 64

Tom Elliott

Is this on the actual FOG Server or the node?

TheWizardUk

this is line 64 from /var/www/fog/lib/db/MySQL.class.php

if (!$this->link = new mysqli($this->host, $this->user, $this->pass))

TheWizardUk

fog server

Tom Elliott

Can you try rerunning the installer? Was there any problems before?

I ask because it’s just strange that it’s trying to use no password when it’s clearly defined. Maybe the php-mysql module isn’t installed?

TheWizardUk

i have been running 0.32 for some time without issue, yesterday i updated to 1.1.0 and today i went to 1.1.1

re install just done foginstall.log below (no issues that i can see)

Script started on Sat 14 Jun 2014 15:50:24 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.1 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: 172.18.130.197
DHCP router Address:
DHCP DNS Address:
Interface: eth0
Using FOG DHCP: 0
Internationalization: 0
Donate: 0

     DHCP will NOT be setup but you must setup your
     current DHCP server to use FOG for PXE services.

     On a Linux DHCP server you must set:
         next-server

     On a Windows DHCP server you must set:
         option 066 & 067

Option 066 is the IP of the FOG Server: (e.g. 172.18.130.197
Option 067 is the undionly.kpxe file: (e.g. undionly.kpxe)

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:
linux-headers-2.6.32-38 libtommath0 linux-headers-2.6.32-38-server
Use ‘apt-get autoremove’ to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

Installing package: mysql-client
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: 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) n
Please enter your mysql password:
Please re-enter your mysql password:
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://172.18.130.197/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…Skipped
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://172.18.130.197/fog/management[/url]

  Default User:
         Username: fog
         Password: password

Script done on Sat 14 Jun 2014 15:52:57 BST

Tom Elliott

Just weird man, that its using a “blank” password for WOL. It’s all calling the same functions so it shouldn’t be trying to do that.

I may have found (on a side note) the bug with the client updater, awaiting return on test client.

TheWizardUk

its also worth mentioning that until today my apache2 error logs we 90kb to 150kb however today its 10mb

Tom Elliott

That, I don’t know much about, if you want you can try posting a few snippets of them here. It sounds like it’s not reading the config.php file properly though and for that I don’t have a simple answer for trouble shooting.

I suppose, you could try changing the DATABASE_HOST from localhost to the IP of the fog server. I’m thinking the “upgrade” process is breaking it at the moment. I was playing with the installer files yesterday evening and found a more approachable method to system updates. If you’d be willing, can you upgrade to SVN?

[code]svn co https://svn.code.sf.net/p/freeghost/code/trunk fog_svn
cd fog_svn/bin
sudo ./installfog.sh[/code]

Maybe this will help fix these issues hopefully? I know it will also fix the client updater problems. You can try the MSI updater you were trying earlier, though I don’t think that will work because the service never calls it, but it should download and return as if it wants to update.

TheWizardUk

when installing SVN

Please enter your mysql password:
Please re-enter your mysql password:
…/lib/ubuntu/functions.sh: line 330: [: !=: unary operator expected

TheWizardUk

Script started on Sat 14 Jun 2014 16:19:54 BST
Ubuntu
…#######:. …,#,… .::##::.
.:###### .:;####:…;#;…
…##… …##;,;##::::.##…
,# …##…##:::## …::
## .::###,##. . ##.::#.:######::.
…##:::###::…#. … .#…#. #…#:::.
…:####:… …##…##::## … #
# . …##:,;##;:::#: … ##…
.# . .:;####;::::.##:::;#:…
# …:;###…
###########################################

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.1 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: 172.18.130.197
DHCP router Address:
DHCP DNS Address:
Interface: eth0
Using FOG DHCP: 0
Internationalization: 0
Donate: 0
DHCP will NOT be setup but you must setup your
current DHCP server to use FOG for PXE services.
On a Linux DHCP server you must set:
next-server
On a Windows DHCP server you must set:
option 066 & 067
Option 066 is the IP of the FOG Server: (e.g. 172.18.130.197
Option 067 is the undionly.kpxe file: (e.g. undionly.kpxe)
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:
linux-headers-2.6.32-38 libtommath0 linux-headers-2.6.32-38-server
Use ‘apt-get autoremove’ to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Installing package: mysql-client
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: 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) n
Please enter your mysql password:
Please re-enter your mysql password:
…/lib/ubuntu/functions.sh: line 330: [: !=: unary operator expected
Setting up and starting Apache Web Server…OK
Configuring Fresh Clam…OK
Setting up storage…OK
Setting up and starting NFS Server…OK
Setting up and starting DHCP Server…Skipped
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://172.18.130.197/fog/management[/url]
  Default User:
  Username: fog
  Password: password
  Script done on Sat 14 Jun 2014 16:21:25 BST

Tom Elliott

Okay,

I should have a “cleaned” version of the install scripts now. One where it won’t throw unary operator errors.

Tom Elliott

Just go into the folder and run[code]svn update[/code]
and cd bin and rerun installer.

TheWizardUk

At revision 1838.
…/lib/ubuntu/functions.sh: line 309: [: : unary operator expected

Tom Elliott

can you try again? Svn update, etc…

TheWizardUk

sorted thank you

Wake-Up task

FOG

Free Computer Imaging Solution

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

Developers:

Chuck Syperski

Jian Zhang

Peter Gilchrist

Tom Elliott

GNU GPL Version 3

FOG

Free Computer Imaging Solution

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

Developers:

Chuck Syperski

Jian Zhang

Peter Gilchrist

Tom Elliott

GNU GPL Version 3

207

12.1k

17.3k

155.3k