Users in ACL can't save changes from Excel 2000

Chris Tooley ctooley at amoa.org
Thu Oct 25 08:55:28 GMT 2001 

I've got a problem with users who are listed in the ACL of a file not
being able to save the file.  As the logs show when the file is opened
they get read=Yes but write=No.  I need them to be able to write to
these files.  Any help would be greatly appreciated.  I apologize for
the length of the e-mail but some of the things looked important (like
it looks like it just keeps opening copies of the file).

This is from a machine log of access to a budget file for user
sstrapple.  The user is in the ADMINISTRATION group.  Below is my
smb.conf and a getfacl of the file he's trying to open.

[2001/10/25 10:40:10, 2] smbd/dosmode.c:unix_mode(61)
unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:10, 2] smbd/dosmode.c:unix_mode(69)
unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:10, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=2)
[2001/10/25 10:40:10, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=1) 
[2001/10/25 10:40:10, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:10, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:10, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=2)
[2001/10/25 10:40:11, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:11, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:11, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=1) 
[2001/10/25 10:40:11, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=2)
[2001/10/25 10:40:11, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:11, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:11, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=1) 
[2001/10/25 10:40:11, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=2)
[2001/10/25 10:40:13, 2] smbd/connection.c:utmp_claim(841)
  utmp_claim: lp_utmp() NULL
[2001/10/25 10:40:13, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:13, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:13, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=1) 
[2001/10/25 10:40:13, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=2)
[2001/10/25 10:40:14, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:14, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:14, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=1) 
[2001/10/25 10:40:14, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=Yes (numopen=2)
[2001/10/25 10:40:16, 2] smbd/connection.c:utmp_yield(785)
  utmp_yield: lp_utmp() NULL
[2001/10/25 10:40:20, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:20, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:20, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=3)
[2001/10/25 10:40:20, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:20, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:20, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=4)
[2001/10/25 10:40:20, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:20, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:20, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=3) 
[2001/10/25 10:40:21, 2] smbd/close.c:close_normal_file(205)
  sstrapple closed file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls (numopen=2) 
[2001/10/25 10:40:21, 2] smbd/open.c:check_share_mode(426)
  Share violation on file (1,4,2,31350,ACCOUNTING/PUBLIC/Budget,
FY2002/2002 Departmental Budgets/2002 Budget Sheet
(Operations).xls,fcbopen = 0, flags = 0) = 0
[2001/10/25 10:40:21, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=3)
[2001/10/25 10:40:22, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inheriting from
ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental Budgets
[2001/10/25 10:40:22, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/2002 Budget Sheet (Operations).xls) inherit mode 40775
[2001/10/25 10:40:22, 2] smbd/open.c:check_share_mode(426)
  Share violation on file (2,4,2,31350,ACCOUNTING/PUBLIC/Budget,
FY2002/2002 Departmental Budgets/2002 Budget Sheet
(Operations).xls,fcbopen = 0, flags = 0) = 0
[2001/10/25 10:40:22, 2] smbd/open.c:open_file(216)
  SSTRAPPLE opened file ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets/2002 Budget Sheet (Operations).xls read=Yes
write=No (numopen=3)
[2001/10/25 10:40:25, 2] smbd/connection.c:utmp_claim(841)
  utmp_claim: lp_utmp() NULL
[2001/10/25 10:40:27, 2] smbd/connection.c:utmp_yield(785)
  utmp_yield: lp_utmp() NULL
[2001/10/25 10:40:28, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/43D9E900) inheriting from ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets
[2001/10/25 10:40:28, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/43D9E900) inherit mode 40775
[2001/10/25 10:40:28, 2] smbd/dosmode.c:unix_mode(61)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/43D9E900) inheriting from ACCOUNTING/PUBLIC/Budget, FY2002/2002
Departmental Budgets
[2001/10/25 10:40:28, 2] smbd/dosmode.c:unix_mode(69)
  unix_mode(ACCOUNTING/PUBLIC/Budget, FY2002/2002 Departmental
Budgets/43D9E900) inherit mode 40775

# Samba config file created using SWAT
# from 192.168.1.50 (192.168.1.50)
# Date: 2001/04/03 21:32:21

# Global parameters
[global]
        workgroup = SAMBANET
        netbios name = FILECABINET
        server string = Austin Museum of Art PDC
        interfaces = 192.168.1.17
        encrypt passwords = Yes
        unix password sync = Yes
        passwd program = /usr/bin/passwd
        debug level = 2
        syslog = 4
        log file = /var/log/samba/log.%m
        max log size = 1000
        announce version = 4.0
        time server = True
        time offset = 300
        logon script = %U.bat
        logon path = \\%N\profiles\%U
        logon drive = X:
        domain logons = Yes
        guest account = nobody
        os level = 65
        preferred master = Yes
        domain master = Yes
        wins proxy = Yes
        wins support = Yes
        mangle case = Yes
        create mask = 0770
        directory mask = 0775
        inherit permissions = yes
        print command = lpr -P%p -r %s
        lppause command = lpc hold %p %j
        lpresume command = lpc release %p %j
        queuepause command = lpc  -P%p stop
        queueresume command = lpc  -P%p start

[netlogon]
        comment = Netlogon
        path = /home/samba/netlogon
        writeable = Yes

[trackit]
        comment = TrackIT
        path = /home/trackit
        writeable = Yes

[Drivers]
        comment = Printer Drivers
        path = /mnt/amoadata/drivers
        writeable = Yes
        public = yes

[Pictures]
        comment = AMOA Digital Images
        path = /mnt/amoadata/photodrive
        writeable = Yes
        recycle bin = /mnt/amoadata/tmp/.photodrivetrash

[ArtGuild]
        comment = ArtGuild
        path = /home/ArtGuild
        writeable = Yes
        recycle bin = /mnt/amoadata/tmp/.artguildtrash

[homes]
        comment = Home Directories
        writeable = Yes
        browseable = No
        recycle bin = /mnt/amoadata/tmp/.recyclebin/%m

[print$]
        comment = All Printers
        path = /home/samba/printers
        printable = Yes
        browseable = Yes
        read only = No
        guest ok = Yes
        write list = Administrator, root, ctooley

[profiles]
        comment = User Profiles
        path = /home/samba/profiles
        writable = Yes

[printers]
        comment = All Printers
        path = /var/spool/samba
        printable = Yes
        guest ok = Yes
        browseable = Yes
        create mode = 0700
        writable = no

[Kelli]
        comment = AMOA DATA
        path = /home/kjohnson
        writeable = Yes
        read only = No
        browseable = No
        recycle bin = /mnt/amoadata/tmp/.maintrash

[SYS]
        comment = AMOA DATA
        path = /mnt/amoadata/shareddata
        writeable = Yes
        read only = No
        recycle bin = /mnt/amoadata/tmp/.maintrash

[IntraWeb]
        comment = Internal Website Information
        path = /home/httpd
        writeable = Yes
        read only = No
        recycle bin = /mnt/amoadata/tmp/.website


A getfacl of the file

# file: 2002 Budget Sheet (Operations).xls
# owner: nsheppard
# group: EVERYONE
user::rwx
group::rwx
group:ADMINISTRATION:rwx
group:ADMINISTRATOR:rwx
mask:rwx
other:r-x

More information about the samba mailing list