These are chat archives for getredash/redash

22nd
Mar 2015
Ralph Yozzo
@fedex1
Mar 22 2015 11:32
Continuing from google group question:
@arikfr here is the output:
ubuntu@ip-10-225-140-50:~/Downloads/github/EverythingMe/redash$ sudo -u redash bin/run ./manage.py  ds list
sed: can't read .env: No such file or directory
[2015-03-22 11:33:12,525][PID:14877][WARNING][google_oauth] No Google Apps domain defined, all Google accounts allowed.
Id: 2
Name: bigquery
Type: bigquery
Options: {"projectId": "personal-real-estate", "privateKey": "/home/ubuntu/Personal Real Estate-XXXX.p12", "serviceAccount": "499933939830-XXXX@developer.gserviceaccount.com"}
Arik Fraimovich
@arikfr
Mar 22 2015 11:38
@fedex1 you didn't use an AMI, right? you just ran the bootstrap script?
Ralph Yozzo
@fedex1
Mar 22 2015 11:38
Yes
I used the bootstrap script
it is easier for me
since i already have a machine running
and it is ubuntu12
Arik Fraimovich
@arikfr
Mar 22 2015 11:40
@fedex1 the bootstrap script "puts" redash and its related stuff in /opt/redash/. Try running the above command from /opt/redash/current.
@fedex1 what I think is going on that it uses two different pg databases (the version that serves your "traffic" and the one in ~/Downloads/github/EverythingMe/redash)
Ralph Yozzo
@fedex1
Mar 22 2015 11:41
ubuntu@ip-10-225-140-50:~/Downloads/github/EverythingMe/redash$ cd /opt/redash/current
ubuntu@ip-10-225-140-50:/opt/redash/current$ sudo -u redash bin/run ./manage.py  ds list
/tmp/redash_env.ZqY8D9: line 4: //export: No such file or directory
[2015-03-22 11:40:23,710][PID:14944][DEBUG][redash.query_runner] Registering BigQuery (bigquery) query runner.
[2015-03-22 11:40:23,711][PID:14944][DEBUG][redash.query_runner] Registering Graphite (graphite) query runner.
[2015-03-22 11:40:23,725][PID:14944][DEBUG][redash.query_runner] Registering MongoDB (mongodb) query runner.
[2015-03-22 11:40:23,734][PID:14944][DEBUG][redash.query_runner] Registering Mysql (mysql) query runner.
[2015-03-22 11:40:23,748][PID:14944][DEBUG][redash.query_runner] Registering PostgreSQL (pg) query runner.
[2015-03-22 11:40:23,749][PID:14944][DEBUG][redash.query_runner] Registering Script (script) query runner.
[2015-03-22 11:40:23,749][PID:14944][DEBUG][redash.query_runner] Registering Url (url) query runner.
[2015-03-22 11:40:23,788][PID:14944][WARNING][google_oauth] No Google Apps domain defined, all Google accounts allowed.
[2015-03-22 11:40:24,037][PID:14944][DEBUG][peewee] ('SELECT "t1"."id", "t1"."name", "t1"."type", "t1"."options", "t1"."queue_name", "t1"."scheduled_queue_name", "t1"."created_at" FROM "data_sources" AS t1', [])
Id: 1
Name: re:dash metadata
Type: pg
Options: {"user": "redash_reader", "password": "ahphaeng", "host": "localhost", "dbname": "redash"}
ubuntu@ip-10-225-140-50:/opt/redash/current
should i run the ds new from that directory?
Arik Fraimovich
@arikfr
Mar 22 2015 11:42
@fedex1 yes with the bin/run util
Ralph Yozzo
@fedex1
Mar 22 2015 11:49
@arikfr Works now. I had to also make the *.p12 readable by redash. (which makes sense)
@arikfr Thanks for your help!!!
Arik Fraimovich
@arikfr
Mar 22 2015 12:02
@fedex1 happy that it worked :) feel free to ping me here or by email, if you have futerh questions