It looks as though you have a password set on your unix server. you will need
to either remove this or ti add the password into the connection string
e.g. readonly:[yourpassword]@'10.86.29.32'
>> 'readonly'@'10.86.29.32'
>> (using password: NO)"
On 30 Oct 2012, at 09:08, kunal sachdeva wrote:
> 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
>>
David Stuart
M +44(0) 778 854 2157
T +44(0) 845 519 5465
www.axistwelve.com
Axis12 Ltd | 7 Wynford Road
| London | N1 9QN | UK
AXIS12 - Enterprise Web Solutions
Reg Company No. 7215135
VAT No. 997 4801 60
This e-mail is strictly confidential and intended solely for the ordinary user
of the e-mail account to which it is addressed. If you have received this
e-mail in error please inform Axis12 immediately by return e-mail or telephone.
We advise that in keeping with good computing practice the recipient of this
e-mail should ensure that it is virus free. We do not accept any responsibility
for any loss or damage that may arise from the use of this email or its
contents.
