These are chat archives for getredash/redash

10th
Mar 2016
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:36
hi i have just started with re:dash couple of days back..
can anyone help me with installation trial version
Arik Fraimovich
@arikfr
Mar 10 2016 06:39
@ashishsaxena14 trial version?
@ashishsaxena14 Re:dash is open source. You either install it on your server (free) or use the hosted version. But there is no trial (or need for it).
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:42
k..
so what should i go with server or hosted one?
i m new to it i worked with tableau before
Arik Fraimovich
@arikfr
Mar 10 2016 06:45
depends on your needs and resources. they're practically the same in terms of features, but the hosted comes with support, you don't need to manage it and it's faster to start (no setup, just create an account and connect your database). of course the hosted version isn't free (but there is a 30 days trial).
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:47
k i m in learning phase so i think i should go with server one
Arik Fraimovich
@arikfr
Mar 10 2016 06:48
I'm curious, why not use the hosted version for learning?
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:52
k then i 'll go with hosted one
Invalid input: letters, numbers and dashes only. getting this error why i m using my own name instead of company ,because i m learning on my own..
Arik Fraimovich
@arikfr
Mar 10 2016 06:55
@ashishsaxena14 what did you input there?
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:56
what i was asked name,email,password,name or company's name...and organization web address..
Arik Fraimovich
@arikfr
Mar 10 2016 06:56
@ashishsaxena14 I mean what did you type in the org web address?
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:57
nothing..
i don't have any personal website or webpage..
Maital Ashkenazi
@maital
Mar 10 2016 06:57
Good morning @arikfr :smile: I installed redash on gce . My redash server is running. How do I login to it?
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:57
i left it blank..
Arik Fraimovich
@arikfr
Mar 10 2016 06:58
@ashishsaxena14 it's not your website, it's the address for your redash account (it will be "app.redash.io/<whatever you type in there>"). just use ashishsaxena14.
Ashish Saxena
@ashishsaxena14
Mar 10 2016 06:58
k let me try..
Arik Fraimovich
@arikfr
Mar 10 2016 06:59
@maital good to see you here :) use the IP address of your server, and then the user admin with the password admin. make sure to change the password...
Ashish Saxena
@ashishsaxena14
Mar 10 2016 07:01
@arikfr ya i m on new page thanks..
Arik Fraimovich
@arikfr
Mar 10 2016 07:01
@ashishsaxena14 :+1:
Maital Ashkenazi
@maital
Mar 10 2016 07:02
unfortunatly that does not seem to work :worried: http://146.148.58.227/
root@real-bi:/opt/redash/current# ps -ef | grep redash
redash    1290     1  0 Mar09 ?        00:00:12 /usr/bin/python /usr/local/bin/supervisord --configuration /opt/redash/supervisord/supervisord.conf
redash    1499  1290  0 Mar09 ?        00:01:18 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker --beat -c2 -Qqueries,celery
redash    1504  1290  0 Mar09 ?        00:01:16 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker -c2 -Qscheduled_queries
redash    1605  1504  0 Mar09 ?        00:00:00 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker -c2 -Qscheduled_queries
redash    1606  1504  0 Mar09 ?        00:00:00 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker -c2 -Qscheduled_queries
redash    1607  1499  0 Mar09 ?        00:00:04 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker --beat -c2 -Qqueries,celery
redash    1608  1499  0 Mar09 ?        00:00:02 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker --beat -c2 -Qqueries,celery
redash    1609  1499  0 Mar09 ?        00:00:03 /usr/bin/python /usr/local/bin/celery worker --app=redash.worker --beat -c2 -Qqueries,celery
redash    6716  1290  0 06:52 ?        00:00:00 /usr/bin/python /usr/local/bin/gunicorn -b 127.0.0.1:5000 --name redash -w 4 redash.wsgi:app
redash    6724  6716  2 06:52 ?        00:00:00 /usr/bin/python /usr/local/bin/gunicorn -b 127.0.0.1:5000 --name redash -w 4 redash.wsgi:app
redash    6727  6716  2 06:52 ?        00:00:00 /usr/bin/python /usr/local/bin/gunicorn -b 127.0.0.1:5000 --name redash -w 4 redash.wsgi:app
redash    6728  6716  2 06:52 ?        00:00:00 /usr/bin/python /usr/local/bin/gunicorn -b 127.0.0.1:5000 --name redash -w 4 redash.wsgi:app
redash    6729  6716  2 06:52 ?        00:00:00 /usr/bin/python /usr/local/bin/gunicorn -b 127.0.0.1:5000 --name redash -w 4 redash.wsgi:app
Is there a process that should run? or a specific port?
Arik Fraimovich
@arikfr
Mar 10 2016 07:08
@maital did you tag this server as http-server to make sure the ports are open?
Maital Ashkenazi
@maital
Mar 10 2016 07:08
no
Maital Ashkenazi
@maital
Mar 10 2016 07:14
works now, thanks! :thumbsup:
Arik Fraimovich
@arikfr
Mar 10 2016 07:18
super :+1:
Ashish Saxena
@ashishsaxena14
Mar 10 2016 09:19
hi can anyone help in connecting mongoDB in redash
i followed the steps but,what we have to write in connecting string and replica set name
Arik Fraimovich
@arikfr
Mar 10 2016 09:27
connection string = the connection settings of your mongo cluster in url format
Neil Shah
@shahneil88
Mar 10 2016 09:43
@arikfr - Do we have an option to reposition legend in visualization ?
Arik Fraimovich
@arikfr
Mar 10 2016 09:43
@shahneil88 unfortunately not. you can only disable it. it's plotly's limitation... :(
Neil Shah
@shahneil88
Mar 10 2016 09:44
Thought so. I was looking on plotly's website and couldn't find it
Ashish Saxena
@ashishsaxena14
Mar 10 2016 09:49
k and what about replica set
Arik Fraimovich
@arikfr
Mar 10 2016 09:49
if you don't know what it is, you can probably leave it empty
Ashish Saxena
@ashishsaxena14
Mar 10 2016 09:50
k i have mongodb in cloud
in connecting string i have to write the port name also
Arik Fraimovich
@arikfr
Mar 10 2016 09:53
yes
something like:
mongodb://user:password@domain_or_ip:59702/db_name
Ashish Saxena
@ashishsaxena14
Mar 10 2016 09:57
done and it is saved now what i have to do ...next step..
Arik Fraimovich
@arikfr
Mar 10 2016 09:57
create a query?
Ashish Saxena
@ashishsaxena14
Mar 10 2016 09:57
k..
see this for examples
Ashish Saxena
@ashishsaxena14
Mar 10 2016 09:59
i want to new query section
it is not supporting normal sql query
and how after writing query it will help me in visualization of data
Arik Fraimovich
@arikfr
Mar 10 2016 10:03
Re:dash let's you query your database with its own query language. MongoDB doesn't support SQL queries, so neither is Re:dash. If you use a database that supports SQL queries (Postgres for example) then you can use SQL queries.
Ashish Saxena
@ashishsaxena14
Mar 10 2016 10:04
k..
where i can find Re:dash query language examples..?
Arik Fraimovich
@arikfr
Mar 10 2016 10:05
Re:dash does not have a query language of its own. We use the language of the database.
Ashish Saxena
@ashishsaxena14
Mar 10 2016 10:06
then how i can write the query i have connect it to mongo db
what should i do now
Arik Fraimovich
@arikfr
Mar 10 2016 10:06
see the doc page I linked above
Ashish Saxena
@ashishsaxena14
Mar 10 2016 10:06
k..
ok after running the query and getting the desired data how we r going to visualize that..?
Ashish Saxena
@ashishsaxena14
Mar 10 2016 10:16
what next..?
Arik Fraimovich
@arikfr
Mar 10 2016 11:25
next? you can create a visualization, add it to a dashboard and share
Inkitt
@inkitt
Mar 10 2016 18:12
Hi! Is it possible to have variables in my queries? I'd like to have variable dates for example
Maybe a date picker?
Arik Fraimovich
@arikfr
Mar 10 2016 18:24
@AliAlbazaz here's an example for variables: demo.redash.io/queries/146/source?p_action=create currently there is no UI for them, but it's planned and will be.
Inkitt
@inkitt
Mar 10 2016 18:26
cool! will just try it out
@arikfr works! thank you.
we had built something like redash on our own in the last 2 years since we are using the ahoy gem for event tracking
we're now switching to re:dash
thanks for the great work!
Arik Fraimovich
@arikfr
Mar 10 2016 18:30
sure! happy that you find it useful
@AliAlbazaz btw, who is we?
Inkitt
@inkitt
Mar 10 2016 18:37
inkitt.com
Arik Fraimovich
@arikfr
Mar 10 2016 18:46
Cool. I recommend signing up to our newsletter, to be updated when new stuff get released: redash.io/newsletter.html
Inkitt
@inkitt
Mar 10 2016 18:49
thanks! done :)
I have a query that I want to plot. But the chart is changing my date format... any idea how I can keep my date format?
Arik Fraimovich
@arikfr
Mar 10 2016 18:52
not sure I follow. mind sharing a screenshot?
Inkitt
@inkitt
Mar 10 2016 18:52
blob
SELECT to_char(started_at, 'YYYY-MM-DD') thats my x-axis
Arik Fraimovich
@arikfr
Mar 10 2016 19:01
Looks like this is the logic Plot.ly applies. If you have more days it updates the scale to show dates, but still in its own format.
Maybe there is control over this, need to check.
Inkitt
@inkitt
Mar 10 2016 19:02
ok I see. I can get used to it. just a minor thing
Arik Fraimovich
@arikfr
Mar 10 2016 19:11
:+1:
Inkitt
@inkitt
Mar 10 2016 19:57
@arikfr I'm trying to connect with google spreadsheet. I added google+ signin and it's working. also created a service account and got the JSON.
but what do I do with the JSON now?
Arik Fraimovich
@arikfr
Mar 10 2016 19:59
@AliAlbazaz when you create a new data source of type google spreadsheets, it will askk for this JSON
Inkitt
@inkitt
Mar 10 2016 20:25
blob
@arikfr but google spreadsheet isn't available there
did I miss something?
Arik Fraimovich
@arikfr
Mar 10 2016 20:28
how did you setup redash?
Inkitt
@inkitt
Mar 10 2016 20:30
what do you mean?
Arik Fraimovich
@arikfr
Mar 10 2016 20:30
how did you install it?
Inkitt
@inkitt
Mar 10 2016 20:30
someone else did. he isn't here unfortunately right now
Arik Fraimovich
@arikfr
Mar 10 2016 20:31
I think you need to install some dependencies the spreadsheets query runner requires
Inkitt
@inkitt
Mar 10 2016 20:31
what do you need to know?
Arik Fraimovich
@arikfr
Mar 10 2016 20:31
this is why it might not be available
Inkitt
@inkitt
Mar 10 2016 20:31
pip install gspread etc.?
I did that
Arik Fraimovich
@arikfr
Mar 10 2016 20:31
yes, gspread, google-api-python-client, oauth2client and pyOpenSSL
and then restart everything
Inkitt
@inkitt
Mar 10 2016 20:32
ah. I only install gspread and oauth2client
Arik Fraimovich
@arikfr
Mar 10 2016 20:32
another option is maybe you overriden the setting that defines available query runners
Inkitt
@inkitt
Mar 10 2016 20:32
the other 2 weren't mentioned in the docs
Arik Fraimovich
@arikfr
Mar 10 2016 20:32
hmm.. maybe they are dependencies of the first two
(and will be installed by pip automatically)
see if you have in your env variables / .env file something with QUERY_RUNNER in its name
Inkitt
@inkitt
Mar 10 2016 20:36
installed the both other pip packages. still no google spreadsheet in the dropdown.
Arik Fraimovich
@arikfr
Mar 10 2016 20:36
did you restart after installing?
Inkitt
@inkitt
Mar 10 2016 20:36
have nothing like QUERY_RUNNER in .env
yes restarted
Arik Fraimovich
@arikfr
Mar 10 2016 20:37
what version are you using? (you can see in /admin/status or in the folder name that is linked to /opt/redash/current)
Inkitt
@inkitt
Mar 10 2016 20:38
0.9.1+b1377
do I need to add "QUERY_RUNNER" in .env?
Arik Fraimovich
@arikfr
Mar 10 2016 20:39
no
google spreadsheets is in the default list
Inkitt
@inkitt
Mar 10 2016 20:41
ok
Arik Fraimovich
@arikfr
Mar 10 2016 20:41
strange, the only way for it to be disabled is either dependencies missing or change of configuration. but none of those are happening in your case :\
Inkitt
@inkitt
Mar 10 2016 20:44
I'm not sure if this is the issue (have no idea about python): I'm installing the pip packaged with sudo. could it be that the user doesn't have access to the packages?
Arik Fraimovich
@arikfr
Mar 10 2016 20:44
If you used the AMIs we provide (or the bootstrap script) than all the packages are installed w/ sudo, so it's ok.
Inkitt
@inkitt
Mar 10 2016 20:45
ok
hmm... then I'll search if it's possible to convert google spreadsheet to json
or would you rather recommend downgrading to a stable version?
Arik Fraimovich
@arikfr
Mar 10 2016 20:49
the version you have is stable enough
I think it's just some configuration issue, I just fail to imagine which one.
Inkitt
@inkitt
Mar 10 2016 20:50
all config is in .env, right?
Arik Fraimovich
@arikfr
Mar 10 2016 20:50
yes
/opt/redash/.env (which is symlinked to /opt/readsh/current/.env)
Inkitt
@inkitt
Mar 10 2016 20:52
export REDASH_STATIC_ASSETS_PATH
export REDASH_LOG_LEVEL
export REDASH_REDIS_URL
export REDASH_DATABASE_URL
export REDASH_COOKIE_SECRET
export REDASH_GOOGLE_APPS_DOMAIN
export REDASH_GOOGLE_CLIENT_ID
export REDASH_GOOGLE_CLIENT_SECRET
Arik Fraimovich
@arikfr
Mar 10 2016 20:53
looks legit
Inkitt
@inkitt
Mar 10 2016 20:53
these are the keys that I have set
(removed the values)
Arik Fraimovich
@arikfr
Mar 10 2016 20:53
can you share /opt/redash/current/settings.py with me?
Inkitt
@inkitt
Mar 10 2016 20:54
file doesn't exist :/
Arik Fraimovich
@arikfr
Mar 10 2016 20:54
oops
/opt/redash/current/redash/settings.py
Arik Fraimovich
@arikfr
Mar 10 2016 20:59
all good here. how did you restart after installing the packages?
Inkitt
@inkitt
Mar 10 2016 21:00
sudo supervisorctl restart redash_server
Arik Fraimovich
@arikfr
Mar 10 2016 21:00
that's correct too
although you need to restart the workers aas well, so it will be supervisorctl restart all, but restarting the server is enough to see the full list
this is the part where it decided if it's enabled or not (if it's in the list)
maybe add some print statements there to verify what happens (and that this file is being actually loaded)
restart the server and check logs (/opt/redash/logs/api_error.log)
Inkitt
@inkitt
Mar 10 2016 21:04
ok
Inkitt
@inkitt
Mar 10 2016 21:26
I have problems now running the server because of some permissions. Will let you know tomorrow what worked.
Thanks a lot though for your help! Really appreciate it