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.
    • 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
                            • DashrenderD
                              Dashrender
                              last edited by

                              I would think AD integration would be pretty nice - only one user DB to worry about, one less username and password for your users to remember, but SSO might not be worth it.

                              1 Reply Last reply Reply Quote 0
                              • dafyreD
                                dafyre
                                last edited by

                                It has been a while since I've mucked around with OpenFire, but I was never able to get AD integration to work... Still, though... for 80 users... that might be worth tinkering around with.

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

                                  I thought about it a little bit. There are some aspects of AD integration and SSO that totally make sense in out environment. However, I think I am going to stick with using the "vanilla" setup. I think in the end it will make the most sense. We have a few users that go by different names than their windows logins so it might be easier to just manually manage user creation and such.

                                  1 Reply Last reply Reply Quote 0
                                  • DashrenderD
                                    Dashrender
                                    last edited by

                                    My boss talked to me once about having a chat solution in the office for staff. But during the discussion she talked herself out of it thinking the staff would use it more for gossip than for work. Which is probably true.

                                    That coupled with the fact that chat would take a lot longer to explain a problem to get help with than a phone call, but 90% of phone calls result in visiting the user anyway, so - really no point.

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

                                      We use them constantly and love them but can't find one that really makes us happy.

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

                                        I hate out messaging solution. The message history is awful, the interface looks like garbage and each message stacks in a new box on top of another instead of having a chat window.
                                        We tried LAN messenger but didn't like that at all. So hopefully this gets us close to what we need. Only issue I see is that no on will log in so hopefully I can setup some auto login stuff on the client.

                                        coliverC scottalanmillerS 2 Replies Last reply Reply Quote 0
                                        • dafyreD
                                          dafyre
                                          last edited by dafyre

                                          Easy enough... I really like the Jitsi chat client. It works great with my chat server!
                                          (Website: https://jitsi.org/)

                                          1 Reply Last reply Reply Quote 0
                                          • coliverC
                                            coliver @bbiAngie
                                            last edited by

                                            @bbiAngie said:

                                            I hate out messaging solution. The message history is awful, the interface looks like garbage and each message stacks in a new box on top of another instead of having a chat window.
                                            We tried LAN messenger but didn't like that at all. So hopefully this gets us close to what we need. Only issue I see is that no on will log in so hopefully I can setup some auto login stuff on the client.

                                            Look into doing it with AD and SSO. Then set it to startup when people log in. That way they won't have the remember a password or anything.

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