Skip navigation
Share This:

Hello,

 

I am writing this to help every fellow remedy admin who wants to add a certificate (SSL) to his tomcat midtier or smart it server. I could not find a simple procedure step anywhere so I will post my finding here whishing that it will help somebody.

 

I just want to thank Jean Christophe with his blog. It’s from this article that I was able to figure out how this is working.

 

So here we go, the process is simple when you know what to do.

 

Steps

Screenshots

In the tomcat install folder there is a folder named ‘conf’.

In this folder, you need to copy the certificate pfx file

Edit the file server.xml and add the following information:

    <Connector port="80" protocol="HTTP/1.1"

connectionTimeout="20000"

               redirectPort="443" />

 

<Connector port="443" protocol="org.apache.coyote.http11.Http11NioProtocol" SSLEnabled="true"            

                   maxThreads="2000" scheme="https" secure="true"

                   maxHttpHeaderSize="32768"

                   clientAuth="none"

                   sslEnabledProtocols="TLSv1.1, TLSv1.2, TLSv1.3"

                   ciphers="HIGH:!aNULL:!RC4:!MD5:@STRENGTH"

     keystoreFile="conf/%pfx filename%"

keystorePass="%pfx file password%"

                    keystoreType="PKCS12"

      />

This should enable https to work on the tomcat.

Now to always redirect http to https you need to add the following parameter to the web.xml file in the same folder

 

<!-- Force HTTPS, required for HTTP redirect! -->

   <security-constraint>

   <web-resource-collection>

<web-resource-name>Protected Context</web-resource-name>

<url-pattern>/*</url-pattern>

</web-resource-collection>

    

   <!-- auth-constraint goes here if you require authentication -->

   <user-data-constraint>

<transport-guarantee>CONFIDENTIAL</transport-guarantee>

   </user-data-constraint>

</security-constraint>

This will make every http call to the server redirected to https.

 

If you have any suggestion as to how I could improve this article don’t hesitate.

Share This:

We wanted to use Binary_AI indexes with our Remedy 9.1.05 installation because we are a french organisation, but could not find a way to do it.

 

So i oppened a case and here what came out of it. I'm posting this because we could not find any useful informaton at the time and maybe someone will find it useful.

 

You need to configure the following parameter for the ARS server to use different indexes than the tradicionnal Binary_CI.

 

Go to the administration console, in server information, on the Database tab and add the Following information in the configuration file section

 

DB-Options: Oracle {

name:NLS_SORT

value:BINARY_AI

}

2018-07-09 11_41_36-Microsoft Edge.png

After that, go to your ar.cfg file and make sure the following 2 line are included :

Db-Case-Insensitive: T

Db-Functional-Index: T

 

Restart your Remedy Ars services

2018-07-09 11_48_22-9. Refaire les indexes Binary_AI - OneNote.png

 

The server should now be using the Binary_AI indexes

 

Note : be sure that your dba team have rebuilded the indexes acordingly

Note 2 : Sorry for the spealling, english is not my primary language. If you guys note some mistakes or need some precisions, just advise an i will correct.

Filter Blog

By date:
By tag: