m0ngr31 / DailyNotes

App for taking notes and tracking tasks on a daily basis
MIT License
702 stars 43 forks source link

sqalchemy errors ; stuck on sign up page #66

Closed bugsbunny88 closed 2 years ago

bugsbunny88 commented 2 years ago

I have a bunch of python sqalchemy errors when installing this ; on Docker Synology using portainer ; it was a simple enough guie I was following . stuck at sign up page . [https://mariushosting.com/how-to-install-dailynotes-on-your-synology-nas/]

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file today at 6:57:58 PM(Background on this error at: https://sqlalche.me/e/14/e3q8)

I have extracted what I feel might be the most relevant code out of the logs ... image

m0ngr31 commented 2 years ago

Seems like it's not reading the DB file. It could be one of a few things...

  1. The config folder isn't being passed through properly. So double check that.
  2. There is an issue with the file permissions and that's something I need to get figured out since it has issues on some installs.
bugsbunny88 commented 2 years ago

its not #1 ; i've done environment variables version with PUIG/PGID to no avail ; its something permissions related at creation because the dailynotes folder is empty even after the container is running . I think the .db file isn't being generated at the onset due to the permission issue .

m0ngr31 commented 2 years ago

Try using the tag v1.0-beta10 on docker. That was the version before the permissions.

bugsbunny88 commented 2 years ago

perfect ; yup I am in now ; works . I will just stick to this tag and keep tabs on this thread for when I can move forward with an update. Atleast I'm up and running ! thanks man

kartikay-bagla commented 2 years ago

I have also been facing the same issue. While using v1.0-beta10 worked for me, I don't think it has the search option, which would've been quite useful.

Steps to reproduce:

  1. run command provided in README for docker

Investigating the logs also showed that while the error is same, the root cause is that the .env file is not being opened due to a permission error.

I have also tried running as root and passing in PUID and GUID for root to no avail.

m0ngr31 commented 2 years ago

@bugsbunny88 @kartikay-bagla I reverted the changes for the permissions stuff on the latest docker image. Try it now.

kartikay-bagla commented 2 years ago

Getting this now.

ERROR: for dailynotes  Cannot start service dailynotes: unable to find user abc: no matching entries in passwd file
ERROR: Encountered errors while bringing up the project.

For context here's my docker-compose.yml

version: '3.1'
services:
  dailynotes:
    image: m0ngr31/dailynotes:latest
    restart: unless-stopped
    ports:
      - '20007:5000'
    volumes:
      - ./config:/app/config
m0ngr31 commented 2 years ago

Good catch. I'm pushing up a fix

kartikay-bagla commented 2 years ago

Can you ping me once it's uploaded on dockerhub? I'll try it out.

m0ngr31 commented 2 years ago

Try now

kartikay-bagla commented 2 years ago

Works like a charm now!

Thanks for helping out.