Home » Blogs » Anandharaj's blog

JasperServer Installation on Linux

Submitted by Anandharaj on Sat, 12/20/2008 - 15:58

This documents updated for JasperServer version 3.0.0

What is JasperServer

JasperServer is an open source business intelligence suite, built by the developers of JasperReports. It providing common services like security and metadata management, and the capability to easily add additional functionality.It also provides a Web and Web services based environment for reporting, data analysis (OLAP), and data integration.

What is JasperReports

JasperReports is a powerful open source Java reporting tool that has the ability to deliver rich content onto the screen, to the printer or into PDF, HTML, XLS, CSV and XML files. It is entirely written in Java and can be used in a variety of Java enabled applications, including J2EE or Web applications, to generate dynamic content. Its main purpose is to help creating page oriented, ready to print documents in a simple and flexible manner.

System requirements

In order to install JasperServer, you need to setup and configure the following application.

  • Apache Tomcat (with JDK1.6) - to be use as Java container
  • PostgreSQL - to be use to store JasperServer metadata files

Note: You may use JBoss and MySQL as an alternative to the above application.

How to install JasperServer?

JasperServer installation is very easy as no complicated process involved. In this guide, we will use the stand-alone WAR file distribution. Follow the step-by-step below to complete the installation.

A. Download and Unpack JasperServer file

The WAR file distribution comes in a ZIP file format. Please download the file from www.jasperforge.com. Once you have downloaded the WAR file distribution, you need to unpack it in order to access the contained files. Go to any working directory location to unpack the ZIP file.

user@server:~# unzip jasperserver-3.0-bin.zip
user@server:~# ls
docs  jasperserver.war  js-installer-version.txt  license.txt  releaseNotes.txt  samples  scripts

B. Setup the JasperServer database

  • Connect to the PostgreSQL database and create a user for JasperServer. In this document, we will use jasperadmin.
    postgres> CREATE USER jasperadmin PASSWORD '<password>';
  • Create a database for JasperServer with jasperadmin as owner and UTF-8 encoding
    postgres> CREATE DATABASE prd_jasperserver OWNER jasperadmin ENCODING 'UTF-8';
  • Connect to the JasperServer database
    postgres> \c prd_jasperserver
prd_jasperserver>
  • Create schema for main JasperServer tables. If you already have the database dump, please skip the steps below.
    prd_jasperserver> \i js-create-schema.sql
  • Create default security.
    prd_jasperserver> \i js-create-default-security.sql
  • Create trigger to delete the BLOB data if the reference records is deleted.
    prd_jasperserver> \i js-create-trigger.sql

C. Install/Deploy JasperServer into Tomcat

Because the JasperServer is stand-alone JSP files, the installation process involves dropping the files into the webapps directory of the Tomcat server. If you decided to use Jasper Server as default page, then you should put the files into ROOT directory.

user@server:~# cd $TOMCAT_ROOT/webapps
user@server:~# mkdir jasperserver
user@server:~# cd jasperserver/
user@server:~# jar xvf /home/user/jasperserver.war
user@server:~# ls
cal  externalResource.htm  images  index.htm  inputControl.htm  jpivot  META-INF  scripts  stylesheets  wcf  WEB-INF

Allocate static memory for Tomcat (Java). The default memory is not enough to extract data which is more than 1000 records (estimation only). To do this, edit the $TOMCAT_ROOT/bin/setclasspath.sh and add the following lines at the end of file.

JAVA_OPTS="$JAVA_OPTS -Xms128m -Xmx768m -XX:PermSize=32m -XX:MaxPermSize=128m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -XX:+CMSPermGenSweepingEnabled "

Note: -Xs128m is referring to minimum allocated memory wheres the -Xmx768m is maximum allocated memory. Change the value based on total memory installed on the machine.

D. Edit configuration files

There are few configuration files that need to edit. The list of files and its contents as below:

  • $JASPER_ROOT/META-INF/context.xml
    <Context path="/jasperserver" debug="5" reloadable="true" crossContext="true">            
    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="jasperadmin" password="mypassword" driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost:5432/prd_jasperserver" defaultAutoCommit="false"/>
</Context>
  • $JASPER_ROOT/WEB-INF/hibernate.properties
    # Property that determines the Hibernate dialect
