Can not create Connection Exception

[vishal29bhp]

Code:

Dear all,

          I have upload some reports (more than 150) on jasperserver and try to run those report simultenously for 10 users but i got Can not Create Connection Exception Access Denied for root@localhost.



          Attached is Jasperserver log having BadPadding Exception also.

      

          How do i tune Jasperserver so that it will give proper response to everybody (more than 100 users or so).



          Is JNDI Datasource is the remeady Plz Give some Guidance on it.



Vishal.              

[swood]

Looks like you exceeded the maximum number of MySQL connections on the MySQL server. You need to increase that to go above 150.

 

The Cipher BadPaddingException is related to encrypted passwords. Does it stop people logging in?

 

 

Sherman

Jaspersoft

[vishal29bhp]

Thanks Sherman for the reply,

 

No , Jasperserver let evry body login .

Actually I am trying to test the jasperserver using

jmeter. I am running test for 10 simultenous users

with 60 seconds ramp up time.

I increased the no of connection on MYSQL server but

still this connection exception.

 

My reports are complex and having complex queries

but managed by proper indexing.does it the cause?

 

Plz Help.

Vishal

[swood]

Sorry - you do not have an issue with 150 connections - it is 150 reports.

Do any of the reports run? It looks like there is a bad connection definition on at least one of the reports - probably a password, but it could be MySQL configuration about allowing remote connections. Test all the data sources you have set up.

 

 

Sherman

Jaspersoft

[vishal29bhp]

Hi Sherman,

When i run the reports individually its runs properly. but the issue is

 

when i test it to run on jmeter it gives this connection BadPadding Exceptions .

 

Any Pointer

 

Vishal

[vishal29bhp]

I also tried with JNDI datasource but still facing the same problem.

 

Vishal

[swood]

The BadPadding exception means that JS could not decrypt passwords in the database and it was expecting to. I suspect that this means that the password for your JDBC report connection is probably wrong. I don't know why that is wrong - how did you create those passwords? Are you logging in as different users with JMeter?

 

 

Sherman

Jaspersoft

[mdaleiden]

I am also receiving this error. In my case, I have a set of reports deployed and schedules set up for each one that run the same report multiple times with different parameters. Each report is scheduled 1 - 2 minutes apart. Most of the reports run without issue, but one or two random ones fail with this crypto message. All reports are using the same datasource defined in the repository, so it is not an issue with the password being incorrect.

Please advise.

[lucianc]

mdaleiden
Wrote:

Please advise.

It's a bug.

It has been fixed in the JasperServer SVN at revision 17226, see the diff at http://jasperforge.org/scm/viewvc.php/trunk/jasperserver-api-impl/metadata/src/main/java/com/jaspersoft/jasperserver/api/metadata/common/service/impl/PasswordCipherer.java?root=jasperserver&r1=15889&r2=17226

Regards,

Lucian

[mdaleiden]

Is this fix included in the latest JasperServer release? If not, is there a patched JAR available?

[lucianc]

The fix was made after the last release.  There's no patched jar available either.  You can make your own by merging the change to the 3.7.0 sources.

[mdaleiden]

Is there a target date or timeframe for the next CE release of JasperServer? We need to assess whether it is worth the effort of building and deploying the patch or simply wait for the next release.

[lucianc]

The next "full" release will probably happen sometime in autumn.  There might be an intermadiary release until then, but as far as I know that hasn't been decided yet.

Regards,

Lucian