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

    Upgraded ubuntu from 13.04 to 14.04 now Web console will not come up

    Scheduled Pinned Locked Moved Unsolved
    FOG Problems
    6
    35
    14.2k
    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.
    • Wayne WorkmanW
      Wayne Workman @darkxeno
      last edited by Wayne Workman

      @darkxeno Ah… didn’t see that part. 😐

      See if your DB is running…

      Some things to try:

      service mysql restart
      tail -f /var/log/mysql/error.log
      mysql
      use fog
      exit
      ./installfog.sh -y
      

      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!
      Daily Clean Installation Results:
      https://fogtesting.fogproject.us/
      FOG Reporting:
      https://fog-external-reporting-results.fogproject.us/

      D 1 Reply Last reply Reply Quote 0
      • D
        darkxeno @ch3i
        last edited by

        @ch3i

        I uploaded the fail since when I copy and paste it tells me it’s spam

        1 Reply Last reply Reply Quote 0
        • D
          darkxeno
          last edited by

          [Wed Jul 08 08:30:04.533150 2015] [:error] [pid 22878] [client 10.0.10.146:51962] PHP Warning: mysqli::poll(): No stream arrays were passed in /var/www/fog/lib/db/MySQL.class.php on line 67, referer: http://10.0.0.22/fog/management/?node=schemaupdater

          This is whats in my apache error log this one line repeated a lot of times lol

          1 Reply Last reply Reply Quote 0
          • D
            darkxeno @Wayne Workman
            last edited by

            @Wayne-Workman db is running

            1 Reply Last reply Reply Quote 0
            • cmlC
              cml Moderator
              last edited by

              Is the document root in /etc/apache2/sites-available/001-fog still set to /var/www ?

              1 Reply Last reply Reply Quote 0
              • D
                darkxeno
                last edited by

                for some reason the fog site isnt there

                1 Reply Last reply Reply Quote 0
                • D
                  darkxeno
                  last edited by

                  i have also notice that when i do the ./installfog.sh -y it hangs on the updating database

                  Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                  • Wayne WorkmanW
                    Wayne Workman @darkxeno
                    last edited by

                    @darkxeno said:

                    i have also notice that when i do the ./installfog.sh -y it hangs on the updating database

                    Sure the database is running?

                    service mysql status
                    

                    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!
                    Daily Clean Installation Results:
                    https://fogtesting.fogproject.us/
                    FOG Reporting:
                    https://fog-external-reporting-results.fogproject.us/

                    D 1 Reply Last reply Reply Quote 0
                    • D
                      darkxeno @Wayne Workman
                      last edited by

                      @Wayne-Workman
                      yup it says running

                      1 Reply Last reply Reply Quote 0
                      • D
                        darkxeno
                        last edited by

                        ok so I went back to 2659 and I’m able to get back into the web console now when i try to up grade to 3713 i’m not able to update the schema

                        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                        • Wayne WorkmanW
                          Wayne Workman @darkxeno
                          last edited by

                          @darkxeno Can you try something in the middle?

                          instead of typing “svn up”, you’d use this to get a specific revision:

                          svn co -r 3186 https://svn.code.sf.net/p/freeghost/code/trunk
                          

                          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!
                          Daily Clean Installation Results:
                          https://fogtesting.fogproject.us/
                          FOG Reporting:
                          https://fog-external-reporting-results.fogproject.us/

                          D 1 Reply Last reply Reply Quote 0
                          • D
                            darkxeno @Wayne Workman
                            last edited by

                            @Wayne-Workman

                            so 3347 worked

                            Wayne WorkmanW 1 Reply Last reply Reply Quote 1
                            • Wayne WorkmanW
                              Wayne Workman @darkxeno
                              last edited by

                              @darkxeno if you can determine - closely or exactly - where it breaks, that’d help the devs a lot.

                              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!
                              Daily Clean Installation Results:
                              https://fogtesting.fogproject.us/
                              FOG Reporting:
                              https://fog-external-reporting-results.fogproject.us/

                              1 Reply Last reply Reply Quote 0
                              • D
                                darkxeno
                                last edited by darkxeno

                                so i went from 3347 to 3726 and with no issues it looks like I had to upgrade in steps for some reason it was the sql database would not update.

                                Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                • Wayne WorkmanW
                                  Wayne Workman @darkxeno
                                  last edited by

                                  @darkxeno that’s an issue… it means that the latest schema updater code can’t update something in earlier revisions to the current revision…

                                  Look at your MySQL logs and Apache logs to try and see what it is… What time did the schema updater fail? Your original post was 3 hours ago.

                                  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!
                                  Daily Clean Installation Results:
                                  https://fogtesting.fogproject.us/
                                  FOG Reporting:
                                  https://fog-external-reporting-results.fogproject.us/

                                  D 1 Reply Last reply Reply Quote 0
                                  • D
                                    darkxeno @Wayne Workman
                                    last edited by

                                    @darkxeno said:

                                    Wed Jul 08 08:30:04.533150 2015] [:error] [pid 22878] [client 10.0.10.146:51962] PHP Warning: mysqli::poll(): No stream arrays were passed in /var/www/fog/lib/db/MySQL.class.php on line 67, referer: http://10.0.0.22/fog/management/?node=schemaupdater

                                    this is whats in the apache logs repeated a bunch of times

                                    150708 8:29:15 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
                                    150708 8:29:15 [Note] Plugin ‘FEDERATED’ is disabled.
                                    150708 8:29:15 InnoDB: The InnoDB memory heap is disabled
                                    150708 8:29:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
                                    150708 8:29:15 InnoDB: Compressed tables use zlib 1.2.8
                                    150708 8:29:15 InnoDB: Using Linux native AIO
                                    150708 8:29:15 InnoDB: Initializing buffer pool, size = 128.0M
                                    150708 8:29:15 InnoDB: Completed initialization of buffer pool
                                    150708 8:29:15 InnoDB: highest supported file format is Barracuda.
                                    150708 8:29:15 InnoDB: Waiting for the background threads to start
                                    150708 8:29:16 InnoDB: 5.5.43 started; log sequence number 2579942
                                    150708 8:29:16 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
                                    150708 8:29:16 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
                                    150708 8:29:16 [Note] Server socket created on IP: ‘127.0.0.1’.
                                    150708 8:29:16 [Warning] Found invalid password for user: ‘timesheet@localhost’; Ignoring user
                                    150708 8:29:16 [Warning] Found invalid password for user: ‘sa@localhost’; Ignoring user
                                    150708 8:29:16 [Warning] Found invalid password for user: ‘timesheet1@localhost’; Ignoring user
                                    150708 8:29:16 [Note] Event Scheduler: Loaded 0 events
                                    150708 8:29:16 [Note] /usr/sbin/mysqld: ready for connections.
                                    Version: ‘5.5.43-0ubuntu0.14.04.1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Ubuntu)
                                    150708 8:37:22 [Note] /usr/sbin/mysqld: Normal shutdown

                                    150708 8:37:22 [Note] Event Scheduler: Purging the queue. 0 events
                                    150708 8:37:24 [Warning] /usr/sbin/mysqld: Forcing close of thread 1554 user: ‘root’

                                    150708 8:37:24 [Warning] /usr/sbin/mysqld: Forcing close of thread 1465 user: ‘root’

                                    150708 8:37:24 InnoDB: Starting shutdown…
                                    150708 8:37:25 InnoDB: Shutdown completed; log sequence number 2593161
                                    150708 8:37:25 [Note] /usr/sbin/mysqld: Shutdown complete

                                    150708 8:37:25 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
                                    150708 8:37:25 [Note] Plugin ‘FEDERATED’ is disabled.
                                    150708 8:37:25 InnoDB: The InnoDB memory heap is disabled
                                    150708 8:37:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
                                    150708 8:37:25 InnoDB: Compressed tables use zlib 1.2.8
                                    150708 8:37:25 InnoDB: Using Linux native AIO
                                    150708 8:37:25 InnoDB: Initializing buffer pool, size = 128.0M
                                    150708 8:37:25 InnoDB: Completed initialization of buffer pool
                                    150708 8:37:25 InnoDB: highest supported file format is Barracuda.
                                    150708 8:37:25 InnoDB: Waiting for the background threads to start
                                    150708 8:37:26 InnoDB: 5.5.43 started; log sequence number 2593161
                                    150708 8:37:26 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
                                    150708 8:37:26 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
                                    150708 8:37:26 [Note] Server socket created on IP: ‘127.0.0.1’.
                                    150708 8:37:26 [Warning] Found invalid password for user: ‘timesheet@localhost’; Ignoring user
                                    150708 8:37:26 [Warning] Found invalid password for user: ‘sa@localhost’; Ignoring user
                                    150708 8:37:26 [Warning] Found invalid password for user: ‘timesheet1@localhost’; Ignoring user
                                    150708 8:37:26 [Note] Event Scheduler: Loaded 0 events
                                    150708 8:37:26 [Note] /usr/sbin/mysqld: ready for connections.
                                    Version: ‘5.5.43-0ubuntu0.14.04.1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Ubuntu)
                                    150708 8:48:45 [Note] /usr/sbin/mysqld: Normal shutdown

                                    150708 8:48:45 [Note] Event Scheduler: Purging the queue. 0 events
                                    150708 8:48:45 InnoDB: Starting shutdown…
                                    150708 8:48:46 InnoDB: Shutdown completed; log sequence number 2593161
                                    150708 8:48:46 [Note] /usr/sbin/mysqld: Shutdown complete

                                    this is my mysql logs

                                    1 Reply Last reply Reply Quote 0
                                    • S
                                      syschuck
                                      last edited by Wayne Workman

                                      Just to let the @Developers know. It’s not an ubuntu thing. I’m having the exact same issue with Mageia 5.
                                      (Mysql 10.0.19-MariaDB).

                                      [Wed Jul 08 11:57:29.718411 2015] [:error] [pid 18958] [client 192.168.1.1:41436] PHP Warning: mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 37
                                      [Wed Jul 08 11:58:18.468757 2015] [:error] [pid 22579] [client 192.168.1.1:41901] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 59

                                      I’m going to check that my mysql password is cleared and try again. I also noticed that it didn’t create the ‘fog’ data base.

                                      1 Reply Last reply Reply Quote 0
                                      • S
                                        syschuck
                                        last edited by

                                        I removed the fog database to start form scratch and I can confirm my earlier report. The fog database is not created. My apache log files show the following;

                                        [Wed Jul 08 12:28:57.084063 2015] [mpm_prefork:notice] [pid 5036] AH00170: caught SIGWINCH, shutting down gracefully
                                        [Wed Jul 08 12:28:58.587272 2015] [auth_digest:notice] [pid 8184] AH01757: generating secret for digest authentication …
                                        [Wed Jul 08 12:28:59.147391 2015] [mpm_prefork:notice] [pid 8184] AH00163: Apache/2.4.10 (Unix) OpenSSL/1.0.2c PHP/5.6.10 mod_perl/2.0.8-dev Perl/v5.20.1 configured – resuming normal operations
                                        [Wed Jul 08 12:28:59.147496 2015] [core:notice] [pid 8184] AH00094: Command line: ‘/usr/sbin/httpd -D FOREGROUND’
                                        [Wed Jul 08 12:29:12.183867 2015] [:error] [pid 8190] [client 192.168.1.1:59748] PHP Warning: mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 37
                                        [Wed Jul 08 12:29:12.184019 2015] [:error] [pid 8190] [client 192.168.1.1:59748] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 59
                                        [Wed Jul 08 12:29:12.196499 2015] [:error] [pid 8190] [client 192.168.1.1:59748] PHP Warning: mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 37
                                        [Wed Jul 08 12:29:12.196879 2015] [:error] [pid 8190] [client 192.168.1.1:59748] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 59
                                        [Wed Jul 08 12:29:12.197176 2015] [:error] [pid 8190] [client 192.168.1.1:59748] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 59

                                        Last line repeated 20+ times.

                                        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                        • Wayne WorkmanW
                                          Wayne Workman @syschuck
                                          last edited by

                                          @syschuck Sounds like either MySQL isn’t running, or a password is set.

                                          But, I assume these aren’t the case… 😕

                                          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!
                                          Daily Clean Installation Results:
                                          https://fogtesting.fogproject.us/
                                          FOG Reporting:
                                          https://fog-external-reporting-results.fogproject.us/

                                          S 1 Reply Last reply Reply Quote 0
                                          • S
                                            syschuck @Wayne Workman
                                            last edited by

                                            I triple checked mysql and root does not have a password and the whole sql is wide open to use.

                                            [root@fog bin]# mysqladmin status
                                            Uptime: 662 Threads: 1 Questions: 2 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 63 Queries per second avg: 0.003

                                            mysqladmin version
                                            mysqladmin Ver 9.1 Distrib 10.0.19-MariaDB, for Linux on x86_64
                                            Copyright © 2000, 2015, Oracle, MariaDB Corporation Ab and others.

                                            Server version 10.0.19-MariaDB
                                            Protocol version 10
                                            Connection Localhost via UNIX socket
                                            UNIX socket /var/lib/mysql/mysql.sock
                                            Uptime: 12 min 24 sec

                                            This is a side note, I discovered while looking at the mysql issue.
                                            Wow. Just did a ‘ps -ef | grep fog’ and found I had like 20+ instances of

                                            root 7469 1 0 Jul07 ? 00:01:22 /usr/bin/php -q /opt/fog/service/FOGMulticastManager/FOGMulticastManager
                                            root 7532 1 0 Jul07 ? 00:00:01 /usr/bin/php -q /opt/fog/service/FOGImageReplicator/FOGImageReplicator
                                            root 7596 1 0 Jul07 ? 00:00:01 /usr/bin/php -q /opt/fog/service/FOGTaskScheduler/FOGTaskScheduler
                                            root 7662 1 0 Jul07 ? 00:00:01 /usr/bin/php -q /opt/fog/service/FOGSnapinReplicator/FOGSnapinReplicator

                                            from all of my install attempts. That must be something minor. Installer shows;

                                            • Stopping FOGMulticastManager Service…/lib/common/functions.sh: line 444: 30965 Terminated $initdpath/$serviceItem stop > /dev/null 2>&1
                                              OK
                                              for each of the services.
                                              For the Mageia5 variation on Redhat, this latest release removed the old systemV init compatibility and is now completely using systemd. So a changes needs to be made to bin/installfog.sh. It’s located down at the line; with
                                              OSVersion=echo $OSVersion | cut -d '.' -f1
                                            if [[ "$OSVersion" -ge 3 && "$linuxReleaseName" == +(*[Mm]'ageia'*) ]]; then
                                                systemctl="yes";
                                            fi
                                            
                                            

                                            So once systemctl is set, then it revealed another systemd issue in lib/common/functions.sh in that Mageia5 doesn’t use mariadb.service or mysql.service. It uses mysqld.service! So I made this change to the configureMySql() function.

                                                if [ "$systemctl" == "yes" ]; then
                                                    if [[ "$linuxReleaseName" == +(*[Mm]'ageia'*) ]]; then
                                                            systemctl="yes";
                                                            systemctl enable mysqld.service >/dev/null 2>&1 && \
                                                            systemctl restart mysqld.service >/dev/null 2>&1 && \
                                                            systemctl status mysqld.service >/dev/null 2>&1
                                                    else
                                                            systemctl="yes";
                                                            systemctl enable mariadb.service >/dev/null 2>&1 && \
                                                            systemctl restart mariadb.service >/dev/null 2>&1 && \
                                                            systemctl status mariadb.service >/dev/null 2>&1
                                                            if [ "$?" != "0" ]; then
                                                                    systemctl enable mysql.service >/dev/null 2>&1 && \
                                                                    systemctl restart mysql.service >/dev/null 2>&1 && \
                                                                    systemctl status mysql.service >/dev/null 2>&1
                                                            fi
                                                    fi
                                            
                                            

                                            Well that has everything working with Mageia5 now. I’ll post the patches later. They are all minor things like above. However, none of that was the problem. It still redirects to http://192.168.1.1/fog/management/index.php?node=schemaupdater

                                            with a blank white page.


                                            Tom ElliottT Wayne WorkmanW 2 Replies Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            181

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project