Trouble with MySQL Server

2018-05-14 Thread Lofgren, Eric
I’m running a SL 7 server that’s being used for a couple data projects using MySQL Server - which I confess I don’t know much about. Two have my students have both encountered errors recently, either joining tables or just restarting MySQL Server, with the logs reading things to the effect of:

Re: Trouble with MySQL Server

2018-05-14 Thread Andrew C Aitchison
On Tue, 15 May 2018, Lofgren, Eric wrote: I’m running a SL 7 server that’s being used for a couple data projects using MySQL Server - which I confess I don’t know much about. Two have my students have both encountered errors recently, either joining tables or just restarting MySQL Server,

Re: Trouble with MySQL Server

2018-05-15 Thread Steven Haigh
On 2018-05-15 14:33, Lofgren, Eric wrote: I’m running a SL 7 server that’s being used for a couple data projects using MySQL Server - which I confess I don’t know much about. Two have my students have both encountered errors recently, either joining tables or just restarting MySQL Server, with th

Re: Trouble with MySQL Server

2018-05-15 Thread Lofgren, Eric
Having failed to fix the ugly partition system, we’re going for reconfiguring mysql to make it elsewhere. I followed this post to try to get the temporary directory to point to another partition: https://encylia.com/2015/02/06/how-to-change-the-mysql-tmp-location-on-centos/ by doing all of the

Re: Trouble with MySQL Server

2018-05-16 Thread Paddy Doyle
On Wed, May 16, 2018 at 01:53:37AM +, Lofgren, Eric wrote: > Having failed to fix the ugly partition system, we???re going for > reconfiguring mysql to make it elsewhere. I followed this post to try to get > the temporary directory to point to another partition: > https://encylia.com/2015/0

Re: Trouble with MySQL Server

2018-05-16 Thread Mark Stodola
On 05/15/2018 08:53 PM, Lofgren, Eric wrote: Having failed to fix the ugly partition system, we’re going for reconfiguring mysql to make it elsewhere. I followed this post to try to get the temporary directory to point to another partition: https://encylia.com/2015/02/06/how-to-change-the-mysq

Re: Trouble with MySQL Server

2018-05-16 Thread Nico Kadel-Garcia
On Wed, May 16, 2018 at 9:15 AM Mark Stodola wrote: > On 05/15/2018 08:53 PM, Lofgren, Eric wrote: > > Having failed to fix the ugly partition system, we’re going for reconfiguring mysql to make it elsewhere. I followed this post to try to get the temporary directory to point to another partition

Re: Trouble with MySQL Server

2018-05-16 Thread Lofgren, Eric
It looks like we have a winner. chown doesn’t work, but checking selinux, I get a number of denied {write} notices for that directory. It looks like selinux is preventing writing to that directory. Is there a way to change that? I confess selinux is utterly opaque to me. Eric > On May 16, 2018

Re: Trouble with MySQL Server

2018-05-16 Thread Paul Robert Marino
x isn't that hard to deal with once you know the basic tools.   Original Message   From: eric.lofg...@wsu.edu Sent: May 16, 2018 8:34 PM To: pa...@tchpc.tcd.ie Cc: scientific-linux-users@fnal.gov Subject: Re: Trouble with MySQL Server It looks like we have a winner. chown doesn’t work, but che