Fog installation and cofiguration on ubuntu 18.04 / 19.04 No DHCP Option
-
Did an installation of fog 1.4.4 after much reading and researching.lots of manipulations to get it to install,
yet again a lot of manipulation to get it to pxe boot capture the device node…thought great since no one else seems to have this done succesfully on ubuntu 18 , i will do a youtube vedeo and write something up for others.
one problem:
time to test it ; little or no success.i get these errors-
fog error creating epoll fd (reas somewhere advising to ignore this error)
Turned on logging and i get:
-
running post init script … /imageinit/dev/postinitscripts/fog.postinit: line 10: /images/dev/postinitscripts$: no such file or directory
Done
an error has been detected
Fatal Error: unknown request type :: NullRebooting system as task is completed
i have this (below) in the postscript…before this i had nothing as default after installation
/images/dev/postinitscripts$ cat fog.postinit
please advice
-
-
The advice is to install FOG 1.5.7 instead of 1.4.4
-
thank you for your quick response…amazed.
i have read in forums where they complained that 1.5 causes them issues, this is why i am hesitating .
what is the easiest way to upgrade if you dont mind me asking.i plan to run: sudo mv /opt/fog/.fogsettings /opt/fog/fogsettings-firstInstall
download the package (fog 1.5)
and run it again.or is it doable from the management portal?
many thanks in advance.
-
do i need to have post scripts?
did it work out of the box for you? -
@chasosnature said in Fog installation and cofiguration on ubuntu 18.04:
i have read in forums where they complained that 1.5 causes them issues, this is why i am hesitating .
Can you please post where you read about this?
fog error creating epoll fd
Not an error, can be ignored.
running post init script … /imageinit/dev/postinitscripts/fog.postinit: line 10: /images/dev/postinitscripts$: no such file or directory
DonePlease take a picture of the exact error and post here!
-
-
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…
-
@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.
-
@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?
-
@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.
-
an update :
i have upgraded to 1.5.7
no errorsat the point of:
-
You still need to install/update your database schema.
-
This can be done by opening a web browser and going to:
but i get this :
Database connection unavailablebelow 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$ -
-
-
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:
this is where the installation got to (so waiting to solve this before pressing enter)
any ideas?
-
@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!!) -
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…
-
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# -
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. -
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…
-
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
-
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