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.

Hi, I am using my JasperServer in many networks. When I change network i also cannot have access to files stored on server during time with other ip. Is there any way to have the same content, despite of another ip-address?

Hi I want to make reports about vulnerabilities on my computer during year something like that: Time period[months ago]121110987654321Vulnerabilities????????????I have good query : SELECT sum(vulnerabilities) FROM fact_all_date WHERE now()-fact_all_date.day < INTERVAL 'in month' but now i have problem how to change query to include "Time period" in query for every field with question mark. Any ideas?

Hi, in reference to JasperReports-Server-Security-Guide.pdf I should edit some java files. But I have jasperserver-war only in .jar file, so I am only able to extract .class file. How to do steps before steps mentioned in manual?

Hello I am unable to make SSL connection. I've made my keystore and edit server.xml like this: But when i try to access https://localhost.com:8443/jasperserver my web browser says that "The server at localhost.com is taking too long to respond". What can be the issue? Jasperserver without SSL works properly.

Here is error from logs: 2017-08-24 10:31:22,849 ERROR AsyncJasperPrintAccessor,pool-4-thread-2:321 - Er$ net.sf.jasperreports.engine.JRException: Byte data not found at: C:Usersroot$ at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(Reposi$ at net.sf.jasperreports.renderers.util.RendererUtil.getNonLazyRenderabl$ at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillIma$ at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.ja$ at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRF$ at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java$ at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillFixedBand(JRVe$ at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageFooter(JRV$ at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastF$ at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVert$ at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVe$ at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerti$ at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java$ at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseF$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHa$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor$ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecuto$ at java.lang.Thread.run(Thread.java:745) 2017-08-24 10:31:22,891 ERROR ErrorPageHandlerAction,http-nio-8080-exec-4:118 -$ com.jaspersoft.jasperserver.api.JSException: Error filling report Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFill$ at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseF$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHa$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.En$ at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor$ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecuto$ at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: Byte data not found at: C:$ at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(Reposi$ at net.sf.jasperreports.renderers.util.RendererUtil.getNonLazyRenderabl$ at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillIma$ at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.ja$

Hello I have problems why I run report on server. Connection to data source is working properly. I have iReport and JasperServer on other virtual machines, but connection to remote database looks the same. Generating report in iReport works properly. Do anybody know what can be the issue?