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

    Database Schema / Installer

    Scheduled Pinned Locked Moved Solved
    Linux Problems
    2
    14
    2.8k
    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.
    • C
      Cmid
      last edited by

      Not on purpose… I would guess it is possible that some updates ran during a power outage.

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

                            153

                            Online

                            12.0k

                            Users

                            17.3k

                            Topics

                            155.2k

                            Posts
                            Copyright © 2012-2024 FOG Project