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

    Fog installation and cofiguration on ubuntu 18.04 / 19.04 No DHCP Option

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    49
    6.4k
    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
      chasosnature @Sebastian Roth
      last edited by

      @Sebastian-Roth

      here are the screenshots requested

      From forum:

      fog error forum.png

      My Error
      fog error 1.png

      1 Reply Last reply Reply Quote 0
      • C
        chasosnature @Sebastian Roth
        last edited by chasosnature

        @Sebastian-Roth

        as we speak i am following Quazz advice and installing 1.5.7 (i imagined it makes more sense as most of these issues have probably been addressed in the later versions)

        i use the -X switch bcos of the experience i have had with FOG installation failing (even on fresh ubuntu 18.04 build) on some packages.
        i usuallly will go back and re-install the failed packages and it works for me like that.

        i currently have this failure:
        Installing package: mariadb-client…Failed! (Will try later)

        i am giving you live updates 🙂

        many thanks for your quick response by the way…keep up the good work…

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

          @chasosnature what type of task was selected when you got the Type :: Null error? This typically means you created a debug task which makes it when you run the command fog, the error will be present. This is because there is no task type associated with the debug specific task.

          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
            chasosnature @Tom Elliott
            last edited by

            @Tom-Elliott said in Fog installation and cofiguration on ubuntu 18.04:

            debug task

            There is a syntax your advices another user to enter in the fog settings, i cant remeber what it is now…i enetered that syntax only after it failed with the screenshots i provided.

            what do you mean by creating a task?

            i thought you just install the Fog , pxe the machine, you get the screen, do a quick registration and then image the client.

            what am i missing?

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

              @chasosnature if this is a fresh install, where is the image to deploy to the machine in the first place?

              FOG isn’t a magic thing. It’s a management system that enables easy capability to manage your machines and software layout to those machines. We don’t have base images for your machines, you have to create them before you can image them.

              You may want to look at the wiki about how to use fog, how to create your first image, and how things work.

              As such, when reading things on the forums, remember your mileage may very. Just because one person has one issue, doesn’t mean all people will have the same issue.

              We do have some bugs that affect multiple people but we are typically really responsive with asking questions and fixing said issues.

              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 3 Replies Last reply Reply Quote 0
              • C
                chasosnature
                last edited by

                an update :

                i have upgraded to 1.5.7
                no errors

                at the point of:

                • You still need to install/update your database schema.

                • This can be done by opening a web browser and going to:

                  http://xxx.xxx.x.xx/fog/management

                but i get this :
                Database connection unavailable

                below is the logs

                [Mon Nov 25 13:59:31.780117 2019] [mpm_event:notice] [pid 30227:tid 140698385435584] AH00489: Apache$
                [Mon Nov 25 13:59:31.780598 2019] [core:notice] [pid 30227:tid 140698385435584] AH00094: Command lin$
                [Mon Nov 25 14:01:55.418809 2019] [mpm_event:notice] [pid 30227:tid 140698385435584] AH00491: caught$
                [Mon Nov 25 14:01:55.633379 2019] [mpm_prefork:notice] [pid 4453] AH00163: Apache/2.4.29 (Ubuntu) co$
                [Mon Nov 25 14:01:55.633804 2019] [core:notice] [pid 4453] AH00094: Command line: ‘/usr/sbin/apache2’
                [Mon Nov 25 14:01:57.308300 2019] [mpm_prefork:notice] [pid 4453] AH00169: caught SIGTERM, shutting $
                [Mon Nov 25 14:01:57.666769 2019] [mpm_prefork:notice] [pid 4514] AH00163: Apache/2.4.29 (Ubuntu) co$
                [Mon Nov 25 14:01:57.666991 2019] [core:notice] [pid 4514] AH00094: Command line: ‘/usr/sbin/apache2’
                [Mon Nov 25 14:12:39.359974 2019] [mpm_prefork:notice] [pid 4514] AH00169: caught SIGTERM, shutting $
                [Mon Nov 25 14:13:10.307323 2019] [mpm_prefork:notice] [pid 13236] AH00163: Apache/2.4.29 (Ubuntu) O$
                [Mon Nov 25 14:13:10.307546 2019] [core:notice] [pid 13236] AH00094: Command line: '/usr/sbin/apache$

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by

                  @chasosnature https://forums.fogproject.org/topic/13447/lost-database

                  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
                    chasosnature @Sebastian Roth
                    last edited by

                    @Sebastian-Roth

                    i have followed the post advice and ran the below commands (i dont see a resolution in that post - so maybe you can give me a hint on what to do next as this is an upgraded from 1.4.4 to 1.5.7 )

                    i can see the lagacy stuff are there in the mysql but nothing in the mariam .

                    " Please run ls -alR /images and du -sh /images to see if there is still something there.

                    Beside that please also run ls -alR /var/lib/mysql and ls -alR /var/lib/mariadb."

                    see below for results:

                    fog error 4.png

                    fog error 5.png

                    this is where the installation got to (so waiting to solve this before pressing enter)

                    fog error 6.png

                    any ideas?

                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator
                      last edited by

                      @chasosnature said in Fog installation and cofiguration on ubuntu 18.04:

                      ls -alR /var/lib/mysql

                      Run ls -alR /var/lib/mysql* (the asterisk at the end is important!!)

                      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
                        chasosnature @Tom Elliott
                        last edited by

                        @Tom-Elliott

                        lol to the magic business.

                        i agree and can attest to your switftness in responding , i already witness it …so thanks

                        i am trying out different scenerios to help the development of this project…i could have just installed centos and use fog
                        i could also simply do a fresh install and use git. but i have decided to take this route and determined to have it functioning , not just becos i am naturally storborn but also to help others who have the setup i am playing with.

                        i descided to upgraded 1.4.4 to 1.5.7 instead of fresh install…why?..in a production environment we might not have that luxury of trashing and re-installing, an upgrade from one version to another without loss of data would be ideal.

                        anyways ; now i am trying to figure out how to get past this : Database connection unavailable

                        i wont bother you on how to use fog anymore as i know you guys must be very busy…but i thought fog images the system as soon as the system can pxe into the fog server…well that would be magic to this standard lol.

                        back to clonezilla…

                        1 Reply Last reply Reply Quote 0
                        • C
                          chasosnature @Sebastian Roth
                          last edited by

                          @Sebastian-Roth

                          thanks…

                          i did…and i get:

                          root@FogServerKubuntu:/home/chaosnature# ls -alR /var/lib/mariadb
                          ls: cannot access ‘/var/lib/mariadb’: No such file or directory
                          root@FogServerKubuntu:/home/chaosnature#

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

                            @Tom-Elliott

                            i have watched multiple youtube videos , all i see these guys doing is install the fog server pxe a live system and fog picks up.

                            i had no idea they had done some imaging of the system prior to this…not so good tutorials then; on the youtube.
                            i will write a better one when i get this working for both experts and newbies.

                            As for the bugs…dont beat yourself about it (this is open source), my advice is make it clear in your documentations : OS versions and compatibilities.
                            i spent four days waring and fighting with fog 1.4.4 , trying to get it to work with ubuntu 18.04 (1 day on 19.04) only to realize later that 1.4.4 is only compatible with ubuntu 16.04 and older versions.

                            from today i am dealing with 1.5.7 fog version.
                            i will only get back to the 1.4.4 version on 18.04 if i am requested to do a tutorial on getting it to with with it, which i have been succeful on doing based on what you are telling me that the system requres an image.

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

                              @Tom-Elliott

                              this is what i just found on Gits network:

                              FOGProject starting point
                              Introduction
                              FOG is a free open-source cloning/imaging solution/rescue suite. FOG can be used to image Windows XP, Vista, Windows 7, Window 8, and Windows 10 PCs using PXE, PartClone, and a Web GUI to tie it together. Includes features like memory and disk test, disk wipe, av scan, task scheduling, inventory management, and remote installation of software packages. Features can be triggered remotely from the web GUI, once the machine has been registered.

                              to me that says Fog can image my system…

                              1 Reply Last reply Reply Quote 0
                              • C
                                chasosnature @Sebastian Roth
                                last edited by

                                @Sebastian-Roth

                                Please ignore previous result…ran it again and i got this:

                                root@FogServerKubuntu:/home/chaosnature# ls -alR /var/lib/mysql*
                                /var/lib/mysql:
                                total 110628
                                
                                /var/lib/mysql-5.7/mysql:
                                total 11932
                                drwxr-x--- 2 mysql mysql    4096 Nov 23 12:08 .
                                drwx------ 6 mysql mysql    4096 Nov 25 12:45 ..
                                -rw-r----- 1 mysql mysql    8820 Nov 23 12:07 columns_priv.frm
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 columns_priv.MYD
                                -rw-r----- 1 mysql mysql    4096 Nov 23 12:07 columns_priv.MYI
                                -rw-r----- 1 mysql mysql    9582 Nov 23 12:07 db.frm
                                -rw-r----- 1 mysql mysql    1464 Nov 23 14:29 db.MYD
                                -rw-r----- 1 mysql mysql    5120 Nov 23 19:24 db.MYI
                                -rw-r----- 1 mysql mysql      65 Nov 23 12:07 db.opt
                                -rw-r----- 1 mysql mysql    8780 Nov 23 12:07 engine_cost.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 engine_cost.ibd
                                -rw-r----- 1 mysql mysql   10223 Nov 23 12:07 event.frm
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 event.MYD
                                -rw-r----- 1 mysql mysql    2048 Nov 23 12:07 event.MYI
                                -rw-r----- 1 mysql mysql    8665 Nov 23 12:07 func.frm
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 func.MYD
                                -rw-r----- 1 mysql mysql    1024 Nov 23 12:07 func.MYI
                                -rw-r----- 1 mysql mysql      35 Nov 23 12:07 general_log.CSM
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 general_log.CSV
                                -rw-r----- 1 mysql mysql    8776 Nov 23 12:07 general_log.frm
                                -rw-r----- 1 mysql mysql    8784 Nov 23 12:07 gtid_executed.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 gtid_executed.ibd
                                -rw-r----- 1 mysql mysql    8700 Nov 23 12:07 help_category.frm
                                -rw-r----- 1 mysql mysql  114688 Nov 23 12:08 help_category.ibd
                                -rw-r----- 1 mysql mysql    8612 Nov 23 12:07 help_keyword.frm
                                -rw-r----- 1 mysql mysql  245760 Nov 23 12:08 help_keyword.ibd
                                -rw-r----- 1 mysql mysql    8630 Nov 23 12:07 help_relation.frm
                                -rw-r----- 1 mysql mysql  147456 Nov 23 12:08 help_relation.ibd
                                -rw-r----- 1 mysql mysql    8770 Nov 23 12:07 help_topic.frm
                                -rw-r----- 1 mysql mysql 9437184 Nov 23 12:08 help_topic.ibd
                                -rw-r----- 1 mysql mysql   12982 Nov 23 12:07 innodb_index_stats.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:08 innodb_index_stats.ibd
                                -rw-r----- 1 mysql mysql    8830 Nov 23 12:07 innodb_table_stats.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:08 innodb_table_stats.ibd
                                -rw-r----- 1 mysql mysql    8986 Nov 23 12:07 ndb_binlog_index.frm
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 ndb_binlog_index.MYD
                                -rw-r----- 1 mysql mysql    1024 Nov 23 12:07 ndb_binlog_index.MYI
                                -rw-r----- 1 mysql mysql    8586 Nov 23 12:07 plugin.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:08 plugin.ibd
                                -rw-r----- 1 mysql mysql    9996 Nov 23 12:07 proc.frm
                                -rw-r----- 1 mysql mysql  301304 Nov 23 12:08 proc.MYD
                                -rw-r----- 1 mysql mysql    4096 Nov 23 12:08 proc.MYI
                                -rw-r----- 1 mysql mysql    8875 Nov 23 12:07 procs_priv.frm
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 procs_priv.MYD
                                -rw-r----- 1 mysql mysql    4096 Nov 23 12:07 procs_priv.MYI
                                -rw-r----- 1 mysql mysql    8800 Nov 23 12:08 proxies_priv.frm
                                -rw-r----- 1 mysql mysql     837 Nov 23 12:08 proxies_priv.MYD
                                -rw-r----- 1 mysql mysql    9216 Nov 23 12:08 proxies_priv.MYI
                                -rw-r----- 1 mysql mysql    8692 Nov 23 12:07 server_cost.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 server_cost.ibd
                                -rw-r----- 1 mysql mysql    8838 Nov 23 12:07 servers.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 servers.ibd
                                -rw-r----- 1 mysql mysql   10908 Nov 23 12:07 slave_master_info.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 slave_master_info.ibd
                                -rw-r----- 1 mysql mysql    9468 Nov 23 12:07 slave_relay_log_info.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 slave_relay_log_info.ibd
                                -rw-r----- 1 mysql mysql    9364 Nov 23 12:07 slave_worker_info.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 slave_worker_info.ibd
                                -rw-r----- 1 mysql mysql      35 Nov 23 12:07 slow_log.CSM
                                -rw-r----- 1 mysql mysql       0 Nov 23 12:07 slow_log.CSV
                                -rw-r----- 1 mysql mysql    9016 Nov 23 12:07 slow_log.frm
                                -rw-r----- 1 mysql mysql    8955 Nov 23 12:07 tables_priv.frm
                                -rw-r----- 1 mysql mysql    1894 Nov 23 12:08 tables_priv.MYD
                                -rw-r----- 1 mysql mysql    9216 Nov 23 12:08 tables_priv.MYI
                                -rw-r----- 1 mysql mysql    8636 Nov 23 12:07 time_zone.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 time_zone.ibd
                                -rw-r----- 1 mysql mysql    8624 Nov 23 12:07 time_zone_leap_second.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 time_zone_leap_second.ibd
                                -rw-r----- 1 mysql mysql    8606 Nov 23 12:07 time_zone_name.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 time_zone_name.ibd
                                -rw-r----- 1 mysql mysql    8686 Nov 23 12:07 time_zone_transition.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 time_zone_transition.ibd
                                -rw-r----- 1 mysql mysql    8748 Nov 23 12:07 time_zone_transition_type.frm
                                -rw-r----- 1 mysql mysql   98304 Nov 23 12:07 time_zone_transition_type.ibd
                                -rw-r----- 1 mysql mysql   10816 Nov 23 12:07 user.frm
                                -rw-r----- 1 mysql mysql     596 Nov 23 21:24 user.MYD
                                -rw-r----- 1 mysql mysql    4096 Nov 25 12:45 user.MYI
                                
                                /var/lib/mysql-5.7/performance_schema:
                                total 1068
                                drwxr-x--- 2 mysql mysql  4096 Nov 23 12:08 .
                                drwx------ 6 mysql mysql  4096 Nov 25 12:45 ..
                                -rw-r----- 1 mysql mysql  8706 Nov 23 12:08 accounts.frm
                                -rw-r----- 1 mysql mysql  8624 Nov 23 12:07 cond_instances.frm
                                -rw-r----- 1 mysql mysql    61 Nov 23 12:07 db.opt
                                -rw-r----- 1 mysql mysql  9103 Nov 23 12:07 events_stages_current.frm
                                -rw-r----- 1 mysql mysql  9103 Nov 23 12:07 events_stages_history.frm
                                -rw-r----- 1 mysql mysql  9103 Nov 23 12:07 events_stages_history_long.frm
                                -rw-r----- 1 mysql mysql  8874 Nov 23 12:07 events_stages_summary_by_account_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8844 Nov 23 12:07 events_stages_summary_by_host_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8854 Nov 23 12:07 events_stages_summary_by_thread_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8844 Nov 23 12:07 events_stages_summary_by_user_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8814 Nov 23 12:07 events_stages_summary_global_by_event_name.frm
                                -rw-r----- 1 mysql mysql 10597 Nov 23 12:07 events_statements_current.frm
                                -rw-r----- 1 mysql mysql 10597 Nov 23 12:07 events_statements_history.frm
                                -rw-r----- 1 mysql mysql 10597 Nov 23 12:07 events_statements_history_long.frm
                                -rw-r----- 1 mysql mysql 10000 Nov 23 12:07 events_statements_summary_by_account_by_event_name.frm
                                -rw-r----- 1 mysql mysql 10102 Nov 23 12:08 events_statements_summary_by_digest.frm
                                -rw-r----- 1 mysql mysql  9970 Nov 23 12:07 events_statements_summary_by_host_by_event_name.frm
                                -rw-r----- 1 mysql mysql 10369 Nov 23 12:08 events_statements_summary_by_program.frm
                                -rw-r----- 1 mysql mysql  9980 Nov 23 12:07 events_statements_summary_by_thread_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9970 Nov 23 12:07 events_statements_summary_by_user_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9940 Nov 23 12:07 events_statements_summary_global_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9800 Nov 23 12:07 events_transactions_current.frm
                                -rw-r----- 1 mysql mysql  9800 Nov 23 12:07 events_transactions_history.frm
                                -rw-r----- 1 mysql mysql  9800 Nov 23 12:07 events_transactions_history_long.frm
                                -rw-r----- 1 mysql mysql  9468 Nov 23 12:07 events_transactions_summary_by_account_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9438 Nov 23 12:07 events_transactions_summary_by_host_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9448 Nov 23 12:07 events_transactions_summary_by_thread_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9438 Nov 23 12:07 events_transactions_summary_by_user_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9408 Nov 23 12:08 events_transactions_summary_global_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9401 Nov 23 12:07 events_waits_current.frm
                                -rw-r----- 1 mysql mysql  9401 Nov 23 12:07 events_waits_history.frm
                                -rw-r----- 1 mysql mysql  9401 Nov 23 12:07 events_waits_history_long.frm
                                -rw-r----- 1 mysql mysql  8874 Nov 23 12:07 events_waits_summary_by_account_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8844 Nov 23 12:07 events_waits_summary_by_host_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8878 Nov 23 12:07 events_waits_summary_by_instance.frm
                                -rw-r----- 1 mysql mysql  8854 Nov 23 12:07 events_waits_summary_by_thread_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8844 Nov 23 12:07 events_waits_summary_by_user_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8814 Nov 23 12:07 events_waits_summary_global_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8654 Nov 23 12:07 file_instances.frm
                                -rw-r----- 1 mysql mysql  9740 Nov 23 12:07 file_summary_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9844 Nov 23 12:07 file_summary_by_instance.frm
                                -rw-r----- 1 mysql mysql  8628 Nov 23 12:08 global_status.frm
                                -rw-r----- 1 mysql mysql  8628 Nov 23 12:08 global_variables.frm
                                -rw-r----- 1 mysql mysql 10483 Nov 23 12:07 host_cache.frm
                                -rw-r----- 1 mysql mysql  8676 Nov 23 12:08 hosts.frm
                                -rw-r----- 1 mysql mysql  9240 Nov 23 12:08 memory_summary_by_account_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9210 Nov 23 12:08 memory_summary_by_host_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9220 Nov 23 12:08 memory_summary_by_thread_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9210 Nov 23 12:08 memory_summary_by_user_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9180 Nov 23 12:08 memory_summary_global_by_event_name.frm
                                -rw-r----- 1 mysql mysql  8998 Nov 23 12:08 metadata_locks.frm
                                -rw-r----- 1 mysql mysql  8684 Nov 23 12:07 mutex_instances.frm
                                -rw-r----- 1 mysql mysql  8908 Nov 23 12:07 objects_summary_global_by_type.frm
                                -rw-r----- 1 mysql mysql  8776 Nov 23 12:07 performance_timers.frm
                                -rw-r----- 1 mysql mysql 10541 Nov 23 12:08 prepared_statements_instances.frm
                                -rw-r----- 1 mysql mysql  8624 Nov 23 12:08 replication_applier_configuration.frm
                                -rw-r----- 1 mysql mysql  8849 Nov 23 12:08 replication_applier_status_by_coordinator.frm
                                -rw-r----- 1 mysql mysql  8953 Nov 23 12:08 replication_applier_status_by_worker.frm
                                -rw-r----- 1 mysql mysql  8759 Nov 23 12:08 replication_applier_status.frm
                                -rw-r----- 1 mysql mysql 17724 Nov 23 12:08 replication_connection_configuration.frm
                                -rw-r----- 1 mysql mysql  9215 Nov 23 12:08 replication_connection_status.frm
                                -rw-r----- 1 mysql mysql  8750 Nov 23 12:08 replication_group_members.frm
                                -rw-r----- 1 mysql mysql  9134 Nov 23 12:08 replication_group_member_stats.frm
                                -rw-r----- 1 mysql mysql  8758 Nov 23 12:07 rwlock_instances.frm
                                -rw-r----- 1 mysql mysql  8716 Nov 23 12:08 session_account_connect_attrs.frm
                                -rw-r----- 1 mysql mysql  8716 Nov 23 12:08 session_connect_attrs.frm
                                -rw-r----- 1 mysql mysql  8628 Nov 23 12:08 session_status.frm
                                -rw-r----- 1 mysql mysql  8628 Nov 23 12:08 session_variables.frm
                                -rw-r----- 1 mysql mysql  8701 Nov 23 12:07 setup_actors.frm
                                -rw-r----- 1 mysql mysql  8605 Nov 23 12:07 setup_consumers.frm
                                -rw-r----- 1 mysql mysql  8637 Nov 23 12:07 setup_instruments.frm
                                -rw-r----- 1 mysql mysql  8784 Nov 23 12:07 setup_objects.frm
                                -rw-r----- 1 mysql mysql  8650 Nov 23 12:07 setup_timers.frm
                                -rw-r----- 1 mysql mysql  8818 Nov 23 12:07 socket_instances.frm
                                -rw-r----- 1 mysql mysql  9740 Nov 23 12:07 socket_summary_by_event_name.frm
                                -rw-r----- 1 mysql mysql  9804 Nov 23 12:07 socket_summary_by_instance.frm
                                -rw-r----- 1 mysql mysql  8688 Nov 23 12:08 status_by_account.frm
                                -rw-r----- 1 mysql mysql  8658 Nov 23 12:08 status_by_host.frm
                                -rw-r----- 1 mysql mysql  8668 Nov 23 12:08 status_by_thread.frm
                                -rw-r----- 1 mysql mysql  8658 Nov 23 12:08 status_by_user.frm
                                -rw-r----- 1 mysql mysql  8928 Nov 23 12:08 table_handles.frm
                                -rw-r----- 1 mysql mysql 10578 Nov 23 12:07 table_io_waits_summary_by_index_usage.frm
                                -rw-r----- 1 mysql mysql 10488 Nov 23 12:07 table_io_waits_summary_by_table.frm
                                -rw-r----- 1 mysql mysql 13186 Nov 23 12:07 table_lock_waits_summary_by_table.frm
                                -rw-r----- 1 mysql mysql  9335 Nov 23 12:07 threads.frm
                                -rw-r----- 1 mysql mysql  8676 Nov 23 12:08 users.frm
                                -rw-r----- 1 mysql mysql  8668 Nov 23 12:08 user_variables_by_thread.frm
                                -rw-r----- 1 mysql mysql  8668 Nov 23 12:08 variables_by_thread.frm
                                
                                /var/lib/mysql-5.7/sys:
                                total 684
                                drwxr-x--- 2 mysql mysql 12288 Nov 23 12:08 .
                                drwx------ 6 mysql mysql  4096 Nov 25 12:45 ..
                                -rw-r----- 1 mysql mysql    61 Nov 23 12:08 db.opt
                                -rw-r----- 1 mysql mysql  2343 Nov 23 12:08 host_summary_by_file_io.frm
                                -rw-r----- 1 mysql mysql  2976 Nov 23 12:08 host_summary_by_file_io_type.frm
                                -rw-r----- 1 mysql mysql  2758 Nov 23 12:08 host_summary_by_stages.frm
                                -rw-r----- 1 mysql mysql  4100 Nov 23 12:08 host_summary_by_statement_latency.frm
                                -rw-r----- 1 mysql mysql  4459 Nov 23 12:08 host_summary_by_statement_type.frm
                                -rw-r----- 1 mysql mysql  4005 Nov 23 12:08 host_summary.frm
                                -rw-r----- 1 mysql mysql  2492 Nov 23 12:08 innodb_buffer_stats_by_schema.frm
                                -rw-r----- 1 mysql mysql  2782 Nov 23 12:08 innodb_buffer_stats_by_table.frm
                                -rw-r----- 1 mysql mysql  5264 Nov 23 12:08 innodb_lock_waits.frm
                                -rw-r----- 1 mysql mysql  4390 Nov 23 12:08 io_by_thread_by_latency.frm
                                -rw-r----- 1 mysql mysql  4169 Nov 23 12:08 io_global_by_file_by_bytes.frm
                                -rw-r----- 1 mysql mysql  2561 Nov 23 12:08 io_global_by_file_by_latency.frm
                                -rw-r----- 1 mysql mysql  5166 Nov 23 12:08 io_global_by_wait_by_bytes.frm
                                -rw-r----- 1 mysql mysql  4983 Nov 23 12:08 io_global_by_wait_by_latency.frm
                                -rw-r----- 1 mysql mysql  3441 Nov 23 12:08 latest_file_io.frm
                                -rw-r----- 1 mysql mysql  3475 Nov 23 12:08 memory_by_host_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql  3214 Nov 23 12:08 memory_by_thread_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql  3475 Nov 23 12:08 memory_by_user_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql  3405 Nov 23 12:08 memory_global_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql   827 Nov 23 12:08 memory_global_total.frm
                                -rw-r----- 1 mysql mysql 10208 Nov 23 12:08 metrics.frm
                                -rw-r----- 1 mysql mysql  8316 Nov 23 12:08 processlist.frm
                                -rw-r----- 1 mysql mysql  1093 Nov 23 12:08 ps_check_lost_instrumentation.frm
                                -rw-r----- 1 mysql mysql  6163 Nov 23 12:08 schema_auto_increment_columns.frm
                                -rw-r----- 1 mysql mysql  3606 Nov 23 12:08 schema_index_statistics.frm
                                -rw-r----- 1 mysql mysql  3725 Nov 23 12:08 schema_object_overview.frm
                                -rw-r----- 1 mysql mysql  5226 Nov 23 12:08 schema_redundant_indexes.frm
                                -rw-r----- 1 mysql mysql  5103 Nov 23 12:08 schema_table_lock_waits.frm
                                -rw-r----- 1 mysql mysql  3987 Nov 23 12:08 schema_table_statistics.frm
                                -rw-r----- 1 mysql mysql  5400 Nov 23 12:08 schema_table_statistics_with_buffer.frm
                                -rw-r----- 1 mysql mysql  1982 Nov 23 12:08 schema_tables_with_full_table_scans.frm
                                -rw-r----- 1 mysql mysql  1949 Nov 23 12:08 schema_unused_indexes.frm
                                -rw-r----- 1 mysql mysql  3044 Nov 23 12:08 session.frm
                                -rw-r----- 1 mysql mysql  2034 Nov 23 12:08 session_ssl_status.frm
                                -rw-r----- 1 mysql mysql  7048 Nov 23 12:08 statement_analysis.frm
                                -rw-r----- 1 mysql mysql  3758 Nov 23 12:08 statements_with_errors_or_warnings.frm
                                -rw-r----- 1 mysql mysql  5656 Nov 23 12:08 statements_with_full_table_scans.frm
                                -rw-r----- 1 mysql mysql  3479 Nov 23 12:08 statements_with_runtimes_in_95th_percentile.frm
                                -rw-r----- 1 mysql mysql  4305 Nov 23 12:08 statements_with_sorting.frm
                                -rw-r----- 1 mysql mysql  4325 Nov 23 12:08 statements_with_temp_tables.frm
                                -rw-r----- 1 mysql mysql  8672 Nov 23 12:08 sys_config.frm
                                -rw-r----- 1 mysql mysql 98304 Nov 23 12:08 sys_config.ibd
                                -rw-r----- 1 mysql mysql    42 Nov 23 12:08 sys_config_insert_set_user.TRN
                                -rw-r----- 1 mysql mysql   720 Nov 23 12:08 sys_config.TRG
                                -rw-r----- 1 mysql mysql    42 Nov 23 12:08 sys_config_update_set_user.TRN
                                -rw-r----- 1 mysql mysql  2343 Nov 23 12:08 user_summary_by_file_io.frm
                                -rw-r----- 1 mysql mysql  2924 Nov 23 12:08 user_summary_by_file_io_type.frm
                                -rw-r----- 1 mysql mysql  2725 Nov 23 12:08 user_summary_by_stages.frm
                                -rw-r----- 1 mysql mysql  4100 Nov 23 12:08 user_summary_by_statement_latency.frm
                                -rw-r----- 1 mysql mysql  4425 Nov 23 12:08 user_summary_by_statement_type.frm
                                -rw-r----- 1 mysql mysql  4697 Nov 23 12:08 user_summary.frm
                                -rw-r----- 1 mysql mysql   460 Nov 23 12:08 version.frm
                                -rw-r----- 1 mysql mysql  3580 Nov 23 12:08 wait_classes_global_by_avg_latency.frm
                                -rw-r----- 1 mysql mysql  3420 Nov 23 12:08 wait_classes_global_by_latency.frm
                                -rw-r----- 1 mysql mysql  3210 Nov 23 12:08 waits_by_host_by_latency.frm
                                -rw-r----- 1 mysql mysql  3413 Nov 23 12:08 waits_by_user_by_latency.frm
                                -rw-r----- 1 mysql mysql  2427 Nov 23 12:08 waits_global_by_latency.frm
                                -rw-r----- 1 mysql mysql  2284 Nov 23 12:08 x@0024host_summary_by_file_io.frm
                                -rw-r----- 1 mysql mysql  2858 Nov 23 12:08 x@0024host_summary_by_file_io_type.frm
                                -rw-r----- 1 mysql mysql  2640 Nov 23 12:08 x@0024host_summary_by_stages.frm
                                -rw-r----- 1 mysql mysql  3923 Nov 23 12:08 x@0024host_summary_by_statement_latency.frm
                                -rw-r----- 1 mysql mysql  4282 Nov 23 12:08 x@0024host_summary_by_statement_type.frm
                                -rw-r----- 1 mysql mysql  3651 Nov 23 12:08 x@0024host_summary.frm
                                -rw-r----- 1 mysql mysql  2430 Nov 23 12:08 x@0024innodb_buffer_stats_by_schema.frm
                                -rw-r----- 1 mysql mysql  2720 Nov 23 12:08 x@0024innodb_buffer_stats_by_table.frm
                                -rw-r----- 1 mysql mysql  5116 Nov 23 12:08 x@0024innodb_lock_waits.frm
                                -rw-r----- 1 mysql mysql  4154 Nov 23 12:08 x@0024io_by_thread_by_latency.frm
                                -rw-r----- 1 mysql mysql  3800 Nov 23 12:08 x@0024io_global_by_file_by_bytes.frm
                                -rw-r----- 1 mysql mysql  2266 Nov 23 12:08 x@0024io_global_by_file_by_latency.frm
                                -rw-r----- 1 mysql mysql  4623 Nov 23 12:08 x@0024io_global_by_wait_by_bytes.frm
                                -rw-r----- 1 mysql mysql  4381 Nov 23 12:08 x@0024io_global_by_wait_by_latency.frm
                                -rw-r----- 1 mysql mysql  3261 Nov 23 12:08 x@0024latest_file_io.frm
                                -rw-r----- 1 mysql mysql  3227 Nov 23 12:08 x@0024memory_by_host_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql  2967 Nov 23 12:08 x@0024memory_by_thread_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql  3227 Nov 23 12:08 x@0024memory_by_user_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql  3157 Nov 23 12:08 x@0024memory_global_by_current_bytes.frm
                                -rw-r----- 1 mysql mysql   765 Nov 23 12:08 x@0024memory_global_total.frm
                                -rw-r----- 1 mysql mysql  7812 Nov 23 12:08 x@0024processlist.frm
                                -rw-r----- 1 mysql mysql  1747 Nov 23 12:08 x@0024ps_digest_95th_percentile_by_avg_us.frm
                                -rw-r----- 1 mysql mysql   844 Nov 23 12:08 x@0024ps_digest_avg_latency_distribution.frm
                                -rw-r----- 1 mysql mysql  2926 Nov 23 12:08 x@0024ps_schema_table_statistics_io.frm
                                -rw-r----- 1 mysql mysql  2469 Nov 23 12:08 x@0024schema_flattened_keys.frm
                                -rw-r----- 1 mysql mysql  3370 Nov 23 12:08 x@0024schema_index_statistics.frm
                                -rw-r----- 1 mysql mysql  5029 Nov 23 12:08 x@0024schema_table_lock_waits.frm
                                -rw-r----- 1 mysql mysql  3391 Nov 23 12:08 x@0024schema_table_statistics.frm
                                -rw-r----- 1 mysql mysql  4679 Nov 23 12:08 x@0024schema_table_statistics_with_buffer.frm
                                -rw-r----- 1 mysql mysql  1923 Nov 23 12:08 x@0024schema_tables_with_full_table_scans.frm
                                -rw-r----- 1 mysql mysql  3170 Nov 23 12:08 x@0024session.frm
                                -rw-r----- 1 mysql mysql  6738 Nov 23 12:08 x@0024statement_analysis.frm
                                -rw-r----- 1 mysql mysql  3684 Nov 23 12:08 x@0024statements_with_errors_or_warnings.frm
                                -rw-r----- 1 mysql mysql  5481 Nov 23 12:08 x@0024statements_with_full_table_scans.frm
                                -rw-r----- 1 mysql mysql  3228 Nov 23 12:08 x@0024statements_with_runtimes_in_95th_percentile.frm
                                -rw-r----- 1 mysql mysql  4172 Nov 23 12:08 x@0024statements_with_sorting.frm
                                -rw-r----- 1 mysql mysql  4192 Nov 23 12:08 x@0024statements_with_temp_tables.frm
                                -rw-r----- 1 mysql mysql  2284 Nov 23 12:08 x@0024user_summary_by_file_io.frm
                                -rw-r----- 1 mysql mysql  2806 Nov 23 12:08 x@0024user_summary_by_file_io_type.frm
                                -rw-r----- 1 mysql mysql  2607 Nov 23 12:08 x@0024user_summary_by_stages.frm
                                -rw-r----- 1 mysql mysql  3923 Nov 23 12:08 x@0024user_summary_by_statement_latency.frm
                                -rw-r----- 1 mysql mysql  4248 Nov 23 12:08 x@0024user_summary_by_statement_type.frm
                                -rw-r----- 1 mysql mysql  4396 Nov 23 12:08 x@0024user_summary.frm
                                -rw-r----- 1 mysql mysql  3236 Nov 23 12:08 x@0024wait_classes_global_by_avg_latency.frm
                                -rw-r----- 1 mysql mysql  3187 Nov 23 12:08 x@0024wait_classes_global_by_latency.frm
                                -rw-r----- 1 mysql mysql  3033 Nov 23 12:08 x@0024waits_by_host_by_latency.frm
                                -rw-r----- 1 mysql mysql  3236 Nov 23 12:08 x@0024waits_by_user_by_latency.frm
                                -rw-r----- 1 mysql mysql  2250 Nov 23 12:08 x@0024waits_global_by_latency.frm
                                
                                /var/lib/mysql-files:
                                total 8
                                drwx------  2 mysql mysql 4096 Nov 23 12:08 .
                                drwxr-xr-x 76 root  root  4096 Nov 25 12:46 ..
                                
                                /var/lib/mysql-keyring:
                                total 8
                                drwx------  2 mysql mysql 4096 Nov 23 12:07 .
                                drwxr-xr-x 76 root  root  4096 Nov 25 12:46 ..
                                root@FogServerKubuntu:/home/chaosnature#
                                
                                

                                Please advie

                                C 1 Reply Last reply Reply Quote 0
                                • C
                                  chasosnature @chasosnature
                                  last edited by

                                  @chasosnature

                                  and more…

                                  drwxr-xr-x  4 mysql mysql     4096 Nov 25 14:12 .
                                  drwxr-xr-x 76 root  root      4096 Nov 25 12:46 ..
                                  -rw-rw----  1 mysql mysql    16384 Nov 25 14:12 aria_log.00000001
                                  -rw-rw----  1 mysql mysql       52 Nov 25 14:12 aria_log_control
                                  -rw-r--r--  1 root  root         0 Nov 25 12:46 debian-10.1.flag
                                  -rw-rw----  1 mysql mysql 12582912 Nov 25 14:12 ibdata1
                                  -rw-rw----  1 mysql mysql 50331648 Nov 25 14:12 ib_logfile0
                                  -rw-rw----  1 mysql mysql 50331648 Nov 25 12:47 ib_logfile1
                                  -rw-rw----  1 mysql mysql        0 Nov 25 12:47 multi-master.info
                                  drwx------  2 mysql mysql     4096 Nov 25 12:47 mysql
                                  drwx------  2 mysql mysql     4096 Nov 25 12:47 performance_schema
                                  
                                  /var/lib/mysql/mysql:
                                  total 1100
                                  drwx------ 2 mysql mysql   4096 Nov 25 12:47 .
                                  drwxr-xr-x 4 mysql mysql   4096 Nov 25 14:12 ..
                                  -rw-rw---- 1 mysql mysql   2110 Nov 25 12:47 columns_priv.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 columns_priv.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 columns_priv.MYI
                                  -rw-rw---- 1 mysql mysql   2602 Nov 25 12:47 column_stats.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 column_stats.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 column_stats.MYI
                                  -rw-rw---- 1 mysql mysql   2677 Nov 25 12:47 db.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 db.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 db.MYI
                                  -rw-rw---- 1 mysql mysql     67 Nov 25 12:47 db.opt
                                  -rw-rw---- 1 mysql mysql   3683 Nov 25 12:47 event.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 event.MYD
                                  -rw-rw---- 1 mysql mysql   2048 Nov 25 12:47 event.MYI
                                  -rw-rw---- 1 mysql mysql   1582 Nov 25 12:47 func.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 func.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 func.MYI
                                  -rw-rw---- 1 mysql mysql     35 Nov 25 12:47 general_log.CSM
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 general_log.CSV
                                  -rw-rw---- 1 mysql mysql    804 Nov 25 12:47 general_log.frm
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 gtid_slave_pos.frm
                                  -rw-rw---- 1 mysql mysql  98304 Nov 25 12:47 gtid_slave_pos.ibd
                                  -rw-rw---- 1 mysql mysql   1706 Nov 25 12:47 help_category.frm
                                  -rw-rw---- 1 mysql mysql   1092 Nov 25 12:47 help_category.MYD
                                  -rw-rw---- 1 mysql mysql   3072 Nov 25 12:47 help_category.MYI
                                  -rw-rw---- 1 mysql mysql   1638 Nov 25 12:47 help_keyword.frm
                                  -rw-rw---- 1 mysql mysql  91408 Nov 25 12:47 help_keyword.MYD
                                  -rw-rw---- 1 mysql mysql  16384 Nov 25 12:47 help_keyword.MYI
                                  -rw-rw---- 1 mysql mysql    970 Nov 25 12:47 help_relation.frm
                                  -rw-rw---- 1 mysql mysql   9252 Nov 25 12:47 help_relation.MYD
                                  -rw-rw---- 1 mysql mysql  19456 Nov 25 12:47 help_relation.MYI
                                  -rw-rw---- 1 mysql mysql   1776 Nov 25 12:47 help_topic.frm
                                  -rw-rw---- 1 mysql mysql 405476 Nov 25 12:47 help_topic.MYD
                                  -rw-rw---- 1 mysql mysql  20480 Nov 25 12:47 help_topic.MYI
                                  -rw-rw---- 1 mysql mysql   1897 Nov 25 12:47 host.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 host.MYD
                                  -rw-rw---- 1 mysql mysql   2048 Nov 25 12:47 host.MYI
                                  -rw-rw---- 1 mysql mysql   1629 Nov 25 12:47 index_stats.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 index_stats.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 index_stats.MYI
                                  -rw-rw---- 1 mysql mysql   4998 Nov 25 12:47 innodb_index_stats.frm
                                  -rw-rw---- 1 mysql mysql  98304 Nov 25 12:47 innodb_index_stats.ibd
                                  -rw-rw---- 1 mysql mysql   1503 Nov 25 12:47 innodb_table_stats.frm
                                  -rw-rw---- 1 mysql mysql  98304 Nov 25 12:47 innodb_table_stats.ibd
                                  -rw-rw---- 1 mysql mysql   1518 Nov 25 12:47 plugin.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 plugin.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 plugin.MYI
                                  -rw-rw---- 1 mysql mysql   3418 Nov 25 12:47 proc.frm
                                  -rw-rw---- 1 mysql mysql   1144 Nov 25 12:47 proc.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 proc.MYI
                                  -rw-rw---- 1 mysql mysql   2874 Nov 25 12:47 procs_priv.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 procs_priv.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 procs_priv.MYI
                                  -rw-rw---- 1 mysql mysql   2839 Nov 25 12:47 proxies_priv.frm
                                  -rw-rw---- 1 mysql mysql   1269 Nov 25 12:47 proxies_priv.MYD
                                  -rw-rw---- 1 mysql mysql  10240 Nov 25 12:47 proxies_priv.MYI
                                  -rw-rw---- 1 mysql mysql   1661 Nov 25 12:47 roles_mapping.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 roles_mapping.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 roles_mapping.MYI
                                  -rw-rw---- 1 mysql mysql   2703 Nov 25 12:47 servers.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 servers.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 servers.MYI
                                  -rw-rw---- 1 mysql mysql     35 Nov 25 12:47 slow_log.CSM
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 slow_log.CSV
                                  -rw-rw---- 1 mysql mysql   2374 Nov 25 12:47 slow_log.frm
                                  -rw-rw---- 1 mysql mysql   2957 Nov 25 12:47 tables_priv.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 tables_priv.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 tables_priv.MYI
                                  -rw-rw---- 1 mysql mysql   1374 Nov 25 12:47 table_stats.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 table_stats.MYD
                                  -rw-rw---- 1 mysql mysql   2048 Nov 25 12:47 table_stats.MYI
                                  -rw-rw---- 1 mysql mysql    973 Nov 25 12:47 time_zone.frm
                                  -rw-rw---- 1 mysql mysql    971 Nov 25 12:47 time_zone_leap_second.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 time_zone_leap_second.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 time_zone_leap_second.MYI
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 time_zone.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 time_zone.MYI
                                  -rw-rw---- 1 mysql mysql   1146 Nov 25 12:47 time_zone_name.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 time_zone_name.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 time_zone_name.MYI
                                  -rw-rw---- 1 mysql mysql   1013 Nov 25 12:47 time_zone_transition.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 time_zone_transition.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 time_zone_transition.MYI
                                  -rw-rw---- 1 mysql mysql   1079 Nov 25 12:47 time_zone_transition_type.frm
                                  -rw-rw---- 1 mysql mysql      0 Nov 25 12:47 time_zone_transition_type.MYD
                                  -rw-rw---- 1 mysql mysql   1024 Nov 25 12:47 time_zone_transition_type.MYI
                                  -rw-rw---- 1 mysql mysql   3191 Nov 25 12:47 user.frm
                                  -rw-rw---- 1 mysql mysql     72 Nov 25 12:47 user.MYD
                                  -rw-rw---- 1 mysql mysql   4096 Nov 25 12:47 user.MYI
                                  
                                  /var/lib/mysql/performance_schema:
                                  total 12
                                  drwx------ 2 mysql mysql 4096 Nov 25 12:47 .
                                  drwxr-xr-x 4 mysql mysql 4096 Nov 25 14:12 ..
                                  -rw-rw---- 1 mysql mysql   61 Nov 25 12:47 db.opt
                                  
                                  /var/lib/mysql-5.7:
                                  total 110672
                                  drwx------  6 mysql mysql     4096 Nov 25 12:45 .
                                  drwxr-xr-x 76 root  root      4096 Nov 25 12:46 ..
                                  -rw-r-----  1 mysql mysql       56 Nov 23 12:07 auto.cnf
                                  -rw-------  1 mysql mysql     1680 Nov 23 12:07 ca-key.pem
                                  -rw-r--r--  1 mysql mysql     1112 Nov 23 12:07 ca.pem
                                  -rw-r--r--  1 mysql mysql     1112 Nov 23 12:07 client-cert.pem
                                  -rw-------  1 mysql mysql     1680 Nov 23 12:07 client-key.pem
                                  -rw-r--r--  1 root  root         0 Nov 23 12:08 debian-5.7.flag
                                  drwxr-x---  2 mysql mysql    12288 Nov 23 14:29 fog
                                  -rw-r-----  1 mysql mysql      289 Nov 25 12:45 ib_buffer_pool
                                  -rw-r-----  1 mysql mysql 12582912 Nov 25 12:45 ibdata1
                                  -rw-r-----  1 mysql mysql 50331648 Nov 25 12:45 ib_logfile0
                                  -rw-r-----  1 mysql mysql 50331648 Nov 23 12:07 ib_logfile1
                                  drwxr-x---  2 mysql mysql     4096 Nov 23 12:08 mysql
                                  drwxr-x---  2 mysql mysql     4096 Nov 23 12:08 performance_schema
                                  -rw-------  1 mysql mysql     1680 Nov 23 12:07 private_key.pem
                                  -rw-r--r--  1 mysql mysql      452 Nov 23 12:07 public_key.pem
                                  -rw-r--r--  1 mysql mysql     1112 Nov 23 12:07 server-cert.pem
                                  -rw-------  1 mysql mysql     1676 Nov 23 12:07 server-key.pem
                                  drwxr-x---  2 mysql mysql    12288 Nov 23 12:08 sys
                                  
                                  
                                  1 Reply Last reply Reply Quote 0
                                  • S
                                    Sebastian Roth Moderator
                                    last edited by Sebastian Roth

                                    @chasosnature said in Fog installation and cofiguration on ubuntu 18.04:

                                    i descided to upgraded 1.4.4 to 1.5.7 instead of fresh install…why?..in a production environment we might not have that luxury of trashing and re-installing, an upgrade from one version to another without loss of data would be ideal.

                                    Over the weekend I have done a fair amount of upgrade testing to make sure a major change I have been working on is not causing any trouble for people who upgrade. Tested 1.4.4 as well as other versions and all upgraded perfectly fine! This is not to say that things cannot go wrong. The more customized an install is the less chance we have. There is no guarantee the installer works perfectly right in all situations.

                                    from today i am dealing with 1.5.7 fog version.
                                    i will only get back to the 1.4.4 version on 18.04 …

                                    Good choice. There is absolutely no point in using the very dated 1.4.4. We put a lot of our time and effort into improving FOG and helping people to get it up. We simply can’t afford the time to backport all the fixes to older version on top of that.

                                    i have watched multiple youtube videos , all i see these guys doing is install the fog server pxe a live system and fog picks up.

                                    I think you just got Tom’s message the wrong way. What we was trying to say is that you need to have an installed client system to capture an image from before you can deploy it to other machines. It’s correct that you just need to setup FOG server and if your network setup is right you can just PXE boot clients and they’ll boot to the FOG menu for registration and things!

                                    Now about the database issue:

                                    /var/lib/mysql-5.7:
                                    total 110672
                                    drwx------  6 mysql mysql     4096 Nov 25 12:45 .
                                    drwxr-xr-x 76 root  root      4096 Nov 25 12:46 ..
                                    -rw-r-----  1 mysql mysql       56 Nov 23 12:07 auto.cnf
                                    -rw-------  1 mysql mysql     1680 Nov 23 12:07 ca-key.pem
                                    -rw-r--r--  1 mysql mysql     1112 Nov 23 12:07 ca.pem
                                    -rw-r--r--  1 mysql mysql     1112 Nov 23 12:07 client-cert.pem
                                    -rw-------  1 mysql mysql     1680 Nov 23 12:07 client-key.pem
                                    -rw-r--r--  1 root  root         0 Nov 23 12:08 debian-5.7.flag
                                    drwxr-x---  2 mysql mysql    12288 Nov 23 14:29 fog
                                    -rw-r-----  1 mysql mysql      289 Nov 25 12:45 ib_buffer_pool
                                    -rw-r-----  1 mysql mysql 12582912 Nov 25 12:45 ibdata1
                                    ...
                                    

                                    The output you posted clearly shows what has happened. You should be able to fix this using the following commands:

                                    sudo -i
                                    mv /var/lib/mysql /var/lib/mysql-backup
                                    apt-get remove mariadb-client mariadb-server
                                    cp -a /var/lib/mysql-5.7 /var/lib/mysql
                                    rm /var/lib/mysql/debian-5.7.flag
                                    chown -R mysql:mysql /var/lib/mysql/
                                    apt-get install mysql-client mysql-server
                                    systemctl start mysql
                                    

                                    IMPORTANT: This is a known issue and documented in the forums. Whenever you re-run the 1.5.7 installer on Ubuntu 18.04 you need to pay attention and say NO when asked if Apache and PHP should be re-installed!

                                    PS: I do wonder about some of the files you have in that directory. auto.cnf, ca-key.pem, ca.pem and so on. Seems like you are playing with things here. As I said, the more custom things you do the more chance things will break because the scripts can’t handle it.

                                    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
                                    • S
                                      Sebastian Roth Moderator
                                      last edited by

                                      @chasosnature Just one more thing. You are very welcome to test FOG and let us know about bugs as you find them. But be aware that the team of developers is sparsely populated at the moment and we can’t promise to fix it all in a rush. The more you help by describing problems in a way that we can replicate and fix those the more quickly we can add fixes. As you said, it’s open source and therefore needs people (not just officials developers!) to put in time and effort. You are very welcome to join in and help.

                                      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
                                        chasosnature @Sebastian Roth
                                        last edited by

                                        @Sebastian-Roth

                                        look at your dedications : its priceless…thanks for your response.

                                        Now lets deal with this:

                                        1. based on your sudo -i …work around i have revisted that snapshot and i will try it and see what happens and update you. (i only just realized no that i have been answering y to the very first installation question, this time i try N)

                                        2. there is another snapshot which also has Database connection unavailable, and i have founf that the msql service is refusing to start up
                                          after 1. i will revisit 2. and follw the below steps and update you.

                                        apt-get remove --purge mysql*
                                        apt-get remove --purge mysql
                                        apt-get remove --purge mariadb
                                        apt-get remove --purge mariadb*
                                        apt-get --purge remove mariadb-server
                                        apt-get --purge remove python-software-properties
                                        Note: When prompted if you want to dump your current Databases, say no. But you can deconfigure the phpmyadmin database easily.

                                        Install everything from fresh: Add the following to your /etc/apt/sources.list file:

                                        deb [arch=amd64,i386] http://ftp.utexas.edu/mariadb/repo/10.1/debian jessie main
                                        deb-src http://ftp.utexas.edu/mariadb/repo/10.1/debian jessie main
                                        Then,

                                        apt-get install python-software-properties
                                        apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
                                        apt-get install software-properties-common
                                        apt-get install mariadb-server mariadb-client

                                        Once your are done you should be able to run mysql -V and see something like:

                                        mysql Ver 15.1 Distrib 10.1.9-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

                                        The reason for my effort on this method is this:
                                        The scenerio would be:
                                        you have a production environment already running 16.04 with 1.4.4 Fog (fog seem to be very compatible with this version of ubuntu)
                                        you wish to upgrade your OS to 18.04 ubuntu
                                        then upgrade your Fog to 1.5.7
                                        You use phpmyadmin or some other method to backup your database.

                                        it would be nice to have an update package that can be applied to 18.04 to bring fog 1.4.4 to 1.5.7 using these experiences gathered.

                                        @Tom-Elliott

                                        lol…i wasnt trying to image a system with no OS.
                                        so now that we are clear , i can say forget clonzilla.

                                        i will update my progress here.

                                        1 Reply Last reply Reply Quote 0
                                        • C
                                          chasosnature @Sebastian Roth
                                          last edited by

                                          @Sebastian-Roth

                                          answering no to the first question will result in:

                                          • Setting up and starting MySQL…Done

                                          • Backing up user reports…Done

                                          • Stopping web service…Failed!
                                            OK

                                          • Removing vhost file…OK

                                          • Setting up Apache and PHP files…Failed
                                            ###########################################

                                            PHP Failed to install properly

                                            ###########################################

                                            Could not find /etc/php//fpm/php.ini!
                                            root@FogServerKubuntu:/opt/fogproject-1.5.7/bin#

                                          i have not run your fix yet…

                                          1 Reply Last reply Reply Quote 0
                                          • S
                                            Sebastian Roth Moderator
                                            last edited by

                                            @chasosnature said in Fog installation and cofiguration on ubuntu 18.04:

                                            dd the following to your /etc/apt/sources.list file:
                                            deb [arch=amd64,i386] http://ftp.utexas.edu/mariadb/repo/10.1/debian jessie main
                                            deb-src http://ftp.utexas.edu/mariadb/repo/10.1/debian jessie main

                                            As I said, the more custom modifications you make the higher the chance things go wrong!!

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

                                            167

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project