Unable to create DB: Error : 127.0.0.1 Permission Denied

Use this forum to discuss Vertica error codes, what they mean and how to fix the issue that generated them

Moderator: NorbertKrupa

Post Reply
skor
Newbie
Newbie
Posts: 2
Joined: Fri Jun 09, 2017 7:52 pm

Unable to create DB: Error : 127.0.0.1 Permission Denied

Post by skor » Fri Jun 09, 2017 7:57 pm

Hello,

I have created a new user on the localhost but it keeps error'ing out on 127.0.0.1 Permission Denied

[testdbadmin@localhost vertica]$ /opt/vertica/bin/adminTools -t create_db -d test_stat -s 127.0.0.1 -l /usr/local/tester/vertica/Test_00003184_1TB.dat --skip-fs-checks
Info: no password specified, using none
Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
Distributing changes to cluster.
Error: The following nodes(s) could not be prepared:
Failed to prepare a host for database participation.
See /opt/vertica/log/adminTools.log for details. Host hints follow.
127.0.0.1 Permission Denied

[testdbadmin@localhost vertica]$


Why do I see this?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1736
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Unable to create DB: Error : 127.0.0.1 Permission Denied

Post by JimKnicely » Sat Jun 10, 2017 1:50 am

Hi,

Most likely cause is a lack of the required file system permissions for the database data directory (i.e. ability to write to a directory).

Does the /opt/vertica/log/adminTools.log show any errors?

When you installed Vertica, did you specify a data directory? If not, by default it will try to create the data directory in /home/dbadmin, assuming your database admin user is dbadmin...

Note that the /opt/vertica/config/admintools.conf file will show the install options ... Use this command:

grep install_opts /opt/vertica/config/admintools.conf

Thanks!
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

skor
Newbie
Newbie
Posts: 2
Joined: Fri Jun 09, 2017 7:52 pm

Re: Unable to create DB: Error : 127.0.0.1 Permission Denied

Post by skor » Tue Jun 13, 2017 8:11 pm

Hi ,

I tried the installation again but run into the same error.

I have specified the dbuser as "svadmin" (no password) and data-directory as /d2/vertica

[root@localhost vertica]# grep install_opts /opt/vertica/config/admintools.conf
install_opts = -s '127.0.0.1' -u svdbadmin --failure-threshold FAIL -d /d2/vertica

Logs from admintools.log at the time of error:
New invocation of AdminTools at ATMain.py:main()

2017-06-13 15:05:38.553 admintools/56713:0x7fc5273e6740 [SshAuth.setup_from_admintools_conf_if_needed] <INFO> Setup complete, default ssh user is svdbadmin, default ssh options are -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes.
2017-06-13 15:05:38.553 admintools/56713:0x7fc5273e6740 [adminExec.__init__] <INFO> Unique Ports: False
2017-06-13 15:05:38.554 admintools/56713:0x7fc5273e6740 [adminExec._is_current_user_conf_owner] <INFO> Owner of admintools.conf (dbauser) is svdbadmin.
2017-06-13 15:05:38.554 admintools/56713:0x7fc5273e6740 [adminExec.isOkToRun] <INFO>
2017-06-13 15:05:38.554 admintools/56713:0x7fc5273e6740 [ATMain.main] <INFO> Use unique ports = False
2017-06-13 15:05:38.554 admintools/56713:0x7fc5273e6740 [adminExec._is_current_user_conf_owner] <INFO> Owner of admintools.conf (dbauser) is svdbadmin.
2017-06-13 15:05:38.555 admintools/56713:0x7fc5273e6740 [adminExec.isOkToRun] <INFO>
2017-06-13 15:05:38.626 admintools/56718:0x7f0c9decd740 [root.setup_custom_logging] <INFO> New log for 'admintools'
2017-06-13 15:05:38.628 admintools/56718:0x7f0c9decd740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/bin/TXTlcheck.py' /opt/vertica/config /opt/vertica/bin
2017-06-13 15:05:38.802 admintools/56725:0x7fc17233d740 [root.setup_custom_logging] <INFO> New log for 'admintools'
2017-06-13 15:05:38.803 admintools/56725:0x7fc17233d740 [root.setup_custom_logging] <INFO> sys.argv: /opt/vertica/bin/adminTools -t create_db -d sv_stat -s '127.0.0.1' -l '/usr/local/Test/statsdb/vertica/Test_00003184_1TB.dat' --skip-fs-checks
2017-06-13 15:05:38.990 admintools/56725:0x7fc17233d740 [ATMain.main] <INFO>

