Quickbooks + samba

[Glenn MacGregor]

I have seemed to get it working.  I took oplocks off and that did nothing,
but then I made the create mask 0775 and that seems to work.  But there is a
weird problem.  I have three users on quickbooks, one with win95, one with
win98 and the other with nt.  If someone with either 95 or 98 opens the file
first the nt user can't get in, but the other 95/98 user can.  If the nt user
opens the file first everything is fine.  Kind of weird.

        Thanks

                    Glenn

David Collier-Brown wrote:

> Glenn MacGregor wrote:
> > I have put up a share for the accounting people where tey store the
> > quickbooks files.  When one person accesses the file everything is
> > fine.  smbstatus looks like this:
> >
> > Locked files:
> > Pid    DenyMode   R/W        Oplock           Name
> > --------------------------------------------------
> > 2216   DENY_NONE  RDWR       EXCLUSIVE+BATCH
> > /usr1/oracom/accounting/Quickbooks 2000/Active/New QB.QBI   Tue Sep 12
> > 13:03:07 2000
> > 2216   DENY_NONE  RDWR       EXCLUSIVE+BATCH
> > /usr1/oracom/accounting/Quickbooks 2000/Active/New QB.QBW   Tue Sep 12
> > 13:03:06 2000
>
> > notice the Quickbooks stuff has the exclusive+batch oplock.  Now when
> > someone else tries to access the file (which is allowed, it worked when
> > I had the files on an NT workstation) they get an error saying it is not
> > a quickbooks file, and the smbstatus follows:
> >
> > Locked files:
> > Pid    DenyMode   R/W        Oplock           Name
> > --------------------------------------------------
> > 2216   DENY_NONE  RDWR       EXCLUSIVE+BATCH
> > /usr1/oracom/accounting/Quickbooks 2000/Active/New QB.QBI   Tue Sep 12
> > 13:03:07 2000
> > 2229   DENY_ALL   RDWR       EXCLUSIVE+BATCH
> > /usr1/oracom/accounting/Quickbooks 2000/Active/INET/_License.tmp   Tue
> > Sep 12 13:07:33 2000
> > 2229   DENY_NONE  RDONLY     NONE
> > /usr1/oracom/accounting/Quickbooks 2000/Active/New QB.QBW   Tue Sep 12
> > 13:07:33 2000
> > 2216   DENY_NONE  RDWR       NONE
> > /usr1/oracom/accounting/Quickbooks 2000/Active/New QB.QBW   Tue Sep 12
> > 13:03:06 2000
>
>         The switch to non-oplocked (visible in QB.QBW) is intentional,
>         as we're responding to an access by breaking any oplocks.
>
>         The "not a quickbooks file" indicates
>         a) they picked a bad error message, or
>         b) the file has been overwritten.
>
>         As a first step, put oplocks=no in the share where
>         the quickbooks files live: if the problem goes away,
>         it's a quickbooks feature (;-)).  If not, we may have
>         a samba issue.
>
>         Is this Samba 2.0.7, and are any of the clients Win2000?
>
> --dave
> --
> David Collier-Brown,  | Always do right. This will gratify some people
> 185 Ellerslie Ave.,   | and astonish the rest.        -- Mark Twain
> Willowdale, Ontario   | //www.oreilly.com/catalog/samba/author.html
> Work: (905) 415-2849 Home: (416) 223-8968 Email: davecb at canada.sun.com

--

Glenn MacGregor

Director of Services
Oracom, Inc.
http://www.oracom.com

Tel. +1 978.557.5710 Ext. 302
Fax  +1 978.557.5716