[Samba] Excel and Samba Problem

Oliver Werner oliver.werner at kontrast.de
Thu Feb 19 06:59:42 MST 2015


In Logs saw an interessting thing:

This will logging when i got the Error:

Feb 19 14:46:07 vl0239 smbd[1429]: userb|pwrite|ok|test/222/._~$Arbeitsmappe1.xlsx
Feb 19 14:46:07 vl0239 smbd[1429]: userb|pwrite|ok|test/222/~$Arbeitsmappe1.xlsx
Feb 19 14:46:18 vl0239 smbd[1429]: userb|unlink|ok|test/222/~$Arbeitsmappe1.xlsx
Feb 19 14:46:18 vl0239 smbd[1429]: userb|unlink|ok|test/222/._~$Arbeitsmappe1.xlsx

And this when all will be ok with saving file:
Feb 19 14:49:06 vl0239 smbd[1429]: userb|pwrite|ok|test/222/._~$Arbeitsmappe1.xlsx
Feb 19 14:49:06 vl0239 smbd[1429]: userb|pwrite|ok|test/222/~$Arbeitsmappe1.xlsx
Feb 19 14:49:16 vl0239 smbd[1429]: userb|pwrite|ok|test/222/._02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|pwrite|ok|test/222/02BF3300
Feb 19 14:49:17 vl0239 smbd[1429]: userb|unlink|ok|test/222/Arbeitsmappe1.xlsx
Feb 19 14:49:17 vl0239 smbd[1429]: userb|unlink|ok|test/222/._Arbeitsmappe1.xlsx
Feb 19 14:49:17 vl0239 smbd[1429]: userb|rename|ok|test/222/02BF3300|test/222/Arbeitsmappe1.xlsx
Feb 19 14:49:17 vl0239 smbd[1429]: userb|rename|ok|test/222/._02BF3300|test/222/._Arbeitsmappe1.xlsx
Feb 19 14:49:20 vl0239 smbd[1429]: userb|unlink|ok|test/222/~$Arbeitsmappe1.xlsx
Feb 19 14:49:20 vl0239 smbd[1429]: userb|unlink|ok|test/222/._~$Arbeitsmappe1.xlsx

> Am 19.02.2015 um 14:27 schrieb Oliver Werner <oliver.werner at kontrast.de>:
> 
> 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



More information about the samba mailing list