EVE Forums

 
Capture Portrait
  • Date of Birth: 2011-07-07 21:26
  • First Forum Visit: 2012-03-04 12:47
  • Number of Posts: 83
  • Bounty: 0 ISK
  • Likes Received: 24

Snitch Ashor

Security Status -9.8
  • Black Rise Guerilla Forces Member since
  • The Bloc Member since

Last 20 Posts

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Changed links and description in the OP. Changed version number to 1.1b. I hope in the following weeks I find the time for a few new features I got requests for.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Dan Conia wrote:
    Norian Lonark wrote:
    Snitch Ashor wrote:


    in principle this can be done. I did a quick search and found this: https://www.mediawiki.org/wiki/Extension:PHPBB/Users_Integration

    might work.

    Cheers,
    Snitch


    Hi Snitch,

    thanks for the check I will have a go at installing it and see what happens when using it in combination with your mod.

    Nori.


    Nori, I noticed an extension that piggybacks on the login of the phpBB. You then just go to your wiki site and it checks phpBB to see if you're a current login.

    Extension:PHPBB/Users Integration

    Edit: Wow, I got so hung up on SSO, I didn't realize you had already posted THE EXACT SAME THING. LOL MOAR COFFEE!!!


    No problem, as my time to code/play is limitd tjese days, any help is appreciated.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Dan Conia wrote:
    Hello, all. I seem to be getting an extra ":80" in my callback URL. Note just after the ".com". This results in the "The callback URI doesn't match the value stored for this client" error.

    https://login.eveonline.com/oauth/authorize/?response_type=code&redirect_uri=https%3A%2F%2Ftaggarttransdimensional.com%3A80%2Fphpbb%2Fapp.php%2Fauthevesso%2Flogin


    I thought I would be clever and try adding it to the callback in the EVE Developers site, but then nothing else works.

    If I try manually editing the browser call it works without an issue.

    Does anybody know where this ":80" is coming from?

    Great extension otherwise. I'm hoping I can contribute in some way (including the wiki question!).

    Thanks.



    Hi,

    to be honest i am not sure how the port ended up there since it's a standard one. Are you using https over port 80?

    Could you double check you got the following settings in you phpbb ACP under Server config/Server settings:

    Server protocol: https://
    Server port: 443

    if this is already the case could you please try:

    Force server URL settings: yes

    Bests,
    Snitch

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Norian Lonark wrote:
    Hi Snitch,

    is there anyway with this that you can use the phpbb authentication for other services. I really want to be able to use dokuwiki or mediawiki for our wiki solution. Currently we use temars plugin for SMF and its quite easy to then authenticate the wiki against the smf database so the user can use the same username and password.

    With this plugin it seems that the user doesn't actually get a password or anything on the forum? or can they set one on their forum profile and the SSO will still work.

    Basically I am just looking for a way that a user could authenticate against the forums and also use the forum account for the WIKI.

    sorry if this is off topic I am not wanting to hijack or take time.. but am searching for a straight forward solution and I may be missing something simple and obvious due to my own limitations of understanding these technical things Lol



    in principle this can be done. I did a quick search and found this: https://www.mediawiki.org/wiki/Extension:PHPBB/Users_Integration

    might work.

    Cheers,
    Snitch

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Norian Lonark wrote:
    Snitch Ashor wrote:
    Syenna Celeste wrote:
    Milo Caman wrote:
    [
    EDIT 3: Changing the URL by removing '%2Fapp.php' manually allows me to login with SSO enabled. This suggests that mod_rewrite might not be working properly? Also the 'Extensions' tab seems to be missing once I get back into ACP with everything enabled.


    Fixed (we think).


    Line 115 login.php.

    Old: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/app.php/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;


    New: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;


    Thanks, did overlook that. So you can use that change for now, or change the callback at the eve dev page.

    EDIT: Just pushed a fix here: https://bitbucket.org/snitchashor/php-ext-authevesso/downloads/php-ext-authevesso-v1.0.7a.zip

    In order not to get locked out. If you had used version <= 1.0.5 and it worked, got to ACP -> General -> Server Confg. -> Server and domain and enable url rewriting.

    After that continue normal:

    disable the extension, update files, clear chache, reenable


    Firstly thank you very much for working on this great mod. I just wanted to check with you but I downloaded the latest version but still have this issue of the rewrite not looking like its working. I corrected it by manually changing the callback on the development page and adding the /app.php/ to the beginning of the path after my forum url. Just wondered if you had any ideas?


    Just to make sure...

    You enabled rewriting in the ACP right? And at the acp page where you enter your dev key, what callback url is given there?

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Morg Yard wrote:
    Question

    All works fine, but we have multiple forum founders, and one of them cant login to forum with following error:

    Quote:
    Username already exists but is not linked to an EVE account


    Character linking with already created account is enabled in ACP->Extention config

    Please help us to resolve this issue.

    What?



    This is a security feature, linking existing accounts that have extended permissions (like admin or founder) is not working, because people might have user accounts like admin or administrator and there are actually eve characters named like this. The one exception is the admin user that you explicitly specify, so here's what you can do:

    Change the admin user in the authentication settings to the one you want to link, heave him log in, repeat with the next founder.

    Sorry I'm not gonna change this behaviour as this would introduce a huge security hole.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    The output of cron:list is:


    Ready tasks:
    ============

    * cron.task.core.tidy_cache
    * cron.task.core.tidy_search
    * cron.task.core.tidy_sessions
    * cron.task.core.tidy_warnings

    Not ready tasks:
    ================

    * cron.task.core.prune_all_forums
    * cron.task.core.prune_forum
    * cron.task.core.prune_shadow_topics
    * cron.task.core.prune_notifications
    * cron.task.core.queue
    * cron.task.core.tidy_database
    * cron.task.core.tidy_plupload
    * cron.task.text_reparser.pm_text
    * cron.task.text_reparser.poll_option
    * cron.task.text_reparser.poll_title
    * cron.task.text_reparser.post_text
    * cron.task.text_reparser.user_signature


    After running cron:run, everything is moved to the 'Not ready' section. I assume that the groups.check task should be included in this list?


    Hmmm the cron job is missing completely. I'm kinda lost here. May I ask you to do a clean phpbb3.2 install in parralel and try the latest version? You still have some leftovers of the first version which may or may not be the issue

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    When I tried to run it manually, I just navigated to /ext/snitch/authevesso/cron and ran the script with php.

    Trying to run the task from cli gives me the following:


    php bin/phpbbcli.php cron:run cron.task.groups_check


      [RuntimeException]
      Could not find cron task “cron.task.groups_check”.


    Can you please post the output of
    php bin/phpbbcli.php cron:list

    If groups_check shows up as ready to be run please run

    php bin/phpbbcli.php cron:run

    Which runs all crons and then list again to check if groups moved to the not ready Section.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    New day, new problem!

    Looks like the groups_check.php cronjob isn't being run by the system. I don't seem to be able to run it manually either as it returns the below:

    Class 'phpbb\cron\task\base' not found in /var/www/html/forum/ext/snitch/authevesso/cron/groups_check.php on line 20


    I'm going to go out on a limb and assume that this is migration-related, but I'm not really sure how phpbb handles it's internal crons. I had a poke around, but I'm feeling a bit lost in it all. Any ideas?


    No for once this has nothing to do with the migrations. Looks like its unable to find the cron base class which is part of phpbb. How did you try to run the cron job manually? It requires the phpbb enviroment so if you want to run it manually, try php path_to_forum/bin/phpbbcli.php cron:run cron.task.groups_check and let me know if that works.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    mysql does not like this query at all and makes a big fuss about the backslash characters, should it just be something like:

    DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = '\snitch\authevesso\migrations\add_module_100';

    instead?

    EDIT: The exact output is:

    mysql> DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'
    ERROR:
    Unknown command '\''.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\\'.
    ERROR:
    Unknown command '\''.
        -> ;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'' at line 1


    DELETE FROM phpbb_migrations WHERE migration_name = '\snitch\authevesso\migrations\add_module_100'; should do.

    Edit: If you havent done this yet can you check in the acp-system-module management-acp, in the very bottom there should be a dropdown and one of the entries should be something like snitch/authevesso/main module.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    Doesn't look like it's a permissions issue, a regular admin doesn't see the extensions tab either.

    How would I go about removing the add_module_100 migrations row? With the mod disabled db:list no longer shows the migrations as installed or available. Would it be worth deleting the extension's data again or might this just cause further problems?


    That might work as well but i would just delete the table row first, e.g. using phpmyadmin if you have, if not, its

    DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    Installed migrations listed as per CLI output are:


    * \snitch\authevesso\migrations\add_table_100
    * \snitch\authevesso\migrations\version_104
    * \snitch\authevesso\migrations\version_101
    * \snitch\authevesso\migrations\profilefield_tsid_100
    * \snitch\authevesso\migrations\add_module_100


    The output from the query is as follows:


    Database changed
    mysql> SELECT * FROM `phpbb_migrations` WHERE `migration_name` LIKE '%snitch%';
    +-----------------------------------------------------+-----------------------------------------------------------------
    ---------------------------------------------------------------------------------------------------------------------+--
    ---------------------+---------------------+----------------------+----------------------+--------------------+
    | migration_name                                      | migration_depends_on
                                                                                                                         | m
    igration_schema_done | migration_data_done | migration_data_state | migration_start_time | migration_end_time |
    +-----------------------------------------------------+-----------------------------------------------------------------
    ---------------------------------------------------------------------------------------------------------------------+--
    ---------------------+---------------------+----------------------+----------------------+--------------------+
    | \snitch\authevesso\migrations\add_module_100        | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";}
                                                                                                                         |
                       1 |                   1 |                      |           1490953922 |         1490953923 |
    | \snitch\authevesso\migrations\add_table             | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";}
                                                                                                                         |
                       1 |                   1 |                      |                    0 |                  0 |
    | \snitch\authevesso\migrations\add_table_100         | a:1:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";}
                                                                                                                         |
                       1 |                   1 |                      |           1490953923 |         1490966569 |
    | \snitch\authevesso\migrations\profilefield_tsid     | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types"
    ;}                                                                                                                   |
                       1 |                   1 |                      |           1489791031 |         1489791031 |
    | \snitch\authevesso\migrations\profilefield_tsid_100 | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types"
    ;}                                                                                                                   |
                       1 |                   1 |                      |                    0 |                  0 |
    | \snitch\authevesso\migrations\version_101           | a:3:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";i:1
    ;s:43:"\snitch\authevesso\migrations\add_table_100";i:2;s:51:"\snitch\authevesso\migrations\profilefield_tsid_100";} |
                       1 |                   1 |                      |           1490966569 |         1490966569 |
    | \snitch\authevesso\migrations\version_104           | a:1:{i:0;s:41:"\snitch\authevesso\migrations\version_101";}
                                                                                                                         |
                       1 |                   1 |                      |           1490966569 |         1490991678 |
    +-----------------------------------------------------+-----------------------------------------------------------------
    ---------------------------------------------------------------------------------------------------------------------+--
    ---------------------+---------------------+----------------------+----------------------+--------------------+
    7 rows in set (0.01 sec)


    It's a bit messy but hope it helps?

    EDIT: New users are now reporting the following error when attempting to log in for the first time:

    General Error
    SQL ERROR [ mysqli ]

    Incorrect integer value: '' for column 'user_avatar_width' at row 1 [1366]


    Guessing this is related to the migrations not being installed properly?


    This is due to the fact that you can not access the acp settings and set the avatar size. Can you please disable the mod, clear the cache, and delete the migrations row \snitch\authevesso\migrations\add_module_100 and then reenable it? Also please check if the extensions tab is present if you disable the extension and log in with your regular admin account, might be a permission problem...

    Edit: Please check with disabled mod and regular admin first. If it shows up there, please do the following: Reenable the mod, search the phpbb_users table for you admin eve char, delete the row and log in with that character again, it should show up now.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    Snitch Ashor wrote:
    Milo Caman wrote:
    Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks Smile

    Still not seeing the extensions tab though. Were some functions moved elsewhere?


    I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce.


    Hrm.

    Would running the query from before fix this? Is it even possible to do the migrations manually via the cli or mysql?


    Sorry no. There are three migrations, one does database stuff, one installs the acp module and one inserts the teamspeak profile field. Can you check if the last one is there?

    And can you please run the following sql query send me the output:
    SELECT * FROM `phpbb_migrations` WHERE `migration_name` LIKE '%snitch%'

  • html formatting used in EVE mails in EVE Technology and Research Center

    Vex Munda wrote:
    Hey,

    Does anyone happen to know what kind of html EVE uses for the mails inside the game? It seems to be an old html style. (it doesn't recognise div elements for example)

    Would there be an easy trick to turn modern html into the old style? Or should I write some custom javascript to edit the html to the old style?



    As far as I can tell its a subset of html4. Lots of stuff is done using font tags. Lists, divs and img tags do not work. The ingame mail viewer also has the bad habit of interpreting br tags as well as linux and/or windows style /r/n line breaks.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks Smile

    Still not seeing the extensions tab though. Were some functions moved elsewhere?


    I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Syenna Celeste wrote:
    Milo Caman wrote:
    [
    EDIT 3: Changing the URL by removing '%2Fapp.php' manually allows me to login with SSO enabled. This suggests that mod_rewrite might not be working properly? Also the 'Extensions' tab seems to be missing once I get back into ACP with everything enabled.


    Fixed (we think).


    Line 115 login.php.

    Old: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/app.php/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;


    New: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;


    Thanks, did overlook that. So you can use that change for now, or change the callback at the eve dev page.

    EDIT: Just pushed a fix here: https://bitbucket.org/snitchashor/php-ext-authevesso/downloads/php-ext-authevesso-v1.0.7a.zip

    In order not to get locked out. If you had used version <= 1.0.5 and it worked, got to ACP -> General -> Server Confg. -> Server and domain and enable url rewriting.

    After that continue normal:

    disable the extension, update files, clear chache, reenable

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    This is due to a fix I added for people without mod rewrite. The mod nowbtells in the authentication settings what the callback should be. In your case, since you obviously have mod rewrite, go to acp -> general -> server config -> server and domain and enable url rewriting, clear the cache and it should be working.

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    https://bitbucket.org/snitchashor/php-ext-authevesso/get/44c15b1fc830.zip should fix it...

    This fix should only be required for mysql >= 5.6 for all others v1.0.6a should be fine

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    It's now throwing the error about the duplicate column again.

    I'm running on mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64). Hope this helps?


    Can you delete the columns? I think i got the migrations right now, but with previous versions this might be an issue. Also clearing the extensions data should remove the columns

  • phpBB 3.2 EVE SSO / ESI extension [beta] in EVE Technology and Research Center

    Milo Caman wrote:
    When attempting to update, I'm getting the following message when trying to re-enable the extension:


    General Error
    SQL ERROR [ mysqli ]

    Duplicate column name 'user_refreshToken' [1060]

    SQL

    ALTER TABLE `phpbb_users` ADD COLUMN `user_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: 999
    CALL: trigger_error()

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

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

    FILE: [ROOT]/phpbb/db/tools/tools.php
    LINE: 1269
    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: 711
    CALL: call_user_func_array()

    FILE: [ROOT]/phpbb/db/migrator.php
    LINE: 658
    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: 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: 185
    CALL: phpbb\extension\base->enable_step()

    FILE: [ROOT]/includes/acp/acp_extensions.php
    LINE: 197
    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()


    Any ideas?


    EDIT:

    Attempts to install the latest version on a completely fresh install of phpbb yields the following when trying to enable the extension:

    General Error
    SQL ERROR [ mysqli ]

    All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead [1171]

    SQL

    CREATE TABLE phpbb_authevesso_membership ( characterID bigint(20) NULL, corporationID bigint(20) NULL, corporationName varchar(100) NULL, allianceID bigint(20) NULL, allianceName varchar(100) NULL, PRIMARY KEY (characterID) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

    BACKTRACE

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

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

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

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

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

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

    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: 711
    CALL: call_user_func_array()

    FILE: [ROOT]/phpbb/db/migrator.php
    LINE: 658
    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: 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: 185
    CALL: phpbb\extension\base->enable_step()

    FILE: [ROOT]/includes/acp/acp_extensions.php
    LINE: 197
    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()


    Should be fixed in this one: https://bitbucket.org/snitchashor/php-ext-authevesso/get/42c27894557b.zip

    Any chance you can tell me your mysql version?