Coder Social home page Coder Social logo

davical-docker-standalone's People

Contributors

elrondo46 avatar

Stargazers

avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar

Forkers

malauch hleskien scobbercareys

davical-docker-standalone's Issues

[BUG] docker container does not start with latest image

  • I'm submitting a ...

    • bug report

  • Do you want to request a feature or report a bug?

Report a bug

  • What is the current behavior?

The latest pushed tag of the docker image does not start anymore. I guess the problem is that the shebang in docker-entrypoint.sh is now on line 2 preceded by an empty line. Removing the empty line makes it start again.

Service container davical failed.
  /usr/bin/docker logs --details fb6b8cd40b0c504c0079032095f01a3945fe62bb26ea3ccebb8979378c7aab3a
   exec /sbin/docker-entrypoint.sh: exec format error
  • If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem

Just try to start a container, it won't work.

[BUG] role "davical_dba" is not permitted to log in

  • I'm submitting a ...

    • bug report
    • feature request
    • support request => Please do not submit support request here, see note at the top of this template.

  • Do you want to request a feature or report a bug?

bug

  • What is the current behavior?

Multiple errors related to davical_dba during startup
role "davical_dba" is not permitted to log in

The container is unable to initialize or update the davical database when the davical_dba user is used.
but works with the postgres user. Basically, all lines with davical_dba from docker-entrypoint.sh failed.

  • If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem

You need to add the following lines to docker-entrypoint.sh to make it work

    PGPASSWORD="$PGSQL_ROOT_PASS" /usr/bin/psql -qX -U postgres -h "$DBHOST" -c 'ALTER ROLE davical_dba LOGIN;'
    PGPASSWORD="$PGSQL_ROOT_PASS" /usr/bin/psql -qX -U postgres -h "$DBHOST" -c 'ALTER ROLE davical_app LOGIN;'
  • What is the expected behavior?

Initialize or update the davical database properly.

  • What is the motivation / use case for changing the behavior?

N/A

  • Please tell us about your environment:

    • Version: latest (81-1.1.12)

newest image does not work with old database

Hi there,

I had to create a new container from scratch and imported the old database with pg_restore. Now I get the following error when I try to add or change a calendar item:

6942ae863517 2023-08-25 19:28:09.483 UTC [87] ERROR:  column "dtstart_orig" of relation "calendar_item" does not exist at character 90
6942ae863517 2023-08-25 19:28:09.483 UTC [87] STATEMENT:  INSERT INTO calendar_item (user_no, dav_name, dav_id, dav_etag, uid, dtstamp,
6942ae863517 	  dtstart, dtstart_orig, dtend, dtend_orig, summary, location, class, transp,
6942ae863517 	  description, rrule, tz_id, last_modified, url, priority, created, due,
6942ae863517 	  percent_complete, status, collection_id, first_instance_start,
6942ae863517 	  last_instance_end )
6942ae863517 	VALUES ( 1002, '/holger/6D38C9C6-002E-4042-A448-E5C449FEB7E9/10640e17-ceca-499a-9ea1-de819b3712a3.ics', 5969, 'a893e4468f5410e053e76a9f7205c817', '10640e17-ceca-499a-9ea1-de819b3712a3', '20230825T192809Z', '20230825T220000',
6942ae863517 	  '20230825T220000', '20230825T230000', '20230825T230000', 'test2', NULL, NULL, 'OPAQUE',
6942ae863517 	  NULL, NULL, 'Europe/Berlin', '20230825T192809Z', NULL, NULL, '20230825T192804Z', NULL,
6942ae863517 	  NULL, NULL, 670, '20230825T200000Z',
6942ae863517 	  '20230825T210000Z')
6942ae863517 2023-08-25 19:28:09.483 UTC [87] ERROR:  current transaction is aborted, commands ignored until end of transaction block
6942ae863517 2023-08-25 19:28:09.483 UTC [87] STATEMENT:  SELECT nextval('metrics_count_put')
6942ae863517 2023-08-25 19:28:09.483 UTC [87] ERROR:  current transaction is aborted, commands ignored until end of transaction block
6942ae863517 2023-08-25 19:28:09.483 UTC [87] STATEMENT:  DEALLOCATE pdo_stmt_00000003

I assume davical was updated in between. Did you already delete the old image from docker hub? I think you should keep older images if possible. Do you know how to update the database or what else is wrong?

Thank you and kind regards

Holger

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.