Subject: Server denies access to datasource error
- Next message: Shishir S. Bharathi: "Using GSI with ogsadai"
- Previous message: Shishir S. Bharathi: "ogsadai installation problems"
From: Shishir S. Bharathi (shishir@ISI.EDU)
Date: Jan 25, 2003 02:49
Hi,
I got the ogsadai installation working. Thanks Simon. Couldn't
figure out exactly what was wrong. The wsdd files looked fine. I
was flipping between tp5 and tp4. I'm now using only tp4, cleaned
things up and did a fresh deploy and it worked. (Not the way I'd have
liked to do it, but hey, to get it working was my first priority)
I'm trying to run some example scripts. I'm getting a
"server denies access to data source":
Error:
AxisFault
faultCode: {http://xml.apache.org/axis/}Server.generalException
faultString:
faultActor: null
faultDetail:
uk.org.ogsadai.wsdl.GridDataServiceSystemException:
<description>SystemException whilst running script: Server
configuration denies access to data sourceServer configuration denies
access to data sourcejava.sql.SQLException: Server configuration denies
access to data source</description>
exceptionName: uk.org.ogsadai.wsdl.GridDataServiceSystemException
stackTrace: AxisFault
faultCode: {http://xml.apache.org/axis/}Server.generalException
faultString:
faultActor: null
faultDetail:
exceptionName: uk.org.ogsadai.wsdl.GridDataServiceSystemException
at
uk.org.ogsadai.service.gds.GridDataServiceP2R1.performScript(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
I'm quite sure I don't have the database roles set up right. Here's what I
want to do:
I want to query for all databases with user=dbuser on my mysql
installation as the root user
Something like: (From a standard mysql installation)
$ mysql -p -u root mysql
> select * from db where user="dbuser";
How should I change the GridServiceFactoryConfig and ExampleDatabaseRoles
files (from the default ogsadai installation files ?)
Thanks again,
Shishir
--
- Next message: Shishir S. Bharathi: "Using GSI with ogsadai"
- Previous message: Shishir S. Bharathi: "ogsadai installation problems"