sustain_1

Hello ! I am using JasperServer 7.1.1 (Build: 20190116_0754) CE. I have russian locale tuned there (ru_RU). After deleting export in XLS for users (like described here https://community.jaspersoft.com/wiki/how-remove-xls-exporter-jasperreports-server-611) - i comment 2 strings in WEB-INFflowsviewReportBeans.xml and restart server. Now all localization work fine except dates. For example months are displayed in reports in English and numbers of weekdays counts from sunday instead of monday. Before this changes russian locale worked good. Help me please how can I solve this problem ?

Hi, you have to do this https://community.jaspersoft.com/documentation/tibco-jasperreports-server-authentication-cookbook/v720/external-database

Hello ! I have well working external LDAP authentication on Jasper Server 7.1.1, but i need else to map roles from Oracle database to internal Jasper database. I can do it with authentication from external DB like described here: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-authentication-cookbook/v71/external-database but in this case i lost my LDAP authorization. Tell me please can i use both methods - take users from LDAP for authentication and after this take roles from my Oracle DB ? If its impossible maybe somebody already solved this problem and give me advice how i can do it ?

Hello ! I want to get username (like full name) from my database via external authentication. But number and order of columns in query is fixed - name="usersByUsernameQuery" - so i take only username(User ID) and password. But i need to add full name in User name pole of JasperServer instead User ID. How can I do it ? here is my bean: <bean id="externalUserDetailsService" class="com.jaspersoft.jasperserver.api.security.externalAuth.db.ExternalJDBCUserDetailsService"> <property name="dataSource" ref="externalDataSource"/> <property name="usersByUsernameQuery" value="SELECT u.JR_USER, u.JR_PWD, 1 FROM JASPER_USERS u WHERE u.JR_USER = ?"/> <property name="authoritiesByUsernameQuery" value="SELECT u.JR_USER, u.JR_ROLE FROM JASPER_USERS u WHERE u.JR_USER = ?"/> </bean> thanks for help.

Hello, I am trying to add external users authentication from Oracle database. Current JasperServer (7.1.0) database is Postgres (Community Edition). In /WEB-INF/applicationContext-externalAuth-db.xml file i write like this: <bean id="externalDataSource" class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.jdbc.JSDriverManagerDataSource"> <property name="driverClassName" value="${external.jdbc.driverClassName}"/> <property name="url" value="${external.jdbc.url}"/> <property name="username" value="${external.jdbc.username}"/> <property name="password" value="${external.jdbc.password}"/> </bean> and in default_master.properties i have: external.jdbcDriverClass=oracle.jdbc.OracleDriver external.jdbcUrl=jdbc:oracle:thin:@host:1521:SID external.dbUsername=uname external.dbPassword=password After server restarts i have status 404 not found in browser. And in jasperserver.log file i see this error: ERROR ContextLoader,localhost-startStop-1:331 - Context initialization failed org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'externalDataSource' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-db.xml]: Could not resolve placeholder 'external.jdbcDriverClass' in string value "${external.jdbcDriverClass}"; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'external.jdbcDriverClass' in string value "${external.jdbcDriverClass}" in my reports i am using the same Oracle connection and it works good. I try to change string on external.jdbcDriverClass=oracle.jdbc.driver.OracleDriver but it did't works too. Help me please, what can be wrong ?

Hello, I have big users database. I need to provide access to selected reports some users in JasperServer. Is it possible to pass some parameter before report execution ? Or maybe there is some event handler or something like trigger on starting report ? I do this with LoggedInUser parameter in report, but all users can open this report. Those who are denied access see the empty report, but I need to prevent them from seeing it. Please help me, how can I solve this problem ?

Thank you Hozawa. Tell me please, if i understand you correctly, is there ability (by tool develop) to add users from existing folder or file to JasperServer ?

Hello, i need to add a list (near 1000) of users to JasperServer. I guess its possible from import file setting, but i don't know how exactly to do this. Please help.