Error source URL - SSL


#1

Hello, I want to run a query from a URL.
I have installed Redmine accessible only from https, and run the query in re: dash me returns the following error
Error running query: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c: 590)>


#2

You can check the log (/opt/redash/logs/celery_error.log) for more information. But I doubt the problem has to do with SSL.

Does the URL you call returns results in the format Redash expects?


#3

I could solve the problem of SSL, simply access http enabling the port etc.
I guess the outcome of the url is correct, attached result

{“issue”:{“id”:12297,“project”:{“id”:51,“name”:“Tareas - Matias”},“tracker”:{“id”:14,“name”:“Notas”},“status”:{“id”:1,“name”:“Nueva”},“priority”:{“id”:2,“name”:“Normal”},“author”:{“id”:5,“name”:“Matias Fusaro”},“assigned_to”:{“id”:5,“name”:“Matias Fusaro”},“subject”:“subjet Test Json”,“description”:"\u003cp\u003eDescripcion here\u003c/p\u003e\r\n",“start_date”:“2016-10-20”,“done_ratio”:0,“spent_hours”:0.0,“total_spent_hours”:0.0,“created_on”:“2016-10-20T11:23:57Z”,“updated_on”:“2016-10-20T11:23:57Z”}}

but re: dash returns me an empty table.


#4

No, it’s not. Did you check the link I posted in the previous message?


#5

I just finished comparing and I realize that the syntax is not the same.
Thanks for the help


#6

help for the syntax for the query for url as data source