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



Wednesday, August 2, 2017

Set Up Dropbox - Blank Black Login Screen - FIX

Issue: Dropbox auto updates and it now asks you to sign in , the only issue is that the login screen is totally blank or black


Cause: This appears to be a display issue but first of all rule out the following


  • Popup blocker
  • Trusted sites internet explorer
  • Firewall / Anti-virus exceptions
  • Java / Adobe Flash (maybe :S )

Fix: For me the issue was display / graphics issue as I could blindly make my way through the setup prompts and some windows were not black other were

My fix was unusual but involved

  1. Setting resolution to 1024x768
  2. Set dropbox to use 256 bit colors (right click shortcut -> properties -> compatibility tab)
  3. Plug into your machine/server hosting dropbox with a VGA cable mouse & keyboard
When I did this everything came up as normal, I am not totally sure which part of this resolved the issue but it may have just been physically connecting to the machine with a vga cable

Other: another possible option for those running dropbox on a virtual machine would be to connect via the console/kvm or remote desktop into the machine. Even from the machine itself to itself.

Note I did try Microsoft remote desktop with the same issues so it may be worth trying a few different remote desktop clients as it appears to be a purely graphical issue, well for me anyway

Hope this helps someone , I know dropbox support is manned by one sole hamster , poor fella he's got so many emails to get through