phpBB 3.2 EVE SSO / ESI extension [beta]

Thanks for the work on this.

A question - What will happen if I install this mod on a phpBB board with already existing users (the board used the default phpBB auth and Cyerus’ mod)?

I assume that the existing users will no longer be usable? Is there any way to migrate these users to the new extension so when they login with EVE SSO, they will be recognized as the same users (if they previously used Cyerus’ mod to register)?

Thanks.

Hello everyone! I’m building up my corporation forum and i would like to obtain the authentication using the EveSSO auth.
When i enter in the panel control pf the phpBB forum i have the option to use eve sso authentication to login but something is going wrong, the message i obtain when i test the login is this:

{“error”:“invalid_request”,“error_description”:“The callback URI doesn’t match the value stored for this client”}

I’ve set che the Client ID and the secret that i obtained into the developer page of EVE, the user agent is: phpbb_evesso {link to the forum}
And the callback is set to: https://{forum link}/forum/app.php/authevesso/login (as suggested by the administration panel)

Can someone help me?

There have been changes to the SSO server, it’s more strict now.
The version tagged 1.2.7 should work again.

User will be migrated, but only regular ones, no admins. I suggest making all admins regular users and promote them again after they logged in once. Not migrating admin users solely based on the character name is a security measure I think is necessary.

Hey Snitch, so currently I’m running phpBB 3.3.2 with PHP 7.4.12 DB server is ubuntu 18.04. Installs fine but when I test SSO I get Internal Error 500. The callback URL is set to “https://forumURL/authevesso/login” as the auth page on the board suggests, but the actual path to login.php is “https://forumURL/ext/snitch/authevesso/login” though neither works for me. If you have any insight on what I might be doing wrong it would be greatly appreciated. Thanks for all the hard work you’ve put in on this over the years!

Could you try to disable url rewriting under Server configuration -> server settings? That should give you a slightly different callback url that contains /app.php/ could you check if it works with this one?

Okay thats done, the Callback URL is now “https://forums.mywebsite.com/app.php/authevesso/login”. Still getting the 500 error though. “500 Internal Server Error / nginx/1.14.0 (Ubuntu)”.

Any chance you can get the webserver logs for this?

There’s a critical issue since the last SSO update. Nobody can create a new account.

The error is:

SQL ERROR [ mysqli ]
Data too long for column 'comment' at row 1 [1406]

Basically the columns data type is too small for the actual error text. Here is the actual error log it’s trying to insert:

[404] Client error: `GET https://esi.evetech.net/v4/characters/2118950597/?datasource=tranquility` resulted in a `404 Not Found` response:\n{\"error\":\"Not found\"}\n

Backtrace:


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 196
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/snitch/authevesso/classes/class.log.php
LINE: 20
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/snitch/authevesso/classes/class.helpers.php
LINE: 202
CALL: snitch\authevesso\AUTHEVESSO_LOG->add()

FILE: [ROOT]/ext/snitch/authevesso/cron/groups_check.php
LINE: 118
CALL: EVEHELPERS::getCorpForChar()

FILE: (not given by php)
LINE: (not given by php)
CALL: snitch\authevesso\cron\groups_check->run()

FILE: [ROOT]/phpbb/cron/task/wrapper.php
LINE: 104
CALL: call_user_func_array()

FILE: [ROOT]/cron.php
LINE: 78
CALL: phpbb\cron\task\wrapper->__call()

I guess it’s because of ESI v4 Character Route Removed - Please Update to V5

You can simply update from v4 to v5 in
forum\ext\snitch\authevesso\classes\esi\lib\Api\CharacterApi.php

Change line #325 to $resourcePath = ‘/v5/characters/{character_id}/’;

You can do that with other version changes too. I didn’t had any problems.

I could have sworn that I tried that already, but apparently I didn’t and now it’s fixed. Thanks!