263452 - LDAP User account lookup fails, access to bug-group settings unavialble.

Status: RESOLVED INVALID

(Bugzilla :: User Accounts, defect)

Description

[Andy Brook]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20041001 Firefox/0.10.1 StumbleUpon/1.998
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20041001 Firefox/0.10.1 StumbleUpon/1.998

No weblink sorry.

2.18rc2 used, extracted to two locations, each using their own database. One is
'blank' and does perform user lookups OK, the second has been used and has 100
or so bugs and about 5 users, setup through Active Directory LDAP.  Login and
querying works fine for the most part (#263448 withstanding), so LDAP config is
good, but when I try and lookup Users I get '0 users found'. despite being
logged in.

If I am unable to edit users Im unable to modify bug groups and cannot add new
users to the system.


Reproducible: Always
Steps to Reproduce:
[live 2.18rc2 system with 100bugs/5users]
1. Click users
2. Type my logged in user id

Actual Results:  
'0 users found' message

Expected Results:  
as found in [blank 2.18rc2 system with 100bugs/5users]
1. Click users
2. Type my logged in user id
3. my user, linked to group access data.

Comment 1

[Andy Brook]

soor, expected results should read [blank 2.18rc2 system]  - no bugs or users
present.

Comment 2

[Andy Brook]

sorry, expected results should read [blank 2.18rc2 system]  - no bugs or users
present.

Comment 3

[Andy Brook]

Ive just tried copying the localconfig from the failing 2.18rc2 to the blank
2.18rc2 (in case scripts got mangled), the problem was still evident so it looks
like a bugzilla/database issue.  Im lookin into trying an earlier version of
mysql anyhow..  Current mysql version is 4.0.21

Comment 4

[Andy Brook]

After I managed to corrupt the profiles table, resulting in the first 7 entries
being deleted, the 'LDAP query' came back to life.

after I recovered the table from backup, the LDAP lookup feature broke again.

Go figure.

Comment 5

[Andy Brook]

RC3 still has this problem, with my current database that was created with RC2.
Ive tested RC3 against a blank RC2 created database and I am able to query
'Users' who have logged in.  I am still not able to do this with the live system.

Sanity check doesnt show up anything and &debug hasn't been implemented for the
user lookup page so I cant extract more information.

Any clues how I can progress this? It seems related to the data but how?

Comment 6

[Andy Brook]

Solved.  The 'profiles' table got wiped as in empty.  Bugzilla never complained
about this, and wierd stuff happened (My Bugs failing, editing users failing).

I reverse engineered the bugs -> user mapping, recreated the users and all is
now well.

My bad, but some debug info about missing data would have been good.

Comment 7

[Max Kanat-Alexander]

This should be NOTABUG, and the blocker should be a duplicate of this bug.

Comment 8

[Max Kanat-Alexander]

Whoops, I mean INVALID, not NOTABUG (I'm thinking about my local Bugzilla...) :-)

Comment 9

[Max Kanat-Alexander]

*** Bug 264342 has been marked as a duplicate of this bug. ***