New invocation of AdminTools at ATMain.py:main()

2017-06-13 15:05:38.992 admintools/56725:0x7fc17233d740 [SshAuth.setup_from_admintools_conf_if_needed] <INFO> Setup complete, default ssh user is svdbadmin, default ssh options are -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes.
2017-06-13 15:05:38.992 admintools/56725:0x7fc17233d740 [adminExec.__init__] <INFO> Unique Ports: False
2017-06-13 15:05:38.993 admintools/56725:0x7fc17233d740 [adminExec._is_current_user_conf_owner] <INFO> Owner of admintools.conf (dbauser) is svdbadmin.
2017-06-13 15:05:38.993 admintools/56725:0x7fc17233d740 [adminExec.isOkToRun] <INFO>
2017-06-13 15:05:38.993 admintools/56725:0x7fc17233d740 [ATMain.main] <INFO> Use unique ports = False
2017-06-13 15:05:38.993 admintools/56725:0x7fc17233d740 [adminExec._is_current_user_conf_owner] <INFO> Owner of admintools.conf (dbauser) is svdbadmin.
2017-06-13 15:05:38.994 admintools/56725:0x7fc17233d740 [adminExec.isOkToRun] <INFO>
2017-06-13 15:05:39.065 admintools/56729:0x7f04a235e740 [root.setup_custom_logging] <INFO> New log for 'admintools'
2017-06-13 15:05:39.067 admintools/56729:0x7f04a235e740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/bin/TXTlcheck.py' /opt/vertica/config /opt/vertica/bin
2017-06-13 15:05:39.074 admintools/56725:0x7fc17233d740 [OpSys._version_helper] <INFO> Found /etc/redhat-release
2017-06-13 15:05:39.074 admintools/56725:0x7fc17233d740 [OpSys._version_helper] <INFO> family: RedHat, version: 7.3.1611, version_major: 7, version_minor: 3
2017-06-13 15:05:39.075 admintools/56725:0x7fc17233d740 [adminExec.validateLicense] <INFO> Attempting to validate /usr/local/Test/statsdb/vertica/Test_00003184_1TB.dat (abspath = /usr/local/Test/statsdb/vertica/Test_00003184_1TB.dat)
2017-06-13 15:05:39.152 admintools/56725:0x7fc17233d740 [adminExec.validateLicense] <INFO> valid license of some sort: Vertica license is valid
Test
11/12/2015
Perpetual
30
1TB
2017-06-13 15:05:39.152 admintools/56725:0x7fc17233d740 [commandLineCtrl.isValidLicenseKey] <INFO> Validation of license file /usr/local/Test/statsdb/vertica/Test_00003184_1TB.dat produced code = True, message = Vertica license is valid
2017-06-13 15:05:39.153 admintools/56725:0x7fc17233d740 [ATFileTransporter._log_outbound] <INFO> copyLocalFileToHosts called with following options:
Local file: /opt/vertica/config/share/license.key
Host 127.0.0.1 Remote File /opt/vertica/config/share/license.key

2017-06-13 15:05:39.153 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> [ATFileTransporter] calling mkdir with {'127.0.0.1': '/tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3'}
2017-06-13 15:05:39.162 admintools/56725:0x7fc169795700 [SshAuth.get_ssh_info_default_user] <INFO> Connection info for 127.0.0.1 is SshConnectionInfo: ssh_user=svdbadmin api_user=None ident=None env={'PYTHON_EGG_CACHE': '/tmp'} options=-oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes
2017-06-13 15:05:39.167 admintools/56725:0x7fc169795700 [BashAdapter.connect_using_stored_auth] <INFO> Connected to host 127.0.0.1
2017-06-13 15:05:39.168 admintools/56725:0x7fc169795700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.make_directory']#{"target_path": "/tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3", "no_chmod": false, "mode": 504}
2017-06-13 15:05:39.351 at_exec/56737:0x7f8ee9a3c740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:39.352 at_exec/56737:0x7f8ee9a3c740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.make_directory'
2017-06-13 15:05:39.353 at_exec/56737:0x7f8ee9a3c740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:39.353 at_exec/56737:0x7f8ee9a3c740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:39.354 at_exec/56737:0x7f8ee9a3c740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'target_path': u'/tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3', u'no_chmod': False, u'mode': 504}
2017-06-13 15:05:39.365 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> Host: 127.0.0.1 Result: <ATResult> status=0 host=127.0.0.1 content={}

