[Samba] Microsoft Access MDB database on Samba share
Daniel Polak
daniel at sys.nl
Tue Jan 27 16:04:19 GMT 2009
I'm having problems using Microsoft Access 2000 mdb files on a Samba share.
The same database worked very well on a Windows server.
I had hoped Samba would be a drop in replacement for a Windows server
but apparently Access needs special Samba configuration.
In Access I sometimes get Run-time error '3035': System resource exceeded.
I don't see any errors in the log file when this is happening.
Concurrent access to the database doesn't work well either.
The log shows the following for yesterday: These messages maybe not be
related to my Access database problem but they still worry me a bit:
Jan 26 10:14:32 fileserver smbd[3850]: [2009/01/26 10:14:32, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util.c:smb_panic(1633)
Jan 26 10:14:32 fileserver smbd[3850]: PANIC (pid 3850): Could not
store byte range mode entry
Jan 26 10:14:32 fileserver smbd[3850]:
Jan 26 10:14:32 fileserver smbd[3850]: [2009/01/26 10:14:32, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util.c:log_stack_trace(1787)
Jan 26 10:14:32 fileserver smbd[3850]: unable to produce a stack trace
on this platform
Jan 26 10:14:32 fileserver smbd[3850]: [2009/01/26 10:14:32, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/fault.c:dump_core(181)
Jan 26 10:14:32 fileserver smbd[3850]: dumping core in /var/log/cores/smbd
Jan 26 10:14:32 fileserver smbd[3850]:
Jan 26 10:14:38 fileserver smbd[1771]: [2009/01/26 10:14:38, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:set_socket_options(261)
Jan 26 10:14:38 fileserver smbd[1771]: Failed to set socket option
TCP_NODELAY (Error Connection reset by peer)
Jan 26 10:14:38 fileserver smbd[1771]: [2009/01/26 10:14:38, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:get_peer_addr(1224)
Jan 26 10:14:38 fileserver smbd[1771]: getpeername failed. Error was
Socket is not connected
Jan 26 10:14:38 fileserver smbd[1771]: [2009/01/26 10:14:38, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:write_data(562)
Jan 26 10:14:38 fileserver smbd[1771]: write_data: write failure in
writing to client 192.168.8.82. Error Broken pipe
Jan 26 10:14:38 fileserver smbd[1771]: [2009/01/26 10:14:38, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:send_smb(761)
Jan 26 10:14:38 fileserver smbd[1771]: Error writing 4 bytes to
client. -1. (Broken pipe)
Jan 26 12:40:51 fileserver smbd[23103]: [2009/01/26 12:40:51, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:get_peer_addr(1224)
Jan 26 12:40:51 fileserver smbd[23103]: getpeername failed. Error was
Socket is not connected
Jan 26 12:40:51 fileserver smbd[23103]: [2009/01/26 12:40:51, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:write_data(562)
Jan 26 12:40:51 fileserver smbd[23103]: write_data: write failure in
writing to client 192.168.8.209. Error Broken pipe
Jan 26 12:40:51 fileserver smbd[23103]: [2009/01/26 12:40:51, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/lib/util_sock.c:send_smb(761)
Jan 26 12:40:51 fileserver smbd[23103]: Error writing 4 bytes to
client. -1. (Broken pipe)
Jan 26 14:06:19 fileserver smbd[10362]: [2009/01/26 14:06:19, 0]
/usr/obj/i386/samba-3.0.31/samba-3.0.31/source/smbd/nttrans.c:call_nt_transact_ioctl(2463)
Jan 26 14:06:19 fileserver smbd[10362]:
call_nt_transact_ioctl(0x9009c): Currently not implemented.
Samba version is 3.0.31 running on OpenBSD 4.4 current (from August last
year).
smb.conf:
[shared]
comment = file exchange
path = /var/fileserver
read only = no
browseable = yes
create mask = 0774
force create mode 0774
oplocks = False
level2 oplocks = False
What is the recommended Samba configuration for use with Microsoft
Access databases?
What is causing the error messages in the log?
Daniel
More information about the samba
mailing list