wszystkielogizajete

Hi, I am struggling with running ./ctlstript.sh as a non root user on my centos, because it says it requires root privilenges. I've changed permissions to jasper folder with command "chown jasperadm jasperrepost-server-cp-6.4.2 -R, but it does not work. How can I run apache-tomcat bundled with jasper as non root user? Greetings, Piotr

Hi, I've read https://community.jaspersoft.com/documentation/tibco-jasperreports-server-community-project-upgrade-guide/v71/upgrading-64-71-0#upgrade-with-sql-script_3648109512_1116632 instruction and managed to run ./js-upgrade-samedb-ce.sh script. Unfortunately, I am not able to see any changes in my jasperserver. What am I doing wrong? I have provided sample output from script: Running JasperReports Server upgrade script at 2018-07-24_05-46 ---------------------------------------------------------------------- ---------------------------------------------------------------------- Using ANT_OPTS: -Dnet.sf.ehcache.disabled=true -Xms512m -Xmx2048m ---------------------------------------------------------------------- [default] Running upgrade-minimal-ce Ant task. ---------------------------------------------------------------------- Buildfile: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build.xml [echo] Filtering properties (cleaning out blank spaces) [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xml set-minimal-mode: gen-config: [echo] Regen config files if they have already been cleaned: [echo] currentConf= /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands test-ce-all-props: [echo] Checking properties: [echo] dbType=postgresql [echo] dbHost=127.0.0.1 [echo] dbUsername=postgres [echo] dbPassword=********** [echo] dbPort=5432 [echo] js.dbName=jasperserver [echo] sugarcrm.dbName=sugarcrm [echo] foodmart.dbName=foodmart [echo] webAppNameCE=jasperserver [echo] appServerType=skipAppServerCheck [echo] appServerDir=/opt/jasperreports-server-cp-6.4.0/apache-tomcat check-dbtype-for-upgrade-ce: do-install-upgrade-test: [echo] Checking DBMS host and port: [echo] About to validate port: 127.0.0.1:5432 [echo] Port 5432 is OK [echo] Done validating port: 127.0.0.1:5432 [echo] Validating administrative database connection at jdbc:postgresql://127.0.0.1:5432/postgres. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [echo] Validating JasperServer database connection at jdbc:postgresql://127.0.0.1:5432/jasperserver. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK do-pre-upgrade-test: pre-upgrade-test-ce: upgrade-js-ce-db-minimal: upgrade-6.4-7.1-ce: [echo] [echo] currentSqlDir = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql [echo] dbType = postgresql [echo] [echo] run script: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-6.4.0-7.1.0-ce.sql [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Executing resource: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-6.4.0-7.1.0-ce.sql [advanced-sql] 0 rows affected [advanced-sql] 0 rows affected [advanced-sql] 2 of 2 SQL statements executed successfully import-minimal-for-upgrade-ce: [echo] [echo] Property values (in install.xml): [echo] archiveArg = --input-zip=/opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/export/js-catalog-postgresql-minimal-ce.zip [echo] dbType = postgresql [echo] jdbcJar = postgresql-9.4-1210.jdbc41.jar [echo] currentConf = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default [echo] importExportConfig = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/ieCe [echo] [echo] Validating JasperServer database connection at jdbc:postgresql://127.0.0.1:5432/jasperserver. Phase: [import-export-test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [java] First resource path:/opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/ieCe/applicationContext-azure-sql-datasource.xml [...] [java] -- JasperServer: TeiidCache preparedplan shutdown called. This normal shutdown operation. [java] -- JasperServer: TeiidCache resultset-repl shutdown called. This normal shutdown operation. [java] -- JasperServer: TeiidCache resultset shutdown called. This normal shutdown operation. [java] -- JasperServer: ProfileAttributeCacheImpl shutdown called. This normal shutdown operation. deploy-webapp-ce-if-needed: do-deploy-webapp-if-needed: [echo] Deployment is skipped because appServerType is set to skipAppServerCheck upgrade-minimal-ce: [echo] Upgrade successfully completed!

Hello, I have changed default user passwords both for postgress and jasperdb users. Unfortunately, my JasperServer web application cannot start now. Can u guys tell me where are config files, where I need to change default passwords for new one to make JasperServer run again.

I have such a big report that is too big for even csv. Thats why i need to split it in few smaller.

But do u mean doing so in sql query? Or is it possible somewhere during xml file creation?

How can I do so?:>

Hello, when I generate reports in JasperServer I have too many records for Excel to handle. Is it possible to split report in two files in that case?

Hello, when I copy applicationcontext-externalAuth-LDAP.xml file to my WEB-INF directory I am unable to use default jasperadmin account. How can I change jasperserver configuration to use both active directory and standard authentication for internal jasper accounts?

Hi all, I'm configuring jasper report server with exsisting active derectory ldap.When I'm running jasper server there is a error in log related to userSearch bean. Error :cvc-complex-type.2.4.d: Invalid content was found starting with element 'span'. No child element is expected at this point. My configurations are here and logs said that I have error with third part of it: </bean><bean id="ldapContextSource" class="org.springframework.security.ldap.DefaultSpringSecurityContextSource"> <constructor-arg value="ldap://hostname:389/dc=ADexample,dc=com"/></bean> <bean id="userSearch" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch"> <constructor-arg index="0"><value><span class="_Override" >cn=Users</span></value></constructor-arg> <constructor-arg index="1"><value><span class="_Override" >(sAMAccountName={0})</span></value></constructor-arg> <constructor-arg index="2"><ref local="ldapContextSource"/></constructor-arg> <property name="searchSubtree"><value>true</value></property></bean> Do u know how to fix it?

Hello, I want to use external authentication with active directory. But when I try to authenticate I have following error: 2018-03-09 06:35:07,071 ERROR EncryptionAuthenticationProcessingFilter,http-nio-8080-exec-10:218 - An internal error occurred while trying to authenticate the user. org.springframework.security.authentication.InternalAuthenticationServiceException: Uncategorized exception occured during LDAP processing; nested exception is javax.naming.NamingException: [LDAP: error code 1 - 000004DC: LdapErr: DSID-0C0907C2, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v2580^@]; remaining name '/' Do you know what can be the problem?

Hello I have an SQL query, which gives a lot of text in one row, and only a small string in another. Can I somehow adjust size of cells to the result of query? It is not looking good if I have big cells with only a few characters....

Hello, I want to delete all domcat default pages. In order to do so I moved to directoryy apache-tomcat/webapps and remover everyting but jasperserver. Then I copy jasperserver to ROOT directory. cp -r jasperserver ROOT. Unfortunately, when i try to access localhost:8080 my web browser says it isnt available. Is it possible to make jasperserver default page when i get localhost:8080?

Hello, I made report with iReport program which uses collection type parameter. Unfortunately, Jasper Server does not have such parameter in available input type. How can I make report on JasperServer with something like collection type parameter? Greetings, Piotr

Hello, when I ryn my report on JaspeServer everything looks fine. But when i try to export as a PDF some letters are dissapearing - its special polish letters like ś, ć, ó. Is there any way to fix that?

Hello, I have report, written in iReport which depends from 2 parameters -> BEGIN_PIEROD_DATE and END_PERIOD_DATE. How can i configure my JasperServer to use these parameters? I've created two InputControls with same name as parametres from iReport. @EDIT I solved my problem. You need to simply add InputControl to your jasper report file, and if the name is the same as parameter it works fine.