q001

Hi Lucian, thanks for your help. It works! Would it be possible to assume in the "JasperServer-Install-Guide.pdf". Regards Matthias

Hallo, I installed JasperServer with following components: * JasperServer 2.1 * Tomcat 5.5 * Mysql 5.0.51a If I try to start the JasperServer I get the error message that JasperServer can't login to database with "root" user. But in the context.xml the user "jasperadmin" is defined. Why jasperserver try it with the wrong user? context.xml file: Code: <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="..." driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/jasperserver?useUnicode=true&characterEncoding=UTF-8" /> </Context> jasperserver.log file: Code:[code] 23:52:54,079 WARN JDBCExceptionReporter,main:77 - SQL Error: 0, SQLState: null 23:52:54,086 ERROR JDBCExceptionReporter,main:78 - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) 23:52:54,091 WARN SettingsFactory,main:109 - Could not obtain connection metadata org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) 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) Thanks for your help Matthias

Hallo, I installed JasperServer with following components: * JasperServer 2.1 * Tomcat 5.5 * Mysql 5.0.51a If I try to start the JasperServer I get the error message that JasperServer can't login to database with "root" user. But in the context.xml the user "jasperadmin" is defined. Why jasperserver try it with the wrong user? context.xml file: Code: <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="..." driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/jasperserver?useUnicode=true&characterEncoding=UTF-8" /> </Context> jasperserver.log file: Code:[code] 23:52:54,079 WARN JDBCExceptionReporter,main:77 - SQL Error: 0, SQLState: null 23:52:54,086 ERROR JDBCExceptionReporter,main:78 - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) 23:52:54,091 WARN SettingsFactory,main:109 - Could not obtain connection metadata org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) 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) Thanks for your help Matthias