• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

LDAP Losing Admin

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In setting up LDAP with JForum it seems as if I have lost the ability to log in as Admin.

See below: (from another post)

Rafael Steil wrote:The account you're using as Admin is not associated to the Administrators group. Tables are jforum_groups and jforum_user_groups.



Here's my tables

mysql> select * from jforum_groups;
+----------+----------------+-------------------+-----------+
| group_id | group_name | group_description | parent_id |
+----------+----------------+-------------------+-----------+
| 1 | General | General Users | 0 |
| 2 | Administration | Admin Users | 0 |
+----------+----------------+-------------------+-----------+
2 rows in set (0.33 sec)

mysql> select user_id, username from jforum_users;
+---------+-----------+
| user_id | username |
+---------+-----------+
| 1 | Anonymous |
| 2 | Admin |
| 3 | dcrumb1 |
| 4 | dcrumb |
+---------+-----------+
4 rows in set (0.10 sec)

mysql> select * from jforum_user_groups;
+----------+---------+
| group_id | user_id |
+----------+---------+
| 1 | 1 |
| 2 | 2 |
| 1 | 3 |
| 1 | 4 |
+----------+---------+
4 rows in set (0.01 sec)

So.. That says that Admin (user_id=2) is part of the Admin group_id

Please advise,

--Dave

[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hm, using LDAP, you log on in JForum using the "Admin" account without any problems - the same "Admin" that's in the database -, and only the Admin Panel is not acessible?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
No, I couldn't authenticate at all with Admin username

What I did do was (via the database) set one of my LDAP Users with a groupid=2 (for Admin).

So, for me it's kinda fixed, but it seems to be an issue you may want to look into.

Best,

--Dave

[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well, that's expected to do. But I know it's my fault, since there is no documentation saying that's expected.

I'm updating the docs (http://www.jforum.net/confluence)

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Story like this gets better after being told a few times. Or maybe it's just a tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic