alex_barylski

What difference does that make if I am using root already with full privileges?

I believe the credentials are correct...I am using root to circumvent any issues with permissions. The connection must work as it manages to create and even import the test data but fails when populating the jasperserver database...it's a bean exception which makes me think I am missing some dependency that is not included in the WAR file or something???

1. I have ran js-install-ce.sh minimal|test|(empty) -- it still failed -- I tried the import because the install works fine up until it has to import the data into the existing (or non-existing database). 2. The database does exist...I have tried with and without...incase the install script needs to create it.

Thank you both for the reply. I am at my wits end trying to get this reporting system installed on Linux (was so much easier on Windows). I believe I am running the latest version of JS. I initially installed JDK 1.8 but after reading a few people had issues I (think) rolled back to 1.7. When I do java -version I get this: [/code]root@CADO-WEB:~/jasperreports-server-cp-5.6.0-bin/buildomatic# java -versionjava version "1.7.0_60"Java SE Runtime Environment (build 1.7.0_60-b19)Java HotSpot Server VM (build 24.60-b09, mixed mode)root@CADO-WEB:~/jasperreports-server-cp-5.6.0-bin/buildomatic# I have ran a js-install-ce.sh test here is the output:[/code]Writing to log file: logs/js-install-ce_2014-07-09_07-52-18572.log----------------------------------------------------------------------Running JasperReports Server install script at 2014-07-09_07-52--------------------------------------------------------------------------------------------------------------------------------------------Using ANT_OPTS: -Xms512m -Xmx2048m -XX:PermSize=128m----------------------------------------------------------------------[test]Running pre-install-test-ce Ant task.----------------------------------------------------------------------Java HotSpot Server VM warning: ignoring option PermSize=128m; support was removed in 8.0Buildfile: /root/jasperreports-server-cp-5.6.0-bin/buildomatic/build.xml [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] chkIfPackageManagedTomcat: CATALINA_HOME and CATALINA_BASE are BOTH set [echo] chkIfPackageManagedTomcat: CATALINA_HOME folder location exists [echo] chkIfPackageManagedTomcat: CATALINA_BASE folder location exists [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] chkIfPackageManagedTomcat: CATALINA_HOME and CATALINA_BASE are BOTH set [echo] chkIfPackageManagedTomcat: CATALINA_HOME folder location exists [echo] chkIfPackageManagedTomcat: CATALINA_BASE folder location exists [echo] tomcatPackageManaged IS SET [echo] Overriding fixedAppServerDir with value from CATALINA_BASE [echo] using settings file: /root/jasperreports-server-cp-5.6.0-bin/buildomatic/build_conf/default/maven_settings.xml test-ce-all-props: [echo] Checking properties: [echo] dbType=mysql [echo] dbHost=localhost [echo] dbUsername=root [echo] dbPassword=********** [echo] dbPort=3306 [echo] js.dbName=jasperserver [echo] sugarcrm.dbName=sugarcrm [echo] foodmart.dbName=foodmart [echo] webAppNameCE=jasperserver check-dbtype-ce: test-appServerType-ce: do-install-upgrade-test: [echo] Checking DBMS host and port: [echo] About to validate host: localhost [echo] Host localhost is OK [echo] Done validating host: localhost [echo] About to validate port: localhost:3306 [echo] Port 3306 is OK [echo] Done validating port: localhost:3306 [echo] Validating administrative database connection at jdbc:mysql://localhost:3306/mysql. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=mariadb-java-client [echo] maven.jdbc.version=1.1.2 [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:mysql://localhost:3306/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=mariadb-java-client [echo] maven.jdbc.version=1.1.2 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK do-pre-install-test: [echo] Validating FoodMart database connection at jdbc:mysql://localhost:3306/foodmart?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=mariadb-java-client [echo] maven.jdbc.version=1.1.2 [echo] Specified JDBC driver jar exists[advanced-sql] Failed to connect: Could not connect: Unknown database 'foodmart' [echo] Connection failed: [echo] SQLState: HY0000 [echo] Vendor specific error code: -1 [echo] Message: [Could not connect: Unknown database 'foodmart'] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step [echo] Validating SugarCRM database connection at jdbc:mysql://localhost:3306/sugarcrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=mariadb-java-client [echo] maven.jdbc.version=1.1.2 [echo] Specified JDBC driver jar exists[advanced-sql] Failed to connect: Could not connect: Unknown database 'sugarcrm' [echo] Connection failed: [echo] SQLState: HY0000 [echo] Vendor specific error code: -1 [echo] Message: [Could not connect: Unknown database 'sugarcrm'] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step pre-install-test-ce: BUILD SUCCESSFULTotal time: 1 secondChecking Ant return code: OK---------------------------------------------------------------------- Any way, I have included the full error response when doing either js-ant import-minimal-ce or js-install-ce.sh minimal as an attached error.log Hopefully I can resolve this soon before I lose any more hair :) Thanks again Alex

