Reattempting to update database...Failed

george1421

@tywyn What version of ubuntu are you using? It appears that third party library is no longer available.

Tywyn

@george1421
~$ cat /etc/issue
Ubuntu 16.04.5 LTS \n \l

george1421

@tywyn This appears to be a ubuntu issue. A quick google-fu shows up quite a few posts with the same error.

I’m a rhel not debian guy so I can only post what I found.

Try to add these repositories your self by hand with:

sudo add-apt-repository ppa:ondrej/php
sudo add-apt-repository ppa:ondrej/apache2
sudo apt-get update
sudo apt-get upgrade

Then rerun the installer.

Tywyn

@george1421

Unfortunately does not work either:

# add-apt-repository ppa:ondrej/php
Cannot add PPA: 'ppa:~ondrej/ubuntu/php'.
ERROR: '~ondrej' user or team does not exist.

Sebastian Roth

@Tywyn Could be a proxy or locales issue:
https://askubuntu.com/questions/724224/cant-add-ppa-on-ubuntu-15-10-user-or-team-does-not-exist
https://askubuntu.com/questions/863825/unable-to-add-ppa-in-my-newly-installed-ubuntu-16-04-lts/863858

Tywyn

@Sebastian-Roth , @george1421

It was a proxy-issue. I have had http_proxy environment set, but I did not have https_proxy.
Fixing that I ran into a timeout concerning a connection to a key-server.

gpg: requesting key E5267A6C from hkp server keyserver.ubuntu.com
Error: retrieving gpg key timed out.

So I decided to add another NIC to bypass the proxy and connect directly to the internet an so the install went through.
There still remain 3 questions concerning the update process:

Installscript says:

   # It is not recommended that you install this on a production system #
   #        as this script modifies many of your system settings.       #

when I have a production system running fog, which method shall I use then, if not running install-script?

Accessing the url provided I cannot see, where I can install/update my database schema

 * You still need to install/update your database schema.
 * This can be done by opening a web browser and going to:

   http://10.10.11.63/fog/management

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

Having done an update without changing anything in the config, but adding a second NIC with a new default gateway: Do I have to bother about the error-message below?

* Setting up and starting DHCP Server......................... !!! No router address found !!!
!!! No dns address found !!!
OK

Sebastian Roth

@Tywyn said:

Installscript says:

What this means is, be careful when you install FOG on a server that has any other services running in production. For example if you have a web server running on this system, running a FOG installation can break the other website’s apache configuration.

Accessing the url provided I cannot see, where I can install/update my database schema

After the upgrade which version do you see in the blue cloud on the web UI? Just wondering. From version to version there might be DB schema updates but I am not sure if there were any from 1.5.2 to 1.5.4, possibly not.

Having done an update without changing anything in the config, but adding a second NIC with a new default gateway: Do I have to bother about the error-message below?

Please post your FOG DHCP config here so we can have a look (/etc/dhcp/dhcpd.conf).

Tywyn

@Sebastian-Roth
On the dashboard I can see in the lower right corner: 1.5.4

And here is the dhcpd.conf:

# DHCP Server Configuration file\n#see /usr/share/doc/dhcp*/dhcpd.conf.sample
# 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.10.11.0 netmask 255.255.255.0{
    option subnet-mask 255.255.255.0;
    range dynamic-bootp 10.10.11.10 10.10.11.254;
    default-lease-time 21600;
    max-lease-time 43200;
    #option routers 0.0.0.0
    #option routers 0.0.0.0
    next-server 10.10.11.63;
    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 "ipxe.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";
            }
        }
    }
}

@all: Thanx for your help

Quazz

@tywyn Please fill in the variables

routeraddress='yourrouterip'
plainrouter='yourrouterip'
dnsaddress='yourdnsserver (possibly router)'
dnsbootimage='yourdnsserver (possibly router)'

in /opt/fog/.fogsettings

Assuming you want FOG to handle DHCP of course…

If not set

dodhcp='N'
bldhcp='0'

in /opt/fog/.fogsettings

Tywyn

@quazz said in Reattempting to update database...Failed:

dnsaddress=‘yourdnsserver (possibly router)’
dnsbootimage=‘yourdnsserver (possibly router)’

Hi,

thank you for your hint. 2 remarks:

I am struggeling with the documentation here: https://wiki.fogproject.org/wiki/index.php/.fogsettings#dnsaddress
It says that the parameter dnsaddress is used for dhcp setup. What does that actually mean? Is this value put in /etc/dhcp/dhcpd.conf as option domain-name-servers ipadress;

Same documentation says, that dnsbootimage is no longer used?

Quazz

@tywyn That’s correct on both accounts. It doesn’t hurt to fill it in, but if you’re on 1.5 you can ignore dnsbootimage indeed.

The DHCP server needs to be able to point clients to a local DNS server so that they know where to look.

Tywyn

Thanx.
The thread can be marked als solved. Can I do this somewhere or can just a board admin do that?

Reattempting to update database...Failed

207

12.1k

17.3k

155.3k