[SOLVED]Slowly load customers page with AD integration

[lyubo]

Hello,
I have OTRS, which is version 6.0.29. I have ldap client integration with AD. The problem is that there are more than 700 clients, and when I open the User Client Administration tab, the page loads slowly, approximately 30-40 sec. When then client is fewer, there is no problem.
Any suggestions how i can solve this problem.

[jojo]

switch on caching, get a faster (indexed) AD

[wurzel]

Hi,

LDAP with more than 5000 should not be an issue.
700 is quite few.

Check if all ports to server are open
Check if the correct LDAP Server is queried (maybe Load balancer issue?)
Check if the DNS is working fast
Check CacheTTL Settings in your Config.pm and increase it, if needed.

regards
Flo

[lyubo]

Hi guys,
I check my Cache settings in sysconfig and they are defaults.
Cache::InBackend - Enabled
Cache::InMemory - Enabled
Cache::Module - Kernel::System::Cache::FileStorable
Cache::SubdirLevels - 2

Also and CacheTTLs

ACL::CacheTTL - 3200

FAQ::CacheTTL - 172800
GenericInterface::Operation::Common::CachedAuth::AgentCacheTTL - 300
GenericInterface::Operation::Common::CachedAuth::CustomerCacheTTL - 300
GenericInterface::WebserviceConfig::CacheTTL - 86400
Process::CacheTTL - 3600
Process::NavBarOutput::CacheTTL - 900
SMIME::CacheTTL - 86400

I made a tcp capture of the trafic and i see that the LDAP trafic takes near 30 secs.

And this is my LDAP customer Bind
$Self->{'Customer::AuthModule3'} = 'Kernel::System::CustomerAuth::LDAP';
$Self->{'Customer::AuthModule::LDAP::Host3'} = 'my dc';
$Self->{'Customer::AuthModule::LDAP::BaseDN3'} = 'my domain';
$Self->{'Customer::AuthModule::LDAP::UID3'} = 'sAMAccountName';
$Self->{'Customer::AuthModule::LDAP::UserAttr3'} = 'UID';
$Self->{'Customer::AuthModule::LDAP::SearchUserDN3'} = 'ldap account';
$Self->{'Customer::AuthModule::LDAP::SearchUserPw3'} = 'password';
$Self->{'CustomerUser3'} = {
Module => 'Kernel::System::CustomerUser::LDAP',
Params => {
Host => 'my dc',
BaseDN => 'Main OU',
SSCOPE => 'sub',
UserDN =>'ldap account',
UserPw => 'password',
AlwaysFilter => '(&(samAccountType=805306368)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
SourceCharset => 'utf-8',
DestCharset => 'utf-8',
},
CustomerKey => 'sAMAccountName',
CustomerID => 'company',
CustomerUserListFields => ['sAMAccountName', 'cn', 'mail'],
CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 3000,
CustomerUserPostMasterSearchFields => ['mail'],
CustomerUserNameFields => ['givenname', 'sn'],
Map => [
[ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ],
[ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ],
[ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ],
[ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
[ 'UserCustomerID', 'CustomerID', 'company', 1, 1, 'var' ],
],
};

[lyubo]

Got it, i saw that CacheTTL miss in my LDAP bind. Thanks!