About Shelton

Shelton · ‎09-18-2017

@Hiren Gala Can you give te screenshot and parameters used? The following are possible causes of this issue: 1. Incorrect port and/or Hive Service defined in connection. 2. Network issues. 3. The Hive server is not started. Please revert

Shelton · ‎09-18-2017

@Hiren Gala The errors suggest that your cluster is probably SSL enables so you would need extra configuration for the ODBC to work .Look at the attached screenshot, of course, you will need the CA, Private key.

Shelton · ‎09-17-2017

@Charles Bradbury It should be frustrating, a simple diagnostic isn't easy just a quick look I saw some incompatibility in 2017-09-1516:58:19,901-StackFeatureVersionInfo:ClusterStack=2.5,ClusterCurrentVersion=None,CommandStack=None,CommandVersion=None->2.5 2017-09-1516:58:19,933-Using hadoop conf dir:/usr/hdp/current/hadoop-client/conf 2017-09-1516:58:19,953- checked_call['rpm -q --queryformat '%{version}-%{release}' hdp-select | sed -e 's/\.el[0-9]//g''] {'stderr': -1} 2017-09-1516:58:19,985- checked_call returned (0,'2.6.0.3-8','') There is a conflict between 2.5 and 2.6.0.3-8 can you validate your hdp.repo in /etc/yum.repo.d/* Make sure you have only the one you intend to install in this case I think 2.6 yum clean all yum repolist Please revert

Shelton · ‎09-15-2017

@ajay vembu Can you copy the URL open another window and replace 9 by 8 and hit enter to go back a step and see the reaction

Shelton · ‎09-15-2017

@kerra Was it self signed certificate of CA?

Shelton · ‎09-14-2017

@Angel Mondragon Okay so you arerunning your mysql as root thats okay. Can you check for th errors in log-error=/var/log/mysqld.log And see if there is a pid in this file remove it and restart mysql you should be able to do a "safe_mysqld --user=mysql --skip-grant-tables" pid-file=/var/run/mysqld/mysqld.pid

Shelton · ‎09-14-2017

odbc-kerberos.jpg@kerra If you cluster is Kerberized you MUST choose under you cluster is Kerberized you MUST choose under Authentication Kerberos ,REALM Host FQDN etc

Shelton · ‎09-14-2017

@Angel Mondragon Cold you try this chown mysql /var/run/mysqld/mysql.sock Then start mysql /usr/local/mysql/bin/safe_mysqld --user=mysql --skip-grant-tables

Shelton · ‎09-14-2017

@Angel Mondragon I think you wrongly typed the command just copy and paste. Do you see the difference in my command and yours? 🙂 # cd /tmp # ln -s /var/mysql/mysql.sock mysql.sock Your command notice you used ls -s instead of ln -s [root@g4t7474 etc]# cd /tmp/ [root@g4t7474 tmp]# ls -s /var/lib/mysql/mysql.sock mysql.sock ls: cannot access /var/lib/mysql/mysql.sock: No such file or directory 0 mysql.sock Please revert

Shelton · ‎09-13-2017

@Jean-François Vandemoortele Any updates?

Online	Offline
Last Visited	‎12-11-2025 11:50 PM

Member Since	‎01-19-2017 04:35 AM
Last Visited	‎12-11-2025 11:50 PM
Posts	3,679
Kudos received	627

Cloudera Community

Re: Apache nifi memory consumption in kubernetes

Re: Nifi toolkit command for GitLabFlowRegistry

Re: Not able to delete the NiFi existing flow usin...

Re: Securing Nifi with SSL and using OIDC provider...

Re: External zookeeper and nifi cluster connection...

Re: Error connecting to hive database using Horton...

Re: Error connecting to hive database using Horton...

Re: Ambari 2.5.0 HDP 2.5.3.0 Installation on RHEL ...

Re: When trying to install cluster via Ambari it's...

Re: Hive ODBC on Kerberos

Re: Mysql server do not start : ambari-server star...

Re: Hive ODBC on Kerberos

Re: Mysql server do not start : ambari-server star...

Re: Mysql server do not start : ambari-server star...

Re: Long running Spark streaming job that crashes ...