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

[Asif Iqbal]

On Sun, Apr 12, 2009 at 2:35 PM, Joop van de Wege
<JoopvandeWege at mococo.nl>wrote:

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

I do not see any mysql.sql file in the src dir of rt 3.4.5

 (root)@webrt:/usr/src/rt-3.4.5# find . -type f | grep mysql
./etc/upgrade/3.1.0/acl.mysql
./etc/upgrade/3.1.0/schema.mysql
./etc/upgrade/3.3.0/acl.mysql
./etc/upgrade/3.3.0/schema.mysql
./etc/upgrade/3.3.11/acl.mysql
./etc/upgrade/3.3.11/schema.mysql
./etc/constraints.mysql
./etc/acl.mysql
./etc/schema.mysql


> Regards,
>
> Joop
>



-- 
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/b4c72de1/attachment.htm>