|
Joined: Apr 2007
Posts: 2
stranger
|
stranger
Joined: Apr 2007
Posts: 2 |
Are there any enterprise collab web apps that work well with UBB? I find that forum component of most enterprise collab software is weak. It would really be nice to run UBB and another product as a single site so that the secondary app would add messenging, doc sharing, conferencing, maybe wiki, etc. to UBBs forum feature.
We are naturally also trying to keep costs down by hosting ourselvers and so want to avoid per account fees of most collab software. Any advice or recommendations would be appreciated.
Nick
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
Well, Rick has stated he plans to add more portal-ish items to the forum, such as improving the calendar, adding a blogg, adding a gallery...
I'm pushing for some sort of Wiki/enhanced FAQ system...
|
|
|
|
Joined: Jul 2006
Posts: 116
member
|
member
Joined: Jul 2006
Posts: 116 |
I'm pushing for some sort of Wiki/enhanced FAQ system... I would love to see this!
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
'eh Rick said somewhere that he's pushing for more board type help system, so who knows :crosses fingers: a UBBWiki sounds sweet to replace a FAQ...
|
|
|
|
Joined: Jul 2006
Posts: 116
member
|
member
Joined: Jul 2006
Posts: 116 |
I've recently tried getting dokuwiki to authenticate using ubb.t. It certainly seems possible as it can authenticate with a mysql backend, but I've not had any luck to get this to work with my installation yet. Has anyone else happened to give this a try? Or would be willing to?
|
|
|
|
Joined: Jul 2006
Posts: 116
member
|
member
Joined: Jul 2006
Posts: 116 |
Maybe as a start I could get some feedback on the SQL statements I'm using below? checkPass: The result should be a table with exactly one line containing at least the password of the user. If the result table is empty or contains more than one row, access will be denied. The module access the password as ‘pass’ so an alias might be necessary. $conf['auth']['mysql']['checkPass'] =
"SELECT USER_PASSWORD AS pass
FROM ubbt_USERS
WHERE USER_LOGIN_NAME='%{user}'
AND USER_PASSWORD=MD5('%{pass}')";
getUserInfo: This statement should return a table with exact one row containing information about one user. The fields needed are: ‘pass’ containing the encrypted or clear text password ‘name’ the user’s full name (I'm using the Display Name) ‘mail’ the user’s email address $conf['auth']['mysql']['getUserInfo'] =
"SELECT USER_PASSWORD AS pass,
USER_DISPLAY_NAME AS name,
USER_REGISTRATION_EMAIL AS mail
FROM ubbt_USERS
WHERE USER_LOGIN_NAME='%{user}'";
getGroups: This statement is used to get all groups a user is member of. The result should be a table containing all groups the given user is member of. The module accesses the group name as ‘group’ so an alias might be necessary. $conf['auth']['mysql']['getGroups'] =
"SELECT GROUP_NAME AS `group`
FROM ubbt_GROUPS g, ubbt_USERS u, ubbt_USER_GROUPS ug
WHERE u.USER_ID = ug.USER_ID
AND g.GROUP_ID = ug.GROUP_ID
AND u.USER_LOGIN_NAME='%{user}'";
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
At first glance the queries look good. Just heading out to dinner, but will take a closer look later.
|
|
|
|
Joined: Jul 2006
Posts: 116
member
|
member
Joined: Jul 2006
Posts: 116 |
One thing I forgot to ask -- am I using MD5 correctly for the password? Or should I be using a different function to MD5?
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
I md5 in my scripts when I call the get variable in the script (I code for register globals off); so: $pass = md5($_GET["pass"]);
|
|
|
|
Joined: Jul 2006
Posts: 116
member
|
member
Joined: Jul 2006
Posts: 116 |
Finally got it working! The checkPass SQL statement needed to be changed to: $conf['auth']['mysql']['checkPass'] =
"SELECT USER_PASSWORD AS pass
FROM ubbt_USERS
WHERE USER_LOGIN_NAME='%{user}'";
I now have DokuWiki authenticating against my UBB.threads installation!
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
Very nice work Myke
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
2 members (Gizmo, 1 invisible),
901
guests, and
169
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|