[SOLVED] After migrating DB, some users can't log on

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Shohreh
Registered User
Posts: 49
Joined: Tue Jun 17, 2014 11:32 am

[SOLVED] After migrating DB, some users can't log on

Post by Shohreh »

Hello,

We're having a serious issue after migrating phpBB from 3.0.4 to 3.3.8: Some users complain that 1) they can't log on with the account + password they used before, and 2) are not getting the email when clicking "Forgot my password".

It's likely more users can't log on and simply didn't bother asking for help.

Any idea what it could be? How to investigate?

Thank you.

---
Edit: I notice a lof of items added in the "Inactive users" part in the General tab.

Could it be accounts are turned off by default when migrating and need to be re-activated?

Or maybe the hashing changed to encrypt passwords, and the passwords are no longer valid?

---
Edit: FWIW, 3.0.4 ran on PHP 5.x, while 3.3.8 is running under PHP 7.4.32. Here's how it was configured by the hoster:

Code: Select all

'./configure' '--docdir=/opt/plesk/php/7.4/share/doc' '--infodir=/opt/plesk/php/7.4/share/info' '--localedir=/opt/plesk/php/7.4/share/locale' '--exec-prefix=/opt/plesk/php/7.4' '--sysconfdir=/opt/plesk/php/7.4/etc' '--includedir=/opt/plesk/php/7.4/include' '--prefix=/opt/plesk/php/7.4' '--libdir=/opt/plesk/php/7.4/lib64' '--sbindir=/opt/plesk/php/7.4/sbin' '--datadir=/opt/plesk/php/7.4/share' '--sharedstatedir=/opt/plesk/php/7.4/com' '--libexecdir=/opt/plesk/php/7.4/lib64' '--mandir=/opt/plesk/php/7.4/share/man' '--bindir=/opt/plesk/php/7.4/bin' '--localstatedir=/opt/plesk/php/7.4/var' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--disable-debug' '--disable-rpath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-litespeed' '--enable-phpdbg' '--enable-sockets' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--enable-xml' '--with-bz2' '--with-config-file-path=/opt/plesk/php/7.4/etc' '--with-config-file-scan-dir=/opt/plesk/php/7.4/etc/php.d' '--with-enchant=shared' '--with-gettext' '--with-gmp' '--with-iconv' '--with-kerberos' '--with-layout=GNU' '--with-libdir=lib64' '--with-libxml' '--with-openssl' '--with-pic' '--with-system-tzdata' '--with-zlib' '--without-gdbm' '--without-pear' '--enable-bcmath=shared' '--enable-dba=shared' '--enable-dom=shared' '--enable-fileinfo=shared' '--enable-gd=shared' '--with-webp=/var/jenkins/workspace/php-7.4-unix-aws/buck-out/gen/libs/webp/webp.files' '--enable-intl=shared' '--enable-json=shared' '--enable-mbregex' '--enable-mbstring=shared' '--enable-mysqlnd=shared' '--enable-pcntl' '--enable-pdo=shared' '--enable-phar=shared' '--enable-posix=shared' '--enable-soap=shared' '--enable-sysvmsg=shared' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-curl=shared' '--with-db4=/usr' '--with-freetype' '--with-imap=shared' '--with-imap-ssl' '--with-jpeg' '--with-ldap=shared' '--with-ldap-sasl' '--with-libedit' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=shared,mysqlnd' '--with-pdo-mysql=shared,mysqlnd' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-pgsql=shared,/usr' '--with-pdo-sqlite=shared' '--with-pgsql=shared' '--with-pspell=shared' '--with-snmp=shared,/usr' '--with-sqlite3=shared' '--with-tidy=shared,/usr' '--with-unixODBC=shared,/usr' '--with-xmlrpc=shared' '--with-xpm' '--with-xsl=shared' '--with-zip=shared' '--without-readline' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'PKG_CONFIG=/var/jenkins/workspace/php-7.4-unix-aws/rules/buck-out/gen/build/pkg-config.pex' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fno-strict-aliasing -pipe -Wno-unused-function' 'CPPFLAGS=' 'CXXFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic'
--
Edit: The server is set up to use the hoster's SMTP server. I'm not getting the mail when clicking on "Send a test email" in the "Email settings" section.

--
Edit: FWIW, in Client Communication > Authentication, I left the default "Apache":
DCC656B2-C72C-48B6-9652-CB58471AF880.png
--
Edit: I didn't know about the Maintenance > Error log.

Code: Select all

Email error
» EMAIL/SMTP
/adm/index.php

Ran into problems sending email at Line 1227. Response: 459 4.4.4 Relaying denied from IP address 185.133.x.y
I'll ask the hoster about that issue.

It look like users being unable to log on could indeed be due to upgrading PHP from 5 to 7 ("argon" hashing). Does it mean users must reset their passwords (once email works again) ?
Post Reply

Return to “[3.3.x] Support Forum”