Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-08 Thread Brad Heintz
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

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-07 Thread Brad Heintz
gt;> > retry FILE operation >> > >> > Martin >> > __ >> > Disclaimer and confidentiality note >> > Everything in this e-mail and any attachments relates to the official >> > business of Sender. This tra

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-07 Thread Brad Heintz
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

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-06 Thread Brad Heintz
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

2008-12-06 Thread Martin Gainty
: 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.

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-06 Thread Brad Heintz
ature and Sender > > does 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 > > >

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-06 Thread Per Jessen
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

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-06 Thread John Daisley
ly 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 CRE

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Florin Andrei
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

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Brad Heintz
> > > > > > Date: Fri, 5 Dec 2008 15:44:06 -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

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Brad Heintz
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

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread ceo
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

Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread Brad Heintz
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`) ) ENGINE