This is set up with Win2K boxes sharing a QB file on a SAMBA share. It may be quite different than with 95-98x-ME(Miserable Edition). There are two or more problems - one thing I identified is that it is possible for two computers to connect to the QB(QuickBooks) share using the same quick books logon - something that will cause data corruption. (Something that could have been easily addressed in the QB software too -- can't wait till GNUcash does invoices). The smb.conf that follows seems to have fixed this problem The other problem only starts after the file size reaches the magic 16777216 byte file size - after that size sharing a QB file on SAMBA seems to cause corruption on it's own. After a talking with several folks at Intuit - - (and being told twice that running off a Linux server was not problem) I found a brighter tech who told me that they don't support linux as a server and they have notes showing that they know about the file corruption problems that they can't show us. They don't think there is a work-around, but then I think they are probably wrong. I have added oplocks = no strict locking = yes To the share definition. And will know if it works in a while. If this gets to Andrew Trigell's attention, let him know that I will supply him with QB software to test this out if he needs it - all he has to do is ask. The files and directories belong to accounting.accounting the permissions are set to 770 NO guarantee if this works - It will take some weeks of just using it to see if I have it fixed - in the mean time I'm dong lots of verifydata and backing up several times/ day. Any feed back here will be more than welcome smb.conf follows: #=== Global Base parameters ======[global] netbios name = servername workgroup = workgroup server string = AMD800mHz 200mHz SFB 376MB RAM level2 oplocks=yes #++++ Global logging =====log level = 2 syslog = 0 max log size = 2000 #== Global security issues ====encrypt passwords = yes smb passwd file = /etc/samba/smbpasswd #unix password sync = Yes passwd program = /usr/bin/passwd %u passwd chat = *New*UNIX*password* %n\n *ReType*new*UNIX*password* %n\n *passwd:*all*authentication*tokens*updated*successfully* #unix password sync=yes hosts allow = 192.168.1. security = user #======== Global tunning parameters ======socket options = TCP_NODELAY IPTOS_LOWDELAY #dead time = 15 #===== Global printer params ===printcap name = /etc/printcap load printers = yes log file = /var/log/samba/%m.log #===== Global Browser Control Options ===domain master = yes password server = * local master = yes os level = 67 preferred master = yes #======== Global Wins parameters ======wins support = yes name resolve order = wins lmhosts bcast #============================ Share Definitions =============================[homes] writable = yes browsable = no [accounting] browseable=yes comment = /home/accounting Quick books share directory path = /home/accounting oplocks = no strict locking = yes writable = yes create mask = 770 directory mask=770 force group = accounting valid users = norma, karl, malaysia # the above users all belong to the accounting group -------------------------------------------------- Karl Schmidt EMail Karl@xtronics.com Transtronics, Inc. WEB http://xtronics.com 3209 West 9th Street Ph(785) 841-3089 Lawrence, KS 66049 FAX(785) 841-0434 Definition of Windows XP: SPAM, thinly disguised as an operating system -------------------------------------------------- -------------- next part -------------- HTML attachment scrubbed and removed
On Fri, May 10, 2002 at 07:39:02PM -0500, Karl Schmidt wrote:> This is set up with Win2K boxes sharing a QB file on a SAMBA share. It may > be quite different than with 95-98x-ME(Miserable Edition). > > There are two or more problems - one thing I identified is that it is > possible for two computers to connect to the QB(QuickBooks) share using the > same quick books logon - something that will cause data corruption. > (Something that could have been easily addressed in the QB software too -- > can't wait till GNUcash does invoices). > > The smb.conf that follows seems to have fixed this problem > > The other problem only starts after the file size reaches the magic > 16777216 byte file size - after that size sharing a QB file on SAMBA seems > to cause corruption on it's own. > > After a talking with several folks at Intuit - - (and being told twice that > running off a Linux server was not problem) I found a brighter tech who > told me that they don't support linux as a server and they have notes > showing that they know about the file corruption problems that they can't > show us. They don't think there is a work-around, but then I think they are > probably wrong. > > I have added > > oplocks = no > strict locking = yes > > To the share definition. And will know if it works in a while. > > If this gets to Andrew Trigell's attention, let him know that I will supply > him with QB software to test this out if he needs it - all he has to do is ask.Andrew is still in Germany. Can you provide me with the software and instructions to reproduce the problem so I can ensure it is fixed in the SAMBA_2_2 and HEAD code streams please ! Thanks, Jeremy.
On Fri, May 10, 2002 at 07:39:02PM -0500, Karl Schmidt wrote:> This is set up with Win2K boxes sharing a QB file on a SAMBA share. It may > be quite different than with 95-98x-ME(Miserable Edition). > > There are two or more problems - one thing I identified is that it is > possible for two computers to connect to the QB(QuickBooks) share using the > same quick books logon - something that will cause data corruption. > (Something that could have been easily addressed in the QB software too -- > can't wait till GNUcash does invoices). > > The smb.conf that follows seems to have fixed this problem > > The other problem only starts after the file size reaches the magic > 16777216 byte file size - after that size sharing a QB file on SAMBA seems > to cause corruption on it's own. > > After a talking with several folks at Intuit - - (and being told twice that > running off a Linux server was not problem) I found a brighter tech who > told me that they don't support linux as a server and they have notes > showing that they know about the file corruption problems that they can't > show us. They don't think there is a work-around, but then I think they are > probably wrong. > > I have added > > oplocks = no > strict locking = yes > > To the share definition. And will know if it works in a while.Also can you tell me what version of Samba you are using please ? There were several fixes that went into 2.2.4 that may help your problem. Thanks, Jeremy.
> From: Seth Hollen <seth@hollen.org> > To: Karl Schmidt <karl@xtronics.com> > Subject: Re: [Samba] Samba + Quickbooks > Date: 10 May 2002 22:58:14 -0400 > > just as a note, I have quickbooks on a samba share and have had no file > corruption, a few mysterious file permission problems but nothing > serious.the files are not that large however.I am considering proposing > a linux/samba replacement to an accounting firm and this is something to > be aware of, thanks! > > Seth > > > > On Fri, 2002-05-10 at 20:39, Karl Schmidt wrote: > > This is set up with Win2K boxes sharing a QB file on a SAMBA share. It may > > be quite different than with 95-98x-ME(Miserable Edition). > > > > There are two or more problems - one thing I identified is that it is > > possible for two computers to connect to the QB(QuickBooks) share using the > > same quick books logon - something that will cause data corruption. > > (Something that could have been easily addressed in the QB software too -- > > can't wait till GNUcash does invoices). > > > > The smb.conf that follows seems to have fixed this problem > > > > The other problem only starts after the file size reaches the magic > > 16777216 byte file size - after that size sharing a QB file on SAMBA seems > > to cause corruption on it's own. > > > > After a talking with several folks at Intuit - - (and being told twice that > > running off a Linux server was not problem) I found a brighter tech who > > told me that they don't support linux as a server and they have notes > > showing that they know about the file corruption problems that they can't > > show us. They don't think there is a work-around, but then I think they are > > probably wrong. > > > > I have added > > > > oplocks = no > > strict locking = yes > > > > To the share definition. And will know if it works in a while. > > > > If this gets to Andrew Trigell's attention, let him know that I will supply > > him with QB software to test this out if he needs it - all he has to do is ask. > > > > The files and directories belong to accounting.accounting the permissions > > are set to 770 > > > > > > NO guarantee if this works - It will take some weeks of just using it to > > see if I have it fixed - in the mean time I'm dong lots of verifydata and > > backing up several times/ day. > > > > Any feed back here will be more than welcome > > > > smb.conf follows: > > > > > > #=== Global Base parameters ======> > [global] > > netbios name = servername > > workgroup = workgroup > > server string = AMD800mHz 200mHz SFB 376MB RAM > > level2 oplocks=yes > > #++++ Global logging =====> > log level = 2 > > syslog = 0 > > max log size = 2000 > > > > #== Global security issues ====> > encrypt passwords = yes > > smb passwd file = /etc/samba/smbpasswd > > #unix password sync = Yes > > passwd program = /usr/bin/passwd %u > > passwd chat = *New*UNIX*password* %n\n *ReType*new*UNIX*password* %n\n > > *passwd:*all*authentication*tokens*updated*successfully* > > #unix password sync=yes > > hosts allow = 192.168.1. > > security = user > > > > #======== Global tunning parameters ======> > socket options = TCP_NODELAY IPTOS_LOWDELAY > > #dead time = 15 > > > > #===== Global printer params ===> > printcap name = /etc/printcap > > load printers = yes > > log file = /var/log/samba/%m.log > > > > #===== Global Browser Control Options ===> > domain master = yes > > password server = * > > local master = yes > > os level = 67 > > preferred master = yes > > > > #======== Global Wins parameters ======> > wins support = yes > > name resolve order = wins lmhosts bcast > > > > #============================ Share Definitions =============================> > [homes] > > writable = yes > > browsable = no > > > > [accounting] > > browseable=yes > > comment = /home/accounting Quick books share directory > > path = /home/accounting > > oplocks = no > > strict locking = yes > > writable = yes > > create mask = 770 > > directory mask=770 > > force group = accounting > > > > valid users = norma, karl, malaysia > > > > # the above users all belong to the accounting group > > > > > > > > > > > > > > > > > > > > > > > > -------------------------------------------------- > > Karl Schmidt EMail Karl@xtronics.com > > Transtronics, Inc. WEB http://xtronics.com > > 3209 West 9th Street Ph(785) 841-3089 > > Lawrence, KS 66049 FAX(785) 841-0434 > > > > Definition of Windows XP: > > SPAM, thinly disguised as an operating system > > -------------------------------------------------- > -- > Take care, > > Seth > seth@hollen.org > 727-919-1598 >-- Take care, Seth seth@hollen.org 727-919-1598