Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Resolved
-
3.3.7
-
None
-
None
-
[I] dev-lang/php
Available versions:
(7.4) 7.4.28-r1^t
(8.0) 8.0.16-r1^t ~8.0.18^t ~8.0.19^t
(8.1) ~8.1.5^t ~8.1.6^t
{acl apache2 apparmor argon2 bcmath berkdb bzip2 calendar cdb cgi cjk +cli coverage +ctype curl debug embed enchant exif ffi +fileinfo +filter firebird +flatfile fpm ftp gd gdbm gmp +iconv imap inifile intl iodbc ipv6 +jit +json kerberos ldap ldap-sasl libedit lmdb mhash mssql mysql mysqli nls oci8-instant-client odbc +opcache pcntl pdo +phar phpdbg +posix postgres qdbm readline selinux +session session-mm sharedmem +simplexml snmp soap sockets sodium spell sqlite ssl systemd sysvipc test threads tidy +tokenizer tokyocabinet truetype unicode webp +xml xmlreader xmlrpc xmlwriter xpm xslt zip zlib}
Installed versions: 7.4.28-r1(7.4)^t(13:10:20 04/29/22)(acl apache2 bcmath bzip2 cgi cli ctype curl exif fileinfo filter flatfile ftp gd gdbm iconv intl ipv6 jit json mysql mysqli nls opcache pdo phar posix postgres readline session simplexml spell sqlite ssl tidy tokenizer truetype unicode xml xmlreader xmlwriter zip zlib -argon2 -berkdb -calendar -cdb -cjk -coverage -debug -embed -enchant -ffi -firebird -fpm -gmp -imap -inifile -iodbc -kerberos -ldap -ldap-sasl -libedit -lmdb -mhash -mssql -oci8-instant-client -odbc -pcntl -phpdbg -qdbm -selinux -session-mm -sharedmem -snmp -soap -sockets -sodium -systemd -sysvipc -test -threads -tokyocabinet -webp -xmlrpc -xpm -xslt) 8.0.16-r1(8.0)^t(21:31:59 06/08/22)(acl apache2 bcmath bzip2 cgi cli ctype curl exif fileinfo filter flatfile ftp gd gdbm iconv intl ipv6 jit mysql mysqli nls opcache pdo phar posix postgres readline session simplexml sodium spell sqlite ssl tidy tokenizer truetype unicode xml xmlreader xmlwriter zip zlib -apparmor -argon2 -berkdb -calendar -cdb -cjk -coverage -debug -embed -enchant -ffi -firebird -fpm -gmp -imap -inifile -iodbc -kerberos -ldap -ldap-sasl -libedit -lmdb -mhash -mssql -oci8-instant-client -odbc -pcntl -phpdbg -qdbm -selinux -session-mm -sharedmem -snmp -soap -sockets -systemd -sysvipc -test -threads -tokyocabinet -webp -xpm -xslt)
Homepage: https://www.php.net/
Description: The PHP language runtime engine
[I] dev-db/sqlite
Available versions: (3) 3.38.2^t 3.38.3^t ~3.38.5^t
{debug doc icu +readline secure-delete static-libs tcl test tools ABI_MIPS="n32 n64 o32" ABI_S390="32 64" ABI_X86="32 64 x32"}
Installed versions: 3.38.3(3)^t(20:17:16 06/06/22)(readline -debug -doc -icu -secure-delete -static-libs -tcl -test -tools ABI_MIPS="-n32 -n64 -o32" ABI_S390="-32 -64" ABI_X86="64 -32 -x32")
Homepage: https://sqlite.org/
Description: SQL database engine
[I] dev-lang/php Available versions: (7.4) 7.4.28-r1^t (8.0) 8.0.16-r1^t ~8.0.18^t ~8.0.19^t (8.1) ~8.1.5^t ~8.1.6^t {acl apache2 apparmor argon2 bcmath berkdb bzip2 calendar cdb cgi cjk +cli coverage +ctype curl debug embed enchant exif ffi +fileinfo +filter firebird +flatfile fpm ftp gd gdbm gmp +iconv imap inifile intl iodbc ipv6 +jit +json kerberos ldap ldap-sasl libedit lmdb mhash mssql mysql mysqli nls oci8-instant-client odbc +opcache pcntl pdo +phar phpdbg +posix postgres qdbm readline selinux +session session-mm sharedmem +simplexml snmp soap sockets sodium spell sqlite ssl systemd sysvipc test threads tidy +tokenizer tokyocabinet truetype unicode webp +xml xmlreader xmlrpc xmlwriter xpm xslt zip zlib} Installed versions: 7.4.28-r1(7.4)^t(13:10:20 04/29/22)(acl apache2 bcmath bzip2 cgi cli ctype curl exif fileinfo filter flatfile ftp gd gdbm iconv intl ipv6 jit json mysql mysqli nls opcache pdo phar posix postgres readline session simplexml spell sqlite ssl tidy tokenizer truetype unicode xml xmlreader xmlwriter zip zlib -argon2 -berkdb -calendar -cdb -cjk -coverage -debug -embed -enchant -ffi -firebird -fpm -gmp -imap -inifile -iodbc -kerberos -ldap -ldap-sasl -libedit -lmdb -mhash -mssql -oci8-instant-client -odbc -pcntl -phpdbg -qdbm -selinux -session-mm -sharedmem -snmp -soap -sockets -sodium -systemd -sysvipc -test -threads -tokyocabinet -webp -xmlrpc -xpm -xslt) 8.0.16-r1(8.0)^t(21:31:59 06/08/22)(acl apache2 bcmath bzip2 cgi cli ctype curl exif fileinfo filter flatfile ftp gd gdbm iconv intl ipv6 jit mysql mysqli nls opcache pdo phar posix postgres readline session simplexml sodium spell sqlite ssl tidy tokenizer truetype unicode xml xmlreader xmlwriter zip zlib -apparmor -argon2 -berkdb -calendar -cdb -cjk -coverage -debug -embed -enchant -ffi -firebird -fpm -gmp -imap -inifile -iodbc -kerberos -ldap -ldap-sasl -libedit -lmdb -mhash -mssql -oci8-instant-client -odbc -pcntl -phpdbg -qdbm -selinux -session-mm -sharedmem -snmp -soap -sockets -systemd -sysvipc -test -threads -tokyocabinet -webp -xpm -xslt) Homepage: https://www.php.net/ Description: The PHP language runtime engine [I] dev-db/sqlite Available versions: (3) 3.38.2^t 3.38.3^t ~3.38.5^t {debug doc icu +readline secure-delete static-libs tcl test tools ABI_MIPS="n32 n64 o32" ABI_S390="32 64" ABI_X86="32 64 x32"} Installed versions: 3.38.3(3)^t(20:17:16 06/06/22)(readline -debug -doc -icu -secure-delete -static-libs -tcl -test -tools ABI_MIPS="-n32 -n64 -o32" ABI_S390="-32 -64" ABI_X86="64 -32 -x32") Homepage: https://sqlite.org/ Description: SQL database engine
Description
On Gentoo Linux, I installed:
[I] www-apps/phpBB
Available versions: (3.3.7) (~)3.3.7
{ftp gd mssql mysqli postgres sqlite vhosts zlib}
Installed versions: 3.3.7(3.3.7)(23:46:32 04/16/22)(ftp gd mysqli postgres sqlite vhosts zlib -mssql)
Homepage: https://www.phpbb.com/
Description: An open-source PHP-based bulletin board package
My PHP is set to 8.0, see environment below.
I do have the package configured so I can use mysqli postgres later on; I wanted to start with SQLIte to keep this simple.
When I performed the install, I did not has "sodium" specified as a USE flag, so the PHP 8.0 operative during the installation of phpBB was without "sodium". I am inferring sodium is some sort of salting routine for encrypted passwords.
I was able to create a user admin account and password and proceeded with configuring my site, e.g. create new forums. 24 hours later I return and tried to log in and could not, returned in red after each attempt is "The submitted form was invalid. Try submitting again".
I recall seeing error messages about no database or SQLite issues, but the installation continued on and completed, so I assumed those were status messages and the installer rectified, e.g. by creating new tables &etc.
So I moved the install directory to de-activate it and tried logging in, but could not. I restored the install directory and cannot seem to find a way to access the Administrative Control Panel (aka "ACP").
As root, I logged into the SQLite3 database and created an entry as follows:
INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
This work-around of adding an entry in phpbb_users comes from: https://www.phpbb.com/community/viewtopic.php?t=2573941
I have attempted to login with Admin1/admin1 and get the same error message.
I recompiled php 8.0 adding sodium as a "USE" item and restarted apache and my login attempts continue to fail.
I've been blocked for over two hours on this. What can I do to move forward?