Login Problems after Update

Fatih
User w
User w
Posts: 6
Joined: Tue Jun 02, 2020 10:44 am

Login Problems after Update

Post by Fatih »

Hello,

first of all here some information about my config:
WP = Latest Version
PHPBB = 3.2.2
Plugin Version 1.9.5

Yes I know the plugin version is old, the reason is whe have so much problems after updates in the past, and now i tried again to update to the letest Version but after the update i was not able to login to WP (wp-admin). I go back to Vewrsion 1.9.5 and tried to update Version by Version und figuered out that after Updating to 1.9.8 its not working and i have to disable the plugin and on the plugins config page getting following massage:
WARNING
Error establishing a phpBB database connection.
The w3all integration plugin will not work properly (widgets, shortcodes).
Integration Running as USERS NOT LINKED until this message display.
Check db connection values into linked phpBB config.php file.

Any ideas how can i fix this ?

thanks

User avatar
axew3
w3all User
w3all User
Posts: 1957
Joined: Fri Jan 22, 2016 5:15 pm
Location: Italy
Contact:

Re: Login Problems after Update

Post by axew3 »

Are you sure the config.php you going to include contain correct values i assume, and the path to the file is correct, and if not on latest 2.3.5 version,
this line (on bottom of the custom config.php file)

Code: Select all

//@define('PHPBB_INSTALLED', true);
has not been changed into this?

Code: Select all

@define('PHPBB_INSTALLED', true);
because if all values are ok, and you're not including the default phpBB root config.php file, this can be a reason.
Did you changed something on mysql server, then may you need to specify the mysql port to connect to?
Why you do not update to latest 2.3.5? ARe you in phpBB 3.2> or 3.3.0?

User avatar
axew3
w3all User
w3all User
Posts: 1957
Joined: Fri Jan 22, 2016 5:15 pm
Location: Italy
Contact:

Re: Login Problems after Update

Post by axew3 »

P.s about the login: until the above message display, the integration plugin do not affect any way the login in wordpress. The password do not match because the hash isn't recognized without integration plugin, that archive the pass in phpbb way.

Just reset password of the user via normal 'lost pass' procedure to login in wordpress, if you're in trouble.

Fatih
User w
User w
Posts: 6
Joined: Tue Jun 02, 2020 10:44 am

Re: Login Problems after Update

Post by Fatih »

Hi,

i am on PHPBB 3.2.2
My config.php looks like:

Code: Select all

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
//$dbms = 'mysql'; //database type it may not be mysql
$dbms = 'phpbb\db\driver\mysqli';
$dbhost = 'dbxxxxxxxxxx.com';
$dbport = '3306';
$dbname = 'dbxxxxxxx';
$dbuser = 'xxxxxxxx';
$dbpasswd = 'yyyyyyyyy';

$table_prefix = 'xyz_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
//@define('DEBUG', false);
//@define('DEBUG_EXTRA', false);

?>
i am pointing to the relative path of my phpbb installation

Fatih
User w
User w
Posts: 6
Joined: Tue Jun 02, 2020 10:44 am

Re: Login Problems after Update

Post by Fatih »

just updates the plugin to the latest version,
The Warning Massage ist the same and after some seconds i will be disconnected from https://simracing-united.net/wp-admin

And the latest version of zhe plugin also brakes my Login Widget on WP Site

Fatih
User w
User w
Posts: 6
Joined: Tue Jun 02, 2020 10:44 am

Re: Login Problems after Update

Post by Fatih »

Now Rollback to 1.9.5

What i do not understand is, why it brakes after Version 1.9.8, i can update to 1.9.6 and also to 1.9.7

Fatih
User w
User w
Posts: 6
Joined: Tue Jun 02, 2020 10:44 am

Re: Login Problems after Update

Post by Fatih »

Hi,

here a short update:

I dont know why but with a custom config.php which lokks like follows, everything its working with the latest version of the plugin.

Code: Select all

<?php defined( 'ABSPATH' ) or die( 'forbidden' ); 

// WP phpBB w3all - custom config.php phpBB configuration file

// note: COMMENT OUT ( add chars // ) on the very last line of this file to force wp_w3all deactivation

// note: vars have been renamed (respect to default phpBB config.php file) to avoid conflicts with external plugins that may have vars named as phpBB
// and that instantiate db calls after integration plugin code execution

// Open with a text editor your phpBB root config.php file
// Change following values and setup according (like on) to your phpBB root config.php file 

$w3all_dbms = ''; // maybe required
$w3all_dbhost = 'yyyyyyyyyyyy.com';
$w3all_dbport = ''; // maybe required
$w3all_dbname = 'dbyyyyyyyyyyy';
$w3all_dbuser = 'zzzzzzzzzzzzz';
$w3all_dbpasswd = 'xxxxxxxxx';
$w3all_table_prefix = 'xyz_';
$w3all_phpbb_adm_relative_path = ''; // maybe required
$w3all_acm_type = ''; // maybe required

@define('WP_W3ALL_MANUAL_CONFIG', true);
// NOTE 
// you can comment out the following line, and force plugin deactivation
@define('PHPBB_INSTALLED', true);

Fatih
User w
User w
Posts: 6
Joined: Tue Jun 02, 2020 10:44 am

Re: Login Problems after Update

Post by Fatih »

@axew3,

could you add this, as a option ?
https://www.axew3.com/w3/forum/?coding= ... E0I3AyNzE0

because after every update i have to modify the files.

I this this would be also a usefull option for others ;)

Thanks in advance

best regards

User avatar
axew3
w3all User
w3all User
Posts: 1957
Joined: Fri Jan 22, 2016 5:15 pm
Location: Italy
Contact:

Re: Login Problems after Update

Post by axew3 »

It should be already! If something you note that do not work as expected let know!
2.3.5 should allow +- any phpBB username to be added into wordpress, if it is not because it contain the character ' (for example), the user will be notified. I still recommend you to avoid and setup phpBB not allow special chars to be used as usernames if you let register users into phpBB, that then will be added into wordpress. Note that specials chars into wordpress usernames, aren't rendered/parsed correctly, so may the username in wp side appear/display not complete (even if all will work fine)

I've not follow to go deep into this aspect, that may could be covered more exactly maybe, to render correctly any username containing special chars.

Post Reply