VITAS changed the topic of #spacedock to: Problems?: https://github.com/KSP-SpaceDock/SpaceDock/issues | Matrix/Riot Chat: https://im.52k.de +spacedock:52k.de Feel free to ask for help, we only bite a little bit! | If you want to help, please check https://github.com/KSP-SpaceDock/SpaceDock-Backend/issues/5 :) | <VITAS> inet users have the attentionspan of a squirrel...
cukkoo[m] has joined #spacedock
<cukkoo[m]> hello i am wondering about the spacedock urrh i forgotoh yeah space dock contributor
<cukkoo[m]> i want to add a user as contributor
<cukkoo[m]> but it's still pending
<cukkoo[m]> for like 1 month
VITAS[m] has joined #spacedock
<VITAS[m]> huh?
<VITAS[m]> so like coauthor?
<VITAS[m]> Go to your mod->edit->additional authors->type username->add
Darklight[m] has joined #spacedock
<Darklight[m]> They have to accept it
<VITAS[m]> that too
<cukkoo[m]> i already do that
<VITAS[m]> and did he accept?
<VITAS[m]> whats the mod lin?
<VITAS[m]> link
cukkoo[m] has quit [Quit: Client limit exceeded: 6]
Vali[m] has joined #spacedock
<Vali[m]> I think it would be also a cool feature adding people to the author list despite needing an account for them. I also would like to add someone to the author list, but that person isn’t active anymore & doesn’t have a SpaceDock account, but he still deserves credit imo.
<VITAS[m]> you could mention them in the desripton
<VITAS[m]> +i
<VITAS[m]> its a good idea to restrict the author function to existing accounts. if you want any rights management you dont want random strings as authors.
Darklight[m] has quit [Quit: Client limit exceeded: 6]
DasSkelett[m] has joined #spacedock
<DasSkelett[m]> So this is why our `stupid_user` test doesn't work anymore...
* DasSkelett[m] uploaded an image: unknown.png (59KB) < https://matrix.52k.de/_matrix/media/r0/download/52k.de/MVwsMSpFeYLFiOmBjGLOrooF >
Vali[m] has quit [Quit: Idle timeout reached: 10800s]
VITAS[m] has quit [Quit: Idle timeout reached: 10800s]
DasSkelett[m] has quit [Quit: Idle timeout reached: 10800s]
<RockyTV> is it possible to use sqlite with spacedock?
VITAS[m] has joined #spacedock
<VITAS[m]> not tested
<VITAS[m]> i would think no
<VITAS[m]> DasSkelett: see query
DasSkelett[m] has joined #spacedock
<DasSkelett[m]> In theory, yes, I think. SqlAlchemy should abstract it enough. Although I'm not sure if we don't use some Postgres-specific functions somewhere.
<VITAS[m]> exactly
<DasSkelett[m]> You could try it out. In theory it should be as easy as changing the connection string in the config to see if it works. Would be interesting.
<RockyTV> I want to setup a local instance for testing so I don't have to deal with CORS but I don't want to install postgres
<VITAS[m]> try it
<RockyTV> it works!!!
<RockyTV> now I just need to run spacedock
<VITAS[m]> cool job
<RockyTV> how do I run the backend?
<RockyTV> the instructions in the readme are outdated btw
<RockyTV> ModuleNotFoundError: No module named 'email.utils'; 'email' is not a package
<DasSkelett[m]> Check the README of alpha branch
<RockyTV> o
<VITAS[m]> RockyTV (IRC): also you could update it :)
<DasSkelett[m]> Yep, would be even better. This might also help regarding system dependencies: https://github.com/KSP-SpaceDock/SpaceDock/wiki/Migration-notes-and-tasks#dependencies
<DasSkelett[m]> And for running the backen, either gunicorn, or the Flask's built-in server. You can use the SystemD-scripts that are in the repo, or if yuo want to use docker, that works too, although you couldn't use docker-compose since that wants to run Postgres.
<RockyTV> ah thanks, it works!
<RockyTV> just need to build the frontend now
<RockyTV> actually
<RockyTV> when you run spacedock database populate it doesn't create a sample mod, right?
<DasSkelett[m]> No
<RockyTV> weird enough, things in static aren't served by gunicorn... oh I need a webserver
<RockyTV> hm, I think I can create the mods via sql
<RockyTV> DasSkelett[m], do you know how to create a mod via curl?
<VITAS[m]> you can steal cnfig stuff from alpha
<RockyTV> I forgot api.md exists
<RockyTV> hm, passing -c ./cookies replaces the file
<RockyTV> it's -b to read from file
<RockyTV> okay created it now I need to publish
<RockyTV> published!
HebaruSan[m] has joined #spacedock
<HebaruSan[m]> Yikes
DasSkelett[m]1 has joined #spacedock
<DasSkelett[m]> That was the top output from an hour ago.
<HebaruSan[m]> What sorts of options do we have for profiling
<DasSkelett[m]> That's a good question.
<HebaruSan[m]> Do mod downloads stay in memory?
<HebaruSan[m]> Do mod downloads stay in memory?
<VITAS[m]> thy shouldnt be handled by gunicorn
<HebaruSan[m]> I guess we can do what <span class="d-mention d-user">RockyTV</span> is doing and measure resource consumption after specific batches of requests
<VITAS[m]> i know we had problems with images so gunicorn is handeling static content like that atm
<RockyTV> maybe it's a celery problem?
<DasSkelett[m]> Not entirely sure how the Apache web server works, if it caches the mod files itself in memory or if it lets the kernel handle it, but in either case it should be memory space that's given free if another process needs it, and shouldn't use up any swap space.
DasSkelett[m]1 has quit [Quit: Client limit exceeded: 6]
<RockyTV> ffs Reason: CORS header ‘Access-Control-Allow-Origin’ missing even at localhost
<VITAS[m]> apache webserver caches static content
<VITAS[m]> and does LB for gunicorn processes
<VITAS[m]> its intended more as a splitter between content types and for LB on local process level
<VITAS[m]> ATS does the real caching
<VITAS[m]> gunicorn \
<VITAS[m]> static content --apache webserver ---ATS ---client
<VITAS[m]> mods /
<VITAS[m]> ATS also does header cleanup, https, htrtp2 and in general makes http headers look nice
<VITAS[m]> http2
HebaruSan[m] has quit [Quit: Client limit exceeded: 6]
DasSkelett[m] has quit [Quit: Client limit exceeded: 6]
Darklight[m] has joined #spacedock
<Darklight[m]> It might be possible to drop from like 10 instances back to 1 for gunicorn, given that the "hit the database a bazillion times" bug was fixed
<Darklight[m]> The speedup was like 100x if I remember correctly, also I don't know if my tester thing is still working, I haven't had a chance to look lately
<Darklight[m]> Looks like it is