Wake-Up task

[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