[jira] [Commented] (SOLR-2775) DataImportHandler jdbc password

2011-10-03 Thread Des Lownds (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/SOLR-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13119428#comment-13119428
 ] 

Des Lownds commented on SOLR-2775:
--

dataimporthalder config:
{code}  !-- data import handler --
  requestHandler name=/dataimport 
class=org.apache.solr.handler.dataimport.DataImportHandler
lst name=defaults
  str name=configdata-config.xml/str
  lst name=datasource
 str name=driver${jdbc.readonly.driver}/str
 str 
name=urljdbc:mysql://${jdbc.readonly.host}:${jdbc.readonly.port}/${jdbc.readonly.database}/str
 str name=user${jdbc.readonly.user}/str
 str name=password${jdbc.readonly.password}/str
  /lst
/lst
  /requestHandler{code}

curl http://localhost:8066/solr/catalog/dataimport
{code}
responselst name=responseHeaderint name=status0/intint 
name=QTime0/int/lstlst name=initArgslst name=defaultsstr 
name=configdata-config.xml/strlst name=datasourcestr 
name=drivercom.mysql.jdbc.Driver/strstr 
name=urljdbc:mysql://localhost:3306/#REDACT#/strstr 
name=user#REDACT#/strstr 
name=password#REDACT#/str/lst/lst/lststr 
name=statusidle/strstr name=importResponse/lst 
name=statusMessagesstr name=Total Requests made to 
DataSource2125/strstr name=Total Rows Fetched1965/strstr name=Total 
Documents Skipped0/strstr name=Full Dump Started2011-10-03 
11:31:02/strstr name=Indexing completed. Added/Updated: 236 documents. 
Deleted 0 documents./strstr name=Committed2011-10-03 11:31:35/strstr 
name=Optimized2011-10-03 11:31:35/strstr name=Total Documents 
Processed236/strstr name=Time taken 0:0:32.932/str/lststr 
name=WARNINGThis response format is experimental.  It is likely to change in 
the future./str/response
{code}
log:
{code} [java] INFO  SearchHandler - Adding  
component:org.apache.solr.handler.component.StatsComponent@f786a3c
 [java] INFO  SearchHandler - Adding  debug 
component:org.apache.solr.handler.component.DebugComponent@2a869113
 [java] INFO  DataImportHandler - Processing configuration from 
solrconfig.xml: 
{config=data-config.xml,datasource={driver=com.mysql.jdbc.Driver,url=jdbc:mysql://localhost:3306/#REDACT#,user=#REDACT#,password=#REDACT#}}
 [java] INFO  DataImportHandler - Adding properties to datasource: 
{user=#REDACT#, password=#REDACT#, url=jdbc:mysql://localhost:3306/#REDACT#, 
driver=com.mysql.jdbc.Driver}
 [java] INFO  DataImporter - Data Configuration loaded successfully
{code}


 DataImportHandler jdbc password
 ---

 Key: SOLR-2775
 URL: https://issues.apache.org/jira/browse/SOLR-2775
 Project: Solr
  Issue Type: Bug
  Components: contrib - DataImportHandler
Affects Versions: 4.0
 Environment: All
Reporter: Des Lownds
Assignee: Shalin Shekhar Mangar
Priority: Minor
 Fix For: 4.0


 The http response from dataimporthandler, as well as logging output exposes 
 the jdbc password in plain text.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira



-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org



[jira] [Commented] (SOLR-2775) DataImportHandler jdbc password

2011-10-03 Thread Des Lownds (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/SOLR-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13119450#comment-13119450
 ] 

Des Lownds commented on SOLR-2775:
--

After looking closer I see this is only happening because I am specifying the 
dataimport config in the dataimporthandler config in solrcore.xml. Moving that 
to a datasource element in data-config.xml prevents this, but makes it hard to 
specify the connection properties in a way that is easily set in deployment. 

 DataImportHandler jdbc password
 ---

 Key: SOLR-2775
 URL: https://issues.apache.org/jira/browse/SOLR-2775
 Project: Solr
  Issue Type: Bug
  Components: contrib - DataImportHandler
Affects Versions: 4.0
 Environment: All
Reporter: Des Lownds
Assignee: Shalin Shekhar Mangar
Priority: Minor
 Fix For: 4.0


 The http response from dataimporthandler, as well as logging output exposes 
 the jdbc password in plain text.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira



-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org



[jira] [Commented] (SOLR-2775) DataImportHandler jdbc password

2011-09-22 Thread Shalin Shekhar Mangar (JIRA)

[ 
https://issues.apache.org/jira/browse/SOLR-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13112433#comment-13112433
 ] 

Shalin Shekhar Mangar commented on SOLR-2775:
-

Can you please give me a log fragment showing this? The log files do have the 
jdbc url so it is advisable to use the user and password attributes on 
JdbcDataSource rather than putting them in the jdbc url itself.

 DataImportHandler jdbc password
 ---

 Key: SOLR-2775
 URL: https://issues.apache.org/jira/browse/SOLR-2775
 Project: Solr
  Issue Type: Bug
  Components: contrib - DataImportHandler
Affects Versions: 4.0
 Environment: All
Reporter: Des Lownds
Assignee: Shalin Shekhar Mangar
Priority: Minor
 Fix For: 4.0


 The http response from dataimporthandler, as well as logging output exposes 
 the jdbc password in plain text.  

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira



-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org