|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| WoW Raid Manager :: Forums :: Closed Support Questions | |||
|
|||
 WRM 3.5.0 phpbb3 bridge queryGo to page >> |
| Author | Post |
| Floodster |
| ||
 Joined: Thu Aug 21 2008, 07:10AM Posts: 8 | Hi, Nice work on 3.5.0 moving from 3.0.9.2 it is a big difference. Anyway my query, when doing a fresh installation of WRM and selecting to use phpbb3 it then asks which forum group should be associated and also a secondary group. Please correct me if I am wrong, but am I correct in thinking if I have 2 groups on my phpbb3 installation lets say "registered" and "member" if I set it to the "member" group on the WRM installation only people in that group on the phpbb3 installation are able to access? Just that I did set it that way as I dont want any registered user using the raid manager and only people who are members of the guild and it didn't seem to work, I created a test account on my forum and it was able to log in and use WRM? I know support is somewhat limited for bridges just wondered if anyone else noticed this? [ Edited Thu Aug 21 2008, 07:33AM ] | ||
| Back to top |
| Illydth |
| ||
  Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | Support for bridges is not limited. Anything I release as a bridge I fully support. :) Yea, you have the right concept, when you select a group it gets "access" to WRM to log in, anyone not of that group cannot log in. The reason there is a secondary group selection is so that you can setup a special group for access. As an example: My guild forums (e107, but it all works the same) have a group called "Members". These are full members in the guild, they have access to all the private forums, etc. However, we bring people in as "Initiates" or "Acolytes" depending on whether or not they're raid recruits or friends/family of other members. We really don't want non-full members signing up willy nilly to raids, we're a largish guild and spots are already tight. HOWEVER we also need to have our Initiates integrated into the raid force. You can see the difficulty. How this works then is we set "member" as the group with full access and then I set a second group called "wrm Access". When an initiate comes into the guild we grant them "wrm Access" rights to allow them to use the system. Once they become full members in the guild we change them from "wrm Access" to "Member" and they maintain full rights to WRM. Ok, so that's how it's SUPPOSED to work. :) When you say "it didn't seem to work" I assume what you mean is that you were able to create a test account on the forum under, say, the "registered" group and still log in to WRM even though you'd set "member" as the group access to WRM? If this is so please verify for me (in the database if possible) that your test user does not also belong to the "member" group.' I have a phpbb3 installation here and I'll see what I can do to re-produce this problem. --Illydth [ Edited Thu Aug 21 2008, 10:16AM ] - Douglas Wagner - Site Admin | ||
