Greetings,
It's great to get back into the JForum community!
I have an ancient (2.1.8) version of JForum that I've been running since the dark ages. I have finally gotten around to migrating it to a new Red Had server, running Tomcat 10 and Java 11.
It was a bit rough, and I had to start over three times, but I finally made it through all of the upgrades and configurations.
The forum is now hosted on its own domain (forums.dawntodusksoftware.com) using an Apache ProxyPass to redirect it to the webapp on Tomcat (localhost:8081/jforum).
So far, things are looking pretty good.
Question #1:
The forums, topics, messages, etc. all look OK, but I did see a lot of mysterious warnings from MySQL during the initial DB import. There were hundreds of messages like this:
Query OK, 267 rows affected, 11 warnings (0.022 sec)
Records: 267 Duplicates: 0 Warnings: 11
Query OK, 281 rows affected, 11 warnings (0.018 sec)
Records: 281 Duplicates: 0 Warnings: 11
Query OK, 430 rows affected, 17 warnings (0.023 sec)
Records: 430 Duplicates: 0 Warnings: 17
...
Is this something I should be worried about?
Question #2:
I'm getting ready to customize the look of the forum to match my main site. I was a little confused reading the
Templates and Styles section. Do I just start editing jforum/templates/default/header.htm, et. al.?
Question #3:
I used to have a custom SSO that allowed all of my registered users to use the forum with the same account. I think I'm going to abandon that and let users create separate accounts for the forum.
It appears that JForum stores a hash of the password in the
jforum_uesrs.users_password field. My SSO hack stored the value "#shadow#" in that field. Is is OK if I leave it that way and just add a note that previously registered users will need to reset their password? Or should I store some other value?
Question #4:
After running for over 10 years, I've registered a lot of spam accounts. I currently have over 400,000 user accounts, I suspect that 98% of those are spam.
A few years back I set the forum to full moderation, so I've rejected all of the spam posts. But I'd really like to delete these accounts.
Is there a script or utility I can run that will safely delete all of the user accounts without any posts?
That's it for now!