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 comm
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, Br
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
ily endorse content contained within this
> transmission.
>
>
>
>
> > 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
>
> >
> >
: 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 between MySQL privs and filesystem
> permissions. MySQL is running as the mysql user.
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 tabl
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 un
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? Set
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
http://florin.my
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
> GR
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 does
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 mor
12 matches
Mail list logo