| Back to top |
| Floodster |
| ||
Joined: Thu Aug 21 2008, 07:10AM Posts: 8 | Thanks for the response, I just created a test user account on the phpbb3 installation which is only part of the registered group. Going to WRM it logged me in as a member. As for checking database level I am not 100% sure on how to do this, although I am technical so if you can give me some guidance I will check it. Could it be that I have a group for the phpbb3 installation called "Guild Member" which I use for guild members? as it isnt a predefined group? although this was the setting I chose on installation. | ||
| Back to top |
| Illydth |
| ||
Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | My big thing is to be careful with default groups. For instance in e107 there's a "members" group that automatically gets people placed into it when they sign up to the boards. In essence there's a "group" that defines users that aren't logged into the system, there's also a group that defines users who are. If you happen to use that group as your access then anyone who creates an account on your forums would have access to WRM. That said, I think there's a problem here. Let me look at it, more this afternoon. - Douglas Wagner - Site Admin | ||
| Back to top |
| Illydth |
| ||
Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | The one's confirmed, just need to figure out why it's doing this. - Douglas Wagner - Site Admin | ||
| Back to top |
| Illydth |
| ||
Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | What a wild goose chase. What you have found is actually unsupported functionality. Historically, the phpBB (v2) piece has never supported "by group" access to the system. It wasn't there when I got the software and it's not there now (verified in both the phpBB2 and phpBB3 auth systems). The only thing checked is the username and password vs the phpBB system, thus, anyone who is able to create a phpBB account on your system has login access to your WRM installation using these bridges. This is NOT the case for the other bridges (e107, smf, smf2, wbb, xoops) which were all created off of the e107 bridge and includes the concept of verifying the user group associated with user against the usergroup selected at installation time. Actually if you go back to any version of WRM before 3.5.0 and run through the installation you will find that the phpBB installation (supporting phpBB2) has no option to select an access group. When the installer was re-written for 3.5.0 alot of functionality / screens were merged together. The "select group for access" functionality is part of that. While the phpBB installer requests that you select a usergroup from phpBB for access, it doesn't matter a whit what you select, it's not supported/implemented in the auth file that checks the user/password. As I am on a VERY tight schedule with 3.5.0 I am unable, at this point, to re-write the phpBB bridges (2 and 3) to support this functionality, however, luckily, I wasn't the one who wrote the phpBB3 bridge in the first place. One of my other developers, Neme, wrote the installer for 3.5.0 and originally the phpBB3 Bridge. At this point I'm going to say, as much as I DO NOT believe this, that this is a feature request. I'll ask Neme to take a look at it and see if he can't re-write the phpBB 2 and 3 bridges for 3.5.0 for better support. Unfortunately, even with as important as this feature I believe is, I can't call this a bug since the support was never there in prior versions and it's still not there in this one...and I can't Jeopardize my timeline (and thus my possibility of a WotLK release on time) to get support written in for this...at least at this point. Let me see if I can get Neme involved here and see what magic he can work. --Illydth - Douglas Wagner - Site Admin | ||
| Back to top |
| Neme |
| ||
 Joined: Tue Mar 18 2008, 06:10AM Posts: 145 | sry sry Sorry, I have completely forgotten this important point, to implement :-( ############################# ==== German PM Support / Developer ==== ############################# | ||
| Back to top |
| Illydth |
| ||
Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | No issues at all, you didn't forget, it was never included in the original code...God knows I've had this software for a year and it took me 4 hours of looking this afternoon to figure out the code simply isn't there. Not your fault at all. I just sent you a PM to see if you've got time to work on this, if you do I would DEEPLY appreciate it. ATM my schedule is basically full. --Illydth - Douglas Wagner - Site Admin | ||
| Back to top |
| Scain |
| ||
 Joined: Sun Aug 10 2008, 07:52AM Posts: 20 | Hey, Any updates on this? It's pretty critical as we're using usergroups as well, that everyone who creates a user on our forums can access our sign-up. Isn't it just to update the SQL query to only compare username/password to people in the chosen usergroup(s) ? | ||
| Back to top |
| Illydth |
| ||
Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | No, actually it's not. The code doesn't even pull the user groups. It also needs to pull a lookup table based off of the data in a main table. That said, if you have a code patch you'd like to distribute feel free to post it back, you'll save Neme some time, otherwise he's working on it now I'm sure, give him a day or two to get something filled in for this. :) - Douglas Wagner - Site Admin | ||
| Back to top |
| Neme |
| ||
Joined: Tue Mar 18 2008, 06:10AM Posts: 145 | i'm work on this pls wait 1 or 2 day ############################# ==== German PM Support / Developer ==== ############################# | ||
| Back to top |
| Scain |
| ||
Joined: Sun Aug 10 2008, 07:52AM Posts: 20 | Great, thanks a lot. I know you have been working hard on all this, i'll wait patiently :) or we will :D | ||
| Back to top |
| Neme |
| ||
Joined: Tue Mar 18 2008, 06:10AM Posts: 145 | finish :-) (i hope) can you pls test and say if this corect work  auth_phpbb3.zipchangelog i have completely changed the sourcecode now base on auth_e107 edit: unpack and replace the file (wrmserver+wrmdir)/auth/auth_phpbb3.php [ Edited Sat Aug 23 2008, 02:04PM ] ############################# ==== German PM Support / Developer ==== ############################# | ||
| Back to top |
| Scain |
| ||
Joined: Sun Aug 10 2008, 07:52AM Posts: 20 | haha, was just browsing the forum to check if you had answered, then 2 mins later it's here :p i'll test it now. | ||
| Back to top |
| Scain |
| ||
Joined: Sun Aug 10 2008, 07:52AM Posts: 20 | Working perfectly, thanks for the quick fix.. Only comment.. when you try to log into WRM without being in the right group it says you're not granted access in "e107" though we're using phpBB bridge, but guess that has nothing to do with the bridge itself.. And maybe change this sentence during last install step using phpBB bridge.. $localstr['step5phpBBsub4wantimport'] = 'want you all users import from phpBB Forum/Board'; To "Do you want to import all users from phpBB Forum/Board" .. The other sentence doesn't make much sence.. Else, thumbs up! Best online raidmanagement system! | ||
| Back to top |
| Floodster |
| ||
Joined: Thu Aug 21 2008, 07:10AM Posts: 8 | As Scain says works fine now, only problems is the "e107" error which I can live with as the functionality is there. Also the way I have the forum / WRM folder path set is as follows: /forum /forum/wrm I had it this way so as long as you are logged in the forum if you then go to WRM it would log you in automatically even if you were never logged in before (if you logged out of both and deleted the cookies then went to the forum and logged in it would auto log you in on WRM as soon as you went to that part of the site) This seems to have stopped working with the new version of the phpbb authorisation code. Not sure if this is a bug or simply a feature that wasn't supposed to be there in the first place. Again though not a major issue as long as the authorisation works. Other thing is that the case sensitive login seems to have now been disabled which is a good thing :) Flood [ Edited Sun Aug 24 2008, 12:40AM ] | ||
| Back to top |
| Neme |
| ||
Joined: Tue Mar 18 2008, 06:10AM Posts: 145 | the bridge NOT use phpbb authorisation code, yet -> they must log off in both systems (phpbb and wrm) ############################# ==== German PM Support / Developer ==== ############################# | ||
| Back to top |
| Galibard |
| ||
Joined: Sun Aug 24 2008, 03:06PM Posts: 2 | i have instaled new WRM and set it up to work with new bridge, during instalation everything seem to be ok but when i try to log in im getting this error. Sorry, phpRaid has encountered a critical error! Page: /wrm/login.php Query: SELECT user_id,username_clean,user_email FROM gildia_phpb1.phpbb_users WHERE username_clean = 'galibard' Details: SELECT command denied to user 'gildia_wrmadm'@'localhost' for table 'phpbb_users' any ideas what i have done wrong ? | ||
| Back to top |
| TheMuffinMan |
| ||
 Joined: Wed Aug 13 2008, 11:56AM Posts: 84 | Galibard wrote ... i have instaled new WRM and set it up to work with new bridge, during instalation everything seem to be ok but when i try to log in im getting this error. Sorry, phpRaid has encountered a critical error! Page: /wrm/login.php Query: SELECT user_id,username_clean,user_email FROM gildia_phpb1.phpbb_users WHERE username_clean = 'galibard' Details: SELECT command denied to user 'gildia_wrmadm'@'localhost' for table 'phpbb_users' any ideas what i have done wrong ? You need to be using the same database/user for both phpbb3 and WRM. Your WRM admin username doesnt have access to the phpbb3 tables. That is what it looks like to me :) The one on Drury Lane?? | ||
| Back to top |
| Galibard |
| ||
Joined: Sun Aug 24 2008, 03:06PM Posts: 2 | You need to be using the same database/user for both phpbb3 and WRM. Your WRM admin username doesnt have access to the phpbb3 tables. That is what it looks like to me :) Thank you , that solved my problem. | ||
| Back to top |
| Moderators: Illydth |
Date / Time Search WoW Raid Manager Chatbox
Neme
andrew11
Illydth
Illydth
Illydth
Illydth
Illydth
Jonneh
Jonneh
ppbash
