These are chat archives for getredash/redash

11th
Mar 2016
Arik Fraimovich
@arikfr
Mar 11 2016 06:08
@AliAlbazaz ok, don't hesitate to reach out again if it's still doesn't work.
Neil Shah
@shahneil88
Mar 11 2016 06:10
@arikfr - Do we have an option to change mode for bar graph? By default it is stacked. I want it to be grouped
Arik Fraimovich
@arikfr
Mar 11 2016 06:11
@shahneil88 next to the "chart type" there is "stacking" try changing it.
Neil Shah
@shahneil88
Mar 11 2016 06:11
I did try that. But instead of grouping it, it seems it overlaps the existing graph
Arik Fraimovich
@arikfr
Mar 11 2016 06:12
I'm not sure what you mean. Can you add a screenshot?
Neil Shah
@shahneil88
Mar 11 2016 06:16
Sure
stack_enabled.png
stack_disabled.png
First chart is stack "enabled"
Second chart is stack "disabled"
Arik Fraimovich
@arikfr
Mar 11 2016 06:19
blob
This was disabled.
blob
this is enabled.
I think you see somehting different because you have two Y axis used.
Neil Shah
@shahneil88
Mar 11 2016 06:21
Ok. Let me try and see what I can do.
Thanks for looking into it
Arik Fraimovich
@arikfr
Mar 11 2016 06:27
:+1:
Neil Shah
@shahneil88
Mar 11 2016 10:42
@arikfr I am trying to connect to MySQL. I provided DBname, host,password,username. I did not provide SSL details
But it is not able to connect to Mysql
How can i debug this?
Arik Fraimovich
@arikfr
Mar 11 2016 10:48
What kind of error do you get?
Neil Shah
@shahneil88
Mar 11 2016 10:49
I do not get any error. I created a new data source. Then scrolled to New queries and selected that DB
But, I do not see list of schema/tables, that we usually see on the right hand side of screen
I wrote a query and tried executing it. But it just keeps running, without any error
Arik Fraimovich
@arikfr
Mar 11 2016 10:56
It might be waiting for a timeout, which indicates a connectivity issue. Did you allow access in your firewall to your database from your redash instance?
Neil Shah
@shahneil88
Mar 11 2016 10:58
I did not specify that separately. I am actually able to connect to Mysql from a separate server which is in same subnet as redash.
Security groups in Mysql is at subnet level
This is what I received. Error running query: Can't connect to MySQL server on 'mysqlhost' (110)
wheremysqlhost is the hostname of Mysql server
Arik Fraimovich
@arikfr
Mar 11 2016 11:01
And are you sure the dns on redash setup to resolve it properly.
?
Neil Shah
@shahneil88
Mar 11 2016 11:02
Yes. But, i will still confirm it with the person who set it up
I do not need to update anything on redash server, right? I am using redash AMI
Arik Fraimovich
@arikfr
Mar 11 2016 11:07
Update for what? Just for mysql support? No.
Neil Shah
@shahneil88
Mar 11 2016 11:08
ok
Neil Shah
@shahneil88
Mar 11 2016 11:13
I did telnet to mysql from redash
Connected to mysqlhost
So, i guess security group should be ok
Ok. I was able to connect to mysql from redash. Issue was that "password" in mysql connection parameters was not getting saved. I saved it 2-3 times and it worked.
Arik Fraimovich
@arikfr
Mar 11 2016 11:18
That's strange. What version of redash do you have?
Neil Shah
@shahneil88
Mar 11 2016 11:18
Not sure if it is the UI, but i faced this issue while
1) Creating new data source
2) Creating new user
Message either says "error" in saving, but it actually saves the data. OR message says saved, but it does not save the data.
re:dash 0.9.1+b1377
It also happened when I was updating password for admin user. It continuously said "error in saving". But when i logged out and logged in again, I was able to login using my new password
Arik Fraimovich
@arikfr
Mar 11 2016 11:21
I fixed a similar issue in 0.9.2 but not sure that what you were experiencing.
Can you query your mysql now.
?
Neil Shah
@shahneil88
Mar 11 2016 11:21
yes
Ok. I will try and update to 0.9.2
Arik Fraimovich
@arikfr
Mar 11 2016 11:51
If you still have issues with saving users after upgrade, please let me know.
Rahul Ghose
@rghose
Mar 11 2016 12:19
@arikfr So I am getting some query errors in celery, is there any way to track which query was responsible for them?
Pablo
@IceS2
Mar 11 2016 14:08
Hello. I'm having trouble using OAuth. Can somebody help me?
I'm getting the 'Your Google Apps domain name isn't allowed.' error
while trying to log in with google+
Denis Stepanov
@denstepa
Mar 11 2016 14:45
Hi! I'm Denis from Inkitt. I'm trying to find out if its possible to combine data sources somehow ?
Neil Shah
@shahneil88
Mar 11 2016 14:52
@arikfr - I am trying to setup dev environment on my machine. I have installed vagrant and followed all the steps mentioned in http://docs.redash.io/en/latest/dev/vagrant.html .
When on step 8, apply migrations ,I get quite a lot of error/warnings, which I have added in attached file. After that when i run localhost:9001, I am asked for username/password which i enter as admin/admin . But it shows error page as attached.
error.png
Can you please help on this?
Pablo
@IceS2
Mar 11 2016 14:53
Is someone there using pandas inside Redash?
Neil Shah
@shahneil88
Mar 11 2016 14:54
@IceS2 - Where exactly are you trying to use pandas. I haven't tried, but curious to know
Arik Fraimovich
@arikfr
Mar 11 2016 14:59
@shahneil88 the error is probably because of the migrations failing. Try what I described here: https://github.com/getredash/redash/issues/887#issuecomment-192977286 (I'm going to update the docs with this)
Pablo
@IceS2
Mar 11 2016 14:59
Instead of using Pandas with an external script, dumping into a cube or view on a db and querying it, I'm using ReDash support to Python to try to manipulate data inside ReDash with pandas.
I'm having trouble with the output
@arikfr , Besides my 'Pandas' trouble, I'm getting "Your Google Apps domain name isn't allowed" when trying to use OAuth, can you help me with it?
Thanks (=
Arik Fraimovich
@arikfr
Mar 11 2016 15:00
@rghose I answered a similar question here, try finding it. If not, I can send details later (mobile right now), just let me know.
@denstepa combine as merge results?
@IceS2 about Google apps: did you allow this domain with the cli command? (it's mentioned in the setup guide)
@IceS2 also, will be happy to help with Pandas, but later...
Neil Shah
@shahneil88
Mar 11 2016 15:03
@arikfr - Solution that you mentioned, works. Thank you.
Pablo
@IceS2
Mar 11 2016 15:10
I did!
@arikfr I've allowed it with the cli command and restarted redash.
Pablo
@IceS2
Mar 11 2016 15:49
@arikfr 'Error running query: 'seaborn' is not configured as a supported import module', can you help me out with this as well? (Actually... Is it possible to display plots made with seaborn on the redash dashboards? thanks!)
Pablo
@IceS2
Mar 11 2016 16:56
@arikfr Is there a way to add visualizations other than the default ones? Thanks!
just10minutes
@just10minutes
Mar 11 2016 18:36
Hi @arikfr , i saw about ReDash tool on Github, just wanted to know is it open source?
just10minutes
@just10minutes
Mar 11 2016 18:56
@arikfr i got my answer, its opensource. Sorry asked question without reading much about your project
Arik Fraimovich
@arikfr
Mar 11 2016 19:03
@IceS2 do you still have the output of the cli run?
@just10minutes it is. I'm curious, what made you unsure if it's open source?
just10minutes
@just10minutes
Mar 11 2016 19:05
i went to this page http://redash.io/ then i clicked on pricing there was no option of free/open source so got confused
Denis Stepanov
@denstepa
Mar 11 2016 19:24
@arikfr yes merge results, or just make a counter that will be calculated based on 2 datasources ?
Arik Fraimovich
@arikfr
Mar 11 2016 19:51
@just10minutes I had a feeling this might be the case. I will update the pricing page.
(the pricing is for the hosted version)
@denstepa currently it's possible if you use the python query runner, but I do plan on adding something like this.
just10minutes
@just10minutes
Mar 11 2016 20:00
Thank you @arikfr , i am trying to install this on openshift paas, not sure how much successful i will be :)
Pablo
@IceS2
Mar 11 2016 20:02
@arikfr Updated list of allowed domains to: ['{{<mydomain>}}']
The best question i'd like to have answered is if there is a way to add different visualizations other than the default ones, such as a gauge meter.
Arik Fraimovich
@arikfr
Mar 11 2016 20:06
@IceS2 you should write the command without the {{}}...
@IceS2 visualizations: it's my goal for this year to make it easier to add new visualization. today to create a new visualization it's a more involved process, see this for example: https://github.com/getredash/redash/pull/323/files not that complex, but there are a few moving parts.
Pablo
@IceS2
Mar 11 2016 20:08
Ok, thanks!
Arik Fraimovich
@arikfr
Mar 11 2016 20:08
pull requests with new visualizations are welcomed :)
just10minutes
@just10minutes
Mar 11 2016 20:21
it looks like on openshift i cannot install it, as i won't have root access
can't i install without root?
Arik Fraimovich
@arikfr
Mar 11 2016 20:21
@just10minutes you need root to install some of the dependencies. maybe you can use the docker images
just10minutes
@just10minutes
Mar 11 2016 20:23
sorry i do not have much knowledge on these, docker images are you referring to AWS and GCE?
as i am trying as a test i would like to deal with open source platforms, for eg: openshift PAAS is opensource