Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 84499 invoked from network); 28 Feb 2007 18:58:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Feb 2007 18:58:36 -0000 Received: (qmail 67818 invoked by uid 500); 28 Feb 2007 18:58:43 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 67801 invoked by uid 500); 28 Feb 2007 18:58:43 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 67790 invoked by uid 99); 28 Feb 2007 18:58:43 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Feb 2007 10:58:43 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Feb 2007 10:58:31 -0800 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HMU08-0004se-Oi for users@activemq.apache.org; Wed, 28 Feb 2007 10:58:08 -0800 Message-ID: <9226481.post@talk.nabble.com> Date: Wed, 28 Feb 2007 10:58:08 -0800 (PST) From: LiXiao2007 To: users@activemq.apache.org Subject: Database Error occured using latest activemq-4.2 binary MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: LiXiao2007@gmail.com X-Virus-Checked: Checked by ClamAV on apache.org 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.