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)

USE MASTER
GO
xp_readerrorlog 01N'Server is listening on'
GO

7.  Confirm SQL port by using SQL configuration manager




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

Db.properties or jdbc.properties

#SQL Server settings
db.driver=net.sf.log4jdbc.DriverSpy
db.url=jdbc:log4jdbc:jtds:sqlserver://MachineName-Testy:52289/Sage;language=english;instance=SQL2016
db.username=sa
db.password=&KAHKHDKJASHKD
db.dialect=com.sage.crm.core.data.sqlserver.HibernateDialect
db.connectionCustomizer=com.sage.crm.core.data.sqlserver.ConnectionCustomizer
db.defaultSqlGenerator=com.sage.crm.core.data.sqlserver.SqlGeneratorImp
db.defaultDDLGenerator=com.sage.crm.core.data.sqlserver.MSSqlDDLGenerator
db.connectiontestquery=select @@version


#Hibernate settings
db.hbm2ddl=validate

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

Unique field include-----

Server port="11005" shutdown="SHUTDOWN"
<Service name="Catalina"> , (e.g catalina1 and catalina2)
<Connector port="11009" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8443" />
<Connector executor="tomcatThreadPool"
               port="11009" protocol="HTTP/1.1"
               connectionTimeout="20000"
               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: