Codeberg-CI/feedback
Codeberg-CI/feedback
264
50
Issues17 Wiki Activity

[Attention] Possible CI access issues due to case-sensitive name-mismatches in DB #221

New issue
Open
opened 2025-01-23 09:58:23 +00:00 by pat-s · 0 comments
pat-s commented 2025-01-23 09:58:23 +00:00
Owner

Following up on past issues, the following users are likely to encounter access issue on their user org in Woodpecker due to a case-sensitive name mismatch in the DB.

The records for all users below have been updated/fixed.

MariaDB [woodpecker]> SELECT orgs.name AS org_name, users.login AS user_login
    -> FROM orgs
    -> JOIN users ON orgs.name = users.login
    -> WHERE BINARY orgs.name <> BINARY users.login;
+---------------------+---------------------+
| org_name            | user_login          |
+---------------------+---------------------+
| 0next               | 0NeXt               |
| 1randhomme          | 1RandHomme          |
| acat                | ACat                |
| adamwysokinski      | AdamWysokinski      |
| adrodoc             | Adrodoc             |
| ak_heaven           | AK_heaven           |
| albanminassian      | AlbanMinassian      |
| alexanderamelkin    | AlexanderAmelkin    |
| archie_             | Archie_             |
| aridev              | AriDEV              |
| averagehelper       | AverageHelper       |
| aviac               | Aviac               |
| bazsalanszky        | Bazsalanszky        |
| be.ing              | Be.ing              |
| beowulf             | Beowulf             |
| chenille33          | Chenille33          |
| chfkch              | Chfkch              |
| chiefmcclane        | ChiefMcClane        |
| ciavash             | CIAvash             |
| coolgi              | coolGi              |
| cpluspatch          | CPlusPatch          |
| crapstone           | crapStone           |
| cubeofshame         | CubeOfShame         |
| curid               | Curid               |
| cvt                 | CvT                 |
| cyanic76            | Cyanic76            |
| dekker1             | Dekker1             |
| derreparierer       | derReparierer       |
| desour              | Desour              |
| dogmadragon         | DogmaDragon         |
| drlecram            | DrLecram            |
| echedellelr         | EchedelleLR         |
| eliastreffler       | EliasTreffler       |
| elysiaorbit         | ElysiaOrbit         |
| epsilon_02          | Epsilon_02          |
| erik-rosenblad      | Erik-Rosenblad      |
| eternahl            | Eternahl            |
| federicoceratto     | FedericoCeratto     |
| federicoschonborn   | FedericoSchonborn   |
| firesphere          | Firesphere          |
| fl1tzi              | Fl1tzi              |
| freso               | Freso               |
| gameplayer-8        | GamePlayer-8        |
| geopjr              | GeopJr              |
| giikis2             | GiikiS2             |
| gusted              | Gusted              |
| harharlinks         | HarHarLinks         |
| hund                | Hund                |
| inputmice           | iNPUTmice           |
| integral            | Integral            |
| jesusmtnez          | JesusMtnez          |
| johnwalkerx         | JohnWalkerx         |
| jonathantreffler    | JonathanTreffler    |
| kanakothegay        | KanakoTheGay        |
| krisque             | Krisque             |
| langerjan           | LangerJan           |
| laxystem            | Laxystem            |
| lcsten              | LcsTen              |
| lenny               | Lenny               |
| leoncarmin          | LeonCarmin          |
| leroyleroy          | LeroyLeroy          |
| lilahexe            | LilaHexe            |
| linerly             | Linerly             |
| lordeidi            | LordEidi            |
| lumaeris            | Lumaeris            |
| lunaa               | Lunaa               |
| mantar              | Mantar              |
| marix               | Marix               |
| mawoka              | Mawoka              |
| megaj               | MegaJ               |
| mek101              | Mek101              |
| michaelagarkov      | MichaelAgarkov      |
| midou36o            | Midou36O            |
| mikecoats           | MikeCoats           |
| mkoesters           | MKoesters           |
| monster             | Monster             |
| mrrulf              | MrRulf              |
| mynacol             | Mynacol             |
| n4ta                | N4ta                |
| natureshadow        | Natureshadow        |
| nordfriese          | Nordfriese          |
| noumlautsallowed    | NoUmlautsAllowed    |
| novaandromeda       | NovaAndromeda       |
| nrk                 | NRK                 |
| orbitalmartian      | OrbitalMartian      |
| piturnah            | Piturnah            |
| powersource         | Powersource         |
| prid                | Prid                |
| psyhackological     | Psyhackological     |
| purplebooth         | PurpleBooth         |
| rawdiamondmc        | RawDiamondMC        |
| release-candidate   | Release-Candidate   |
| resonix             | Resonix             |
| rinma               | Rinma               |
| robwalt             | RobWalt             |
| s1syphos            | S1SYPHOS            |
| samwhited           | SamWhited           |
| scpf-bot            | SCPF-Bot            |
| scrumplex           | Scrumplex           |
| sebito              | Sebito              |
| seryoga_leshii      | Seryoga_Leshii      |
| shuriken            | SHuRiKeN            |
| simx72              | Simx72              |
| skyeforeverblue     | SkyeForeverBlue     |
| skyfire             | SkyFire             |
| smollemon           | SmolLemon           |
| squel               | Squel               |
| stayblue            | StayBlue            |
| sunrise             | Sunrise             |
| surreptitiousstream | SurreptitiousStream |
| szpachlarz          | Szpachlarz          |
| taffer              | Taffer              |
| tealk               | Tealk               |
| test_user           | Test_User           |
| thatguymatus        | ThatGuyMatus        |
| theevilskeleton     | TheEvilSkeleton     |
| theholytachanka     | TheHolyTachanka     |
| themyth             | TheMyth             |
| tinsuke             | tinsukE             |
| tronde              | Tronde              |
| tuxilio             | Tuxilio             |
| ummit               | UmmIt               |
| vishnusanal         | VishnuSanal         |
| vnpower             | VnPower             |
| webgame2k           | WebGame2k           |
| whynothugo          | WhyNotHugo          |
| xade                | XADE                |
| xdr                 | XDR                 |
| xdream8             | XDream8             |
| xinayder            | Xinayder            |
| xphyro              | XPhyro              |
| ypman               | Ypman               |
| zamenhof            | Zamenhof            |
| zunnecode           | ZunneCode           |
+---------------------+---------------------+

