[Samba] Excel and Samba Problem

Fri Feb 20 04:05:14 MST 2015

Hi Daniel,

the Problem with the lock file ~filename.xlsx looks like solved.
But my Problem with the 8digit filename can not be accessable already exists…

I have seen when the error with „not accessable" diaplayed i can say ok. When try to save again this work.

the failed 8digit-filename already exists on fileserver

> Am 20.02.2015 um 11:14 schrieb Daniel Müller <mueller at tropenklinik.de>:
> 
> Did you try fort he share:
> 
> oplocks = no
> level2 oplocks = no
> 
> 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: Oliver Werner [mailto:oliver.werner at kontrast.de] 
> Gesendet: Freitag, 20. Februar 2015 10:12
> An: Daniel Müller
> Cc: samba at lists.samba.org
> Betreff: Re: [Samba] Excel and Samba Problem
> 
> i was trying this configuration yesterdayand does not help.
> 
> But i was find out more things.
> 
> When I’m connect with CIFS the Problem can not reproduced.
> 
> A saw with SMB and with CIFS the Logfile ~filename.xlsx not unlinked
> everytime when Excel will be closed.
> 
> 
> 
> 
>> Am 20.02.2015 um 09:54 schrieb Daniel Müller <mueller at tropenklinik.de>:
>> 
>> 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
>> 
>> --
>> To unsubscribe from this list go to the following URL and read the
>> instructions:  https://lists.samba.org/mailman/options/samba
> 
> 