metadata.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
metadata.hibernate.dataSource.jndiName=jdbc/jasperserver
  • $JASPER_ROOT/WEB-INF/js.mail.properties
    report.scheduler.mail.sender.host=smtp.raj2u.net
report.scheduler.mail.sender.username=user@raj2u.net
report.scheduler.mail.sender.password=password
report.scheduler.mail.sender.from=user@raj2u.net
report.scheduler.mail.sender.protocol=smtp
report.scheduler.mail.sender.port=25
  • $JASPER_ROOT/WEB-INF/js.quartz.properties
    org.quartz.scheduler.instanceName=JasperServerScheduler
org.quartz.threadPool.threadCount=20
org.quartz.threadPool.threadPriority=5
org.quartz.jobStore.misfireThreshold=180000
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
org.quartz.jobStore.tablePrefix=QRTZ_

Note: Don't forget to put all the required JDBC drivers in $TOMCAT_ROOT/lib or $TOMCAT_ROOT/common/lib

Now you may start the Tomcat and check the Tomcat's log file to see that there are not serious errors on the startup. If JasperServer started up properly, you should be able to login. Login by going to the following URL: http://host-address:port/jasperserver. The default login information is written in the js-create-default-security.sql file.

JasperServer Customization -> HOW-TO

A. How to enable password encryption?

File that need to be edited is $JASPER_ROOT/META-INF/WEB-INF/ApplicationContext-security.xml

In the definition of the "daoAuthenticationProvider" bean, there is a commented-out reference to the passwordEncoder bean. Uncomment the reference to passwordEncoder and this causes the passwordEncoder logic to be used. After removing the commenting characters the line should look like the following:

 <property name="passwordEncoder"><ref local="passwordEncoder"/></property>

Now under the “passwordEncoder” bean, the property "allowEncoding" should be changed from false to true so that it looks like the following:
 <property name="allowEncoding"><value>true</value></property>

Once the changes described above are made, encryption is enabled for the JasperServer application upon the next restart.

Note: If the password in database is in clear text, please update to "A34FAB575B828B127AC85B236B096043" as we are using encryption and the password in clear text will be "mypassword".

B. How to change the login page?

Edit the $JASPER_ROOT/WEB-INF/bundles/jasperserver_messages.properties and change your desired text as below.

#Welcome Login Page
LOGIN_WELCOME_OS=Welcome to JasperServer Reporting System!
 
# the following 2 strings belong to the same sentence
LOGIN_ONLINE_DEMO_PRE=JasperServer is an open source business intelligence suite ....
LOGIN_ONLINE_DEMO=JasperReports is a powerful open source Java reporting tool ...

Now, replace the $JASPER_ROOT/WEB-INF/jsp/login_welcome.jsp with the one i attached here. You may see the differents before replace. Once the file replaced, the login page will look like below.

Jasper Login

C. How to change report export parameters?

You need to edit $JASPER_ROOT/WEB-INF/applicationContext.xml and $JASPER_ROOT/WEB-INF/applicationContext-report-scheduling.xml. Look for "export parameters" section:

<!-- export parameters -->
 
    <bean id="xlsExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean">
        <property name="detectCellType" value="true"/>
        <property name="onePagePerSheet" value="false"/>
        <property name="removeEmptySpaceBetweenRows" value="false"/>
        <property name="removeEmptySpaceBetweenColumns" value="true"/>
        <property name="whitePageBackground" value="false"/>
        <property name="ignoreGraphics" value="false"/>
        <property name="collapseRowSpan" value="true"/>
        <property name="ignoreCellBorder" value="true"/>
        <property name="fontSizeFixEnabled" value="true"/>
        <property name="maximumRowsPerSheet" value="0"/>
        <property name="xlsFormatPatternsMap" ref="formatPatternsMap"/>
    </bean>
 
    <bean id="csvExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.CsvExportParametersBean">
        <property name="fieldDelimiter" value="|"/>
    </bean>
 
    <bean id="pdfExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.PdfExportParametersBean">
        <property name="localizedFontMap" ref="localePdfFontMap"/>
    </bean>
 
    <util:map id="formatPatternsMap">
        <!-- entry key="¤ #,##0.00" value="$ #,##0.00"/-->
    </util:map> 
 
    <!-- end export parameters -->

D. How to restrict report scheduling function?

You need to edit $JASPER_ROOT/WEB-INF/jsp/repository/repositoryExplorer.jsp and add the "authz:authorize ifAllGranted" to set the permission based on role. In example below, i have granted scheduling / run background to role "Administrator" only.

