<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=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:90973276;
mso-list-type:hybrid;
mso-list-template-ids:-1909045532 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Trying to upgrade from RT 4.2.1 to 4.2.4 with a remote SSL required Mysql server. I’ve had the current version working fine for months by modifying /opt/rt/lib/RT/Handle.pm as such, where ++ denotes added lines. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>sub BuildDSN {<o:p></o:p></p><p class=MsoNormal> my $self = shift;<o:p></o:p></p><p class=MsoNormal> # Unless the database port is a positive integer, we really don't want to pass it.<o:p></o:p></p><p class=MsoNormal> my $db_port = RT->Config->Get('DatabasePort');<o:p></o:p></p><p class=MsoNormal> $db_port = undef unless (defined $db_port && $db_port =~ /^(\d+)$/);<o:p></o:p></p><p class=MsoNormal> my $db_host = RT->Config->Get('DatabaseHost');<o:p></o:p></p><p class=MsoNormal> $db_host = undef unless $db_host;<o:p></o:p></p><p class=MsoNormal> my $db_name = RT->Config->Get('DatabaseName');<o:p></o:p></p><p class=MsoNormal> my $db_type = RT->Config->Get('DatabaseType');<o:p></o:p></p><p class=MsoNormal> $db_name = File::Spec->catfile($RT::VarPath, $db_name)<o:p></o:p></p><p class=MsoNormal> if $db_type eq 'SQLite' && !File::Spec->file_name_is_absolute($db_name);<o:p></o:p></p><p class=MsoNormal> ++ my $DBDriver = $RT::DatabaseType;<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> ++$DBDriver .= ":mysql_read_default_file=$RT::MySQLClientConfigFile" if<o:p></o:p></p><p class=MsoNormal> ++(defined $RT::MySQLClientConfigFile);<o:p></o:p></p><p class=MsoNormal> my %args = (<o:p></o:p></p><p class=MsoNormal> Host => $db_host,<o:p></o:p></p><p class=MsoNormal> Database => $db_name,<o:p></o:p></p><p class=MsoNormal> Port => $db_port,<o:p></o:p></p><p class=MsoNormal> ++Driver => $DBDriver,<o:p></o:p></p><p class=MsoNormal> RequireSSL => RT->Config->Get('DatabaseRequireSSL'),<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have already run make upgrade, copied my changes to Handle.pm and verified that the connection works using the web interface. Make upgrade-database fails however saying “access denied for <user@RTwebhostname> (using password: YES)” <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Can anyone think of a way to:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]> For the make upgrade-database script to use the connection specified in RT_SiteConfig that works… or<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Do a manual database upgrade using a manual connection via mysql –D …. Etc. etc. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’d very much appreciate any assistance!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Jim<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'>Jim Pollard<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>IT Coordinator<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Department of Biomedical Engineering<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>University of Texas at Austin<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><a href="mailto:it@bme.utexas.edu"><span style='color:blue'>it@bme.utexas.edu</span></a><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>512.471.7576<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>"</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>It’s a strange thing about determined seekers-after-wisdom that, no matter where they happen to be, they’ll always seek that wisdom which is a long way off. Wisdom is one of the few things that looks bigger the farther away it is."<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Terry Pratchett</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>