Excellent. :-)

(but remember to change that password now)

--

/Sune T.

From: iga3725@yahoo.com [mailto:iga3725@yahoo.com]
Sent: 26. februar 2014 12:58
To: OTRS. User questions and discussions about ; Sune T. Tougaard
Subject: Re: [otrs] (SOLVED) Sizelimit exceeded error after configure Otrs with LDAP backend.

It's working with your config... Now, our new Config.pm for LDAP is:

############################ LDAP #########################
# CustomerUser
# (customer ldap backend and settings)
$Self->{CustomerUser} = {
    Name => 'LDAP Lookup',
    Module => 'Kernel::System::CustomerUser::LDAP',
    Params => {
        # ldap host
        Host => 'domain.net',
        # ldap base dn
        BaseDN => 'OU=domain,DC=domain,DC=net',
        # search scope (one|sub)
        SSCOPE => 'sub',
        # The following is valid but would only be necessary if the
        # anonymous user does NOT have permission to read from the LDAP tree
        UserDN => 'CN=Israel Garcia Alvarez,OU=Sistemes,OU=Usuaris Roureda,OU=domain,DC=domain,DC=net',
        UserPw => 'Daniela2013',
        # in case you want to add always one filter to each ldap query, use
        # this option. e. g. AlwaysFilter => '(mail=*)' or AlwaysFilter => '(objectclass=user)'
        AlwaysFilter => '(objectclass=user)',
            # if both your frontend and your LDAP are unicode, use this:
            SourceCharset => 'utf-8',
            DestCharset   => 'utf-8',
            # if your frontend is unicode and the charset of your
            # ldap server is iso-8859-1, use these options.
            # SourceCharset => 'iso-8859-1',
            # DestCharset => 'utf-8',
            # Net::LDAP new params (if needed - for more info see perldoc Net::LDAP)
            Params => {
                port => 389,
                timeout => 120,
                async => 0,
                version => 3,
            },
    },
    # customer unique id
    CustomerKey => 'sAMAccountName',
    # customer #
    CustomerID => 'mail',
    CustomerUserListFields => ['cn', 'mail'],
    CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],
    CustomerUserSearchPrefix => '',
    CustomerUserSearchSuffix => '*',
    CustomerUserSearchListLimit => 1000,
    CustomerUserPostMasterSearchFields => ['mail'],
    CustomerUserNameFields => ['givenname', 'sn'],
    # show not own tickets in customer panel, CompanyTickets
    CustomerUserExcludePrimaryCustomerID => 0,
    # add an ldap filter for valid users (expert setting)
#    CustomerUserValidFilter => '(!(description=locked))',
    # administrator can't change customer preferences
    AdminSetPreferences => 0,
#    # cache time to live in sec. - cache any database queries
#    CacheTTL => 0,
    Map => [
        # note: Login, Email and CustomerID are mandatory!
        # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
        [ 'UserTitle',      'Title',      'title',           1, 0, 'var', '', 0 ],
        [ 'UserFirstname',  'Firstname',  'givenname',       1, 1, 'var', '', 0 ],
        [ 'UserLastname',   'Lastname',   'sn',              1, 1, 'var', '', 0 ],
        [ 'UserLogin',      'Username',   'sAMAccountName',  1, 1, 'var', '', 0 ],
        [ 'UserEmail',      'Email',      'mail',            1, 1, 'var', '', 0 ],
        [ 'UserCustomerID', 'CustomerID', 'mail',            0, 1, 'var', '', 0 ],
#        [ 'UserCustomerIDs', 'CustomerIDs', 'second_customer_ids', 1, 0, 'var', '', 0 ],
        [ 'UserPhone',      'Phone',      'telephonenumber', 1, 0, 'var', '', 0 ],
        [ 'UserAddress',    'Address',    'postaladdress',   1, 0, 'var', '', 0 ],
        [ 'UserComment',    'Comment',    'description',     1, 0, 'var', '', 0 ],
    ],
};

Thanks much Sune T. Tougaard
;)

El Miércoles 26 de febrero de 2014 11:31, "iga3725@yahoo.com" <iga3725@yahoo.com> escribió:

OK.. let me test with your config.....;)

Thanks!!

El , "iga3725@yahoo.com" <iga3725@yahoo.com> escribió:

El Miércoles 26 de febrero de 2014 11:26, Sune T. Tougaard <stt@lyngsoesystems.com> escribió:

Hi,

Well, the only issues (compared to my own AD LDAP config) that I see in the config snippet you sent are these:

1)

CustomerKey => 'uid',

In my config, I’m using:

CustomerKey => 'sAMAccountName',

2)

CustomerUserSearchFields => ['uid', 'cn', 'mail'],

In my config, I’m using:

CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],

3)

CustomerUserSearchListLimit => 1,

In my config, I’m using:

CustomerUserSearchListLimit => 1000,

(and you say you have also changed this, so…)

4)

In the Map => section:

