Re: [Samba] Slow Access Database on Samba
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 <[EMAIL PROTECTED]> 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? > -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Slow Access Database on Samba
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? -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Slow Access Database on Samba
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. Thanks for your help, santiago. On 11/11/05, Gerald Drouillard <[EMAIL PROTECTED]> wrote: > Dave Williams wrote: > > Dear All, > > > > We have an access database running on a Samba share (Samba version > > 3.0.10-1.4E) with a gigabit connection to the network. The front end of the > > databases are on the client machines with linked tables stored in a separate > > mdb file on the linux server. > > > > For some reason the database runs very slowly when it is set up in this way. > > I tested copying a 10 MB file onto the samba share and it was instant which > > leads me to believe that this is not a networking issue but tweak needed to > > the smb.conf file. I have also run the database with the back end stored on > > a Windows Peer in the network - it runs much faster than on the linux > > setup. Here is the current Global setting in smb.conf. I would be very > > grateful if anyone can help; > > > > > > [global] > > workgroup = ACE > > server string = Ace New Server > > passdb backend = tdbsam > > username map = /etc/samba/smbusers > > wins support = Yes > > local master = yes > > preferred master = yes > > wins support = yes > > socket options = IPTOS_LOWDELAY TCP_NODELAY SO_SNDBUF=4096 > > SO_RCVBUF=4096 > > oplocks = no > > > > > > Dave Williams > > > > > > > > Have a look at: > http://drouillard.ca/Tips&Tricks/Samba/Oplocks.htm > > -- > Regards > -- > Gerald Drouillard > Technology Architect > Drouillard & Associates, Inc. > http://www.Drouillard.ca > -- > To unsubscribe from this list go to the following URL and read the > instructions: https://lists.samba.org/mailman/listinfo/samba > -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Slow Access Database on Samba
Dave Williams wrote: Dear All, We have an access database running on a Samba share (Samba version 3.0.10-1.4E) with a gigabit connection to the network. The front end of the databases are on the client machines with linked tables stored in a separate mdb file on the linux server. For some reason the database runs very slowly when it is set up in this way. I tested copying a 10 MB file onto the samba share and it was instant which leads me to believe that this is not a networking issue but tweak needed to the smb.conf file. I have also run the database with the back end stored on a Windows Peer in the network - it runs much faster than on the linux setup. Here is the current Global setting in smb.conf. I would be very grateful if anyone can help; [global] workgroup = ACE server string = Ace New Server passdb backend = tdbsam username map = /etc/samba/smbusers wins support = Yes local master = yes preferred master = yes wins support = yes socket options = IPTOS_LOWDELAY TCP_NODELAY SO_SNDBUF=4096 SO_RCVBUF=4096 oplocks = no Dave Williams Have a look at: http://drouillard.ca/Tips&Tricks/Samba/Oplocks.htm -- Regards -- Gerald Drouillard Technology Architect Drouillard & Associates, Inc. http://www.Drouillard.ca -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
[Samba] Slow Access Database on Samba
Dear All, We have an access database running on a Samba share (Samba version 3.0.10-1.4E) with a gigabit connection to the network. The front end of the databases are on the client machines with linked tables stored in a separate mdb file on the linux server. For some reason the database runs very slowly when it is set up in this way. I tested copying a 10 MB file onto the samba share and it was instant which leads me to believe that this is not a networking issue but tweak needed to the smb.conf file. I have also run the database with the back end stored on a Windows Peer in the network - it runs much faster than on the linux setup. Here is the current Global setting in smb.conf. I would be very grateful if anyone can help; [global] workgroup = ACE server string = Ace New Server passdb backend = tdbsam username map = /etc/samba/smbusers wins support = Yes local master = yes preferred master = yes wins support = yes socket options = IPTOS_LOWDELAY TCP_NODELAY SO_SNDBUF=4096 SO_RCVBUF=4096 oplocks = no Dave Williams -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
