The user I am trying it as is not the ROOT user but an additional user. If I login into mySQL at the command prompt as this user I am able to perform the query with no issue so the user would appear to have the permissions available to it to run the LOAD File statement.
Regards, Lee On Sunday, March 25, 2012 3:53:25 PM UTC+1, Matt Woodward wrote: > > On Sun, Mar 25, 2012 at 4:19 AM, Lee <[email protected]> wrote: > >> What details is it you require? Could it be the mySQL admin console it is >> referring to, perhaps the user does not have rights to perform that action >> from a program outside the main SQL console. >> > > I dug into this a bit more and that error message actually comes from the > OpenBD engine itself, specifically line 118 in > com.naryx.tagfusion.cfm.engine.exceptionMessage. > > So at least we're getting somewhere. I wonder if that's the error that > gets thrown when OpenBD itself sees that a setting isn't explicitly enabled > (or is explicitly disabled) in the XML configuration file, so maybe in > MySQL you have to explicitly grant LOAD permissions for this to work? Are > you using a root user at least for testing to eliminate permission issues? > > Couple of threads on all of this: > http://lists.mysql.com/mysql/132200 <http://lists.mysql.com/mysql/132200> > http://objectmix.com/jdbc-java/41828-jdbc-outfile-infile.html<http://objectmix.com/jdbc-java/41828-jdbc-outfile-infile.html> > http://forums.databasejournal.com/showthread.php?t=39584<http://forums.databasejournal.com/showthread.php?t=39584> > > I've never used this feature of MySQL mysql but I'll try to experiment > later today. > > >> Being more of an MS SQL developer this is my first foray into mySQL so >> any guidance even though it might be off topic would be appreciated. >> > > Log into MySQL directly (i.e. not running things via JDBC) as the root > user and see if you can execute the LOAD stuff that way. Did you already > try that? If it works that way and not this way are you using the same > MySQL user? > > So now I'm wondering if maybe your MySQL user doesn't have permissions to > do this (are you trying this as MySQL root user or equivalent just to make > sure it's not permissions on that end?) and that the error coming out of > OpenBD is a bit of a red herring, although I'd think if that were the case > you'd be getting the error from the JDBC driver, not the OpenBD engine. > > -- > Matthew Woodward > [email protected] > http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html<http://www.gnu.org/philosophy/no-word-attachments.html> > -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
