@george1421
Hello george,
I did not succeed in restoring the database, I do a complete reinstallation of the server.
Thank you for everything

@george1421
thank you for your answer george, I go through google translate that’s why I take time to answer
I will try to rebuild the database as you told me, tomorrow because suir I have to go to bed, I will work early tomorrow
I’ll keep you informed tomorrow
thank you

@george1421
I plugged the disk into usb and I had 0 bytes left. I then deleted 3 disk images and then I plugged the disk back into the computer, it started (no more problem with maria DB).
I then have in firefox: Database connection unavailable

@george1421
Here is the result
I removed 3 disk images to restart the PC

@george1421

Voici le résulltat:

Sys. de fichiers Taille Utilisé Dispo Uti% Monté sur
udev               7,8G       0  7,8G   0% /dev
tmpfs              1,6G    1,9M  1,6G   1% /run
/dev/sda2          1,9T    1,7T   53G  98% /
tmpfs              7,8G     57M  7,8G   1% /dev/shm
tmpfs              5,0M    4,0K  5,0M   1% /run/lock
tmpfs              7,8G       0  7,8G   0% /sys/fs/cgroup
/dev/loop0         2,5M    2,5M     0 100% /snap/gnome-calculator/826
/dev/loop1         1,0M    1,0M     0 100% /snap/gnome-logs/100
/dev/loop2          98M     98M     0 100% /snap/core/10185
/dev/loop3         146M    146M     0 100% /snap/opera/99
/dev/loop4         163M    163M     0 100% /snap/gnome-3-28-1804/145
/dev/loop6          15M     15M     0 100% /snap/gnome-characters/399
/dev/loop5         3,8M    3,8M     0 100% /snap/gnome-system-monitor/127
/dev/loop8         4,3M    4,3M     0 100% /snap/gnome-calculator/544
/dev/loop7         146M    146M     0 100% /snap/opera/97
/dev/loop10         45M     45M     0 100% /snap/gtk-common-themes/1440
/dev/loop9          55M     55M     0 100% /snap/core18/1668
/dev/loop11        161M    161M     0 100% /snap/gnome-3-28-1804/116
/dev/loop12        1,0M    1,0M     0 100% /snap/gnome-logs/81
/dev/loop14         56M     56M     0 100% /snap/core18/1932
/dev/loop13        218M    218M     0 100% /snap/gnome-3-34-1804/60
/dev/loop15        2,3M    2,3M     0 100% /snap/gnome-system-monitor/148
/dev/loop16         33M     33M     0 100% /snap/chromium-ffmpeg/17
/dev/loop18         63M     63M     0 100% /snap/gtk-common-themes/1506
/dev/loop17         90M     90M     0 100% /snap/core/8268
/dev/loop19        384K    384K     0 100% /snap/gnome-characters/570
/dev/sda1          511M    6,1M  505M   2% /boot/efi
tmpfs              1,6G     40K  1,6G   1% /run/user/1000

@george1421 @Sebastian-Roth
apologies, as I’m not the one using fog I didn’t think about looking at the disk space.
I was able to arrive on the graphical interface, but on firefox I cannot connect: Database connection unavailable
I think the database did not like :
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: The InnoDB memory heap is disabled
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Using Linux native AIO
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Using SSE crc32 instructions
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Completed initialization of buffer pool
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Highest supported file format is Barracuda.
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: 128 rollback segment(s) are active.
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Waiting for purge to start
2021-03-01 19:01:48 140500859161728 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 1618255
2021-03-01 19:01:48 140500187215616 [Note] InnoDB: Dumping buffer pool(s) not yet started
2021-03-01 19:01:48 140500859161728 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-03-01 19:01:48 140500859161728 [Note] Recovering after a crash using tc.log
2021-03-01 19:01:48 140500859161728 [ERROR] Can’t init tc log
2021-03-01 19:01:48 140500859161728 [ERROR] Aborting

@sebastian-roth
I installed the server last year in January or February , the FOG station has never been updated.

@sebastian-roth
here are the screenshots

@sebastian-roth
Thank you very much for your answer.
The old system does not start anymore, when loading it becomes very slow and crashes at the level of maria DB

I think the SSD is broken
I will try to reinstall fog identically (ubuntu 18.04 and fog 1.5.8)
thank you for your reply.