2017-06-13 15:05:39.365 admintools/56725:0x7fc17233d740 [SshAuth.get_ssh_info_default_user] <INFO> Connection info for 127.0.0.1 is SshConnectionInfo: ssh_user=svdbadmin api_user=None ident=None env={'PYTHON_EGG_CACHE': '/tmp'} options=-oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes
2017-06-13 15:05:39.371 admintools/56725:0x7fc17233d740 [Scp._local_run] <INFO> Local Scp: Running copy command cp -f /tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3/outbound_file /tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3/file
2017-06-13 15:05:39.375 admintools/56725:0x7fc17233d740 [ATFileTransporter._send_local_file] <INFO> [ATFileTransporter] Host 127.0.0.1 remote_fname /tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3/file return 0 output
2017-06-13 15:05:39.375 admintools/56725:0x7fc17233d740 [ATFileTransporter._move_sent_files] <INFO> Calling move staged files with
remote_temp = {'127.0.0.1': '/tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3/file'}, remote_dest = {'127.0.0.1': '/opt/vertica/config/share/license.key'}
2017-06-13 15:05:39.376 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.move_staged_files']#{"remove_parent_dirs": true, "untar_file": false, "staged_file": "/tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3/file", "dest_path": "/opt/vertica/config/share/license.key"}
2017-06-13 15:05:39.542 at_exec/56743:0x7f912b5f7740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:39.544 at_exec/56743:0x7f912b5f7740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.move_staged_files'
2017-06-13 15:05:39.545 at_exec/56743:0x7f912b5f7740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:39.545 at_exec/56743:0x7f912b5f7740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:39.547 at_exec/56743:0x7f912b5f7740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'untar_file': False, u'remove_parent_dirs': True, u'staged_file': u'/tmp/vstage-27c1be09-7180-4f12-8ef1-44f8fe1f15b3/file', u'dest_path': u'/opt/vertica/config/share/license.key'}
2017-06-13 15:05:39.562 admintools/56725:0x7fc17233d740 [adminExec.send_license_to_all_hosts] <INFO> License transfer to 127.0.0.1 had status True

2017-06-13 15:05:39.664 admintools/56725:0x7fc17233d740 [commandLineCtrl._createDB_validNodes] <INFO> License has max node count None
2017-06-13 15:05:39.665 admintools/56725:0x7fc17233d740 [adminExec.do_create_node] <INFO> creating node w/ ['v_sv_stat_node0001', '127.0.0.1', '/home/dbadmin', '/home/dbadmin']
2017-06-13 15:05:39.666 admintools/56725:0x7fc17233d740 [Configurator.save] <INFO> Wrote state to file: /opt/vertica/config/admintools.conf
2017-06-13 15:05:39.667 admintools/56725:0x7fc17233d740 [ATFileTransporter._log_outbound] <INFO> copyLocalFileToHosts called with following options:
Local file: /opt/vertica/config/admintools.conf
Host 127.0.0.1 Remote File /opt/vertica/config/admintools.conf

2017-06-13 15:05:39.668 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> [ATFileTransporter] calling mkdir with {'127.0.0.1': '/tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123'}
2017-06-13 15:05:39.694 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.make_directory']#{"target_path": "/tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123", "no_chmod": false, "mode": 504}
2017-06-13 15:05:39.847 admintools/56750:0x7f33458ba740 [root.setup_custom_logging] <INFO> New log for 'admintools'
2017-06-13 15:05:39.848 admintools/56750:0x7f33458ba740 [root.setup_custom_logging] <INFO> sys.argv: /opt/vertica/bin/adminTools -t db_status -s up
2017-06-13 15:05:40.058 at_exec/56752:0x7f5219f76740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:40.071 at_exec/56752:0x7f5219f76740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.make_directory'
2017-06-13 15:05:40.072 at_exec/56752:0x7f5219f76740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:40.073 at_exec/56752:0x7f5219f76740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:40.073 at_exec/56752:0x7f5219f76740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'target_path': u'/tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123', u'no_chmod': False, u'mode': 504}
2017-06-13 15:05:40.096 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> Host: 127.0.0.1 Result: <ATResult> status=0 host=127.0.0.1 content={}

