Search Computer Help Please

Sunday, August 6, 2017

Installing multiple instances of Sage CRM - Tomcat & Webapps

For development reasons you may require multiple instances of Sage CRM but how duth one proceedeth , like thus

  1. Install the first instance of Sage CRM using the installer
2.   Install the 2nd Instance using the installer specifying a new instance name / directory

3. Confirm configuration file applicationHost.config in C:\Windows\System32\inetsrv\config for both instances ( check application paths and entries for both CRM instances)

4. Navigate to HKLM/SOFTWARE/Wow6432Node/eWare/Config//CRMName 
and check each CRM instance /CRMNAME and confirm details for

DatabaseTcpPort – Must be unique
Default Database, InstallDir , and database login details

5.  Check both CRM instances are listed under HKLM/SOFTWARE/Wow6432Node/eWare/Mappings in registry

6. Confirm DatabaseTcpPort being used by CRM instance is available and SQL is listening (using sql query below)

xp_readerrorlog 01N'Server is listening on'

7.  Confirm SQL port by using SQL configuration manager

8. Check Tomcat Configuration under tomcat\webapps\crminstancename\web-inf or

#SQL Server settings
db.connectiontestquery=select @@version

#Hibernate settings

9.  Confirm each tomcat instance is running on a unique port and this port is not in use by something else

Unique field include-----

Server port="11005" shutdown="SHUTDOWN"
<Service name="Catalina"> , (e.g catalina1 and catalina2)
<Connector port="11009" protocol="HTTP/1.1"
               redirectPort="8443" />
<Connector executor="tomcatThreadPool"
               port="11009" protocol="HTTP/1.1"
               redirectPort="8443" />
Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
               maxThreads="150" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS" />
    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />
<Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">
    <Engine name="Catalina" defaultHost="localhost">

10. Check entries within IIS sdata application – URL Rewrite


11.  Restart IIS and Tomcat for changes to take affect
           Any issues with URL rewrite , the installer can be found CRM\Utils\EN\UrlRewriter

1 comment: