RT Database - RESOLVED

Wash,

This may not help (or even match your scenario), but then again it may so

Last week our machine crashed - following a recovery RT was behaving
weirdly - could see stuff and create tickets but couldn’t add comments.

We are use MySQL and it turned out a couple of tables (indexes actually)
were marked as corrupt - running repair table resolved the problems.

Corruption was identified with :-
mysqlcheck --defaults-file=.my.cnf --all-databases --check --extended

Tables repaired using ‘mysql> repair table’, full details in MySQL
documentation.

It turned out that complex queries in MySQL need write access to the temp
directory, and permissions were denying this.

-Wash

Odhiambo Washington wash@wananchi.com "The box said 'Requires
Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,'
Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD."
GSM: +254 72 743223 +254 733 744121 This sig is McQ! :slight_smile:

Meeting, n.:
An assembly of people coming together to decide what person or
department not represented in the room must solve a problem.