@0NeXt @1RandHomme @ACat @AdamWysokinski @Adrodoc @AK_heaven @AlbanMinassian @AlexanderAmelkin @Archie_ @AriDEV @AverageHelper @Aviac @Bazsalanszky @Be.ing @Beowulf @Chenille33 @Chfkch @ChiefMcClane @CIAvash @coolGi @CPlusPatch @crapStone @CubeOfShame @Curid @CvT @Cyanic76 @Dekker1 @derReparierer @Desour @DogmaDragon @DrLecram @EchedelleLR @EliasTreffler @ElysiaOrbit @Epsilon_02 @Erik-Rosenblad @Eternahl @FedericoCeratto @FedericoSchonborn @Firesphere @Fl1tzi @Freso @GamePlayer-8 @GeopJr @GiikiS2 @Gusted @HarHarLinks @Hund @iNPUTmice @Integral @JesusMtnez @JohnWalkerx @JonathanTreffler @KanakoTheGay @Krisque @LangerJan @Laxystem @LcsTen @Lenny @LeonCarmin @LeroyLeroy @LilaHexe @Linerly @LordEidi @Lumaeris @Lunaa @Mantar @Marix @Mawoka @MegaJ @Mek101 @MichaelAgarkov @Midou36O @MikeCoats @MKoesters @Monster @MrRulf @Mynacol @N4ta @Natureshadow @Nordfriese @NoUmlautsAllowed @NovaAndromeda @NRK @OrbitalMartian @Piturnah @Powersource @Prid @Psyhackological @PurpleBooth @RawDiamondMC @Release-Candidate @Resonix @Rinma @RobWalt @S1SYPHOS @SamWhited @SCPF-Bot @Scrumplex @Sebito @Seryoga_Leshii @SHuRiKeN @Simx72 @SkyeForeverBlue @SkyFire @SmolLemon @Squel @StayBlue @Sunrise @SurreptitiousStream @Szpachlarz @Taffer @Tealk @Test_User @ThatGuyMatus @TheEvilSkeleton @TheHolyTachanka @TheMyth @tinsukE @Tronde @Tuxilio @UmmIt @VishnuSanal @VnPower @WebGame2k @WhyNotHugo @XADE @XDR @XDream8 @Xinayder @XPhyro @Ypman @Zamenhof @ZunneCode

