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

    Installing OpenFire with MariaDB on CentOS 7

    IT Discussion
    openfire mysqli centos 7 jabber mariadb projects centos linux xmpp ignite realtime
    8
    48
    20.3k
    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.
    • scottalanmillerS
      scottalanmiller
      last edited by

      Here is the walk through of the GUI portion of the install. Mostly this is just clicking "next" a lot.

      openfire1.PNG

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

        openfire2.PNG

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

          openfire3.PNG

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

            openfire4.PNG

            Notice that the URL was changed to show the local IP address and the name that we selected earlier for the database "openfire".

            Select MySQL from the dropdown.

            The username and password are the ones that we set manually earlier.

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

              openfire5.PNG

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

                And that is it!

                1 Reply Last reply Reply Quote 0
                • J
                  Jason Banned
                  last edited by

                  That's the easy part. SSO and AD intergration are the hard part. AD/LDAP integration is simple if you are used to LDAP filters. SSO isn't easy at all.

                  1 Reply Last reply Reply Quote 0
                  • bbiAngieB
                    bbiAngie
                    last edited by

                    When you say updating all packages, do you just mean running the basic updates? Or is there something else outside of that I need to do?
                    I followed this to update:
                    https://www.centos.org/docs/5/html/yum/sn-updating-your-system.html

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

                      @bbiAngie said:

                      When you say updating all packages, do you just mean running the basic updates? Or is there something else outside of that I need to do?
                      I followed this to update:
                      https://www.centos.org/docs/5/html/yum/sn-updating-your-system.html

                      After install as root:

                      yum -y update
                      

                      Optionally add the EPEL

                      yum -y install epel-release
                      
                      bbiAngieB 1 Reply Last reply Reply Quote 0
                      • bbiAngieB
                        bbiAngie @JaredBusch
                        last edited by

                        @JaredBusch Would you recommend installing the EPEL? Do I "need" it?

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

                          @bbiAngie said:

                          @JaredBusch Would you recommend installing the EPEL? Do I "need" it?

                          @scottalanmiller would say yes. I disagree on that opinion. It does give you access to more tools that can be helpful. Also OpenFire might even require packages from it. I haven't looked.

                          The question here is does Vultr pre-include EPEL? If it does, a self built minimal install that does not by default include it may not work based on @scottalanmiller 's above instructions. I haven't tried it so not sure.

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

                            @JaredBusch said:

                            @bbiAngie said:

                            @JaredBusch Would you recommend installing the EPEL? Do I "need" it?

                            @scottalanmiller would say yes. I disagree on that opinion. It does give you access to more tools that can be helpful. Also OpenFire might even require packages from it. I haven't looked.

                            The question here is does Vultr pre-include EPEL? If it does, a self built minimal install that does not by default include it may not work based on @scottalanmiller 's above instructions. I haven't tried it so not sure.

                            Nothing in my list requires the EPEL, this will build without it. Only "extra" package included here is one core library. Beyond that, all MariaDB.

                            I used the EPEL typically because I like to have fail2ban, which is there. I did not install that here.

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

                              Vultr does enable the EPEL by default if memory serves. They also pre-update the OS to the very latest before install.

                              1 Reply Last reply Reply Quote 0
                              • bbiAngieB
                                bbiAngie @scottalanmiller
                                last edited by bbiAngie

                                @scottalanmiller said:

                                openfire4.PNG

                                Notice that the URL was changed to show the local IP address and the name that we selected earlier for the database "openfire".

                                Select MySQL from the dropdown.

                                The username and password are the ones that we set manually earlier.

                                Are the minimum and maximum connections the amount of users that will be connecting to it or is that something I don't even need to worry about?

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

                                  Don't worry about it at your size. That's a stateless Apache connection tuning thing and very different from the number of potential users.

                                  1 Reply Last reply Reply Quote 0
                                  • bbiAngieB
                                    bbiAngie
                                    last edited by

                                    I am getting the same red banner across the top as in your screenshot. Says "A connection to the database could not be made. View the error message by opening the "/log/error.log" log file, then go back to fix the problem."

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

                                      Post a screenshot of your configuration.

                                      1 Reply Last reply Reply Quote 0
                                      • bbiAngieB
                                        bbiAngie
                                        last edited by bbiAngie

                                        Never mind, I figured this out too!
                                        They make you create too many users and passwords.... after a few different combinations, I was able to move forward.

                                        1 Reply Last reply Reply Quote 2
                                        • bbiAngieB
                                          bbiAngie
                                          last edited by

                                          Is AD integration with SSO even worth considering?

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

                                            @bbiAngie said:

                                            Is AD integration with SSO even worth considering?

                                            That TOTALLY depends on your specific environment.

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