Installation on Docker - database "loomio_production" does not exist

Hi @stuartnorth - try docker-compose run app rake db:create or if that fails then I'd be keen to know about it.

Something like docker exec -ti loomio-db su - postgres -c 'createdb loomio_production' might work, but I worry it may have a permission error.

Let me know.

Hi @robertguthrie I have to run docker compose as sudo. I get a lot of output from 'sudo docker-compose run app rake db:create'
https://pastebin.com/8v9MvhaK
And I'm still getting the same errors in the logs;
loomio-db | FATAL: database "loomio_production" does not exist
loomio-app | rake aborted!
loomio-app | ActiveRecord::NoDatabaseError: FATAL: database "loomio_production" does not exist

I get no errors from running the command "docker exec -ti loomio-db su - postgres -c 'createdb loomio_production'"
but I'm getting tons of new errors in the logs now https://pastebin.com/TvZkc6vi

loomio-worker | Warning: method update already defined
loomio-worker | [Worker(host:d0e053ee4ed8 pid:7)] Starting job worker
loomio-worker | 2019-02-27T20:00:34+0000: [Worker(host:d0e053ee4ed8 pid:7)] Starting job worker
loomio-db | ERROR: relation "delayed_jobs" does not exist at character 566
loomio-db | STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
loomio-db | pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
loomio-db | c.collname, col_description(a.attrelid, a.attnum) AS comment
loomio-db | FROM pg_attribute a
loomio-db | LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
loomio-db | LEFT JOIN pg_type t ON a.atttypid = t.oid
loomio-db | LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
loomio-db | WHERE a.attrelid = '"delayed_jobs"'::regclass
loomio-db | AND a.attnum > 0 AND NOT a.attisdropped
loomio-db | ORDER BY a.attnum
loomio-db |

loomio-worker | [Worker(host:d0e053ee4ed8 pid:7)] Error while reserving job: PG::UndefinedTable: ERROR: relation "delayed_jobs" does not exist
loomio-worker | LINE 8: WHERE a.attrelid = '"delayed_jobs"'::regclass
loomio-worker | ^
loomio-worker | : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
loomio-worker | pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
loomio-worker | c.collname, col_description(a.attrelid, a.attnum) AS comment
loomio-worker | FROM pg_attribute a
loomio-worker | LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
loomio-worker | LEFT JOIN pg_type t ON a.atttypid = t.oid
loomio-worker | LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
loomio-worker | WHERE a.attrelid = '"delayed_jobs"'::regclass
loomio-worker | AND a.attnum > 0 AND NOT a.attisdropped
loomio-worker | ORDER BY a.attnum
loomio-worker | 2019-02-27T20:00:34+0000: [Worker(host:d0e053ee4ed8 pid:7)] Error while reserving job: PG::UndefinedTable: ERROR: relation "delayed_jobs" does not exist
etc

no errors on createdb means you created the database. Re run the db:setup command to fix those relation missing errors.

ok, that looked good https://pastebin.com/GFR0YhxV
and loomio appears to be loading now
many thanks @robertguthrie

@robertguthrie although I'm no longer getting '500 Internal Server Error'.
It redirects to /dashboard but the page is completely blank
https://pastebin.com/KeaEEAWH

If dashboard page is blank please open javascript console and read any browser errors

Hi, I'm facing this same problem. Whether I do:

docker-compose run app rake db:create

or

docker-compose run app rake db:setup

The result is the same for each:

ActiveRecord::NoDatabaseError: FATAL: database "loomio_production" does not exist

try

docker-compose run app createdb loomio_production
docker-compose run app rake db:setup


If that does not work you'll need to sudo to postgres user to createdb.

Let me know if it works and I'll update the docs either way.

Thankyou @robertguthrie but I'm not having much luck. I am new to Docker, so perhaps it's something trivial.

root@vultr:~/loomio-deploy# docker-compose run app createdb loomio_production
Starting loomio-db    ... done
Starting loomio-redis ... done
Error response from daemon: OCI runtime create failed: container_linux.go:348: starting container process caused "exec: \"createdb\": executable file not found in $PATH": unknown

Is this what you meant by "su to postgres and createdb"? Because that also has not helped...

postgres@vultr:~/loomio$ createdb loomio_production
postgres@vultr:~/loomio$ exit
exit
root@vultr:~/loomio-deploy# docker-compose run app rake db:setup
Starting loomio-db ... done
Starting loomio-redis ... done
rake aborted!
ActiveRecord::NoDatabaseError: FATAL:  database "loomio_production" does not exist