[Samba] Excel and Samba Problem

Daniel Müller mueller at tropenklinik.de
Fri Feb 20 01:54:39 MST 2015 

If everything fails try this. Is working form e even on a windows 8.1X64
client  full patched in a samba 3.6 domain and  Samba 4.
Ans I run it on a ext3 glusterd  replicating share without any issue
First set the sticky bit for your group on that share

[share]
path= /yourpath
 posix locking =NO <--I need that for my gluster not shure you will
readonly=no
valid users =  @yourusersgroup
directory mask=2770
        force directory mode=2770
        create mask = 2770
        force create mode=2770
        force security mode=2770
        force directory security mode=2770
force group = yourusersgroup  <---try if you need that too


EDV Daniel Müller

Leitung EDV
Tropenklinik Paul-Lechler-Krankenhaus
Paul-Lechler-Str. 24
72076 Tübingen 
Tel.: 07071/206-463, Fax: 07071/206-499
eMail: mueller at tropenklinik.de
Internet: www.tropenklinik.de 



-----Ursprüngliche Nachricht-----
Von: samba-bounces at lists.samba.org [mailto:samba-bounces at lists.samba.org] Im
Auftrag von Oliver Werner
Gesendet: Donnerstag, 19. Februar 2015 16:50
An: L.P.H. van Belle
Cc: samba at lists.samba.org
Betreff: Re: [Samba] Excel and Samba Problem

Hm thats stange


i have test some lock options, masks, etc. but i got everytime the Error

Microsoft Excel can not be accessable file „Volumes:test:path:DB0B7110“ 
.



