I downloaded the latest activemq-4.2 binary
apache-activemq-4.2-20070209.025159-1.tar and got the followng error when I
tried to start the broker. I did not have this problem when I used
activemq-4.1.0. The tables ACTIVEMQ_ACKS, ACTIVEMQ_LOCKS, and ACTIVE_MSGS
were created so I know that my user xli has the permission to access the
datbase.
ERROR DefaultDatabaseLocker - Failed to acquire lock:
java.sql.SQLException: Access denied for user 'xli'@'%' to database 'smurf'
java.sql.SQLException: Access denied for user 'xli'@'%' to database 'smurf'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137)
at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:803)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:117)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:117)
at
org.apache.activemq.store.jdbc.DefaultDatabaseLocker.start(DefaultDatabaseLocker.java:60)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:175)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter.start(JournalPersistenceAdapter.java:220)
at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1255)
at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1213)
at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:507)
at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:404)
at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
--
View this message in context:
http://www.nabble.com/Database-Error-occured-using-latest-activemq-4.2-binary-tf3317869s2354.html#a9226481
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
