EVE Technology Lab

Hi all,

This is a beta version of a phpBB extension that enables Single sign on for registration and login to the phpBB forum software: Downloads

Current version: 1.1b

Update procedure (coming from a previous version of THIS extension):

1. Disable the extension. (DO *NOT* clear the data)
2. Exchange the extension folder.
3. Purge your forums cache.
4. Reenable

Current features:

• phpBB auth provider (replaces regular login completely)
• Login / Registration using EVE accounts
• Group management based on corp / alliance (using ESI to fetch)
• Teamspeak serverGroup management based on corp / alliance
• Display users corp / alliance below the user name

Requirements:

• phpBB 3.2 or above
• php5.5 or above with php-curl installed
• A valid EVE Online subscription (you need one to register a developer app.)

Installation and setup:

This extension is under development, if you install it on anything but a fresh and empty board, backup your database and files now.

1. Upload the contents of the zip to your forum root (the zip should already contain the directory structure /ext/snitch/authevesso)
2. Go to the ACP
3. Enable the extension under 'Customise', if it doesnt show up check the directory structure.
4. Go to developers.eveonline.com and create an App, select API access the scope esi-corporations.read_corporation_membership.v1, set the callback url to server/forumurl/authevesso/login
5. Go to you forum ACP: General - Client communication - Authentication
6. Enter your app id and secret you got in the above step, as well as the Admin character name (Important: This has to be an eve character you will use from now on to log in as admin. If this char already exists as a board user, make him a founder and grant all permissions now.)
7. Save Settings
8. Change authentication method to Evesso and save.
9. Log in with the admin EVE char and purge the forum cache in the ACP.
10. Start adding Groups / Teamspeak groups under 'Extensions'

if something goes wrong and you locked yourself out, access your database and find the key auth_method in your phpbb_config table and change it from 'evesso' to 'db'.


To do:

• Implement logging
• Testing
• Better session management (when logging in from multiple devices)
• ???

A few notes how its working:

This extension automatically creates a forum user account for evey user that logs in with his eve account.
It only handles the groups configured in the extensions ACP menu, it will not add OR REMOVE from any of the groups / teamspeak groups not entered there.
phpBB3.1+ has a new cron system. if you wish to run the cron jobs manually, the command to do so is: php _install_dir_/bin/phpbbcli.php cron:run (set to run e.g. once in 15 minutes, dont worry, the actual jobs run at different intervals) In that case, go to your boards server settings and set 'run periodic tasks from system...' to 'yes'.


Credits:

Inspired by EVE API for phpBB 3.0 by Cyerus and phpBB 3.1 Authentication Provider for Shibboleth
Using the Teamspeak PHP framework
ESI client generated using swagger codegen


Translations:

English
Russian


Speacial thanks:

Jintaro Keo for a lot of testing and the russian translation


Happy testing,

Report any bugs you ancounter here or to admin@brgf.de
If you wanna support this project, feel free to throw some ISK at Snitch Ashor

o7, Snitch

It is amazing!

Hmmm weird, that column should have been installed with the mod. Will try it myself on a fresh install.

That is related to the first I guess, looks like the migration that installs database tables and columns is not executed at all in your case, will try to figure out what went wrong. If you want to retry you have to deinstall the mod and delte all data of the mod in the customization tab.

If you could try the following please:

Disable the mod.
Delte Data for the mod.

Reenable it and give it a try. If the same error occurs, here's how to create the DB entries required:

ALTER TABLE phpbb_users ADD (
  `user_refreshToken` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `user_characterID` bigint(20) DEFAULT NULL,
  `user_lastAPI` int(11) UNSIGNED DEFAULT NULL,
  `user_APIfailcount` mediumint(8) UNSIGNED DEFAULT NULL
);

ALTER TABLE phpbb_sessions ADD (
  `session_authstate` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `session_refreshToken` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `session_characterID` bigint(20) DEFAULT NULL,
  `session_characterName` varchar(100) COLLATE utf8_bin DEFAULT NULL
);

CREATE TABLE `phpbb_authevesso_groups` (
  `id` bigint(20) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `type` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_group` mediumint(8) UNSIGNED DEFAULT NULL,
  `ts_group` mediumint(8) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Thanks for reporting back, could you do one more quick check just look if the file

_phpBBinstall_/phpbb/db/migration/migration.php is present and tell me what php version you are running please?

Thanks.

Btw since all migrations require that class, the one that creates the profile field to enter the teamspeakID might be missing as well. You can just create it under users-> custom profile fields:

Identifier: authevesso_tsid Type: single text field.

Publicly display profile field: NO and the only options that should be ticked are:
Display in user control panel
Hide profile field

Yeah you are right. You can disable board registration yourself for now in the ACP. I will either disable the button or just forward registration to the sso as well.

Cool project

I installed it without a hitch, but when I enable authentication, I will get a 404 error when trying to hit the login button.

The 404 is for forums.domain.tld/authevesso/login (my phpbb install is not in a subdirectory)

Any ideas on this one ?

Will have to try and reproduce it. If you feel like trying it on a subfolder, let me know if it works.

Quick update:

Made a new VM to test this on, completley vanilla ubuntu 16.10 , just installed mod_php, apache2, phpmyadmin, and mysql. installed a fresh version of phpbb 3.2 and added your plugin, so far so good..

after installing, and activating the plugin, I cannot access the /authevesso/login url (http://172.16.32.149/phpbb/authevesso/login?target=http%3A%2F%2F172.16.32.149%2Fphpbb%2Findex.php)

The mysql version is probably not the issue, the default apache configuration may be. As I stated, I'm running a unmodified apache conf except for enabling mod_rewrite.