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
Subject: Vexing permissions issue with partitioned CREATE TABLE
All -
Thanks in advance for help with a sticky problem.
I'm attempting to create a partitioned table thus:
CREATE TABLE `my_precious_table` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`startTimeStamp` datetime
not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
transmission.
Date: Fri, 5 Dec 2008 15:44:06 -0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Vexing permissions issue
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
distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
transmission.
Date: Fri, 5 Dec 2008 15:44:06 -0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Vexing permissions issue with partitioned CREATE
-0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Vexing permissions issue with partitioned CREATE TABLE
All -
Thanks in advance for help with a sticky problem.
I'm attempting to create a partitioned table thus:
CREATE TABLE
.
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
All -
Thanks in advance for help with a sticky problem.
I'm attempting to create a partitioned table thus:
CREATE TABLE `my_precious_table` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`startTimeStamp` datetime NOT NULL DEFAULT '-00-00 00:00:00',
PRIMARY KEY (`id`,`startTimeStamp`)
)
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
Subject: Vexing permissions issue with partitioned CREATE TABLE
All -
Thanks in advance for help with a sticky problem.
I'm attempting to create a partitioned table thus:
CREATE TABLE `my_precious_table` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`startTimeStamp` datetime NOT NULL
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
13 matches
Mail list logo