rsync errors

[Kaushal Shriyan]

On Thu, Mar 27, 2008 at 7:56 PM, Kaushal Shriyan
<kaushalshriyan at gmail.com> wrote:
>
> On Wed, Mar 26, 2008 at 6:21 PM, Matt McCutchen <matt at mattmccutchen.net> 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
>

Hi Matt,

Any clue on the issue

Thanks

Kaushal