Mathais: I would like to appeal your decision on this on the basis that mysqld already applies the necessary restriction and that the apparmor restriction is redundant, plus it is not granular per user. MySQL defaults to having LOAD DATA INFILE off due to the Files Privilege being off.
<This is due to the apparmor profile for mysqld that disallows the mysqld process to read files in /var/www.> On 7.04 all I needed was to GRANT FILES PRIVILEGES to use LOAD DATA INFILE. As it is now, apparmor thwarts my user-level GRANTS. <See https://wiki.ubuntu.com/DebuggingApparmor for more information on this.> Here is what I did and it seems to work: [EMAIL PROTECTED]:~$ sudo aa-complain /usr/sbin/mysqld [sudo] password for gelmjw: Setting /usr/sbin/mysqld to complain mode. [EMAIL PROTECTED]:~$ sudo /etc/init.d/apparmor reload Reloading AppArmor profiles : done. [EMAIL PROTECTED]:~$ Thanks for the link. However I believe this is a workaround. Of course, I could be totally ignorant on this, so if there is a link to help understand why the apparmor restriction is there, I would be happy to be informed. Thank You; John -- File load data infile'file-name' fails https://bugs.launchpad.net/bugs/244406 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
