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.
