FW: Bugzilla 5.0.6 REST interface fails after renaming table groups to groeps

Fri Sep 15 13:03:25 UTC 2023

Only the list admins can see the subscriber list. It's designed to allow 
people to read the list and keep their privacy as long as they don't 
post to it.

As to the MySQL 8 issues, we're in the middle of our final push to 
getting versoin 5.2 and its companion releases out the door (we planned 
to release a couple weeks ago but lots of last minute release blockers 
surfaced, and I'm guessing we're about a week away yet at this point 
still).  Getting our MySQL 8 compatibility sorted is the first thing on 
the list after we get this set of releases out (and there would be a 
followup release containing that fix once its ready).  Our leading 
candidate patch set at the moment is leaving the name of the table alone 
but quoting the identifiers properly (which is a surprisingly invasive 
patch, probably has to touch almost as many places as you renaming the 
table did), but less likely to cause compatibility issues with APIs that 
are using table names for parameters.

Moving to an older version of Bugzilla wouldn't help anything, because 
MySQL 8+ still has that issue with 'groups' being a reserved word.

It may or may not be a choice available to you but we've been 
recommending using MariaDB instead of MySQL if you need it all working 
right away.  MariaDB (prior to version 10.6 anyway) is almost a drop-in 
replacement for MySQL and it'll work with Bugzilla using the MySQL 
drivers, but MariaDB doesn't have the groups reserved word issue.

Making the tweaks needed for MariaDB 10.6 to work properly with Bugzilla 
is actually included in the 5.2 release that's imminent (in fact, that's 
one of our release blockers).  Versions of Bugzilla prior to 5.0.5 don't 
have any issues with MariaDB 10.6, it's a specific thing in 
5.0.5/5.0.6/5.2 that broke it.

On 9/15/23 7:05 AM, Ignace Danneels wrote:
>
> Hello,
>
> On September 1^st , I posted (wrote) some additional information on 
> the REST api error I see from Bugzilla 5.0.6.
>
> I have tried other Python libraries that interact with Bugzilla and 
> they have the same issue.
>
> I can’t say for sure that the rename is the root cause of the issue, 
> because I did not try the api before I made the change.
>
> I was wondering if in the community, someone has picked up the issue 
> and tried it out as well, and if a solution to the issue has been 
> proposed.
>
> If a quickfix is possible (indicating to me what sources I need to 
> modify), I’d appreciate that.
>
> I have subscribed to the mailing list, but when I try to “Visit 
> Subscriber List”, I get a “support-list roster authentication failed”.
>
> I’m getting more and more pressure to revert back to the 5.0.6, which 
> I would like to avoid.
>
> Kind regards,
>
> *Ignace Danneels*
>
> Controls Design Engineer
>
> *TREMEC*
>
> Office: +32 (0) 50 977 766
>
> *From:*Ignace Danneels
> *Sent:* Friday, 1 September 2023 14:08
> *To:* 'David Miller' <justdave at bugzilla.org>; 
> 'support-list at bugzilla.org' <support-list at bugzilla.org>
> *Subject:* FW: Bugzilla 5.0.6 REST interface fails after renaming 
> table groups to groeps
>
> I apologize, I just realized that the parser parses chunks (1024) of 
> data, so there are several blocks to be examined.
>
> Here’s a little more detail
>
> On step 1:
>
> It is during the last block that the self._parser.Parse(data, )  
> throws the error I reported earlier.
>
> Kind regards,
>
> *Ignace Danneels*
>
> Controls Design Engineer
>
> *TREMEC*
>
> Office: +32 (0) 50 977 766
>
>
> ------------------------------------------------------------------------
>
> Este correo electrónico es confidencial y está destinado 
> exclusivamente para la(s) persona(s) a quien(es) se dirige. Queda 
> estrictamente prohibida la distribución o copia del contenido de este 
> correo. Si usted ha recibido este correo por error le suplicamos 
> notificar inmediatamente a la persona que lo envió y borrarlo 
> definitivamente de su sistema. Grupo Kuo, S.A.B de C.V. con domicilio 
> en Paseo de los Tamarindos No. 400-B, piso 31, Bosques de las Lomas, 
> Cuajimalpa de Morelos, C.P. 05110, Ciudad de México, México, podrá 
> tratar los Datos Personales recabados vía correo electrónico con la 
> finalidad de atender a las comunicaciones que nos haga llegar, darles 
> seguimiento a las mismas, por motivos de seguridad y/o para cumplir 
> con las obligaciones legales aplicables. Para más información, 
> consulte nuestro Aviso de Privacidad en 
> https://kuo.com.mx/avisos-privacidad. Este mensaje no constituye una 
> aceptación, firma electrónica o un acuerdo vinculante, a menos que se 
> especifique expresamente lo contrario en el mismo.
>
> This e-mail is confidential and is intended only for the person(s) to 
> whom it is addressed. Any distribution or copy hereof is strictly 
> forbidden. If you have received this e-mail by error, we kindly ask 
> you to notify the sender and to delete it immediately. Grupo Kuo, 
> S.A.B. de C.V., having its address in Paseo de los Tamarindos, No. 
> 400-B, piso 31, Bosques de las Lomas, Cuajimalpa de Morelos, C.P. 
> 05120, Ciudad de México, Mexico, may process Personal Data collected 
> via email in order to process the communications submitted by you, 
> follow up on them, for security reasons and/or to fulfill applicable 
> legal obligations. For more information, see our Privacy Notice at 
> https://kuo.com.mx/avisos-privacidad. Nothing in this message is 
> intended to constitute an acceptance, an electronic signature nor a 
> binding agreement, unless a specific statement to the contrary is 
> expressly included in this message.
>
> _______________________________________________
> support-list mailing list
> support-list at bugzilla.org
> https://lists.bugzilla.org/listinfo/support-list
-- 
[Bugzilla Logo] 	
*Dave Miller*
Project Leader
*Bugzilla Project*
https://bugzilla.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 15474 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image011.png
Type: image/png
Size: 51033 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image012.png
Type: image/png
Size: 43746 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 54396 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 53219 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: vi0zL4708Z2dhw5J.png
Type: image/png
Size: 7345 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/d79b7dee/attachment-0011.png>