Installing OpenFire with MariaDB on CentOS 7
-
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.
-
-
And that is it!
-
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.
-
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 -
@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.htmlAfter install as root:
yum -y updateOptionally add the EPEL
yum -y install epel-release -
@JaredBusch Would you recommend installing the EPEL? Do I "need" it?
-
@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.
-
@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.
-
Vultr does enable the EPEL by default if memory serves. They also pre-update the OS to the very latest before install.
-
@scottalanmiller said:
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?
-
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.
-
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."
-
Post a screenshot of your configuration.
-
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. -
Is AD integration with SSO even worth considering?
-
@bbiAngie said:
Is AD integration with SSO even worth considering?
That TOTALLY depends on your specific environment.
-
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.
-
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.
-
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.
