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

    Fog web interface times out loading almost any page

    Scheduled Pinned Locked Moved
    FOG Problems
    3
    22
    8.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.
    • Joseph HalesJ
      Joseph Hales Testers
      last edited by

      No its not virtualized and if I loose some client records its not the end of the world I may be seeing this issues as well if the mac address’s are deleted should I clean out the database of these records. If so can you give me the mysql command to do this

      RTFM

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

        @Joseph-Hales said:

        No its not virtualized and if I loose some client records its not the end of the world I may be seeing this issues as well if the mac address’s are deleted should I clean out the database of these records. If so can you give me the mysql command to do this

        I’m 100% sure we can give you a command to do that, but if you have a host export you can just re import the data.

        I have not tested this so be forewarned… backup your DB before hand.
        FOG Configuration -> Configuration Save -> Export

        DELETE FROM hosts WHERE hostID NOT IN (SELECT hmhostID FROM hostMAC);
        

        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
        • Joseph HalesJ
          Joseph Hales Testers
          last edited by

          I thought that command just saved the fog settings not the hosts and images?

          RTFM

          Wayne WorkmanW 1 Reply Last reply Reply Quote 0
          • Joseph HalesJ
            Joseph Hales Testers
            last edited by

            When I try to connect to mysql it errors out with error too many connections I will update svn, reboot and try again.

            RTFM

            1 Reply Last reply Reply Quote 0
            • Joseph HalesJ
              Joseph Hales Testers
              last edited by

              Still run into the error ERROR 1040 (HY000): Too many connections

              RTFM

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

                @Joseph-Hales said:

                Still run into the error ERROR 1040 (HY000): Too many connections

                I know what your issue is… you have tons of hosts… you need to increase your maximum connections!!! 😄

                There’s a section in this about just that 🙂 https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL

                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
                • Wayne WorkmanW
                  Wayne Workman @Joseph Hales
                  last edited by Wayne Workman

                  @Joseph-Hales said:

                  I thought that command just saved the fog settings not the hosts and images?

                  That feature exports the entire DB. Everything.

                  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
                  • Joseph HalesJ
                    Joseph Hales Testers
                    last edited by

                    Ok if someone could make a note in the wiki the my.cnf in ubuntu 14 seems to be located in /etc/mysql/ not the root of /etc/ that fixed my too many connections. It seems the update to 14 deleted my old my.cnf and reverted to the default 100 max connections. after clearing the bad records it seems I lost 1050 records. If I import an older backup made from the web page will it only add records that no longer exist or will it overwrite and delete the new records added since the backup?

                    RTFM

                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                    • Joseph HalesJ
                      Joseph Hales Testers
                      last edited by Joseph Hales

                      Ok pages seem better and server load is down but my Task Management page fails to load at all, every other menu option loads normally.

                      RTFM

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

                        @Joseph-Hales said:

                        If I import an older backup made from the web page will it only add records that no longer exist or will it overwrite and delete the new records added since the backup?

                        An import will blast your DB and place the import in place. You will loose all changes made since that backup was made.
                        Of course this doesn’t affect the ACTUAL images made since then, it just affects the image definitions in the DB. Those can be recreated manually via the Web UI. But you have to create them exactly as they were (image type, OS, Exact path and the path is case sensitive).

                        And I’ll make note in the WiKi about Ubuntu 14.

                        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
                        • Joseph HalesJ
                          Joseph Hales Testers
                          last edited by

                          So the main fog page shows active and pending tasks but going to task management loads a blank page and truncate jobs and snapins affects 0 rows any ideas this seems to be the only show stopper issue I still have.

                          RTFM

                          1 Reply Last reply Reply Quote 0
                          • Joseph HalesJ
                            Joseph Hales Testers
                            last edited by

                            Ok bit the bullet and restored a backup of the database seems to have fixed the issue I will keep an eye on how it behaves under load today.

                            RTFM

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

                            163

                            Online

                            12.0k

                            Users

                            17.3k

                            Topics

                            155.2k

                            Posts
                            Copyright © 2012-2024 FOG Project