Thanks for the reply Omar. I just tried that and I'm on the latest version.
Hi Arnold, yes I have. There were no errors during that part of the installation.
After running those commands and checking on tables:
wwadmin@wwserver:/opt/webwork/courses$ sudo mysql
MariaDB [(none)]> use webwork;
MariaDB [webwork]> show tables;
I see:
+-------------------------------+
| Tables_in_webwork |
+-------------------------------+
| OPL_DBchapter |
| OPL_DBsection |
| OPL_DBsubject |
| OPL_author |
etc. What do you see?
My output is below:
+-----------------------------------------------------+
| Tables_in_webwork |
+-----------------------------------------------------+
| OPL_global_statistics |
| OPL_local_statistics |
| OPL_problem_user |
| Pluu_ProbStat_G1_Spring2020_achievement |
| Pluu_ProbStat_G1_Spring2020_achievement_user |
| Pluu_ProbStat_G1_Spring2020_global_user_achievement |
| Pluu_ProbStat_G1_Spring2020_key |
| Pluu_ProbStat_G1_Spring2020_password |
| Pluu_ProbStat_G1_Spring2020_past_answer |
| Pluu_ProbStat_G1_Spring2020_permission |
| Pluu_ProbStat_G1_Spring2020_problem |
| Pluu_ProbStat_G1_Spring2020_problem_user |
| Pluu_ProbStat_G1_Spring2020_set |
| Pluu_ProbStat_G1_Spring2020_set_locations |
| Pluu_ProbStat_G1_Spring2020_set_locations_user |
| Pluu_ProbStat_G1_Spring2020_set_user |
| Pluu_ProbStat_G1_Spring2020_setting |
| Pluu_ProbStat_G1_Spring2020_user |
| Test123_achievement |
| Test123_achievement_user |
| Test123_global_user_achievement |
| Test123_key |
| Test123_password |
| Test123_past_answer |
| Test123_permission |
| Test123_problem |
| Test123_problem_user |
| Test123_set |
| Test123_set_locations |
| Test123_set_locations_user |
| Test123_set_user |
| Test123_setting |
| Test123_user |
| admin_achievement |
| admin_achievement_user |
| admin_global_user_achievement |
| admin_key |
| admin_password |
| admin_past_answer |
| admin_permission |
| admin_problem |
| admin_problem_user |
| admin_set |
| admin_set_locations |
| admin_set_locations_user |
| admin_set_user |
| admin_setting |
| admin_user |
| depths |
| location_addresses |
| locations |
+-----------------------------------------------------+
51 rows in set (0.001 sec)
Hi Danny,
No I do not get any errors when running that command. See below:
I still get the same error on the front end when trying to access the library browser, and the table mentioned in the error still does not exist.
clj@ad.uauth.net@webwork2-gc:/opt/webwork/libraries/webwork-open-problem-library$ SKIP_UPLOAD_OPL_statistics=1 OPL-update
Downloading the latest OPL release.
Using WeBWorK root: /opt/webwork/webwork2
Using PG root: /opt/webwork/pg
Using library root: /opt/webwork/libraries/webwork-open-problem-library/OpenProblemLibrary
Using contrib root: /opt/webwork/libraries/webwork-open-problem-library/Contrib
Updating Library Statistics.
Importing statistics for 4 courses.
1 2 3 4
You may want to run load-OPL-global-statistics.pl to update the global statistics data.
If this is being run by OPL-update, that will be done automatically.
Loading global statistics (if possible).
WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.
Skipping upload-OPL-statistics as requested
Done.
Hi Andrew, thanks for your assistance!
line 39 of the file is as follows:
do $ENV{WEBWORK_ROOT} . '/bin/download-OPL-metadata-release.pl';
Attempting to run the cmd manually results in this error:
Error in tempdir() using /opt/webwork/webwork2/bin/FileFetch.XXXXXX: Could not create directory /opt/webwork/webwork2/bin/FileFetch.CD9T0Q: Permission denied at /usr/share/perl/5.34/File/Fetch.pm line 456.
Attempting to re-run with sudo results in:
download-OPL-metadata-release.pl: command not found
Hi,
You could use sudo with the full path to the script.
But it appears your permissions are not set up correctly which might cause other problems. I would suggest you redo the permissions in https://webwork.maa.org/wiki/Installation_Manual_for_2.17_on_Ubuntu#Setting_Permissions
Arnie
This is probably an artifact of running some of the scripts as root.
Most likely you can just delete the folder at /opt/webwork/libraries/webwork-open-problem-library/OpenProblemLibrary/fileFetch.H1nftW. That folder was probably created as a temporary location for downloaded files. It's worth looking to see what's in that folder to make sure that it doesn't look like anything important.
> resulted in some different results
Can you please share what results you received from running the `download-OPL-metadata-release`?
Sure thing!
Found OPL METADATA release v2022-05-30.
Downloaded release archive, now extracting.
Restoring OPL tables from release database dump.
OPL path seems to be /opt/webwork/libraries/webwork-open-problem-library/
WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.
Removing temporary files.
Done!
