These are chat archives for getredash/redash

16th
Nov 2016
Andre Greeff
@ZaLiTHkA
Nov 16 2016 06:59
Greetings... I'm having some trouble running queries against a MSSQL server (Re:dash running in a Bitnami VM, MSSQL server running on my network with an instance name of MSSQLSERVER1). The database schema doesn't show when I create a new query and select the data source, but I don't see any errors coming up in the UI, while deliberately entering the incorrect data source details does throws an expected error; the same data connection settings work correctly when run through DBeaver on my local machine. Could somebody please help me work out what's gone wrong?
Andre Greeff
@ZaLiTHkA
Nov 16 2016 07:07
Hmm.. It seems after restarting my VM, I am now getting an error. The UI is telling me "General SQL Server error: Check messages from the SQL server" and my browser console shows HTTP status 500 for the GET request to https://x.x.x.x/api/data_sources/1/schema, so let me first go check server logs and see if there's anything helpful there. In the meantime though, could anyone provide some clarity on the requirements for connecting to named MSSQL Server instances? Is it the typical idea of using SERVER_NAME\INSTANCE_NAME for the "host", or am I missing something?
Lol. And I did it again: Asked for help and then got it working. :) I had a silly syntax error in my SQL query, the "Format Query" button helped me find it.
Hamish Dickson
@hamishdickson
Nov 16 2016 10:04
@arikfr great news - thanks
Bruno
@bbay
Nov 16 2016 12:56
Hello everyone :) I’m trying to install redash in my dev env via Vagrant to give it a try and play around with it. I never used this vagrant thing and I’m stuck with this.
I downloaded vagrant, I cloned redash repo, and im executing the script and I’m getting this message:
The box 'redash/dev' could not be found or could not be accessed in the remote catalog
Allen Short
@washort
Nov 16 2016 14:01
@arikfr I'm looking at the views in admin.py and I'm wondering if column_exclude_list should be form_excluded_columns instead. (I can't find the former mentioned in flask-admin.)
Allen Short
@washort
Nov 16 2016 14:08
-- oh, I see they're a little different.
Allen Short
@washort
Nov 16 2016 14:47
@arikfr Working on fulltext search for queries. https://github.com/washort/redash/tree/query-search
Got indexing started, going to do the query part next
Allen Short
@washort
Nov 16 2016 15:40
@arikfr oh hey that was easy. getredash/redash#1400
Hamish Dickson
@hamishdickson
Nov 16 2016 15:45
hey again - I’ve set up redash, but I’m having trouble running ES queries - the specific error I’m getting is Error running query: No connection adapters were found for ‘172.blah.blah/index-20/_mapping’
anyone know what that actually means?
Hamish Dickson
@hamishdickson
Nov 16 2016 16:33
in case anyone else ever has this issue it means “you should have added ‘http://' to the front of your url"
Hamish Dickson
@hamishdickson
Nov 16 2016 17:55
OK .. next question: how do I set the set the search_type field in an elasticsearch redash?
so I can do the equivalent of:
GET blah/_search?search_type=count

{
  // my query here
}
my best guess is to try this:
{
    "index": "some-index",
    "search_type": "count",
    "aggs": {
        // blah
    }
}
but that just returned an error