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

Database issue on latest trunk

Scheduled Pinned Locked Moved Solved
FOG Problems
5
25
8.7k
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.
  • T
    Tom Elliott @Bob Henderson
    last edited by Jun 16, 2016, 12:52 PM

    @Bob-Henderson Is this a storage node, or main server?

    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

    B 1 Reply Last reply Jun 16, 2016, 12:54 PM Reply Quote 0
    • B
      Bob Henderson @Tom Elliott
      last edited by Jun 16, 2016, 12:54 PM

      @Tom-Elliott

      Main server, stand alone. Was working fine until I did the update.

      Adding in the host and username resolved the issue instantly.

      T 1 Reply Last reply Jun 16, 2016, 12:54 PM Reply Quote 0
      • T
        Tom Elliott @Bob Henderson
        last edited by Jun 16, 2016, 12:54 PM

        @Bob-Henderson and what displays in the /opt/fog/.fogsettings file for the snmysqlhost and snmysqluser information?

        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

        B 1 Reply Last reply Jun 16, 2016, 12:56 PM Reply Quote 1
        • B
          Bob Henderson @plegrand
          last edited by Jun 16, 2016, 12:54 PM

          @plegrand

          Yep, nothing is over 35% used.

          1 Reply Last reply Reply Quote 0
          • B
            Bob Henderson @Tom Elliott
            last edited by Jun 16, 2016, 12:56 PM

            @Tom-Elliott

            Well, that’s odd, those are all blank. No user, pass, host.

            It has all my other settings still, like IP and password and such.

            T P 2 Replies Last reply Jun 16, 2016, 12:57 PM Reply Quote 0
            • T
              Tom Elliott @Bob Henderson
              last edited by Jun 16, 2016, 12:57 PM

              @Bob-Henderson I’m asking to help you.

              Please enter your information. ON Main server, the snmysqlhost should be '127.0.0.1'
              snmysqluser should be 'root'
              snmysqlpass (unless you set a password) should be ''

              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

              B 1 Reply Last reply Jun 16, 2016, 12:59 PM Reply Quote 1
              • P
                plegrand @Bob Henderson
                last edited by plegrand Jun 16, 2016, 6:59 AM Jun 16, 2016, 12:57 PM

                @Bob-Henderson I dont know if tom agree with that but i find out these fields :
                snmysqluser=‘root’
                snmysqlhost=‘127.0.0.1’

                😉

                1 Reply Last reply Reply Quote 0
                • B
                  Bob Henderson @Tom Elliott
                  last edited by Jun 16, 2016, 12:59 PM

                  @Tom-Elliott

                  I’ve put those in now, and had verified that if I put them into config.class.php manually, I got database connection back as well.

                  So we’ve figured out what broke, but I’m sorta confused as to why it happened in the first place? I appreciate the help, just wouldn’t want someone else to update and get the same issue.

                  1 Reply Last reply Reply Quote 0
                  • B
                    Bob Henderson
                    last edited by Jun 16, 2016, 1:30 PM

                    I just went and updated another node via git as well, and it did the same thing. It appears it wipes out the SQl settings in the fogsettings file. Adding them back in fixes it, but obviously isn’t what we’d want.

                    T 1 Reply Last reply Jun 16, 2016, 1:37 PM Reply Quote 0
                    • T
                      Tom Elliott @Bob Henderson
                      last edited by Jun 16, 2016, 1:37 PM

                      @Bob-Henderson I don’t think it’s wiping them out. It simply has no idea how to handle it from the prior config. I’ll see if I can make some better guesses though.

                      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

                      1 Reply Last reply Reply Quote 0
                      • T
                        Tom Elliott
                        last edited by Jun 16, 2016, 1:47 PM

                        Should be fixed in latest…hopefully.

                        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

                        B 1 Reply Last reply Jun 16, 2016, 2:42 PM Reply Quote 0
                        • B
                          Bob Henderson @Tom Elliott
                          last edited by Jun 16, 2016, 2:42 PM

                          @Tom-Elliott

                          no dice. Just updated the testing node to 8138, same issue. Putting the info back in config.class.php gets connection back, but it didn’t have them originally.

                          T 1 Reply Last reply Jun 16, 2016, 4:04 PM Reply Quote 0
                          • T
                            Tom Elliott @Bob Henderson
                            last edited by Jun 16, 2016, 4:04 PM

                            @Bob-Henderson and now after another update?

                            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

                            B 1 Reply Last reply Jun 16, 2016, 8:48 PM Reply Quote 0
                            • B
                              Bob Henderson @Tom Elliott
                              last edited by Jun 16, 2016, 8:48 PM

                              @Tom-Elliott

                              Sorry for the delay, busy day.

                              Updated to 8143, all seems good.

                              1 Reply Last reply Reply Quote 0
                              • cnewman402C
                                cnewman402
                                last edited by Aug 7, 2016, 1:35 AM

                                CentOS 7?
                                sudo su -
                                setsebool -P httpd_can_network_connect 1

                                Wayne WorkmanW 1 Reply Last reply Aug 7, 2016, 3:12 AM Reply Quote 0
                                • Wayne WorkmanW
                                  Wayne Workman @cnewman402
                                  last edited by Aug 7, 2016, 3:12 AM

                                  @cnewman402 This thread is two months old and has been solved. Do you have a similar problem?

                                  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!
                                  Daily Clean Installation Results:
                                  https://fogtesting.fogproject.us/
                                  FOG Reporting:
                                  https://fog-external-reporting-results.fogproject.us/

                                  cnewman402C 1 Reply Last reply Aug 7, 2016, 3:53 AM Reply Quote 0
                                  • cnewman402C
                                    cnewman402 @Wayne Workman
                                    last edited by Aug 7, 2016, 3:53 AM

                                    @Wayne-Workman I did have a similar problem in CentOS7. I used a standard security deployment which lead me to the exact issue in this thread. I resolved this by running the command I posted. Sorry for replying to an old thread. I landed here via google, and thought I should contribute.

                                    Wayne WorkmanW 1 Reply Last reply Aug 7, 2016, 3:56 AM Reply Quote 0
                                    • Wayne WorkmanW
                                      Wayne Workman @cnewman402
                                      last edited by Aug 7, 2016, 3:56 AM

                                      @cnewman402 The OP had an issue because the fog installer at the time was clearing his db settings in .fogsettings. I appreciate you contributing, but this thread isn’t related to SELinux. Maybe make a blurb in the tutorials area?

                                      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!
                                      Daily Clean Installation Results:
                                      https://fogtesting.fogproject.us/
                                      FOG Reporting:
                                      https://fog-external-reporting-results.fogproject.us/

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

                                      245

                                      Online

                                      12.0k

                                      Users

                                      17.3k

                                      Topics

                                      155.2k

                                      Posts
                                      Copyright © 2012-2024 FOG Project