yeh, there was a mysql permissions thing, but we fixed that, now we still
get the same rt errors, but no errors in apache. so they obviously werent
linked.
also, if i uncomment the line 89 that has the die statement, it all works
fine.
weirdFrom: Matthew Watson [mailto:matthew.watson@staff.netspace.net.au]
Hmm. Well, those (if I call correctly) are mysql’s data files… so are you
able to check that mysql came up cleanly?
Regards,
Matt.
From: Andrew Xenides [mailto:andrew@staff.esc.net.au]
on further investigation. the apache error logs show
DBD::mysql::st execute failed: Can’t find file: ‘./rt3/Users.frm’ (errno:
13) at /usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 480.
RT::Handle=HASH(0x12ff3104) couldn’t execute the query ‘SELECT * FROM Users
WHERE Name = ?’ at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
DBD::mysql::st execute failed: Can’t find file: ‘./rt3/Users.frm’ (errno:
13) at /usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 480.
RT::Handle=HASH(0x12ff3104) couldn’t execute the query ‘SELECT * FROM Users
WHERE Name = ?’ at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
for each load.
now, could this file have been deleted somehow? how can i recreate it?
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Andrew
Xenides
yes, i know, all the permissions are exactly the same as they were before
the reboot.
let me repeat the scenario.
RT is working
reboot server
RT gives error
Andrew Xenides
From: Matthew Watson [mailto:matthew.watson@staff.netspace.net.au]
Umm, not to be rude, but have you read the error message?
“RT Couldn’t write to session directory ‘/opt/rt3/var/session_data’”
Further down, it even tells you what to do about it
“Check that this dir ectory’s permissions are correct.”
Regards,
Matt.
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Andrew
Xenides
we rebooted the rt server and now get this error when trying to bring up the
login screen
any ideas?
error:
RT Couldn’t write to session directory ‘/opt/rt3/var/session_data’: Died at
/usr/local/lib/perl5/site_perl/5.8.5/Apache/Session/Generate/MD5.pm line 40.
Stack:
[/usr/local/lib/perl5/site_perl/5.8.5/Apache/Session/Generate/MD5.pm:40]
[/usr/local/lib/perl5/site_perl/5.8.5/Apache/Session.pm:400]
[/opt/rt3/share/html/Elements/SetupSessionCookie:64]
[/opt/rt3/share/html/autohandler:73]
. Check that this dir ectory’s permissions are correct. at
/opt/rt3/share/html/Elements/SetupSessionCookie line 89.
context:
…
85:
};
86:
undef $cookies{$cookiename};
87:
}
88:
else {
89:
die “RT Couldn’t write to session directory ‘$RT::MasonSessionDir’: $@.
Check that this dir ectory’s permissions are correct.”;
90:
}
91:
}
92:
93:
if ( !$cookies{$cookiename} ) {
…
code stack:
/opt/rt3/share/html/Elements/SetupSessionCookie:89
/opt/rt3/share/html/autohandler:73
Andrew Xenides