Hello
I had a fog 1.5.8 server on ubuntu 18.04, but the system crashed, how can I restore the images and hosts to the new fog 1.5.9 (ubuntu 20.04) system?
I copied the / opt / fog and / images directories and executed chmod 777 –vR / images but the images and hosts do not appear on the fog interface.
thank you for your answers

@george1421
I thank you, George for you help, for me it’s ok to solve this topic.
cordially

@Sebastian-Roth
hello Sebastian thank you for you answer.
I’ve 2 network on this Computer, the first ( eth0) for fog server, and the second (eth1) for internet connection.
I changed the configuration line in dhcpd.conf with

range dynamic-bootp 10.0.0.10 10.0.255.254;
but the installation was aborted
when i launch ./installfog.sh (fog 1.4.0) i can’t change parameters since i install fog 1.2.0:

root@shuttlefog:~/fogproject/bin# ./installfog.sh
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.4.0 Installer/Updater

• Found FOG Settings from previous install at: /opt/fog/.fogsettings

• Performing upgrade using these settings

Starting Debian based Installation

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

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

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

** Notice ** FOG is difficult to setup securely

SELinux and IPTables are usually asked to be disabled

There have been strides in adding capabilities

The recommendations would now be more appropriate

to set SELinux to permissive and to disable firewall for now.

You can find some methods to enable SELinux and maintain firewall

settings and ports. If you feel comfortable doing so please do

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

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: Debian GNU/Linux

• Server IP Address: 10.0.2.15

• Server Subnet Mask:

• Interface: eth0

• Installation Type: Normal Server

• Internationalization: 0

• Image Storage Location: /images

• Using FOG DHCP: Yes

• DHCP router Address: 10.0.2.2

• Are you sure you wish to continue (Y/N) y

• Installation Started

• Installing required packages, if this fails
  | make sure you have an active internet connection.

• Adding needed repository…OK

• Preparing Package Manager…OK

• Packages to be installed:

  apache2 bc build-essential cpp curl g++ gawk gcc gzip htmldoc isc-dhcp-server lftp libapache2-mod-php5 libc6 libcurl3 m4 mysql-client mysql-server net-tools nfs-kernel-server openssh-server php5 php5-bcmath php5-cli php5-curl php5-fpm php5-gd php5-json php5-mcrypt php5-mysql php5-mysqlnd php-gettext sysv-rc-conf tar tftpd-hpa tftp-hpa unzip vsftpd wget xinetd zlib1g

• Skipping package: apache2…(Already Installed)

• 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: gzip…(Already Installed)

• Skipping package: htmldoc…(Already Installed)

• Skipping package: isc-dhcp-server…(Already Installed)

• Skipping package: lftp…(Already Installed)

• Skipping package: libapache2-mod-php5…(Already Installed)

• Skipping package: libc6…(Already Installed)

• Skipping package: libcurl3…(Already Installed)

• Skipping package: m4…(Already Installed)

• Skipping package: mysql-client…(Already Installed)

• Skipping package: mysql-server…(Already Installed)

• Skipping package: net-tools…(Already Installed)

• Skipping package: nfs-kernel-server…(Already Installed)

• Skipping package: openssh-server…(Already Installed)

• Skipping package: php5…(Already Installed)

• Skipping package: php5-bcmath…(Does not exist)

• Skipping package: php5-cli…(Already Installed)

• Skipping package: php5-curl…(Already Installed)

• Skipping package: php5-fpm…(Already Installed)

• Skipping package: php5-gd…(Already Installed)

• Skipping package: php5-json…(Already Installed)

• Skipping package: php5-mcrypt…(Already Installed)

• Skipping package: php5-mysqlnd…(Already Installed)

• Skipping package: php5-mysqlnd…(Already Installed)

• Skipping package: php-gettext…(Already Installed)

• Skipping package: sysv-rc-conf…(Already Installed)

• 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: gzip…OK

• Checking package: htmldoc…OK

• Checking package: isc-dhcp-server…OK

• Checking package: lftp…OK

• Checking package: libapache2-mod-php5…OK

• Checking package: libc6…OK

• Checking package: libcurl3…OK

• Checking package: m4…OK

• Checking package: mysql-client…OK

• Checking package: mysql-server…OK

• Checking package: net-tools…OK

• Checking package: nfs-kernel-server…OK

• Checking package: openssh-server…OK

• Checking package: php5…OK

