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

Image capturing: Updating Database...Failed

Scheduled Pinned Locked Moved Solved
FOG Problems
4
23
2.6k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S
    Sebastian Roth Moderator
    last edited by Dec 1, 2019, 12:09 PM

    @EStegenburgs Do you use CentOS 7 or 8? I will do a test setup and see if I can replicate the issue.

    Used the settings as here: https://wiki.fogproject.org/wiki/index.php/FOG_on_an_Isolated_Network

    Do you also have an isolated network setup or do you just mean you answered the installer questions similar to what we have in the wiki article?

    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

    E 1 Reply Last reply Dec 1, 2019, 12:31 PM Reply Quote 0
    • E
      EStegenburgs @Sebastian Roth
      last edited by Dec 1, 2019, 12:31 PM

      @Sebastian-Roth CentOS 7. I am using the systems as described in the first post.
      Also, yes, I have an isolated network in the VirtualBox environment.

      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator
        last edited by Dec 1, 2019, 3:40 PM

        @EStegenburgs What exactly do you mean by “isolated network in the VirtualBox environment”? Is it set to host only, NAT, NAT network, bridged? While I don’t think any specific VM network setting can cause this issue it’s still be good to know just in case.

        I’ve just done a complete fresh minimal CentOS 7 install. First I setup a VirtualBox VM with bridged network, ran the CentOS 7 installer followed by these commands:

        # yum update
        # sed -i.bak 's/^.*\SELINUX=enforcing\b.*$/SELINUX=permissive/' /etc/selinux/config
        # systemctl stop firewalld
        # systemctl disable firewalld
        # reboot
        

        Now when it’s back up I checked SELinux and firewall:

        # getenforce
        Permissive
        # iptables -L -n -v
        Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
         pkts bytes target     prot opt in     out     source               destination         
        
        Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
         pkts bytes target     prot opt in     out     source               destination         
        
        Chain OUTPUT (policy ACCEPT 0 packets, 0 bytes)
         pkts bytes target     prot opt in     out     source               destination         
        

        Now downloaded and installed FOG:

        curl -L -o 1.5.7.tar.gz https://github.com/FOGproject/fogproject/archive/1.5.7.tar.gz
        tar xzf 1.5.7.tar.gz
        cd fogproject-1.5.7/bin/
        ./installfog.sh
        

        Following all the instructions, updated the schema and then tried to connect via FTP from localhost and from an external machine.

        Listing from FileZilla connect:

        Status:	Connecting to 192.168.24.130:21...
        Status:	Connection established, waiting for welcome message...
        Response:	220 (vsFTPd 3.0.2)
        Command:	USER fogproject
        Response:	331 Please specify the password.
        Command:	PASS ************
        Response:	230 Login successful.
        Command:	SYST
        Response:	215 UNIX Type: L8
        Command:	FEAT
        Response:	211-Features:
        Response:	 EPRT
        Response:	 EPSV
        Response:	 MDTM
        Response:	 PASV
        Response:	 REST STREAM
        Response:	 SIZE
        Response:	 TVFS
        Response:	 UTF8
        Response:	211 End
        Command:	OPTS UTF8 ON
        Response:	200 Always in UTF8 mode.
        Status:	Connected
        Status:	Retrieving directory listing...
        Command:	PWD
        Response:	257 "/home/fogproject"
        Command:	TYPE I
        Response:	200 Switching to Binary mode.
        Command:	PASV
        Response:	227 Entering Passive Mode (192,168,24,130,22,169).
        Command:	LIST
        Response:	150 Here comes the directory listing.
        Response:	226 Directory send OK.
        Status:	Calculating timezone offset of server...
        Command:	MDTM warnfogaccount.sh
        Response:	213 20191201151442
        Status:	Timezone offsets: Server: 0 seconds. Local: 3600 seconds. Difference: 3600 seconds.
        Status:	Directory listing successful
        

        localhost command line FTP:

        Trying ::1...
        ftp: connect to address ::1Connection refused
        Trying 127.0.0.1...
        Connected to localhost (127.0.0.1).
        220 (vsFTPd 3.0.2)
        Name (localhost:root): fogproject
        331 Please specify the password.
        Password:
        230 Login successful.
        Remote system type is UNIX.
        Using binary mode to transfer files.
        ftp> ls
        227 Entering Passive Mode (127,0,0,1,148,218).
        150 Here comes the directory listing.
        -rwxr-xr-x    1 0        0             681 Dec 01 15:14 warnfogaccount.sh
        226 Directory send OK.
        ftp> 221 Goodbye.
        

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        E 1 Reply Last reply Dec 1, 2019, 6:36 PM Reply Quote 0
        • E
          EStegenburgs @Sebastian Roth
          last edited by Dec 1, 2019, 6:36 PM

          @Sebastian-Roth said in Image capturing: Updating Database...Failed:

          What exactly do you mean by “isolated network in the VirtualBox environment”? Is it set to host only, NAT, NAT network, bridged?

          The first network adapter is NAT (enp0s3), and the second one is VM internal (enp0s8).

          E 1 Reply Last reply Dec 1, 2019, 6:46 PM Reply Quote 0
          • E
            EStegenburgs @EStegenburgs
            last edited by Dec 1, 2019, 6:46 PM

            When I meant “isolated”, FOG is set up to use the internal network through the second adapter enp0s8.

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Sebastian Roth Dec 1, 2019, 4:14 PM Dec 1, 2019, 10:13 PM

              @EStegenburgs said:

              The first network adapter is NAT (enp0s3), and the second one is VM internal (enp0s8).

              So when the installer asks you about which network adapter you want to use, what did you say? I have to admit that my setup is a little different and that I have not tested it this way yet. But I remember there is an issue in the installer script with network adapter enumeration. Possibly this is causing the issue for you in the end. On the other hand I do wonder that PXE boot seems to work find then.

              Do you still get the Error: Failed to retrieve directory listing when trying to connect via FTP?

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              E 2 Replies Last reply Dec 2, 2019, 8:48 AM Reply Quote 1
              • E
                EStegenburgs @Sebastian Roth
                last edited by Dec 2, 2019, 8:48 AM

                @Sebastian-Roth What FOG installation settings did you use? It looks like you are not using FOG DHCP, in such case you would need to configure an external server for PXE boot, right? Also, did you do any vsFTPd configuration? ftp localhost on CentOS worked but I am struggling with the remote FileZilla connection.

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Dec 2, 2019, 4:12 PM

                  @EStegenburgs I do use the FOG DHCP and there should be no need to manually adjust vsftpd.conf.

                  All installer questions I answered as the are by default except for DHCP where no is default but I said yes.

                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                  1 Reply Last reply Reply Quote 0
                  • Greg PlamondonG
                    Greg Plamondon Testers
                    last edited by Dec 5, 2019, 1:25 PM

                    I had a similar problem but I found that it was my max connections.

                    mysql -e"show status like '%used_connections%'"
                    +----------------------+-------+
                    | Variable_name        | Value |
                    +----------------------+-------+
                    | Max_used_connections | 224   |
                    +----------------------+-------+
                    
                    
                    mysql -e"SHOW VARIABLES LIKE '%max_connections%'"
                    +-----------------------+-------+
                    | Variable_name         | Value |
                    +-----------------------+-------+
                    | extra_max_connections | 1     |
                    | max_connections       | 1000  |
                    +-----------------------+-------+
                    

                    Mariadb max_connections default Value: 151
                    I increased mine to 1000 and my DB connection issues seem to have gone away.

                    1 Reply Last reply Reply Quote 0
                    • E
                      EStegenburgs @Sebastian Roth
                      last edited by Dec 19, 2019, 10:47 AM

                      @Sebastian-Roth So, in the end, I have entirely switched to a bridged network solution, and everything is working fine now. It seems that the problem was, in fact, as you mentioned, about the issue in the installer script with network adapter enumeration. But that also means it is some type of bug - all captures of an image were successful, only failed at the very end trying to update the database.

                      The difference that I noticed between bridged and internal NAT configuration is that in the latter one, the FOG installer script at the very beginning complains that net-tools is not installed. When it asked about the network adapters, it couldn’t get an IP at first because it tried to use a network adapter enp0s3 enp0s8 (NAT adapter for internet connection and internal NAT adapter), at which point I had to specify to use enp0s8 adapter manually.

                      1 Reply Last reply Reply Quote 0
                      • 1
                      • 2
                      • 2 / 2
                      • First post
                        Last post

                      189

                      Online

                      12.1k

                      Users

                      17.3k

                      Topics

                      155.3k

                      Posts
                      Copyright © 2012-2024 FOG Project