On Wed, Mar 26, 2008 at 6:21 PM, Matt McCutchen <[EMAIL PROTECTED]> wrote: > On Tue, 2008-03-25 at 23:21 +0530, Kaushal Shriyan wrote: > > How do i set the "sms" user on hostaa to have permission to set > > permissions on > > /var/lib/mysql? > > > > I have given #setfacl -R -m u:sms:rwx /var/lib/mysql on hostaa > > #setfacl -R -m g:sms:rwx /var/lib/mysql on hostaa > > The second command is unnecessary; granting access to the user "sms" is > enough. But you also have to set the default ACL so that "sms" will > have permissions on new files created by "mysql". To do this, run the > same command plus the -d option: > > setfacl -R -dm u:sms:rwx /var/lib/mysql > > You should also add user "mysql" to the access and default ACLs in the > same way so that it will have access to files created by "sms". > Finally, adding "rwx" entries to the access ACLs of existing files will > turn on their S_IXGRP permission bit. To fix that bit, run: > > chmod -R g-x,g+X /var/lib/mysql > > At this point, the "failed to open" errors should go away. Rsync may > still fail to set the times of /var/lib/mysql because it is owned by > user "mysql" and only the owner of a file is allowed to set its times > arbitrarily. To get rid of that error, you can pass --omit-dir-times . > > Matt > >
Hi Matt I followed your suggestion, but no luck I did setfacl -R -dm u:sms:rwx /var/lib/mysql on hostaa setfacl -R -dm u:mysql:rwx /var/lib/mysql on hostaa chmod -R g-x,g+X /var/lib/mysql on hostaa I am still getting the below error building file list ... done mysql/ rsync: failed to set permissions on "/var/lib/mysql": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/.keep_dev-db_mysql-0": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/host0084-bin.000001": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/host0084-bin.000002": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/host0084-bin.000003": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/host0084-bin.index": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/host0084-relay-bin.000001": Operation not permitted (1) rsync: failed to set permissions on "/var/lib/mysql/host0084-relay-bin.index": Operation not permitted (1) mysql/ib_logfile0 mysql/ib_logfile1 mysql/ibdata1 mysql/master.info rsync: failed to set permissions on "/var/lib/mysql/relay-log.info": Operation not permitted (1) Please let me know if i am missing something Thanks and Regards Kaushal
-- To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html