Import Test Cases from Excel in Remote server

thumbnail
Angel Guillermo Hidalgo, modified 10 Years ago.

Import Test Cases from Excel in Remote server

Padawan Posts: 62 Join Date: 12/20/13 Recent Posts
Hi

I need to export TC from excel to Klaros.

My excel file is nemed: <2014-02-25_Generating_of_Theft_Alert_by_Hotwire_in_the_Platinum_Devices_In_Normal_Operational_Mode.xls>
I am in Ecuador.
The server is in Israel.
I can access to the project normally.

I wrote this command:


D:\Validación\Klaros\TC_AndrésMorillo>curl -v -T 2014-02-25_Generating_of_Theft_Alert_by_Hotwire_in_the_Platinum_Devices_In_Normal_Operational_Mode.xls "https://www.roadtracktelematics.com/klaros-web/seam/resource/rest/import/testcase/xls?config=P00009&username=****&password=****"

The username and password is hidden.

The results were


* Adding handle: conn: 0x9a3910
* Adding handle: send: 0
* Adding handle: recv: 0
* Curl_addHandleToPipeline: length: 1
* - Conn 0 (0x9a3910) send_pipe: 1, recv_pipe: 0
* About to connect() to www.roadtracktelematics.com port 443 (#0)
* Trying 82.166.147.91...
* Connected to www.roadtracktelematics.com (82.166.147.91) port 443 (#0)
* successfully set certificate verify locations:
* CAfile: C:\Program Files\cURL\bin\curl-ca-bundle.crt
CApath: none
* SSLv3, TLS handshake, Client hello (1):
* SSLv3, TLS handshake, Server hello (2):
* SSLv3, TLS handshake, CERT (11):
* SSLv3, TLS alert, Server hello (2):
* SSL certificate problem: unable to get local issuer certificate
* Closing connection 0
curl: (60) SSL certificate problem: unable to get local issuer certificate
More details here: http://curl.haxx.se/docs/sslcerts.html

curl performs SSL certificate verification by default, using a "bundle"
of Certificate Authority (CA) public keys (CA certs). If the default
bundle file isn't adequate, you can specify an alternate file
using the --cacert option.
If this HTTPS server uses a certificate signed by a CA represented in
the bundle, the certificate verification probably failed due to a
problem with the certificate (it might be expired, or the name might
not match the domain name in the URL).
If you'd like to turn off curl's verification of the certificate, use
the -k (or --insecure) option.



The process was fail. Please give me a hint about what was the problem?

Thanks in advance.

Angel Hidalgo
thumbnail
Torsten Stolpmann, modified 10 Years ago.

RE: Import Test Cases from Excel in Remote server

Jedi Council Member Posts: 755 Join Date: 2/12/09 Recent Posts
Hi Angel,

Your SSL server (https://www.roadtracktelematics.com) is using a self-signed certificate which is causing the message. Please use the option mentioned in your error message above to avoid this:

-k, --insecure (SSL) This option explicitly allows curl to perform "insecure" SSL connections and transfers. All SSL connections are attempted to be made secure by using the CA certificate bundle installed by default. This makes all connections considered "insecure" fail unless -k, --insecure is used.


Regards,

Torsten