Thread Like Summary
Gizmo, isaac, Morgan
Total Likes: 6
Original Post (Thread Starter)
#264396 10/19/2020 10:19 AM
by Morgan
Morgan
Hi, an upgrade question to secure the forums MySQL

I run my forum on a VPS linux server and MySQL version is 5.6 and its only valid to feb 2021
The back up I use is set up as incremental meaning it only does backup on the data that has been changed.

I see in WHM control panel MySQL/MariaDB Upgrade (Step 1 of 6)
first step is to choose version 5.7 and click next..

I wonder what I should think of when upgrading to 5.7 except closing the forum and do back up.

I think I'll issue a ticket and ask the host to do it so I wonder what I should ask them to do.

Sorry if this is not a direct UBB question but I think that you guys have done this and knows how the forum can be affected or not..

Thanks for your input
Liked Replies
#264400 Oct 19th a 05:35 PM
by Ruben
Ruben
I think you should upgrade your server as much as possible as long as it is compatible with the scripts you run.
You don't want to be stranded with a EOL application.
I had one large site on a dedicated server the owner turned off upgrades years ago.
It was so long a duration there was no tool to upgrade anymore.
So it became easier to just migrate to a new host.

In fact site one php is getting old in the tooth so when I have time I will upgrade .
1 member likes this
#264409 Oct 20th a 07:07 PM
by Gizmo
Gizmo
UBB.threads is a basic web script, we assume that you have a fully functioning web server within the ranges of recommended PHP/MySQL versions. Web Server configuration or troubleshooting out of the scope of user to user support for our web script.

The required versions, as of this writing are:
PHP 5.4 or higher
MySQL 5.5 or higher
MariaDB is also compatible

When performing an upgrade of system services it is advised to have a full backup for disaster recovery; but this should be something that you keep on top of regardless of if you're having a system update applied or not.

We are currently running UBB.threads on several bleeding edge systems which include PHP7.4.11 and MariaDB10.4.14
1 member likes this
#264419 Oct 21st a 04:10 AM
by isaac
isaac
FWIW, Server Information from some of our snapshot servers as of 2020-10-15:

[Linked Image]

[Linked Image]

--

If you are in a legacy environment where you only have older PHP or MySQL versions, UBB.threads also works with a PHP 5.4 and MySQL 5.5 or newer enabled website, but these versions have reached official End Of Life and as such may expose your site to security vulnerabilities.

Here’s a letter you can send to your host; copy and paste
Quote
I’m interested in running UBB.threads PHP Forum software <https://ubbcentral.com/> and I was wondering if my account supported the following:

PHP 7.4 or greater
MySQL 5.6 or greater OR MariaDB 10.1 or greater
Nginx or Apache with mod_rewrite module
HTTPS support

Thanks!

This was shamelessly copied, modified, and reposted here from the open-source WordPress software's requirements page at https://wordpress.org/about/requirements/. Thank you, WP Team laugh
Attached Images
1 member likes this
#264426 Oct 21st a 10:48 AM
by isaac
isaac
Originally Posted by Morgan
Could you please explain what you mean in #4

4. load up your forum.?

as I don't follow what you mean in that item

Load up your forum = Visit your forum
Load your forums web pages in to your internet web browser = Visit your website
Use your web browser. Chrome, Firefox, Edge...etc. to visit your website.
1 member likes this
#264424 Oct 21st a 10:40 AM
by isaac
isaac
Originally Posted by Morgan
Isaac, I guess that the question in your reply is from someone who wish to start using a UBB forum software, I already use one and wish to upgrade the MySQL database so my question needs to be different to the host.
The second half of my post was directed at both new and current forum owners who need a starting template for asking their host to upgrade them to the latest versions of the software UBB.threads uses. This would include you in that group of people. It is a template for you to modify as desired.

The first half of my post was to demonstrate that UBB.threads works on an End Of Life version, as well as bleeding edge versions with either Linux or Windows.

Originally Posted by Morgan
I understand if I can't get more help here and if that is the case do you know of any other forums where i can ask?
Im not sure what part of your questions went unanswered by Ruben, Gizmo, and myself.

1. close your forum
2. make a backup.
3. upgrade your server software
4. load up your forum.
5. if all looks good, re-open your forum.
done.

Your web host should be able to help you with #3. Often it is seamless and only requires an email or telephone call to contact them to get the process started. They can also provide assistance for backing up your database before any changes are made.
1 member likes this
#264434 Oct 22nd a 06:50 PM
by Morgan
Morgan
Happy to say it seems to work with the upgraded MySQL Version: 5.7.32
Thank you very much everybody.

PHP Version: is still 5.6.40 hopefully its ok as i'm not sure when to upgrade that... wink
1 member likes this
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
v7.7.5 Active Topics Display Name Incorrect
by Jake - 11/17/2020 4:46 PM
custom islands in forums tool
by Ruben - 11/17/2020 3:21 PM
Captcha bug maybe?
by Morgan - 11/16/2020 8:34 AM
Facebook thumbnail issue
by DBryce - 11/08/2020 7:43 PM
No hop to menu in the category pages
by Morgan - 11/05/2020 4:19 PM
Who's Online Now
1 members (Ruben), 56 guests, and 45 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5