118 reputation
15
bio website
location
age
visits member for 5 years, 5 months
seen yesterday

Aug
7
awarded  Supporter
Nov
25
awarded  Notable Question
Sep
22
awarded  Popular Question
Apr
29
awarded  Tumbleweed
Jun
5
awarded  Scholar
Jun
5
accepted Fixing “Can't find file: … (errno: 13)” on mysql
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
"restorecon -R -v /var/lib/mysql/tablename" looks to have fixed it
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
Yup, it was selinux. I found it just before I read your message.
Jun
5
awarded  Student
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
The cwd is /var/lib/mysql, which would be correct. Besides, wouldn't that affect any other db operation? I can use the other schemas just fine, it's only this one that's the problem.
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
Sure, it was just a temporary check since nothing else was working. Also, the files are owned by the mysql user.
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
31285 open("./schemaname/tablename.frm", O_RDONLY|O_LARGEFILE) = -1 EACCES (Permission denied) Other than a Fcntl flag I haven't seen before, that doesn't tell me much. Also this is a "legacy" app that is supposed to be replaced "any second now", so my options for modifications/upgrades are non-existant.
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
Also "myisamchk -r" didn't fix anything and "repair table" in mysql results in the same error.
Jun
5
comment Fixing “Can't find file: … (errno: 13)” on mysql
Note: I've tried chmodding everything to 777
Jun
5
asked Fixing “Can't find file: … (errno: 13)” on mysql