yetanalytics / lrsql

A SQL-based Learning Record Store
https://www.sqllrs.com
Apache License 2.0
89 stars 18 forks source link

Windows Documentation #327

Open mhoepf opened 1 year ago

mhoepf commented 1 year ago

I've been able to successfully follow the documentation here to run the exe file and access/login to the LRS on a Windows server via the web address I'm using for this. However, if I try to access the LRS using the same web address NOT on the server, I am only able to navigate through the file structure. For example, if I enter the web address /admin/index.html I am able to pull up the index.html page (which takes you to the LRS login). But, it's clear to me that it's just loading the html only since, if I try to login, it tells me it's unable to connect to the LRS. I feel like the current documentation for installing on windows server could be expanded a bit more between steps 5 and 6 as it seems there's something I'm missing to make this work.

cliffcaseyyet commented 1 year ago

Hi @mhoepf,

I'm not sure that I am totally following. If you are able to open that web address, that means a full SQL LRS server is running and providing that resource. Additionally if you see the bootup in the terminal (including the logo) it's definitely running.

As for your login issues it could be a number of things depending on configuration. You mention you are using a web address for it. Is that domain something other than localhost? If so, one common deployment issue is you may be running into CORS issues. CORS is enabled by default and requires configuration to use real web addresses. Try accessing from within the server and see what happens from localhost:[port you used]. If that works, you'll know it's a CORS issue. If that is the case please refer to the following configuration vars (LRSQL_ALLOW_ALL_ORIGINS, and LRSQL_ALLOWED_ORIGINS).

If that is not the case let me know and we will keep troubleshooting some other angles.

Thanks, Cliff

mhoepf commented 1 year ago

@cliffcaseyyet - I do see the logo at the end of running the exe file and I also double checked my config vars. Those seem to be correct as I have AllowAllOrigins set to true. I am also unable to access the LRS from localhost:[port#] which I take as a good sign. Bottom line is that I can successfully access the LRS via the web address from the server. I cannot access the LRS outside of the server.