Date: Wed, 12 Oct 2011 09:17:59 -0700 From: Jason Helfman <jhelfman@e-e.com> To: "mholmes@kingventures.net" <mholmes@kingventures.net> Cc: ports@FreeBSD.org Subject: Re: FreeBSD Port: jasperserver-4.1.0 Message-ID: <20111012161759.GD37829@eggman.experts-exchange.com> In-Reply-To: <4E9586CC.9050606@kingventures.net> References: <4E9586CC.9050606@kingventures.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--XF85m9dhOBO43t/C Content-Type: multipart/mixed; boundary="CE+1k2dSO48ffgeK" Content-Disposition: inline --CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Oct 12, 2011 at 05:23:40AM -0700, mholmes@kingventures.net thus spa= ke: >Good morning, > >I have just installed jasperserver from ports on FreeBSD 8.0. Thank you >for the great job. Thanks very much. Happy to hear that someone is actually using it. :) >I'm not sure if I missed a step, but I have no data in the MySQL >jasperserver database and I cannot login. >Any help would be appreciated. I've attached the default package message for reference. Once the database is created: mysql> create database jasperserver character set utf8; You would need to load the following files in to the jasperserver database: /usr/local/tomcat5.5/webapps/jasperserver/js-create.ddl /usr/local/tomcat5.5/webapps/jasperserver/quartz.ddl /usr/local/tomcat5.5/webapps/jasperserver/jasperserverCreateDefaultSecurity= -mysql.sql After they are loaded in, and at least your tomcat/db server are started, y= ou should be able to login via the default username and password. (jasperadmin/jasperadmin) Insofar as data, most of our reports are connecting to an oracle system that already have existing data, however there are sample datasets to load that are in the distribution of the software. Here is the location of various datasets that can be loaded, but I have not tested any of this: $ cd /usr/ports/databases/jaspserserver $ make extract $ cd work/jasperreports-server-cp-4.1.0-src/jasperserver/buildomatic/instal= l_resources/sql Hope this helps! -jgh --=20 Jason Helfman System Administrator experts-exchange.com http://www.experts-exchange.com/M_4830110.html E4AD 7CF1 1396 27F6 79DD 4342 5E92 AD66 8C8C FBA5 --CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="jspkgmsg.txt" Content-Transfer-Encoding: quoted-printable To use this software package, you need to properly configure and enable an application and database server. These components need to be enabled, respectively, in /etc/rc.conf. The mysql schema and default security credentials have been copied to: - /usr/local/tomcat5.5/webapps/jasperserver/js-create.ddl - /usr/local/tomcat5.5/webapps/jasperserver/quartz.ddl=20 - /usr/local/tomcat5.5/webapps/jasperserver/upgrade-mysql-4.0.0-4.1.0-ce.sql and=20 - /usr/local/tomcat5.5/webapps/jasperserver/jasperserverCreateDefaultSecuri= ty-mysql.sql=20 Take necessary precautions before loading this sql into the jasperserver database. To create the jasperserver database, you may choose to run the following ta= rget against /work/a/ports/databases/jasperserver/work/jasperreports-server-cp-4.1.0-src= /jasperserver/buildomatic/js-ant =2E/js-ant create-js-db (Creates the jasperserver database) If the jasperserver database already exists, you may need to first drop the database: =2E/js-ant drop-js-db (Drops the jasperserver database) Alternatively, you may choose to use the following method to create a suita= ble database: (mysql) mysql> create database jasperserver character set utf8; (postgresql) create database jasperserver; --CE+1k2dSO48ffgeK-- --XF85m9dhOBO43t/C Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (FreeBSD) iF4EAREIAAYFAk6VvbcACgkQXpKtZoyM+6X5uwD+MDeZTqATk629JVnAmX9aGKXB ykmAYIBvBvuoSgx9nE4A/A6At+iYfNGHY4oh1lyFqv5xUV8m1oGILHrXRmlgD8fJ =TL1i -----END PGP SIGNATURE----- --XF85m9dhOBO43t/C--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20111012161759.GD37829>