LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-22-2013, 04:03 AM   #1
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,552

Rep: Reputation: 103Reputation: 103
Cannot open any file with MS-Office on my Centos 6 samba share


Hi Guys

I've got a samba share on my Centos 6 machine that is mounted on an NFS export from an Ubuntu machine.

Since creating the setup my users worked for a week with no problems on this share.

Today, nobody can open any file with MS-Excel or MS-Word.

Using Notepad on the client machines (for example) I can open all files, including the Word and Excel files (I see the binary content of the file in Notepad). I can also save changes.

However, if I try to open the MS-Excel or MS-Word files, the file is always locked by "another user" according to Excel or Word. If the file does not come up as "locked by another user", sometimes, after a few minutes, the user cannot save the file in Excel or Word.

Here's the /etc/exports on the Ubuntu machine:

Code:
/shares/Users                   192.168.1.2(rw,sync,no_root_squash)
Here's how I mount the above NFS share on my Centos machine:

Code:
mount 192.168.1.2:/shares/Users /mnt/users -o user,exec,dev,suid,rw,nolock
Here's my smb.conf:

Code:
[global]	
workgroup = mydomain
server string = Samba Server Version %v
netbios name = DOMPDC
interfaces = lo eth0
hosts allow = 127. 172.
admin users = root
log file = /var/log/samba/log.%m
max log size = 50
security = user
passdb backend = tdbsam
domain master = yes 
domain logons = yes
encrypt passwords = yes
os level = 65
log level = 3
socket options = TCP_NODELAY IPTOS_LOWDELAY SO_RCVBUF=16384 SO_SNDBUF=16384
preferred master = auto
local master = yes
wins support = yes
name resolve order = bcast host lmhosts wins
dns proxy = yes
lm announce = no
logon script = %U.bat
logon path = 
logon drive =
#logon drive = O:
load printers = no
time server = yes
ntlm auth = yes
client ntlmv2 auth = yes
client lanman auth = yes
client use spnego = yes
lanman auth = yes
remote announce = 172.16.0.0
deadtime=2
keepalive=10
winbind separator = +
winbind enum users = yes
winbind enum groups = yes
winbind use default domain = yes
#client use spnego = yes
kernel oplocks = no
	
[Users]
path = /mnt/users
guest ok = no
writable = yes
create mask = 0777
directory mask = 0777
browseable = yes
public = yes
valid users = sn cg eo nd
Veto files = /*.inf/*.lnk/*.mp3/*.avi/*.mp4/*.divx/*.acc/*.ogg/*.pif/*.cmd/*.exe/
The Samba instance is also serving as PDC, all the users having the MS-Excel and MS-Word "opening problem" are members of the domain, and are logged in. They're using Office 2010 and Windows 7.

What I can do to enable them to be able to just even open an MS-Excel or MS-Word file on the shares, without being told it is locked by somebody else?

I've already tested for contention, if I alone (no other users) go on the share after rebooting the Samba server and the NFS source server / ubuntu server I =STILL= cannot open any Office file using Excel or Word, same error.

I've already tried setting oplocks off on the share, turning on / off NT acls with in smb.conf, added the nolock option when mounting the NFS share, etc. etc. etc.

How in tarnation can I get this to work?

Any help appreciated!!
 
Old 01-23-2013, 12:21 AM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,552

Original Poster
Rep: Reputation: 103Reputation: 103
Still waiting for confirmation from my users, but it seems my problem of Office applications on Windows client machines not being able to open .xlsx / .xls and .docx and .doc files over the network has been solved!

I had to add these options to the [global] of my smb.conf:

Code:
kernel oplocks = no
nt acl support = no
strict locking = no
And to each share definition where I want users capable of opening and saving Office files I added the following - unsure if some of the above overlap with these below:

Code:
[sharename]
.
.
.
oplocks = no
acl check permissions = false
level2 oplocks = no
locking = no
strict locking = no
share modes = no
With Centos 6 Samba 3.5.4-68.el6 "share modes" is complained about as "deprecated" but appears to be still valid.

Once I added the above settings to [global] as indicated and to each share definition in smb.conf as indicated, so far, users on those shares are able to use Excel and Word to open and save files on the Samba file server share without problems. Still waiting for complete confirmation today when everybody comes in to work, but this seems to have solved the issue with interoperation of Samba shares in my environment and MS-Office 2010 applications...
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MS office files open in read only mode from samba share Toushi Linux - Networking 6 05-19-2011 11:39 AM
Folder permissions for samba share in small medical office? Abner Gershon Linux - Server 2 12-14-2010 10:31 AM
Microsoft Office Accounting 2008 and Samba on Centos/SME 7.3 RupertTHEbare Linux - Enterprise 3 06-05-2008 10:27 AM
CentOS - Samba Share Mithrilhall Linux - Newbie 1 05-18-2006 07:02 AM
Problem accessing open office documents over samba share jonic Linux - Software 0 11-18-2005 10:46 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:22 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration