Friday, October 13, 2017

nzsql: Password authentication failed for user 'ADMIN' on netezza

we recently faced issue on netezza  and we could not login to  database using nzsql or any other administrative tool did not work and got the below error.

issue:

nz@<server_name>:/export/home/nz/> nzsql
nzsql: Password authentication failed for user 'ADMIN'

root cause:
looks like the password file missing in the server.

nz@<server_name>:/export/home/nz> nzpassword show

No cached passwords.

nz@<server_name>:/export/home/nz>  ls -lart .nzpassword
/bin/ls: .nzpassword: No such file or directory

solution:
added the password file on the server and worked fine.


nz@<server_name>:/export/home/nz> nzpassword add -u ADMIN -pw <pwd> -host <server_name>
nz@<server_name>:/export/home/nz> nzpassword show


Host                         User
---------------------------- -----
<server_name>                ADMIN



nz@<server_name>:/export/home/nz> ls -ltra .nzpassword
-r-------- 1 nz 500 203 Oct 11 11:09 .nzpassword

No comments:

Post a Comment