I want to scrutinize the vertica cluster. when i run command /opt/vertica/bin/scrutinize. i get following error
Scrutinize Version 8.1.1-27
Using default temporary directory
/tmpInvocation information
/opt/vertica/bin/scrutinize
Vertica Scrutinize Report
Result Dir: /home/dbadmin/VerticaScrutinize.20200623142812
User: dbadmin
Database: VDB
Warning: The target db is running, but it cannot
be reached. Common causes of this are:
- Incorrect passord
- Running an all-node scrutinize from a down node
when the db is up
If you intend to run without connecting to the db,
please use --vsql-off.
Latest VSQL Error:
vsql: FATAL 3781: Invalid username or password
Failed to initialize Scrutinize.
Cannot connect to running database 'VDB'
error says "invalid user or pass". when i tried to login into db using vsql -d VDB -u dbadmin -w dbadminpass i successful logged in. and can run sql commands.
another way i tried to scrutinize like /opt/vertica/bin/scrutinize -d VDB -U dbadmin -w dbadminpass, following error popped up.
Invoking worker on dbadminpass
Scrutinize Version 8.1.1-27
Running all tasks
Traceback (most recent call last):
File "/opt/vertica/bin/scrutinize", line 144, in
main()
File "/opt/vertica/bin/scrutinize", line 41, in main
arg_parser.options.worker_instructions
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/tools/Scrutinize/ScrutinWorker.py", line 35, in init
self.load_config_file(config_file)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/tools/Scrutinize/ScrutinWorker.py", line 43, in load_config_file
cfile = open(config_file,'r')
IOError: [Errno 2] No such file or directory: 'dbadminpass'
I could not understand this error. plz guide on this. i also want tables info and dont want to do '--vsql-off'
