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

    My database connection appears to be invalid?

    Scheduled Pinned Locked Moved Solved Bug Reports
    25 Posts 5 Posters 10.7k Views
    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.
    • JJ FullmerJ
      JJ Fullmer Testers
      last edited by

      This sounds like a mariaDB (aka mySql) issue. And it sounds like it’s just not configured to start on startup if systemctl start mysqld.service fixes it. This article might could help.
      https://mariadb.com/kb/en/mariadb/starting-and-stopping-mariadb-automatically/

      I thought that the database got configured to automatically start on the apt-get/yum install.
      I have cent os 7 and have never had to do any sort of configuration for fog services to run on startup.

      Wayne WorkmanW 1 Reply Last reply Reply Quote 0
      • JJ FullmerJ
        JJ Fullmer Testers @Wayne Workman
        last edited by

        This post is deleted!
        1 Reply Last reply Reply Quote 0
        • Wayne WorkmanW
          Wayne Workman @JJ Fullmer
          last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • Wayne WorkmanW
            Wayne Workman
            last edited by

            In centos 7 the way to start maridadb on boot is probably:
            systemctl eanble mysqld

            I’m still waiting to hear back on the commands I posted.

            AngryScientistA 1 Reply Last reply Reply Quote 0
            • AngryScientistA
              AngryScientist @Wayne Workman
              last edited by

              @Wayne-Workman

              systemctl enable mysqld
              

              Typo correction!

              I will reboot my FOG server later today and give you the results of your suggestions. Right now I am reveling in the wonders of 5GBps imagine speed. 1.2.0 on my old hardware topped out at 1.2GBps

              Wayne WorkmanW 1 Reply Last reply Reply Quote 1
              • Wayne WorkmanW
                Wayne Workman @AngryScientist
                last edited by

                @AngryScientist said in My database connection appears to be invalid?:

                Right now I am reveling in the wonders of 5GBps imagine speed. 1.2.0 on my old hardware topped out at 1.2GBps

                A lot of that has to do with the performance improvements of FOG 1.3.0 RC, a change was made to how the images are compressed and decompressed for imaging and some people reported 50 to 100% speed increases.

                1 Reply Last reply Reply Quote 1
                • Tom ElliottT
                  Tom Elliott
                  last edited by

                  RC-22 Officially released.

                  Please update and hopefully you’ll see all the latest goodies and what not. (Hopefully this will be fixed for you too.)

                  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

                  AngryScientistA 1 Reply Last reply Reply Quote 0
                  • AngryScientistA
                    AngryScientist @Tom Elliott
                    last edited by

                    @Tom-Elliott
                    I know how to do a git pull, but what is the official upgrade procedure?

                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                    • Wayne WorkmanW
                      Wayne Workman @AngryScientist
                      last edited by

                      @AngryScientist here:

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

                      1 Reply Last reply Reply Quote 0
                      • Tom ElliottT
                        Tom Elliott
                        last edited by

                        In very simple terms:

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

                        Essentially, open a terminal.

                        Cd to the installer directory.

                        If you loaded the repo from git, make sure you’re on the dev-branch:

                        git checkout dev-branch

                        Ensure you’re environment is setup without customizations:

                        git reset --hard

                        Pull the latest:

                        git pull

                        Cd to the BIN directory:

                        cd bin

                        Install as normal.

                        ./installfog.sh -y

                        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

                        AngryScientistA 1 Reply Last reply Reply Quote 1
                        • AngryScientistA
                          AngryScientist @Tom Elliott
                          last edited by

                          @Tom-Elliott

                          Time to un-zombie the thread.

                          I updated to RC-36, and same same. I had to sudo systemctl start mysqld to get the database connection running.

                          Tom ElliottT george1421G 2 Replies Last reply Reply Quote 0
                          • Tom ElliottT
                            Tom Elliott @AngryScientist
                            last edited by

                            @AngryScientist Are you sure it wasn’t:

                            systemctl start mysql or even systemctl start mariadb?

                            I’m trying to validate what the problem is here, and I’m fairly sure we’d have seen a bunch of issues with this operationally speaking. (We have a bunch of people using CentOS 7).

                            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
                            • george1421G
                              george1421 Moderator @AngryScientist
                              last edited by george1421

                              @AngryScientist It would be interesting to know if the contents of your .fogsettings file is messed up and then upgrading caused the installer to look at bad data again??

                              My production server is running Centos 7, I think we are on RC34 and that upgraded cleanly.

                              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!

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

                              42

                              Online

                              12.2k

                              Users

                              17.4k

                              Topics

                              155.6k

                              Posts
                              Copyright © 2012-2025 FOG Project