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

[OSGeo]

#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>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.