Not able to run with pgsql and docker

[janhoy]

Describe the bug
Trying to use a Postgres DB for docker-compose is hard and fails.

To Reproduce
Steps to reproduce the behavior:

1. Create a pgsql db somewhere (not in docker)
2. Modify docker-compose.prod.yaml to point to that DB (with app image from hub)
3. Start the app (docker-compose up)
4. Fails because 'pg' db driver is not bundled in o19s/quepid
5. Clone Dockerfile.prod, Gemfile and config locally, add pg ~> 0.18 to Gemfile (and Gemfile.lock) and modify docker-compose file accordingly (see Dockerfile)
6. Build container and try again
7. Now we get started, to the point where db:setup is run
8. db setup fails with (see full log)

   rake aborted!
   ActiveRecord::StatementInvalid: PG::DuplicateTable: ERROR:  relation "user_id" already exists
   : CREATE  INDEX  "user_id" ON "cases" USING btree ("user_id")
   

Expected behavior

• Docker image should ship with the most common db drivers including postgres, oracle etc
• DB schema.rb and migrations should work across different databases

[janhoy]

No urge to fix this, I gave up and use a standalone MySql instead, which btw worked like a charm :)

[epugh]

My feeling is that the type of database is kind of an internal detail to Quepid... Kind of like when Solr went from a WAR deployable in Tomcat or Jetty to the servlet container being a internal detail to Solr. Supporting multiple databases would require a much more comprehensive CI process than we have today ;-)

[janhoy]

Ok, that can be a choice you make. If so, I'd document it clearly and remove DB_ADAPTER variable from docker-compose and instead hardcode it in database.yml with a comment that it will NOT work with anything else.

Where I'm coming from is we plan to deploy Quepid as a container in our environment, but at the same time we don't want to keep the DB on the same host where it can get lost. We use ECS for containers and RDS for databases. It worked fine once I provisioned a MySql RDS db.

[epugh]

I’d love any tips on the https://github.com/o19s/quepid/wiki/Installation-Guide page for what you did to get it working with RDS, and that is a good suggestion on changing up the DB_ADAPTER. Let me reopen this ticket to make sure we actually get that change done ;-)

…

On Jun 10, 2020, at 7:40 AM, Jan Høydahl ***@***.***> wrote: Closed #155 <#155>. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#155 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAFO6YAINZ77BJRLYQIPXLRV5WJPANCNFSM4N2HTRLQ>.

_______________________ Eric Pugh | Founder & CEO | OpenSource Connections, LLC | 434.466.1467 | http://www.opensourceconnections.com <http://www.opensourceconnections.com/> | My Free/Busy <http://tinyurl.com/eric-cal> Co-Author: Apache Solr Enterprise Search Server, 3rd Ed <https://www.packtpub.com/big-data-and-business-intelligence/apache-solr-enterprise-search-server-third-edition-raw> This e-mail and all contents, including attachments, is considered to be Company Confidential unless explicitly stated otherwise, regardless of whether attachments are marked as such.

[epugh]

Keep ticket open till we update the documentation etc.

[janhoy]

My feedback on installation guide wiki is:

• The guide works for 6.2 but not for current latest image
  • I.e. thor user:grant_administrator does not exist in 6.1.1, and syntax for user:create is also different
  • So perhaps documentation should be in the git repo and not wiki, and tell people to first browse to some tag corresponding with latest hub image to get the correct documentation

The only thing I did to talk to RDS in AWS was to change DB_HOST, DB_USERNAME, DB_PASSWORD and DATABASE_URL in docker-compose :) Btw: Why do you need DATABASE_URL when we just configured all parts of it in the other vars? Well, the only part missing to construct DATABASE_URL would be DB_PORT

[epugh]

Interesting on the DATABASE_URL versus teh DB_HOST etc.. I don't know why it's like that, though I think it's a pattern that I've seen... not sure why!

[epugh]

Added a comment about AWS RDS to https://github.com/o19s/quepid/wiki/Installation-Guide#docker-compose-based-install