2017-06-13 15:05:40.096 admintools/56725:0x7fc17233d740 [SshAuth.get_ssh_info_default_user] <INFO> Connection info for 127.0.0.1 is SshConnectionInfo: ssh_user=svdbadmin api_user=None ident=None env={'PYTHON_EGG_CACHE': '/tmp'} options=-oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes
2017-06-13 15:05:40.125 admintools/56725:0x7fc17233d740 [Scp._local_run] <INFO> Local Scp: Running copy command cp -f /tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123/outbound_file /tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123/file
2017-06-13 15:05:40.140 admintools/56725:0x7fc17233d740 [ATFileTransporter._send_local_file] <INFO> [ATFileTransporter] Host 127.0.0.1 remote_fname /tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123/file return 0 output
2017-06-13 15:05:40.140 admintools/56725:0x7fc17233d740 [ATFileTransporter._move_sent_files] <INFO> Calling move staged files with
remote_temp = {'127.0.0.1': '/tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123/file'}, remote_dest = {'127.0.0.1': '/opt/vertica/config/admintools.conf'}
2017-06-13 15:05:40.153 admintools/56725:0x7fc169795700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.move_staged_files']#{"remove_parent_dirs": true, "untar_file": false, "staged_file": "/tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123/file", "dest_path": "/opt/vertica/config/admintools.conf"}
2017-06-13 15:05:40.229 admintools/56750:0x7f33458ba740 [ATMain.main] <INFO>

New invocation of AdminTools at ATMain.py:main()

2017-06-13 15:05:40.232 admintools/56750:0x7f33458ba740 [SshAuth.setup_from_admintools_conf_if_needed] <INFO> Setup complete, default ssh user is svdbadmin, default ssh options are -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes.
2017-06-13 15:05:40.232 admintools/56750:0x7f33458ba740 [adminExec.__init__] <INFO> Unique Ports: False
2017-06-13 15:05:40.232 admintools/56750:0x7f33458ba740 [adminExec._is_current_user_conf_owner] <INFO> Owner of admintools.conf (dbauser) is svdbadmin.
2017-06-13 15:05:40.232 admintools/56750:0x7f33458ba740 [adminExec.isOkToRun] <INFO>
2017-06-13 15:05:40.233 admintools/56750:0x7f33458ba740 [ATMain.main] <INFO> Use unique ports = False
2017-06-13 15:05:40.233 admintools/56750:0x7f33458ba740 [adminExec._is_current_user_conf_owner] <INFO> Owner of admintools.conf (dbauser) is svdbadmin.
2017-06-13 15:05:40.233 admintools/56750:0x7f33458ba740 [adminExec.isOkToRun] <INFO>
2017-06-13 15:05:40.396 admintools/56763:0x7f8873e0a740 [root.setup_custom_logging] <INFO> New log for 'admintools'
2017-06-13 15:05:40.398 admintools/56763:0x7f8873e0a740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/bin/TXTlcheck.py' /opt/vertica/config /opt/vertica/bin
2017-06-13 15:05:40.474 at_exec/56760:0x7f5573f31740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:40.475 at_exec/56760:0x7f5573f31740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.move_staged_files'
2017-06-13 15:05:40.477 at_exec/56760:0x7f5573f31740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:40.477 at_exec/56760:0x7f5573f31740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:40.479 at_exec/56760:0x7f5573f31740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'untar_file': False, u'remove_parent_dirs': True, u'staged_file': u'/tmp/vstage-b4ca1c3c-12cd-4337-9085-9b0196d93123/file', u'dest_path': u'/opt/vertica/config/admintools.conf'}
2017-06-13 15:05:40.491 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.check_file_exists']#{"file_list": "/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat"}
2017-06-13 15:05:40.672 at_exec/56765:0x7f86c0450740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:40.673 at_exec/56765:0x7f86c0450740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.check_file_exists'
2017-06-13 15:05:40.674 at_exec/56765:0x7f86c0450740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:40.674 at_exec/56765:0x7f86c0450740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:40.675 at_exec/56765:0x7f86c0450740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'file_list': u'/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat'}
2017-06-13 15:05:40.686 admintools/56725:0x7fc17233d740 [ATFileTransporter._log_outbound] <INFO> copyLocalFileToHosts called with following options:
Local file: /opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat
Host 127.0.0.1 Remote File /opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat

2017-06-13 15:05:40.688 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> [ATFileTransporter] calling mkdir with {'127.0.0.1': '/tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782'}
2017-06-13 15:05:40.689 admintools/56725:0x7fc169795700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.make_directory']#{"target_path": "/tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782", "no_chmod": false, "mode": 504}
2017-06-13 15:05:40.882 at_exec/56768:0x7f5cd3c28740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:40.884 at_exec/56768:0x7f5cd3c28740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.make_directory'
2017-06-13 15:05:40.885 at_exec/56768:0x7f5cd3c28740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:40.885 at_exec/56768:0x7f5cd3c28740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:40.885 at_exec/56768:0x7f5cd3c28740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'target_path': u'/tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782', u'no_chmod': False, u'mode': 504}
2017-06-13 15:05:40.896 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> Host: 127.0.0.1 Result: <ATResult> status=0 host=127.0.0.1 content={}

