phpBB 3.2 EVE SSO / ESI extension [beta]

@Snitch_Ashor
Great work but I’m experiencing an issue…

I followed all the steps provided but when I test the SSO login I get-

error: "invalid_request"
error_description: “Some parameters are either missing or invalid”

I’m using phpbb3.2.2 (rhea)

I can guarantee it’s a noob error on my part but I have no idea where I went wrong. Like I said, I’ve followed all the instructions provided… Any help would be hugely appreciated :slight_smile:

Is 10004 the port you also use to connect via the TS program? If so, thats not the query port.

So I assume you enteres your developer id and secret. Could you try another browser or a private browsing session? Most of the time its a cache issue

Yep, dev id and secret code entered as instructed…

Changed browser to Internet explorer from Firefox. Had slightly better luck in ie but still went wrong. This time I get and actual message:

This error (HTTP 400 Bad Request) means that Internet Explorer was able to connect to the web server, but the webpage could not be found because of a problem with the address.

…so at least ie is telling me something but I’m stumped…

The url (edited) is:
https://login.eveonline.com/oauth/authorize/?response_type=code&redirect_uri=http%3A%2F%2Fwww.mysite.com%2Fforums%2FphpBB3%2Fapp.php%2Fauthevesso%2Flogin%3Ftarget%3DXXXXXX%3D&client_id=&scope=esi-corporations.read_corporation_membership.v1&state=XXXXXXXX

app.php is in the correct location: site.com/forums/phpBB3/app.php

The 'XXXXXX’s are redacted bits of the URL which I’m presuming you don’t need to see and I shouldn’t be posting to a public forum. The only other alteration is that i’ve altered the site name…

Thanks for the response so far, anything you can suggest to shed some light on this would be a huge help :slight_smile:

The query port is 10011 and I just changed to it, but still not working

Or, TBF if anyone else can point out what I’m doing wrong that would be a huge help! :slight_smile:

Could you tell me your php version and could you check if php-curl is installed?

php version is 7.1.15
cURL is installed from what phpinfo is telling me…

Could you pm me your board url?

If I knew how to do that I would. I see no link anywhere for sending PM’s :man_facepalming:

Messaged you in game instead of trying to work it out :slight_smile:

I would like to say a huge thanks to @Snitch_Ashor for all the help I have recieved in getting myself up and running with this ESI extension, it now works brilliantly! :smile:

Did you check if you can login via telnet using your serveradmin credentials?

Hi @Snitch_Ashor , is it possible to change the EVE account that is the admin after the the extension is already set up?

You can change the admin account and once that one logs in, he becomes admin as well. The old one keeps its rights though and I need to check if this also works for existing acounts. Admin rights may be assigned on first login only.

Hi @Snitch_Ashor

First off, this is fantastic, second, i have found out the hardway after having to delete my forum because it didn’t like spaces in my name. I ran through your helpful guide, but even after changing the Mysql DB entry to Db again, it didn’t recover, i couldn’t get back to my original state no matter what i tried.

Anyway a fresh install and another characters name later, its working… however when i try to click the button to sign in to eve via the Forum, it throws up an error.

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

However, if i use the link that is on Devapps for the callback, it logs me in. If i logout it has to authenticate me everytime also.

Am i doing something wrong with the settings? Why can’t i log back in again via the forums but i can with this other link?

Any help would be appreciated:

Oh and P.S i have PHPBB version 3.2.2 and 7.0.27 for PHP version.

Also have Curl…

Help? :slight_smile:

hello An error occurred while uninstalling the modules to reinstall it
SQL ERROR [ mysql4 ]

Duplicate column name ‘session_refreshToken’ [1060]

SQL

ALTER TABLE phpbb_csessions ADD COLUMN session_refreshToken varchar(255) NULL

BACKTRACE

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

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

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

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1064
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1272
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 549
CALL: phpbb\db\tools\tools->sql_column_add()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 714
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 661
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 190
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()

Does this occur during reinstall or removal? And does the mod show up as uninstalled afterwards? If so removing the column session_refreshToken from the sessions table should do it.

This happened when deleting and reinstalling the mod.

also need help with ts.
what address to specify if the server on other hosting. and what login and password? My account TS, or login and pass to the server adm tools? all i try not work, dont display ts group