All user's password dose not work on the New server.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gamevilcom2us
    New Member
    • Jun 2018
    • 7
    • 5.3.x

    All user's password dose not work on the New server.

    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)
    Last edited by gamevilcom2us; Wed 5 Sep '18, 3:42pm.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...