{"id":8913,"date":"2014-09-26T07:14:48","date_gmt":"2014-09-26T07:14:48","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=8913"},"modified":"2014-09-26T07:14:48","modified_gmt":"2014-09-26T07:14:48","slug":"sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/","title":{"rendered":"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP"},"content":{"rendered":"

Recently we came across a Tomcat issue where Dashboard and Excel Import Export was not working after upgrade from 6.2 to 7.2 on an Amazon Server, every configuration was properly in place but Tomcat logs were showing db connectivity issues. After deep digging on this issue we came to know that Amazon server works on Elastic IP concept.<\/a>
\nGUMU Sage CRM Integrations\u00a0:\u00a0Sage ERP X3<\/a>\u00a0|\u00a0Sage 100<\/a>\u00a0|\u00a0Sage 500<\/a>\u00a0|\u00a0Sage 300<\/a><\/strong>
\nAn\u00a0Elastic IP address\u00a0(EIP) is a static IP address designed for dynamic cloud computing. With an EIP, you can mask the failure of an instance or software by rapidly remapping the address to another instance in your account. Your EIP is associated with your AWS account, not a particular instance, and it remains associated with your account until you choose to explicitly release it.<\/em>
\nOn further investigation we have noticed that Dashboards, etc worked when accessing via localhost, but it was getting failed when elastic IP was used.
\nRoot Cause:<\/strong>
\nThis was because the elastic IP is actually a type of proxy – redirected requests to Tomcat which had to be rerouted to respective server to make it working, where the necessary ports weren’t open; while since these EIP\u2019s are dynamic in nature hence CRM URL Rewriter was not able to resolve different IP addresses to actual hosting server.
\nHow we Resolved:<\/strong>
\nWe amended CRM.Rewriter.rules so that redirected requests would always go to localhost.
\nExample original rule:\u00a0<\/span>
\nRewriteRule ^\/sdata\/crmj\/(.*)$ http:\/\/%{HTTP_HOST}:10009\/crmj\/$1?%{QUERY_STRING} [P]
\nAmended rule:\u00a0<\/span>
\nRewriteRule ^\/sdata\/crmj\/(.*)$ http:\/\/localhost:10009\/crmj\/$1?%{QUERY_STRING} [P]
\nSince we have hardcoded it to localhost now it does\u2019t matter Tomcat is getting which EIP, it\u2019s URL Rewriter always takes care of it and resolves it to hosting server.
\nNote* Above mentioned technique might have some implications which however we have not observed till date but to make it working on Amazon EC2 this tweaking worked fine for us. We will update you on our blogs in case we face any anomaly due to this.
\nAlso Read:<\/strong><\/em><\/span>
\n1) Apache Tomcat Java configuration issues<\/a>
\n2) Error exporting reports to excel in CRM part 2<\/a>
\n3) Mailing reports after converting from Crystal Reports to PDF format<\/a>
\n4) File to PDF conversion using FOP<\/a>
\n5) Export To PDF functionality for Quotes in Sage CRM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Recently we came across a Tomcat issue where Dashboard and Excel Import Export was not working after upgrade from 6.2 to 7.2 on an Amazon Server, every configuration was properly in place but Tomcat logs were showing db connectivity issues. After deep digging on this issue we came to know that Amazon server works on\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,332,337,405],"tags":[],"class_list":["post-8913","post","type-post","status-publish","format-standard","hentry","category-crm72","category-sage-crm","category-sage-crm-7-2","category-tomcat-server"],"yoast_head":"\nSage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Recently we came across a Tomcat issue where Dashboard and Excel Import Export was not working after upgrade from 6.2 to 7.2 on an Amazon Server, every configuration was properly in place but Tomcat logs were showing db connectivity issues. After deep digging on this issue we came to know that Amazon server works on\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-26T07:14:48+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/\",\"name\":\"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2014-09-26T07:14:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/","og_locale":"en_US","og_type":"article","og_title":"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Recently we came across a Tomcat issue where Dashboard and Excel Import Export was not working after upgrade from 6.2 to 7.2 on an Amazon Server, every configuration was properly in place but Tomcat logs were showing db connectivity issues. After deep digging on this issue we came to know that Amazon server works on\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-09-26T07:14:48+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/","name":"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2014-09-26T07:14:48+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/09\/26\/sage-crm-7-2-tomcat-setting-for-ec2-amazon-servers-elastic-ip\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Sage CRM 7.2 Tomcat Setting for EC2 Amazon Server\u2019s Elastic IP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=8913"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8913\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=8913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=8913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=8913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}