[On Behalf of Naresh] sqoop password-file option failed to execute

sgiri · August 15, 2018, 2:54pm

Hi Sir,
I am trying to run sqoop job with password-file option but its failed to identify file path in hadfs, please resolve the issue…
sqoop list-databases --connect jdbc:mysql://ip-172-31-13-154:3306 --username sqoopuser --password-file hdfs://ip-172-31-53-48.ec2.internal/user/narine91267897/sqoop.password

Exception:

18/08/05 11:18:13 ERROR manager.CatalogQueryManager: Failed to list databasesjava.sql.SQLException: Access denied for user ‘sqoopuser’@‘ip-172-31-38-183.ec2.internal’ (using password:YES)

username: narineXXXX
webconsole: https://f.cloudxlab.com/
hostname: ip-172-31-38-183.ec2.internal

Thanks & regards,
Naresh Kumar

sgiri · August 15, 2018, 2:56pm

Hi Naresh,
It seems to work fine now. I just tested it. Please see the image below.

Please check and confirm. If you notice the error, please inform.