Installation

Missing Table Error for Admin Course

Re: Missing Table Error for Admin Course

by Harshal Patel -
Number of replies: 9
Hi Danny,

You're right! There were no tables. I deleted the admin directory and re-created it. I can see course administration and the admin course. I also changed the database host from localhost to our on-prem mySQL server. It's working.

Thank you so much for your assistance, this was a great help.

Now that webwork is running, when I try to check Latex packages using
/opt/webwork/webwork2/bin/check_latex
it gives the error below:
! LaTeX Error: File `amsart.cls' not found.

I tried a couple of steps found in support forums but they did not work. Would you know how can this be fixed?

Thanks again,
Harshal
In reply to Harshal Patel

Re: Missing Table Error for Admin Course

by Harshal Patel -
Hi Danny,

We can continue the converstation here regarding amsart.cls not found. When I run the whatprovides command, it shows this:

texlive-amscls-7:20180414-25.el8.noarch : AMS document classes for LaTeX
Repo : rhel-8-for-x86_64-appstream-rpms
Matched from:
Filename : /usr/share/texlive/texmf-dist/tex/latex/amscls/amsart.cls

How do I go about installing this?

Also, when I log in as admin to webwork and try to create a course, it does not create one and do not give an error either. It creates the associated user but not the course itself.

On the server, when I go to /opt/webwork/courses, I can see the courses. They're not visible on the Webwork website side. It seems like a permission issue. These courses are owned by apache. Admin course is owned by wwadmin (who is added to the apache group).

Thanks,
Harshal
In reply to Harshal Patel

Re: Missing Table Error for Admin Course

by Danny Glin -

It's bad form to pick up questions from another thread.  It makes it very hard for anyone else who experiences the same problem to find answers.

Reading the courses not showing up, do you mean that you don't see them on https://webwork.yourschool.edu/webwork2/?  It would be surprising if that was a permissions issue, since the apache user is the one that creates the course folder in /opt/webwork/courses, and is also the one that lists the contents of that folder in order to build the list of courses on the server.

If you go directly to https://webwork.yourschool.edu/webwork2/[coursename] (where [coursename] is the name of the course you created) what do you see?


In reply to Danny Glin

Re: Missing Table Error for Admin Course

by Harshal Patel -
Hi Danny,

I apologize. I have asked my question about amscls package in the original thread.

Regarding the courses issue, when I go to https://webwork.yourschool.edu/webwork2/[coursename], it shows me the login page and I can login as admin. So they're not visible on the main page but are being created.
In reply to Harshal Patel

Re: Missing Table Error for Admin Course

by Danny Glin -
Here are a couple of things to check:
  1. Make sure that there is not a file called "hide_directory" in the course directory.  This would cause the course to be deliberately hidden in the listing.
  2. Make sure that you have $database_host, $database_port and $database_name set in site.conf.  If you upgraded from a previous version of WeBWorK these may be missing, which has the potential to break the course listing.
In reply to Danny Glin

Re: Missing Table Error for Admin Course

by Harshal Patel -

Hi Danny,

Thank you for replying.

  1. I checked the course directory for all the courses in "/opt/webwork/courses" and there was no "hide_directory" file.
  2. Yes I have the details added in site.conf. $database_port value is kept as the default, 3306. We are using an on-prem database server at University so I have mentioned that in the $database_host and $database_name fields.
I will change the value of $database_host to localhost and create a webwork database locally to test if that makes a difference.

Harshal
In reply to Danny Glin

Re: Missing Table Error for Admin Course

by Harshal Patel -
Hi Danny,

I still cannot see the courses at the homepage. Any suggestions you can provide will be helpful?

Thank you!
Harshal
In reply to Harshal Patel

Re: Missing Table Error for Admin Course

by Peter Staab -

It seems like this thread has gotten away from the original question.  Can you submit a new post in the installation with you current issue?

In reply to Danny Glin

Re: Missing Table Error for Admin Course

by Harshal Patel -
Hi Danny,

Did you get a chance to look at my reply here and in the amscls package thread? I would appreciate if you can provide any input.

Thanks,
Harshal