OTRS 5 search issues

Moderator: crythias

Post Reply
firebolt
Znuny newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
Znuny Version: 5.0.10
Real Name: Игорь (Igor)

OTRS 5 search issues

Post by firebolt »

Hello!

We use OTRS in Russian language. After upgrading OTRS from 4.0.8 to 5.0.5 we got issues with the search engine. The engine can not find the tickets with words written in Cyrillic letters in the subject of the ticket, if these tickets were created after the OTRS upgrading. In other words, if we looking for the tickets with Russian words in the ticket's subject, it will find only those tickets which were created before the upgrading.

Also there is an error message in the System Log that says:

Code: Select all

Tue Jan 5 15:53:22 2016	error	OTRS-CGI-10	Need Search, UserLogin, PostMasterSearch or CustomerID!
Tue Jan 5 15:53:22 2016	error	OTRS-CGI-10	Need Search, UserLogin, PostMasterSearch, CustomerIDRaw or CustomerID!
Maybe there are interrelations between this error and the search issue.

Will appreciate any help!
OTRS 6.0.20, Debian GNU/Linux 9 stretch
root
Administrator
Posts: 3965
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: OTRS 5 search issues

Post by root »

What's your setting of Ticket::SearchIndexModule?
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
firebolt
Znuny newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
Znuny Version: 5.0.10
Real Name: Игорь (Igor)

Re: OTRS 5 search issues

Post by firebolt »

root wrote:What's your setting of Ticket::SearchIndexModule?
It is StaticDB.
OTRS 6.0.20, Debian GNU/Linux 9 stretch
firebolt
Znuny newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
Znuny Version: 5.0.10
Real Name: Игорь (Igor)

Re: OTRS 5 search issues

Post by firebolt »

I've ran Index Rebuild

Code: Select all

bin/otrs.Console.pl Maint::Ticket::FulltextIndexRebuild
And after this action I can't find even one ticket with russian words in the ticket's subject :D
OTRS 6.0.20, Debian GNU/Linux 9 stretch
firebolt
Znuny newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
Znuny Version: 5.0.10
Real Name: Игорь (Igor)

Re: OTRS 5 search issues

Post by firebolt »

Maybe some one can tell anything about the messages from System Log?
OTRS 6.0.20, Debian GNU/Linux 9 stretch
EXG133
Znuny expert
Posts: 217
Joined: 06 Aug 2012, 18:12
Znuny Version: 3.1.7 & 4.04

Re: OTRS 5 search issues

Post by EXG133 »

You need to check in /var/log/messages what the complete errormessage is. System Log often leaves out essential information.
firebolt
Znuny newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
Znuny Version: 5.0.10
Real Name: Игорь (Igor)

Re: OTRS 5 search issues

Post by firebolt »

EXG133 wrote:You need to check in /var/log/messages what the complete errormessage is. System Log often leaves out essential information.
In /var/log/messages I found this:

Code: Select all

[Fri Jan 15 14:56:49 2016][Error][Kernel::System::CustomerUser::DB::CustomerSearch][189] Need Search, UserLogin, PostMasterSearch, CustomerIDRaw or CustomerID!
[Fri Jan 15 14:56:49 2016][Error][Kernel::System::CustomerUser::LDAP::CustomerSearch][297] Need Search, UserLogin, PostMasterSearch or CustomerID!
I have no idea about the reason of these errors.

Here is my Config.pm

Code: Select all

    $Self->{CustomerUser1} = {
     ForeignDB => '1',
     Name => 'МАЭК',
     Module => 'Kernel::System::CustomerUser::LDAP',
     Params => {
      Host => 'svr.domain.local',
      BaseDN => 'dc=domain,dc=local',
      SSCOPE => 'sub',
      UserDN => 'cn=Admin,ou=Administrators,dc=domain,dc=local',
      UserPw => '*******',
      SourceCharset => 'utf-8',
      DestCharset => 'utf-8',
      AlwaysFilter => '(&(objectCategory=User)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',
     Params => {
		port => 389,
		timeout => 120,
		async => 0,
		version => 3
		},
    },
    CustomerKey => 'sAMAccountName',
    CustomerID => 'mail',
    CustomerUserSearchListLimit => 900,
    CustomerUserListFields => ['sAMAccountName', 'cn', 'mail'],
    CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],
    CustomerUserPostMasterSearchFields => ['mail'],
    CustomerUserNameFields => ['givenname', 'sn'],
    Map => [
      [ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var', '', 0 ],
      [ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var', '', 0 ],
      [ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var', '', 0 ],
      [ 'UserEmail', 'Email', 'mail', 1, 1, 'var', '', 0 ],
      [ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var', '', 0 ],
      [ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var', '', 0 ],
      [ 'UserTitle', 'Должность', 'title', 1, 0, 'var' ],
      [ 'UserDepartment', 'Департамент', 'department', 1, 0, 'var' ],
    ],
  };
Do I have to add these new fields into the mapping?
OTRS 6.0.20, Debian GNU/Linux 9 stretch
Post Reply