Hi, seems that 127.0.0.1 is not resolved to localhost in your environment? Which I think is very peculiar. Either add a grant for [email protected] in mysql or add an alias localhost for 127.0.0.1 in your hostfile.
Hope that helps. /Arvid 2010/4/6 Marc Grue <[email protected]> > > Hi, > > I'm trying to get Streamflow running, and I have followed Paul Merlin-2's > instructions in his http://old.nabble.com/StreamFlow-code-ts27618391.html > post including granting privileges to the streamflow database: > > grant all privileges on streamflow.* to streamf...@localhost identified by > "streamflow"; > > But when I run > > mvn compile exec:java > > I still get an Access denied exception (see trace below). I have no problem > logging into mysql as user:streamflow passw:streamflow. > > Can some of you see what I'm missing? > > Thanks, > Marc > > ================= > INFO C3P0Registry - Initializing c3p0-0.9.1 [built 16-January-2007 > 14:46:42; debug? true; trace: 10] > INFO DataSourceService - Starting up DataSource 'streamflowds' > for:streamf...@jdbc:mysql://localhost:3306/streamflow > INFO AbstractPoolBackedDataSource - Initializing c3p0 pool... > com.mchange.v2.c3p0.ComboPooledDataSource [ > acquireIncrement -> 3, > acquireRetryAttempts -> 30, > acquireRetryDelay -> 1000, > autoCommitOnClose -> false, > automaticTestTable -> null, > breakAfterAcquireFailure -> false, > checkoutTimeout -> 0, > connectionCustomizerClassName -> null, > connectionTesterClassName -> > com.mchange.v2.c3p0.impl.DefaultConnectionTester, > dataSourceName -> 1hge0wa871mayjrf15sciy2|2b5fab, > debugUnreturnedConnectionStackTraces -> false, > description -> null, > driverClass -> com.mysql.jdbc.Driver, > factoryClassLocation -> null, > forceIgnoreUnresolvedTransactions -> false, > identityToken -> 1hge0wa871mayjrf15sciy2|2b5fab, > idleConnectionTestPeriod -> 0, > initialPoolSize -> 3, > jdbcUrl -> jdbc:mysql://localhost:3306/streamflow, > lastAcquisitionFailureDefaultUser -> null, > maxAdministrativeTaskTime -> 0, > maxConnectionAge -> 3600, > maxIdleTime -> 0, > maxIdleTimeExcessConnections -> 0, > maxPoolSize -> 15, > maxStatements -> 0, > maxStatementsPerConnection -> 0, > minPoolSize -> 3, > numHelperThreads -> 3, > numThreadsAwaitingCheckoutDefaultUser -> 0, > preferredTestQuery -> null, > properties -> {user=******, password=******}, > propertyCycle -> 0, > testConnectionOnCheckin -> false, > testConnectionOnCheckout -> false, > unreturnedConnectionTimeout -> 0, > usesTraditionalReflectiveProxies -> false ] > WARN BasicResourcePool - > com.mchange.v2.resourcepool.basicresourcepool$acquiret...@54f7fb -- > Acquisition Attempt Failed!!! Clearing pending acquires. While trying to > acquire a needed new resource, we failed to succeed more than the maximum > number of allowed acquisition attempts (30). Last acquisition attempt > exception: > java.sql.SQLException: Access denied for user 'streamflow'@'127.0.0.1' > (using password: YES) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920) > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4000) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1285) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2186) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787) > at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:353) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) > at > > com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) > at > > com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) > at > > com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) > at > > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) > at > > com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) > at > > com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) > at > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) > at > > com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) > ================= > -- > View this message in context: > http://old.nabble.com/Accessing-streamflow-database-denied-tp28149365p28149365.html > Sent from the Qi4j-dev mailing list archive at Nabble.com. > > > _______________________________________________ > qi4j-dev mailing list > [email protected] > http://lists.ops4j.org/mailman/listinfo/qi4j-dev > >
_______________________________________________ qi4j-dev mailing list [email protected] http://lists.ops4j.org/mailman/listinfo/qi4j-dev
