samba - Aug 2002 - Strange MS-Access Problems with Samba 2.2.1a

Hello,

something strange happens sometimes with a MS access Database when trying to
open it on a samba share. The database is destroyed and I think the problem
is Samba cause in the database file you can find some log entries from
samba. I got some tips from a german ng but I think it is better to publish
it here cause might be a bug in samba 2.2.1a.
I use samba 2.2.1a on Suse 7.3 and MS Office 2000 with service pack 2 on
WIN98 SE
greetings
Gregor

Parts of the destroyed database file:
--snip--
@^A^@^G^D^@^D^@^@^@^@^@^F^@??^L^@
^@^A^@^G^D^@^C^@^@^@^@^@^F^@??^L^@
^@^A^@^G^D^@^B^@^@^@^@^@^F^@??^L^@
^@^A^@^G[2002/08/15 10:18:43, 2] smbd/open.c:open_file(216)
  GREGOR opened file Access-Datenbank/db1.mdb read=Yes write=No (numopen=2)
[2002/08/15 10:18:43, 2] smbd/close.c:close_normal_file(205)
  gregor closed file Access-Datenbank/db1.mdb (numopen=1)
[2002/08/15 10:18:43, 2] smbd/open.c:open_file(216)
  GREGOR opened file Access-Datenbank/db1.mdb read=Yes write=Yes (numopen=2)
[2002/08/15 10:18:47, 2] smbd/close.c:close_normal_file(205)
--snip--

Samba-Configuration:
[global]
server string = Herbort Server
encrypt passwords = yes
workgroup = SIMPSONS
security = DOMAIN
interfaces = 192.168.17.60/255.255.255.0
domain logons = yes
logon script=%U.bat
netbios name = samba-server
wins support = yes
os level = 255
domain master = yes
preferred master = yes
local master = yes
socket options = TCP_NODELAY IPTOS_LOWDELAY
log level = 2
case sensitive = no
mangle case = no
short preserve case = yes
preserve case = yes
dos filetimes = yes
dos filetime resolution = yes

[daten]
public=yes
comment=Daten
read only=no
path=/home/daten
create mask =  777
directory mask = 777
writeable = FALSE
valid users = gregor
write list = gregor
guest ok = no

A standard response to data corruption is to turn off oplocks. They are on
by default. Also, read about strict sync and sync always. These are off by
default.

To use the man page instead of swat.
man smb.conf
/     strict sync

Joel


On Tue, Aug 27, 2002 at 02:30:54PM +0200, Gregor Herbort
wrote:
> Hello,
> 
> something strange happens sometimes with a MS access Database when trying
to
> open it on a samba share. The database is destroyed and I think the problem
> is Samba cause in the database file you can find some log entries from
> samba. I got some tips from a german ng but I think it is better to publish
> it here cause might be a bug in samba 2.2.1a.
> I use samba 2.2.1a on Suse 7.3 and MS Office 2000 with service pack 2 on
> WIN98 SE
> greetings
> Gregor
> 
> Parts of the destroyed database file:
> --snip--
> @^A^@^G^D^@^D^@^@^@^@^@^F^@??^L^@
> ^@^A^@^G^D^@^C^@^@^@^@^@^F^@??^L^@
> ^@^A^@^G^D^@^B^@^@^@^@^@^F^@??^L^@
> ^@^A^@^G[2002/08/15 10:18:43, 2] smbd/open.c:open_file(216)
>   GREGOR opened file Access-Datenbank/db1.mdb read=Yes write=No (numopen=2)
> [2002/08/15 10:18:43, 2] smbd/close.c:close_normal_file(205)
>   gregor closed file Access-Datenbank/db1.mdb (numopen=1)
> [2002/08/15 10:18:43, 2] smbd/open.c:open_file(216)
>   GREGOR opened file Access-Datenbank/db1.mdb read=Yes write=Yes
(numopen=2)
> [2002/08/15 10:18:47, 2] smbd/close.c:close_normal_file(205)
> --snip--
> 
> Samba-Configuration:
> [global]
> server string = Herbort Server
> encrypt passwords = yes
> workgroup = SIMPSONS
> security = DOMAIN
> interfaces = 192.168.17.60/255.255.255.0
> domain logons = yes
> logon script=%U.bat
> netbios name = samba-server
> wins support = yes
> os level = 255
> domain master = yes
> preferred master = yes
> local master = yes
> socket options = TCP_NODELAY IPTOS_LOWDELAY
> log level = 2
> case sensitive = no
> mangle case = no
> short preserve case = yes
> preserve case = yes
> dos filetimes = yes
> dos filetime resolution = yes
> 
> [daten]
> public=yes
> comment=Daten
> read only=no
> path=/home/daten
> create mask =  777
> directory mask = 777
> writeable = FALSE
> valid users = gregor
> write list = gregor
> guest ok = no
> 
> -- 
> To unsubscribe from this list go to the following URL and read the
> instructions:  http://lists.samba.org/mailman/listinfo/samba

On Tue, 27 Aug 2002, Gregor Herbort wrote:
> Hello,
> 
> something strange happens sometimes with a MS access Database when trying
to
> open it on a samba share. The database is destroyed and I think the problem
> is Samba cause in the database file you can find some log entries from
> samba. I got some tips from a german ng but I think it is better to publish
> it here cause might be a bug in samba 2.2.1a.
> I use samba 2.2.1a on Suse 7.3 and MS Office 2000 with service pack 2 on
> WIN98 SE
There were several fixes to byte range locking in regards to pc database 
files done around 2.2.3a-2.2.5.  Please test latest release and let us 
know iof your problem still occurs.




cheers, jerry
 ---------------------------------------------------------------------
 Hewlett-Packard                                     http://www.hp.com
 SAMBA Team                                       http://www.samba.org
 --                                            http://www.plainjoe.org
 "Sam's Teach Yourself Samba in 24 Hours" 2ed.      ISBN
0-672-32269-2
 --"I never saved anything for the swim back." Ethan Hawk in Gattaca--

On Tue, Aug 27, 2002 at 08:48:02AM -0500, Gerald (Jerry) Carter
wrote:
> > I use samba 2.2.1a on Suse 7.3 and MS Office 2000 with service pack 2
on
> > WIN98 SE
> 
> There were several fixes to byte range locking in regards to pc database 
> files done around 2.2.3a-2.2.5.  Please test latest release and let us 
> know iof your problem still occurs.
And make sure that you do not use reiserfs. At least with SuSE 7.3 default
kernel there have been problems with that. Convert to ext2 or use the latest
SuSE kernel. Have not tested the latest reiserfs myself, but SuSE says that the
problems have been solved.

Volker
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
Url :
http://lists.samba.org/archive/samba/attachments/20020828/e49156c4/attachment.bin

Hello,

even with:
veto oplock files = /*.DBF/*.FPT/*.CDX/*.mdb/*.xls
oplocks = no
level2 oplocks = no
kernel oplocks = no
if have problems. When i try to open a file in PowerPoint i get a message
that there is existing a file with the same name and it is not possible to
save it. In Word i get a message that this file can not be imported. After
that tries the files are destroyed and the beginnig looks like this:

[2002/08/28 11:31:24, 2] smbd/open.c:open_file(216)
  GREGOR opened file Angebote/wedi_vpn20020730.ppt read=Yes write=Yes
(numopen=1)
????????????????????????????????????????????????????????????????????????????
?????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????
???????????????

It is not that easy to update the system cause using Suse and there is no
rpm. Perhaps someone knows if i can use the rpms of Suse 8.0?

Thanks so far and greetings
Gregor