Some more questions, It seems that the OU=NIFI is hardcoded, I see this when I look at the certificate? Even if I set the FQDN to something else, the certificate seems to come in with OU=NIFI? Do you need a certificate for the user and the server, IE are there 2 certificates to be imported? When you run a clustered NiFi operation, the UI what you use, is this one specific server, IOW, at the moment I have 4 NiFi Quick links where I can open the GUI from, but seeing that all the flows etc should be the same, should there only be one? So here you would only specify the "master" or entry GUI server? Any document links that works would be appreciated please! ... View more

Hi @Thomas Williams The error seems to be caused by incorrect paths to the keystore.jks and or incorrect generation of the keystore.jks, I have my NiFi Registry switched off now, I'm trying to get Ranger and NiFi to talk to each other so that I can get Ranger to authenticate the NiFi users, it has been an uphill battle Cheers ... View more

I get exactly the same ambari-server upgrade Using python /usr/bin/python Upgrading ambari-server INFO: Upgrade Ambari Server INFO: Updating Ambari Server properties in ambari.properties ... WARNING: Can not find ambari.properties.rpmsave file from previous version, skipping import of settings INFO: Updating Ambari Server properties in ambari-env.sh ... INFO: Can not find ambari-env.sh.rpmsave file from previous version, skipping restore of environment settings. ambari-env.sh may not include any user customization. INFO: Fixing database objects owner Ambari Server configured for Postgres. Confirm you have made a backup of the Ambari Server database [y/n] (y)? y INFO: Upgrading database schema INFO: Return code from schema upgrade command, retcode = 1 ERROR: Error executing schema upgrade, please check the server logs. ERROR: Error output from schema upgrade command: ERROR: Exception in thread "main" org.apache.ambari.server.AmbariException: Unable to find any CURRENT repositories. at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:203) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:418) Caused by: org.apache.ambari.server.AmbariException: Unable to find any CURRENT repositories. at org.apache.ambari.server.upgrade.UpgradeCatalog260.getCurrentVersionID(UpgradeCatalog260.java:510) at org.apache.ambari.server.upgrade.UpgradeCatalog260.executeDDLUpdates(UpgradeCatalog260.java:194) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:923) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:200) ... 1 more ERROR: Ambari server upgrade failed. Please look at /var/log/ambari-server/ambari-server.log, for more details. ERROR: Exiting with exit code 11. REASON: Schema upgrade failed. The patch mentioned here Looks like you are hitting the issue reported in the JIRA: https://issues.apache.org/jira/browse/AMBARI-22469 which is expected to be addressed in Ambari 2.6.1 Seem NOT to be able to apply? -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12898511/AMBARI-22469.patch against trunk revision . -1 patch. The patch command could not apply the patch. Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/12699//console This message is automatically generated. I tried looking for the involved files, but I cannot find them, does anyone know how I would be able to get past this please BTW its not the yum repos problem, mine seem to be ok yum repolist Loaded plugins: fastestmirror HDP-2.6.3.0 | 2.9 kB 00:00:00 HDP-UTILS-1.1.0.21 | 2.9 kB 00:00:00 Supporting-repo | 2.9 kB 00:00:00 ambari-ambari-2.6.0.0 | 2.9 kB 00:00:00 (1/4): HDP-2.6.3.0/primary_db | 99 kB 00:00:00 (2/4): HDP-UTILS-1.1.0.21/primary_db | 37 kB 00:00:00 (3/4): Supporting-repo/primary_db | 91 kB 00:00:00 (4/4): ambari-ambari-2.6.0.0/primary_db | 12 kB 00:00:00 Determining fastest mirrors repo id repo name status HDP-2.6.3.0 HDP Version - HDP-2.6.3.0 236 HDP-UTILS-1.1.0.21 HDP-UTILS Version - HDP-UTILS-1.1.0.21 64 Supporting-repo Supporting-repo 121 ambari-ambari-2.6.0.0 ambari Version - ambari-ambari-2.6.0.0 15 repolist: 436 ... View more

