Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

    With the Isomorphic Toolkit/Admin Console I am able to browse my database and look at all the contents. However, when I try to import a data source I get the following:

    Code:
    === 2013-06-19 00:23:03,963 [sor8] ERROR SQLConnectionManager - Caught exception
    === 2013-06-19 00:23:03,977 [sor8] ERROR BuiltinRPC - There was a problem importing datasource 'uploads'.  The error report below may indicate what the problem was.
    
    java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
    	at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:443)
    	at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:141)
    	at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:111)
    	at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:185)
    	at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:344)
    	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
    	at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:85)
    	at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:69)
    	at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:156)
    	at com.isomorphic.tools.SQLImport.processSQLDataSource(SQLImport.java:352)
    	at com.isomorphic.tools.SQLImport.processDataSource(SQLImport.java:269)
    	at com.isomorphic.tools.AdminConsole.importDataSources(AdminConsole.java:408)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:601)
    	at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:972)
    	at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:804)
    	at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:306)
    	at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:66)
    	at org.apache.jsp.tools.adminConsoleOperations_jsp._jspService(adminConsoleOperations_jsp.java:93)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    	at com.isomorphic.js.JSSyntaxScannerFilter.doFilter(JSSyntaxScannerFilter.java:251)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
    	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
    	at java.lang.Thread.run(Thread.java:722)
    Here is the data source I'm trying to import:

    Code:
    <DataSource 
    	dbName="Local MySQL"
    	tableName="uploads"
    	ID="uploads"
    	dataSourceVersion="1"
    	generatedBy="v8.3p_2013-05-10/EVAL Deployment 2013-05-10"
    	serverType="sql"
    >
    	<fields>
    		<field primaryKey="true" name="ID" type="sequence"></field>
    		<field name="AccountID" type="integer"></field>
    		<field name="Name" length="45" type="text"></field>
    		<field name="Type" length=20" type="text"></field>
    		<field name="UploadedFile" type="binary"></field>
    		<field name="UploadedFile_filename" length="255" type="text"></field>
    		<field name="UploadedFile_filesize" type="integer"></field>
    		<field name="UploadedFile_date_created" type="datetime"></field>
    	</fields>
    </DataSource>
    In the past I've been able to successfully import data sources but now it won't work for me.

    I can't tell what I'm doing wrong that would cause this error. Could you provide some guidance for me so I can understand how I can correct this?

    #2
    problem solved

    Never mind!

    I had the wrong dbName in the data source XML file

    Comment

    Working...
    X