[Samba] access database locking issue

[Scherb, Glenn]

Try adding *.ldb to the veto oplocks list.

We've doing MS Access development here with Samba servers since 1998.
I've had the most reliable Access database performance with oplocks
disabled.

Platform:  FreeBSD 4.9, Samba 2.2.8a

--
Glenn Scherb
Midwest Research Institute
425 Volker Boulevard
Kansas City, Missouri 64110
gscherb at mriresearch.org
http://www.mriresearch.org 

	
	Phone: (816)360-5440
	FAX: (816)753-5359
	Page: (816)990-8513
	pagegscherb at mriresearch.org

 


> -----Original Message-----
> From: samba-bounces+gscherb=mriresearch.org at lists.samba.org 
> [mailto:samba-bounces+gscherb=mriresearch.org at lists.samba.org]
>  On Behalf Of John H Terpstra
> Sent: Wednesday, March 17, 2004 11:36 AM
> To: Jack Malone
> Cc: samba at lists.samba.org
> Subject: Re: [Samba] access database locking issue
> 
> 
> On Wed, 17 Mar 2004, Jack Malone wrote:
> 
> > Hello. after getting suse 9.0 loaded on a new machine here an 
> > configuring samba 2.28 that came on the cd's I'm having a locking 
> > problem with some access database files. I had this same 
> problem when 
> > i first went to linux 2 years go an started storing some access 
> > database files on the server. It seems only one person  (an 
> sometimes 
> > 2 i'm told by the users) can have the file open at a time. 
> we use it 
> > for keeping up with our traffice log here of incoming an outgoing 
> > shippments. it was working fine on the old server but now that it 
> > crashed on me I had to setup a temp machine til i get some 
> new parts 
> > in for the old one.
> 
> When you moved this database did you reset the lock handling 
> settings in MS Access?
> 
> You must launch MS Access, open Toolss->Options->General, 
> then reset the network path to the shared database folder. 
> Also be sure to set the correct parameters under the "Advanced" tab.
> 
> - John T.
> 
> >
> > i will post my samba conf file in this email for someone to 
> look at an 
> > point me in the direction i'm going wrong. thanks for the 
> info / help.
> >
> > jack
> >
> > smb.conf file is below
> >
> >
> > # smb.conf is the main Samba configuration file. You find a full 
> > commented # version at 
> > /usr/share/doc/packages/samba/examples/smb.conf.SuSE
> > # Date: 2003-09-23
> > [global]
> >        socket options = SO_KEEPALIVE IPTOS_LOWDELAY TCP_NODELAY
> >        domain logons = no
> >        unix extensions = Yes
> >        encrypt passwords = yes
> >        map to guest = Bad User
> >        security = user
> >        preferred master = auto
> >        add user script =
> >        time server = Yes
> >        printing = CUPS
> >        veto oplock files = /*.dbf/*.fpt/*.cdx/*.mdb/*.xls
> >        domain master = false
> >        printcap name = CUPS
> >        veto files = /*.eml/*.nws/riched20.dll/*.{*}/
> >        workgroup = etlb
> >        server string = BackUP production server (FROG)
> >        os level = 68
> >        local master = no
> >        netbios name = Frog samba server
> >        wins support = true
> >
> > [homes]
> >     comment = Home Directories
> >     valid users = %S
> >     browseable = no
> >     read only = No
> >     create mask = 0640
> >     directory mask = 0750
> >     guest ok = no
> >     printable = no
> > [printers]
> >     comment = All Printers
> >     path = /var/tmp
> >     printable = yes
> >     create mask = 0600
> >     browseable = no
> >     guest ok = no
> > [print$]
> >     comment = Printer Drivers
> >     path = /var/lib/samba/drivers
> >     write list = @ntadmin root
> >     force group = ntadmin
> >     create mask = 0664
> >     directory mask = 0775
> >     browseable = yes
> >     guest ok = no
> >     printable = no
> > [horizon]
> >        path = /horizon
> >        writeable = yes
> >        comment = frog samba server
> >          create mask = 0777
> >        force directory mode = 777
> >
> >
> >
> > thanks again
> >
> >
> >
> >
> > jack malone
> > Network Administrator
> > EAST TEXAS LIGHTHOUSE FOR THE BLIND
> > dba HORIZON INDUSTRIES
> > 903-595-3444
> > http://www.horizonind.com
> >
> >
> 
> -- 
> John H Terpstra
> Email: jht at samba.org
> -- 
> To unsubscribe from this list go to the following URL and read the
> instructions:  http://lists.samba.org/mailman/listinfo/samba
>