by sapiens.bi

Sapiens.BI helps you produce effective reports with charts in a fast and easy way. It is a SugarCRM BI plug-in with powerful reporting capabilities, ease of use, elegant design, and a quick and easy setup. This Reporting Tool is easy to use, there is no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3371 - Unable to validate license

Closed Installation created by pratapkunal 5 years ago

hi Team i am unable to validate installation license and receiving following message : SugarOutfitters_API::call(): Unable to validate the license key. Please configure the firewall to allow requests to https://www.sugaroutfitters.com/api/v1/key/validate and make sure that SSL certs are up to date on the server. I have checked with our IT team and it seems to be able to reach www.sugaroutfitters.com via cmd line curl command [root@plolb-dsugar1 uk]# curl https://www.sugaroutfitters.com/api/v1/key/validate "Key is required."[root@plolb-dsugar1 uk]#

but unable to validate from Sugar UI. we have a on-premise installation. Any help would be great.

thanks, Kunal

  1. jason member avatar

    jason

    5 years ago

    Hello Kunal,

    Please also make sure that php_curl is enabled in the server's php.ini and that config_override.php in the root Sugar directory is writeable. The php_curl not being enabled is typically the cause of this error.

    Let me know if that works.

    Thanks, Jason Eggers SugarOutfitters

    • pratapkunal member avatar

      pratapkunal

      5 years ago

      BAsed on my conversation team it seems yes it is enable. Is there a quick way i can check this ? i have access to root command line on the webserver.

    • jason member avatar

      jason

      5 years ago

      There is a chance that the command line uses a different php.ini so I recommend creating a php such as phpinfo.php in your web directory with the contents:

      <?php phpinfo(); ?>
      

      Then open the page from your browser. You should see php_info enabled on that page.

    • pratapkunal member avatar

      pratapkunal

      5 years ago

      yup I am already able to see the info.php via the web URL after creating this file. So doesn that meam curl is enabled. Also based on my conversation with my It team , sugar has full access to right into the files so i am not sure what is going wrong here.

      Thanks, Kunal

  2. pratapkunal member avatar

    pratapkunal

    5 years ago

    phpinfo.JPG

    • jason member avatar

      jason

      5 years ago

      There should be a separate line for php_curl somewhere on that page with the gray side saying enabled. If that is the case then there is something preventing the server from connecting to the license API.

    • pratapkunal member avatar

      pratapkunal

      5 years ago

      is there a way to validate Key from command line ?

  3. pratapkunal member avatar

    pratapkunal

    5 years ago

    Curl_PHP.JPG

  4. pratapkunal member avatar

    pratapkunal

    5 years ago

    this is still not working for us. we have double checked with our IT team and curl seems to be enabled. from bash the servers are able to reach the servers but getting output below :

    [root@plolb-dsugar1 certs]# curl -v https://www.sugaroutfitters.com/api/v1/key/validate * About to connect() to proxy 192.168.2.211 port 80 (#0) * Trying 192.168.2.211... * Connected to 192.168.2.211 (192.168.2.211) port 80 (#0) * Establish HTTP proxy tunnel to www.sugaroutfitters.com:443

    CONNECT www.sugaroutfitters.com:443 HTTP/1.1 Host: www.sugaroutfitters.com:443 User-Agent: curl/7.29.0 Proxy-Connection: Keep-Alive

    < HTTP/1.1 200 Connection Established < Proxy-Agent: Fortinet-Proxy/1.0 < * Proxy replied OK to CONNECT request * Initializing NSS with certpath: sql:/etc/pki/nssdb * CAfile: /etc/pki/tls/certs/ca-bundle.crt CApath: none * SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 * Server certificate: * subject: CN=www.sugaroutfitters.com,O="SugarOutfitters (CRMOutfitters, LLC)",L=Minneapolis,ST=Minnesota,C=US,postalCode=55448,STREET=66 104th Lane NW,serialNumber=484985600022,incorporationState=Minnesota,incorporationCountry=US,businessCategory=Private Organization * start date: sie 24 00:00:00 2015 GMT * expire date: lis 21 12:00:00 2017 GMT * common name: www.sugaroutfitters.com * issuer: CN=DigiCert SHA2 Extended Validation Server CA,OU=www.digicert.com,O=DigiCert Inc,C=US GET /api/v1/key/validate HTTP/1.1 User-Agent: curl/7.29.0 Host: www.sugaroutfitters.com Accept: /

    < HTTP/1.1 400 Bad Request < Date: Mon, 23 Oct 2017 12:14:17 GMT < Server: Apache/2.4.7 (Ubuntu) < X-Powered-By: PHP/5.5.9-1ubuntu4.9 < Content-Length: 18 < Connection: close < Content-Type: application/json < * Closing connection 0

    • sapiens-bi member avatar

      sapiens.bi Provider

      5 years ago

      Hello, it looks like it is working Ok now for you? Or are you still having the issues with license?

      Best Regards, IT Sapiens Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "We have been using it for about a month and it is by far the best available reporting tool for SugarCRM. It is worth spending the time to learn how to use it. "

    Read More Reviews