• Checking package: php5-cli…OK

• Checking package: php5-curl…OK

• Checking package: php5-fpm…OK

• Checking package: php5-gd…OK

• Checking package: php5-json…OK

• Checking package: php5-mcrypt…OK

• Checking package: php5-mysqlnd…OK

• Checking package: php-gettext…OK

• Checking package: sysv-rc-conf…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 fog user…Already setup

• Setting up fog 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

• Setting up and starting MySQL…OK

• Backing up user reports…Done

• Stopping web service…OK

• Removing vhost file…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

• Unzipping the binaries…Done

• Copying binaries where needed…Done

• 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 SSL FOG Server…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://10.0.2.15/fog/management

• Press [Enter] key when database is updated/installed.

• Setting up storage…OK

• Setting up and starting DHCP Server…Failed!
  root@shuttlefog:~/fogproject/bin#

@george1421
Hello George,
I want to try to remain simple in my explanation:
I had taken the configuration in a tutorial:
The fog server has 10.0.2.15, subnet mask : 255.0.0.0 gateway 10.0.2.2 DNS address 10.0.50.2
the DHCP server 10.0.2.2

I have nothing else on the network
I do not know if this is the best configuration
Here ip addr show:

lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default 
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether 80:ee:73:96:8e:ec brd ff:ff:ff:ff:ff:ff
    inet 10.0.2.15/8 brd 10.255.255.255 scope global eth0
       valid_lft forever preferred_lft forever
    inet6 fe80::82ee:73ff:fe96:8eec/64 scope link 
       valid_lft forever preferred_lft forever
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether 80:ee:73:96:8e:ed brd ff:ff:ff:ff:ff:ff
    inet 192.168.0.33/24 brd 192.168.0.255 scope global dynamic eth1
       valid_lft 85033sec preferred_lft 85033sec
    inet6 fe80::82ee:73ff:fe96:8eed/64 scope link 
       valid_lft forever preferred_lft forever

@george1421
I have took 10.x.x.x because have see tutorial with it, i don’t need 2 millions adresses, the fog is only on the dhcp server.
I try to install with 192.168.0.x range

Sorry,
I have to go to work, I leave you today
Thank you

@george1421
I haven’t the folder tftpdboot when i do the first install of 1.4

@george1421
Here is dhcp.conf for fog install 1.4:

# This file was created by FOG
#Definition of PXE-specific options
# Code 1: Multicast IP Address of bootfile
# Code 2: UDP Port that client should monitor for MTFTP Responses
# Code 3: UDP Port that MTFTP servers are using to listen for MTFTP requests
# Code 4: Number of seconds a client must listen for activity before trying
#         to start a new MTFTP transfer
# Code 5: Number of seconds a client must listen before trying to restart
#         a MTFTP transfer
option space PXE;
option PXE.mtftp-ip code 1 = ip-address;
option PXE.mtftp-cport code 2 = unsigned integer 16;
option PXE.mtftp-sport code 3 = unsigned integer 16;
option PXE.mtftp-tmout code 4 = unsigned integer 8;
option PXE.mtftp-delay code 5 = unsigned integer 8;
option arch code 93 = unsigned integer 16;
use-host-decl-names on;
ddns-update-style interim;
ignore client-updates;
# Specify subnet of ether device you do NOT want service.
# For systems with two or more ethernet devices.
# subnet 136.165.0.0 netmask 255.255.0.0 {}
subnet 10.0.0.0 netmask 255.0.0.0{
    option subnet-mask 255.0.0.0;
    range dynamic-bootp 10.0.0.10 10.255.255.254;
    default-lease-time 21600;
    max-lease-time 43200;
    option routers 10.0.2.2;
    option domain-name-servers 10.0.50.5;
    next-server 10.0.2.15;
    class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }
    class "SURFACE-PRO-4" {
        match if substring(option vendor-class-identifier, 0, 32) = "PXEClient:Arch:00007:UNDI:003016";
        filename "ipxe7156.efi";
    }
    class "Apple-Intel-Netboot" {
        match if substring(option vendor-class-identifier, 0, 14) = "AAPLBSDPC/i386";
        option dhcp-parameter-request-list 1,3,17,43,60;
        if (option dhcp-message-type = 8) {
            option vendor-class-identifier "AAPLBSDPC";
            if (substring(option vendor-encapsulated-options, 0, 3) = 01:01:01) {
                # BSDP List
                option vendor-encapsulated-options 01:01:01:04:02:80:00:07:04:81:00:05:2a:09:0D:81:00:05:2a:08:69:50:58:45:2d:46:4f:47;
                filename "ipxe.efi";
            }
        }
    }
}

