<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<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 Definitions */
@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;}
/* Style Definitions */
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;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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]-->
</head>
<body lang="en-BE" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Glad that has your approval </span><span lang="EN-US" style="font-family:"Segoe UI Emoji",sans-serif">😊</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Perhaps you can help me with the following:<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’ve been comparing the params.json from the ‘old’ configuration with the ‘new’ one.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I run into 500- Internal Server Error when I port the following:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><img width="737" height="90" style="width:7.675in;height:.9333in" id="Picture_x0020_4" src="cid:image001.png@01D96254.12DDF010"></span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">In the original configuration, the user_verify_class is “DB”, and the 2 parameters below are originally 0.<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 used the default Strawberry Perl installation.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Oh, stupid me: I just noticed there’s an optional perl-ldap.
<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 tried to “ppm install perl-ldap”, but I get the following error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><img width="562" height="69" style="width:5.85in;height:.7166in" id="Picture_x0020_5" src="cid:image002.png@01D96255.1F410F80"></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">Do you know what I should do now?<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 <justdave@bugzilla.org>
<br>
<b>Sent:</b> Wednesday, 29 March 2023 15:22<br>
<b>To:</b> support-list@bugzilla.org; Ignace Danneels <ignace.danneels@tremec.com><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>
<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">Ah, that makes sense what you did. That's one of the ideas we've tossed around about how to deal with it is renaming that table. There's a few options being discussed right now, another
is just making it quote the table name properly.<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 8:34:16 AM EDT, Ignace Danneels <<a href="mailto:ignace.danneels@tremec.com">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-right:0cm">
<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">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">support-list@bugzilla.org</a>; Ignace Danneels <<a href="mailto:ignace.danneels@tremec.com">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">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.4833in" id="_x0000_i1032" src="cid:image003.png@01D96245.EB9B9DD0"></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">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/"><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:.7333in" id="_x0000_i1031" src="cid:image001.jpg@01D96244.287B07B0"></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_i1030" src="cid:image002.png@01D96244.287B07B0"></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">
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">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>
<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">
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">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 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.<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 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.<br>
</font>
</body>
</html>