Since update to OF 3.8.1 i’ve had problems with listing users @ OF admin interface, the list is completely empty, yet where it says “Total Users:” it shows the correct amount of users.
I’ve had no problems in OF 3.7.X and i saw everything. I can search the users one by one and they show up, but i can’t see the entire list.
This is an extremely important feature for me, as i am not managing thousands of users, so having a list is perfect.
TROUBLESHOOT INFO:
It seems to be some sort of issue with database. When i observe the “Warn.” logs of my OF server then every time i “refresh” or go the the "User Summary Page it adds another line to the “Warn.” log list.
The lines are simillar and they are, for example:
2013.03.19 16:39:46 org.jivesoftware.util.log.util.CommonsLogFactory - Unable to set status of connection 11 from ACTIVE to AVAILABLE because it’s state was NULL
2013.03.19 16:44:26 org.jivesoftware.util.log.util.CommonsLogFactory - Unable to set status of connection 14 from ACTIVE to AVAILABLE because it’s state was NULL
2013.03.19 16:45:14 org.jivesoftware.util.log.util.CommonsLogFactory - Unable to set status of connection 17 from ACTIVE to AVAILABLE because it’s state was NULL
This is all the information i’ve got, i hope someone has a solution to this as i am not competent enough to figure out where the problem exactly lies.
Any questions about this, feel free to ask and thanks in advance.
I am having the same issue. On 3.8.1 imbedded database I can see all users in user summary but I installed on a production server 3.8.2 with a MySql 5.6.11 and the user summary is empty. Please help I want to roll this out but need to make sure it is functing as expected.
I’m glad I’m not alone in this. I am still experiencing the issue with Openfire 3.8.2 on my server using MySQL database. (Settings described above). I was really hoping this gets fixed in 3.8.2, but so far no.
It seems to be something to do with the major OF update to 3.8.X from 3.7.X.
Until they can figure it out, you can use the “Search” function in admin interface, which is slow and annoying as hell to use, but it is the only option you got at the moment, also you can’t see users who have registered.
If any developers need more information, please feel free to ask, I’ll do my best of providing it. Also i have been trying to get this fixed by myself, but so far nothing works.
Exact same thing here so obviously its a common issue. My setup is with openfire 3.8.2 using mysql 5.6.12 . Its working fine as stated by previous comments but would be nice to be able to see all the users. Thanks for all your hard work, other than this minor glitch it is an excellent product.
I’m using OpenFire 3.8.2 hosted in a EC2 - Amazon Server (Linux) with MySQL 5.6.12 (RDS - Amazon).
All works fine but the user-summary.jsp is empty all the time.
I can get all users name using DBAccess OpenFire Plugin and using the “Search Users” field
I’ve heard that put MySQL on version 5.1.xx could solve the problem.
Anyone tried it before? Anyone found a solution to this issue?
I’m not sure if setting the MySQL version to 5.1.XX helps, since i’ve been using MySQL 5.6.XX before and didn’t have the issue. So something is definently changed with Openfire 3.8.X which causes the problem to so many users.
So far, haven’t found a way to fix this problem, getting quite frustrating.
Just a bump for this - have there been any updates? I’m having the same issue on a fresh installation. I’m also experiencing very similar issues on the Server Manager > Statistics page, if any of you have that plugin.
No, i believe this is on their low priority of bugs list, IF they even know about the bug. Since if some users report it’s not working and some users say it’s working, like with any other software, the dev’s don’t consider it a bug or even test-worthy. It might get fixed after some years or when they experience the bug themselves i guess. Meanwhile you can try to find workarounds, i am just browsing the database table where the users are manually, annoying as hell, but the only way for me at the moment.
is it simply that the mysql jdbc driver needs updating? It seems most of the users having issue are using mysql 5.6.x version… and people without issue are on older versions. 5.6.x is drastically different over the older 5.1.x that most “server” linux distros ship with… on windows servers of course users must manually install mysql, so they get the latest package.
i use mysql 5.1.x as my database on a openfire 3.8.2 server running on CentOS 6.x. all works as expected.
EDIT: I just looked, Openfire 3.8.2 is using MySQL JDBC Driver version 5.0.8 – the latest from the mysql site is 5.1.26 – perhaps someone experiencing this issue should try updating the driver and testing it out…
It appears that you can update your mysql jdbc driver by replacing the one under the Openfire installation directory’s lib/ directory. It’s called “mysql.jar” right now… just back that up, download the latest from mysql’s site, and copy it into that lib/ directory (making sure to call it the same name - mysql.jar).
I have attached the lastest MySQL JDBC Driver for convinience… if you feel so inclinded to download your own… it’s available at:
– Make sure you rename this download jar to “mysql.jar” before dropping it into your openfire_installation/lib/ directory mysql-connector-java-5.1.26-bin.jar (855948 Bytes)