search

FIRST-Tech-Challenge / scorekeeper

FIRST Tech Challenge Live Scorekeeper Software
89 stars 21 forks source link

Problems with database access #658

Open Crossle86 opened 1 year ago

Crossle86 commented 1 year ago

After install of Live, I was able to add some users. The next day I wanted to add more and Live would not add users. Log file revealed errors about read only access to the database. After confirming Windows permissions were correct, I reinstalled Live. After reinstall the adding of users proceeded normally. Then I tried to automatically import an event. This failed to work. Log file shows the same problem, trying to write to read only database.

I suspect that this problem starts after I stop and then restart Live. Works right after install and then quits after restart. 2023_10_31_02_08_48_PM.log

Crossle86 commented 1 year ago

Update: I have successfully installed on another PC so the problem seems connected to my school district PC. This is unfortunate as it is my robotics PC and is highly customized and fully recognized by the school district network. That network may well be the problem but district IT folks examined my district PC today and could not find any explanation for the lack of write access to the Live database.

maths22 commented 1 year ago

We just released a new version of the installer with a fix that might address your issue (the FTCLive version hasn't changed; it is still v5.0.9). We can't quite reproduce the same behavior you encountered on our machines, so if you could try uninstalling the software, removing the affected folders from both AppData and Documents, repeat what you had originally done to reproduce this issue, and let us know what happens we would appreciate it.

(Our working hypothesis is that it ends up running the scoring system with the credentials of the admin user when launched after the installation, but then when restarted later it uses the credentials of the regular user that can't write to the files originally created by the admin user. The new version of the installer should ensure it still runs as the regular user on the first run.)

Crossle86 commented 1 year ago

I followed your instructions downloading installer and installing (after cleaning out old installation). No change in the problem. It is clear that on the initial execution of Live (installer asks if you want to launch and I say yes) I can users to the db. After shutdown and restart of Live I cannot add users. Log shows read only access. I am attaching the log from the initial run and the restart run.

I see on my other PC where Live works correctly the server.db is owned by the local Administrators group. On the problem PC as installed with new installer, server.db is owned by my user name, the user name that ran the installer.

All windows permissions show full access for my user and the administrators group. Running Live with Run as Administrator does not help. A fine mystery...

2023_11_01_09_12_23_AM.log 2023_11_01_09_14_43_AM.log

Crossle86 commented 1 year ago

Just an additional note: I do all of my FIRST work (FTC and FRC) on the PC with the problem and have not had any other issues of this nature with any other FIRST related software. This is a district PC and they are pretty skillful in ways to foul things up but I had a district IT person examine the PC and they concurred with me, nothing we can find explains the problem.

Crossle86 commented 1 year ago

I also tried installing just for my user instead of everyone but that did not change anything.

Crossle86 commented 1 year ago

Update on this. Have not determined the permissions issue on my district PC. Installed successfully on non-district PC to run our event.