Fog installation and cofiguration on ubuntu 18.04 / 19.04 No DHCP Option
-
@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 -
@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 mysqlIMPORTANT: 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.
-
@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.
-
look at your dedications : its priceless…thanks for your response.
Now lets deal with this:
-
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)
-
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-clientOnce 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.
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.
-
-
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…
-
-
@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 mainAs I said, the more custom modifications you make the higher the chance things go wrong!!
-
oh yeah, you just reminded me now…
in regards to the custom mod business…those files you mentioned earlier where copied over , it was customisation to get dnsmasq functioning as tftpboot…it was the only way i could get 1.4.4 installed on ubuntu 18.04 successfully to the point of that initial error i started the post with. (but i believe we all agree now that 1.4.4 might never function on ubuntu 1.4.4 so i am doing an upgrade from that)
-
@chasosnature Please run
grep php /opt/fog/.fogsettingsanddpkg -l | grep php- post results of both commands here.I remember the switch from PHP 5.x to 7.x was a really ugly situation with every distro doing things differently we had to work around to many things.
-
@Sebastian-Roth said in Fog installation and cofiguration on ubuntu 18.04:
grep php /opt/fog/.fogsettings
O.k update…
trying to update a “working” 1.4.4 (ubuntu 18.04) with 1.5.7 (ubuntu 18.04)
last portion:
* Configuring services * Setting up fogproject user..................................OK * Locking fogproject as a system account......................OK * Setting up fogproject password..............................OK * Stopping FOGMulticastManager.service Service................OK * Stopping FOGImageReplicator.service Service.................OK * Stopping FOGSnapinReplicator.service Service................OK * Stopping FOGScheduler.service Service.......................OK * Stopping FOGPingHosts.service Service.......................OK * Stopping FOGSnapinHash.service Service......................OK * Stopping FOGImageSize.service Service.......................OK * Is the MySQL password blank? (Y/n) y * 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#running: grep php /opt/fog/.fogsettings
root@FogServerKubuntu:/opt/fogproject-1.5.7/bin# grep php /opt/fog/.fogsettings grep: /opt/fog/.fogsettings: No such file or directory root@FogServerKubuntu:/opt/fogproject-1.5.7/bin#running: dpkg -l | grep php
root@FogServerKubuntu:/opt/fogproject-1.5.7/bin# dpkg -l | grep php ii libapache2-mod-php 1:7.2+60ubuntu1 all server-side, HTML-embedded scripting language (Apache 2 module) (default) ii libapache2-mod-php7.1 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 server-side, HTML-embedded scripting language (Apache 2 module) ii libapache2-mod-php7.2 7.2.24-0ubuntu0.18.04.1 amd64 server-side, HTML-embedded scripting language (Apache 2 module) ii php 1:7.2+60ubuntu1 all server-side, HTML-embedded scripting language (default) ii php-bcmath 1:7.2+60ubuntu1 all Bcmath module for PHP [default] ii php-cli 1:7.2+60ubuntu1 all command-line interpreter for the PHP scripting language (default) ii php-common 2:70+ubuntu18.04.1+deb.sury.org+6 all Common files for PHP packages ii php-curl 1:7.2+60ubuntu1 all CURL module for PHP [default] ii php-fpm 1:7.2+60ubuntu1 all server-side, HTML-embedded scripting language (FPM-CGI binary) (default) ii php-gd 1:7.2+60ubuntu1 all GD module for PHP [default] ii php-gettext 1.0.12-0.1 all transitional dummy package for php-php-gettext ii php-json 1:7.2+60ubuntu1 all JSON module for PHP [default] ii php-mbstring 1:7.2+60ubuntu1 all MBSTRING module for PHP [default] ii php-mysql 1:7.2+60ubuntu1 all MySQL module for PHP [default] ii php-pear 1:1.10.8+submodules+notgz-1+ubuntu18.04.1+deb.sury.org+1 all PEAR Base System ii php-php-gettext 1.0.12-0.1 all read gettext MO files directly, without requiring anything other than PHP ii php-xml 2:7.3+70+ubuntu18.04.1+deb.sury.org+6 all DOM, SimpleXML, WDDX, XML, and XSL module for PHP [default] ii php7.1 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 all server-side, HTML-embedded scripting language (metapackage) ii php7.1-bcmath 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 Bcmath module for PHP ii php7.1-cli 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 command-line interpreter for the PHP scripting language ii php7.1-common 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 documentation, examples and common module for PHP ii php7.1-curl 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 CURL module for PHP ii php7.1-fpm 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary) ii php7.1-gd 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 GD module for PHP ii php7.1-json 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 JSON module for PHP ii php7.1-ldap 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 LDAP module for PHP ii php7.1-mbstring 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 MBSTRING module for PHP ii php7.1-mcrypt 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 libmcrypt module for PHP ii php7.1-mysql 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 MySQL module for PHP ii php7.1-opcache 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 Zend OpCache module for PHP ii php7.1-readline 7.1.33-1+ubuntu18.04.1+deb.sury.org+1 amd64 readline module for PHP ii php7.2 7.2.24-0ubuntu0.18.04.1 all server-side, HTML-embedded scripting language (metapackage) ii php7.2-bcmath 7.2.24-0ubuntu0.18.04.1 amd64 Bcmath module for PHP ii php7.2-cli 7.2.24-0ubuntu0.18.04.1 amd64 command-line interpreter for the PHP scripting language ii php7.2-common 7.2.24-0ubuntu0.18.04.1 amd64 documentation, examples and common module for PHP ii php7.2-curl 7.2.24-0ubuntu0.18.04.1 amd64 CURL module for PHP ii php7.2-fpm 7.2.24-0ubuntu0.18.04.1 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary) ii php7.2-gd 7.2.24-0ubuntu0.18.04.1 amd64 GD module for PHP ii php7.2-json 7.2.24-0ubuntu0.18.04.1 amd64 JSON module for PHP ii php7.2-mbstring 7.2.24-0ubuntu0.18.04.1 amd64 MBSTRING module for PHP ii php7.2-mysql 7.2.24-0ubuntu0.18.04.1 amd64 MySQL module for PHP ii php7.2-opcache 7.2.24-0ubuntu0.18.04.1 amd64 Zend OpCache module for PHP ii php7.2-readline 7.2.24-0ubuntu0.18.04.1 amd64 readline module for PHP ii php7.3-common 7.3.11-1+ubuntu18.04.1+deb.sury.org+1 amd64 documentation, examples and common module for PHP ii php7.3-xml 7.3.11-1+ubuntu18.04.1+deb.sury.org+1 amd64 DOM, SimpleXML, WDDX, XML, and XSL module for PHPis this the point where i run: ??
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 -
@chasosnature Just another option that came to my mind is update to 1.5.6 saying yes to re-installing Apache/PHP and then update to 1.5.7 from there but saying no to Apache/PHP re-install…
-
i was about to update to 1.5.7 saying yes
but let me revert snapshot and try your suggestion…
-
@chasosnature Time for bed in Europe. Will see how it went for you tomorrow morning…
Different versions of PHP installed might make it hard to fix all this…
-
sure…thanks for your time.
-
ok below is the scripts that tells the whole story of my test :
so far all installed but mariam db not playing ball.
so i have snapshot it and taking a break,root@FogServerKubuntu:/opt/fogproject-1.5.7/bin# userdel fogproject root@FogServerKubuntu:/opt/fogproject-1.5.7/bin# ./installfog.sh -X Installing LSB_Release as needed * Attempting to get release information.......................Done systemd +------------------------------------------+ | ..#######:. ..,#,.. .::##::. | |.:###### .:;####:......;#;.. | |...##... ...##;,;##::::.##... | | ,# ...##.....##:::## ..:: | | ## .::###,,##. . ##.::#.:######::.| |...##:::###::....#. .. .#...#. #...#:::. | |..:####:.. ..##......##::## .. # | | # . ...##:,;##;:::#: ... ##.. | | .# . .:;####;::::.##:::;#:.. | | # ..:;###.. | | | +------------------------------------------+ | Free Computer Imaging Solution | +------------------------------------------+ | Credits: http://fogproject.org/Credits | | http://fogproject.org/Credits | | Released under GPL Version 3 | +------------------------------------------+ Version: 1.5.7 Installer/Updater What version of Linux would you like to run the installation for? 1) Redhat Based Linux (Redhat, CentOS, Mageia) 2) Debian Based Linux (Debian, Ubuntu, Kubuntu, Edubuntu) 3) Arch Linux Choice: [2] 2 Starting Debian based Installation *** Detected a potential need to reinstall apache and php files. *** This will remove the /etc/php* and /etc/apache2* directories *** and remove/purge the apache and php files from this system. *** If you're okay with this please type Y, anything else will *** continue the installation, but may mean you will need to *** remove the files later and make proper changes as *** necessary. (Y/N): y * Removing apache and php files...............................Done * Stopping web services.......................................Done * Removing the apache and php packages........................Done * Resetting our variables to specify php version..............Done FOG Server installation modes: * Normal Server: (Choice N) This is the typical installation type and will install all FOG components for you on this machine. Pick this option if you are unsure what to pick. * Storage Node: (Choice S) This install mode will only install the software required to make this server act as a node in a storage group More information: http://www.fogproject.org/wiki/index.php?title=InstallationModes What type of installation would you like to do? [N/s (Normal/Storage)] n We found the following interfaces on your system: * ens3 - xxx.xxx.x.xx/24 Would you like to change the default network interface from ens3? If you are not sure, select No. [y/N] n Would you like to setup a router address for the DHCP server? [Y/n] n Would you like DHCP to handle DNS? [Y/n] n Would you like to use the FOG server for DHCP service? [y/N] n This version of FOG has internationalization support, would you like to install the additional language packs? [y/N] n *** New option 'hostname' since FOG 1.5.6 *** Would you like to change the default hostname >FogServerKubuntu<? The fully qualified hostname is used for the webserver certificate. If you are not sure, select No. [y/N] n ###################################################################### # FOG now has everything it needs for this setup, but please # # understand that this script will overwrite any setting you may # # have setup for services like DHCP, apache, pxe, tftp, and NFS. # ###################################################################### # It is not recommended that you install this on a production system # # as this script modifies many of your system settings. # ###################################################################### # This script should be run by the root user. # # It will prepend the running with sudo if root is not set # ###################################################################### # Please see our wiki for more information at: # ###################################################################### # https://wiki.fogproject.org/wiki/index.php # ###################################################################### * Here are the settings FOG will use: * Base Linux: Debian * Detected Linux Distribution: Ubuntu * Interface: ens3 * Server IP Address: xxx.xxx.x.xx * Server Subnet Mask: 255.xxx.xxx.0 * Server Hostname: FogServerKubuntu * Installation Type: Normal Server * Internationalization: 0 * Image Storage Location: /images * Using FOG DHCP: No * DHCP will NOT be setup but you must setup your | current DHCP server to use FOG for PXE services. * On a Linux DHCP server you must set: next-server and filename * On a Windows DHCP server you must set options 066 and 067 * Option 066/next-server is the IP of the FOG Server: (e.g. xxx.xxx.x.xx) * Option 067/filename is the bootfile: (e.g. undionly.kpxe) * Are you sure you wish to continue (Y/N) y * Installation Started * Testing internet connection.................................Done * Adding repository if needed.................................OK * Preparing Package Manager...................................OK * Packages to be installed: apache2 bc build-essential cpp curl g++ gawk gcc genisoimage gzip htmldoc isolinux lftp libapache2-mod-php7.2 libc6 libcurl4 liblzma-dev m4 mariadb-client mariadb-server net-tools nfs-kernel-server openssh-server php7.2 php7.2-bcmath php7.2-cli php7.2-curl php7.2-fpm php7.2-gd php7.2-json php7.2-ldap php7.2-mbstring php7.2-mysql php7.2-mysqlnd php-gettext sysv-rc-conf tar tftpd-hpa tftp-hpa unzip vsftpd wget xinetd zlib1g * Installing package: apache2.................................OK * Skipping package: bc......................................(Already Installed) * Skipping package: build-essential.........................(Already Installed) * Skipping package: cpp.....................................(Already Installed) * Skipping package: curl....................................(Already Installed) * Skipping package: g++.....................................(Already Installed) * Skipping package: gawk....................................(Already Installed) * Skipping package: gcc.....................................(Already Installed) * Skipping package: genisoimage.............................(Already Installed) * Skipping package: gzip....................................(Already Installed) * Skipping package: htmldoc.................................(Already Installed) * Skipping package: isolinux................................(Already Installed) * Skipping package: lftp....................................(Already Installed) * Installing package: libapache2-mod-php7.2...................OK * Skipping package: libc6...................................(Already Installed) * Skipping package: libcurl4................................(Already Installed) * Skipping package: liblzma-dev.............................(Already Installed) * Skipping package: m4......................................(Already Installed) * Skipping package: mariadb-client..........................(Already Installed) * Skipping package: mariadb-server..........................(Already Installed) * Skipping package: net-tools...............................(Already Installed) * Skipping package: nfs-kernel-server.......................(Already Installed) * Skipping package: openssh-server..........................(Already Installed) * Installing package: php7.2..................................OK * Installing package: php7.2-bcmath...........................OK * Skipping package: php7.2-cli..............................(Already Installed) * Installing package: php7.2-curl.............................OK * Installing package: php7.2-fpm..............................OK * Installing package: php7.2-gd...............................OK * Skipping package: php7.2-json.............................(Already Installed) * Installing package: php7.2-ldap.............................OK * Installing package: php7.2-mbstring.........................OK * Installing package: php7.2-mysql............................OK * Skipping package: php7.2-mysql............................(Already Installed) * Installing package: php-gettext.............................OK * Skipping package: sysv-rc-conf..............................(Does not exist) * Skipping package: tar.....................................(Already Installed) * Skipping package: tftpd-hpa...............................(Already Installed) * Skipping package: tftp-hpa................................(Already Installed) * Skipping package: unzip...................................(Already Installed) * Skipping package: vsftpd..................................(Already Installed) * Skipping package: wget....................................(Already Installed) * Skipping package: xinetd..................................(Already Installed) * Skipping package: zlib1g..................................(Already Installed) * Updating packages as needed.................................OK * Confirming package installation * Checking package: apache2...................................OK * Checking package: bc........................................OK * Checking package: build-essential...........................OK * Checking package: cpp.......................................OK * Checking package: curl......................................OK * Checking package: g++.......................................OK * Checking package: gawk......................................OK * Checking package: gcc.......................................OK * Checking package: genisoimage...............................OK * Checking package: gzip......................................OK * Checking package: htmldoc...................................OK * Checking package: isolinux..................................OK * Checking package: lftp......................................OK * Checking package: libapache2-mod-php7.2.....................OK * Checking package: libc6.....................................OK * Checking package: libcurl4..................................OK * Checking package: liblzma-dev...............................OK * Checking package: m4........................................OK * Checking package: mariadb-client............................OK * Checking package: mariadb-server............................OK * Checking package: net-tools.................................OK * Checking package: nfs-kernel-server.........................OK * Checking package: openssh-server............................OK * Checking package: php7.2....................................OK * Checking package: php7.2-bcmath.............................OK * Checking package: php7.2-cli................................OK * Checking package: php7.2-curl...............................OK * Checking package: php7.2-fpm................................OK * Checking package: php7.2-gd.................................OK * Checking package: php7.2-json...............................OK * Checking package: php7.2-ldap...............................OK * Checking package: php7.2-mbstring...........................OK * Checking package: php7.2-mysql..............................OK * Checking package: php-gettext...............................OK * Checking package: tar.......................................OK * Checking package: tftpd-hpa.................................OK * Checking package: tftp-hpa..................................OK * Checking package: unzip.....................................OK * Checking package: vsftpd....................................OK * Checking package: wget......................................OK * Checking package: xinetd....................................OK * Checking package: zlib1g....................................OK * Configuring services * Setting up fogproject user..................................OK * Locking fogproject as a system account......................OK * Setting up fogproject password..............................OK * Stopping FOGMulticastManager.service Service................OK * Stopping FOGImageReplicator.service Service.................OK * Stopping FOGSnapinReplicator.service Service................OK * Stopping FOGScheduler.service Service.......................OK * Stopping FOGPingHosts.service Service.......................OK * Stopping FOGSnapinHash.service Service......................OK * Stopping FOGImageSize.service Service.......................OK * Is the MySQL password blank? (Y/n) y * Setting up and starting MySQL...............................Done * Backing up user reports.....................................Done * Stopping web service........................................OK * Setting up Apache and PHP files.............................OK * Testing and removing symbolic links if found................OK * Backing up old data.........................................OK * Copying new files to web folder.............................OK * Creating config file........................................OK * Downloading kernel, init and fog-client binaries............Done * Extracting the binaries archive.............................OK * Copying binaries to destination paths.......................OK * Enabling apache and fpm services on boot....................OK * Creating SSL CA.............................................OK * Creating SSL Private Key....................................OK * Creating SSL Certificate....................................OK * Creating auth pub key and cert..............................OK * Resetting SSL Permissions...................................OK * Setting up Apache virtual host (no SSL).....................OK * Starting and checking status of web services................OK * Changing permissions on apache log files....................OK * Backing up database.........................................OK * 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 * Press [Enter] key when database is updated/installed. * Setting up storage..........................................OK * Setting up and starting DHCP Server.........................Skipped * Setting up and starting TFTP and PXE Servers................OK * Setting up and starting VSFTP Server........................OK * Setting up FOG Snapins......................................OK * Setting up UDPCast..........................................OK * Configuring UDPCast.........................................OK * Building UDPCast............................................OK * Installing UDPCast..........................................OK * Installing FOG System Scripts...............................OK * Configuring FOG System Services * Setting permissions on FOGMulticastManager.service script...OK * Enabling FOGMulticastManager.service Service................OK * Setting permissions on FOGImageReplicator.service script....OK * Enabling FOGImageReplicator.service Service.................OK * Setting permissions on FOGSnapinReplicator.service script...OK * Enabling FOGSnapinReplicator.service Service................OK * Setting permissions on FOGScheduler.service script..........OK * Enabling FOGScheduler.service Service.......................OK * Setting permissions on FOGPingHosts.service script..........OK * Enabling FOGPingHosts.service Service.......................OK * Setting permissions on FOGSnapinHash.service script.........OK * Enabling FOGSnapinHash.service Service......................OK * Setting permissions on FOGImageSize.service script..........OK * Enabling FOGImageSize.service Service.......................OK * Setting up FOG Services.....................................OK * Starting FOGMulticastManager.service Service................OK * Starting FOGImageReplicator.service Service.................OK * Starting FOGSnapinReplicator.service Service................OK * Starting FOGScheduler.service Service.......................OK * Starting FOGPingHosts.service Service.......................OK * Starting FOGSnapinHash.service Service......................OK * Starting FOGImageSize.service Service.......................OK * Setting up exports file.....................................OK * Setting up and starting RPCBind.............................OK * Setting up and starting NFS Server..........................OK * Ensuring node username and passwords match..................Done * Setup complete You can now login to the FOG Management Portal using the information listed below. The login information is only if this is the first install. This can be done by opening a web browser and going to: http://xxx.xxx.x.xx/fog/management Default User Information Username: fog Password: password root@FogServerKubuntu:/opt/fogproject-1.5.7/bin# /etc/init.d/mysql restart [....] Restarting mysql (via systemctl): mysql.serviceJob for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details. failed! root@FogServerKubuntu:/opt/fogproject-1.5.7/bin# journalctl -xe Nov 26 01:58:31 FogServerKubuntu systemd[1]: mariadb.service: Start operation timed out. Terminating Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.176:256): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.284:257): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.384:258): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.484:259): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.584:260): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.688:261): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.788:262): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.888:263): apparmor="DENIE Nov 26 01:58:31 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:31 FogServerKubuntu kernel: audit: type=1400 audit(1574733511.988:264): apparmor="DENIE Nov 26 01:58:32 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:32 FogServerKubuntu kernel: audit: type=1400 audit(1574733512.088:265): apparmor="DENIE Nov 26 01:58:32 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:32 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:32 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:33 FogServerKubuntu audit[16858]: AVC apparmor="DENIED" operation="sendmsg" info="Faile Nov 26 01:58:33 FogServerKubuntu systemd[1]: mariadb.service: Failed with result 'timeout'. Nov 26 01:58:33 FogServerKubuntu systemd[1]: Failed to start MariaDB 10.1.43 database server. -- Subject: Unit mariadb.service has failed -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- -- Unit mariadb.service has failed. -- -- The result is RESULT. root@FogServerKubuntu:/opt/fogproject-1.5.7/bin#``` about to go to other snapshot (fresh install) and use git.