[Samba] Slow Access Database on Samba

[jorge santiago]

Sure, I pasted it below,  dbsystem is the share where the Access
database is located. I'm using debian sarge (samba 3.0.14a-3, openldap
2.2.23-8).

santiago.

/etc/samba/smb.conf:

#======================= Global Settings =======================

[global]
   workgroup = myworkgroup
   netbios name = mysmbserver
   server string = %h server
   wins support = yes
   name resolve order = lmhosts host wins bcast

   log file = /var/log/samba/log.%m
   log level = 1
   max log size = 1000
   syslog = 0
   panic action = /usr/share/samba/panic-action %d

   security = user
   encrypt passwords = true
   passdb backend = ldapsam:ldap://127.0.0.1

   ldap ssl = Off

   obey pam restrictions = no

   ldap admin dn = cn=admin,dc=mydomain,dc=com
   ldap suffix = dc=mydomain,dc=com
   ldap group suffix = ou=Groups
   ldap user suffix = ou=People
   ldap machine suffix = ou=Computers
   ldap idmap suffix = ou=People

   ldap passwd sync = Yes
   passwd program = /usr/sbin/smbldap-passwd %u
   passwd chat = *New*password* %n\n *Retype*new*password* %n\n
*all*authentication*tokens*updated*

   guest account = nobody
   invalid users = root
   admin users = Administrator

   add user script = /usr/sbin/smbldap-useradd -m "%u"
   ldap delete dn = Yes
   delete user script = /usr/sbin/smbldap-userdel "%u"
   add machine script = /usr/sbin/smbldap-useradd -w "%u"
   add group script = /usr/sbin/smbldap-groupadd -p "%g"
   delete group script = /usr/sbin/smbldap-groupdel "%g"
   add user to group script = /usr/sbin/smbldap-groupmod -m "%u" "%g"
   delete user from group script = /usr/sbin/smbldap-groupmod -x "%u" "%g"
   set primary group script = /usr/sbin/smbldap-usermod -g "%g" "%u"

  logon script = netlogon.bat
  socket options = TCP_NODELAY IPTOS_LOWDELAY SO_RCVBUF=8192 SO_SNDBUF=8192

   domain logons = yes
   domain master = yes
   preferred master = yes
   local master = yes

   os level = 100

   time server = yes

   getwd cache = yes
   use sendfile = no
   lock spin time = 15
   lock spin count = 30
   hosts allow = 172.25.0.0/16 172.30.0.0/16 127.0.0.1
   interfaces = eth1 eth1:0 lo
   bind interfaces only = yes
  ;dns proxy = no
   oplocks = no
   level2 oplocks = no
   change notify timeout = 300
   dos filetimes = yes
   strict locking = no

#======================= Share Definitions =======================

[homes]
   comment = Home Directories
   browseable = no
   writable = yes
   create mask = 0700
   directory mask = 0700
   oplocks = yes
   level2 oplocks = yes
   root preexec = /usr/local/sbin/sambalogger.sh start %u %m %I
   root postexec = /usr/local/sbin/sambalogger.sh stop %u %m %I

[netlogon]
   comment = Network Logon Service
   path = /home/SambaPot/netlogon
   guest ok = yes
   writable = no
   share modes = no

[printers]
   comment = All Printers
   browseable = no
   path = /tmp
   printable = yes
   public = no
   writable = no
   create mode = 0700

[dbsystem]
        path = /home/SambaPot/dbsystem
        read only = Yes
        browseable = Yes
        create mask = 0666
        directory mask = 0777
        write list = @dbsystem


On 11/16/05, Gerald Drouillard <gerrylist at drouillard.ca> wrote:
> Jorge Santiago wrote:
>
> >I've applied all the optimizations you mention in that URL in my own
> >smb.conf but my problem persists.  The first user of the database
> >opens it very fast, but the next users that try to open it, do it very
> >slowly.  Do you know what option (locking option?) might cause this
> >behaviour? I've also tried 'strict locking = no' with no success.
> >
> >
> Can we see what you smb.conf looks like now?
>