It doesn't look like the problem is there. In the error message it says "User
does not have CONNECT privilege". Could that be the clue?
Postgres- does have Login Roles "dspace" user and the database is owned by
"dspace"
They look the same on both old and new servers. One little thing... database
properties the property "ACL" on the new server (with dspace 1.5.2) has {}
and the older server (with dspace 1.5.1) it is blank. Both have privileges at
public.
DSpace.cfg looks good too.
##### Database settings #####
# Database name ("oracle", or "postgres")
#db.name = postgres
db.name = postgres
#db.name = oracle
# URL for connecting to database
#db.url = jdbc:postgresql://dspacedb.snhu.edu:5432/dspace
db.url = jdbc:postgresql://localhost:5432/dspace
# JDBC Driver
#db.driver = org.postgresql.Driver
db.driver = org.postgresql.Driver
# Database username and password
#db.username = dspace
#db.password = dspace
db.username = dspace
db.password = dspace
-----Original Message-----
From: Allen Lam [mailto:[email protected]]
Sent: Tuesday, November 10, 2009 8:52 PM
To: [email protected]
Subject: Re: [Dspace-tech] FW: help windows installation
Hi Susan,
Check these points:
Find in dspace.cfg, what username you are using to login to postgres?
Open pgAdminIII (provided by postgres) and check the Login Roles. Can
you find the username?
In pgAdminIII also check the properties of the "dspace" database. Who is
the owner?
Fix any conflicts that you discover.
Best,
Allen Lam.
HKU Hub Administrator, http://hub.hku.hk
Kantargis, Susan wrote:
>
> Hello,
>
> I've been relocation dspace to a new windows server and must have
> missed a step along the line.
>
> This message comes up when I bring \jspui up with tomcat:
>
> WARN org.dspace.jsp @
> anonymous:no_context:database_error:org.postgresql.util.PSQLException\colon;
> FATAL\colon; permission denied for database "dspace"
>
> Detail\colon; User does not have CONNECT privilege.
>
> org.postgresql.util.PSQLException: FATAL: permission denied for
> database "dspace"
>
> Detail: User does not have CONNECT privilege.
>
> Can someone please point to the right spot?
>
> *Sue Kantargis*
>
> Programmer Analyst
>
> *Department of Computing Resources** *
>
> Southern New Hampshire University
>
> 2500 North River Road
>
> Manchester, NH 03106
>
> *Phone:* 603-668-2211 ext. 2337
>
> *Fax:* 603-645-9775
>
>
> Please consider the environment before printing this e-mail.
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> ------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
