ibrahimhamza

I think you get an old schema you should run ALTER TABLE jiuser ADD previouspasswordchangetime DATE; make sure that below tables has the add fields or add them using the script ALTER TABLE jireportjobrepodest ADD output_description VARCHAR(100); ALTER TABLE jireportjobrepodest ADD timestamp_pattern VARCHAR(250); attached the schema which I am using it

Good that it working but really strange error unrelated at first glance

thanks anandharaj for your great support and your good response but oracle save passwords in its own way i try now to save the users passwords that will connect to the reports in standard hasing like sha1 or md5 and if i find a solution for databse users i will post it here

Dear ssr1251983 if you want to install jasperserver in oracle follow the steps in http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994 if you wish only to make new report that make connection to oracle make sure to put the oracle jdbc driver and make the right connection string

Thanks anandharaj This is the solution for my problem 1- "ROLE_USER" must exist and assigned to any user 2- "ROLE_USER" may NOT have any privilage at all 3- create your new role and assign it to folders 4- give the desired role to desired user

The Exception Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp you should make the default value to null instead of '0000-00-00'

Dear All I installed jasperserver on oracle XE using the steps descibed in http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994 1- I create role and give it permission read only on root / 2- I create user and give him the role when logon with user give me The user has no access to this page.

Dear Sreekanth Could you give more details? exception if found can you connect to the server using ireport or not ?

11- start tomcat 12- login in the url http://localhost:8080/jasperserver/ username jasperadmin and password password

5 - install tomcat 6- extract the jasperserver-3.1-bin.zip then extract the jasperserver.war inside the apache-tomcatwebappsjasperserver 7- download jdbc driver for oracle 7-put the ojdbc14.jar in apache-tomcatcommonlib 8- modify apache-tomcatwebappsjasperserverWEB-INFhibernate.properties modify the line starts with metadata.hibernate.dialect= to be metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect 9- modify apache-tomcatwebappsjasperserverMETA-INFjasperserverDS-jdbc.xml modify the section <jdbc-driver-params> to be <jdbc-driver-params> <url>jdbc:oracle:thin:@localhost:1521:XE</url> <driver-name>oracle.jdbc.driver.OracleDriver</driver-name> <properties> <property> <name>user</name> <value>jasper</value> </property> </properties> <password-encrypted>jasper</password-encrypted> </jdbc-driver-params> 10 - modfiy apache-tomcatwebappsjasperserverMETA-INFcontext.xml modify the section starts with <Resource name="jdbc/jasperserver" to be <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasper" password="jasper" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:XE"/>

First if you can buy Pro edition it is recommonded to have support to your self and to project too second if you can't 1- download the latest bin file from http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243 current is jasperserver-3.1-bin.zip 2- download Tomcat 5.5 http://tomcat.apache.org/download-55.cgi 3- download the jasperreport schema from the attachment you can transfer postgres or mysql schema to oracle if you understand where is the difference. 4- create a user for example called jasper and run the attached sql schema inside

Is this applicable to connect using database users

Now it works and here is the steps to make the passswords hashed with sha1 Modify the apache-tomcatwebappsjasperserverWEB-INFapplicationContext-security.xml 1- comment or remove the bean which starts with <bean id="passwordEncoder" to be <!-- <bean id="passwordEncoder" class="com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordCipherer"> <property name="allowEncoding"><value>false</value></property> <property name="keyInPlainText"><value>false</value></property> <property name="secretKey"><value>0xC8 0x43 0x29 0x49 0xAE 0x25 0x2F 0xA1 0xC1 0xF2 0xC8 0xD9 0x31 0x01 0x2C 0x52 0x54 0x0B 0x5E 0xEA 0x9E 0x37 0xA8 0x61</value></property> <property name="secretKeyAlgorithm"><value>DESede</value></property> <property name="cipherTransformation"><value>DESede/CBC/PKCS5Padding</value></property> </bean> --> 2- but this instead <bean id="passwordEncoder" class="org.acegisecurity.providers.encoding.ShaPasswordEncoder"> <property name="encodeHashAsBase64"><value>false</value></property> </bean> 3- make sure that <property name="passwordEncoder"><ref local="passwordEncoder"/></property> is not commented remove th comment by delete <!-- and --> 4- connect using sql to update jasperadmin user password UPDATE JIUSER SET PASSWORD = '4899a849f6a3cee79e2ad5b7dd93d0a7f276d493' WHERE USERNAME = 'jasperadmin'; now login with jasperadmin and password jasperadmin Post Edited by ibrahim hamza at 04/09/09 07:36 Post Edited by ibrahim hamza at 04/12/09 07:35

I have jasper server 3.1 I search your site with sha and sha1 and no results I add the nest section to applicationContext-security.xml <bean id="passwordEncoder" class="org.acegisecurity.providers.encoding.ShaPasswordEncoder"> <property name="encodeHashAsBase64"><value>false</value></property> </bean> and commented the old <bean id="passwordEncoder" class="com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordCipherer"> and then i make user and hashed its password "1" which is 356a192b7913b04c54574d18c28d46e6395428ab

Dear All Can I change the jasperserver to save passwords in sha1 to be more secure thanks