[rt-users] RT [Transactions] failing after Fedora upgrade

[Jay Vlavianos]

Ok, just to close this out (for the digest & history).  I did a :

yum remove perl-DBD-MySQL
cpan && get DBD-mysql
configure, make and makeinstall DBD-mysql from the /root/.cpan/build
directory
I had to skip the make test for some reason because it would hang... but
RT is back up and running now.

I will need to be very careful from now on with yum.  Heretofore I have
had no problems at all with yum, in fact I have used yum to upgrade my
Fedora core to each new distro release with virtually no pain at all.

Well, now I am a little gun-shy :)

Thanks!
-Jay


-----Original Message-----
From: Drew Barnes [mailto:barnesaw at ucrwcu.rwc.uc.edu] 
Sent: Thursday, July 09, 2009 11:46 AM
To: Jay Vlavianos
Cc: Agnislav Onufrijchuk; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade


Jay Vlavianos wrote:
> Thanks for responding:
>
> Rpm -qa reports : perl-DBD-MySQL-4.005-8.fc9.i386
>   

I suspect you may need to rebuild DBD::mysql and/or DBI.  This is why 
yum/rpm never touches perl on my systems.  It never does anything GOOD, 
it only breaks things.  Package management is fine if you never need to 
install anything any other way, but if you need to touch cpan even once,

you're likely hosed after each update.

> All tables in the rt3 database are InnoDB except sessions
>
> I don't have a my.cnf so mysql is loading with defaults, but since the
> DB is InnoDB I would imagine that it is running?
>
> Thanks,
> -Jay
>
>
> -----Original Message-----
> From: Agnislav Onufrijchuk [mailto:Agnislav.Onufrijchuk at portaone.com] 
> Sent: Thursday, July 09, 2009 12:27 AM
> To: Jay Vlavianos
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade
>
> Jay Vlavianos wrote:
>   
>> Transactions not supported by database at 
>> /usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line
>>     
> 1674.
>   
>
> What DBD::mysql version do you use? Do you have InnoDB engine enabled
in
> your 
> my.cnf ?
>
>
>