<authz:authorize ifAllGranted="ROLE_ADMINISTRATOR">
    <td style="cursor: pointer;" width='50' height='50' onClick='' id='schedule_td' align="center">
     <a href='#' class='normalpx' id='schedule_td_a'><img src="images/schedule_enabled.gif" border='0' title='<spring:message code="RM_BUTTON_SCHEDULE_REPORT" javaScriptEscape="true"/>' id='schedule' /></a>
    </td>
 
    <td style="cursor: pointer;" width='50' height='50' onClick='' id='send_output_td' align="center">  
     <a href='#' class='normalpx' id='send_output_td_a'><img src="images/send_output_enabled.gif" border='0' title='<spring:message code="RM_BUTTON_RUN_IN_BACKGROUND" javaScriptEscape="true"/>' id='send_output' /></a>
    </td>
</authz:authorize>

References

For more information on the installation guide and troubleshooting, please visit http://wwww.jasperforge.org

AttachmentSize
login_welcome.jsp (for jasperserver-3.0.0)3.66 KB
jasperserver-v3-schema.zip5.11 KB
#1Submitted by Bellon1882 (not verified) on Thu, 03/18/2010 - 12:41.

Very nice, I really liked it.

Very nice, I really liked it. Do you know of somewhere I can check out more about it?

#2Submitted by Anandharaj on Fri, 03/26/2010 - 08:46.

What kind of information

Hi, What kind of information you looking? The other source would the JasperSoft website itself.

#3Submitted by Sumesh (not verified) on Tue, 07/07/2009 - 20:34.

Fetch E-Mail address to report-scheduling->output->To text box

Hi,

How to fetch the email address stored in the user master to the report-scheduling->output->To (last page) page automatically? Also how can I put the user name to the Subject text box automatically?

Thanks in advance... please help me

Sumesh

#4Submitted by Sumesh (not verified) on Tue, 07/07/2009 - 20:29.

email address to the report-scheduling output

Hi,

How can I display the email address saved with the user master to the report-scheduling last page (output) automatically when the user comes to that page? Also how can I put the user name to the Subject box in the same page? Please reply as soon as possible...

Thank you in advance

Sumesh

#5Submitted by Anandharaj on Tue, 07/07/2009 - 22:37.

Dont understand

Hi,

Sorry, i dont really get your question. Could you elaborate a bit in details on wht you trying to achieve?

#6Submitted by Sri (not verified) on Thu, 06/18/2009 - 01:44.

Password Encryption in JasperServer 3.0

Hi,

Thanks so much for this information on Password encryption on JS 3.0. We want to upgrade to 3.5 just for password encryption, but this is great for now! (when I get it working)

I would like to know what the format should be after encryption and is it Base 64 encoding or some other kind of encryption?

Should it still follow the direct report URL format -
http://192.168.33.134:8080/jasperserver/flow.html?_flowId=viewReportFlow... Honda&Month=January&Year=2009&decorate=no&output=pdf&j_acegi_security_check?&j_username=encrypt&j_password=encrypt?

I tried it with this format, and i got a message - "Invalid credentials supplied.
Could not login to JasperServer."

So, I reverted the changes I made in the applicationContext-security.xml to enable password encryption. I am still not able to log in.

Can you please help me here?

Thanks,
Sri

#7Submitted by Sri (not verified) on Thu, 06/18/2009 - 02:43.

Ok. I admit. I dont think I

Ok. I admit. I dont think I understood everything the first time I read. I didnt follow the instructions completely in encrypting the password in the database.

It works fine now after i reverted the changes I made to appContext-security.xml.

Will try again now!

Thanks,
Sri

#8Submitted by Anandharaj on Thu, 06/18/2009 - 13:38.

Encryption enabled in JS3.5

Hi,

The encryption in JS 3.5 is enabled by default. So, there should not be any changes to the JS code except you need to update the password in database. Anyhow, please use http://www.raj2u.net/jasperserver-35-with-postgresql-83-on-linux.html for JS 3.5 related matter.

#9Submitted by Anonymous (not verified) on Tue, 06/16/2009 - 04:14.

Unlock JasperServer-pro

I have downloaded and installed jasperserver-pro evaluation version. now the trial is expired. is there a way to continue using the same installation by modifying any configuration files

