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

Fri Sep 15 13:32:57 UTC 2023

Thank you for your (as always) prompt response.

By reverting to 5.0.3, I meant the version we have created internally.  It’s based on the official version 5.0.3, but as we had a MySQL 8 server, we did the changes discussed earlier:

  *   the table ‘groups’ was renamed to ‘groeps’
  *   we modified the perl scripts that reference the table.
In that version, the REST api was working correctly.

When we installed the 5.0.6 (on the new server), we repeated the table name translation and the modification of the perl scripts, but here the REST api is NOT working correctly.
Truth being said:  In the 5.0.6, we found some other references to the table we did not modify in the 5.0.3 changes, so our 5.0.6 contains a small number of additional changes to the perl scripts.

I was hoping that my previous mails explaining the issue in detail would trigger one the REST developers to examine why the REST api is not functioning anymore.

Kind regards,

Ignace Danneels
Controls Design Engineer
TREMEC
Office:  +32 (0) 50 977 766

From: support-list <support-list-bounces at bugzilla.org> On Behalf Of David Miller
Sent: Friday, 15 September 2023 15:03
To: support-list at bugzilla.org
Subject: Re: FW: Bugzilla 5.0.6 REST interface fails after renaming table groups to groeps

[CYBERSECURITY DESC] MENSAJE DE UN REMITENTE EXTERNO / MESSAGE FROM AN EXTERNAL SENDER
Toma precauciones extremas, no hagas click en los enlaces.
Take extreme precautions, do not click on unknown links.

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 1st, 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><mailto:justdave at bugzilla.org>; 'support-list at bugzilla.org<mailto:support-list at bugzilla.org>' <support-list at bugzilla.org><mailto: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.
[cid:image001.png at 01D9E7E8.D991A4D0]

Here’s a little more detail

On step 1:
[cid:image002.png at 01D9E7E8.D991A4D0]

[cid:image003.png at 01D9E7E8.D991A4D0]
[cid:image004.png at 01D9E7E8.D991A4D0]
[cid:image005.png at 01D9E7E8.D991A4D0]

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<mailto:support-list at bugzilla.org>

https://lists.bugzilla.org/listinfo/support-list
--
[[Bugzilla Logo]]
Dave Miller
Project Leader
Bugzilla Project
https://bugzilla.org/

________________________________

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15474 bytes
Desc: image001.png
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 51033 bytes
Desc: image002.png
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 43746 bytes
Desc: image003.png
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 54396 bytes
Desc: image004.png
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 53219 bytes
Desc: image005.png
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 7345 bytes
Desc: image006.png
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20230915/5ac07714/attachment-0011.png>