118 reputation
15
bio website
location
age
visits member for 5 years, 1 month
seen Jun 19 at 20:29

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