can't connect to LDAP

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

can't connect to LDAP

Post by EP_explorer »

I'm trying to connect to SUn One Directory Server 5.2

I have no problems in connecting using etldap as Anonymous (
see 01_connect
01_connect.jpg
01_connect.jpg (22.01 KiB) Viewed 9102 times
), or using User Info
(see 02_connect
02_connect.jpg
02_connect.jpg (21.78 KiB) Viewed 9102 times
)

After it I export user to TM1 server using etldap
and here I've stuck

I've written many different lines in TM1s.cfg but result is the same
Login Failed: LDAPServerConnectionFailed when I'm trying to connect (using for example Tm1 Architect)

This is quote from TM1s.cfg

UseSSL=F
PasswordSource=LDAP
LDAPPort=1543
LDAPHost=kondor
LDAPSearchField=uid
LDAPSearchBase=ou=Groups,dc=local
LDAPWellKnownUserName=uid=***, ou=Groups, dc=local
#On place of *** is name of user from Sun One Directory
LDAPUseServerAccount=F
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: can't connect to LDAP

Post by rmackenzie »

Don't you have to supply LDAPWellKnownPassword as well?

Edit... depends on your version...
Robin Mackenzie
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: can't connect to LDAP

Post by moby91 »

Starting TM1 9.1,the first version of TM1 to support SSL, TM1 supports only the SSL encrypted LDAPS (LDAP over SSL) protocol, which by default is using the TCP port 636.

Does your LDAP Server support the LDAPS protocol ?

In case your LDAP Server supports the LDAPS protocol, which TCP Port is used by the LDAPS protocol ?



By default the ETLDAP tool supports the LDAP protocol. By default the LDAP protocol is using the TCP port 389. To force the ETLDAP tool to use the LDAPS protocol you have to check the checkbox "SSL". But that is nothing but the first step to configure the ETLDAP tool to use the LDAPS protocol.


When you are using LDAP Authentication, the TM1 Server is a LDAP Client to your LDAP Server. As an LDAP Client the TM1 Server has to logon to your LDAP Server using a valid LDAP user and password. There are two options to achive that:
The first one is that the Windows user running the TM1 server process is also a valid LDAP user. If that is the case, you can set the LDAP specific parameter "LDAPUseServerAccount=T".
If that is not the case, if the Windows user running your TM1 server process is not a valid LDAP user, you must use the second option and explicitly specify a valid LDAP user (and his password) in the TM1 server configuration file tm1s.cfg . This is initiated by the parameter "LDAPUserServerAccount=F". After that you must specify the three LDAP specific parameters "LDAPWellKnownUserName", "LDAPPAsswordFile" and "LDAPPasswordKeyfile".


When using an explicitly named LDAP User by setting the LDAP specific parameters "LDAPUseServerAccount=F" and "LDAPWellKnownUserName", you must also also pass the LDAP password of that LDAP user. Prior to TM1 9.1, that LDAP password was stored unencrypted as clear text in the LDAP specific parameter "LDAPWellKnownPassword". As of TM1 9.1, the LDAP password is stored in encrypted form in the two files referred to by the two LDAP specific parameters "LDAPPAsswordFile" and "LDAPPasswordKeyfile". These two files are created using the TM1Crypt.exe tool.


For detailed information see the IBM Cognos Proven Practice "Configuring LDAP authentication for TM1 9.5":

http://www.ibm.com/developerworks/data/ ... ge498.html
Configuring LDAP authentication for TM1 9.5

Summary: This document is meant to supplement the TM1 9.5 Operations Guide as it describes the task of configuring LDAP authentication for TM1 9.5 in greater detail.

http://public.dhe.ibm.com/software/dw/d ... M1_9.5.pdf
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: can't connect to LDAP

Post by EP_explorer »

Thank you for excellent explanation.

But anyway I can't connect (((
If generated .dat files and put way to them in TM1s.cfg

It was like
tm1crypt.exe -pwd *** -keyfile btkey.dat -outfile btprk.dat -validate

TM1s.cfg looks like

PasswordSource=LDAP
LDAPPort=1543
LDAPHost=kondor
LDAPSearchField=uid
LDAPSearchBase=ou=Groups,dc=local
LDAPWellKnownUserName=uid=***,ou=Groups,dc=local
LDAPUseServerAccount=F
LDAPPasswordFile=C:\Lib\Assump_dat\btprk.dat
LDAPPasswordKeyFile=C:\Lib\Assump_dat\btkey.dat

But error is the same. May be I should try another LDAP )))
Although I can say I can connect to it using Cognos8 and etldap. Very strange
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: can't connect to LDAP

Post by moby91 »

What LDAP related error messages do you get in your TM1 server message logfile tm1server.log ?


Did you enable Debug Level Logging for LDAP Authentication by adding the logger

log4j.logger.TM1.LDAPAuth=DEBUG

to your logger configuration file tm1s-log.properties ?
Last edited by moby91 on Wed Nov 02, 2011 5:03 pm, edited 1 time in total.
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: can't connect to LDAP

Post by moby91 »

In your TM1 server configuration file tm1s.cfg you specified the TCP port 1543 as the TCP port used by your LDAP Server for LDAPS communication.

This must be wrong:
According to the two screenshots displayed by your first email 1543 is the TCP port used for LDAP communication as the checkbox "SSL" is not checked.

What TCP port is your LDAP Server using for LDAPS communication ?

That value you must set using the TM1 server configuration parameter "LDAPPort".
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: can't connect to LDAP

Post by EP_explorer »

Actually I don't find something useful in log. files althoug I have put
log4j.logger.TM1=INFO, S1
log4j.logger.TM1.LDAPAuth=DEBUG

in tm1s-log.properties

The only thing there is:

2464 ERROR 2011-11-04 11:05:51.292 TM1.LDAPAuth LDAP ERROR: 0x51 - ldap_connect failed.


But it seems connection is impossinble without SSL tuning. ok I will try to do it and tell about results.
adarsh
Posts: 3
Joined: Sat May 14, 2011 4:52 am
OLAP Product: TM1
Version: cognos TM1 10.1.0
Excel Version: Excal 2007

Re: can't connect to LDAP

Post by adarsh »

Is this LDAP issues fixed? Iam also facing the same issue.
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: can't connect to LDAP

Post by jameswebber »

Post Reply