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.
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
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@samba.org
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@mriresearch.org http://www.mriresearch.org Phone: (816)360-5440 FAX: (816)753-5359 Page: (816)990-8513 pagegscherb@mriresearch.org> -----Original Message----- > From: samba-bounces+gscherb=mriresearch.org@lists.samba.org > [mailto:samba-bounces+gscherb=mriresearch.org@lists.samba.org] > On Behalf Of John H Terpstra > Sent: Wednesday, March 17, 2004 11:36 AM > To: Jack Malone > Cc: samba@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@samba.org > -- > To unsubscribe from this list go to the following URL and read the > instructions: http://lists.samba.org/mailman/listinfo/samba >