Web lists-archives.org

Re: [Samba] [Fwd: File Locking and Permissions Issue]

For some reason the excel file was stripped in my last post. (See below). We would appreciate any help we can get on this. Intuit tried this on their test server and we don't know whats causing the files to open without oplocks when a second user tries to access the database. 

Thanks,

Jack

Jack Lauman wrote:



-------- Original Message --------
Subject: File Locking and Permissions Issue
Date: Wed, 14 May 2008 15:10:28 -0700
From: Jack Lauman <jlauman@xxxxxxxxxxxxxx>
Organization: nwcascades.com
To: mailto:samba@xxxxxxxxxxxxxxx

I'm trying to get Lacerte 2007 Tax Accounting software working on a
Samba v3.0.28a based server.  When one user is logged in it works fine.
  When two or more users are accessing the database files it slows to a
crawl.

Lacerte's tech support personnel set up an identical scenereo in their
lab.  Here's what the found:

<quote>
I compared the open files with one computer in Lacerte vs. two
computers in Lacerte and noticed one thing peculiar: when one computer
is using Lacerte, all files are opened with exclusive+batch oplocks
including Data1i07.dbf, however when 2 computers are running Lacerte, a
few files open without oplocks, notably data1i07.dbf.  I have also
attached a copy of my smbstatus output (put into an Excel spreadsheet,
computer 1 highlighted in yellow, computer 2 in blue.)  This seems to be
the same way it was working on your server.

One more thing to note - I was logged in as the same user on both
workstations - if you can try that configuration and it works, that
might clue us in to some kind of permissions issue.
</quote>

I've attached both files to this message.  Any help in resolving this
matter would be greatly appreciated.

Thanks,

Jack Lauman


Locked files:								
Pid	Uid	DenyMode	Access	R/W	Oplock	SharePath 	Name	Time
15314 500 DENY_WRITE 0x20089 RDONLY EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/Setup07/Setup.XML Tue May 13 23:10:24 2008 15001 500 DENY_NONE 0x100001 RDONLY NONE /home/arends/intuit . Tue May 13 23:07:44 2008 15314 500 DENY_NONE 0x2019f RDWR EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/DATA1I07.DBF Tue May 13 23:10:25 2008 15314 500 DENY_NONE 0x2019f RDWR EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/urn/User002.LW7 Tue May 13 23:10:24 2008 15314 500 DENY_WRITE 0x20089 RDONLY EXCLUSIVE+BATCH /home/arends/intuit Lacerte/06tax/OPTION06/OPINDEX.W6 Tue May 13 23:10:24 2008 15314 500 DENY_NONE 0x20089 RDONLY EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/DDRIDI07.DAT Tue May 13 23:10:24 2008 15314 500 DENY_NONE 0x2019f RDWR EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/DATA1I07.MDX Tue May 13 23:10:17 2008 15314 500 DENY_NONE 0x20089 RDONLY EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/urn/User001.LW7 Tue May 13 23:10:24 2008 

Locked files:								
Pid	Uid	DenyMode	Access	R/W	Oplock	SharePath	Name	Time
15001 500 DENY_NONE 0x100001 RDONLY NONE /home/arends/intuit . Tue May 13 23:07:44 2008 15314 500 DENY_NONE 0x2019f RDWR NONE /home/arends/intuit Lacerte/07tax/IDATA/DATA1I07.DBF Tue May 13 23:10:25 2008 15001 500 DENY_NONE 0x2019f RDWR NONE /home/arends/intuit Lacerte/07tax/IDATA/DATA1I07.DBF Tue May 13 23:11:20 2008 15314 500 DENY_NONE 0x2019f RDWR NONE /home/arends/intuit Lacerte/07tax/IDATA/urn/User002.LW7 Tue May 13 23:10:24 2008 15001 500 DENY_NONE 0x20089 RDONLY EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/DDRIDI07.DAT Tue May 13 23:11:16 2008 15001 500 DENY_NONE 0x2019f RDWR EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/urn/User003.LW7 Tue May 13 23:11:16 2008 15001 500 DENY_NONE 0x20089 RDONLY EXCLUSIVE+BATCH /home/arends/intuit Lacerte/07tax/IDATA/urn/User001.LW7 Tue May 13 23:11:16 2008 
[global]
	server string = Linux Samba Server V %v
   workgroup = WORKGROUP
	interfaces = eth0 127.0.0.1
	bind interfaces only = yes
   security = user
	log file = /var/log/samba/log.%m
	time server = yes
	socket options = TCP_NODELAY IPTOS_LOWDELAY
	os level = 65
	preferred master = yes
	domain master = yes
	local master = yes
	guest account = smbuser
	printcap name = cups
	printing = cups 
	wins support = yes
	use client driver = yes
	encrypt passwords = yes
	smb passwd file = /etc/samba/smbpasswd
   idmap uid = 16777216-33554431
   idmap gid = 16777216-33554431
   template shell = /bin/false
   winbind use default domain = no
[homes]
	browsable = no
	writable = yes
[intuit]
	comment = Lacerte Server
	path = /home/arends/intuit
	read only = no
	guest ok = yes

[public]
	comment = Public file access
	path = /home/public
	read only = no
	create mask = 2775
	directory mask = 0775
	guest ok = yes
[web]
	comment = WWW
	path = /var/www/html
	valid users = arends
	read only = no 
[printers]
	printer = raw
	comment = All Printers
	path = /var/spool/samba
	guest ok = yes
	public = yes	
	writable = yes
	printable = yes
	browseable = yes
[print$]
	comment = Printer Drivers
	path = /etc/samba/printer
	guest ok = no
	broweseable = yes
	read only = yes
	write list = arends,gijane,root

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