triumdh

Thank you very much. I found the script in .ddl format and was looking for .sql and it is running.

Hi, After a fresh install, I cannot login with jasper admin and although there is a jasperserver database, it is empty. Does anyone know where i can find scripts to poulate the database. Thanks in advance.

SOLVED. FreeBSD by default uses a UNIX socket for mysql. If you creat a my.cfg file with a port number asignment and restart mysq the install completes successfully. Code:#cp /usr/local/share/mysql/my-large.cnf /usr/local/etc/my.cnf#/usr/local/etc/rc.d/mysql-server restart

Hi All, While installing jasperserver 4.1 on Freebsd 8.0 MySQL 5.0.9 I have the following error. I can connect to the database from command line and have checked username and password many times. Any help would be appreciated as I am supposed to evaluate BI software by the end of the week. Code:"Writing to log file: logs/js-install-ce_2011-10-10_15-50-10925.log----------------------------------------------------------------------Running JasperReports Server install script at 2011-10-10_15-50----------------------------------------------------------------------[default]Running install-normal-ce Ant task.----------------------------------------------------------------------Buildfile: /backup/jasperserver/buildomatic/build.xml [echo] Filtering properties (cleaning out blank spaces)gen-config: [echo] Regen config files if they have already been cleaned: [echo] currentConf= /backup/jasperserver/buildomatic/build_conf/defaulttest-ce-all-props: [echo] Checking properties: [echo] appServerType=tomcat6 [echo] appServerDir=/usr/local/apache-tomcat-6.0 [echo] dbType=mysql [echo] dbHost=localhost [echo] dbUsername=******** [echo] dbPassword=********** [echo] dbPort=3306 [echo] js.dbName=jasperserver [echo] sugarcrm.dbName=sugarcrm [echo] foodmart.dbName=foodmart [echo] webAppNameCE=jasperservercheck-dbtype-ce:test-appServerType-ce:do-pre-install-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:3306BUILD FAILED/backup/jasperserver/buildomatic/bin/validation.xml:281: The following error occurred while executing this line:/backup/jasperserver/buildomatic/bin/validation.xml:42: The following error occurred while executing this line:/backup/jasperserver/buildomatic/bin/validation.xml:91: Error: port 3306 is not reachable at host localhostTotal time: 1 secondChecking Ant return code: OK----------------------------------------------------------------------[*********** /usr/local/apache-tomcat-6.0/webapps/jasperserver/buildomatic]#"

Thank you for your reply. We are using non-standard port but we resolved it as a conflicting port issue.

Hi, I have installed jasperreports and started tomcat successfully. I go to url http://localhost:3306/jasperserver and it times out. where localhost is the name of my server. I have a rule in the firewall for port 3306 and context.xml has the following: url="jdbc:mysql://localhost:3306/jasperserver?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true" I am new to java and tomcat. Is there a tomecat log file? Any help would be appreciated.