@george1421
Thank you for your answer
The Fog server have a direct access to internet
Here is the errors log for fog 1.4

Executing /usr/sbin/update-rc.d isc-dhcp-server defaults
Executing /usr/sbin/update-rc.d isc-dhcp-server enable
Job for isc-dhcp-server.service failed. See ‘systemctl status isc-dhcp-server.service’ and ‘journalctl -xn’ for details.
● isc-dhcp-server.service - LSB: DHCP server
Loaded: loaded (/etc/init.d/isc-dhcp-server)
Active: failed (Result: exit-code) since mar. 2017-05-23 10:51:23 CEST; 2s ago
Process: 28947 ExecStart=/etc/init.d/isc-dhcp-server start (code=exited, status=1/FAILURE)

mai 23 10:51:21 shuttlefog isc-dhcp-server[28947]: Copyright 2004-2014 Internet Systems Consortium.
mai 23 10:51:21 shuttlefog isc-dhcp-server[28947]: All rights reserved.
mai 23 10:51:21 shuttlefog isc-dhcp-server[28947]: For info, please visit https://www.isc.org/software/dhcp/
mai 23 10:51:21 shuttlefog isc-dhcp-server[28947]: Config file: /etc/dhcp/dhcpd.conf
mai 23 10:51:21 shuttlefog isc-dhcp-server[28947]: Database file: /var/lib/dhcp/dhcpd.leases
mai 23 10:51:21 shuttlefog isc-dhcp-server[28947]: PID file: /var/run/dhcpd.pid
mai 23 10:51:23 shuttlefog isc-dhcp-server[28947]: Segmentation fault
mai 23 10:51:23 shuttlefog systemd[1]: isc-dhcp-server.service: control process exited, code=exited status=1
mai 23 10:51:23 shuttlefog systemd[1]: Failed to start LSB: DHCP server.
mai 23 10:51:23 shuttlefog systemd[1]: Unit isc-dhcp-server.service entered failed state.

@Quazz
Thank you for your answer, and sorry for my english.
I have first install fog 1.4 on this computer with the subnet mask 255.0.0.0
The install was aborted when it want to configure and run dhcp.
So I install fog 1.2.0 , and The installation completed successfully.
But for the topic, I have reinstall the fog 1.4.0 and the subnet mask missing.
but But the finality is the same, the dhcp does not work.
and the file /opt/fog/.fogsettings appears only when is the fog 1.2 install:

Created by the FOG Installer

Version: 1.2.0

Install time: mer. 24 mai 2017 01:27:37 CEST

ipaddress=“10.0.2.15”;
interface=“eth0”;
routeraddress=" option routers 10.0.2.2;“;
plainrouter=“10.0.2.2”;
dnsaddress=” option domain-name-servers 10.0.50.5; “;
dnsbootimage=“10.0.50.5”;
password=”“;
osid=“2”;
osname=“Debian”;
dodhcp=“y”;
bldhcp=“1”;
installtype=“N”;
snmysqluser=”"
snmysqlpass=“”;
snmysqlhost=“”;
installlang=“0”;
donate=“0”;
fogupdateloaded=“1”

Server

• FOG Version: 1.3.0 /1.4.0
• OS: Debian 8.7 / Ubuntu 16.04

Client

• Service Version:
• OS:

Description

Hello,
Since version 1.3, during the installation, the configuration of the DHCP service is not done:
Setting up and starting DHCP Server…Failed!
I must reinstall fog 1.2.0 with the same parameters for run Fog :

• Here are the settings FOG will use:
• Base Linux: Debian
• Detected Linux Distribution: Debian GNU/Linux
• Server IP Address: 10.0.2.15
• Server Subnet Mask:
• Interface: eth0
• Installation Type: Normal Server
• Internationalization: 0
• Image Storage Location: /images
• Using FOG DHCP: Yes
• DHCP router Address: 10.0.2.2
  (When I install 1.3 or 1.4 version the folder /TFTPBOOT was not here. )
  Thank you for your help
  Patrice