Thanks so much, I did that and then hit the next problem, this is like hitting your head against a solid brick wall... ambari=# CREATE TABLE cluster_version ( ambari(# id BIGINT NOT NULL, ambari(# repo_version_id BIGINT NOT NULL, ambari(# cluster_id BIGINT NOT NULL, ambari(# state VARCHAR(32) NOT NULL, ambari(# start_time BIGINT NOT NULL, ambari(# end_time BIGINT, ambari(# user_name VARCHAR(32)); CREATE TABLE ambari=# ambari-server upgrade Using python /usr/bin/python Upgrading ambari-server INFO: Upgrade Ambari Server INFO: Updating Ambari Server properties in ambari.properties ... WARNING: Can not find ambari.properties.rpmsave file from previous version, skipping import of settings INFO: Updating Ambari Server properties in ambari-env.sh ... INFO: Can not find ambari-env.sh.rpmsave file from previous version, skipping restore of environment settings. ambari-env.sh may not include any user customization. INFO: Fixing database objects owner Ambari Server configured for Postgres. Confirm you have made a backup of the Ambari Server database [y/n] (y)? y INFO: Upgrading database schema INFO: Return code from schema upgrade command, retcode = 1 ERROR: Error executing schema upgrade, please check the server logs. ERROR: Error output from schema upgrade command: ERROR: Exception in thread "main" java.lang.Exception: Unexpected error, upgrade failed at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:441) Caused by: java.lang.RuntimeException: Unable to read database version at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.readSourceVersion(SchemaUpgradeHelper.java:97) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:402) Caused by: org.postgresql.util.PSQLException: ERROR: relation "metainfo" does not exist Position: 30 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.readSourceVersion(SchemaUpgradeHelper.java:90) ... 1 more ERROR: Ambari server upgrade failed. Please look at /var/log/ambari-server/ambari-server.log, for more details. ERROR: Exiting with exit code 11. REASON: Schema upgrade failed. ... View more

I've now installed Postgres 9.4 with Ambari 2.5.0.3, upgraded Ambari to 2.6.0.0 but when I do the upgrade, I get another Postgres issue java.lang.IllegalArgumentException: cluster_version table does not contain repo_version_id column ambari-server upgrade Using python /usr/bin/python Upgrading ambari-server INFO: Upgrade Ambari Server INFO: Updating Ambari Server properties in ambari.properties ... INFO: Updating Ambari Server properties in ambari-env.sh ... WARNING: Original file ambari-env.sh kept INFO: Fixing database objects owner Ambari Server configured for Postgres. Confirm you have made a backup of the Ambari Server database [y/n] (y)? y INFO: Upgrading database schema INFO: Return code from schema upgrade command, retcode = 1 ERROR: Error executing schema upgrade, please check the server logs. ERROR: Error output from schema upgrade command: ERROR: Exception in thread "main" org.apache.ambari.server.AmbariException: cluster_version table does not contain repo_version_id column at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:203) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:418) Caused by: java.lang.IllegalArgumentException: cluster_version table does not contain repo_version_id column at org.apache.ambari.server.orm.DBAccessorImpl.getIntColumnValues(DBAccessorImpl.java:1536) at org.apache.ambari.server.upgrade.UpgradeCatalog260.getCurrentVersionID(UpgradeCatalog260.java:507) at org.apache.ambari.server.upgrade.UpgradeCatalog260.executeDDLUpdates(UpgradeCatalog260.java:194) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:923) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:200) ... 1 more ERROR: Ambari server upgrade failed. Please look at /var/log/ambari-server/ambari-server.log, for more details. ERROR: Exiting with exit code 11. REASON: Schema upgrade failed. ... View more

Hi @ Josh Elser I made the changes on the OS disabling the IPV6 and that seems to have done the trick, thanks so much for the suggestion [root@server02 ~]# vi /etc/sysctl.conf [root@server02 ~]# sysctl -p net.ipv4.tcp_keepalive_time = 300 net.ipv4.ip_local_port_range = 1024 65000 fs.file-max = 64000 net.ipv6.conf.all.disable_ipv6 = 1 net.ipv6.conf.default.disable_ipv6 = 1 [root@server02 ~]# systemctl restart network [root@server02 ~]# ... View more