I have Googled everywhere and read some weird answers: http://community.jaspersoft.com/questions/825605/problem-updating-jasperserver-50-55 I am running as root, so I fail to see how not having write privs to 'tmp' is an issue. I have read of possible missing dependencies, /etc/host not having the right mappings, etc. None of these worked, nor made any sense. The identical error I am getting is in the first message by OP of the linked article above. I do not know how to reolve this issue and it's frustrating me to no end. Why are the beans throwing exceptions? Is there a missing mapping in the XML files or something???

I have successfully run: bash js-install-ce.sh test However when I run: bash js-install-ce.sh minimal I am confronted with some exceptional errors which I am unclear on how to resolve. The point at which the exceptions occur look something like: From all the Googling I have done it sounds as though I may be missing dependencies, the problem is, which one, where do I get it and how I associate it to make the install "just work" Any ideas or suggestions would be greatly appreciated.

I have googled to the end of the earth, stackoverflow and here...seems to be a common problem but nothing resolved my issues... JasperServer: Product Version: 4.7.0 Build: 20120815_1737 I am also using iReport 4.7.1 to build the reports and publish them to JS. I have managed to follow tutorials and get the report working when running locally under iReport, using both a local MySQL data source and the production data source which the reports that get pushed to JS will use. I am 100% confident the data source is correct and data exists and should be showing. 1. The first issue I had was trying to figure out how to resolve the subreport path when publishing the master report to the JS. This seems to have been corrected by relying on iReport publishing the sub-report for me as an item of "Resources" -- something which is not at all obvious when using the web-based control panel of JS. So lets assume this issue is resolved for now. 2. Now the sub-report comes up blank. I have tried every combination and thread I have found nothing works -- I am starting to get desperate as I have everyone sold on JS as an alternative to Crystal. <subreport isUsingCache="false" runToBottom="false"> <reportElement uuid="5e577ac9-2585-4f63-8c4b-52715a21373a" isPrintRepeatedValues="false" x="1" y="1" width="592" height="50" isRemoveLineWhenBlank="true"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["repo:WorkOrderRepairItems.jrxml"]]></subreportExpression> </subreport> I have changed the sub-report to a simple fixed query with a hardcoded ID to remove any variables. I can even run the sub-report independently -- at least from iReport -- the sub-report doesn't appear in JS web-based except as a resource. I have even tried changing the REPORT_CONNECTION to REPORT_DATA_SOURCE and Connection Type to "Use a data source connection" without any difference in results. I have Googled the depths of JS and iReport and I cannot find any article or resource on getting sub-reports to work from a server -- any assistance/explanation would be greatly appreciated. EDIT | Not sure how relevant it is but after reading the PDF JS Ultimate Guide 3 on REPORT_CONNECTION and REPORT_DATA_SOURCE these are the values which are shown: $P{REPORT_CONNECTION} org.apache.commons.dbcp.PoolableConnection@12b0097 $P{REPORT_DATA_SOURCE} net.sf.jasperreports.engine.JRResultSetDataSource@69468f Regards,Alex