These are chat archives for getredash/redash

10th
May 2016
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 07:48
Hi all. I have 2 questions:
1) when I setup Mail Configuration to gmail server i get exception SMTPException("STARTTLS extension not supported by server.")
to another servers as yahoo I can't send mail too.
My gmail settings: export REDASH_MAIL_SERVER="smtp.gmail.com"
export REDASH_MAIL_PORT="465"
export REDASH_MAIL_USE_TLS="True"
export REDASH_MAIL_USE_SSL="True"
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 07:54
also i setup USERNAME, PASSWORD, DEFAULT_SENDER and REDASH_HOST. What I do wrong?
2) Can I use NOT integer values for Reference in Alerts?
Antoine Augusti
@AntoineAugusti
May 10 2016 09:11
@MarchenkoAndrii I've got the following settings for Gmail and it works fine
export REDASH_MAIL_SERVER="smtp.gmail.com"
export REDASH_MAIL_PORT=587
export REDASH_MAIL_USE_TLS=True
export REDASH_MAIL_USE_SSL=False
export REDASH_MAIL_USERNAME="foo@example.com"
export REDASH_MAIL_PASSWORD="blah"
Arik Fraimovich
@arikfr
May 10 2016 09:12
@MarchenkoAndrii re. reference values: no.
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 09:14
@arikfr Thanks
Arik Fraimovich
@arikfr
May 10 2016 09:14
@ttheune if you share the logs, using the stacktrace we can figure out what's wrong. But probably it got some response it failed to parse.
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 09:15
@AntoineAugusti with this settings i got SMTPAuthenticationError Please log in via your web browser and then try again.
Arik Fraimovich
@arikfr
May 10 2016 09:25
@MarchenkoAndrii are you using 2 factor authentication?
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 10:08
@arikfr No
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 10:30
@arikfr @AntoineAugusti Very interesting... I Create new gmail account, try send email with bin/run ./manage.py send_test_mail and i got usual for me message, but test message will be delivered. a few minutes later I received a letter from Google about locking my account. I unlocked it, tried again but most messages do not come :(
Arik Fraimovich
@arikfr
May 10 2016 10:31
@MarchenkoAndrii it might be that Google are cautious about people using Gmail accounts from cloud servers?
@MarchenkoAndrii I'm using MailGun to send emails. Works very well and have a very generous free tier (10K/mo messages)
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 10:34
@arikfr But if i connect my gmail account for MailGun i must setup config as for Google?
Arik Fraimovich
@arikfr
May 10 2016 10:37
@MarchenkoAndrii no, mailgun gives you their smtp server.
martin sarsale
@runa
May 10 2016 12:29
Hi! My queries are stuck: IN PROGRESS (0) WAITING (9) DONE (50)
why is this?
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 12:37
@arikfr Now I can send test mail with bin/run ./manage.py send_test_mail but when alerts are triggered I don't get mail :( I try change "Subscribers" but any progress. Also Send Password Reset Email don't send email :(
Arik Fraimovich
@arikfr
May 10 2016 12:49
@runa and really don't execute? are the workers running?
martin sarsale
@runa
May 10 2016 12:49
@arikfr um. I restarted celery and they're running now (?)
Arik Fraimovich
@arikfr
May 10 2016 12:49
@MarchenkoAndrii what are you using? gmail or mailgun?
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 12:57
gmail
@arikfr I wait verification from MailGun
Arik Fraimovich
@arikfr
May 10 2016 12:59
@MarchenkoAndrii maybe check spam? also gmail sometimes auto archives emails you send to yourself. so if you're sending to the same account you're sending from , also check all mail.
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 13:01
@arikfr No, i haven't it in sent mail :( In sent mail only test mails
Arik Fraimovich
@arikfr
May 10 2016 13:02
was the alert triggered before email started to work properly?
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 13:03
@arikfr And before and after
also I try setup Rearm, no progress :(
Arik Fraimovich
@arikfr
May 10 2016 13:08
check the logs
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 13:44
@arikfr In logs only old errors that I get when can't setup mail :(
MarchenkoAndrii
@MarchenkoAndrii
May 10 2016 13:54
@arikfr Oh yes... I found the problem. I restart reDash (As usual after every change sudo supervisorctl restart redash_server) and than I restart Instance with ReDash on GCE
@arikfr Thank's for help!!!
Travis Theune
@ttheune
May 10 2016 15:37
@arikfr how do you want me to send you the stack?
Arik Fraimovich
@arikfr
May 10 2016 18:39
@MarchenkoAndrii if this is how you restart, then this your problem. running restart redash_server restarts only the web server, but doesn't restart the workers (we actually send the email...). you should use restart all.
@ttheune whatever works for you. gist?
Travis Theune
@ttheune
May 10 2016 18:40
sure thing. gimme just a second.
gist of the query that fails:
martin sarsale
@runa
May 10 2016 19:02
@arikfr everybody here is delighted with the new UI
mitchhh22
@mitchhh22
May 10 2016 20:13
any one getting an "Internal Server Error" when trying to enable a User's role to Admin?
I set up redash with GCP: http://docs.redash.io/en/latest/setup.html#google-compute-engine
EssamSalah
@EssamSalah_twitter
May 10 2016 22:11
Hey, any plan to support Oracle?
mdwongca
@mdwongca
May 10 2016 22:38
Is there a way to combine multiple data sources into one query? I have a one data source that I'm querying against, but ideally need to pull identifiers for specific items out of another data source?
Scott Hand
@scott-hand
May 10 2016 22:57
@arikfr It's up to if you need a UI for the widget add feature. As it stands, if I want to make a base query and have 20 different users tailor it to their set of parameters, I would need 20 different queries. That's fine and all, but maybe in the future it would be nice to use dashboard widgets as "tailored queries".
This also might seem kind of like a frivolous request, but is there a way to disable the commas in integers being displayed? Looks silly if it's displaying things like IDs