About saayak

saayak · ‎01-02-2019

@bgooley Thanks for the clarification. When you say CM's Kerberos configuration, you mean from Administration -> Security -> Kerberos Credentials -> Configuration In the krb5.cnf file for all hosts, if we don't change "kdc" name should that be okay ? We will keep the same hostname for the new host. How do we install the KDC in the new host ?

saayak · ‎01-02-2019

Hello team, We are planning to migrate KDC service from one host to a new host in the cluster. It's Kerborised cluster. How should we go about with the process. Thanks and regards Sayak

saayak · ‎12-16-2018

Thank you for the explanation. We did restore it from the backup and it's pointing to the previous CDH version

saayak · ‎12-14-2018

Hello team, Cloudera navigator audit server is failing to start with exception FATAL SqlFile [main]: SQL Error at 'UTF-8' line 1: "ALTER TABLE PARTITION_INFO ADD COLUMN BEGIN_TS BIGINT(20)" Duplicate column name 'BEGIN_TS' ERROR SqlFileRunner [main]: Exception while executing ddl scripts. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'BEGIN_TS' Would anyone let us know how to resolve the issue ? Thanks and regards Sayak

saayak · ‎12-14-2018

Hello team, We are getting below exception whle trying to start Navigator audit server. UpgradeSchemaAndSetupDataSource [main]: Unable to upgrade schema to latest version com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'nava.AUDIT_SCHEMA_ VERSION' doesn't exist Would you please help ? Thanks and regards Sayak

saayak · ‎12-14-2018

Hello team, We had to re-install MySQL as it crashed. Post doing we have created the databases, but when we start the cloudera-scm-server and checking from the CM UI, we are unable to get the current CDH version and the services are not loading. How do we get back the current CDH version ? Thanks and regards Sayak

saayak · ‎12-09-2018

We started the process by shutting down the cluster and MySQL instance. When the MySQL instance was stopped, the CM UI went blank. How we make the hostname changes ? Is there any configuration needed in my.cnf for MySQL instance in Cloudera ? As when we installed MySQL instance in new node, and then copied the data directory and started the MySQL instance, it failed to start. For the MySQL data directory move, we followed below steps. 1.Stop MySQL server in previous instance 2. cp -R /var/lib/mysql/ <new instance path> 3. Installed MySQL in new instance 4. mv /var/lib/mysql/ /var/lib/mysql_56_clean 5. cp -R <new instance path> </var/lib/mysql/ in new instance> and changed permissions 6 Start MySQL instance in new instance (failed to start) Thanks and regards Sayak

saayak · ‎12-06-2018

Thanks for the detailed description.

saayak · ‎12-05-2018

Thank you. Is there any other way apart from web ui. Like from command interface ?

saayak · ‎12-05-2018

Thanks for the detailed explanation. When the query runs, you say it's picking one Impala Daemon. Does picking up the Impala daemon can be managed ? Impala Daemons Load Balancer is configured.

saayak · ‎12-05-2018

Hello team, We have different applications/scripts that are fetching data via Impala. These are jdbc connections. The output of the queries ends up with exceptions Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: null, SQL state: HY000, The issue gets resolved after a service restart of Impala. Is there a way to check how many open connections ? Please let us know. Thanks and regards Sayak

saayak · ‎12-05-2018

Hello team, From our web application whenever we are trying to fetch data from Impala, it's doing so from one particular node. There are multiple data nodes. There is haproxy acting as a load balancer. Replication factor set to 3. Is there any configuration in Impala that would allow to fetch data from multiple nodes. Thanks and regards Sayak

saayak · ‎11-29-2018

Hello team, We have activity montitor, navigator audit, navaigator metadata, reports manager, hive metastore, hue, oozie, sentry as a MySQL instance. Is there any impact if we move the MySQL instance to another node. That is install in anothe node, copy MySQL data directory. And remove MySQL instance from the existing node. Thanks and regards Sayak

saayak · ‎11-21-2018

Anyone who can suggest ?

saayak · ‎10-17-2018

Hi Manu, This is what we get when we open the admin home page 2018-10-17 10:24:15,128 WARN 230875498@scm-web-32083:com.cloudera.server.web.cmf.csrf.CsrfRefererInterceptor: Rejecting request originating from 127.0.0.1 for http://localhost:7180/cmf/services/landingPageStatusContent with referrer https://<URL>/cmf/home Reagrds Sayak

saayak · ‎10-11-2018

Is there anyone who can help ?

saayak · ‎10-09-2018

Sorry, i mean it works fine with http. And doesn't with https

saayak · ‎10-09-2018

Hello team, CM admin console is unable to load Charts/Graphs when we use HTTPS. It works fine without http. Please let me know how to resolve the issue. Regards Sayak

Online	Offline
Last Visited	‎01-10-2019 06:09 AM

Date Registered	‎01-13-2017 01:14 AM
Last Visited	‎01-10-2019 06:09 AM
Total Messages Posted	19
Total Kudos Received	1

Re: KDC installation

KDC installation

Re: Unable to get back latest CDH Version

Navigator Audit Server not starting

Navigator Audit Server

Unable to get back latest CDH Version

Re: MySQL instance move from one to another

Re: MySQL instance move from one to another

Re: How to manage Impala connection exhaustion

Re: How new data can be accessed/written accross m...

How to manage Impala connection exhaustion

How new data can be accessed/written accross multi...

MySQL instance move from one to another

Re: CM admin console unable to load Charts/Graphs

Re: CM admin console unable to load Charts/Graphs

Re: CM admin console unable to load Charts/Graphs

Re: CM admin console unable to load Charts/Graphs

CM admin console unable to load Charts/Graphs