UseSSL

Post Reply
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

UseSSL

Post by Wim Gielis »

I was looking at a connection with the TM1 REST API to a customer's model. In the config file, we have UseSSL = T. When the TM1 server starts, it logs SSL Mode: 0. Does 0 mean True ? I haven't looked at it in any great detail but I found it weird.
02.png
02.png (30.1 KiB) Viewed 20042 times
01.png
01.png (54.14 KiB) Viewed 20042 times
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: UseSSL

Post by jim wood »

We have recently enabled SSL and the rest api code we've been using for a while no longer works, so there's some weird stuff happening and we are still looking at it.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
gtonkin
MVP
Posts: 1202
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: UseSSL

Post by gtonkin »

Hi Wim,

Seems fine on my side - What version are you trying on?

TM1 Build Number: 11.8.00500.12 (possibly PA 2.0.9.6)

Code: Select all

33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Logging Directory: c:\tm1 logs\XYZ
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Configuration Directory: c:\tm1 data\XYZ
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Raw Store Directory: c:\tm1 data\XYZ
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Port: 27472
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   HTTPPort: 27474
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Client Message Port: 27473
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Client Message Port does not accept Tm1Top connections.
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   IP Version: ipv4
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   SSL Mode: 1
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Key File: C:\Program Files\ibm\cognos\tm1_64\bin64\ssl\ibmtm1.kdb
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Key Stash File: C:\Program Files\ibm\cognos\tm1_64\bin64\ssl\ibmtm1.sth
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   FIPS Operation Mode: 2
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   NIST SP800 131A Mode: 1
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Certificate Authority: ibmtm1.arm
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Client Export Server Certificate: 0
33244   []   INFO   2021-05-18 15:53:13.521   TM1.Server   Security Mode: 1
Assuming you have double-checked that there is not another UseSSL statement in the file.
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: UseSSL

Post by Wim Gielis »

Hello Jim, George,

Thanks for the replies.

It's server version 11.8.00100.13 which equates to 2.0.9.2 (July 2020).
There's only 1 line with UseSSL in the cfg file.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Emixam
Posts: 139
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: UseSSL

Post by Emixam »

Hello Wim,

It may sounds stupid but in the screenshot it shows log from 2020-09-29. Maybe they changed the UseSSL parameter recently ?
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: UseSSL

Post by Wim Gielis »

Emixam wrote: Tue May 18, 2021 8:38 pm Hello Wim,

It may sounds stupid but in the screenshot it shows log from 2020-09-29. Maybe they changed the UseSSL parameter recently ?
That doesn't sound stupid at all ! You were right, thanks !
01.png
01.png (153.79 KiB) Viewed 20012 times
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
ardi
Community Contributor
Posts: 152
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: UseSSL

Post by ardi »

jim wood wrote: Tue May 18, 2021 2:12 pm We have recently enabled SSL and the rest api code we've been using for a while no longer works, so there's some weird stuff happening and we are still looking at it.
I am also having the same issue. Were you able to figure out how to resolve this?
Ardian Alikaj
Post Reply