You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Adarsh Sharma <ed...@gmail.com> on 2012/09/11 17:01:07 UTC

Saved jobs with passwords

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

Re: Saved jobs with passwords

Posted by Cheolsoo Park <ch...@cloudera.com>.
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 <ed...@gmail.com>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
>