search

meethed / simpleLifter

simpleLifter powerlifting meet program
http://cotf.zapto.org
GNU General Public License v3.0
4 stars 1 forks source link

Better documentation for selfhosting #21

Open Bearsaerker opened 1 year ago

Bearsaerker commented 1 year ago

I love your webapplication so far. I played a little bit around with your webversion and it works like a charm. I wanted to use it in our next meet where we unfortunately don't have any internetconnection whatsoever. I wanted to host this site myself through a raspberry pi and a mobile router but I don't get it to work by myself. I can access the index.php, its hosted via apache but I can't connect it to a database. I don't exactly have enough knowledge to know how to proceed or what even went wrong. But I think a rough documentation of how to set up a database would be enough. Love your effort so far!

meethed commented 1 year ago

ahhh yes!! mine was hosted on a raspberry pi, it's more than capable of keeping up. i have no idea how to describe the database setup for you, but give me a few hours and i'll get something together.

i originally had a standalone version of simpleLifter that you could just download and run on a local computer, and have it all save to the local storage and to a local file. it'll be impossible to do the referee lights with that version as they can't all talk to the computer (unless over bluetooth or some other thing that i haven't done), but if you just want a 1 minute attempt timer, a 1 minute 'next attempt' timer, that could be knocked up in a matter of minutes.

what would you prefer? database setup so you can clone it on your own raspberry pi, or a standalone version of simpleLifter without the lights and overlay connectivity?

Bearsaerker commented 1 year ago

Thank you for your fast reply. I'd need the referee lights running locally. So this would be the version I'd prefer :D but I don't want to pressure you! Take your time :)

meethed commented 1 year ago

mate have a look at the new database.md file i created for you. it has the "comps" table description laid out in a format that makes sense. Sorry it's so messy... you'll have to learn a thing or two about setting up mysql (i used mariadb on my PI, i think that's what comes default?) and getting it to talk to PHP but it should be pretty easy... i mean i have NFI what i'm doing and i worked it out!!

i've also updated all of the php files so they all use ".../config.php" which means once your database is set up you just need to make that file which establishes the $conn connection to your DB and you should be GTG

Bearsaerker commented 1 year ago

Thanks for the new description. Is the php file already there or do I have to write one by myself?

meethed commented 1 year ago

ahh you gotta make your own, it doesn't belong in the web root (/var/www/html) it goes in /var/www, and because it has the database password in plain text it can't be accessible by outsiders. the database.md file should have everything you need to make one

Bearsaerker commented 1 year ago

Thanks for your help, I got it to work (The lights at least). If you want to I can write a complete noob documentation of what I've done with all steps so that others can profit from it!