• 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.
    • Tom ElliottT
      Tom Elliott
      last edited by

      Is selinux set to be permissive or disabled? Or is it still set as enforcing?

      sestatus

      setenforce 0 (temporary fix)

      Is iptables/firewalld?

      systemctl status firewalld
      iptables -L -n

      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 1
      • AngryScientistA
        AngryScientist
        last edited by

        To reiterate, I followed the install guide on the wiki exactly.

        selinux is set to permissive:

        SELinux status:                 enabled
        SELinuxfs mount:                /sys/fs/selinux
        SELinux root directory:         /etc/selinux
        Loaded policy name:             targeted
        Current mode:                   permissive
        Mode from config file:          permissive
        Policy MLS status:              enabled
        Policy deny_unknown status:     allowed
        Max kernel policy version:      28
        

        Status of firewalld:

         firewalld.service - firewalld - dynamic firewall daemon
           Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
           Active: active (running) since Tue 2016-11-08 09:43:44 EST; 1h 30min ago
         Main PID: 831 (firewalld)
           CGroup: /system.slice/firewalld.service
                   └─831 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
        
        Nov 08 09:43:39 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
        Nov 08 09:43:44 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
        

        And now for IPtables, this one is long!

        Chain INPUT (policy ACCEPT)
        target     prot opt source               destination         
        ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0            ctstate RELATED,ESTABLISHED
        ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           
        INPUT_direct  all  --  0.0.0.0/0            0.0.0.0/0           
        INPUT_ZONES_SOURCE  all  --  0.0.0.0/0            0.0.0.0/0           
        INPUT_ZONES  all  --  0.0.0.0/0            0.0.0.0/0           
        ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0           
        REJECT     all  --  0.0.0.0/0            0.0.0.0/0            reject-with icmp-host-prohibited
        
        Chain FORWARD (policy ACCEPT)
        target     prot opt source               destination         
        ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0            ctstate RELATED,ESTABLISHED
        ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           
        FORWARD_direct  all  --  0.0.0.0/0            0.0.0.0/0           
        FORWARD_IN_ZONES_SOURCE  all  --  0.0.0.0/0            0.0.0.0/0           
        FORWARD_IN_ZONES  all  --  0.0.0.0/0            0.0.0.0/0           
        FORWARD_OUT_ZONES_SOURCE  all  --  0.0.0.0/0            0.0.0.0/0           
        FORWARD_OUT_ZONES  all  --  0.0.0.0/0            0.0.0.0/0           
        ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0           
        REJECT     all  --  0.0.0.0/0            0.0.0.0/0            reject-with icmp-host-prohibited
        
        Chain OUTPUT (policy ACCEPT)
        target     prot opt source               destination         
        OUTPUT_direct  all  --  0.0.0.0/0            0.0.0.0/0           
        
        Chain FORWARD_IN_ZONES (1 references)
        target     prot opt source               destination         
        FWDI_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        FWDI_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        FWDI_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        
        Chain FORWARD_IN_ZONES_SOURCE (1 references)
        target     prot opt source               destination         
        
        Chain FORWARD_OUT_ZONES (1 references)
        target     prot opt source               destination         
        FWDO_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        FWDO_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        FWDO_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        
        Chain FORWARD_OUT_ZONES_SOURCE (1 references)
        target     prot opt source               destination         
        
        Chain FORWARD_direct (1 references)
        target     prot opt source               destination         
        
        Chain FWDI_public (3 references)
        target     prot opt source               destination         
        FWDI_public_log  all  --  0.0.0.0/0            0.0.0.0/0           
        FWDI_public_deny  all  --  0.0.0.0/0            0.0.0.0/0           
        FWDI_public_allow  all  --  0.0.0.0/0            0.0.0.0/0           
        
        Chain FWDI_public_allow (1 references)
        target     prot opt source               destination         
        
        Chain FWDI_public_deny (1 references)
        target     prot opt source               destination         
        
        Chain FWDI_public_log (1 references)
        target     prot opt source               destination         
        
        Chain FWDO_public (3 references)
        target     prot opt source               destination         
        FWDO_public_log  all  --  0.0.0.0/0            0.0.0.0/0           
        FWDO_public_deny  all  --  0.0.0.0/0            0.0.0.0/0           
        FWDO_public_allow  all  --  0.0.0.0/0            0.0.0.0/0           
        
        Chain FWDO_public_allow (1 references)
        target     prot opt source               destination         
        
        Chain FWDO_public_deny (1 references)
        target     prot opt source               destination         
        
        Chain FWDO_public_log (1 references)
        target     prot opt source               destination         
        
        Chain INPUT_ZONES (1 references)
        target     prot opt source               destination         
        IN_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        IN_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        IN_public  all  --  0.0.0.0/0            0.0.0.0/0           [goto] 
        
        Chain INPUT_ZONES_SOURCE (1 references)
        target     prot opt source               destination         
        
        Chain INPUT_direct (1 references)
        target     prot opt source               destination         
        ACCEPT     2    --  0.0.0.0/0            0.0.0.0/0           
        
        Chain IN_public (3 references)
        target     prot opt source               destination         
        IN_public_log  all  --  0.0.0.0/0            0.0.0.0/0           
        IN_public_deny  all  --  0.0.0.0/0            0.0.0.0/0           
        IN_public_allow  all  --  0.0.0.0/0            0.0.0.0/0           
        
        Chain IN_public_allow (1 references)
        target     prot opt source               destination         
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:21 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:137 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:138 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:139 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:445 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:80 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:443 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:111 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:111 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:20048 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:20048 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:2049 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:22 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:53 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:53 ctstate NEW
        ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0            tcp dpt:3306 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:67 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:69 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpt:4011 ctstate NEW
        ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0            udp dpts:49152:65532 ctstate NEW
        
        Chain IN_public_deny (1 references)
        target     prot opt source               destination         
        
        Chain IN_public_log (1 references)
        target     prot opt source               destination         
        
        Chain OUTPUT_direct (1 references)
        target     prot opt source               destination  
        
        1 Reply Last reply Reply Quote 0
        • 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
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            347

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project