2017-06-13 15:05:40.897 admintools/56725:0x7fc17233d740 [SshAuth.get_ssh_info_default_user] <INFO> Connection info for 127.0.0.1 is SshConnectionInfo: ssh_user=svdbadmin api_user=None ident=None env={'PYTHON_EGG_CACHE': '/tmp'} options=-oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes
2017-06-13 15:05:40.903 admintools/56725:0x7fc17233d740 [Scp._local_run] <INFO> Local Scp: Running copy command cp -f /tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782/outbound_file /tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782/file
2017-06-13 15:05:40.907 admintools/56725:0x7fc17233d740 [ATFileTransporter._send_local_file] <INFO> [ATFileTransporter] Host 127.0.0.1 remote_fname /tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782/file return 0 output
2017-06-13 15:05:40.907 admintools/56725:0x7fc17233d740 [ATFileTransporter._move_sent_files] <INFO> Calling move staged files with
remote_temp = {'127.0.0.1': '/tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782/file'}, remote_dest = {'127.0.0.1': '/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat'}
2017-06-13 15:05:40.908 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.move_staged_files']#{"remove_parent_dirs": true, "untar_file": false, "staged_file": "/tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782/file", "dest_path": "/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat"}
2017-06-13 15:05:41.076 at_exec/56775:0x7fd7cee6a740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:41.077 at_exec/56775:0x7fd7cee6a740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.move_staged_files'
2017-06-13 15:05:41.079 at_exec/56775:0x7fd7cee6a740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:41.079 at_exec/56775:0x7fd7cee6a740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:41.081 at_exec/56775:0x7fd7cee6a740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'untar_file': False, u'remove_parent_dirs': True, u'staged_file': u'/tmp/vstage-3541aafd-9fc3-49e0-878c-c6bbfd87e782/file', u'dest_path': u'/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat'}
2017-06-13 15:05:41.093 admintools/56725:0x7fc17233d740 [adminExec.createDB] <INFO> creating db sv_stat
2017-06-13 15:05:41.093 admintools/56725:0x7fc17233d740 [adminExec._createDB_integrityChecks] <INFO> Running integrity checks on [<vertica.config.VDatabase.VNode instance at 0x7fc169c16ab8>]
2017-06-13 15:05:41.097 admintools/56725:0x7fc17233d740 [agent_log_util.event] <INFO> EVENT: type=Status job None {"type":"NODEHOST", "state":"VALIDATING", "host":"127.0.0.1", "node":"v_sv_stat_node0001", "dbname":"sv_stat", "msg":"Running Integrity Checks", "maxSteps":"6", "currStep":"1"}
2017-06-13 15:05:41.144 admintools/56725:0x7fc17233d740 [adminExec._createDB_getPort] <INFO> Will create database on port 5433
2017-06-13 15:05:41.144 admintools/56725:0x7fc17233d740 [adminExec._createDB_getPort] <INFO> Checking that nodes are defined and installed
2017-06-13 15:05:41.145 admintools/56725:0x7fc17233d740 [agent_log_util.event] <INFO> EVENT: type=Status job None {"type":"NODEHOST", "state":"VALIDATING", "host":"127.0.0.1", "node":"v_sv_stat_node0001", "dbname":"sv_stat", "msg":"Validating RPM", "maxSteps":"6", "currStep":"2"}
2017-06-13 15:05:41.145 admintools/56725:0x7fc17233d740 [vertica_versions_match.__init__] <INFO> init
2017-06-13 15:05:41.145 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.vertica_versions_match']#{}
2017-06-13 15:05:41.316 at_exec/56780:0x7f6519def740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:41.317 at_exec/56780:0x7f6519def740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.vertica_versions_match'
2017-06-13 15:05:41.318 at_exec/56780:0x7f6519def740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:41.318 at_exec/56780:0x7f6519def740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:41.319 at_exec/56780:0x7f6519def740 [vertica_versions_match.__init__] <INFO> init
2017-06-13 15:05:41.319 at_exec/56780:0x7f6519def740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={}
2017-06-13 15:05:41.319 at_exec/56780:0x7f6519def740 [vertica_versions_match.run_in_subprocess] <INFO> run_in_subprocess: ['/opt/vertica/bin/vertica', '-V']None
2017-06-13 15:05:41.367 admintools/56725:0x7fc17233d740 [vertica_versions_match._set_state_from_results] <INFO> host 127.0.0.1 current_version gets Vertica Analytic Database v8.1.0-0
vertica(v8.1.0-0) built by jeeves@build-centos6 from tag@releases/VER_8_1_RELEASE_BUILD_0_0_20170331 on 'Fri Mar 31 19:31:49 2017' $BuildId$

