phpBB • Free and Open Source Forum Software

Shohreh · by **Shohreh** » Thu Oct 06, 2022 7:33 pm

Hello,

Maybe I missed something in the install, but I can't get STK to let me access an old forum to which I don't have any user account, including Admin accounts.

Here's what I did:

Installed a fresh phpBB 3.0.4 + php5.6 using the "phpbbNEW_" prefix
Edited config.php to point to the old database in MariaDB through the "phpbb_" prefix
Installed STK in /var/www/html/forum/stk
Ran STK and copied its passwd.php in /var/www/html/forum/stk
Aimed http://192.168.0.7/forum/stk/, typed the password. It doesn't complain but… clicking on any item sends me back to the login page.

So I can't actually access the forum.

Any idea what's wrong?

Thanks for any help.

Shohreh · by **Shohreh** » Thu Oct 06, 2022 8:21 pm

Since I have acccess to the DB, can't I simply add a new superuser manually, with its password hashed in MD5?

Code: Select all

MariaDB [mytable]> describe phpbb_users ;
+--------------------------+-----------------------+------+-----+-----------+----------------+
| Field                    | Type                  | Null | Key | Default   | Extra          |
+--------------------------+-----------------------+------+-----+-----------+----------------+
| user_id                  | mediumint(8) unsigned | NO   | PRI | NULL      | auto_increment |
| user_type                | tinyint(2)            | NO   | MUL | 0         |                |
| group_id                 | mediumint(8) unsigned | NO   |     | 3         |                |
| user_permissions         | mediumtext            | NO   |     | NULL      |                |
| user_perm_from           | mediumint(8) unsigned | NO   |     | 0         |                |
| user_ip                  | varchar(40)           | NO   |     |           |                |
| user_regdate             | int(11) unsigned      | NO   |     | 0         |                |
| username                 | varchar(255)          | NO   |     |           |                |
| username_clean           | varchar(255)          | NO   | UNI |           |                |
| user_password            | varchar(40)           | NO   |     |           |                |
| user_passchg             | int(11) unsigned      | NO   |     | 0         |                |
| user_pass_convert        | tinyint(1) unsigned   | NO   |     | 0         |                |
…
| user_newpasswd           | varchar(40)           | NO   |     |           |                |
| user_form_salt           | varchar(32)           | NO   |     |           |                |
+--------------------------+-----------------------+------+-----+-----------+----------------+

Shohreh · by **Shohreh** » Thu Oct 06, 2022 8:31 pm

Indeed!

If you have access to the DB, you don't have to bother with STK: Just use eg. this site to turn a new password into its MD5 hash, paste it into the phpbb_users database, and you're good to go.

Code: Select all

UPDATE phpbb_users set user_password = 'someMD5hash' WHERE username='superuser';

phpBB • Free and Open Source Forum Software

Support Toolkit

[SOLVEDJust loops back to login screen after typing password - Support Toolkit

[SOLVEDJust loops back to login screen after typing password

Re: Just loops back to login screen after typing password

Re: Just loops back to login screen after typing password

advertisements