Moving phpbb to new host results in passwords failing on destination.

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
oztkktzo4
Registered User
Posts: 13
Joined: Tue Feb 06, 2024 6:04 am

Moving phpbb to new host results in passwords failing on destination.

Post by oztkktzo4 »

Support Request Template
What version of phpBB are you using? phpBB 3.3.11
What is your board's URL? No answer given
Who do you host your board with? InterServer
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What extensions do you have installed? CP Add User
phpBB Media Embed PlugIn
Read other's topics Permission
VigLink
What styles do you currently have installed? prosilver
What language(s) is your board currently using? en_us
Which database type/version are you using? MariaDB
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? More or less a new install and have installed the above extensions and regular use for learning and prep for production. Nothing extraordinary that we know of.
Please describe your problem. Please see body.
Generated by SRT Generator

We're setting up a phpbb3 instance on a shared host and as part of it we're working through the backup/restore process for learning and in case of disaster that we have to rebuild. Following KB article 845 (0).
As the subject states none of the passwords work on the new destination. We're trying to figure out where the problem is.

Here's a general overview of the workflow.

Disable board
Back up DB via ACP > Maintenance > Backup choosing: Full, gzip, Select all.
Use rsync over ssh or scp to get all the files from source htdoc/phpbb3 to new destination.
Create new empty DB on dest to match source.
Create new DB user on dest to match source.
Using the same values on source config.php to the destination so no changes there.

$ gunzip < ../store/NAME_OF-FILE.GZ | mariadb -u USERNAME -p --default-character-set=utf8 DATABASE_NAME.

The board comes up fine except admin and user passwords fail.

Create an Admin1 user(using the INSERT... sql workaround from (1) ) with all rights and changed/reset the SMTP settings and the email addresses for the aforementioned users to the destination system. Then for each user, use the 'forgot my password' URL so that a new password reset link gets emailed. Then reset the password and upon logging in all is well. Setting the password manually for the users worked as well.

We've tried a few different combinations and re-ordering the steps in an effort to understand what is happening but are stuck. Seems like it would be a version mismatch between either mySQL or PHP? Or is it user error?

The source(shared host)
General > Welcome to phpBB
Database server: MySQL(i) 10.5.23-MariaDB-cll-lve
PHP version: 7.4.33

All of these failed password as destination:
Virtual Machine: Database server: 10.5.22-MariaDB, PHP version: 7.4.33
LAMPP 8.2.12 Database server: 10.4.32-MariaDB, PHP version: 8.2.12
LAMPP 7.4.33 Database server: 10.4.27-MariaDB, PHP version: 7.4.33

The KB article suggests:
..../install/database_update.php might be needed, but it doesn't exist from the shared host installation or a new clean installation. Which makes sense since the instructions state to delete that folder.

There was a post from 2015 (2) that suggested deleting the files:

Code: Select all

/cache/container_dotslash.php and
/cache/container_dotslashdotdotslash.php
which are not present on our installation.

Starting clean with a new 3.3.11 installation and restoring just the database doesn't help. The only thing that DOES work is when restoring to the exact same environment it came from. (tested on LAMPP)

My searching has come up empty. Is our use case valid? If it is, any tips on figuring this out?

If the use case is not valid, what would be the requirements for a restore? Using only exact matching versions on the source/destination(which we've come very close to on the VM attempt above)?

0. https://www.phpbb.com/support/docs/en/3 ... or-domain/
1. viewtopic.php?p=14820691#p14820691
2. viewtopic.php?p=14025671&sid=2b3500d2ab ... #p14025671


Thank-you.
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 28813
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier

Re: Moving phpbb to new host results in passwords failing on destination.

Post by Paul »

Make sure you use the same php versions on both locations. Depending on the version used, passwords saved in newer versions cant be read in older php versions .
User avatar
EA117
Registered User
Posts: 2162
Joined: Wed Aug 15, 2018 3:23 am

Re: Moving phpbb to new host results in passwords failing on destination.

Post by EA117 »

And not just "PHP versions" (which already were the same or higher version in the described tests), but specifically the enabled modules/extensions for the PHP installation you're moving the database to. Most typically, lack of having the "sodium" module for PHP available or enabled would prevent the hash support necessary to match passwords against saved hashes which had been produced on a server that did have the "sodium" module enabled.
oztkktzo4
Registered User
Posts: 13
Joined: Tue Feb 06, 2024 6:04 am

Re: Moving phpbb to new host results in passwords failing on destination.

Post by oztkktzo4 »

Thanks so much for this! I had given up because as you noted my PHP versions were the same and I hadn't checked back here for a while. You diagnosed the issue perfectly with the "sodium" module for PHP. Works like a charm now.
DPDISXR4Ti
Registered User
Posts: 6
Joined: Wed Jan 28, 2009 8:43 pm
Location: New York
Name: Brad

Re: Moving phpbb to new host results in passwords failing on destination.

Post by DPDISXR4Ti »

Curious if you moved TO InterServer or FROM Interserver?

We're considering moving our phpBB to InterServer and would be interested to hear feedback either way.

Thanks...
Brad

Return to “[3.3.x] Support Forum”