senton9999

Hm, i checked the config file and as i wrote in my last posting i used the standard-config-file form the jasperintelligence-source-build-and-developer-guide. I turned all repos on and it doesn't work. It seems really strange to me :) greetings stefan

oh man, I'm really stupid! i didn't expect that it would be that easy! :) thx a lot, for your help! Do you have an idea why the iReport function for setting a new Datasource in the subreport-creation-dialog doesn't work? could it be a bug?? stefan

thx for your answer, but if i create the connection this way, he tries to connect to DB without password. When i write the following: java.sql.DriverManager.getConnection("jdbc:mysql://localhost/jasperserver", "root", "$P{dbPass}"), he recognize that i try to connect to db with password, but i'm not able to establish a connection because of: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) So i think, in quotes the Parameter is not correctly interpreted and without the function doens'nt recognize the password. Maybe a problem with the initialisation of the Parameters? thx, stefan

Hi everybody! I was just playing around with iReport. I tried to create a report with a very simple subreport. But the point i'd liked to try was to fill the masterreport with subreports-data from a diffrent datasource. So what i've done until now: I create a report and a suitable subreport. When i created the subreport i choose a diffrent datasource in the dialog-field which definitely works because in the query-browser of the subreport i get the correct results from DB. So, the masterreport and the subreport compile correct and produce a correct report-output. But when i try to run the masterreport with the subreport in it, filling of the report stops because of an sql-exception: java.sql.SQLException: Invalid object name 'jsuser'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) This is clear for me, because he is trying to use the master-report database connection to retrieve the data for the subreport. I really don't know where and how i should change this behaviour. I could solve this problem using a new Parameter creating a new JDBC:mysql connection to the correct database server and using this one in the subreports Connections Expression: $P{dbcon}. Param dbcon: java.sql.DriverManager.getConnection("jdbc:mysql://localhost/jasperserver", "username", "password") But i really don't like to put my username and password for my database hardcoded in the statement. So i tried to add a second parameter to the masterreport asking for the password and changed the dbcon as follows: java.sql.DriverManager.getConnection("jdbc:mysql://localhost/jasperserver", "username", "$P{dbPass}") When i fill report it throws an exception because the connection was refused. I guess it is not possible to use a parameter in a paramter according to their diffrent initialization? How can i get Subreports working with different datasources or how can i solve the problem with the parameter in my custom db-param. I apologize for the long posting, but i hope anybody can help me with this problem! stefan

To increase HeapSpace you have to set a new Environment Variable called JAVA_OPTS. When starting Tomcat he will use the new options you overtake with the variable. For linux do: export JAVA_OPTS="-Xmx256m" to increase heap space to 256Mb. Under Windows you only has to open the Tomcat Configuration and under JAVA you can set the MemoryValues as you prefer. Furhter you could try to create your report directly from iReport using the virtualizer properties. hth, stefan Post edited by: senton9999, at: 2006/09/21 08:07

Hi everybody! I tried to compile the jasperintelligence package from source for a couple of days. I checked out the latest version from the repository, installed maven2 und started compiling. I always got errors during build because of missing dependencies. I read here in the forum, that it is possible that the repositories are overloaded and temporarily not available. So, now im trying it for 2 days and i'm as far as on the first day. :( First i got an missing itext.jar which i could solve by installing it from command-line. But now i get a missing dependencie: [iNFO] The plugin 'org.apache.maven.plugins:maven-site-plugin' does not exist or no valid version could be found Ok, what i now about maven is, that it creates the plugins and dependencies by itself in [home]/.m2/repositories. So, i can definitly find the plugin in maven's repository! but it seems maven doesn't anymore. I'm using the standard settings.xml puplished in the source-code-developer-guide.pdf from jasperintel! has anybody some hints for me, how i can get jasperserver running from source? thx in advance Stefan

Anyone an idea?? thx in advance!

