UsingWW: Lars Jensen - admin course with sql

$inactiveTopic$ admin course with sql_single

topic started 10/12/2004; 2:31:35 AM
last post 10/12/2004; 2:47:35 PM

$user$ Lars Jensen - admin course with sql_single $blueArrow$
10/12/2004; 2:31:35 AM (reads: 1058, responses: 3)

Hi,

How is the admin course created when using the sql_single db layout?

Is there a way to make a regular course into an admin course?

Thanks,

Lars.

<| Post or View Comments |>

$user$ Sam Hathaway - Re: admin course with sql_single $blueArrow$
10/12/2004; 10:03:02 AM (reads: 1277, responses: 0)

To create an sql_single-using admin course, do this:

addcouse admin --db-layout=sql_single --users=whatever/classlist.lst --professors=lars,whoever

You can't change another course into the admin course because you can't change the name of an existing course. (This might be possible in the future, however.)

<| Post or View Comments |>

$user$ Lars Jensen - Re: admin course with sql_single $blueArrow$
10/12/2004; 12:03:14 PM (reads: 1267, responses: 0)

Hi Sam,

Thanks for the reply. We aren't able to create an sql_single admin course. We can create a gdbm admin course, though. When trying to create a sql_single (regular) course we get lots of errors, like below. Do you know what we might be missing? All required software is installed correctly, according to check_modules.pl. We created a mysql database named webwork, and created users webworkRead and webworkWrite, with the appropriate rights, but no tables are being added to the webwork database when I attempt to create a sql_single course.

Thanks,

Lars.

# DBD::mysql::db selectrow_array failed: Table 'webwork.testsql6_user' doesn't exist at /opt/webwork2/lib/WeBWorK/DB/Schema/SQL.pm line 131.

# --- in WeBWorK::DB::Schema::SQL::exists called at line 985 of /opt/webwork2/lib/WeBWorK/DB.pm

# --- in WeBWorK::DB::addUser called at line 198 of /opt/webwork2/lib/WeBWorK/Utils/CourseManagement.pm

# --- in (eval) called at line 198 of /opt/webwork2/lib/WeBWorK/Utils/CourseManagement.pm

# --- in WeBWorK::Utils::CourseManagement::addCourse called at line 687 of /opt/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm

# --- in (eval) called at line 686 of /opt/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm

# --- in WeBWorK::ContentGenerator::CourseAdmin::do_add_course called at line 232 of /opt/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm

# --- in WeBWorK::ContentGenerator::CourseAdmin::body called at line 152 of /opt/webwork2/lib/WeBWorK/Template.pm

# --- in WeBWorK::Template::template called at line 411 of /opt/webwork2/lib/WeBWorK/ContentGenerator.pm

# --- in WeBWorK::ContentGenerator::content called at line 191 of /opt/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm

# --- in WeBWorK::ContentGenerator::CourseAdmin::content called at line 163 of /opt/webwork2/lib/WeBWorK/ContentGenerator.pm

# --- in WeBWorK::ContentGenerator::go called at line 276 of /opt/webwork2/lib/WeBWorK.pm

<| Post or View Comments |>

$user$ Sam Hathaway - Re: admin course with sql_single $blueArrow$
10/12/2004; 2:47:35 PM (reads: 1277, responses: 0)

I'm not sure what's going on there. Are there any warning messages that appear before the errors? Verify that the webworkWrite user has the appropriate privileges.

I created our webwork database like this:

$ mysql -u root -p mysql
Password: **
> CREATE DATABASE webwork;
> GRANT SELECT ON webwork.* TO webworkRead@localhost IDENTIFIED BY 'passwordRO';
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP ON webwork.* TO webworkWrite@localhost IDENTIFIED BY 'passwordRW';
> exit
Bye
$

<| Post or View Comments |>

Using WeBWorK

Forum archive 2000-2006

Lars Jensen - admin course with sql_single

Lars Jensen - admin course with sql_single