We're trying to use a NetApp StoreVault S500 as a storage location for backups of a MySQL database using Zmanda's ZRM for MySQL Enterprise. Both the database server and the backup server are running Ubuntu Linux 9.10 (Karmic). The StoreVault is, of course, running NetApp's proprietary Data ONTAP software.
We have exported a directory on the StoreVault in /vol/exports as an NFS share, and have mounted the share on the backup server. Both the 'mysql' user and the 'root' user must access this share at times during the backup process, and must do so both from the backup server and the database server. The 'mysql' user successfully creates a new directory for a backup, but then runs a command in that directory with sudo. The command fails because, for some reason, the 'root' user does not have access to the directory 'mysql' created! We tried the options for security in the Manage Exports dialog of the StoreVault Manager software to attempt to give all users from that host access as 'root', but that did not help matters.
I am attaching the contents of our /vol/vol0/etc/exports file on the StoreVault, which I believe shows the permissions.
Can anyone offer advice? Where are we going wrong? The support technicians at Zmanda are convinced that it is a permissions error on the StoreVault side, but can offer no solution.
#Auto-generated by setup Sun Mar 14 01:04:16 GMT 2010