| mysql throws access denied error but report still runs [message #478807] |
Fri, 07 August 2009 01:52  |
Eclipse User |
|
|
|
Originally posted by: ben.voicelogic.com.au
Hi All,
I have a report that I have run from my desktop in dev phase, deployed
to a jboss server in a dev environment and run successfully against a
dev database and how now finally deployed to a prod jboss server against
the prod database.
I am using a jndi connection however this issue happens with direct
access as well.
What is happening is that the report is running successfully returning
all teh data that it should, however there are a bunch of Mysql errors
being thrown each time the report runs - the errors are along the lines
of connection refused errors and access denied errors.
the first line of a very long (repeating stack trace) is as follows:
org.jboss.resource.JBossResourceException: Could not create connection;
- nested throwable: (java.sql.SQLException: Access denied for user
'<user>'@'<dbserver>' (using password: YES))
The report only has 1 data source in it an as the report is returning
valid data the connection details are obviously correct. I am guessing
that the errors that are being thrown are due to Birt trying to access
some meta data or some other data that the given user does not have
access to - does this sound right?
If not, does anyone have any idea why I would be getting such errors but
still getting access to the report data?
If yes, does anyone know how to get rid of these errors without given
the report user cart blanche database access?
Environment is as follows:
Birt 2.5.0
Jboss 4.2.3
JDK Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_16-b02, mixed mode)
MySQL JDBC 5.1.5
MySQL 5.0.22
my data source config in the report is as follows:
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="<ds>-prod" id="6">
<property name="odaJndiName">java:<dsName></property>
<property name="odaUser"><uname></property>
<encrypted-property name="odaPassword"
encryptionID="base64"><pword></encrypted-property>
</oda-data-source>
</data-sources>
Cheers,
Ben
|
|
|
| Re: mysql throws access denied error but report still runs [message #479605 is a reply to message #478807] |
Tue, 11 August 2009 16:58  |
|
Ben,
Did you get this resolved? If not can you log a bug for it?
Jason
Ben Dinnerville wrote:
> Hi All,
>
> I have a report that I have run from my desktop in dev phase, deployed
> to a jboss server in a dev environment and run successfully against a
> dev database and how now finally deployed to a prod jboss server against
> the prod database.
>
> I am using a jndi connection however this issue happens with direct
> access as well.
>
> What is happening is that the report is running successfully returning
> all teh data that it should, however there are a bunch of Mysql errors
> being thrown each time the report runs - the errors are along the lines
> of connection refused errors and access denied errors.
>
> the first line of a very long (repeating stack trace) is as follows:
>
> org.jboss.resource.JBossResourceException: Could not create connection;
> - nested throwable: (java.sql.SQLException: Access denied for user
> '<user>'@'<dbserver>' (using password: YES))
>
> The report only has 1 data source in it an as the report is returning
> valid data the connection details are obviously correct. I am guessing
> that the errors that are being thrown are due to Birt trying to access
> some meta data or some other data that the given user does not have
> access to - does this sound right?
>
> If not, does anyone have any idea why I would be getting such errors but
> still getting access to the report data?
>
> If yes, does anyone know how to get rid of these errors without given
> the report user cart blanche database access?
>
> Environment is as follows:
>
> Birt 2.5.0
> Jboss 4.2.3
> JDK Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_16-b02, mixed mode)
> MySQL JDBC 5.1.5
> MySQL 5.0.22
>
> my data source config in the report is as follows:
>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="<ds>-prod"
> id="6">
> <property name="odaJndiName">java:<dsName></property>
> <property name="odaUser"><uname></property>
> <encrypted-property name="odaPassword"
> encryptionID="base64"><pword></encrypted-property>
> </oda-data-source>
> </data-sources>
>
> Cheers,
>
> Ben
|
|
|
|
Powered by
FUDForum. Page generated in 0.03547 seconds
] 
Search
Help
Register
Login
Home
