Company dedicated to web development, graphic design, photography and web hosting.

Blog

1. Download JasperServer 3.7.0 Community Edition from the next address:
   
   • http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%203.7.0/
   
   
2. From this address you need to download two files:
   
   • jasperserver-ce-3.7.0-windows-installer.exe
   • JasperServerPortlet-3.7.0.war

1. Execute from command line the mysql console:
   
   C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql -u root -p
   The system will ask the password for root user. Suply it.
   
   
2. In the mysql console execute the next sql command:
   
   select * from information_schema.engines;
3. The InnoDB engine must be installed, you must see it listed. If not, you need to install it. Reinstall MySQL with this option selected.
   

1. Execute the file jasperserver-ce-3.7.0-windows-installer.exe.
   
   
2. Follow the steps and choose your own MySQL instance. Choose your local instance or another one where you want to install the data for your reports. Fill all the needed data with info from your machine.
   
   
3. Choose also your own tomcat. When you need to suply the folder, choose the one where you have installed your liferay.
   

1. We need to add some lines from:
   • ${LIFERAY_DIR}\tomcat-6.0.26\webapps\jasperserver\META-INF\context.xml
   to the file:
   • ${LIFERAY_DIR}\tomcat-6.0.26\conf\context.xml
   and the lines to add are:
   1234567891011121314151617

   <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"

       maxActive="100" maxIdle="30" maxWait="10000"

       username="jasperdb" password="password" driverClassName="com.mysql.jdbc.Driver"

       validationQuery="select 1" testOnBorrow="true"

       url="jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"/>

   <Resource name="jdbc/sugarcrm" auth="Container" type="javax.sql.DataSource"

       maxActive="100" maxIdle="30" maxWait="10000"

       username="jasperdb" password="password" driverClassName="com.mysql.jdbc.Driver"

       validationQuery="select 1" testOnBorrow="true"

       url="jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/sugarcrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"/>

   <Resource name="jdbc/foodmart" auth="Container" type="javax.sql.DataSource"

       maxActive="100" maxIdle="30" maxWait="10000"

       username="jasperdb" password="password" driverClassName="com.mysql.jdbc.Driver"

       validationQuery="select 1" testOnBorrow="true"

       url="jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/foodmart?autoReconnect=true&autoReconnectForPools=true"/>

1. Launch liferay portal with the script:
   
   ${LIFERAY_DIR}\tomcat-6.0.26\bin\startup.bat
2. When the portal is running, open the next url in your browser:
   • http://localhost:8080/jasperserver/
3. When the login screen appears, you can access there with user: jasperadmin and password: jasperadmin
   

1. Copy the file JasperServerPortlet-3.7.0.war to the folder ${LIFERAY_DIR}/deploy. Liferay must be running to perform hot deploy.
   
   
2. Do login with an administrator role user, for example the Test user.
   
   
3. Add the portlet to any page using the Add menu on the top left. Choose "More..." option and select the group JasperSoft. Add the JasperServer Portlet to the page.
   
   
4. After that the portlet will have problems to access to the server. In the next steps will configure the server access portlet.
   
   

1. Open the file
   • ${LIFERAY_DIR}\tomcat-6.0.26\webapps\JasperServerPortlet-3.7.0\WEB-INF\applicationContext-security.xml
   and uncomment the line 226, allowing secure access to the local ip address. (JasperServer requires secure access). Change the ip address if you have installed the server in another machine.
   
   
2. Open the file
   • ${LIFERAY_DIR}\tomcat-6.0.26\webapps\JasperServerPortlet-3.7.0\WEB-INF\portlet.xml
   and change the line 10, changing jasperserver-pro by jasperserver, because it's the community version.
   
   
3. Restart Liferay and you will see now the example reports (if you installed them in the wizard). If you want to see your own reports you need to publish in the server.