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
The rt-users Archives
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