Thanks to everyone who offered their suggestions. Those of you who
suggested I look into SElinux were correct - my admin adjusted the policy
and rebooted the server, and my problem is solved.
I've never run across that issue before, but I'll know to look for it in the
future. The list the
Per -
I am finding a lot of exit=-13 entries for the mysql user, but that's the
same information as in the original error message. Is there anything else
you're suggesting I look for?
- Brad
On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen [EMAIL PROTECTED] wrote:
Brad Heintz wrote:
Thanks for
John -
I've chowned the pertinent directories to mysql:mysql and chmoded them to
700. Still no change in the result. For laughs, I tried chown and chmod
with a --reference of an existing, working data directory in /var/lib/mysql,
but again, no change.
- Brad
On Sat, Dec 6, 2008 at 10:40 AM,
Brad, what user are you running the mysql server as? Have you created a
mysql user and group (or another user and group) to run the server and
set a user= option in the cnf file?
Are you absolutely sure all necessary files and directories are owned
and readable/writable only by the mysql user?
Brad Heintz wrote:
Thanks for responding.
The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX
DIRECTORY take absolute paths (not relative), and will in fact reject
paths containing
the MySQL data dir. Because I'm out of other ideas, I did try
creating the directories under
John -
I've seen people confuse MySQL users with OS users, too. I'm not doing
that, and I understand the difference between MySQL privs and filesystem
permissions. MySQL is running as the mysql user. I'm running the query as
MySQL's root.
I am able to create partitioned or non-partitioned
permissions issue with partitioned CREATE TABLE
John -
I've seen people confuse MySQL users with OS users, too. I'm not doing
that, and I understand the difference between MySQL privs and filesystem
permissions. MySQL is running as the mysql user. I'm running the query as
MySQL's root.
I am
.
Date: Sat, 6 Dec 2008 10:40:17 -0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Vexing permissions issue with partitioned CREATE TABLE
John -
I've seen people confuse MySQL users with OS users, too. I'm not doing
that, and I understand the difference
I've never created a partitioned table, but...
$ perror 13
OS error code 13: Permission denied
So I suspect some kind of file-system permissions issue...
Are you sure that the path you are giving isn't relative to the mysql data
dir?
In which case it's trying to use something more
Thanks for responding.
The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX DIRECTORY
take absolute paths (not relative), and will in fact reject paths containing
the MySQL data dir. Because I'm out of other ideas, I did try creating the
directories under the MySQL data dir and it
Thanks, Martin, but that's not it. As I mentioned in my email, I'm running
as MySQL root user with all priv bits set. I tried your suggestion anyway,
but no change.
Cheers,
- Brad
On Fri, Dec 5, 2008 at 4:34 PM, Martin Gainty [EMAIL PROTECTED] wrote:
Brad-
log into mysql as admin
GRANT
Brad Heintz wrote:
I've googled extensively, searched the list archives, and exhausted every
other avenue I could think of before posting to the list, but am no closer
to an answer. Does anyone have any ideas? Have I missed something in the
docs?
SELinux?
--
Florin Andrei
12 matches
Mail list logo