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

    Database Schema / Installer

    Scheduled Pinned Locked Moved Solved
    Linux Problems
    2
    14
    2.9k
    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.
    • Tom ElliottT
      Tom Elliott @Cmid
      last edited by

      @Cmid Can you rerun the installer? It shouldn’t hurt anything.

      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
      • C
        Cmid
        last edited by

        I actually tried that yesterday. Trying it again now using the following command which I used initially:
        php_ver=‘7.0’ php_verAdds=‘-7.0’ ./installfog.sh -y

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

          @Cmid Lose the php_ver arguments.

          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 1
          • C
            Cmid
            last edited by

            Done

            I also remembered that in a panic I went ahead and downloaded the newest trunk as well.

            So I ran that and at the end I got:

            • Updating packages as needed…OK
            • Installing now everything is updated…Failed!
            Tom ElliottT 1 Reply Last reply Reply Quote 0
            • Tom ElliottT
              Tom Elliott @Cmid
              last edited by

              @Cmid Please edit the /opt/fog/.fogsettings file.

              Remove the php_ver lines and remove the packages line.

              Rerun.

              This will force fog to remove all your current php and apache files (the application not your mysql or web information). This should correct the problem once you rerun. It may take a while longer to run as well.

              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

              C 2 Replies Last reply Reply Quote 0
              • C
                Cmid @Tom Elliott
                last edited by

                @Tom-Elliott

                • Here are the settings FOG will use:

                • Base Linux: Debian

                • Detected Linux Distribution: Ubuntu

                • Server IP Address: 10.1.20.111

                • Server Subnet Mask: 255.255.255.0

                • Interface: eno1

                • Installation Type: Normal Server

                • Donate: 0

                • Internationalization:

                • Image Storage Location: /images

                • Using FOG DHCP: No

                • 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 and filename

                • On a Windows DHCP server you must set options 066 and 067

                • Option 066/next-server is the IP of the FOG Server: (e.g. 10.1.20.111)

                • Option 067/filename is the bootfile: (e.g. undionly.kpxe)

                • Installation Started

                • Installing required packages, if this fails
                  | make sure you have an active internet connection.

                • Adding needed repository…OK

                • Preparing Package Manager…OK

                • Packages to be installed:

                   apache2 bc build-essential cpp curl g++ gawk gcc gzip htmldoc lftp libap                         ache2-mod-php7.1 libc6 libcurl3 m4 mysql-client mysql-server net-tools nfs-kerne                         l-server openssh-server php7.1 php7.1-bcmath php7.1-cli php7.1-curl php7.1-fpm p                         hp7.1-gd php7.1-json php7.1-ldap php7.1-mbstring php7.1-mcrypt php7.1-mysql php7                         .1-mysqlnd php-gettext sysv-rc-conf tar tftpd-hpa tftp-hpa unzip vsftpd wget xin                         etd zlib1g
                  
                • Installing package: apache2…OK

                • Skipping package: bc…(Already Installe d)

                • Skipping package: build-essential…(Already Installe d)

                • Skipping package: cpp…(Already Installe d)

                • Skipping package: curl…(Already Installe d)

                • Skipping package: g++…(Already Installe d)

                • Skipping package: gawk…(Already Installe d)

                • Skipping package: gcc…(Already Installe d)

                • Skipping package: gzip…(Already Installe d)

                • Skipping package: htmldoc…(Already Installe d)

                • Skipping package: lftp…(Already Installe d)

                • Installing package: libapache2-mod-php7.1…OK

                • Skipping package: libc6…(Already Installed)

                • Skipping package: libcurl3…(Already Installed)

                • Skipping package: m4…(Already Installed)

                • Skipping package: mysql-client…(Already Installed)

                • Skipping package: mysql-server…(Already Installed)

                • Skipping package: net-tools…(Already Installed)

                • Skipping package: nfs-kernel-server…(Already Installed)

                • Skipping package: openssh-server…(Already Installed)

                • Installing package: php7.1…OK

                • Installing package: php7.1-bcmath…OK

                • Skipping package: php7.1-cli…(Already Installed)

                • Installing package: php7.1-curl…OK

                • Installing package: php7.1-fpm…OK

                • Installing package: php7.1-gd…OK

                • Skipping package: php7.1-json…(Already Installed)

                • Installing package: php7.1-ldap…OK

                • Installing package: php7.1-mbstring…OK

                • Installing package: php7.1-mcrypt…OK

                • Installing package: php7.1-mysql…OK

                • Skipping package: php7.1-mysql…(Already Installed)

                • Installing package: php-gettext…OK

                • Skipping package: sysv-rc-conf…(Already Installed)

                • Skipping package: tar…(Already Installed)

                • Skipping package: tftpd-hpa…(Already Installed)

                • Skipping package: tftp-hpa…(Already Installed)

                • Skipping package: unzip…(Already Installed)

                • Skipping package: vsftpd…(Already Installed)

                • Skipping package: wget…(Already Installed)

                • Skipping package: xinetd…(Already Installed)

                • Skipping package: zlib1g…(Already Installed)

                • Updating packages as needed…OK

                • Confirming package installation

                • Checking package: apache2…OK

                • Checking package: bc…OK

                • Checking package: build-essential…OK

                • Checking package: cpp…OK

                • Checking package: curl…OK

                • Checking package: g++…OK

                • Checking package: gawk…OK

                • Checking package: gcc…OK

                • Checking package: gzip…OK

                • Checking package: htmldoc…OK

                • Checking package: lftp…OK

                • Checking package: libapache2-mod-php7.1…OK

                • Checking package: libc6…OK

                • Checking package: libcurl3…OK

                • Checking package: m4…OK

                • Checking package: mysql-client…OK

                • Checking package: mysql-server…OK

                • Checking package: net-tools…OK

                • Checking package: nfs-kernel-server…OK

                • Checking package: openssh-server…OK

                • Checking package: php7.1…OK

                • Checking package: php7.1-bcmath…OK

                • Checking package: php7.1-cli…OK

                • Checking package: php7.1-curl…OK

                • Checking package: php7.1-fpm…OK

                • Checking package: php7.1-gd…OK

                • Checking package: php7.1-json…OK

                • Checking package: php7.1-ldap…OK

                • Checking package: php7.1-mbstring…OK

                • Checking package: php7.1-mcrypt…OK

                • Checking package: php7.1-mysql…OK

                • Checking package: php-gettext…OK

                • Checking package: sysv-rc-conf…OK

                • Checking package: tar…OK

                • Checking package: tftpd-hpa…OK

                • Checking package: tftp-hpa…OK

                • Checking package: unzip…OK

                • Checking package: vsftpd…OK

                • Checking package: wget…OK

                • Checking package: xinetd…OK

                • Checking package: zlib1g…OK

                • Configuring services

                • Setting up fog user…Already setup

                • Setting up fog password…OK

                • Stopping FOGMulticastManager.service Service…OK

                • Stopping FOGImageReplicator.service Service…OK

                • Stopping FOGSnapinReplicator.service Service…OK

                • Stopping FOGScheduler.service Service…OK

                • Stopping FOGPingHosts.service Service…OK

                • Stopping FOGSnapinHash.service Service…OK

                • Stopping FOGImageSize.service Service…OK

                • Setting up and starting MySQL…OK

                • Backing up user reports…Done

                • Stopping web service…OK

                • Setting up Apache and PHP files…OK

                • Testing and removing symbolic links if found…OK

                • Backing up old data…OK

                • Copying new files to web folder…OK

                • Creating config file…OK

                • Unzipping the binaries…Done

                • Copying binaries where needed…Done

                • Enabling apache and fpm services on boot…OK

                • Creating SSL Certificate…OK

                • Creating auth pub key and cert…OK

                • Resetting SSL Permissions…OK

                • Setting up SSL FOG Server…OK

                • Restarting Apache2 for fog vhost…OK

                • Changing permissions on apache log files…OK

                • Backing up database…OK

                • Updating Database…Failed!

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

                  @Cmid Why does ubuntu hate me so much?

                  Please open terminal and run:

                  sudo mysql -u root
                  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
                  ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '';
                  exit
                  

                  Then 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
                  • C
                    Cmid @Tom Elliott
                    last edited by

                    Before I rerun installer, I tried those lines. Those first one got me a Query OK, 0 rows affected

                    However the 2nd command got me ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@‘127.0.0.1’

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

                      @Cmid That’s okay.

                      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

                      C 1 Reply Last reply Reply Quote 0
                      • C
                        Cmid @Tom Elliott
                        last edited by

                        @Tom-Elliott

                        Tom 1 Ubuntu 0 - worked perfect - thanks so much!

                        Any idea what would of happened?

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

                          @Cmid Yep.

                          Ubuntu decided that only “root” users can login with a password defined. You can’t even open mysql via terminal without sudo if there is no password set.

                          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 1
                          • 1 / 1
                          • First post
                            Last post

                          199

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project