I implemented an authenticationprovider and an authentication service. The provider basically ignores all authentication checks as a first step and the service generates a user with predefined roles from the request. So far so good, the jasper server now accepts the login, also it writes that the user is authenticated but the forward to the main page still does not work, it still is stuck in the login page. The affect server log says: WARN LoggerListener,http-8080-Processor25:55 - Authentication event InteractiveAuthenticationSuccessEvent: lexow; details: org.acegisecurity.ui.WebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 127.0.0.1; SessionId: 9C0EB6BDE4FB115FFE87811F5BADD8BA 16:30:05,238 WARN UserAuthorityServiceImpl,http-8080-Processor25:500 - Added following external roles to: lexow ROLE_ANONYMOUS ROLE_USER 16:30:05,247 WARN UserAuthorityServiceImpl,http-8080-Processor25:536 - Updated user: lexow. Roles are now: ROLE_USER ROLE_ANONYMOUS ROLE_ADMINISTRATOR 16:30:05,292 WARN UserAuthorityServiceImpl,http-8080-Processor25:542 - Updated user: lexow. Roles are now: ROLE_USER ROLE_ANONYMOUS ROLE_ADMINISTRATOR Well as it seems the server accepts the authentication for the foreign datasources now, but does not do anything afterwards. Is it possible that i forgot to change something in the config-files? Attached are the two source files, the authentication provider and the user DetailService: (packed zip file due to upload restrictions) thx for every advice! [file name=provider-075fed1dfead4ed37e5c8139b07e342f.zip size=3041]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/provider-075fed1dfead4ed37e5c8139b07e342f.zip[/file]

First of all, thanks a lot for your advices. Now the steps a clear for me. I had a look at the pdf you recommended me and now i know, that i will have a lot of fun with building jasperserver from source ;) thx a lot! senton

First of all, thanks a lot for your advices. Now the steps a clear for me. I had a look at the pdf you recommended me and now i know, that i will have a lot of fun with building jasperserver from source ;) thx a lot! senton

Ok, first of all, thanks for the quick answer. I am in fact already one step further. I implemented an authenticationprovider and an authentication service. The provider basically ignores all authentication checks as a first step and the service generates a user with predefined roles from the request. So far so good, the jasper server now accepts the login, also it writes that the user is authenticated but the forward to the main page still does not work, it still is stuck in the login page. The affect server log says: WARN LoggerListener,http-8080-Processor25:55 - Authentication event InteractiveAuthenticationSuccessEvent: lexow; details: org.acegisecurity.ui.WebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 127.0.0.1; SessionId: 9C0EB6BDE4FB115FFE87811F5BADD8BA 16:30:05,238 WARN UserAuthorityServiceImpl,http-8080-Processor25:500 - Added following external roles to: lexow ROLE_ANONYMOUS ROLE_USER 16:30:05,247 WARN UserAuthorityServiceImpl,http-8080-Processor25:536 - Updated user: lexow. Roles are now: ROLE_USER ROLE_ANONYMOUS ROLE_ADMINISTRATOR 16:30:05,292 WARN UserAuthorityServiceImpl,http-8080-Processor25:542 - Updated user: lexow. Roles are now: ROLE_USER ROLE_ANONYMOUS ROLE_ADMINISTRATOR Well as it seems the server accepts the authentication for the foreign datasources now, but does not do anything afterwards. Attached are the two source files, the authentication provider and the user DetailService: (packed zip file due to upload restrictions) [file name=provider.zip size=3041]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/provider.zip[/file] Post edited by: senton9999, at: 2006/08/30 14:38

Hello, I am trying to move the jasper server user authentication to a custom database which already exists. Now the problem is I found out thanks to the documentation on this site and the acegi security documentation that the hook point is the security provider, respectively, UserDetailService dao. The problem is, if I replace the userdetail service with my implementation or a custom in memory implementation, with my own users in it, the authentication fails. The problem in memory might be related to unencrypted passwords in the config files, but I am not sure (I know security etc....) Is there an example on how to hook custom user databases into the jasper server or is this not possible unless the users exist already in the jasper server database?

hi everyone! i'm playing with the tutorial in the JasperServer-Developer-Guide. I've tried to follow the instructions, but i'm not sure, where exactly to safe the hello.html and the *.jsp for it. Further it is not clear for me, where i have to add the following lines of code: public ModelAndView hello(HttpServletRequest req, HttpServletResponse res) throws ServletException { return new ModelAndView("hello"); } Ok, you got me, i'm an absolute newbie, but i hope, anyone can help me. thx in advance. Senton