This error is typically because of a mysql permissions problem. These
are usually resolved by a GRANT statement on your DB to allow for
users to connect remotely to your database server.
I don't know the full syntax but a quick search on Google should yield
what you are looking for. If you don't control access to this DB, talk
to your sys admin who does maintain this access and s/he should be
able to help resolve this.
On Tue, Oct 30, 2012 at 7:13 AM, Travis Low <t...@4centurion.com> wrote:
> Like Amit said, this appears not to be a Solr problem. From the command
> line of your machine, try this:
>
> mysql -u'readonly' -p'readonly' -h'10.86.29.32' hpcms_db_new
>
> If that works, and 10.86.29.32 is the server referenced by the URL in your
> data-config.xml problem, then at least you know you have database
> connectivity, and to the right server.
>
> Also, if your unix server (presumably your mysql server) is 10.86.29.32,
> then the URL in your data-config.xml is pointing to the wrong machine. If
> the one in the data-config.xml is correct, you need to test for
> connectivity to that machine instead.
>
> cheers,
>
> Travis
>
> On Tue, Oct 30, 2012 at 5:15 AM, kunal sachdeva
> <kunalsachde...@gmail.com>wrote:
>
>> Hi,
>>
>> This is my data-config file:-
>>
>> <dataConfig>
>>
>> <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://
>> 172.16.37.160:3306/hpcms_db_new" user="readonly" password="readonly"/>
>>
>> <document>
>>
>> <entity
>> name="package" query="select concat('pckg', id) as id,pkg_name,updated_time
>> from hp_package_info;">
>> </entity>
>>
>> <entity
>> name="destination"
>> query="select name,id from hp_city">
>> <field column="name" name="dest_name"/>
>> </entity>
>> <!--
>> <entity
>> name="theme"
>> query="select id,name from hp_themes">
>> <field column="name" name="theme_name"/>
>> </entity>
>> -->
>> </document>
>> </dataConfig>
>>
>>
>> and password is not null. and 10.86.29.32 is my unix server ip.
>>
>> regards,
>> kunal
>>
>> On Tue, Oct 30, 2012 at 2:42 PM, Dave Stuart <d...@axistwelve.com> wrote:
>>
>> > 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.
>> >
>> >
>> >
>> >
>> >
>>
>
>
>
> --
>
> **
>
> *Travis Low, Director of Development*
>
>
> ** <t...@4centurion.com>* *
>
> *Centurion Research Solutions, LLC*
>
> *14048 ParkEast Circle *•* Suite 100 *•* Chantilly, VA 20151*
>
> *703-956-6276 *•* 703-378-4474 (fax)*
>
> *http://www.centurionresearch.com* <http://www.centurionresearch.com>
>
> **The information contained in this email message is confidential and
> protected from disclosure. If you are not the intended recipient, any use
> or dissemination of this communication, including attachments, is strictly
> prohibited. If you received this email message in error, please delete it
> and immediately notify the sender.
>
> This email message and any attachments have been scanned and are believed
> to be free of malicious software and defects that might affect any computer
> system in which they are received and opened. No responsibility is accepted
> by Centurion Research Solutions, LLC for any loss or damage arising from
> the content of this email.
