Vertica 6.1SP3 (6.1.3) Virtual Machines : unable to open adminTools

Lakshminarayana

I am trying to use the vertica in VM (vmware worksatation @ 9 Using the latest : Vertica 6.1SP3 (6.1.3) Virtual Machines. And encounter an error at the initial stage , Well before creating the database, in fact when trying to open the adminTools. When trying to open the opt/vertica/bin/adminTools Below error popped up as provided in log, Log for reference: [dbadmin@vertica ~]$ /opt/vertica/bin/adminTools Traceback (most recent call last): File "/opt/vertica/bin/adminTools", line 242, in cmdController = commandLineCtrl.commandLineCtrl(makeUniquePorts, showNodes) File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/commandLineCtrl.py", line 35, in __init__ self.__exec = adminExec.adminExec(makeUniquePorts, showNodes) File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/adminExec.py", line 138, in __init__ c = Configurator.Instance() File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/Configurator.py", line 50, in Instance with FileLock( Configurator.CONFIG_FILE): File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/FileLocker.py", line 67, in __enter__ self.acquire() File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/FileLocker.py", line 40, in acquire self.fd = os.open(self.lockfile, os.O_CREAT|os.O_EXCL|os.O_RDWR) OSError: [Errno 13] Permission denied: '/opt/vertica/config/admintools.conf.lock' Note : I tried to change the permission using (chmod 777 admintools.conf ) as root user , but it’s not working.

Artem_Prusevich

Can you write to dir /opt/vertica/config?  Can you write to /opt/vertica/log dir as well?  Both should be at 775 at a minimum.

Lakshminarayana

Not sure weather I have the permission on stock vm once you downloaded. But I am able to resolve the issue by doing an complete uninstall and reinstall using the rpm file, which makes things work without any issues. Waiting for crane.... And new guide to query

Laxmi_narayan_B

can you please tell me how you did reinstall? Thanks in advance....

Daniel_Leybovic

There are bug in VM appliance: didn't configured well a owner of folder /opt/vertica/config
You don't need to reinstall, just set a owner 'dbadmin' for folder:
https://community.vertica.com/vertica/topics/permission_denied_admintools_conf_lock