[SOLVED] Unable to see customer data

[aph]

Hi,

I have configured an LDAP backend for customer users, however I am unable to see customer data in web interface (Customer-> Customer User Administration).
I have it working on a virtual machine, but I get 'HTTP 500 Internal Server Error', when I try to see customer data. I'm attaching my Config file.

Thank you.

[crythias]

500 internal server error always (usually) explains itself in apache error.log. What's the error?

[aph]

I'm using IIS as server on Windows Server 2008. Where can I see the error log?
EDIT: When I unclick 'show friendliy http error message' it shows a 'script failed to send data' error

[crythias]

You are going to have more problems with Windows than with the Appliance for this purpose.

[aph]

I wish I had the choice to use Linux / Apache!

[crythias]

You can't even use Hyper-V to host the appliance?

[crythias]

arg ... that config is eternal. And in German. Is the German forum unable to assist you? (Or are you crossposting...?)
Relevant code:

Code: Select all

	# CustomerUser
	# (customer user ldap backend and settings)
     $Self->{CustomerUser1} = {
        Name => 'LDAP Backend',
        Module => 'Kernel::System::CustomerUser::LDAP',
		Params => {
            Host => 'slgrz1-dc3.xxxx.intra',
            # ldap base dn
            BaseDN => 'dc=xxxx,dc=intra',
            SSCOPE => 'sub',
            UserDN => 'CN=service_otrs_adread,OU=Serviceaccounts,OU=OTRS,OU=All_Divisions,OU=Central_Services,OU=Resources,DC=xxxx,DC=intra',
            UserPw => 'xxxx',
            Params => {
					 inet4 => 1,
            },
         },
         CustomerKey => 'userPrincipalName',
         CustomerID => 'userPrincipalName',
         CustomerUserSearchListLimit => 250,
         CustomerUserNameFields => ['givenname', 'sn'],
         Map => [
             [ 'UserTitle',      'Title',      'title',           1, 0, 'var', '', 0 ],
             [ 'UserFirstname',  'Firstname',  'givenname',       1, 1, 'var', '', 0 ],
             [ 'UserLastname',   'Lastname',   'sn',              1, 1, 'var', '', 0 ],
             [ 'UserLogin',      'Username',   'userPrincipalName',             1, 1, 'var', '', 0 ],
             [ 'UserEmail',      'Email',      'userPrincipalName',            1, 1, 'var', '', 0 ],
             [ 'UserCustomerID', 'CustomerID', 'userPrincipalName',            0, 1, 'var', '', 0 ],
			 [ 'UserPhone',      'Phone',      'telephonenumber', 1, 0, 'var', '', 0 ],
			 [ 'UserAddress',    'Address',    'postaladdress',   1, 0, 'var', '', 0 ],
            [ 'UserComment',    'Comment',    'description',     1, 0, 'var', '', 0 ],
         ],
    };
#---------------------------APH Kommentar--------------------------------------------------------------------------------------#
# Einstellungen für CustomerUser für zweites LDAP Backend:
#------------------------------------------------------------------------------------------------------------------------------#
	# CustomerUser
     $Self->{CustomerUser2} = {
        Name => 'LDAP Backend2',
        Module => 'Kernel::System::CustomerUser::LDAP',
		Params => {
            Host => 'slgrz1-dc4.xxxx.intra',
            BaseDN => 'dc=xxxx,dc=intra',
            SSCOPE => 'sub',
            UserDN => 'CN=xxxx,OU=Serviceaccounts,OU=OTRS,OU=All_Divisions,OU=Central_Services,OU=Resources,DC=xxxx,DC=intra',
            UserPw => 'xxxx',
            Params => {
					 inet4 => 1,
            },
         },
         CustomerKey => 'userPrincipalName',
         CustomerID => 'userPrincipalName',
         CustomerUserSearchListLimit => 250,
       CustomerUserNameFields => ['givenname', 'sn'],
         Map => [
             [ 'UserTitle',      'Title',      'title',           1, 0, 'var', '', 0 ],
             [ 'UserFirstname',  'Firstname',  'givenname',       1, 1, 'var', '', 0 ],
             [ 'UserLastname',   'Lastname',   'sn',              1, 1, 'var', '', 0 ],
             [ 'UserLogin',      'Username',   'userPrincipalName',             1, 1, 'var', '', 0 ],
             [ 'UserEmail',      'Email',      'userPrincipalName',            1, 1, 'var', '', 0 ],
             [ 'UserCustomerID', 'CustomerID', 'userPrincipalName',            0, 1, 'var', '', 0 ],
			 [ 'UserPhone',      'Phone',      'telephonenumber', 1, 0, 'var', '', 0 ],
			 [ 'UserAddress',    'Address',    'postaladdress',   1, 0, 'var', '', 0 ],
            [ 'UserComment',    'Comment',    'description',     1, 0, 'var', '', 0 ],
         ],
    };

Any additional otrs.log would be of interest.

[aph]

I agree. It has started to become complex.
For my understanding I still prefer English. The comments are for my colleagues.
There is no additional message in the otrs.log
Customers can authenticate against the ldap backend and log into customer portal.

[aph]

If I could use Hyper-V for OTRS Appliance, how would I get the LDAP Sync etc. running, since there is no config.pm and I cannot store OTRS data in a MSSQL DB. Or am I getting it completely wrong?

[crythias]

how would I get the LDAP Sync etc. running, since there is no config.pm

Of course there is. How else would we be able to communicate if I'm running Linux and you're running Windows?

I cannot store OTRS data in a MSSQL DB

well, again, up to you on where you store data. If you insist on MSSQL, you can use FreeTDS or something, but you can also just use the included MySQL in the appliance.

[aph]

is there some documentation available on installing appliance on windows server 2008 using Hyper V? I would like to give it a try if it will make matters less complicated

[crythias]

Documentation?

Download iso, create vm, boot iso within vm, follow instructions.

[crythias]

BTW, if you don't know how to use Hyper-V and VMs don't go blindly following instructions by some guy on the Internet. Some reasonable amount of sanity, intelligence, and use of proper backups is assumed. :)

What you do on your servers is up to your responsibility.

[aph]

I did try OTRS appliance on VM as described in http://otrs.github.io/doc/manual/appliance/3.3/en/html/.
However, where would I configure the system,for example, for LDAP etc. Where are the config and defaults files? The appliance manager in the web interface would only let me reboot, shutdown and update the system, which is no different than in VM. The system settings in the VM don't provide the option to configure OTRS as with config.pm

[crythias]

look at the bottom of the interface page. I believe you can press F2.
http://otrs.github.io/doc/manual/applia ... 05s05.html

[aph]

hmmmmm very tedious to edit the files on the system using vi! It is not possible to copy my existing Config.pm to the otrs appliance, is it?

[crythias]

ssh, putty, filezilla, ...

[aph]

Hmmmmm, certainly not the easiest solution. What I wonder about is why it works on a VM running Windows Server, but not a windows server itself!
Btw I get the following information message in IIS log when I click on 'Customers -> Customer User Administration.

Unbenannt.PNG

A message saying 'the OTRS database is being started'.

[aph]

I was able to solve the problem. Apprently I had commented the line:

Code: Select all

CustomerUserListFields => ['cn', 'mail'],

Uncommenting the line solved the problem.