Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - Saved jobs with passwords

Copy link to this message
Re: Saved jobs with passwords
Cheolsoo Park 2012-09-11, 20:25
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

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.

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