[rt-users] sessions table is lost after a system crash

[Asif Iqbal]

On Sun, Apr 12, 2009 at 2:24 PM, Asif Iqbal <vadud3 at gmail.com> 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 ?


>
> 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?
>
>
>


-- 
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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090412/f07837de/attachment.htm>