ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Install LAMP phpMyAdmin and MariaDB into CentOS7

    Scheduled Pinned Locked Moved IT Discussion
    33 Posts 5 Posters 2.2k 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.
    • DustinB3403D
      DustinB3403
      last edited by

      I'm comfortable with the phpMyAdmin being accessible on the LAN. I have no issues with that.

      But all of the documentation I'm able to find seems to not go this route. For security reasons I assume.

      1 Reply Last reply Reply Quote 0
      • travisdh1T
        travisdh1 @DustinB3403
        last edited by

        @DustinB3403 You're not getting a "You don't have permission to access this page." error now?

        Since you don't mind it being available on the LAN, change all the 'Order Deny,Allow' to 'Order Allow,Deny' and each 'Deny from All' to 'Allow from All'.

        I've never actually used a separate .conf file for phpmyadmin. You could probably make this work, but you'd need to configure proxy and reverse proxy to get that setup working correctly. It's like they went and locked it down to the point of being unusable.

        1 Reply Last reply Reply Quote 0
        • DustinB3403D
          DustinB3403
          last edited by

          Ok I got that resolved and now I'm signed in. Followed this here to get it going.

          travisdh1T 1 Reply Last reply Reply Quote 1
          • travisdh1T
            travisdh1 @DustinB3403
            last edited by

            @DustinB3403 said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

            Ok I got that resolved and now I'm signed in. Followed this here to get it going.

            Looks like a much better guide.

            1 Reply Last reply Reply Quote 0
            • DustinB3403D
              DustinB3403
              last edited by

              Forward progress!

              0_1471530813904_chrome_2016-08-18_10-33-01.png

              1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller
                last edited by

                phpMyAdmin is just another website, there isn't anything unique about it. Don't think of it as something special.

                1 Reply Last reply Reply Quote 1
                • DustinB3403D
                  DustinB3403
                  last edited by

                  Stalled... it appears CentOS has some restrictions in place that don't allow the website to get updated.

                  So investigating this issue now..0_1471532229512_chrome_2016-08-18_10-55-44.png

                  travisdh1T 1 Reply Last reply Reply Quote 0
                  • travisdh1T
                    travisdh1 @DustinB3403
                    last edited by

                    @DustinB3403 At least that error tells you how to go fix things.

                    DustinB3403D 1 Reply Last reply Reply Quote 1
                    • DustinB3403D
                      DustinB3403 @travisdh1
                      last edited by

                      @travisdh1 said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                      @DustinB3403 At least that error tells you how to go fix things.

                      Kind of, I've set the permissions on the file in question, and no dice.

                      travisdh1T 1 Reply Last reply Reply Quote 0
                      • stacksofplatesS
                        stacksofplates
                        last edited by

                        Remember if you have SELinux turned on you're going to need to change the type for all of those files.

                        DustinB3403D 1 Reply Last reply Reply Quote 0
                        • DustinB3403D
                          DustinB3403 @stacksofplates
                          last edited by

                          @stacksofplates said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                          Remember if you have SELinux turned on you're going to need to change the type for all of those files.

                          selinux is on by default.

                          What do you mean "change the type for all of those files" ?

                          stacksofplatesS 1 Reply Last reply Reply Quote 0
                          • travisdh1T
                            travisdh1 @DustinB3403
                            last edited by

                            @DustinB3403 said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                            @travisdh1 said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                            @DustinB3403 At least that error tells you how to go fix things.

                            Kind of, I've set the permissions on the file in question, and no dice.

                            Either file permissions in the rest of the phpmyadmin folder, of selinux permissions problems. My first guess is normally selinux in these cases.

                            semanage fcontext -a -t httpd_sys_rw_content_t '/path/to/phpmyadmin(/.*)?'
                            
                            1 Reply Last reply Reply Quote 1
                            • stacksofplatesS
                              stacksofplates @DustinB3403
                              last edited by

                              @DustinB3403 said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                              @stacksofplates said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                              Remember if you have SELinux turned on you're going to need to change the type for all of those files.

                              selinux is on by default.

                              What do you mean "change the type for all of those files" ?

                              You have to change the SELinux context type for the files in apache directory. By default the context should be httpd_sys_rw_content_t.

                              If you do an ls -lZ on the directory all of the files are in it will show you the context type.

                              1 Reply Last reply Reply Quote 1
                              • DustinB3403D
                                DustinB3403
                                last edited by

                                I ran this, and was able to get past the above error.

                                chcon -R -t httpd_sys_rw_content_t /var/www/html/
                                
                                1 Reply Last reply Reply Quote 0
                                • stacksofplatesS
                                  stacksofplates
                                  last edited by stacksofplates

                                  you can also do a chcon -R --reference=/var/www/html <directory you need to change> but remember if you just use chcon it can be reversed with restorecon to the bad types. I usually use this as a quick test to make sure it works. Then I'll use semanage to permanently change the context.

                                  1 Reply Last reply Reply Quote 0
                                  • JaredBuschJ
                                    JaredBusch
                                    last edited by

                                    Just turn of SELinux and make sure it all works before you change contexts.

                                    setenforce 0

                                    then if it all works, change contexts and turn it back on and test.

                                    stacksofplatesS 1 Reply Last reply Reply Quote 2
                                    • scottalanmillerS
                                      scottalanmiller
                                      last edited by

                                      I'm with Jared, turning SELinux off during testing and installation is fine. Just make sure it is there before you start using the box.

                                      JaredBuschJ 1 Reply Last reply Reply Quote 1
                                      • JaredBuschJ
                                        JaredBusch @scottalanmiller
                                        last edited by

                                        @scottalanmiller said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                                        I'm with Jared, turning SELinux off during testing and installation is fine. Just make sure it is there before you start using the box.

                                        And that is why I always say to use setenforce 0, because it will not survive a reboot in case you forget.

                                        scottalanmillerS 1 Reply Last reply Reply Quote 1
                                        • stacksofplatesS
                                          stacksofplates @JaredBusch
                                          last edited by

                                          @JaredBusch said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                                          Just turn of SELinux and make sure it all works before you change contexts.

                                          setenforce 0

                                          then if it all works, change contexts and turn it back on and test.

                                          I got out of the habit of doing this because if the installer changes something in a diff directory that you didn't expect it can be a pain to troubleshoot. I've had that happen a couple times. But in this scenario it's all http files so I agree.

                                          1 Reply Last reply Reply Quote 0
                                          • scottalanmillerS
                                            scottalanmiller @JaredBusch
                                            last edited by

                                            @JaredBusch said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                                            @scottalanmiller said in Install LAMP phpMyAdmin and MariaDB into CentOS7:

                                            I'm with Jared, turning SELinux off during testing and installation is fine. Just make sure it is there before you start using the box.

                                            And that is why I always say to use setenforce 0, because it will not survive a reboot in case you forget.

                                            Same here.

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