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
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 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