#10Submitted by Anandharaj on Tue, 06/16/2009 - 08:13.

Need valid Key

Im afraid you need a valid license key to continue use the JS Pro version

#11Submitted by Manoj (not verified) on Mon, 05/11/2009 - 17:45.

Adding new fields to login page

Hi,
While I have been able to customize the JasperServer to use existing iBatis/Struts infrastructure and integrate authentication using existing app, there is one thorn. How can I change the login page to accept another field? Say I want user to enter Domain in addition to username and password. And use the three to authenticate and eventually show reports. I have been able to write my custom Dao that validates jasper user from my DB, but how do I get new attribute - domain to reach my Dao, so that it can be used to authenticate the user?

Thx

#12Submitted by Anandharaj on Mon, 05/11/2009 - 18:02.

Let me take a look and get

Let me take a look and get back to you... BTW, if you are using latest JS-3.5, please post your comment in http://www.raj2u.net/jasperserver-35-with-postgresql-83-on-linux.html

#13Submitted by Anonymous (not verified) on Thu, 04/30/2009 - 03:12.

Configure js.quartz.properties to use SSL / TLS

Thank you for the pointing me in the direction of js.quartz.properties vs. js.mail.properties. I believe everything is configured properly, however, I need to use Google Apps as the smtp server, and Google requires TLS. Here is a copy of the error:

Job: Missing Rates Batch (ID: 1)
Report unit: /Folder/ReportName
Quartz Job: ReportJobs.job_1
Quartz Trigger: ReportJobs.trigger_1_1
Exceptions:

An error occurred while sending job error notification.
org.springframework.mail.MailSendException; nested exception details (1) are:
Failed message 1:
com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. 26sm2415915qwa.46

at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388)
at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583)
at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:391)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:335)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:331)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:916)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:392)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

I'm trying to avoid modifying the quartz.1.5.1.jar file and hoping I could add a property in the quartz.properties to STARTTLS. You seem to have a strong handle on how Jasper operates and was hoping you could set me on the right path. Thanks in advance for any guidance you are willing to share.

#14Submitted by Anandharaj on Tue, 05/12/2009 - 12:19.

Refer to JasperServer How-To

Hi,

Please refer to http://www.raj2u.net/jasperserver-quick-how-to.html -> section H: What if SMTP server required authentication or TLS/SSL connection?

For the Gmail SMTP port, please try port 465 or 587. Later, please share the result.

#15Submitted by Anandharaj on Mon, 05/11/2009 - 18:03.

Google Mail Server

I never try use Google's mail server, but i remember there were some topics discussed about this in forum. Let me check it first

#16Submitted by Sridhar (not verified) on Thu, 03/19/2009 - 07:05.

JasperServer with weblogic

Hi All,

I am new to jasperserver and ireport. How to use jasperserver with weblogic 10.3. How to start and stop jasper server?. Is tomact is default for jasperserver? After login asjasperadmin i didnot find any options to restart. Please help me out. Thanks in advance.

Sridhar.

#17Submitted by Anandharaj on Thu, 03/19/2009 - 11:00.

Not tried with weblogic before

Hi,

JasperServer is actually a java container which need to be deploy to Java Servlet (Tomcat, Jboss, etc). I have not used Weblogic before so i cant guide on how to deploy into Weblogic. You cant restart JasperServer from the UI, actually you need to restart the Java Servlet. You might confuse with the name of "JasperServer" - its actually a java web application.

#18Submitted by Anonymous (not verified) on Sat, 02/28/2009 - 07:07.

Tomcat start up error please help

8:43,663 WARN SettingsFactory,main:109 - Could not obtain connection metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)
at org.springframework.beans.factory.support.AbstractAutowireCapableBe

#19Submitted by Anandharaj on Sat, 02/28/2009 - 11:01.

JDBC URL Setting

Hi,

Do you put the JDBC driver in Tomcat? And set the proper database connection setting?

#20Submitted by andrew (not verified) on Thu, 02/12/2009 - 23:25.

postgresql 8.3 and jasper 3.1

Sorry I am slightly lost what scripts should i run for postgresql 8.3 database?

From discussion it does not look like the ones provide as attachments will work for 8.3.

Thanks.

#21Submitted by Anandharaj on Fri, 02/13/2009 - 00:52.

Hi, Thanks for your comment,

Hi,

Thanks for your comment, well this blog is written for PostgreSQL 8.1 and JS 3.0 . Soon, i'll write one more blog for JS 3.1 with PostgreSQL 8.3.

#22Submitted by Juan Gimenez (not verified) on Tue, 01/20/2009 - 00:29.

JasperServer 3.1 PostgreSQL Schema

Dear Anandharaj,

For JasperServer 3.1, there using PostgreSQL, and using Hibernate dialect: "com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect", your schema has to be changed slightly.

In fact i have only done a minimal test, but at least i am not getting errors when i upload an input control or file. Basically i changed the OID type colums with Bytea.

If you think it might be helpful for you, just write to me and i will send it corrected.

Thanks for your great help in getting PostgreSQL up with JS.

#23Submitted by ben neill (not verified) on Mon, 02/02/2009 - 09:18.

RE:JasperServer 3.1 PostgreSQL Schema

can you possibly post that 3.1 schema? I have been attempting to get things up and running using postgreSQL and only having minimal luck - I can get the server to run, etc but I can't delete or modify reports for instance, or run in the background
Cheers,
Ben

#24Submitted by Anandharaj on Tue, 01/20/2009 - 19:03.

Thanks

Hi Juan Gimenez,

Thank you very much for the updates, yes i notice some changes in JS 3.1, but not update my blog yet. Will appreciate if you can provide those changes (in comparison with JS 3.0), than i shall update my blog here. Thanks in advance.

#25Submitted by Anonymous (not verified) on Wed, 12/24/2008 - 02:06.

Unknown SMTP host: mail.localhost.com

I had similar problem until I updated js.quarts.properties the same was as was recommended here for js.mail.properties. Looks like js.quarts.properties is used for notification.

#26Submitted by Anandharaj on Wed, 12/24/2008 - 10:15.

What you update?

Hi,

Then what you have updated in js.quarts.properties file?

#27Submitted by Anonymous (not verified) on Thu, 12/11/2008 - 23:38.

Map Long to blob Exception

I've set up a new Jasperserver 3.1 following your tutorial.
I have a Windows Server with a PostgreSQL 8.3 DB.
Everything worked smooth(login, creating data sources,...) until i tried to add my first Report to the Server.
I created a Report with 2 Input Controls and saved it.
When i try to view the report on the repository it doesn't appear, the idle icon next to the folder doesn't disappear.
Here's the exception from the log:

org.hibernate.HibernateException: I don't know how to map the type java.lang.Long to a blob

I can also post the whole Stacktrace if this helps (just don't wanted to flood the comments area)

Carsten

#28Submitted by Anandharaj on Fri, 12/12/2008 - 08:58.

Send the full log

Hi,

Thanks for your comments, i'll try my level best to solve it. The problem might be related to PostgreSQL as my tutorial is based on PostgreSQL 8.1. Please send the full log to webmaster@raj2u.net. Besides that, please make sure you are using correct JDBC driver according to JDK version (http://jdbc.postgresql.org/download.html)

#29Submitted by Simone (not verified) on Thu, 01/08/2009 - 21:04.

I just got stuck in the same

I just got stuck in the same way... "I don't know how to map the type java.lang.Long to a blob" after importing my first report, using postgresql 8.3.5...

Has anyone found a solution yet?

#30Submitted by Simone (not verified) on Thu, 01/08/2009 - 21:54.

Fixed!

hey, I've found the solution:

- I've re-created the database using the scripts available at http://jasperforge.org/scm/viewvc.php/trunk/buildomatic/install_resource...

- I've changed the line:
metadata.hibernate.dialect=com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect
in WEB-INF/hibernate.properties

- I've removed defaultAutoCommit="false" from META-INF/context.xml (as suggested on JasperForge forums)

#31Submitted by Anandharaj on Tue, 01/13/2009 - 18:36.

Thanks

Hi,

Thanks for the update...at least it will help others on this issue, since im not using PostgreSQL 8.3, im not manage to discover this...

#32Submitted by muradas (not verified) on Wed, 12/10/2008 - 10:22.

Cant find *.sql

Hi...

I've downloaded the js 3.1. Where can I find js-create-trigger.sql, js-create-default-security.sql and js-create-schema.sql?

I don't find them in any part of my installation.

regards

#33Submitted by muradas (not verified) on Wed, 12/10/2008 - 10:28.

upss sorry

Ok. I didn't see the final attachments.

Thanks.

Great tutorial....

regards

#34Submitted by Anonymous (not verified) on Wed, 11/26/2008 - 14:29.

jar xvf jasperserver.war

Hi,
I am using Centos 4.4. I am trying to install jasperserver on my pc. I followed the above procedure, but stucked on section "C" ( Install/Deploy JasperServer into Tomcat ).
When i run # jar xvf /path/jasperserver.war /path/jasperserver it doesn't extract any fine in jasperserver directory.

Waiting for Reply.

thanks
sandeep

#35Submitted by Anandharaj on Thu, 11/27/2008 - 13:23.

Extract without specifying the dest folder

Hi,

Seems like we need to extract without specifying the destination folder. Therefore, we need to "cd" into that folder before extract. I have updated that section, please refer back.

#36Submitted by Anonymous (not verified) on Tue, 12/02/2008 - 19:16.

Thanks for reply. I have

Thanks for reply.
I have already did that.

#37Submitted by sonia (not verified) on Thu, 11/20/2008 - 19:47.

Modifications in GUI

I have installed Jasper Sever 3.0 . I woul like to make some changes in the User Interface like hiding the scheduler icons. How to g about it ?

#38Submitted by Anandharaj on Mon, 11/24/2008 - 10:24.

Refer How-To section "D"

Hi,

I have added that in How-To, please refer section "D" - How to restrict report scheduling function?

#39Submitted by Anonymous (not verified) on Mon, 10/27/2008 - 23:49.

js.mail.properties

Hi,

thanks for this post.

I have got an issue with the mail . The server is not able to send mail
I have got a JasperServer-pro 3.0.2. running on linux plaform (redhat enterprise 5.2).

The file js.mail.properties was missing, I have created a new one and put all informations (mail server, protocol, port, user...).

I have stop and restard the jasperserver.
I have got always error messages : Caused by: javax.mail.MessagingException: Unknown SMTP host: mail.localhost.com;

But it is strange, because I have put my smtp server and not mail.locahost.com

I have installed jasperserver release 3.0.1 on my computer (windows XP). I have put the same js.mail.proerties locally, and it works !!!!!!

Is there any issue with linux ?, with 3.0.2 ?

Why jasperserver still using mail.localhost.com ?

Thanks for any advice

#40Submitted by Anandharaj on Fri, 11/07/2008 - 22:04.

Seems like you are using JS

Seems like you are using JS Pro version, and you were saying that the js.mail.properties file is mission...probably Pro version is using different file / different place to change it? Please send the content of js.mail file that you created...with its location path.

#41Submitted by Anonymous (not verified) on Sat, 10/18/2008 - 01:57.

No luck...

No luck with these instructions. Thou I'm using MySql that is working fine with all the other Tomcat applications. Back to Crystal Reports it seems to me. Open source projects are ok if you aren't doing anything critical. For real life projects, just forget it.

#42Submitted by Anandharaj on Fri, 11/07/2008 - 22:07.

Hmm, actually JS is same

Hmm, actually JS is same level as Crystal Report...its just a matter how you do the setup. If you wish to try JS without hassle, try the Pro version which you will have official support from JasperSoft.

#43Submitted by Anonymous on Fri, 09/12/2008 - 22:28.

slightly connected question

Hi Raj,

Thanks for the post, but I have a separate question about using JasperServer Input Controls with a jrxml file.

I know it's slightly off the topic here, but I posted this question on the forum, and since know your stuff, was hoping you could probably answer this in a couple of seconds.

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=10...

any help greatly appreciated

#44Submitted by Anandharaj on Fri, 09/12/2008 - 23:02.

Sorry, im a bit busy that why

Sorry, im a bit busy that why couldn't reply in the forum. Will check and reply there.

#45Submitted by Anonymous on Tue, 09/09/2008 - 11:23.

DDL files

Thanks for sharing these steps but where did you source js-create-schema.ddl, quartz-tables-postgres.sql, js-create-default-security.sql and js-create-trigger.sql from? I can't find these in the jasperserver-3.0-bin.zip distribution.

Calvin.

#46Submitted by Anandharaj on Thu, 09/11/2008 - 21:19.

Schema Attached

The file already attached. That schema is based on PostgreSQL 8.1, if you have problem with latest version, please let me know.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <b> <i> <p> <br> <img> <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. The supported tag styles are: <foo>, [foo]. PHP source code can also be enclosed in <?php ... ?> or <% ... %>.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.