2017-06-13 15:05:41.367 admintools/56725:0x7fc17233d740 [agent_log_util.event] <INFO> EVENT: type=Status job None {"type":"NODEHOST", "state":"VALIDATING", "host":"127.0.0.1", "node":"v_sv_stat_node0001", "dbname":"sv_stat", "msg":"Validating Cluster", "maxSteps":"6", "currStep":"3"}
2017-06-13 15:05:41.367 admintools/56725:0x7fc17233d740 [ATDispatcher.get_unreachable_hosts] <INFO> get_unreachable_hosts: host_list: ['127.0.0.1']
2017-06-13 15:05:41.367 admintools/56725:0x7fc17233d740 [ATDispatcher.get_unreachable_hosts] <INFO> get_unreachable_hosts: down_hosts: []; current_unreachables: []
2017-06-13 15:05:41.367 admintools/56725:0x7fc17233d740 [ATFileTransporter._log_outbound] <INFO> copyLocalFileToHosts called with following options:
Local file: /opt/vertica/config/share/license.key
Host 127.0.0.1 Remote File /opt/vertica/config/share/license.key

2017-06-13 15:05:41.368 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> [ATFileTransporter] calling mkdir with {'127.0.0.1': '/tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2'}
2017-06-13 15:05:41.369 admintools/56725:0x7fc169795700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.make_directory']#{"target_path": "/tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2", "no_chmod": false, "mode": 504}
2017-06-13 15:05:41.537 at_exec/56785:0x7f7db1084740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:41.538 at_exec/56785:0x7f7db1084740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.make_directory'
2017-06-13 15:05:41.539 at_exec/56785:0x7f7db1084740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:41.539 at_exec/56785:0x7f7db1084740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:41.540 at_exec/56785:0x7f7db1084740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'target_path': u'/tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2', u'no_chmod': False, u'mode': 504}
2017-06-13 15:05:41.551 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> Host: 127.0.0.1 Result: <ATResult> status=0 host=127.0.0.1 content={}