Following up on past issues, the following users are likely to encounter access issue on their user org in Woodpecker due to a case-sensitive name mismatch in the DB. The records for all users below **have been updated/fixed**. ```sql MariaDB [woodpecker]> SELECT orgs.name AS org_name, users.login AS user_login -> FROM orgs -> JOIN users ON orgs.name = users.login -> WHERE BINARY orgs.name <> BINARY users.login; +---------------------+---------------------+ | org_name | user_login | +---------------------+---------------------+ | 0next | 0NeXt | | 1randhomme | 1RandHomme | | acat | ACat | | adamwysokinski | AdamWysokinski | | adrodoc | Adrodoc | | ak_heaven | AK_heaven | | albanminassian | AlbanMinassian | | alexanderamelkin | AlexanderAmelkin | | archie_ | Archie_ | | aridev | AriDEV | | averagehelper | AverageHelper | | aviac | Aviac | | bazsalanszky | Bazsalanszky | | be.ing | Be.ing | | beowulf | Beowulf | | chenille33 | Chenille33 | | chfkch | Chfkch | | chiefmcclane | ChiefMcClane | | ciavash | CIAvash | | coolgi | coolGi | | cpluspatch | CPlusPatch | | crapstone | crapStone | | cubeofshame | CubeOfShame | | curid | Curid | | cvt | CvT | | cyanic76 | Cyanic76 | | dekker1 | Dekker1 | | derreparierer | derReparierer | | desour | Desour | | dogmadragon | DogmaDragon | | drlecram | DrLecram | | echedellelr | EchedelleLR | | eliastreffler | EliasTreffler | | elysiaorbit | ElysiaOrbit | | epsilon_02 | Epsilon_02 | | erik-rosenblad | Erik-Rosenblad | | eternahl | Eternahl | | federicoceratto | FedericoCeratto | | federicoschonborn | FedericoSchonborn | | firesphere | Firesphere | | fl1tzi | Fl1tzi | | freso | Freso | | gameplayer-8 | GamePlayer-8 | | geopjr | GeopJr | | giikis2 | GiikiS2 | | gusted | Gusted | | harharlinks | HarHarLinks | | hund | Hund | | inputmice | iNPUTmice | | integral | Integral | | jesusmtnez | JesusMtnez | | johnwalkerx | JohnWalkerx | | jonathantreffler | JonathanTreffler | | kanakothegay | KanakoTheGay | | krisque | Krisque | | langerjan | LangerJan | | laxystem | Laxystem | | lcsten | LcsTen | | lenny | Lenny | | leoncarmin | LeonCarmin | | leroyleroy | LeroyLeroy | | lilahexe | LilaHexe | | linerly | Linerly | | lordeidi | LordEidi | | lumaeris | Lumaeris | | lunaa | Lunaa | | mantar | Mantar | | marix | Marix | | mawoka | Mawoka | | megaj | MegaJ | | mek101 | Mek101 | | michaelagarkov | MichaelAgarkov | | midou36o | Midou36O | | mikecoats | MikeCoats | | mkoesters | MKoesters | | monster | Monster | | mrrulf | MrRulf | | mynacol | Mynacol | | n4ta | N4ta | | natureshadow | Natureshadow | | nordfriese | Nordfriese | | noumlautsallowed | NoUmlautsAllowed | | novaandromeda | NovaAndromeda | | nrk | NRK | | orbitalmartian | OrbitalMartian | | piturnah | Piturnah | | powersource | Powersource | | prid | Prid | | psyhackological | Psyhackological | | purplebooth | PurpleBooth | | rawdiamondmc | RawDiamondMC | | release-candidate | Release-Candidate | | resonix | Resonix | | rinma | Rinma | | robwalt | RobWalt | | s1syphos | S1SYPHOS | | samwhited | SamWhited | | scpf-bot | SCPF-Bot | | scrumplex | Scrumplex | | sebito | Sebito | | seryoga_leshii | Seryoga_Leshii | | shuriken | SHuRiKeN | | simx72 | Simx72 | | skyeforeverblue | SkyeForeverBlue | | skyfire | SkyFire | | smollemon | SmolLemon | | squel | Squel | | stayblue | StayBlue | | sunrise | Sunrise | | surreptitiousstream | SurreptitiousStream | | szpachlarz | Szpachlarz | | taffer | Taffer | | tealk | Tealk | | test_user | Test_User | | thatguymatus | ThatGuyMatus | | theevilskeleton | TheEvilSkeleton | | theholytachanka | TheHolyTachanka | | themyth | TheMyth | | tinsuke | tinsukE | | tronde | Tronde | | tuxilio | Tuxilio | | ummit | UmmIt | | vishnusanal | VishnuSanal | | vnpower | VnPower | | webgame2k | WebGame2k | | whynothugo | WhyNotHugo | | xade | XADE | | xdr | XDR | | xdream8 | XDream8 | | xinayder | Xinayder | | xphyro | XPhyro | | ypman | Ypman | | zamenhof | Zamenhof | | zunnecode | ZunneCode | +---------------------+---------------------+ ``` @0NeXt @1RandHomme @ACat @AdamWysokinski @Adrodoc @AK_heaven @AlbanMinassian @AlexanderAmelkin @Archie_ @AriDEV @AverageHelper @Aviac @Bazsalanszky @Be.ing @Beowulf @Chenille33 @Chfkch @ChiefMcClane @CIAvash @coolGi @CPlusPatch @crapStone @CubeOfShame @Curid @CvT @Cyanic76 @Dekker1 @derReparierer @Desour @DogmaDragon @DrLecram @EchedelleLR @EliasTreffler @ElysiaOrbit @Epsilon_02 @Erik-Rosenblad @Eternahl @FedericoCeratto @FedericoSchonborn @Firesphere @Fl1tzi @Freso @GamePlayer-8 @GeopJr @GiikiS2 @Gusted @HarHarLinks @Hund @iNPUTmice @Integral @JesusMtnez @JohnWalkerx @JonathanTreffler @KanakoTheGay @Krisque @LangerJan @Laxystem @LcsTen @Lenny @LeonCarmin @LeroyLeroy @LilaHexe @Linerly @LordEidi @Lumaeris @Lunaa @Mantar @Marix @Mawoka @MegaJ @Mek101 @MichaelAgarkov @Midou36O @MikeCoats @MKoesters @Monster @MrRulf @Mynacol @N4ta @Natureshadow @Nordfriese @NoUmlautsAllowed @NovaAndromeda @NRK @OrbitalMartian @Piturnah @Powersource @Prid @Psyhackological @PurpleBooth @RawDiamondMC @Release-Candidate @Resonix @Rinma @RobWalt @S1SYPHOS @SamWhited @SCPF-Bot @Scrumplex @Sebito @Seryoga_Leshii @SHuRiKeN @Simx72 @SkyeForeverBlue @SkyFire @SmolLemon @Squel @StayBlue @Sunrise @SurreptitiousStream @Szpachlarz @Taffer @Tealk @Test_User @ThatGuyMatus @TheEvilSkeleton @TheHolyTachanka @TheMyth @tinsukE @Tronde @Tuxilio @UmmIt @VishnuSanal @VnPower @WebGame2k @WhyNotHugo @XADE @XDR @XDream8 @Xinayder @XPhyro @Ypman @Zamenhof @ZunneCode
👍 2
Sign in to join this conversation.
No labels
Bug
Chat
Codeberg
Documentation
Duplicate
edge-case
Feature
Gitea
Need Feedback
Plugin
Suggestion
UI
Upstream
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: Codeberg-CI/feedback#221
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?