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

    My database connection appears to be invalid?

    Scheduled Pinned Locked Moved Solved
    Bug Reports
    5
    25
    9.1k
    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.
    • Wayne WorkmanW
      Wayne Workman
      last edited by

      Try to access the db manually.

      mysql -D fog

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

        Pulled from git for RC21, Fixed errors in the fogsettings file. During installation, a selinux alert was generated:

        SELinux is preventing /usr/bin/passwd from ioctl access on the file /home/ullsadmin/git/fogproject/bin/error_logs/fog_error_1.3.0-RC-21.log.
        
        *****  Plugin catchall (100. confidence) suggests   **************************
        
        If you believe that passwd should be allowed ioctl access on the fog_error_1.3.0-RC-21.log file by default.
        Then you should report this as a bug.
        You can generate a local policy module to allow this access.
        Do
        allow this access for now by executing:
        # grep passwd /var/log/audit/audit.log | audit2allow -M mypol
        # semodule -i mypol.pp
        
        Additional Information:
        Source Context                unconfined_u:unconfined_r:passwd_t:s0-s0:c0.c1023
        Target Context                unconfined_u:object_r:user_home_t:s0
        Target Objects                /home/ullsadmin/git/fogproject/bin/error_logs/fog_
                                      error_1.3.0-RC-21.log [ file ]
        Source                        passwd
        Source Path                   /usr/bin/passwd
        Port                          <Unknown>
        Host                          localhost.localdomain
        Source RPM Packages           passwd-0.79-4.el7.x86_64
        Target RPM Packages           
        Policy RPM                    selinux-policy-3.13.1-60.el7_2.9.noarch
        Selinux Enabled               True
        Policy Type                   targeted
        Enforcing Mode                Permissive
        Host Name                     localhost.localdomain
        Platform                      Linux localhost.localdomain
                                      3.10.0-327.36.3.el7.x86_64 #1 SMP Mon Oct 24
                                      16:09:20 UTC 2016 x86_64 x86_64
        Alert Count                   2
        First Seen                    2016-11-05 22:11:37 EDT
        Last Seen                     2016-11-08 12:24:57 EST
        Local ID                      b2bddb79-8259-42e5-b4d2-2b432292d6b6
        
        Raw Audit Messages
        type=AVC msg=audit(1478625897.821:682): avc:  denied  { ioctl } for  pid=5594 comm="passwd" path="/home/ullsadmin/git/fogproject/bin/error_logs/fog_error_1.3.0-RC-21.log" dev="dm-0" ino=35560553 scontext=unconfined_u:unconfined_r:passwd_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:user_home_t:s0 tclass=file
        
        
        type=SYSCALL msg=audit(1478625897.821:682): arch=x86_64 syscall=ioctl success=no exit=ENOTTY a0=1 a1=5401 a2=7ffd1070e6e0 a3=7ffd1070e670 items=0 ppid=5118 pid=5594 auid=1000 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=pts1 ses=1 comm=passwd exe=/usr/bin/passwd subj=unconfined_u:unconfined_r:passwd_t:s0-s0:c0.c1023 key=(null)
        
        Hash: passwd,passwd_t,user_home_t,file,ioctl
        

        The file was still written however, and the last few entries indicate a problem with the database as well…

        --2016-11-08 12:49:27--  (try: 5)  http://10.6.6.6//fog//maintenance/backup_db.php
        Connecting to 10.6.6.6:80... connected.
        HTTP request sent, awaiting response... 
        
        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
        • Wayne WorkmanW
          Wayne Workman @AngryScientist
          last edited by

          @AngryScientist In permissive mode, SELinux generates messages as it would in enforcing, but it doesn’t take any action to block anything whatsoever. Please try what I posted below.

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

            @Wayne-Workman
            Okay, sorry Wayne, your post got lost in my text walls.

            [ullsadmin@localhost ~]$ mysql -D fog
            ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
            

            This is beyond my knowledge…
            EDIT: Restarting mysqld fixed the issue. Now I will see if it stays after reboot…
            EDIT2: It does not stay, boooo.

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

              @AngryScientist When it throws the error again, try these and see if one works:

              mysql -D fog -u root -h localhost

              mysql -D fog -u root -h 127.0.0.1

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

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

                @Wayne-Workman
                Okay, sorry Wayne, your post got lost in my text walls.

                [ullsadmin@localhost ~]$ mysql -D fog
                ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
                

                This is beyond my knowledge…
                EDIT: Restarting mysqld fixed the issue. Now I will see if it stays after reboot…
                EDIT2: It does not stay, boooo.

                I have the exact same error now… great.

                @Tom-Elliott Moving this to bug reports.

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

                  This post is deleted!
                  JJ FullmerJ 1 Reply Last reply Reply Quote 0
                  • 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
                                            • 1 / 2
                                            • First post
                                              Last post

                                            281

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project