Map => [

…

[ 'UserLogin',      'Username',   'uid',             1, 1, 'var', '', 0 ],

In my config, I’m using:

Map => [

…

[ 'UserLogin',      'Username',   'sAMAccountName',             1, 1, 'var', '', 0 ],

--

/S

From: iga3725@yahoo.com [mailto:iga3725@yahoo.com]
Sent: 26. februar 2014 10:26
To: Sune T. Tougaard; User questions and discussions about OTRS.
Subject: Re: [otrs] Sizelimit exceeded error after configure Otrs with LDAP backend.

Hi.. what I see is that Otrs does not import users from our Windows DC's servers and the error that is shown on logs is:
Feb 26 10:23:03 cmdbsrv OTRS-CGI-90[7445]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded
Feb 26 10:23:03 cmdbsrv OTRS-CGI-90[7445]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded
Feb 26 10:23:05 cmdbsrv OTRS-CGI-90[7444]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded
Feb 26 10:23:05 cmdbsrv OTRS-CGI-90[7444]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded

CustomerUserSearchListLimit parameter is 250, I have increased to 5000 and nothing happens... ;(

El Miércoles 26 de febrero de 2014 10:20, Sune T. Tougaard <stt@lyngsoesystems.com> escribió:

Without being entirely sure of what you experience, could this perhaps be an issue:

CustomerUserSearchListLimit => 1,

Try increasing that.

--

/S

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of iga3725@yahoo.com
Sent: 26. februar 2014 09:53
To: OTRS. User questions and discussions about
Subject: [otrs] Sizelimit exceeded error after configure Otrs with LDAP backend.

Hi,

We have setup otrs 3.3.2 to use a LDAP backend. For this we have added this part to Kernel/Config.pm file:

############################ LDAP #########################
# CustomerUser
# (customer ldap backend and settings)
$Self->{CustomerUser} = {
    Name => 'LDAP Lookup',
    Module => 'Kernel::System::CustomerUser::LDAP',
    Params => {
        # ldap host
        Host => 'domain.net',
        # ldap base dn
        BaseDN => 'OU=domain,DC=domain,DC=net',
        # search scope (one|sub)
        SSCOPE => 'sub',
        # The following is valid but would only be necessary if the
        # anonymous user does NOT have permission to read from the LDAP tree
        UserDN => 'CN=Israel Garcia Alvarez,OU=Sist,OU=Usuaris Roureda,OU=domain,DC=domain,DC=net',
        UserPw => 'Password',
        # in case you want to add always one filter to each ldap query, use
        # this option. e. g. AlwaysFilter => '(mail=*)' or AlwaysFilter => '(objectclass=user)'
        AlwaysFilter => '(objectclass=user)',
            # if both your frontend and your LDAP are unicode, use this:
            SourceCharset => 'utf-8',
            DestCharset   => 'utf-8',
            # if your frontend is unicode and the charset of your
            # ldap server is iso-8859-1, use these options.
            # SourceCharset => 'iso-8859-1',
            # DestCharset => 'utf-8',
            # Net::LDAP new params (if needed - for more info see perldoc Net::LDAP)
            Params => {
                port => 389,
                timeout => 120,
                async => 0,
                version => 3,
            },
    },
    # customer unique id
    CustomerKey => 'uid',
    # customer #
    CustomerID => 'mail',
    CustomerUserListFields => ['cn', 'mail'],
    CustomerUserSearchFields => ['uid', 'cn', 'mail'],
    CustomerUserSearchPrefix => '',
    CustomerUserSearchSuffix => '*',
    CustomerUserSearchListLimit => 1,
    CustomerUserPostMasterSearchFields => ['mail'],
    CustomerUserNameFields => ['givenname', 'sn'],
    # show not own tickets in customer panel, CompanyTickets
    CustomerUserExcludePrimaryCustomerID => 0,
    # add an ldap filter for valid users (expert setting)
#    CustomerUserValidFilter => '(!(description=locked))',
    # administrator can't change customer preferences
    AdminSetPreferences => 0,
#    # cache time to live in sec. - cache any database queries
#    CacheTTL => 0,
    Map => [
        # note: Login, Email and CustomerID are mandatory!
        # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
        [ 'UserTitle',      'Title',      'title',           1, 0, 'var', '', 0 ],
        [ 'UserFirstname',  'Firstname',  'givenname',       1, 1, 'var', '', 0 ],
        [ 'UserLastname',   'Lastname',   'sn',              1, 1, 'var', '', 0 ],
        [ 'UserLogin',      'Username',   'uid',             1, 1, 'var', '', 0 ],
        [ 'UserEmail',      'Email',      'mail',            1, 1, 'var', '', 0 ],
        [ 'UserCustomerID', 'CustomerID', 'mail',            0, 1, 'var', '', 0 ],
#        [ 'UserCustomerIDs', 'CustomerIDs', 'second_customer_ids', 1, 0, 'var', '', 0 ],
        [ 'UserPhone',      'Phone',      'telephonenumber', 1, 0, 'var', '', 0 ],
        [ 'UserAddress',    'Address',    'postaladdress',   1, 0, 'var', '', 0 ],
        [ 'UserComment',    'Comment',    'description',     1, 0, 'var', '', 0 ],
    ],
};

################ LDAP AUTH #####################

But when we access Customer web page ( See image attached) we see this error on Otrs's log:

Feb 26 09:32:08 cmdbsrv OTRS-CGI-90[9463]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded
Feb 26 09:32:08 cmdbsrv OTRS-CGI-90[9463]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded
Feb 26 09:32:11 cmdbsrv OTRS-CGI-90[7443]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded
Feb 26 09:32:11 cmdbsrv OTRS-CGI-90[7443]: [Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][Line:380]: Sizelimit exceeded

Does any of you have any idea why?

Thanks much!

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs