[Samba] Microsoft Access MDB database on Samba share

[Daniel Polak]

==== Original message from Volker Lendecke at 27-1-2009 20:18
> On Tue, Jan 27, 2009 at 08:14:57PM +0100, Daniel Polak wrote:
>   
>> Yes it is OpenBSD.
>>
>> Do you expect that mmap = no will just help with the above error message 
>> or would it also help with running Access databases?
>>     
>
> That error is severe enough to kill Access DBs. If it will
> fix it -- not sure.
>
>   
>> Are the options oplocks = False and level2 oplocks = False necessary for 
>> use with Access 2000 mdb's or is that outdated?
>>     
>
> That seems outdated to me, but it doesn't hurt either,
> except for performance.
>   
Volker,

Thank you for helping me with this!

I just added use mmap = no to smb.conf and restarted Samba.

Just clicking on a mapped drive results in the following:
Jan 27 20:36:02 fileserver smbd[10133]: [2009/01/27 20:36:02, 0] 
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:write_data(562)
Jan 27 20:36:02 fileserver smbd[10133]:   write_data: write failure in 
writing to client 192.168.1.102. Error Broken pipe
Jan 27 20:36:02 fileserver smbd[10133]: [2009/01/27 20:36:02, 0] 
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:send_smb(761)
Jan 27 20:36:02 fileserver smbd[10133]:   Error writing 4 bytes to 
client. -1. (Broken pipe)

Running the database operation that is causing problems show this now:
Jan 27 20:39:26 fileserver smbd[31888]: [2009/01/27 20:39:26, 0] 
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util.c:smb_panic(1633)
Jan 27 20:39:26 fileserver smbd[31888]:   PANIC (pid 31888): Could not 
store byte range mode entry
Jan 27 20:39:26 fileserver smbd[31888]:
Jan 27 20:39:26 fileserver smbd[31888]: [2009/01/27 20:39:26, 0] 
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util.c:log_stack_trace(1787)
Jan 27 20:39:26 fileserver smbd[31888]:   unable to produce a stack 
trace on this platform
Jan 27 20:39:26 fileserver smbd[31888]: [2009/01/27 20:39:26, 0] 
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/fault.c:dump_core(181)
Jan 27 20:39:26 fileserver smbd[31888]:   dumping core in 
/var/log/cores/smbd
Jan 27 20:39:26 fileserver smbd[31888]:
Jan 27 20:39:41 fileserver nmbd[24403]: [2009/01/27 20:39:41, 0] 
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/nmbd/nmbd_become_lmb.c:become_local_master_stage2(396)
Jan 27 20:39:41 fileserver nmbd[24403]:   *****
Jan 27 20:39:41 fileserver nmbd[24403]:
Jan 27 20:39:41 fileserver nmbd[24403]:   Samba name server FILESERVER 
is now a local master browser for workgroup WG on subnet 192.168.1.2
Jan 27 20:39:41 fileserver nmbd[24403]:
Jan 27 20:39:41 fileserver nmbd[24403]:   *****

On the workstation it say Run-time error "3043":  Disk or network error.

Daniel