Thanks @ Josh Elser I going to disable IPV6 on OS level and I'll try the -Djava.net.preferIPv4Stack=true as well. One thing though, you say e.g. for "10.0.0.1", generate "1.0.0.10.in-addr.arpa" , the way I understand the rDNS lookup is that it will swap the 1st 2 and the last 2, IE 192.168.1.101 will be 168.192.101.1, see my DNS entries below, I'm thinking that if the resolve is like "10.0.0.1", generate "1.0.0.10.in-addr.arpa" , my entries will not be "hit" and that might be the problem? zone "168.192.in-addr.arpa" { type master; file "/etc/named/zones/db.192.168"; # 192.168.1 subnet }; [root@server01 zones]# cat db.192.168 $TTL 604800 @ IN SOA server01int.xxxx.com. admin.xxxx.com. ( 3 ; Serial 604800 ; Refresh 86400 ; Retry 2419200 ; Expire 604800 ) ; Negative Cache TTL ; name servers - NS records IN NS server01int.xxxx.com. IN NS server02int.xxxx.com. ; PTR Records 101.1 IN PTR server01int.xxxx.com. ; 192.168.1.101 102.1 IN PTR server02int.xxxx.com. ; 192.168.1.102 103.1 IN PTR server03int.xxxx.com. ; 192.168.1.103 104.1 IN PTR server04int.xxxx.com. ; 192.168.1.104 105.1 IN PTR server05int.xxxx.com. ; 192.168.1.105 106.1 IN PTR server06int.xxxx.com. ; 192.168.1.106 [root@server01 zones]# ... View more

Hi @ Josh Elser , I had a look at the document, but I just cannot seem to find the problem, I have gone so far as in to setup my own bind (DNS) server on one of the servers in the cluster. When I do nslookup with internal IP, external IP, internal hostname and external hostname, they are all resolved. The problem I think is two-fold, when I specify hbase.master.dns.interface=eno2 and hbase.regionserver.dns.interface=eno2, I get the following error (which seems to be documented all over) 2017-02-07 11:23:00,418 INFO [main] util.ServerCommandLine: vmName=OpenJDK 64-Bit Server VM, vmVendor=Oracle Corporation, vmVersion=25.111-b15 2017-02-07 11:23:00,418 INFO [main] util.ServerCommandLine: vmInputArguments=[-Dproc_master, -XX:OnOutOfMemoryError=kill -9 %p, -Dhdp.version=2.5.3.0-37, -XX:+UseConcMarkSweepGC, -XX:ErrorFile=/var/log/hbase/hs_err_pid%p.log, -Djava.io.tmpdir=/tmp, -verbose:gc, -XX:+PrintGCDetails, -XX:+PrintGCDateStamps, -Xloggc:/var/log/hbase/gc.log-201702071122, -Xmx1024m, -Dhbase.log.dir=/var/log/hbase, -Dhbase.log.file=hbase-hbase-master-server01.xxxx.com.log, -Dhbase.home.dir=/usr/hdp/current/hbase-master/bin/.., -Dhbase.id.str=hbase, -Dhbase.root.logger=INFO,RFA, -Djava.library.path=:/usr/hdp/2.5.3.0-37/hadoop/lib/native/Linux-amd64-64:/usr/hdp/2.5.3.0-37/hadoop/lib/native, -Dhbase.security.logger=INFO,RFAS] 2017-02-07 11:23:00,549 ERROR [main] master.HMasterCommandLine: Master exiting java.lang.RuntimeException: Failed construction of Master: class org.apache.hadoop.hbase.master.HMaster at org.apache.hadoop.hbase.master.HMaster.constructMaster(HMaster.java:2515) at org.apache.hadoop.hbase.master.HMasterCommandLine.startMaster(HMasterCommandLine.java:235) at org.apache.hadoop.hbase.master.HMasterCommandLine.run(HMasterCommandLine.java:139) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.hadoop.hbase.util.ServerCommandLine.doMain(ServerCommandLine.java:126) at org.apache.hadoop.hbase.master.HMaster.main(HMaster.java:2529) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.hbase.util.DNS.getDefaultHost(DNS.java:53) at org.apache.hadoop.hbase.regionserver.RSRpcServices.getHostname(RSRpcServices.java:922) at org.apache.hadoop.hbase.regionserver.RSRpcServices.<init>(RSRpcServices.java:867) at org.apache.hadoop.hbase.master.MasterRpcServices.<init>(MasterRpcServices.java:230) at org.apache.hadoop.hbase.master.HMaster.createRpcServices(HMaster.java:581) at org.apache.hadoop.hbase.regionserver.HRegionServer.<init>(HRegionServer.java:540) at org.apache.hadoop.hbase.master.HMaster.<init>(HMaster.java:411) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.apache.hadoop.hbase.master.HMaster.constructMaster(HMaster.java:2510) ... 5 more Caused by: java.lang.ArrayIndexOutOfBoundsException: 3 at org.apache.hadoop.net.DNS.reverseDns(DNS.java:82) at org.apache.hadoop.net.DNS.getHosts(DNS.java:253) at org.apache.hadoop.net.DNS.getDefaultHost(DNS.java:366) ... 21 more When I take these parameters out, the Active Master and Standby Master starts up, but on the external hostname and IP address, the alert says that it is trying to connect to the internal hostname and internal IP address [root@server01 hbase]# netstat -anp | grep 16000 tcp6 0 0 172.28.200.198:16000 :::* LISTEN 17293/java tcp6 0 0 172.28.200.198:30230 172.28.200.214:16000 ESTABLISHED 17898/java [root@server01 hbase]# Connection failed: [Errno 111] Connection refused to server01int.xxxx.com:16000 The ifconfig seems to be correct, eno1 is external and eno2 is internal, All the /etc/hosts files contain all the servers in the cluster [root@server01 hbase]# ifconfig -a eno1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 172.28.200.198 netmask 255.255.255.0 broadcast 172.28.200.255 inet6 fe80::ec4:7aff:fecd:f1f0 prefixlen 64 scopeid 0x20<link> ether 0c:c4:7a:cd:f1:f0 txqueuelen 1000 (Ethernet) RX packets 1559331 bytes 1448481094 (1.3 GiB) RX errors 0 dropped 120 overruns 0 frame 0 TX packets 966299 bytes 324828255 (309.7 MiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 device memory 0xc7500000-c757ffff eno2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.1.101 netmask 255.255.255.0 broadcast 192.168.1.255 inet6 fe80::ec4:7aff:fecd:f1f1 prefixlen 64 scopeid 0x20<link> ether 0c:c4:7a:cd:f1:f1 txqueuelen 1000 (Ethernet) RX packets 17758610 bytes 8386323271 (7.8 GiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 19826227 bytes 15357623455 (14.3 GiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 device memory 0xc7400000-c747ffff lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536 inet 127.0.0.1 netmask 255.0.0.0 inet6 ::1 prefixlen 128 scopeid 0x10<host> loop txqueuelen 0 (Local Loopback) RX packets 25674869 bytes 14514139121 (13.5 GiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 25674869 bytes 14514139121 (13.5 GiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 [root@server01 hbase]# [root@server03 hbase]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 172.28.200.214 server03.xxxx.com server03 192.168.1.103 server03int.xxxx.com server03int # Entries for Ambari on internal IPs 192.168.1.106 server06int.xxxx.com server06int 192.168.1.105 server05int.xxxx.com server05int 192.168.1.104 server04int.xxxx.com server04int 192.168.1.101 server01int.xxxx.com server01int 192.168.1.102 server02int.xxxx.com server02int 192.168.1.103 server03int.xxxx.com server03int # End-Entries for Ambari on internal IPs [root@server03 hbase]# nslookup resolves with no problem [root@server03 hbase]# nslookup > server01 Server: 192.168.1.101 Address: 192.168.1.101#53 Name: server01.xxxx.com Address: 172.28.200.198 > server01int Server: 192.168.1.101 Address: 192.168.1.101#53 Name: server01int.xxxx.com Address: 192.168.1.101 > server01.xxxx.com Server: 192.168.1.101 Address: 192.168.1.101#53 Name: server01.xxxx.com Address: 172.28.200.198 > server01int.xxxx.com Server: 192.168.1.101 Address: 192.168.1.101#53 Name: server01int.xxxx.com Address: 192.168.1.101 > 192.168.1.101 Server: 192.168.1.101 Address: 192.168.1.101#53 101.1.168.192.in-addr.arpa name = server01int.xxxx.com. > 172.28.200.198 Server: 192.168.1.101 Address: 192.168.1.101#53 198.200.28.172.in-addr.arpa name = server01.xxxx.com. > exit [root@server03 hbase]# Any idea of what I'm not doing wrong here, please Regards ... View more

Thanks Josh, let me have a read on this, it is confirmed, my bind address is set to 0.0.0.0 ... View more