sjongenelen

Hmm, so to work around this, i've replaced the default MySQL engine with a newer one, overwritten root user password with mysqladmin and thus gaining control over the database engine. howver, i hope this will not affect future update of JS wich perhaps use the root credentials....

i can confirm this works on MySQl 5.5.10 32bit CE with MS Windows Server 2008 64 bit: <property name="maxValue" column="[maxValue]" type="serializable"/>

unfortunately, no if i do this, JS wil create the role as a property of the user without the role actually existing.

Also, you should delete the old .bin files with the old drivers (if there is any) unfortunately i dont know how to debug; no logfiles in "C:\Program Files (x86)\jasperreports-server-4.0\apache-tomcat\logs" ?

I think you should place the driver in a different folder, dont have time to check it now but you might try to place it a bit 'higher' (@tomcat level, not webapp level) also, there are 2 'accepted' oracle url connection strings syntax's: jdbc:oracle:thin:[user/password]@[host][:port]:SID jdbc:oracle:thin:[user/password]@//[host][:port]/SID you might try those :) (source: http://www.herongyang.com/JDBC/Oracle-JDBC-Driver-Connection-URL.html)

nothing on this, anyone? No documentation on this and i dont want to waste a support call for this small question..!

I was wondering can i create a new user in the jasperserver database? Im using mysql and connection with jasperdb@localhost and the matching password.. i need this user so i can quickly query which reports use which SQL query so i can locate these reports and edit them! Code:CREATE USER 'readonly'@'%';GRANT USAGE ON *.* TO 'readonly'@'%' IDENTIFIED BY 'password';GRANT SELECT ON *.* TO 'readonly'@'%';GRANT SHOW DATABASES ON *.* TO 'readonly'@'%';GRANT SHOW VIEW ON *.* TO 'readonly'@'%';

Hi Guys, Installing JS4 at the moment, and trying to config the following: On user first authentication (LDAP in this case), add a role to his account. This seemed easily done, but i think im lacking syntax skills! I need to add the role 'public' in the organisation 'organization_1'. Although 'public' is an unique role name in my enviroment, it is still not added. I think i need to specify organisation / ROLE but i dont know how. P.s. logger says: WARN UserAuthorityServiceImpl,http-8080-1:878 - Updated user: username. Roles are now: public ROLE_USER Code:<bean id="mtUserAuthorityServiceTarget" class="com.jaspersoft.jasperserver.multipleTenancy.MTUserAuthorityServiceImpl"> <property name="sessionFactory" ref="sessionFactory"/> <property name="objectMappingFactory" ref="mappingResourceFactory"/> <property name="persistentClassFactory" ref="persistentMappings"/> <property name="profileAttributeService" ref="profileAttributeService"/> <property name="defaultInternalRoles"> <list> <value>ROLE_USER</value> <value>public</value> </list> </property> <property name="multiTenancyConfiguration"><ref bean="multiTenancyConfiguration"/></property> <property name="securityProvider"><ref local="tenantSecurityProvider"/></property> <property name="securityContextProvider"><ref bean="${bean.securityContextProvider}"/></property> <property name="tenantPersistenceResolver"><ref bean="${bean.hibernateTenantService}"/></property> <property name="userProcessors"> <list> <!-- For LDAP authentication --> <!-- ref bean="ldapExternalUserProcessor"/--> <ref bean="defaultExternalUserProcessor"/> </list> </property> <property name="auditContext" ref="${bean.auditContext}"/> <property name="databaseCharactersEscapeResolver" ref="databaseCharactersEscapeResolver"/> </bean>

i used this config (mind the capitalizations!) <bean id="ldapContextSource" class="org.springframework.security.ldap.DefaultSpringSecurityContextSource"> <constructor-arg value="ldap://mydomain:389/ou=users,dc=mydomain,dc=com"/> <property name="userDn"><value>CN=Administrator,CN=Users,DC=somecomp,DC=com</value></property> <property name="password"><value>passwordhere</value></property> <property name="referral"><value>follow</value></property> </bean> this works for a 2003 forest (in my case) also, i've read that some users experience more succes with a java naming referral like: <property name="referral" value="follow"></property>

Thanks for your note. Although this does not count the number of usages, it will show me when the report has last been opened - which will tell me if the report has been used!

This is not possible at the moment in JS itself. You could try to do it through the JS database though.. good luck with that :/

My best guess is to make a subreport in the main report. When the thumbnail is clicked the subreport reloads.. otherwhise just use drilldown to new reports p.s. you can set open new page in a frame using hyperlink targets.. no experience with that though

you could try and use dashboards. I dont think your request is possible

this problem has been posted on this forum several times as well :)

well, when you purchase PRO edition, you can get real support calls and also they can engineer custom user imports (quite expensive tbh). I've been running 3.5 pro in production (with LDAP) for 1.5 years now - very stable!