I am having a ton of trouble with data corruption of my quickbooks pro
2001 data. I am having to rebuild the database about twice a week. I
have the database sitting on a server with RH7 and Samba 2.0.7. Clients
are on Win2000 and only 3 people access the file during the day, most of
the time they access it all at the same time. I put the file on one of
the Win machines for a week and never had a problem. My last attempt at
running the database on the Linux box lasted 6 hours before I had fatal
error in Quickbooks.
Here's my global:
# from localhost (127.0.0.1)
# Date: 2001/02/13 15:24:27
# Global parameters
[global]
workgroup = NLS
netbios name = ZEUS
server string = Samba Server
log file = /var/log/samba/log.%m
max log size = 0
socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
os level = 65
preferred master = Yes
domain master = Yes
dns proxy = No
wins support = Yes
veto oplock files = /*.QBW/*.qbw/*.QBI/*.qbi/
[homes]
comment = Home Directories
writeable = Yes
browseable = No
[printers]
comment = All Printers
path = /var/spool/samba
printable = Yes
browseable = No
[nls]
path = /home/nls
writeable = Yes
create mask = 0777
level2 oplocks = Yes
Here's a little more from the smb.conf:
blocking locks = Yes
fake oplocks = No
locking = Yes
oplocks = Yes
level2 oplocks = No
oplock contention limit = 2
strict locking = No
share modes = Yes
delete veto files=No
Can someone help me? I've run out of ideas and may have to switch to a NT
server if I can't get this figured out. My CEO is starting to breath down my
neck a bit.
Let me know what other information I need to provide.
Thanks in advance.
Tom
This is slightly different, but after I upgraded to the latest alpha snapshot of samba, I can no longer back up quicken deluxe 2000 onto a samba share. ----- Original Message ----- From: "Tom Nielsen" <tom@neuro-logic.com> To: <samba@lists.samba.org> Sent: Tuesday, February 13, 2001 6:01 PM Subject: Quickbooks Data Corruption with Samba...Help> I am having a ton of trouble with data corruption of my quickbooks pro > 2001 data. I am having to rebuild the database about twice a week. I > have the database sitting on a server with RH7 and Samba 2.0.7. Clients > are on Win2000 and only 3 people access the file during the day, most of > the time they access it all at the same time. I put the file on one of > the Win machines for a week and never had a problem. My last attempt at > running the database on the Linux box lasted 6 hours before I had fatal > error in Quickbooks. > > Here's my global: > > # from localhost (127.0.0.1) > # Date: 2001/02/13 15:24:27 > > # Global parameters > [global] > workgroup = NLS > netbios name = ZEUS > server string = Samba Server > log file = /var/log/samba/log.%m > max log size = 0 > socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192 > os level = 65 > preferred master = Yes > domain master = Yes > dns proxy = No > wins support = Yes > veto oplock files = /*.QBW/*.qbw/*.QBI/*.qbi/ > > [homes] > comment = Home Directories > writeable = Yes > browseable = No > > [printers] > comment = All Printers > path = /var/spool/samba > printable = Yes > browseable = No > > [nls] > path = /home/nls > writeable = Yes > create mask = 0777 > level2 oplocks = Yes > > Here's a little more from the smb.conf: > > blocking locks = Yes > fake oplocks = No > locking = Yes > oplocks = Yes > level2 oplocks = No > oplock contention limit = 2 > strict locking = No > share modes = Yes > delete veto files=No > > Can someone help me? I've run out of ideas and may have to switch to a NTserver if I can't get this figured out. My CEO is starting to breath down my neck a bit.> > Let me know what other information I need to provide. > > Thanks in advance. > Tom > > >
Are you positive Samba is corrupting your Quickbooks pro database? I've had to rebuild my database and it's running from the hard drive. On Tue, 13 Feb 2001, Tom Nielsen wrote:> I am having a ton of trouble with data corruption of my quickbooks pro > 2001 data. I am having to rebuild the database about twice a week. I > have the database sitting on a server with RH7 and Samba 2.0.7. Clients > are on Win2000 and only 3 people access the file during the day, most of > the time they access it all at the same time. I put the file on one of > the Win machines for a week and never had a problem. My last attempt at > running the database on the Linux box lasted 6 hours before I had fatal > error in Quickbooks. > > Here's my global: > > # from localhost (127.0.0.1) > # Date: 2001/02/13 15:24:27 > > # Global parameters > [global] > workgroup = NLS > netbios name = ZEUS > server string = Samba Server > log file = /var/log/samba/log.%m > max log size = 0 > socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192 > os level = 65 > preferred master = Yes > domain master = Yes > dns proxy = No > wins support = Yes > veto oplock files = /*.QBW/*.qbw/*.QBI/*.qbi/ > > [homes] > comment = Home Directories > writeable = Yes > browseable = No > > [printers] > comment = All Printers > path = /var/spool/samba > printable = Yes > browseable = No > > [nls] > path = /home/nls > writeable = Yes > create mask = 0777 > level2 oplocks = Yes > > Here's a little more from the smb.conf: > > blocking locks = Yes > fake oplocks = No > locking = Yes > oplocks = Yes > level2 oplocks = No > oplock contention limit = 2 > strict locking = No > share modes = Yes > delete veto files=No > > Can someone help me? I've run out of ideas and may have to switch to a NT server if I can't get this figured out. My CEO is starting to breath down my neck a bit. > > Let me know what other information I need to provide. > > Thanks in advance. > Tom > > >
Have you tried setting strict locking = yes. Maybe Quickbooks is not well
behaved. It is multi-user app, right?
-----Original Message-----
From: samba-admin@lists.samba.org [mailto:samba-admin@lists.samba.org]On
Behalf Of Tom Nielsen
Sent: Tuesday, February 13, 2001 7:02 PM
To: samba@lists.samba.org
Subject: Quickbooks Data Corruption with Samba...Help
I am having a ton of trouble with data corruption of my quickbooks pro
2001 data. I am having to rebuild the database about twice a week. I
have the database sitting on a server with RH7 and Samba 2.0.7. Clients
are on Win2000 and only 3 people access the file during the day, most of
the time they access it all at the same time. I put the file on one of
the Win machines for a week and never had a problem. My last attempt at
running the database on the Linux box lasted 6 hours before I had fatal
error in Quickbooks.
Here's my global:
# from localhost (127.0.0.1)
# Date: 2001/02/13 15:24:27
# Global parameters
[global]
workgroup = NLS
netbios name = ZEUS
server string = Samba Server
log file = /var/log/samba/log.%m
max log size = 0
socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
os level = 65
preferred master = Yes
domain master = Yes
dns proxy = No
wins support = Yes
veto oplock files = /*.QBW/*.qbw/*.QBI/*.qbi/
[homes]
comment = Home Directories
writeable = Yes
browseable = No
[printers]
comment = All Printers
path = /var/spool/samba
printable = Yes
browseable = No
[nls]
path = /home/nls
writeable = Yes
create mask = 0777
level2 oplocks = Yes
Here's a little more from the smb.conf:
blocking locks = Yes
fake oplocks = No
locking = Yes
oplocks = Yes
level2 oplocks = No
oplock contention limit = 2
strict locking = No
share modes = Yes
delete veto files=No
Can someone help me? I've run out of ideas and may have to switch to a NT
server if I can't get this figured out. My CEO is starting to breath down my
neck a bit.
Let me know what other information I need to provide.
Thanks in advance.
Tom