connect to elasticsearch

[michae...@guardian.co.uk]

Hi there,

I was wondering if anyone's had any luck connecting their re:dash instance to their Elasticsearch cluster?

Currently getting "Error running query: 'dict' object has no attribute 'rstrip'" error when trying to query Elasticsearch from re:dash.

This is making me think that re:dash is not connecting to Elasticsearch properly.

The setup:

• re:dash instance set up in AWS following documentation
  
• Elasticsearch endpoint used as base-URL in re:dash data_source setup
  

can someone confirm how the connection between re:dash and Elasticsearch is made? As in:

• what security groups are required
  
• what should be used as the base-URL when setting up the data source in re:dash
  

Thanks in advance for your time,

Mike

[Arik Fraimovich]

Hi,

I went through the code of the ElasticSearch query runner and I don't see the use of rstrip method there, so hard to pin-point where the error comes from.

Can you please check if you see full stacktrace in the logs (/opt/redash/logs/celery_error.log)?

As for your questions:

* You need to allow access to the port ES is using from the re:dash instance.

* The base URL is only the host & port of your ES instance.

---

This e-mail and all attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender and delete the e-mail and all attachments immediately. Do not disclose the contents to another person. You may not use the information for any purpose, or store, or copy, it in any way.  Guardian News & Media Limited is not liable for any computer viruses or other material transmitted with or as part of this e-mail. You should employ virus checking software.

 

Guardian News & Media Limited is a member of Guardian Media Group plc. Registered Office: PO Box 68164, Kings Place, 90 York Way, London, N1P 2AP.  Registered in England Number 908396

--
You received this message because you are subscribed to the Google Groups "re:dash users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redash-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[michae...@guardian.co.uk]

Hi Arik,

Thanks for the speedy reply.

we're all connected here now. It appeared to be a syntactical issue with the query.

Thanks,

Mike

[Arik Fraimovich]

Hi,

Happy to know it works.

I recommend signing up to the newsletter (http://redash.io/#newsletter), to learn about new versions and project news.

Arik.