[Samba] Excel and Samba Problem

Oliver Werner oliver.werner at kontrast.de
Fri Feb 20 02:11:54 MST 2015 

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

More information about the samba mailing list