These were just simple patches which had not been applied and included all the patches available. We don't use Sun's apache or perl and are careful not to for this very reason. (Ditto sendmail, but that isn't relevant to this issue). The other possibility is that the server might not have been rebooted, and therefore apache not restarted, since Christmas so some perl modules might have changed in the mean time, but not been loaded since they changed. I have to check that.
<br><br>Thanks,<br>Steve.<br><br><div><span class="gmail_quote">On 3/7/07, <b class="gmail_sendername"><a href="mailto:jmoseley@pgtv.com">jmoseley@pgtv.com</a></b> <<a href="mailto:jmoseley@pgtv.com">jmoseley@pgtv.com</a>
> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I would look for perl or apache patches. Were these simply Solaris OS<br>
patches for security, or was this a jumbo patch which includes updates for<br>other installed software. Problem with new versions of Solaris is that<br>they come with Apache, Sendmail, Perl (I believe) - I wouldn't install any
<br>of that if possible...<br><br><br>James Moseley<br><br><br><br><br><br> "Steve Holmes"<br> <<a href="mailto:sholmes42@mac.co">sholmes42@mac.co</a><br> m> To
<br> Sent by: "<a href="mailto:jmoseley@pgtv.com">jmoseley@pgtv.com</a>"<br> <a href="mailto:sholmes42@gmail.c">sholmes42@gmail.c</a> <<a href="mailto:jmoseley@pgtv.com">
jmoseley@pgtv.com</a>><br> om cc<br> "RT Users"<br> <<a href="mailto:rt-users@lists.bestpractical.com">
rt-users@lists.bestpractical.com</a>>,<br> 03/07/2007 02:46 <a href="mailto:rt-users-bounces@lists.bestpractica">rt-users-bounces@lists.bestpractica</a><br> PM <a href="http://l.com">
l.com</a><br> Subject<br> Re: [rt-users] Can't create new<br> tickets, new problem
<br><br><br><br><br><br><br><br><br><br><br>James,<br><br>It looks like 58 patches were applied on the RT server. I can list them for<br>you if you like. No we have not tried to back any of them out.<br><br>I'm not sure how to know which ones would be appropriate to backout. I'm
<br>about to start reading all of the READMEs for the patches to see if I can<br>find anything that stands out.<br><br>Thanks,<br>Steve<br><br>On 3/7/07, <a href="mailto:jmoseley@pgtv.com">jmoseley@pgtv.com</a> <<a href="mailto:jmoseley@pgtv.com">
jmoseley@pgtv.com</a> > wrote:<br> Which Solaris patches were installed? Have you tried backing out of<br> them?<br><br><br> James Moseley<br><br><br><br><br><br> "Steve Holmes"<br> <
<a href="mailto:sholmes42@mac.co">sholmes42@mac.co</a><br> m><br> To<br> Sent by: "RT Users"<br> rt-users-bounces@ <<a href="mailto:rt-users@lists.bestpractical.com">
rt-users@lists.bestpractical.com</a>><br> lists.bestpractic<br> cc<br> <a href="http://al.com">al.com</a><br><br> Subject<br> [rt-users] Can't create new
<br> 03/07/2007 02:15 tickets, new problem<br> PM<br><br><br><br><br><br><br><br><br><br> My install of RT 3.6.1 (on Solaris 10, mysql 5.0.22) has been working<br> very<br> nicely for several months. We only have about 80 tickets, but we have
<br> been<br> able to create tickets with no problems both in the web interface and via<br> email. That is, until today. Now I get:<br><br> error: Transactions not supported by database at<br> /opt/perlsite/lib/site_perl/5.8.7/sun4-solaris/DBI.pm line
<br> 1668.<br><br> context:<br><br> ...<br><br> 1664:<br> sub begin_work {<br> 1665:<br> my $dbh = shift;<br> 1666:<br> return $dbh->set_err(1, "Already in a transaction")
<br><br> 1667:<br> unless $dbh->FETCH('AutoCommit');<br> 1668:<br> $dbh->STORE('AutoCommit', 0); # will croak if<br> driver<br> doesn't support it
<br> 1669:<br> $dbh->STORE('BegunWork', 1); # trigger post<br> commit/rollback action<br> 1670:<br> return 1;<br> 1671:
<br> }<br> 1672:<br><br> ...<br><br><br><br> code /opt/perlsite/lib/site_perl/5.8.7/sun4-solaris/DBI.pm:1668<br> stack: /opt/perlsite/lib/site_perl/5.8.7<br> /DBIx/SearchBuilder/Handle.pm:720
<br> /opt/rt3/lib/RT/Ticket_Overlay.pm:564<br> /opt/rt3/lib/RT/Interface/Web.pm:446<br> /opt/rt3/share/html/Ticket/Display.html:103<br> /opt/rt3/share/html/Ticket/Create.html:300
<br> /opt/rt3/share/html/autohandler:279<br><br><br><br><br> when trying to create a ticket on the web. I get similar, but slightly<br> different errors from an email attempt. I've searched the archives and
<br> the<br> wiki but any mention of the keywords here are from 2002 or so.<br><br> I checked the rt3.Transactions table on the mysql server it it is INNODB.<br> Are there other tables to check?<br><br> I haven't modified RT or the mysql server at all in many weeks. However,
<br> Solaris patches were applied last night. Unfortunately, I can't see<br> anything has changed in the RT or the mysql install. And SearchBuilder is<br> up to date according to CPAN.<br><br> Appreciate any ideas of where to look.
<br><br> Thanks,<br> Steve Holmes<br><br></blockquote></div>