horilla icon indicating copy to clipboard operation
horilla copied to clipboard

How to configure a Fresh DB

Open wasimkhan2024 opened this issue 1 year ago • 5 comments

I've installed the horilla software successfully using its installation guide on its website but it has demo data. how can i replace it with fresh DB and its configuration according to my requirements.

wasimkhan2024 avatar Jun 25 '24 10:06 wasimkhan2024

Hi @wasimkhan2024 , You can change the database name inside the horilla/settings.py and run the migrations command to start with a fresh database. Change the name of the database inside the settings.py file to your wish. After that run the makemigrations and migrate command. Inside settings.py you'll find a line for database configuration containing the name "TestDB_Horilla.sqlite3". Just change the name to anything you wish followed by .sqlite3 as file format. (For example: "Production_DB.sqlite3"). Run the migrations command.

python3 manage.py makemigrations
python3 manage.py migrate

If you are going for a production level installation, we suggest you to use postgresql database instead of sqlite3.

With Regards, Team Horilla

horilla-opensource avatar Jun 25 '24 11:06 horilla-opensource

Thank you for your guidance and support. as per your suggestion of shifting to Postgresql database, is it possible for you to guide me about this shifting with complete details like what would be the suggested DB name with extension. I've followed the steps mentioned in https://www.horilla.com/docs/database-setup/ but getting error mesg.

wasimkhan2024 avatar Jul 18 '24 10:07 wasimkhan2024

getting error: Execution of job "block_unblock_disciplinary (trigger: interval[0:00:10], next run at: 2024-07-18 17:10:25 PKT)" skipped: maximum number of running instances reached (1)

wasimkhan2024 avatar Jul 18 '24 12:07 wasimkhan2024

Hi @wasimkhan2024 , Can you share with the details of the settings.py file containing the database configuration data?

horilla-opensource avatar Jul 22 '24 09:07 horilla-opensource

Hi @wasimkhan2024 , Any updates?

With Regards, Team Horilla

horilla-opensource avatar Aug 13 '24 08:08 horilla-opensource

Hi @wasimkhan2024 , We are closing this issue due to inactivity. It seems that there hasn't been any recent activity or discussion, and we believe it may have been resolved or is no longer relevant. If you feel this issue is still important and should be addressed, please feel free to reopen it or create a new issue with updated details.

With Regards, Team Horilla

horilla-opensource avatar Aug 16 '24 04:08 horilla-opensource