I am new to vertica. I just installed vertica on my CentOS and I was able to open the adminTools UI. Soon after I give the password to create a new(my first) database. I get the following error.
admintools failed to create an interface object.
Please resize your window to a larger width and height.
This is the content of my admintools.conf file.
cat admintools.conf[Configuration]
last_port = 5433
tmp_dir = /tmp
default_base = /home/dbadmin
format = 3
install_opts = --hosts '127.0.0.1' --dba-user vertica --dba-user-password '*******'
spreadlog = False
controlsubnet = default
controlmode = broadcast
[Cluster]
hosts =
[Nodes]
Content of logs:
Nov 25 14:07:07 [18217] NEW LOG: /opt/vertica/bin/adminTools
Nov 25 14:07:07 [18217] [adminExec.__init__] Unique Ports: False
Nov 25 14:07:07 [18217] [isOkToRun] owner of admintools.conf (dbauser) is vertica.
Nov 25 14:07:07 [18217] [adminTools] Starting admin tools (['/opt/vertica/bin/adminTools'])...
Nov 25 14:07:07 [18217] [adminTools] Use unique ports = False
Nov 25 14:07:07 [18217] [adminTools] Configuration=
DBinclude.ADMINTOOLS_CONF=/opt/vertica/config/admintools.conf
DBinclude.ADMIN_DIR=/opt/vertica/bin
DBinclude.CHECK_FAILED=-1
DBinclude.CONFIG_DIR=/opt/vertica/config
DBinclude.CONFIG_INFO_DIR=/opt/vertica/config/configInfo
DBinclude.CONFIG_SHARE_DIR=/opt/vertica/config/share
DBinclude.CONFIG_USER_DIR=/opt/vertica/config/users
DBinclude.DB_DIR=/opt/vertica
DBinclude.DBname=<module 'vertica.config.DBname' from '/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/DBname.pyc'>
DBinclude.DEFAULT_RESTART_POLICY=ksafe
DBinclude.HELP_DIR=/opt/vertica/bin/help
DBinclude.LCHK_DIR=/opt/vertica/bin
DBinclude.LICENSE_KEY=/opt/vertica/config/share/license.key
DBinclude.LOG=0
DBinclude.LOG_DIR=/opt/vertica/log
DBinclude.MAX_KSAFETY=2
DBinclude.NAG_COUNT=0
DBinclude.NAG_FLAG=0
DBinclude.NAG_MSG={}
DBinclude.OLD_SPREAD_CONF=/opt/vertica/config/vspread.conf
DBinclude.OSNAME=RHEL5
DBinclude.OSS_DIR=/opt/vertica/oss
DBinclude.OS_DEBIAN=7
DBinclude.OS_DEBIAN_S=DEBIAN
DBinclude.OS_FEDORA=4
DBinclude.OS_FEDORA_S=FEDORA
DBinclude.OS_RHEL4=1
DBinclude.OS_RHEL4_S=RHEL4
DBinclude.OS_RHEL5=5
DBinclude.OS_RHEL5_S=RHEL5
DBinclude.OS_SUSE=3
DBinclude.OS_SUSE_S=SUSE
DBinclude.OS_UNSUPPORT=0
DBinclude.PACKAGES_DIR=/opt/vertica/packages
DBinclude.PACKAGE_DESC_FILE=package.conf
DBinclude.PACKAGE_INSTALL_SCRIPT=ddl/install.sql
DBinclude.PACKAGE_ISINSTALLED_SCRIPT=ddl/isinstalled.sql
DBinclude.PACKAGE_UNINSTALL_SCRIPT=ddl/uninstall.sql
DBinclude.PYTHON_BINARY=/opt/vertica/oss/python/bin/python
DBinclude.RESTART_POLICY_LIST=('never', 'ksafe', 'always')
DBinclude.SCRIPT_DIR=/opt/vertica/scripts
DBinclude.SHARE_DIR=/opt/vertica/share
DBinclude.TMP_DIR=/tmp
DBinclude.VERTICA_EGGS=/opt/vertica/share/eggs
DBinclude.adminToolErrorLog=/opt/vertica/log/adminTools-vertica.errors
DBinclude.adminToolLog=/opt/vertica/log/adminTools-vertica.log
DBinclude.adminToolLogUser=vertica
DBinclude.agentToolLog=/opt/vertica/log/agentTool-vertica.log
DBinclude.binDir=/opt/vertica/bin
DBinclude.binPath=/opt/vertica/bin/vertica
DBinclude.binPathCmdSetting=PATH=/opt/vertica/bin:$PATH; export PATH
DBinclude.commands=<module 'commands' from '/opt/vertica/oss/python/lib/python2.7/commands.pyc'>
DBinclude.copy=<module 'copy' from '/opt/vertica/oss/python/lib/python2.7/copy.pyc'>
DBinclude.dbDesignerConfig=/opt/vertica/config/configInfo/dbDesignerConfig
DBinclude.designParamsFile=design_params.txt
DBinclude.designParamsFileSuffix=_params.txt
DBinclude.designSchemaFileSuffix=_schema.xml
DBinclude.designerDiagManifest=/opt/vertica/log/DesignerDiagManifest.txt
DBinclude.designerErrorFile=designer_error.msg
DBinclude.designerLog=designer.log
DBinclude.getStringRep=<function getStringRep at 0x13070c8>
DBinclude.glob=<module 'glob' from '/opt/vertica/oss/python/lib/python2.7/glob.pyc'>
DBinclude.help_url=<function help_url at 0x13071b8>
DBinclude.libDir=/opt/vertica/lib
DBinclude.os=<module 'os' from '/opt/vertica/oss/python/lib/python2.7/os.pyc'>
DBinclude.pwd=<module 'pwd' (built-in)>
DBinclude.re=<module 're' from '/opt/vertica/oss/python/lib/python2.7/re.pyc'>
DBinclude.redesignParamsFile=redesign_params.txt
DBinclude.rpmDestFile=/tmp/dbRPM.rpm
DBinclude.rpmFC4_SrcInfoFile=/opt/vertica/config/configInfo/rpmFC4Info
DBinclude.rpmRHEL_SrcInfoFile=/opt/vertica/config/configInfo/rpmRHELInfo
DBinclude.rpmSUSE_SrcInfoFile=/opt/vertica/config/configInfo/rpmSUSEInfo
DBinclude.sbinDir=/opt/vertica/sbin
DBinclude.sys=<module 'sys' (built-in)>
DBinclude.uiMgrInput=None
DBinclude.uiMgrLog=/opt/vertica/log/uiMgr-vertica.log
Nov 25 14:07:07 [18217] [adminExec.__init__] Unique Ports: False
Nov 25 14:07:07 [18217] [adminExec.setInteractive] setting to True
Nov 25 14:07:07 [18217] [isOkToRun] owner of admintools.conf (dbauser) is vertica.
Any help on this would be greatly appreciated ...
Unable to create first database in Vertica (on CentOS)
Which version of Vertica are you using ?
Are you using dbadmin user to connect to Admintool utility ?
Are you using dbadmin user to connect to Admintool utility ?
Hi Mayank.. Thanks for replying...
It's Vertica Analytic Database v7.1.1-0.
I had created a user- 'vertica' while installation and tried to create the DB using this user.
It's Vertica Analytic Database v7.1.1-0.
I had created a user- 'vertica' while installation and tried to create the DB using this user.
Can you try creating the DB from the command line -
admintools -t create_db -s <hostname> -d <DB-NAME>
This should populate the admintools.conf, which has sometimes addressed this issue.
Hi Raul.. Thanks for replying.. I tried as per your suggestion. Please see the error i get now in the attached image.
.
This CentOS machine is not connected to any network. Could this be a cause?
.This CentOS machine is not connected to any network. Could this be a cause?
+1Hi,
was it a single node installation or a cluster?
was it a single node installation or a cluster?
Hi!
HOST isn't correct. Its not your problem, its awful python programmers at HP Vertica.
Let me show(emulate) your issue:
https://www.dropbox.com/s/pust0hyvh8xloo0/socket.pdf?dl=0
Ha! Same error and error message!
From example you can see, that the problem in python code, that process a wrong host name. Awful python programmers, Im too tired to fix their bugs.
What is your host name? You can find it with 'hostname' command:
HOST isn't correct. Its not your problem, its awful python programmers at HP Vertica.
Let me show(emulate) your issue:
https://www.dropbox.com/s/pust0hyvh8xloo0/socket.pdf?dl=0
Ha! Same error and error message!
From example you can see, that the problem in python code, that process a wrong host name. Awful python programmers, Im too tired to fix their bugs.
What is your host name? You can find it with 'hostname' command:
$ hostnameDaniel
synapse
my hostname is seen in the screen- TRVDBPHILIPSIGSDEVVL
Its on just one node in this case.
Hi!
so try to define a host (if it single node installation):
You asked for help , and I have to strain my eyes and try to discover what is written there in the picture? Do you have a conscience? Its so hard to do COPY/PASTE or to run command that I asked.
so try to define a host (if it single node installation):
-s '127.0.0.1'PS
You asked for help , and I have to strain my eyes and try to discover what is written there in the picture? Do you have a conscience? Its so hard to do COPY/PASTE or to run command that I asked.
...or you can ensure that the name is resolved to an IP address in /etc/hosts
sorry that i cudnt copy paste it as my CentOS machine is a remote machine.
This is the error now.
[vertica@TRVDBPHILIPSIGSDEVVL bin]$ adminTools -t create_db -s 127.0.0.1 -d IGS_Master
Info: no password specified, using none
Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
Error: host 127.0.0.1 does not appear to be part of this cluster.
Make sure you are using the correct hostname.
Content of host file.
[u22299@TRVDBPHILIPSIGSDEVVL ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
[vertica@TRVDBPHILIPSIGSDEVVL bin]$ adminTools -t create_db -s 127.0.0.1 -d IGS_Master
Info: no password specified, using none
Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
Error: host 127.0.0.1 does not appear to be part of this cluster.
Make sure you are using the correct hostname.
Content of host file.
[u22299@TRVDBPHILIPSIGSDEVVL ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
Hi!
Content of section "Cluster" are empty in your /opt/vertica/config/admintools.conf config file. Try manually to fill this sections:
Regards, Idiot.
Content of section "Cluster" are empty in your /opt/vertica/config/admintools.conf config file. Try manually to fill this sections:
[Cluster]And try to run install and if it fails post an error message.
hosts = 127.0.0.1
Regards, Idiot.
changed the conf file and tried to install again.
[root@TRVDBPHILIPSIGSDEVVL sbin]# ./install_vertica --hosts 127.0.0.1 --dba-user vertica --dba-user -password verticaVertica Analytic Database 7.1.1-0 Installation Tool
>> Validating options...
Mapping hostnames in --hosts (-s) to addresses...
>> Starting installation tasks.
>> Getting system information for cluster (this may take a while)...
Default shell on nodes:
127.0.0.1 /bin/bash
>> Validating software versions (rpm or deb)...
>> Beginning new cluster creation...
backing up admintools.conf on 127.0.0.1
>> Creating or validating DB Admin user/group...
Successful on hosts (1): 127.0.0.1
Provided DB Admin account details: user = vertica, group = verticadba, home = /home/vertica
Creating group... Group already exists
Validating group... Okay
Creating user... User already exists
Validating user... Okay
>> Validating node and cluster prerequisites...
Prerequisites not fully met during local (OS) configuration for
verify-127.0.0.1.xml:
HINT (S0305): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0305
TZ is unset for vertica. Consider updating .profile or .bashrc
HINT (S0041): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0041
Could not find the following tools normally provided by the mcelog
package: mcelog
FAIL (S0150): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0150
These disks do not have 'deadline' or 'noop' IO scheduling: '/dev/sda1'
('sda') = 'cfq', '/dev/sda2' ('sda') = 'cfq'
FAIL (S0020): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0020
Readahead size of sda (/dev/sda1,/dev/sda2) is too low for typical
systems: 256 < 2048
FAIL (S0030): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0030
ntpd process is not running: ['ntpd', 'ntp']
FAIL (S0081): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0081
SELinux appears to be enabled and not in permissive mode.
FAIL (S0310): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0310
Transparent hugepages is set to 'always'. Must be 'never' or 'madvise'.
System prerequisites failed. Threshold = WARN
Hint: Fix above failures or use --failure-threshold
Installation FAILED with errors.
****
AdminTools and your existing Vertica databases may be unavailable.
Investigate the above warnings/errors and re-run installation.
****
[root@TRVDBPHILIPSIGSDEVVL sbin]# ./install_vertica --hosts 127.0.0.1 --dba-user vertica --dba-user -password verticaVertica Analytic Database 7.1.1-0 Installation Tool
>> Validating options...
Mapping hostnames in --hosts (-s) to addresses...
>> Starting installation tasks.
>> Getting system information for cluster (this may take a while)...
Default shell on nodes:
127.0.0.1 /bin/bash
>> Validating software versions (rpm or deb)...
>> Beginning new cluster creation...
backing up admintools.conf on 127.0.0.1
>> Creating or validating DB Admin user/group...
Successful on hosts (1): 127.0.0.1
Provided DB Admin account details: user = vertica, group = verticadba, home = /home/vertica
Creating group... Group already exists
Validating group... Okay
Creating user... User already exists
Validating user... Okay
>> Validating node and cluster prerequisites...
Prerequisites not fully met during local (OS) configuration for
verify-127.0.0.1.xml:
HINT (S0305): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0305
TZ is unset for vertica. Consider updating .profile or .bashrc
HINT (S0041): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0041
Could not find the following tools normally provided by the mcelog
package: mcelog
FAIL (S0150): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0150
These disks do not have 'deadline' or 'noop' IO scheduling: '/dev/sda1'
('sda') = 'cfq', '/dev/sda2' ('sda') = 'cfq'
FAIL (S0020): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0020
Readahead size of sda (/dev/sda1,/dev/sda2) is too low for typical
systems: 256 < 2048
FAIL (S0030): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0030
ntpd process is not running: ['ntpd', 'ntp']
FAIL (S0081): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0081
SELinux appears to be enabled and not in permissive mode.
FAIL (S0310): https://my.vertica.com/docs/7.1.x/HTML/index.htm#cshid=S0310
Transparent hugepages is set to 'always'. Must be 'never' or 'madvise'.
System prerequisites failed. Threshold = WARN
Hint: Fix above failures or use --failure-threshold
Installation FAILED with errors.
****
AdminTools and your existing Vertica databases may be unavailable.
Investigate the above warnings/errors and re-run installation.
****
Hi!
So now everything is ok - problem is solved, just fix all your "FAILS". Don't ask us what "FAIL"s means - read the docs(each "FAIL" provides a link with error description and solution).
SOLVED
Regards, idiot.
So now everything is ok - problem is solved, just fix all your "FAILS". Don't ask us what "FAIL"s means - read the docs(each "FAIL" provides a link with error description and solution).
SOLVED
Regards, idiot.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
