Completely horked my rt database connection

Following Jesse’s suggestion to run mysqltuner, I didn’t pay close enough attention to what I was doing and ran the script as admin, which didn’t look at my rt database. I removed innoDB, as per it’s recommendation, and now my entire install is horked. I suspect that it re-created my mysql users, which is what’s causing the problem, but I can’t find where RT configures this so I can reset it. Help!

Kimberly McKinnis
System Operations Engineer
Service Provider Division, TiVo Inc
408-519-9607

It may have added a line to your my.cnf … usually in /etc/mysql/my.cnf

skip-innodb

You will want to #comment that. There may be other settings but that
will skip the innodb engine and won’t initialize your database.

Kimberly McKinnis wrote:

That’s exactly what it was. Thank you.From: Curtis Bruneau [mailto:curtisb@vianet.ca]
Sent: Tuesday, April 07, 2009 12:49 PM
To: Kimberly McKinnis; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] completely horked my rt database connection

It may have added a line to your my.cnf … usually in /etc/mysql/my.cnf

skip-innodb

You will want to #comment that. There may be other settings but that
will skip the innodb engine and won’t initialize your database.

Kimberly McKinnis wrote:

Following Jesse’s suggestion to run mysqltuner, I didn’t pay close
enough attention to what I was doing and ran the script as admin,
which didn’t look at my rt database. I removed innoDB, as per it’s
recommendation, and now my entire install is horked. I suspect that it
re-created my mysql users, which is what’s causing the problem, but I
can’t find where RT configures this so I can reset it. Help!

~~

Kimberly McKinnis

System Operations Engineer

Service Provider Division, TiVo Inc

408-519-9607



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com