• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Wake-Up task

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    23
    7.3k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T
      TheWizardUk
      last edited by

      think i might have found the issue

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

      1 Reply Last reply Reply Quote 0
      • T
        TheWizardUk
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott
          last edited by

          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.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          1 Reply Last reply Reply Quote 0
          • T
            TheWizardUk
            last edited by

            in config .php

            define(‘DATABASE_PASSWORD’,‘Mypassword’);

            is set

            1 Reply Last reply Reply Quote 0
            • T
              TheWizardUk
              last edited by

              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

              1 Reply Last reply Reply Quote 0
              • Tom ElliottT
                Tom Elliott
                last edited by

                Is this on the actual FOG Server or the node?

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                1 Reply Last reply Reply Quote 0
                • T
                  TheWizardUk
                  last edited by

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

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

                  1 Reply Last reply Reply Quote 0
                  • T
                    TheWizardUk
                    last edited by

                    fog server

                    1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott
                      last edited by

                      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?

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      1 Reply Last reply Reply Quote 0
                      • T
                        TheWizardUk
                        last edited by

                        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

                        1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott
                          last edited by

                          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.

                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          1 Reply Last reply Reply Quote 0
                          • T
                            TheWizardUk
                            last edited by

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

                            1 Reply Last reply Reply Quote 0
                            • Tom ElliottT
                              Tom Elliott
                              last edited by

                              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.

                              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                              1 Reply Last reply Reply Quote 0
                              • T
                                TheWizardUk
                                last edited by

                                when installing SVN

                                • Please enter your mysql password:
                                • Please re-enter your mysql password:
                                  …/lib/ubuntu/functions.sh: line 330: [: !=: unary operator expected
                                1 Reply Last reply Reply Quote 0
                                • T
                                  TheWizardUk
                                  last edited by

                                  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
                                  1 Reply Last reply Reply Quote 0
                                  • Tom ElliottT
                                    Tom Elliott
                                    last edited by

                                    Okay,

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

                                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                    1 Reply Last reply Reply Quote 0
                                    • Tom ElliottT
                                      Tom Elliott
                                      last edited by

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

                                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                      1 Reply Last reply Reply Quote 0
                                      • T
                                        TheWizardUk
                                        last edited by

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

                                        1 Reply Last reply Reply Quote 0
                                        • Tom ElliottT
                                          Tom Elliott
                                          last edited by

                                          can you try again? Svn update, etc…

                                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                          1 Reply Last reply Reply Quote 0
                                          • T
                                            TheWizardUk
                                            last edited by

                                            sorted thank you

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            206

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project