Sapiens.BI PRO - Analytic Reporting

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 6 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

jason
6 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

reply
- pratapkunal
  6 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.
  
  reply
- jason
  6 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.
  reply
- pratapkunal
  6 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
  
  reply
pratapkunal
6 years ago

reply
- jason
  6 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.
  
  reply
- pratapkunal
  6 years ago
  
  is there a way to validate Key from command line ?
  
  reply
pratapkunal
6 years ago

reply
- pratapkunal
  6 years ago
  
  Curl also seems to be enabled on the server.
  
  reply
- jason
  6 years ago
  
  cURL is different from php_curl. That is going to be the issue. Once php_curl is enabled you will be able to validate. This page will have some different ways to enable it: https://stackoverflow.com/questions/1347146/how-to-enable-curl-in-php-xampp
  
  reply
pratapkunal
6 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

reply
- sapiens.bi
  6 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
  
  reply