> Am 19.02.2015 um 16:33 schrieb L.P.H. van Belle <belle at bazuin.nl>:
> 
> Hai, sorry about the delay.. i had to do some work here.. 
> 
> in my global settings in smb.conf
> 
> ## Acl-EA settings
>        ea support = yes
>        store dos attributes = yes
>        map archive = no
>        map hidden = no
>        map system = no
>        map readonly = no
>        inherit permissions = yes
>        inherit acls = yes
>        map acl inherit = yes
>        acl group control = yes
>        veto oplock files = 
> /*.doc/*.xls/*.mdb/*.ldb/*.DOC/*.XLS/*.MDB/*.LDB/*.PDF/*.TIF/*.xlsx/*.
> XLSX
> 
> 
> and i have these in my share. 
>        create mode = 660
>        force create mode = 660
>        directory mode = 2770
>        force directory mode = 2770
> 
> 
> if that does not work, try 
>        create mode = 666
>        force create mode = 666
> 
> Louis
> 
> 
>> -----Oorspronkelijk bericht-----
>> Van: Daniel Müller [mailto:mueller at tropenklinik.de]
>> Verzonden: donderdag 19 februari 2015 15:56
>> Aan: 'Oliver Werner'; 'L.P.H. van Belle'
>> CC: samba at lists.samba.org
>> Onderwerp: AW: [Samba] Excel and Samba Problem
>> 
>> Directorymask=27770
>> Create mask=2770
>> 
>> If this will not work
>> 
>> Test force params
>> 
>> EDV Daniel Müller
>> 
>> Leitung EDV
>> Tropenklinik Paul-Lechler-Krankenhaus Paul-Lechler-Str. 24
>> 72076 Tübingen
>> Tel.: 07071/206-463, Fax: 07071/206-499
>> eMail: mueller at tropenklinik.de
>> Internet: www.tropenklinik.de
>> 
>> 
>> 
>> -----Ursprüngliche Nachricht-----
>> Von: samba-bounces at lists.samba.org
>> [mailto:samba-bounces at lists.samba.org] Im Auftrag von Oliver Werner
>> Gesendet: Donnerstag, 19. Februar 2015 14:27
>> An: L.P.H. van Belle
>> Cc: samba at lists.samba.org
>> Betreff: Re: [Samba] Excel and Samba Problem
>> 
>> Yep 2770 is also configured for sharing path.
>> 
>> What mask do you use for files?
>> OLIVER WERNER
>> System-Administrator
>> 
>> 
>> 
>> 
>> Kontrast Communication Services GmbH
>> Grafenberger Allee 100, 40237 Düsseldorf, Germany
>> 
>> Fon  +49-211-91505-500
>> Fax +49-211-91505-530
>> www.kontrast.de <http://www.kontrast.de/>
>> 
>> Amtsgericht Düsseldorf: HRB 26934
>> Geschäftsführer: Joachim Fischer
>> 
>> <https://www.facebook.com/kontrast.communication>
>> <https://twitter.com/KONTRAST_de>
>> <http://www.xing.com/companies/kontrastcommunicationservicesgmbh>
>> <http://www.linkedin.com/company/kontrast-communication-services-gmbh>
>> <https://vimeo.com/kontrastcs>     
>> <http://instagram.com/kontrast_de>    
>> 
>> 
>> 
>> 
>>> Am 19.02.2015 um 13:54 schrieb L.P.H. van Belle <belle at bazuin.nl>:
>>> 
>>> ok.. 
>>> 
>>> and you did also a .. 
>>> chmod -R 2770 /path/to/dir
>>> 
>>> The folder you are share-ing also needs 2770
>>> 
>>> 
>>> 
>>>> -----Oorspronkelijk bericht-----
>>>> Van: Oliver Werner [mailto:oliver.werner at kontrast.de]
>>>> Verzonden: donderdag 19 februari 2015 13:45
>>>> Aan: L.P.H. van Belle
>>>> CC: samba at lists.samba.org
>>>> Onderwerp: Re: [Samba] Excel and Samba Problem
>>>> 
>>>> I have try it but does not help. I get the same error?
>>>> 
>>>> 
>>>> 
>>>>> Am 19.02.2015 um 13:22 schrieb L.P.H. van Belle <belle at bazuin.nl>:
>>>>> 
>>>>> i have the following for a share on my samba 3.6.6
>>>>> 
>>>>>      directory mode = 2770
>>>>>      force directory mode = 2770
>>>>>      blocking locks = no
>>>>> 
>>>>> can you try these.
>>>>> 
>>>>> Greetz,
>>>>> 
>>>>> Louis
>>>>> 
>>>>>> -----Oorspronkelijk bericht-----
>>>>>> Van: oliver.werner at kontrast.de
>>>>>> [mailto:samba-bounces at lists.samba.org] Namens Oliver Werner
>>>>>> Verzonden: donderdag 19 februari 2015 12:45
>>>>>> Aan: samba at lists.samba.org
>>>>>> Onderwerp: [Samba] Excel and Samba Problem
>>>>>> 
>>>>>> Hello,
>>>>>> 
>>>>>> We have a problem with our Samba server (we tested with two 
>>>>>> versions 3.6.6 and 4.1.11).
>>>>>> When a User edit an Excel file and saves, another user
>> can not save
>>>>>> this edited later.
>>>>>> The temporary file named like 885E9010 will be created and Excel 
>>>>>> reports that this file can not be accessed.
>>>>>> 
>>>>>> I have test it with Windows and Mac. Both have the same Problem.
>>>>>> 
>>>>>> This is our samba configuration:
>>>>>> 
>>>>>> [global]
>>>>>> security = domain
>>>>>> workgroup = company
>>>>>> netbios name = fileserver
>>>>>> winbind separator = /
>>>>>> winbind use default domain = yes
>>>>>> winbind cache time = 300
>>>>>> encrypt passwords = true
>>>>>> server string = FILESERVER
>>>>>> log level = 0
>>>>>> max log size = 1024000
>>>>>> unix extensions = No
>>>>>> logon path = \\fileserver3\profiles\%U logon home = 
>>>>>> \\fileserver3\Profiles\%U logon drive = H:
>>>>>> logon script = logon.bat
>>>>>> block size = 4096
>>>>>> max protocol = SMB2
>>>>>> 
>>>>>> [Data]
>>>>>> path = /data/
>>>>>> browseable = yes
>>>>>> writeable = yes
>>>>>> force group = Intern
>>>>>> valid users = @Intern
>>>>>> create mask = 0660
>>>>>> directory mask = 0770
>>>>>> vfs objects = full_audit recycle
>>>>>> full_audit:prefix = %u
>>>>>> full_audit:success = mkdir rename rmdir unlink pwrite 
>>>>>> full_audit:failure = none full_audit:facility = LOCAL5 
>>>>>> full_audit:priority = NOTICE recycle:versions = yes
>> recycle:exclude
>>>>>> = .*, ~*
>>>>>> 
>>>>>> 
>>>>>> And here are the rights for the Files on Samba Server:
>>>>>> 
>>>>>> 535041902  4 drwxrwx---  3 user.a Intern       4096 Feb 19 12:35 .
>>>>>> 535041673  0 -rw-rw----  1 userb      Intern          0 Feb 19 
>>>>>> 12:35 885E9010
>>>>>> 535041669 68 -rw-rw----  1 usera      Intern      69492 Feb 19 
>>>>>> 12:34 Testfile.xlsx
>>>>>> 535037291  4 -rw-rw----  1 userb      Intern        171 Feb 19 
>>>>>> 12:35 ~$Testfile.xlsx
>>>>>> 535037292  4 -rw-rw----  1 userb     Intern       4096 Feb 19 
>>>>>> 12:35 ._~$Testfile.xlsx
>>>>>> 
>>>>>> 
>>>>>> yours sincerely
>>>>>> Oliver
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> --
>>>>>> To unsubscribe from this list go to the following URL and read 
>>>>>> the
>>>>>> instructions:  https://lists.samba.org/mailman/options/samba
>>>>>> 
>>>>>> 
>>>>> 
>>>>> --
>>>>> To unsubscribe from this list go to the following URL and read the
>>>>> instructions:  https://lists.samba.org/mailman/options/samba
>>>> 
>>>> 
>>> 
>>> --
>>> To unsubscribe from this list go to the following URL and read the
>>> instructions:  https://lists.samba.org/mailman/options/samba
>> 
>> --
>> To unsubscribe from this list go to the following URL and read the
>> instructions:  https://lists.samba.org/mailman/options/samba
>> 
>> 
> 

--
To unsubscribe from this list go to the following URL and read the
instructions:  https://lists.samba.org/mailman/options/samba

More information about the samba mailing list