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.
>
>
>
>
>
