<!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] RT and mysql 5.0 segfault</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Courier New">A bit of info about the env:</FONT>
<BR><FONT SIZE=2 FACE="Courier New">RHEL4.6_i386</FONT>
<BR><FONT SIZE=2 FACE="Courier New">RT version 3.6.6</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Apache 2.0.52-38</FONT>
<BR><FONT SIZE=2 FACE="Courier New">MySQL-standard 5.0.24a-0</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">After a bit of stracing the running httpd processes, I found some information leading up to the segfault.</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">munmap(0xb7f6d000, 4096) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">socket(PF_FILE, SOCK_STREAM, 0) = 1</FONT>
<BR><FONT SIZE=2 FACE="Courier New">fcntl64(1, F_GETFL) = 0x2 (flags O_RDWR)</FONT>
<BR><FONT SIZE=2 FACE="Courier New">connect(1, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">setsockopt(1, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)</FONT>
<BR><FONT SIZE=2 FACE="Courier New">setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, ">\0\0\0", 4) = 4</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) = 62</FONT>
<BR><FONT SIZE=2 FACE="Courier New">open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)</FONT>
<BR><FONT SIZE=2 FACE="Courier New">write(1, "\24\0\0\1\217 \0\0\0rt\XXXXXXX\0rt3", 24) = 24</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, "\5\0\0\2", 4) = 4</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, "\0\0\0\2\0", 5) = 5</FONT>
<BR><FONT SIZE=2 FACE="Courier New">fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, 0xc0977b8, 8192) = -1 EAGAIN (Resource temporarily unavailable)</FONT>
<BR><FONT SIZE=2 FACE="Courier New">fcntl64(1, F_SETFL, O_RDWR) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">write(1, "\21\0\0\0\3set autocommit=1", 21) = 21</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, "\5\0\0\1", 4) = 4</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(1, "\0\0\0\2\0", 5) = 5</FONT>
<BR><FONT SIZE=2 FACE="Courier New">time(NULL) = 1206447319</FONT>
<BR><FONT SIZE=2 FACE="Courier New">time(NULL) = 1206447319</FONT>
<BR><FONT SIZE=2 FACE="Courier New">--- SIGSEGV (Segmentation fault) @ 0 (0) ---</FONT>
<BR><FONT SIZE=2 FACE="Courier New">chdir("/etc/httpd") = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">kill(5043, SIGSEGV) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">sigreturn() = ? (mask now [])</FONT>
<BR><FONT SIZE=2 FACE="Courier New">--- SIGSEGV (Segmentation fault) @ 0 (0) ---</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Process 5043 detached</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">There is no /usr/share/mysql/charsets/Index file, but copying an old version from a 3.0 mysql server gives</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = 36</FONT>
<BR><FONT SIZE=2 FACE="Courier New">fstat64(36, {st_mode=S_IFREG|0755, st_size=549, ...}) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7e63000</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) = 549</FONT>
<BR><FONT SIZE=2 FACE="Courier New">read(36, "", 4096) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">close(36) = 0</FONT>
<BR><FONT SIZE=2 FACE="Courier New">munmap(0xb7e63000, 4096) = 0</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">The data and segfault there after are pretty much the same</FONT>
<BR><FONT SIZE=2 FACE="Courier New">I have tried installing shared-compat libs for mysql as we were using shared-standard, but this did not change anything either.</FONT></P>
<P><FONT SIZE=2 FACE="Courier New">Anyone able to make more sense out of this than I or perhaps point me in the right direction. It would be much appreciated.</FONT></P>
<P><FONT SIZE=2 FACE="Courier New">Cheers,</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">-------------------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">Did anyone ever figure this out? I am having the same problem. At<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">first I had the regular password style:<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">DBI connect('dbname=rt3;host=localhost','rt',...) failed: Client does<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">not support authentication protocol requested by server; consider<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">upgrading MySQL client at<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 106<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">[Wed Mar 19 14:06:33 2008] [error] [client 10.20.1.102] Connect Failed<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">Client does not support authentication protocol requested by server;<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">Changing the password to use the old_password function gave me:<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT><BR>
<FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">[Wed Mar 19 14:07:37 2008] [notice] child pid 6190 exit signal<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">Segmentation 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">Thanks in advance,<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">Peter Musolino<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">D.B. Zwirn (UK) Ltd.<BR>
</FONT><FONT SIZE=2 FACE="Courier New">></FONT> <FONT SIZE=2 FACE="Courier New">peter.musolino at dbzco dot com<BR>
</FONT><FONT SIZE=2 FACE="Courier New">-------------------------------------------------------------------------------</FONT><BR>
</P>
<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>