I went through all of the steps to upgrade the database in the 2.4 Installation manual. Two questions:
1) Do I use "localhost" or the name of my server in the sql command? (I've granted the privileges both ways.) Do I put quotes around the password? (I did.)
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, LOCK TABLES
ON webwork.* TO webworkWrite@localhost IDENTIFIED BY 'password';
2) When I used the command to update the database, it apparently went through all my existing courses and for each one it said the update failed because of an extra field in the database.
Since I could not get into the existing classes, I decided to see what happened if I made a new class. I used the addcourse command and did not get an error message. The test course showed up on the WeBWorK course page, but when I tried to access it I got a few more error messages for missing modules. I installed them and now when I try to get into the new class I get the following error message. By the way, I checked the webwork database in mysql and there were no tables created for the test course.
Base class package "SQL::Abstract" is empty.
(Perhaps you need to 'use' the module which defines that package first.)
at /opt/webwork/webwork2/lib/WeBWorK/DB/Utils/SQLAbstractIdentTrans.pm line 18
BEGIN failed--compilation aborted at /opt/webwork/webwork2/lib/WeBWorK/DB/Utils/SQLAbstractIdentTrans.pm line 18.
Compilation failed in require at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 31.
BEGIN failed--compilation aborted at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 31.
Compilation failed in require at (eval 100) line 3.
...propagated at /usr/local/lib/perl5/5.8.8/base.pm line 85.
BEGIN failed--compilation aborted at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/NonVersioned.pm line 18.
Compilation failed in require at (eval 99) line 1.
The information below can help locate the source of the problem.
in WeBWorK::Utils::runtime_use called at line 211 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm
in WeBWorK::DB::init_table called at line 200 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm
in WeBWorK::DB::init_table called at line 169 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm
in WeBWorK::DB::new called at line 286 of /opt/webwork/webwork2/lib/WeBWorK.pm