Tweet
Hi,
I've recently taken on the role of administrator for a vb forum which is currently on v4.2.1
Just recently, there was a security problem with another site hosted on the same server (not a vbulletin site), and the mitigation actions to fix the other site included upgrading some of the underlying products.
Along with all the updates, MySQL was updated from 5.1 to MariaDB 10.
Unfortunately, this broke the forum, as PHP 5.3 does not seem to support MariaDB10, and unfortunately no supported way to roll back to MySQL (cPanel doesn't provide an option to install the earlier version once you've upgraded
)
I was able to get the forum back up and running by upgrading PHP to 5.4 which does support MariaDB10, but there are issues with VB4.2.1 on PHP 5.4,
So, I'm biting the bullet, and upgrading vbulletin to 4.2.3.
As I've been reading through documentation about performing the upgrade, I see lots of comments about "test test test"... so just trying to come up with a valid method of testing.
From what I can work out, for testing I need to dump the database, and import it into a new database with a command something like this:
mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql
mysql -u dbusername -p test_databasename < /path/to/backupname.sql
and make a full copy of the public_html folder to test in, and update the includes/config.php file in the test to point to the test database, that is, change the lines:
$config['Database']['dbname'] = 'databasename';
$config['Misc']['forumpath'] = '/path/to/forum/public_html'
to :
$config['Database']['dbname'] = 'test_databasename';
$config['Misc']['forumpath'] = '/path/to/forum/public_html_test'
And then run the update process from the test location
My guess is that this location should be web accessible so that I can test the copy after the upgrade to make sure there were no issues. So, do I need to set up a new domain name to point at this test, or can I locate the test somewhere like /path/to/forum/public_html/testforum (given that the path to the current forum is /path/to/forum/public_html
(Apparently someone had a go at updating the forum to 4.2.3 a while back, but they got errors and never followed up how to resolve those errors. My hope is that I can either get the correct procedure sorted so that the upgrade goes smoothly, or to get assistance from this forum for any errors that do occur. Hence why I'm wanting to test the update process thoroughly)
current product versions:
PHP 5.4.45
vBulletin 4.2.1
MySQL 10.0.27-MariaDB
(Upgrading PHP version to 5.5 or 5.6 is potentially on the cards after this vbulletin upgrade is successfull.)
All pointers/tips/help much appreciated
Regards,
John.
I've recently taken on the role of administrator for a vb forum which is currently on v4.2.1
Just recently, there was a security problem with another site hosted on the same server (not a vbulletin site), and the mitigation actions to fix the other site included upgrading some of the underlying products.
Along with all the updates, MySQL was updated from 5.1 to MariaDB 10.
Unfortunately, this broke the forum, as PHP 5.3 does not seem to support MariaDB10, and unfortunately no supported way to roll back to MySQL (cPanel doesn't provide an option to install the earlier version once you've upgraded
)I was able to get the forum back up and running by upgrading PHP to 5.4 which does support MariaDB10, but there are issues with VB4.2.1 on PHP 5.4,
So, I'm biting the bullet, and upgrading vbulletin to 4.2.3.
As I've been reading through documentation about performing the upgrade, I see lots of comments about "test test test"... so just trying to come up with a valid method of testing.
From what I can work out, for testing I need to dump the database, and import it into a new database with a command something like this:
mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql
mysql -u dbusername -p test_databasename < /path/to/backupname.sql
and make a full copy of the public_html folder to test in, and update the includes/config.php file in the test to point to the test database, that is, change the lines:
$config['Database']['dbname'] = 'databasename';
$config['Misc']['forumpath'] = '/path/to/forum/public_html'
to :
$config['Database']['dbname'] = 'test_databasename';
$config['Misc']['forumpath'] = '/path/to/forum/public_html_test'
And then run the update process from the test location
My guess is that this location should be web accessible so that I can test the copy after the upgrade to make sure there were no issues. So, do I need to set up a new domain name to point at this test, or can I locate the test somewhere like /path/to/forum/public_html/testforum (given that the path to the current forum is /path/to/forum/public_html
(Apparently someone had a go at updating the forum to 4.2.3 a while back, but they got errors and never followed up how to resolve those errors. My hope is that I can either get the correct procedure sorted so that the upgrade goes smoothly, or to get assistance from this forum for any errors that do occur. Hence why I'm wanting to test the update process thoroughly)
current product versions:
PHP 5.4.45
vBulletin 4.2.1
MySQL 10.0.27-MariaDB
(Upgrading PHP version to 5.5 or 5.6 is potentially on the cards after this vbulletin upgrade is successfull.)
All pointers/tips/help much appreciated
Regards,
John.
only been admin of this VB site for some months... I'll have a dig through cpanel to check out its backup options.
Comment