Hi,
I'm not getting this error while running in local machine. Please Help
Regards,
Kunal
On Tue, Oct 30, 2012 at 10:32 AM, Amit Nithian <anith...@gmail.com> wrote:
> This looks like a MySQL permissions problem and not a Solr problem.
> "Caused by: java.sql.SQLException: Access denied for user
> 'readonly'@'10.86.29.32'
> (using password: NO)"
>
> I'd advise reading your stack traces a bit more carefully. You should
> check your permissions or if you don't own the DB, check with your DBA
> to find out what user you should use to access your DB.
>
> - Amit
>
> On Mon, Oct 29, 2012 at 9:38 PM, kunal sachdeva
> <kunalsachde...@gmail.com> wrote:
> > Hi,
> >
> > I have tried using data-import in my local system. I was able to execute
> it
> > properly. but when I tried to do it unix server I got following error:-
> >
> >
> > INFO: Starting Full Import
> > Oct 30, 2012 9:40:49 AM
> > org.apache.solr.handler.dataimport.SimplePropertiesWriter
> > readIndexerProperties
> > WARNING: Unable to read: dataimport.properties
> > Oct 30, 2012 9:40:49 AM org.apache.solr.update.DirectUpdateHandler2
> > deleteAll
> > INFO: [core0] REMOVING ALL DOCUMENTS FROM INDEX
> > Oct 30, 2012 9:40:49 AM org.apache.solr.core.SolrDeletionPolicy onInit
> > INFO: SolrDeletionPolicy.onInit: commits:num=1
> >
> >
> commit{dir=/opt/testsolr/multicore/core0/data/index,segFN=segments_1,version=1351490646879,generation=1,filenames=[segments_1]
> > Oct 30, 2012 9:40:49 AM org.apache.solr.core.SolrDeletionPolicy
> > updateCommits
> > INFO: newest commit = 1351490646879
> > Oct 30, 2012 9:40:49 AM
> org.apache.solr.handler.dataimport.JdbcDataSource$1
> > call
> > INFO: Creating a connection for entity destination with URL:
> jdbc:mysql://
> > 172.16.37.160:3306/hpcms_db_new
> > Oct 30, 2012 9:40:50 AM org.apache.solr.common.SolrException log
> > SEVERE: Exception while processing: destination document :
> >
> SolrInputDocument[{}]:org.apache.solr.handler.dataimport.DataImportHandlerException:
> > Unable to execute query: select name,id from hp_city Processing Document
> # 1
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:264)
> > at
> >
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:375)
> > at
> >
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:445)
> > at
> >
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:426)
> > Caused by: java.lang.RuntimeException:
> > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> > execute query: select name,id from hp_city Processing Document # 1
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:621)
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:327)
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:225)
> > ... 3 more
> > Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
> > Unable to execute query: select name,id from hp_city Processing Document
> # 1
> > at
> >
> org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
> > at
> >
> org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
> > at
> >
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> > at
> >
> org.apache.solr.handler.dataimport.EntityProcessorWrapper.pullRow(EntityProcessorWrapper.java:330)
> > at
> >
> org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:296)
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:683)
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:619)
> > ... 5 more
> > Caused by: java.sql.SQLException: Access denied for user
> > 'readonly'@'10.86.29.32'
> > (using password: NO)
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
> > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
> > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
> > at
> > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
> > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
> > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > Method)
> > at
> >
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> > at
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> > at
> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> > at
> > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
> > at
> >
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:129)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39)
> > at
> >
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
> > ... 13 more
> >
> > Oct 30, 2012 9:40:50 AM org.apache.solr.update.DirectUpdateHandler2
> rollback
> > INFO: start rollback
> > Oct 30, 2012 9:40:50 AM org.apache.solr.update.DirectUpdateHandler2
> rollback
> > INFO: end_rollback
> >
> > Please resolve this issue.
> >
> > Regards,
> > Kunal
>
