On Sun, Apr 12, 2009 at 2:31 PM, Asif Iqbal <[email protected]> wrote:
> On Sun, Apr 12, 2009 at 2:24 PM, Asif Iqbal <[email protected]> wrote: > >> (user)@webrt:~$ mysql -u root -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 11 to server version: 4.0.24-log >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> use rt3; >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Didn't find any fields in table 'sessions' >> Database changed >> mysql> > > > mysql> desc sessions; > ERROR 1016: Can't open file: 'sessions.MYI'. (errno: 145) > > Looks like sessions table is gone? Do I need to recreate it ? > ls -al /usr/local/mysql/data/rt3 [..] -rw-rw---- 1 mysql mysql 149122960 Apr 12 07:42 sessions.MYD -rw-rw---- 1 mysql mysql 12666880 Apr 12 08:29 sessions.MYI Is it possible that the sessions table is corrupted? > > >> >> When I try to connect to RT (from cli) I get similar error >> >> RT couldn't store your session.<br>This may mean that that the directory >> '/opt/rt3/var/session_data' >> isn't writable or a database table is missing or corrupt. >> >> How do I fix it? >> >> I am using RT 3.4.5 with Perl 5.8.6 and mysql 4.0.24 >> > -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
