Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Empty sqlite DB after install #50

Open
ComputingFroggy opened this issue Mar 14, 2024 · 3 comments
Open

Empty sqlite DB after install #50

ComputingFroggy opened this issue Mar 14, 2024 · 3 comments

Comments

@ComputingFroggy
Copy link

Describe the bug
I've followed instructions at https://github.com/Rabbit-Company/Passky-Server/blob/main/docs/installation/shared-hosting.md but once done. There's no sqlite DB file created. Once I get to the Health tab of my passky server. The passky.db file is created and is empty. The Health tab indicates "API can't connect with a database." ... which is quite logic as it is empty.

To Reproduce
Steps to reproduce the behavior:

  1. Install following instructions at https://github.com/Rabbit-Company/Passky-Server/blob/main/docs/installation/shared-hosting.md
  2. Empty datase

Expected behavior
I would expect the installation to work with a sqlite DB created and working.

Desktop (please complete the following information):

  • OS: Ubuntu 22.04

** Server : PHP 8.3

@zigazajc007
Copy link
Member

Hello,

Documentation for Shared-Hosting does not mention cron task, that takes care for creating tables in a database.

Once Passky Server is deployed execute /cron.php API endpoint.
image

You can create a cron task that will execute this API endpoint every minute.

@ComputingFroggy
Copy link
Author

That worked !
Why running this cron every minute ?

@zigazajc007
Copy link
Member

That worked ! Why running this cron every minute ?

The tasks behind a cron.php will only get executed once per day. So it is completely safe to call it every minute or even spam the /cron.php api endpoint.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants