<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>[rt-users] Mysql problems with our RT system</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Courier New">Did anyone ever figure this out? I am having the same problem. At first I had the regular password style:</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">DBI connect('dbname=rt3;host=localhost','rt',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 106</FONT></P>
<P><FONT SIZE=2 FACE="Courier New">[Wed Mar 19 14:06:33 2008] [error] [client 10.20.1.102] Connect Failed Client does not support authentication protocol requested by server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n</FONT></P>
<P><FONT SIZE=2 FACE="Courier New">Changing the password to use the old_password function gave me:</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">[Wed Mar 19 14:07:37 2008] [notice] child pid 6190 exit signal Segmentation fault (11)</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">Thanks in advance,</FONT>
<BR><FONT SIZE=2 FACE="Times New Roman">Peter Musolino</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">D.B. Zwirn (UK) Ltd.</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">52 Conduit Street</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">London, W1S 2YZ</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">Phone: +44 (0) 20 7220 2322</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">Mobile: +44 (0) 79 0953 0687</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">peter.musolino at dbzco dot com</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">I enabled the old password support in my.cnf and then re-started both apache<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">and mysql. When I try to hit the site in the web browser I get a blank<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">page, absolutely nothing with no errors.<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">In the httpd/error_log I get:<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">[Wed May 23 11:08:23 2007] [notice] child pid 28611 exit signal Segmentation<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">fault (11)<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">In the httpd/access_log I get:<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New"><<ip-address>> - - [23/May/2007:09:45:17 -0500] "Get /rt3 HTTP/1.1" 500 662<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">There is nothing in the rt.log.<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">CR<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">>></FONT> <FONT SIZE=2 FACE="Courier New">On 5/23/07, Scott Courtney <</FONT><A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Courier New">scott at 4th.com</FONT></U></A><FONT SIZE=2 FACE="Courier New">> wrote:<BR>
></FONT><FONT SIZE=2 FACE="Courier New">><I></I></FONT><I><BR>
</I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> On Wednesday 23 May 2007 10:58, Carlos Randolph wrote:<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> > I've gone into MySQL and did the whole "OLD_PASSWORD" thing for the<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> RT_USER<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> > account but we still get the same thing. I'm checked to make sure the<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> the<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> > Perl modules are all up to date and they are. I'm not sure what else I<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> > should look at so any help would be appreciated.<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><BR>
</I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> Did you enable old password support in your my.cnf (or equivalent) config<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> file? I believe you can't do it on an account-by-account basis unless it's<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> also enabled at the global level in the server config.<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><BR>
</I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> Kind regards,<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><BR>
</I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> Scott<BR>
</FONT></I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><BR>
</I><FONT SIZE=2 FACE="Courier New">></FONT><FONT SIZE=2 FACE="Courier New">></FONT><I></I><I><FONT SIZE=2 FACE="Courier New"> --</FONT></I>
</P>
<P><FONT SIZE=2 FACE="Arial">--</FONT>
<BR><FONT SIZE=2 FACE="Times New Roman">Peter Musolino</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">D.B. Zwirn (UK) Ltd.</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">52 Conduit Street</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">London, W1S 2YZ</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">Phone: +44 (0) 20 7220 2322</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">Mobile: +44 (0) 79 0953 0687</FONT>
<BR><FONT SIZE=1 FACE="Times New Roman">peter.musolino@dbzco.com</FONT>
</P>
<BR>
<pre>
This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended recipient, you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserves the right to archive
and monitor all e-mail communications through its networks. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and
delete the message and any attachment(s) from your system. Thank you.
</pre></BODY>
</HTML>