Problem first starting JasperServer

[q001]

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

[lucianc]

Follow-up here.