Adrià Batlle
2012-May-09 08:13 UTC
[Samba] Technical problems with samba 3.5.11 and access 97 .mdb
Hello everybody, I'm having trouble with samba 3.5.11 and an access 97 database. I work in a business with 5 users that use a mdb database over samba, and for the first to make a query everything works fine, but if some other user tries to make a query when the first one is doing it, the database works really slow, like if the .mdb file is being blocked (that's what I suppose). I've been reading a lot about it, i found people talking about changing the smb.conf to oplock = no and level2 oplock = no, but it doesn't work for me. smb.conf [global] log file = /var/log/samba/log.%m syslog = 0 panic action = /usr/share/samba/panic-action %d guest account = nobody encrypt passwords = true passdb backend = tdbsam passwd chat = *Enter\snew\s*\spassword:* %n\n *Retype\snew\s*\spassword:* %n\n *password\supdated\ssuccessfully* . obey pam restrictions = yes map to guest = bad user socket options = TCP_NODELAY SO_RCVBUF=65536 SO_SNDBUF=65536 IPTOS_LOWDELAY passwd program = /usr/bin/passwd %u dns proxy = no netbios name= Server server string = %h logon script = INICIO.BAT unix password sync = yes workgroup = TRM os level = 99 usershare allow guests = yes security = share max log size = 1000 pam password change = yes # domain logons = yes domain logons = no interfaces = 192.168.0.193/255.255.255.0 oplocks = no level2 oplocks = no # strict locking = no fake oplocks = no [netlogon] path = /usr/lib/samba/netlogon [SHARE] comment = Servidor path = /mnt/fitxers browseable = yes read only = no guest ok = yes With an earlier version of samba (2 i think) everything was fine, but since i upgraded it users complain me about how slowly the database works (just when 2 people are using it). Sorry for my horrible english and thanks for your time. Adri?,
Daniel Müller
2012-May-09 10:18 UTC
[Samba] Technical problems with samba 3.5.11 and access 97 .mdb
This is a bug in access . We do not use the mdbs in our network anymore. Good Luck Daniel ----------------------------------------------- EDV Daniel M?ller Leitung EDV Tropenklinik Paul-Lechler-Krankenhaus Paul-Lechler-Str. 24 72076 T?bingen Tel.: 07071/206-463, Fax: 07071/206-499 eMail: mueller at tropenklinik.de Internet: www.tropenklinik.de ----------------------------------------------- -----Urspr?ngliche Nachricht----- Von: samba-bounces at lists.samba.org [mailto:samba-bounces at lists.samba.org] Im Auftrag von Adri? Batlle Gesendet: Mittwoch, 9. Mai 2012 10:14 An: samba at lists.samba.org Betreff: [Samba] Technical problems with samba 3.5.11 and access 97 .mdb Hello everybody, I'm having trouble with samba 3.5.11 and an access 97 database. I work in a business with 5 users that use a mdb database over samba, and for the first to make a query everything works fine, but if some other user tries to make a query when the first one is doing it, the database works really slow, like if the .mdb file is being blocked (that's what I suppose). I've been reading a lot about it, i found people talking about changing the smb.conf to oplock = no and level2 oplock = no, but it doesn't work for me. smb.conf [global] log file = /var/log/samba/log.%m syslog = 0 panic action = /usr/share/samba/panic-action %d guest account = nobody encrypt passwords = true passdb backend = tdbsam passwd chat = *Enter\snew\s*\spassword:* %n\n *Retype\snew\s*\spassword:* %n\n *password\supdated\ssuccessfully* . obey pam restrictions = yes map to guest = bad user socket options = TCP_NODELAY SO_RCVBUF=65536 SO_SNDBUF=65536 IPTOS_LOWDELAY passwd program = /usr/bin/passwd %u dns proxy = no netbios name= Server server string = %h logon script = INICIO.BAT unix password sync = yes workgroup = TRM os level = 99 usershare allow guests = yes security = share max log size = 1000 pam password change = yes # domain logons = yes domain logons = no interfaces = 192.168.0.193/255.255.255.0 oplocks = no level2 oplocks = no # strict locking = no fake oplocks = no [netlogon] path = /usr/lib/samba/netlogon [SHARE] comment = Servidor path = /mnt/fitxers browseable = yes read only = no guest ok = yes With an earlier version of samba (2 i think) everything was fine, but since i upgraded it users complain me about how slowly the database works (just when 2 people are using it). Sorry for my horrible english and thanks for your time. Adri?, -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/options/samba
Denis Cardon
2012-May-09 12:05 UTC
[Samba] Technical problems with samba 3.5.11 and access 97 .mdb
Hi Adria,> I'm having trouble with samba 3.5.11 and an access 97 database. > > I work in a business with 5 users that use a mdb database over samba, and > for the first to make a query everything works fine, but if some other user > tries to make a query when the first one is doing it, the database works > really slow, like if the .mdb file is being blocked (that's what I suppose). > > I've been reading a lot about it, i found people talking about changing the > smb.conf to oplock = no and level2 oplock = no, but it doesn't work for me. >Have you tried adding the following line to your shares? veto oplock files = /*.mdb/*.MDB/ Cheers, Denis> smb.conf > > [global] > log file = /var/log/samba/log.%m > syslog = 0 > panic action = /usr/share/samba/panic-action %d > guest account = nobody > encrypt passwords = true > passdb backend = tdbsam > passwd chat = *Enter\snew\s*\spassword:* %n\n > *Retype\snew\s*\spassword:* %n\n *password\supdated\ssuccessfully* . > obey pam restrictions = yes > map to guest = bad user > socket options = TCP_NODELAY SO_RCVBUF=65536 SO_SNDBUF=65536 > IPTOS_LOWDELAY > passwd program = /usr/bin/passwd %u > dns proxy = no > netbios name= Server > server string = %h > logon script = INICIO.BAT > unix password sync = yes > workgroup = TRM > os level = 99 > usershare allow guests = yes > security = share > max log size = 1000 > pam password change = yes > # domain logons = yes > domain logons = no > interfaces = 192.168.0.193/255.255.255.0 > oplocks = no > level2 oplocks = no > # strict locking = no > fake oplocks = no > > [netlogon] > path = /usr/lib/samba/netlogon > > [SHARE] > comment = Servidor > path = /mnt/fitxers > browseable = yes > read only = no > guest ok = yes > > > With an earlier version of samba (2 i think) everything was fine, but since > i upgraded it users complain me about how slowly the database works (just > when 2 people are using it). > > Sorry for my horrible english and thanks for your time. > > Adri?,-- Denis Cardon Tranquil IT Systems 44 bvd des pas enchant?s 44230 Saint S?bastien sur Loire tel : +33 (0) 2.40.97.57.57 http://www.tranquil-it-systems.fr