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 <[EMAIL PROTECTED]>
Organization: nwcascades.com
To: mailto:[email protected]
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
