Hi there,
we have a problem regarding MS Access with Samba.
We have 4 users which open a database at the same time. When one user makes
changes to the database, the changes will not be seen on the other pcs
until the database is closed an reopened. We made some tests with several
samba options e.g. file locking, oplocks and strict locking, also with
"sync after writes" but nothing helped. When we copy the database to a
windows nt server, the problem disappears and everything works fine.
Does anyone has a proposal what problem we run into ?
Here is our smb.conf:
[global]
debug level = 3
dns proxy = no
security = user
workgroup = Edv
server string = Samba Server ka029a
socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
netbios name = ka029a
log file = /var/log/samba/log.%m
load printers = yes
netbios aliases = cal-serv
printcap name = /etc/printcap
max log size = 50
[calibration_data]
path = /db/others/calibration_data
hide dot files = no
browseable = no
writeable = yes
create mode = 700
directory mode = 700
share modes = no
map system = yes
force group = root
read list = cal_reader
map hidden = yes
valid users = cal391,cal392,cal393,cal394,
delete readonly = yes
locking = no
force user = root
It was necessary to set the force user = root flag to make it possible to
open the database from each pc at the same time. We are quite new in the
linux and samba business so it would be great if someone could help us.
Thanks in advance
Oliver Krehan
On Mon, Oct 07, 2002 at 04:47:45PM +0200, Oliver Krehan wrote:> Hi there, > > we have a problem regarding MS Access with Samba. > We have 4 users which open a database at the same time. When one user makes > changes to the database, the changes will not be seen on the other pcs > until the database is closed an reopened. We made some tests with several > samba options e.g. file locking, oplocks and strict locking, also with > "sync after writes" but nothing helped. When we copy the database to a > windows nt server, the problem disappears and everything works fine. > > Does anyone has a proposal what problem we run into ?What version of Samba ? That is usually a useful thing to add in a problem description. Jeremy.
Make sure under tools, options the default open mode is shared ....
My problems had been op locks .... They all went away after I exported
the tables to a sql server then re-imported them as links.
T o n y
A.G. (Tony) Nichols
I.S. Manager
Appalachian Log Structures Inc.
www.applog.com
tony@mail.applog.com
888-999-2574 x124
-----Original Message-----
From: samba-admin@lists.samba.org [mailto:samba-admin@lists.samba.org]
On Behalf Of Oliver Krehan
Sent: Monday, October 07, 2002 10:48 AM
To: samba@lists.samba.org
Subject: [Samba] Samba and MS Access Problems
Hi there,
we have a problem regarding MS Access with Samba.
We have 4 users which open a database at the same time. When one user
makes
changes to the database, the changes will not be seen on the other pcs
until the database is closed an reopened. We made some tests with
several
samba options e.g. file locking, oplocks and strict locking, also with
"sync after writes" but nothing helped. When we copy the database to a
windows nt server, the problem disappears and everything works fine.
Does anyone has a proposal what problem we run into ?
Here is our smb.conf:
[global]
debug level = 3
dns proxy = no
security = user
workgroup = Edv
server string = Samba Server ka029a
socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
netbios name = ka029a
log file = /var/log/samba/log.%m
load printers = yes
netbios aliases = cal-serv
printcap name = /etc/printcap
max log size = 50
[calibration_data]
path = /db/others/calibration_data
hide dot files = no
browseable = no
writeable = yes
create mode = 700
directory mode = 700
share modes = no
map system = yes
force group = root
read list = cal_reader
map hidden = yes
valid users = cal391,cal392,cal393,cal394,
delete readonly = yes
locking = no
force user = root
It was necessary to set the force user = root flag to make it possible
to
open the database from each pc at the same time. We are quite new in the
linux and samba business so it would be great if someone could help us.
Thanks in advance
Oliver Krehan
--
To unsubscribe from this list go to the following URL and read the
instructions: http://lists.samba.org/mailman/listinfo/samba