Hi Adarsh, Can you please provide the output of "sqoop job --show <your job name> | grep db.require.password"? It should be set to "false" to stop asking for password.
I see two possibilities: 1) Your sqoop-site.xml is not being loaded by Sqoop. 2) Your job had been created before "sqoop.metastore.client.record.password" was set to "true". As for 1, can you double check your SQOOP_HOME? As for 2, even though "sqoop.metastore.client.record.password" is set to "true" in sqoop-site.xml now, if your job was created before that (i.e. when "sqoop.metastore.client.record.password" was "false"), it will continue to ask for password for that job. To change this, you have to delete the saved job and re-create it in the metastore. Thanks, Cheolsoo On Tue, Sep 11, 2012 at 8:01 AM, Adarsh Sharma <[email protected]>wrote: > Hi, > > Sqoop provides a mechanism to save jobs & run periodically. I need to > save passwords for sqoop jobs in metastore so that it didn't ask for > password every time when job runs may be crons. > > I set below parameters in sqoop-site.xml :- > > <configuration> > <property> > <name>sqoop.metastore.client.record.password</name> > <value>true</value> > <description>If true, allow saved passwords in the metastore. > </description> > </property> > <property> > <name>sqoop.metastore.client.enable.autoconnect</name> > <value>true</value> > <description>If true, Sqoop will connect to a local metastore > for job management when no other metastore arguments are > provided. > </description> > </property> > > Still don't know why it prompts for password everytime and wonders job > started without entering password and pressing enter on password prompt. > > > Thanks >
