<!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 5.5.2653.12">
<TITLE>HELP!! Mysql and Group woes</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>I showed up to work today and after several months of flawless RT execution, I had several hundred complaints from RT about not being able to create users. This is a problem on all of our Queues.</FONT></P>
<P><FONT SIZE=2>The e-mail I'm getting looks like:</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for this email (***@****).</FONT></P>
<P><FONT SIZE=2>You might need to grant 'Everyone' the right 'CreateTicket' for the queue *****.</FONT>
</P>
<BR>
<P><FONT SIZE=2>This is obviously a problem. I'm quite positive the queue is configured correctly (it's been working for quite some time basically untouched). I've verified this morning that all of the permissions are in fact correct.</FONT></P>
<P><FONT SIZE=2>Poking around the logs reveals:</FONT>
</P>
<BR>
<P><FONT SIZE=2>[Thu Feb 19 16:21:44 2004] [warning]: DBD::mysql::st</FONT>
<BR><FONT SIZE=2>execute failed: Lost connection to MySQL server during</FONT>
<BR><FONT SIZE=2>query at /usr/lib/perl5/site_perl/5.8.0/Apache/Session/Store/DBI.pm</FONT>
<BR><FONT SIZE=2>line 86.</FONT>
<BR><FONT SIZE=2> (/opt/rt3/lib/RT.pm:247)</FONT>
<BR><FONT SIZE=2>[Thu Feb 19 16:21:44 2004] [warning]: DBD::mysql::st</FONT>
<BR><FONT SIZE=2>execute failed: Lost connection to MySQL server during</FONT>
<BR><FONT SIZE=2>query at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm</FONT>
<BR><FONT SIZE=2>line 410.</FONT>
<BR><FONT SIZE=2> (/opt/rt3/lib/RT.pm:247)</FONT>
<BR><FONT SIZE=2>[Thu Feb 19 16:21:44 2004] [warning]:</FONT>
<BR><FONT SIZE=2>RT::Handle=HASH(0x984b5b0) couldn't execute the query</FONT>
<BR><FONT SIZE=2>'SELECT * FROM GroupMembers WHERE GroupId = ? AND</FONT>
<BR><FONT SIZE=2>MemberId = ?' at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm</FONT>
<BR><FONT SIZE=2>line 417.</FONT>
<BR><FONT SIZE=2> (/opt/rt3/lib/RT.pm:247)</FONT>
<BR><FONT SIZE=2>[Thu Feb 19 16:22:41 2004] [warning]:</FONT>
<BR><FONT SIZE=2>GroupMember::Create called with a bogus Group arg (/opt/rt3/lib/RT/GroupMember_Overlay.pm:82)</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Followed by a bounce on basically every new user trying to send us a ticket.</FONT>
</P>
<P><FONT SIZE=2>PLEASE PLEASE help me... I can't find an obvious fix and we're literally bouncing every e-mail that's coming in this morning.</FONT></P>
<P><FONT SIZE=2>Nick Pleis</FONT>
</P>
</BODY>
<!--[object_id=#cesinc.com#]--><P align=center><FONT face=Tahoma size=2><FONT color=#0000ff></FONT></FONT> </P></HTML>