I was preparing for upgrade vBulletin to v5.4.3.
Origin Server spec is too low for upgrading to v5.4.3 so I made a new server for it.
# Issue 1 : All user's password dose not work on the New server. the password works fine on Origin Server.
I have no idea why it happen but Forum is display normally on the new server but user can not login to the new server with their ID/PW.
My current vBulletin version is v4.2.1.
Dose anyone know why it happen and how to fix it?
# What I did #
* I made a New server for Upgrade and restored with mysqldump from Origin Server.
1. Created a new server
Origin Server -----------------> New server for Upgrade -------
| Server Type: CentOS . |-> Server Type: uBuntu
| Web Server Apache v2.2.15 |-> Web Server Apache/2.4.7
| PHP 5.3.3 |-> PHP 7.1.19
| MySQL Version 5.1.69-log |-> MySQL Version 5.5.60
2. Got mysql dump file from Origin server
> mysqldump --opt -Q -uroot -p forum > forum_20180813.SQL
3. Copy forum folder from the origin server to new server
> Origin server /var/www/html/forums ---> New server /var/www/html/forums
4. Created Data base
> CREATE DATABASE forum DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
5. Restored mysql dump file on the new server
> mysql -uroot -p forum < forum_20180813.SQL
## Origin Server DB character set : MySQL Version 5.1.69-log ##
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show variables like '%col%';
+---------------------------+-------------------+
| Variable_name | Value |
+---------------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| protocol_version | 10 |
| slave_compressed_protocol | OFF |
+---------------------------+-------------------+
5 rows in set (0.00 sec)
## New Server DB character set : MySQL Version 5.5.60 ##
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show variables like '%col%';
+---------------------------+-------------------+
| Variable_name | Value |
+---------------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| protocol_version | 10 |
| slave_compressed_protocol | OFF |
+---------------------------+-------------------+
5 rows in set (0.00 sec)
mysql> SELECT * FROM setting WHERE varname = 'bburl';
+---------+------------+----------------------------+-------------------------------+------------+--------------+----------+----------+----------+-----------+---------------------------------------------------------------+-----------+
| varname | grouptitle | value | defaultvalue | optioncode | displayorder | advanced | volatile | datatype | product | validationcode | blacklist |
+---------+------------+----------------------------+-------------------------------+------------+--------------+----------+----------+----------+-----------+---------------------------------------------------------------+-----------+
| bburl | address | http://35.171.53.29/forums | http://www.example.com/forums | | 20 | 0 | 1 | free | vbulletin | return ($data AND preg_match('#^https?://.+[^/]$#i', $data)); | 0 |
+---------+------------+----------------------------+-------------------------------+------------+--------------+----------+----------+----------+-----------+---------------------------------------------------------------+-----------+
1 row in set (0.00 sec)
mysql> SELECT * FROM setting WHERE varname = 'cookiepath';
+------------+------------+----------+--------------+------------+--------------+----------+----------+----------+-----------+----------------+-----------+
| varname | grouptitle | value | defaultvalue | optioncode | displayorder | advanced | volatile | datatype | product | validationcode | blacklist |
+------------+------------+----------+--------------+------------+--------------+----------+----------+----------+-----------+----------------+-----------+
| cookiepath | http | /forums/ | / | cookiepath | 20 | 0 | 1 | free | vbulletin | | 1 |
+------------+------------+----------+--------------+------------+--------------+----------+----------+----------+-----------+----------------+-----------+
1 row in set (0.00 sec)
Origin Server spec is too low for upgrading to v5.4.3 so I made a new server for it.
# Issue 1 : All user's password dose not work on the New server. the password works fine on Origin Server.
I have no idea why it happen but Forum is display normally on the new server but user can not login to the new server with their ID/PW.
My current vBulletin version is v4.2.1.
Dose anyone know why it happen and how to fix it?
# What I did #
* I made a New server for Upgrade and restored with mysqldump from Origin Server.
1. Created a new server
Origin Server -----------------> New server for Upgrade -------
| Server Type: CentOS . |-> Server Type: uBuntu
| Web Server Apache v2.2.15 |-> Web Server Apache/2.4.7
| PHP 5.3.3 |-> PHP 7.1.19
| MySQL Version 5.1.69-log |-> MySQL Version 5.5.60
2. Got mysql dump file from Origin server
> mysqldump --opt -Q -uroot -p forum > forum_20180813.SQL
3. Copy forum folder from the origin server to new server
> Origin server /var/www/html/forums ---> New server /var/www/html/forums
4. Created Data base
> CREATE DATABASE forum DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
5. Restored mysql dump file on the new server
> mysql -uroot -p forum < forum_20180813.SQL
## Origin Server DB character set : MySQL Version 5.1.69-log ##
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show variables like '%col%';
+---------------------------+-------------------+
| Variable_name | Value |
+---------------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| protocol_version | 10 |
| slave_compressed_protocol | OFF |
+---------------------------+-------------------+
5 rows in set (0.00 sec)
## New Server DB character set : MySQL Version 5.5.60 ##
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show variables like '%col%';
+---------------------------+-------------------+
| Variable_name | Value |
+---------------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| protocol_version | 10 |
| slave_compressed_protocol | OFF |
+---------------------------+-------------------+
5 rows in set (0.00 sec)
mysql> SELECT * FROM setting WHERE varname = 'bburl';
+---------+------------+----------------------------+-------------------------------+------------+--------------+----------+----------+----------+-----------+---------------------------------------------------------------+-----------+
| varname | grouptitle | value | defaultvalue | optioncode | displayorder | advanced | volatile | datatype | product | validationcode | blacklist |
+---------+------------+----------------------------+-------------------------------+------------+--------------+----------+----------+----------+-----------+---------------------------------------------------------------+-----------+
| bburl | address | http://35.171.53.29/forums | http://www.example.com/forums | | 20 | 0 | 1 | free | vbulletin | return ($data AND preg_match('#^https?://.+[^/]$#i', $data)); | 0 |
+---------+------------+----------------------------+-------------------------------+------------+--------------+----------+----------+----------+-----------+---------------------------------------------------------------+-----------+
1 row in set (0.00 sec)
mysql> SELECT * FROM setting WHERE varname = 'cookiepath';
+------------+------------+----------+--------------+------------+--------------+----------+----------+----------+-----------+----------------+-----------+
| varname | grouptitle | value | defaultvalue | optioncode | displayorder | advanced | volatile | datatype | product | validationcode | blacklist |
+------------+------------+----------+--------------+------------+--------------+----------+----------+----------+-----------+----------------+-----------+
| cookiepath | http | /forums/ | / | cookiepath | 20 | 0 | 1 | free | vbulletin | | 1 |
+------------+------------+----------+--------------+------------+--------------+----------+----------+----------+-----------+----------------+-----------+
1 row in set (0.00 sec)