TM1 Web 10.2 Integrated Login Kerberos setup

JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by JamiseBondi »

Hi Kangkc,

In the installation of the BI runtime (bi_runtime_64b_10.2_win_ml.tar) there is no content store database available to install, the content manager is there but no content store (the apache derby bundled database). To get the content store database i tried the full BI install (bi_svr_64b_10.2_win_ml.tar) which does include the content store database. I tried getting this database to fire up but got this error message:
[ ERROR ] Content Manager failed to connect to the content store. The connection string is "jdbc:derby://serverdb1.mycompany.com:51527/cm". The error encountered is: "java.security.PrivilegedActionException : Error opening socket to server serverdb1.mycompany.com on port 51527 with message : java.net.ConnectException: Connection refused: connect"
I tried these links to get the apache derby db fired up:
http://www-01.ibm.com/support/docview.w ... wg1PI14141
http://www-01.ibm.com/support/docview.w ... wg21673320

To no avail. I'm now looking at installing IBM DB2 Express-C Edition and creating this DB first and then using the 'DDL' script to create the required tablespace.
I don't see a BI server in version 10.2.2 (see http://www-01.ibm.com/support/docview.w ... 529&tpl=17). What is the equivalent of bi_svr_64b_10.2_win_ml.tar in version 10.2.2? In other words, in order to get CAM working with the most basic BI install, what is the minimum required set of BI components needing to be installed in BI version 10.2.2? Thanks.
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by David Usherwood »

From our notes on BI/TM1 integration:
Huge step forward (for TM1 users at least) – there is now a Quick Setup option which installs all BI components, plus DB2 for the content store, on one box. Only requirements are X64 and absence of a prior DB2 install. Still extremely slow – suggest leaving it running overnight.
This was 10.2.2 BI and TM1.
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by JamiseBondi »

Hi David,

Thanks for sharing. Using the product code I found version 10.2.2 and at least that install routine gets the DB2 database installed and configured.
As you're been through this, would you mind elaborating on your setting for
ClientCAMURI in tm1s.cfg file
I see the notes here
https://www.ibm.com/support/knowledgece ... urity.html
say contact the Cognos admin. The web page is not very detailed - are you aware of a more detailed article on getting TM1 configured to use CAM without going into an unnecessarily detailed BI config (that's not required to get TM1 working with CAM authentication).

I searched for cognos.cgi in the file system and found it here: C:\Program Files\ibm\cognos\c10_64\cgi-bin\cognos.cgi
As an example I used
http://cogserver.mycompany.com/ibmcogno ... cognos.cgi

I see you referred to your "Notes on TM1/BI integration". do you take bitcoins? ;-)
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by David Usherwood »

Tempt me, why don't you....
We found Rebecca Hansen's excellent "IBM Cognos Express Installation and Migration Guide" at
http://www-01.ibm.com/support/docview.w ... wg27045726
to provide the details IBM had not previously made visible. Although it is for CX 10.2.2, since 10.2.2 is now standard between CX and TM1/BI, it should give you what you want.
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by JamiseBondi »

David, a big thank you! that guide is what I used to get BI and TM1 talking to each other.

For those of you who are not using BI for reporting and only for the CAM functionality, have you managed to turn off any of the default BI services that get installed with a default BI install routine? I'm trying to get only the CAM functionality in place and turn off any other unnecessary overhead as these services will be living on an existing TM1 server.
Cognos BI 10.2.2 services
Cognos BI 10.2.2 services
Cognos BI services.jpg (102.25 KiB) Viewed 5424 times
Many thanks.
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by JamiseBondi »

Turns out through a bit of trial and error I can get CAM running with only these services enabled:
CAM Services.jpg
CAM Services.jpg (68.66 KiB) Viewed 5399 times
Out of curiosity, have any of you been able to get multiple TM1 web servers working with a single BI server? I mean using the web services residing on each TM1 server and all of these TM1 web servers making use of the single BI server?

By removing the admin host parameter in the tm1web_config.xml file on the TM1 web server I can specify multiple admin hosts (so I can use CAM in DEV, QA and PROD) but this is using the one web server URI but I don't see how I could make use of multiple TM1 web URI's using CAM with only a single BI server? it looks like the config on the BI server (variables_TM1.xml and tm1web.html) is limited to specifying only a single TM1 web server. Any ideas on this?

Thanks.
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Post by kangkc »

You can specify multiple TM1Web servers on a single Cognos BI Server. Just separate each server with a comma.
Post Reply