<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>We should have the MySQL 8 compatibility landed at the latest by
the end of November (but probably much sooner). We gave some good
patches for it now, they just need review and testing.</p>
<p>Version 5.2 should be coming out this weekend. It still won't
have the MySQL 8 compatibility, but we will be landing it on that
branch once it's ready. 5.0.x will not be getting that fix as
it'll be considered too invasive for an older branch. But since
you already upgraded beyond 5.0.4, you're essentially on the 5.2
version already (because 5.0.5 made invasive changes that it
shouldn't have, and should have been 5.2 with those changes).</p>
<p>As far as your commit message goes... what do you mean by "no
longer works"? Are you getting an error? If so, what's the error?
Is anything showing up in the logs on either end of the
transaction?<br>
</p>
<div class="moz-cite-prefix">On 9/1/23 5:06 AM, Ignace Danneels
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:DM6PR03MB3915F14098776177B9E8E16C8EE4A@DM6PR03MB3915.namprd03.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator"
content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style>@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello Dave,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I hope I can bother you
one more time. <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">As explained in earlier
mails, we have renamed the table ‘groups’ to ‘groeps’ in
order to be compliant with MySQL 8.<br>
(I still don’t see a Bugzilla release that is compatible
with it)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We have changed all
references in the Bugzilla perl scripts and from a
webinterface part, everything is working as expected.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We do run into one
issue, for which I may need your help.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I would need to get in
touch with the Bugzilla REST specialist.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The issue is the
following:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We are working with
subversion and when we make a commit, then we have a post
commit hook that runs a python script to also commit the
comment from the subversion commit into the Bugzilla
issue(s).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The python script uses
the python library bugzillatools. (<a
href="https://pypi.org/project/bugzillatools/"
moz-do-not-send="true" class="moz-txt-link-freetext">https://pypi.org/project/bugzillatools/</a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Some history:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We had Bugzilla 5.0.3
before, when transitioning to a new server, we also upgraded
Bugzilla to 5.0.6<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The post-commit hook did
work when we had BZ 5.0.3. It no longer works after
installing 5.0.6<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">In the original 5.0.3,
we had made changes (only) to the following files:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><img border="0"
width="537" height="143"
style="width:5.5916in;height:1.4916in"
id="Picture_x0020_5"
src="cid:part1.1oH7LyF9.foWVrlev@bugzilla.org" class=""></span><span
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">When Installing 5.0.6,
we made changes to the following files (changing ‘groups’ to
‘groeps’)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><img border="0"
width="452" height="524"
style="width:4.7083in;height:5.4583in"
id="Picture_x0020_6"
src="cid:part2.imjs4m0i.wukIPjPK@bugzilla.org" class=""></span><span
lang="EN-US"><br>
<br>
If you want, I am prepared to share the modified files with
you.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Unfortunately, I’m not
very familiar with REST.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">As you can see, in
5.0.3, we modified some sources, but we did not modify
Schema.pm or the DB.pm<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’m assuming I made a
change too much, which is crucial to the REST interface.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I do hope you can
forward my question to one of your Bugzilla experts to help
me get this on track again.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thank you in advance for
any assistance you can provide.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="en-BE"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="en-BE"
style="color:black;mso-ligatures:standardcontextual;mso-fareast-language:#2000">Kind
regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="en-BE"
style="color:black;mso-ligatures:standardcontextual;mso-fareast-language:#2000"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><b><span
lang="EN-US"
style="font-family:"Helvetica",sans-serif;color:#E51736;mso-ligatures:standardcontextual;mso-fareast-language:#2000">Ignace
Danneels</span></b><span lang="en-BE"
style="mso-ligatures:standardcontextual;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><span
lang="EN-US"
style="font-size:10.0pt;line-height:115%;font-family:"Helvetica",sans-serif;mso-ligatures:standardcontextual;mso-fareast-language:#2000">Controls
Design Engineer</span><span lang="en-BE"
style="mso-ligatures:standardcontextual;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><b><span
lang="EN-US"
style="font-size:12.0pt;line-height:115%;font-family:"Helvetica",sans-serif;color:black;mso-ligatures:standardcontextual;mso-fareast-language:#2000">TREMEC</span></b><span
lang="en-BE"
style="mso-ligatures:standardcontextual;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#BFBFBF;mso-ligatures:standardcontextual;mso-fareast-language:#2000">Office:
+32 (0) 50 977 766</span><span lang="en-BE"
style="color:black;mso-ligatures:standardcontextual;mso-fareast-language:#2000"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="en-BE"><o:p> </o:p></span></p>
<div>
<div
style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US"
style="mso-fareast-language:#2000">From:</span></b><span
lang="EN-US" style="mso-fareast-language:#2000"> Ignace
Danneels
<br>
<b>Sent:</b> Wednesday, 29 March 2023 14:34<br>
<b>To:</b> Dave Miller <a class="moz-txt-link-rfc2396E" href="mailto:justdave@bugzilla.org"><justdave@bugzilla.org></a>;
<a class="moz-txt-link-abbreviated" href="mailto:support-list@bugzilla.org">support-list@bugzilla.org</a><br>
<b>Subject:</b> RE: Bugzilla 5.0.6 Unable to log in
after migration<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">Changes for MySQL 8:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">(I had to dig into my
knowledge of perl again. I haven’t used that for many years
=> switched to Python)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We have Bugzilla 5.0.3
running on MySQL 8 for quite some time now. Ever since IT
decided to change to the latest version of MySQL! I think
it’s up to ½ year running without issues now.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">If we do, it’s because
we forgot to update an SQL statement. So we fix that one,
then simply continue.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The incompatibility
towards MySQL 8 is basically caused by the fact that
“groups” is now a reserved word.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">So we changed the table
name to ‘groeps’ . I’m from Belgium and ‘group’ in Dutch is
‘groep’. The plural is groepen, but we just changed one
letter. So ‘groups’ has become ‘groeps’.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Then all I did was
change all SQL statements to replace ‘groups’ with
‘groeps’. Only 80 replacements in 13 files.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">When installing 5.0.6, I
also had to modify the ABSTRACT_SCHEMA.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">When running perl
checksetup.pl, it tried to create the groeps table.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I found that there’s a
table in the database bz_schema that contains the current
layout of the database, so I changed the blob to replace all
‘groups’ by ‘groeps’ as well.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The next hurdle I
encountered was in the sub _<i>add_password_salt</i>_separator
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:blue;mso-fareast-language:#2000">my</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#001080;mso-fareast-language:#2000">$profiles</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
=
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#001080;mso-fareast-language:#2000">$dbh</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">->selectall_arrayref(<o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">"SELECT
userid, cryptpassword FROM profiles WHERE ("</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
.
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#001080;mso-fareast-language:#2000">$dbh</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">->sql_regexp(</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">"cryptpassword"</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">,
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">"'^[^,]+{'"</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">)<o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
.
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">")"</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">);<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’m quite sure it’s
because the { in a regex indicates an amount of something to
repeat. So I needed to escape that. It resulted in
<o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:blue;mso-fareast-language:#2000">my</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#001080;mso-fareast-language:#2000">$profiles</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
=
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#001080;mso-fareast-language:#2000">$dbh</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">->selectall_arrayref(<o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">"SELECT
userid, cryptpassword FROM profiles WHERE ("</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
.
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#001080;mso-fareast-language:#2000">$dbh</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">->sql_regexp(</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">"cryptpassword"</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">,
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">"'^[^,]+</span><span
lang="EN-US"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">\\\\</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">{'"</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">)<o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:14.25pt;background:white"><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">
.
</span><span lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:#A31515;mso-fareast-language:#2000">")"</span><span
lang="en-BE"
style="font-size:10.5pt;font-family:Consolas;color:black;mso-fareast-language:#2000">);<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">That’s it. The perl
checksetup.pl now ran without issues.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The site is running and
I can see everything, but I can’t log in! Probably because
the encrypted password in the table is an old one from the
days before we used the LDAP. But I’m not sure.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’ll look for the
errorlog file. In the current server (Windows 2012), it is
in the data folder. So I thought the new installation would
also have it there.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="en-BE"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#2F5496;mso-fareast-language:#2000">Best
regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"
style="mso-fareast-language:#2000"><o:p> </o:p></span></p>
<p class="MsoNormal"
style="line-height:12.05pt;text-autospace:none"><b><span
lang="ES"
style="font-size:12.0pt;color:#828282;mso-fareast-language:#2000">Ing.
Ignace Danneels</span></b><span lang="ES"
style="font-size:12.0pt;color:#828282;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES-MX"
style="font-size:10.0pt;color:gray;mso-fareast-language:#2000">Controls
Design Engineer</span><span lang="ES-MX"
style="color:#1F497D;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"
style="font-size:5.0pt;color:#CD0029;mso-fareast-language:#2000">__________________________________________________________________________</span><span
lang="ES-MX"
style="color:#1F497D;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="en-BE"
style="font-size:12.0pt;color:#7F7F7F;mso-fareast-language:#2000">TREMEC</span></b><b><span
lang="EN-US"
style="font-size:12.0pt;color:#7F7F7F;mso-fareast-language:#2000"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:10.0pt;color:#AEAAAA;mso-fareast-language:#2000">Belgium
Phone: +32 50 977766<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="en-BE"><o:p> </o:p></span></p>
<div>
<div
style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US"
style="mso-fareast-language:#2000">From:</span></b><span
lang="EN-US" style="mso-fareast-language:#2000"> Dave
Miller <<a href="mailto:justdave@bugzilla.org"
moz-do-not-send="true" class="moz-txt-link-freetext">justdave@bugzilla.org</a>>
<br>
<b>Sent:</b> Wednesday, 29 March 2023 14:13<br>
<b>To:</b> <a href="mailto:support-list@bugzilla.org"
moz-do-not-send="true" class="moz-txt-link-freetext">support-list@bugzilla.org</a>;
Ignace Danneels <<a
href="mailto:ignace.danneels@tremec.com"
moz-do-not-send="true" class="moz-txt-link-freetext">ignace.danneels@tremec.com</a>><br>
<b>Subject:</b> Re: Bugzilla 5.0.6 Unable to log in
after migration<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="en-BE"><o:p> </o:p></span></p>
<div style="border:solid #F77E39 2.25pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="background:#F9C179"><b><span
lang="en-BE"
style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:#2000">[CYBERSECURITY
DESC] MENSAJE DE UN REMITENTE EXTERNO / MESSAGE FROM AN
EXTERNAL SENDER</span></b><span lang="en-BE"
style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:#2000">
<br>
Toma precauciones extremas, no hagas click en los enlaces.<br>
Take extreme precautions, do not click on unknown links. <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="en-BE"
style="mso-fareast-language:#2000"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span lang="en-BE"
style="mso-fareast-language:#2000">Error 500 indicates
that the webserver is encountering a problem which
should be logged in the error log. That log exists
somewhere, you'll need to find it. Since you're on
Windows it might be in the system wide service logs in
the control panel if it's not somewhere in Apache's
directory structure.<br>
<br>
Also, Bugzilla 5.0.6 is **not** compatible with MySQL 8.
I'm curious to know what you did to make it work, though
I suspect that might be why you're getting the error 500
(but we won't know for sure until you find the logs). My
general suggestion is to use MariaDB instead (which is a
drop in replacement for MySQL).<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span
lang="en-BE" style="mso-fareast-language:#2000"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span lang="en-BE"
style="mso-fareast-language:#2000">On March 29, 2023
7:55:01 AM EDT, Ignace Danneels <<a
href="mailto:ignace.danneels@tremec.com"
moz-do-not-send="true" class="moz-txt-link-freetext">ignace.danneels@tremec.com</a>>
wrote:<o:p></o:p></span></p>
</div>
<blockquote
style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="EN-US">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I hope someone can
help me.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Situation:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We currently have
5.0.3 running on a Windows server using a MYSQL 8
database. The site indicates Bugzilla doesn’t support
MySQL 8, but the conversion was really easy.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We need to migrate
to a new server and took the opportunity to install
the latest version of Bugzilla (I downloaded the targ
Bugzilla-5.0.6.tar.gz) and installed it on the new
server.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I made a duplicate
of the database (to ensure nothing gets corrupted
while testing).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I installed
StrawBerry Perl, then applied the same changes to
ensure compatibility with MYSQL 8. I ran perl
checksetup.pl and passed. The site is up and running,
I can see the existing bugs and so one, but I can’t
log in!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Then I read in the
documentation about moving, so I copied the ‘old’ data
folder to the new installation, but it results in the
same error as below.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I looked at the
profiles table, and my account does have a crypted
password, but as the configuration was changed (ages
ago) to use an LDAP, I doubt if the crypted password
has anything to do with the LDAP password.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We use an ldap
server, so I thought about copying ONLY the
params.json file from the old server onto the new one
(to transfer the settings), but then I get an error
that it’s missing some resources and that’s it.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><img border="0"
width="772" height="142"
style="width:8.0416in;height:1.475in"
id="_x0000_i1031"
src="cid:image003.png@01D96245.EB9B9DD0"
moz-do-not-send="true"></span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">It doesn’t
indicate what the problem is, and there’s no errorlog
on the server neither. So I’m just ‘floating in
darkness’…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I would appreciate
if someone could give me a helping hand.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I you could
provide me with a profile record that has admin rights<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thank you (in
advance) for any help you can offer me.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span lang="en-BE"
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:#2000">Best
regards,</span><span lang="en-BE"
style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D;mso-fareast-language:#2000"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="en-BE"
style="color:#1F497D;mso-fareast-language:#2000"> <o:p></o:p></span></p>
</div>
<table class="MsoNormalTable" border="0"
cellspacing="0" cellpadding="0" width="623"
style="width:467.5pt;border-collapse:collapse">
<tbody>
<tr>
<td width="258" valign="bottom"
style="width:193.5pt;border:none;border-right:solid #A6A6A6 1.5pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"
style="line-height:115%"><b><span
lang="EN-US"
style="font-size:12.0pt;line-height:115%;color:#E51736">Ing. Ignace
Danneels</span></b><b><span
lang="EN-US"
style="font-size:12.0pt;line-height:115%;font-family:"Helvetica",sans-serif;color:#E51736">
<o:p></o:p></span></b></p>
<p class="MsoNormal"
style="line-height:115%"><span
lang="EN-US"
style="font-size:10.0pt;line-height:115%;font-family:"Helvetica",sans-serif">Controls
Design Engineer<o:p></o:p></span></p>
<p class="MsoNormal"
style="line-height:115%"><b><span
lang="FR-BE"
style="font-size:12.0pt;line-height:115%;font-family:"Helvetica",sans-serif;color:black">TREMEC<o:p></o:p></span></b></p>
<p class="MsoNormal"
style="line-height:115%"><b><span
lang="FR-BE"
style="font-size:10.0pt;line-height:115%;font-family:"Helvetica",sans-serif">TORQUE
TRANSFER SOLUTIONS<o:p></o:p></span></b></p>
<p class="MsoNormal"
style="text-autospace:ideograph-other"><span
lang="EN-US"
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><a
href="mailto:Ignace.Danneels@tremec.com" moz-do-not-send="true"
class="moz-txt-link-freetext">Ignace.Danneels@tremec.com</a><u><span
style="color:red">
<o:p></o:p></span></u></span></p>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:12.0pt"><a
href="http://tremec.com/"
moz-do-not-send="true"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#E51936">tremec.com</span></a></span><span
lang="EN-US"
style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><o:p></o:p></span></p>
</td>
<td width="30" valign="bottom"
style="width:22.5pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span lang="EN-US"
style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</td>
<td width="335" valign="bottom"
style="width:251.5pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span lang="EN-US"
style="font-size:12.0pt"><img border="0"
width="173" height="70"
style="width:1.8in;height:.725in"
id="_x0000_i1030"
src="cid:image001.jpg@01D96244.287B07B0" moz-do-not-send="true"></span><span
lang="EN-US"
style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:12.0pt"><img border="0"
width="78" height="46"
style="width:.8166in;height:.4833in"
id="_x0000_i1029"
src="cid:image002.png@01D96244.287B07B0" moz-do-not-send="true"></span><span
lang="EN-US"
style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"
style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="en-BE" style="mso-fareast-language:#2000"><o:p> </o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="en-BE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="en-BE"
style="mso-fareast-language:#2000"><o:p> </o:p></span></p>
<div class="MsoNormal" align="center"
style="text-align:center"><span lang="en-BE"
style="mso-fareast-language:#2000">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span lang="en-BE"
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:gray;mso-fareast-language:#2000"><br>
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 <a href="https://kuo.com.mx/avisos-privacidad"
moz-do-not-send="true" class="moz-txt-link-freetext">
https://kuo.com.mx/avisos-privacidad</a>. 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.<br>
<br>
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
<a href="https://kuo.com.mx/avisos-privacidad"
moz-do-not-send="true" class="moz-txt-link-freetext">https://kuo.com.mx/avisos-privacidad</a>.
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.</span><span
lang="en-BE" style="mso-fareast-language:#2000"><o:p></o:p></span></p>
</blockquote>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="en-BE"
style="mso-fareast-language:#2000">-- <br>
Sent from my Android phone with K-9 Mail. Please
excuse my brevity.<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
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
<a class="moz-txt-link-freetext" href="https://kuo.com.mx/avisos-privacidad">https://kuo.com.mx/avisos-privacidad</a>. 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.<br>
<br>
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
<a class="moz-txt-link-freetext" href="https://kuo.com.mx/avisos-privacidad">https://kuo.com.mx/avisos-privacidad</a>. 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.<br>
</font>
</blockquote>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>
</div>
<pre class="moz-signature"
signature-switch-id="b92106bf-d939-4138-a809-9ca6ed6839b0" cols="72"></pre>
</body>
</html>