** Using WeBWorK **

Everything up through configuring apache seems to be ok with one exception. I have never been able to get server-info to work on any installation I've tried. Other than that, everything seems ok.

Then I tried to create the admin course. It seemed to run ok, but when I try to go to the course page, I get the following errors:

Warning messages

* DBI connect('webwork_admin','webworkRead',...) failed: Access denied for user: '@localhost' to database 'webwork_admin' at /opt/webwork2/lib/WeBWorK/DB/Driver/SQL.pm line 39

Error messages

error instantiating DB schema WeBWorK::DB::Schema::SQL for table problem_user: Can't call method "STYLE" without a package or object reference at /opt/webwork2/lib/WeBWorK/DB/Schema.pm line 81. at /opt/webwork2/lib/WeBWorK.pm line 209

I saw that others had this issue, so I ran a wwcvs update -r rel-2-0-1, but it did not resolve the problem. I suspect that there is something wrong with the user but I have no idea where to look for the problem, or how to fix it.

Any ideas? Thanks in advance.

Mark

<| Post or View Comments |>

the server-info is just for information. One problem is that you may need to set up the permissions for the service properly in the httpd.conf file. Normally this service is locked down pretty tight, and you may only be able to use to from certain domains. In any case if everything else seems to be working on the server, you don't need it. It's for debugging during the installation process.

I'm not sure what you mean by "go to course page" -- which button do you click on? In the 2-0-patches version (in the CVS) clicking on "Homework sets" will result in no action. I believe in an earlier version an error in accessing the mySQL database was reported.

In any case the admin course is not a normal course -- it is used only for setting up other courses using "add course" at the top (also "delete course"). You can add students to this course, but only students who are given permission levels of 10 (and are hence professors) will be able to see anything at all in this course. These are the people who will be allowed to create new courses. there is no point in adding problems sets to the admin course.

Once you've created another course (test_course, say) using the "add course" facility you will have a normal course that you can add homework sets and students to. I suggest creating a gdbm course first. If that works create a sql course and check your connections with mysql.

Hope this helps.

-- Mike

<| Post or View Comments |>

I mean that when I go to myserver/webwork2/admin/ the errors above show up. It doesn't matter if I type the address in directly or if I click on the link from myhost/webwork2/ I'm not actually trying anything in the admin course, since I'm not getting anything from the admin course, not even a login screen.

I suspect that the user name is a problem since the errror above has it as "@localhost", but I don't know how to fix that. I don't currently have gdbm installed, but I can put it on if need be. Is it possible to create an admin course using gdbm?

<| Post or View Comments |>

I suggest looking at the contents of conf/database.conf (and possibly conf/global.conf) for the settings related to connecting to the mySQL database. These involve a "read" user a "write" user and their passwords.

You also might want to connect directly to the mysql database from the command line and making sure that the users are defined in the database -- you also might like to reset their passwords, just to make sure that the connection between webwork and mysql is compatible.

-- Mike

<| Post or View Comments |>

I don't have access to the machine at the moment, but I will look at that as soon as I can.

I'm not very SQL literate, so I'll ask: how do I go about checking if the users are defined in the database? Also, what should the database be called? After running the addcourse script, there were only two databases listed when I did "show databases" in sql. One was called test and the other was (I think) "mySQL".

Thanks again for the help. If things don't clear up, I will try creating a GDBM version of WW2.0

Mark

<| Post or View Comments |>

<| Post or View Comments |>

We had a similiar problem when installing WeBWorK2.01. We got around this problem by defining webwork_admin, webworkREAD, webworkWrite as users. In the SQL database we grant privilleges on webwork_admin to webworkREAD@localhost.

In mysql we typed: mysql> use mysql mysql>grant select on webwork_admin.* to webworkRead@localhost; mysql>grant selcet, insert, update, delete, drop, create on webwork_admin.* webworkWrite@localhost;

Now that we have the Admin course but when we tried to add courses named MAT111, another problem showed up, saying:

Failed to create the course directory /opt/webwork2/courses/MAT111: Permission denied

The course database was not created and this message shows up regardless of using sql or gdbm. We got stuck here, where should we check for the permission?

Jun

<| Post or View Comments |>

Failed to create the course directory /opt/webwork2/courses/MAT111: Permission denied

Check the permissions on /opt/webwork2/courses. The web server should have permission to write to this directory.

<| Post or View Comments |>

drwxr-xr-x 3 root root 4096 Aug 12 11:42 bin
drwxrwsr-x 5 root root 4096 Aug 16 15:01 conf
drwxrwsr-x 6 root wwserver 4096 Aug 23 12:25 courses
drwxr-xr-x 2 root root 4096 Aug 11 14:22 CVS
drwxrwsr-x 4 root wwserver 4096 Aug 23 11:50 DATA
drwxr-xr-x 5 root root 4096 Aug 11 14:22 doc
drwxrwsr-x 8 root root 4096 Aug 11 14:22 htdocs
-rw-r--r-- 1 root wwserver 0 Aug 12 13:39 index,hrml
-rw-r--r-- 1 root wwserver 0 Aug 12 13:39 index.html
drwxr-xr-x 5 root root 4096 Aug 11 14:22 lib
-rw-r--r-- 1 root root 1529 Jul 23 12:48 LICENSE
drwxrwsr-x 3 root wwserver 4096 Aug 11 14:22 logs
-rw-r--r-- 1 root wwserver 0 Aug 16 15:36 nohup.out
-rw-r--r-- 1 root root 2924 Jul 23 12:48 README
drwxrwsr-x 3 root wwserver 4096 Aug 11 14:22 tmp

Thanks,

Jun

<| Post or View Comments |>