[rt-users] sessions table is lost after a system crash
Joop van de Wege
JoopvandeWege at mococo.nl
Sun Apr 12 04:35:22 EDT 2009
Asif Iqbal 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>
>
> 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?
Have a look at the mysql.sql file in your setup folder of RT or download
rt and recreate the table.
Regards,
Joop
More information about the rt-users
mailing list