Cloudera Community
Manoj690
user rank
Contributor

Re: ambari server problem 2

by Contributor in Support Questions
‎08-21-2019 12:03 AM
‎08-21-2019 12:03 AM
yes i created correctly and i use flush command also. i am able to login mysql -u ambari -p with this command after that i  use password to get in also. i created everything. but some connection is missing i dnt know what that is.  ... View more

Re: ambari server problem 2

by Contributor in Support Questions
‎08-20-2019 11:47 PM
‎08-20-2019 11:47 PM
Yes   ------------+------------------+ | user | host | +------------------+------------------+ | ambari | % | | ambarii | % | | hive | % | | manojs | % | | ambari | gaian-lap386.com | | ambarii | gaian-lap386.com | | manojs | gaian-lap386.com | | ambari | localhost | | ambarii | localhost | | debian-sys-maint | localhost | | hive | localhost | | hiveuser | localhost | | manoj | localhost | | manojs | localhost | | mysql.session | localhost | | mysql.sys | localhost | | root | localhost ... View more

ambari server problem 2

by Contributor in Support Questions
‎08-20-2019 11:28 PM
‎08-20-2019 11:28 PM
in server.out file this is the error   Wed Aug 21 11:54:54 IST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.   in server.log  file this is the error   Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:146) at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:144) ... 14 more Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685) ... 16 more Caused by: java.sql.SQLException: Access denied for user 'ambari'@'gaian-lap386.com' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor42.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ... View more
Labels:

Re: ambari server not running

by Contributor in Support Questions
‎08-20-2019 02:06 AM
‎08-20-2019 02:06 AM
can you tell me solution for this   ambari-server restart   Using python /usr/bin/python Restarting ambari-server Ambari Server is not running Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources... Ambari database consistency check started... Server PID at: /var/run/ambari-server/ambari-server.pid Server out at: /var/log/ambari-server/ambari-server.out Server log at: /var/log/ambari-server/ambari-server.log Waiting for server start..........................................ERROR: Exiting with exit code -1. REASON: Ambari Server java process has stopped. Please check the logs for more information. ... View more

Re: ambari agent not running

by Contributor in Support Questions
‎08-20-2019 01:54 AM
‎08-20-2019 01:54 AM
still same error. can you tell me your contact in private messages(email or phone) ... View more

Re: ambari agent not running

by Contributor in Support Questions
‎08-20-2019 01:48 AM
‎08-20-2019 01:48 AM
Still same error   ambari-agent restart Restarting ambari-agent Verifying Python version compatibility... Using python /usr/bin/python ambari-agent is not running. No PID found at /run/ambari-agent/ambari-agent.pid Verifying Python version compatibility... Using python /usr/bin/python Checking for previously running Ambari Agent... Checking ambari-common dir... Starting ambari-agent Verifying ambari-agent process status... ERROR: ambari-agent start failed. For more details, see /var/log/ambari-agent/ambari-agent.out: ==================== No handlers could be found for logger "root" Failed to start ping port listener of: Could not open port 8670 because port already used by another process: UID PID PPID C STIME TTY TIME CMD root 23758 23754 0 Aug19 pts/4 00:00:43 /usr/bin/python /usr/lib/ambari- ==================== Agent out at: /var/log/ambari-agent/ambari-agent.out Agent log at: /var/log/ambari-agent/ambari-agent.log ... View more

Re: ambari agent not running

by Contributor in Support Questions
‎08-20-2019 01:41 AM
‎08-20-2019 01:41 AM
Hi i tried this   ps aux | grep main.py | grep -v grep root 12998 0.0 0.1 164276 28588 pts/4 T Aug19 0:00 /usr/bin/python /usr/lib/ambari-agent/lib/ambari_agent/main.py stop root 23758 0.0 0.1 232796 23640 pts/4 Sl Aug19 0:32 /usr/bin/python /usr/lib/ambari-agent/lib/ambari_agent/main.py start  kill PID bash: kill: PID: arguments must be process or job IDs ... View more

ambari agent not running

by Contributor in Support Questions
‎08-19-2019 11:06 PM
‎08-19-2019 11:06 PM
Hi   By mistake i deleted one file in ambari agent that is rm -f /run/ambari-agent/ambari-agent.pid   after that its showing this error   ambari-agent restart Restarting ambari-agent Verifying Python version compatibility... Using python /usr/bin/python ambari-agent is not running. No PID found at /run/ambari-agent/ambari-agent.pid Verifying Python version compatibility... Using python /usr/bin/python Checking for previously running Ambari Agent... Checking ambari-common dir... Starting ambari-agent Verifying ambari-agent process status... ERROR: ambari-agent start failed. For more details, see /var/log/ambari-agent/ambari-agent.out: ==================== No handlers could be found for logger "root" Failed to start ping port listener of: Could not open port 8670 because port already used by another process: UID PID PPID C STIME TTY TIME CMD root 23758 23754 0 Aug19 pts/4 00:00:17 /usr/bin/python /usr/lib/ambari- ==================== Agent out at: /var/log/ambari-agent/ambari-agent.out Agent log at: /var/log/ambari-agent/ambari-agent.log       ... View more
Labels:

Re: ERROR: Exiting with exit code -1. REASON: Amb...

by Contributor in Support Questions
‎08-19-2019 10:40 PM
‎08-19-2019 10:40 PM
when i used below command it will give this result   grep 'jdbc' /etc/ambari-server/conf/ambari.properties   custom.mysql.jdbc.name=mysql-connector-java.jar previous.custom.mysql.jdbc.name=mysql-connector-java.jar server.jdbc.connection-pool=c3p0 server.jdbc.connection-pool.acquisition-size=5 server.jdbc.connection-pool.idle-test-interval=7200 server.jdbc.connection-pool.max-age=0 server.jdbc.connection-pool.max-idle-time=14400 server.jdbc.connection-pool.max-idle-time-excess=0 server.jdbc.database=mysql server.jdbc.database_name=hive server.jdbc.driver=com.mysql.jdbc.Driver server.jdbc.driver.path=/usr/share/java/mysql-connector-java.jar server.jdbc.hostname=gaian-lap386.com server.jdbc.port=8080 server.jdbc.rca.driver=com.mysql.jdbc.Driver server.jdbc.rca.url=jdbc:mysql://gaian-lap386.com:8080/hive server.jdbc.rca.user.name=hive server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat server.jdbc.url=jdbc:mysql://gaian-lap386.com:8080/hive server.jdbc.user.name=hive server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat     AND   tail -10f /var/log/ambari-server/ambari-server.log   Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) ... 20 more ... View more

Re: ERROR: Exiting with exit code -1. REASON: Amb...

by Contributor in Support Questions
‎08-19-2019 03:05 AM
‎08-19-2019 03:05 AM
  - Hence, can you please share the whole ambari-server.log . / amabri-server.out file?  : long files cant share. can you send your personal email id we can talk over there - How frequently do you see this error?    when ever i start ambari server its getting this message  - Do you see any port conflict on ambari server listen port (is that port free?): dont know hoe to check - Are you running ambari server as non root user?   : no i am running on root - Have you checked the permission of ambari log "/var/log/ambari-server" and run directory : "/var/run/ambari-server" ?:  dont know how to check - If your ambari server database running fine and accessible without any issue?: dont know how to check ... View more
Contact Me
Online
Offline
Last Visited
‎04-01-2021 02:50 AM
Community Statistics
Member Since ‎08-19-2019 01:28 AM
Last Visited ‎04-01-2021 02:50 AM
Posts 150
Kudos received 1