[SAC] [OSGeo] #165: Wiki LDAP integration

#165: Wiki LDAP integration
------------------------+---------------------------------------
Reporter: crschmidt | Owner: robe
     Type: task | Status: closed
Priority: major | Milestone: Sysadmin Contract 2021-I
Component: Wiki | Resolution: fixed
Keywords: ldap, wiki |
------------------------+---------------------------------------

Comment (by robe):

Replying to [comment:82 Jeff McKenna]:
> Could it be that any bureaucrat is facing this issue, since the merge?
> - zero past contributions:
https://wiki.osgeo.org/wiki/Special:Contributions/Jmckenna
>

The issue is case sensitivity one. It turns out our Mysql wiki database
is case sensitive. Came as shock to me and wiki expects the first letter
to be Upper. Cutting to the chase, this resulted in ghost accounts being
created. So there is a Jmckenna and a jmckenna account. It seems for
many people the history / group was assigned to the all lower case account
which you can't log into because login forces uppercase for first letter.

We put in a patch last night which hopefully should fix the issue moving
forward.

I've just merged your identity Jeff -- can you try again.

Replying to [comment:83 neteler]:
> Replying to [comment:81 robe]:
> > Neteler can you see if you have access to your pages again? Hopefully
I didn't cause more damage than good.
>
> Thanks - the login now works, and history is there:
> https://wiki.osgeo.org/wiki/Special:Contributions/Neteler
>
> However, yet no edit rights...

This is odd I thought I took you out of the in-progress/needs-migration
group and yet you seem to have gotten back in. I've deleted those again,
but this time via the Wiki interface instead of directly from the
database. If they show up again when you log in I'll investigate further.

+---------+----------------------------+-----------+
| ug_user | ug_group | ug_expiry |
+---------+----------------------------+-----------+
| 25083 | bureaucrat | NULL |
| 25083 | sysop | NULL |
| 25083 | wikitoldap-in-progress | NULL |
| 25083 | wikitoldap-merged | NULL |
| 25083 | wikitoldap-needs-migration | NULL |
+---------+----------------------------+-----------+

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/165#comment:84&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.