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

Updating database ... freezed screen after upload task

Scheduled Pinned Locked Moved Solved
Bug Reports
4
28
9.9k
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.
  • H
    hernani
    last edited by May 27, 2016, 7:46 AM

    As requested by the administrator, here is a new topic with my specific problem.

    On SVN 7695, there was no problem. It was possible to upload a new image on the server.

    After migrating (today is SVN 7863), but even after the first update after 7695, uploading is impossible.

    “Updating database… failed
    Reattempting to update database”
    –> The client reboot and the task begins again (because still active on the server).

    Linux version on the server: 14.04 LTS
    Seems the Mysql database is OK: i can connect through command line, and navigate through it.

    thanks for your help.

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by May 27, 2016, 9:54 AM

      Anything in apache error logs?

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      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

      H 1 Reply Last reply May 27, 2016, 11:43 AM Reply Quote 0
      • H
        hernani
        last edited by May 27, 2016, 11:34 AM

        This post is deleted!
        1 Reply Last reply Reply Quote 0
        • H
          hernani @Tom Elliott
          last edited by May 27, 2016, 11:43 AM

          @Tom-Elliott
          I see that:
          HP Strict Standards: Only variables should be passed by reference in /var/www/html/fog/lib/pages/schemaupdaterpage.class.php on line 48, referer: http://SERVERIP/fog/management/?node=schema
          [Thu May 26 14:47:25.380926 2016] [:error] [pid 44662] [client 194.254.109.161:56690] PHP Warning: array_walk() expects parameter 1 to be array, boolean given in /var/www/html/fog/lib/fog/fogpage.class.php on line 845
          [Thu May 26 14:47:25.383390 2016] [:error] [pid 44662] [client 194.254.109.161:56690] PHP Fatal error: Call to a member function lastInsertId() on null in /var/www/html/fog/lib/db/pdodb.class.php on line 124
          [Thu May 26 15:52:31.035728 2016] [:error] [pid 6920] [client 194.254.109.161:52695] PHP Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 169
          [Thu May 26 15:52:31.035776 2016] [:error] [pid 6920] [client 194.254.109.161:52695] PHP Warning: PDOStatement::execute(): Error reading result set’s header in /var/www/html/fog/lib/db/pdodb.class.php on line 169
          [Thu May 26 15:52:31.067489 2016] [:error] [pid 6920] [client 194.254.109.161:52695] PHP Warning: array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 262
          [Thu May 26 15:52:31.067515 2016] [:error] [pid 6920] [client 194.254.109.161:52695] PHP Warning: array_walk() expects parameter 1 to be array, boolean given in /var/www/html/fog/lib/fog/fogpage.class.php on line 845
          [Thu May 26 15:52:31.186624 2016] [:error] [pid 3663] [client 194.254.109.161:2542] PHP Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 169
          [Thu May 26 15:52:31.186653 2016] [:error] [pid 3663] [client 194.254.109.161:2542] PHP Warning: PDOStatement::execute(): Error reading result set’s header in /var/www/html/fog/lib/db/pdodb.class.php on line 169

          1 Reply Last reply Reply Quote 0
          • T
            Tom Elliott
            last edited by May 27, 2016, 12:52 PM

            Can you please update?

            Also, mind checking your disk space on the system?

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

            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

            H 1 Reply Last reply May 30, 2016, 8:09 AM Reply Quote 0
            • H
              hernani
              last edited by May 27, 2016, 1:05 PM

              I’m doing the update now.
              For system space, everything is good
              Ubuntu drive: 300Gb (280 Gb Free)
              storage: 4Tb (-10% used)

              😉

              1 Reply Last reply Reply Quote 0
              • H
                hernani @Tom Elliott
                last edited by May 30, 2016, 8:09 AM

                @Tom-Elliott
                Same thing after the update to 7907.

                T 1 Reply Last reply May 30, 2016, 1:36 PM Reply Quote 0
                • T
                  Tom Elliott @hernani
                  last edited by May 30, 2016, 1:36 PM

                  @hernani how did you update? We are beyond 7907 even.

                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                  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

                  H 1 Reply Last reply May 30, 2016, 2:38 PM Reply Quote 0
                  • H
                    hernani @Tom Elliott
                    last edited by hernani May 30, 2016, 8:40 AM May 30, 2016, 2:38 PM

                    @Tom-Elliott
                    Last friday the most recent update was 7907.
                    today i didn’t update but until now, i follow the “svn up” method on the wiki + relaunching the install
                    I’ll do it tomorrow morning (France).
                    Was it a problem with mySql ?
                    thx

                    T 1 Reply Last reply May 30, 2016, 3:24 PM Reply Quote 0
                    • T
                      Tom Elliott @hernani
                      last edited by May 30, 2016, 3:24 PM

                      @hernani I don’t know what the problem is/was all I can think it was from the node losing contact. The requests had a ridiculous timeout value which might cause the issue you were seeing. I’ve lowered the timeout to a slightly lower value, though it is still pretty long. It should, hopefully, give a better experience I hope.

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      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

                      H 1 Reply Last reply Jun 1, 2016, 10:23 AM Reply Quote 0
                      • H
                        hernani @Tom Elliott
                        last edited by Tom Elliott Jun 1, 2016, 6:15 AM Jun 1, 2016, 10:23 AM

                        @Tom-Elliott I’ve just updated to 7935. Same bug at the end of an upload task.
                        My question is: what is this operation of “updating database”? Which user is used to to this operation?
                        thx

                        T 1 Reply Last reply Jun 1, 2016, 10:28 AM Reply Quote 0
                        • T
                          Tom Elliott @hernani
                          last edited by Jun 1, 2016, 10:28 AM

                          @hernani The database user is used.

                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                          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

                          H 1 Reply Last reply Jun 1, 2016, 11:45 AM Reply Quote 0
                          • H
                            hernani @Tom Elliott
                            last edited by Jun 1, 2016, 11:45 AM

                            @Tom-Elliott the ‘root’ created during the install of MySql or ‘fog’?

                            T 1 Reply Last reply Jun 1, 2016, 11:46 AM Reply Quote 0
                            • T
                              Tom Elliott @hernani
                              last edited by Jun 1, 2016, 11:46 AM

                              @hernani Root is typically used.

                              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                              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

                              H 1 Reply Last reply Jun 1, 2016, 11:51 AM Reply Quote 0
                              • H
                                hernani @Tom Elliott
                                last edited by Jun 1, 2016, 11:51 AM

                                @Tom-Elliott ok so it’s correct because i can explore the mysql database with a terminal using root and the password is ok in ./fogsettings.

                                T 1 Reply Last reply Jun 1, 2016, 11:53 AM Reply Quote 0
                                • T
                                  Tom Elliott @hernani
                                  last edited by Jun 1, 2016, 11:53 AM

                                  @hernani I’m thinking this is more a “FTP Login” issue as opposed to a database issue. The Database will only be updated after the FTP Upload happens.

                                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                  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

                                  H 1 Reply Last reply Jun 1, 2016, 11:57 AM Reply Quote 0
                                  • H
                                    hernani @Tom Elliott
                                    last edited by Jun 1, 2016, 11:57 AM

                                    @Tom-Elliott i noticed that the image is upload in /tmp/MacAdress but is not moved to the final destination, so you’re probably right when you say it’s FTP issue.
                                    For doing FTP, same question: which account is used ‘fog’, ‘fogstorage’ (because we’ve got one node for our images)?

                                    This error is here now:
                                    [Wed Jun 01 11:27:04.814918 2016] [:error] [pid 50751] [client 172.16.40.27:61269] PHP Warning: in_array() expects parameter 2 to be array, null given in /var/www/html/fog/lib/client/fogclient.class.php on line 19
                                    [Wed Jun 01 11:27:04.819914 2016] [:error] [pid 50751] [client 172.16.40.27:61269] PHP Warning: in_array() expects parameter 2 to be array, null given in /var/www/html/fog/lib/client/fogclient.class.php on line 19

                                    T 1 Reply Last reply Jun 1, 2016, 12:19 PM Reply Quote 0
                                    • T
                                      Tom Elliott @hernani
                                      last edited by Jun 1, 2016, 12:19 PM

                                      @hernani I’ve fixed the in_array error.

                                      That said, we have a wiki article about Troubleshooting FTP. I think it’s actually called: Troubleshoot FTP.

                                      https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP

                                      The user is the linux user named fog and can be found in Storage Management->List All Nodes->Your relevant Node->Management Username and Management Password.

                                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                      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

                                      H 1 Reply Last reply Jun 1, 2016, 12:23 PM Reply Quote 0
                                      • H
                                        hernani @Tom Elliott
                                        last edited by Jun 1, 2016, 12:23 PM

                                        @Tom-Elliott
                                        Yes, i was reading this article in fact and isa comparing all this. The password is the same everywhere BUT in the config file of fog, i replaced the old password when i moved from 1.2 to SVN and at the end of password i put " instead of ’ for the password value… maybe it’s my fault… 😞

                                        T 1 Reply Last reply Jun 1, 2016, 12:25 PM Reply Quote 0
                                        • T
                                          Tom Elliott @hernani
                                          last edited by Jun 1, 2016, 12:25 PM

                                          @hernani Change the .fogsettings file password thing to match what everything else has it stored as. Then rerun the installer. THe installer, now, reset’s the FOG User’s password every time the installer is run and it uses the value in the .fogsettings file to make sure it is maintained what the installer expects.

                                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                          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

                                          H 1 Reply Last reply Jun 2, 2016, 11:04 AM Reply Quote 0
                                          • 1
                                          • 2
                                          • 1 / 2
                                          1 / 2
                                          • First post
                                            2/28
                                            Last post

                                          154

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project