2017-06-13 15:05:41.551 admintools/56725:0x7fc17233d740 [SshAuth.get_ssh_info_default_user] <INFO> Connection info for 127.0.0.1 is SshConnectionInfo: ssh_user=svdbadmin api_user=None ident=None env={'PYTHON_EGG_CACHE': '/tmp'} options=-oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes
2017-06-13 15:05:41.557 admintools/56725:0x7fc17233d740 [Scp._local_run] <INFO> Local Scp: Running copy command cp -f /tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2/outbound_file /tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2/file
2017-06-13 15:05:41.560 admintools/56725:0x7fc17233d740 [ATFileTransporter._send_local_file] <INFO> [ATFileTransporter] Host 127.0.0.1 remote_fname /tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2/file return 0 output
2017-06-13 15:05:41.561 admintools/56725:0x7fc17233d740 [ATFileTransporter._move_sent_files] <INFO> Calling move staged files with
remote_temp = {'127.0.0.1': '/tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2/file'}, remote_dest = {'127.0.0.1': '/opt/vertica/config/share/license.key'}
2017-06-13 15:05:41.561 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.move_staged_files']#{"remove_parent_dirs": true, "untar_file": false, "staged_file": "/tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2/file", "dest_path": "/opt/vertica/config/share/license.key"}
2017-06-13 15:05:41.744 at_exec/56791:0x7f58804c4740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:41.745 at_exec/56791:0x7f58804c4740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.move_staged_files'
2017-06-13 15:05:41.746 at_exec/56791:0x7f58804c4740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:41.746 at_exec/56791:0x7f58804c4740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:41.748 at_exec/56791:0x7f58804c4740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'untar_file': False, u'remove_parent_dirs': True, u'staged_file': u'/tmp/vstage-6466a28b-7add-4e61-bc88-5fa54b6959d2/file', u'dest_path': u'/opt/vertica/config/share/license.key'}
2017-06-13 15:05:41.761 admintools/56725:0x7fc17233d740 [adminExec._createDB_initiatorSetup] <INFO> Nominated initiator node (name v_sv_stat_node0001, catalogpath /home/dbadmin/sv_stat/v_sv_stat_node0001_catalog, storagelocs ['/home/dbadmin/sv_stat/v_sv_stat_node0001_data'], host 127.0.0.1, port 5433, oid None, controlnode None, startcmd [None])
2017-06-13 15:05:41.761 admintools/56725:0x7fc17233d740 [adminExec._createDB_makeDirs] <INFO> Creating catalog and data directories
2017-06-13 15:05:41.762 admintools/56725:0x7fc17233d740 [agent_log_util.event] <INFO> EVENT: type=Status job None {"type":"NODEHOST", "state":"VALIDATING", "host":"127.0.0.1", "node":"v_sv_stat_node0001", "dbname":"sv_stat", "msg":"Creating Catalog and Data Directories", "maxSteps":"6", "currStep":"4"}
2017-06-13 15:05:41.762 admintools/56725:0x7fc169795700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.prepare_database']#{"node": {"name": "v_sv_stat_node0001", "storagelocs": ["/home/dbadmin/sv_stat/v_sv_stat_node0001_data"], "oid": null, "host": "127.0.0.1", "catalogpath": "/home/dbadmin/sv_stat/v_sv_stat_node0001_catalog", "controlnode": null, "startcmd": null, "port": 5433}, "db_name": "sv_stat", "skip_file_system_checks": true}
2017-06-13 15:05:41.935 at_exec/56794:0x7fe674cc6740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:41.936 at_exec/56794:0x7fe674cc6740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.prepare_database'
2017-06-13 15:05:41.937 at_exec/56794:0x7fe674cc6740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:41.937 at_exec/56794:0x7fe674cc6740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:41.941 at_exec/56794:0x7fe674cc6740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'node': {u'name': u'v_sv_stat_node0001', u'storagelocs': [u'/home/dbadmin/sv_stat/v_sv_stat_node0001_data'], u'oid': None, u'host': u'127.0.0.1', u'catalogpath': u'/home/dbadmin/sv_stat/v_sv_stat_node0001_catalog', u'controlnode': None, u'startcmd': None, u'port': 5433}, u'db_name': u'sv_stat', u'skip_file_system_checks': True}
2017-06-13 15:05:41.954 admintools/56725:0x7fc17233d740 [adminExec._createDB_makeDirs] <INFO> Exception on host 127.0.0.1: Access Denied. Message [Errno 13] Permission denied: '/home/dbadmin/sv_stat' Traceback (most recent call last):
File "/opt/vertica/share/eggs/vertica/engine/api/at_runner.py", line 37, in exec_module
result = instance.execute(command)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/api/prepare_database.py", line 115, in execute
return self._execute_impl(cmd, result)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/api/prepare_database.py", line 130, in _execute_impl
self._make_all_db_dirs(node, result)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/api/prepare_database.py", line 155, in _make_all_db_dirs
"Access Denied. Message {0}".format(e))
ATDBPrepareError: Access Denied. Message [Errno 13] Permission denied: '/home/dbadmin/sv_stat'
None

2017-06-13 15:05:41.955 admintools/56725:0x7fc168f94700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.cleanup_prepare']#{"node": {"name": "v_sv_stat_node0001", "storagelocs": ["/home/dbadmin/sv_stat/v_sv_stat_node0001_data"], "oid": null, "host": "127.0.0.1", "catalogpath": "/home/dbadmin/sv_stat/v_sv_stat_node0001_catalog", "controlnode": null, "startcmd": null, "port": 5433}, "preserve_parent": true}
2017-06-13 15:05:42.128 at_exec/56797:0x7fa961b4f740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:42.129 at_exec/56797:0x7fa961b4f740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.cleanup_prepare'
2017-06-13 15:05:42.130 at_exec/56797:0x7fa961b4f740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:42.130 at_exec/56797:0x7fa961b4f740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:42.131 at_exec/56797:0x7fa961b4f740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'node': {u'name': u'v_sv_stat_node0001', u'storagelocs': [u'/home/dbadmin/sv_stat/v_sv_stat_node0001_data'], u'oid': None, u'host': u'127.0.0.1', u'catalogpath': u'/home/dbadmin/sv_stat/v_sv_stat_node0001_catalog', u'controlnode': None, u'startcmd': None, u'port': 5433}, u'preserve_parent': True}
2017-06-13 15:05:42.142 admintools/56725:0x7fc17233d740 [prepare_database.get_user_message] <INFO> Formatting hint [Permission Denied] for result: host 127.0.0.1 msg [<ATResult> status=2 host=127.0.0.1 error_type=<class 'vertica.engine.api.errors.ATDBPrepareError'> error_message=Access Denied. Message [Errno 13] Permission denied: '/home/dbadmin/sv_stat'

Stack Trace from Executor follows
Traceback (most recent call last):
File "/opt/vertica/share/eggs/vertica/engine/api/at_runner.py", line 37, in exec_module
result = instance.execute(command)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/api/prepare_database.py", line 115, in execute
return self._execute_impl(cmd, result)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/api/prepare_database.py", line 130, in _execute_impl
self._make_all_db_dirs(node, result)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/api/prepare_database.py", line 155, in _make_all_db_dirs
"Access Denied. Message {0}".format(e))
ATDBPrepareError: Access Denied. Message [Errno 13] Permission denied: '/home/dbadmin/sv_stat'
]
2017-06-13 15:05:42.143 admintools/56725:0x7fc17233d740 [Configurator.save] <INFO> Wrote state to file: /opt/vertica/config/admintools.conf
2017-06-13 15:05:42.144 admintools/56725:0x7fc17233d740 [ATFileTransporter._log_outbound] <INFO> copyLocalFileToHosts called with following options:
Local file: /opt/vertica/config/admintools.conf
Host 127.0.0.1 Remote File /opt/vertica/config/admintools.conf

