Forum archive 2000-2006

Michael Schulte - PostgreSQL problem

Michael Schulte - PostgreSQL problem

by Arnold Pizer -
Number of replies: 0
inactiveTopicPostgreSQL problem topic started 11/30/2004; 2:45:13 PM
last post 11/30/2004; 4:32:47 PM
userMichael Schulte - PostgreSQL problem  blueArrow
11/30/2004; 2:45:13 PM (reads: 750, responses: 1)
I am having problems in making Webwork use a PostgreSQL database.

I type: addcourse admin --sql-layout=sql_single --users=adminClasslist.lst --professors=admin (as in the Course Admin Manual).

I get the error: DBI connect('webwork','webworkWrite',...) failed: ERROR: Missing '=' after 'webwork' in conninfo at /students/webwork/Webwork2.1/lib/WeBWorK/Utils/CourseManagement/sql_single.pm line 150 sql_single: failed to connect to DBI source 'dbi:Pg:webwork': ERROR: Missing '=' after 'webwork' in conninfo

Any ideas?

<| Post or View Comments |>

userSam Hathaway - Re: PostgreSQL problem  blueArrow
11/30/2004; 4:32:47 PM (reads: 959, responses: 0)
It looks like the DBI DSN should be dbi:Pg:dbname=webwork rather than dbi:Pg:webwork. In webwork, this is set in database.conf:

 

my $sqlSingleDBISource = "dbi:Pg:dbname=webwork";

See also http://search.cpan.org/~rudy/DBD-Pg-1.32/Pg.pm#DBI_Class_Methods

Please let us know if you run into further problems. We haven't tested WeBWorK with Postgres, but we're glad to help you get it working if there are problems. We can even give you patches if the source doe needs modifying.

<| Post or View Comments |>