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