2017-06-13 15:05:42.144 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> [ATFileTransporter] calling mkdir with {'127.0.0.1': '/tmp/vstage-dcc8dd4f-93c1-4985-aa06-beab6fa56127'}
2017-06-13 15:05:42.145 admintools/56725:0x7fc169795700 [BashAdapter._exec_module_impl] <INFO> Running command ['/opt/vertica/oss/python/bin/python', '-m', 'vertica.engine.api.at_runner', '--no-prompt', '--module', 'vertica.engine.api.make_directory']#{"target_path": "/tmp/vstage-dcc8dd4f-93c1-4985-aa06-beab6fa56127", "no_chmod": false, "mode": 504}
2017-06-13 15:05:42.314 at_exec/56800:0x7f64160ce740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2017-06-13 15:05:42.315 at_exec/56800:0x7f64160ce740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/share/eggs/vertica/engine/api/at_runner.py' --no-prompt --module 'vertica.engine.api.make_directory'
2017-06-13 15:05:42.316 at_exec/56800:0x7f64160ce740 [ATRunner._parse_command] <INFO> Reading a line from stdin...
2017-06-13 15:05:42.316 at_exec/56800:0x7f64160ce740 [ATRunner._parse_command] <INFO> Reading complete
2017-06-13 15:05:42.317 at_exec/56800:0x7f64160ce740 [ATRunner.exec_module] <INFO> ATRunner exec_module: command: <ATCommand> module=None version=1.0 args={u'target_path': u'/tmp/vstage-dcc8dd4f-93c1-4985-aa06-beab6fa56127', u'no_chmod': False, u'mode': 504}
2017-06-13 15:05:42.339 admintools/56725:0x7fc17233d740 [ATFileTransporter._prepare_remote_staging_dir] <INFO> Host: 127.0.0.1 Result: <ATResult> status=0 host=127.0.0.1 content={}


The error says : ATDBPrepareError: Access Denied. Message [Errno 13] Permission denied: '/home/dbadmin/sv_stat'

A wild guess here .. should it not create sv_stat be created under /home/svdbadmin instead of /home/dbadmin ?[/quote][/glow]

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1736
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Unable to create DB: Error : 127.0.0.1 Permission Denied

Post by JimKnicely » Wed Jun 14, 2017 7:48 pm

Hi,

Check the [nodes] section of your /opt/vertica/config/admintools.conf file. You should see an entry like this:

[Nodes]
node0001 = 127.0.0.1,/d2/vertica,/d2/vertica

If you see this, then something went wrong with the install...

[Nodes]
node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin

If you haven't done anything yet (i.e. create a DB), I'd do the following:

As root:

1. Uninstall the Vertica RPM
2. Delete the /opt/vertica directory
3. Reinstall the Vertica RPM
4. Run the installer using the options -u svdbadmin -d /d2/vertica --failure-threshold FAIL

Then check the /opt/vertica/config/admintools.conf file again to make sure it is correct.

If you don't want to so that, you can log in as the svdbadmin user directly (don't su to it)... Then run the create db command specifying the data and catalog path for your new database using the -D and -c parameters:

/opt/vertica/bin/adminTools -t create_db -d test_stat -s 127.0.0.1 -l /usr/local/tester/vertica/Test_00003184_1TB.dat -D /d2/vertica -c /d2/vertica --skip-fs-checks

That should work.
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Error Codes”

Who is online

Users browsing this forum: No registered users and 1 guest