Member since
07-07-2020
8
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3879 | 07-20-2020 01:59 AM |
07-20-2020
01:59 AM
@Shelton I had to install ident server, also I had changed the ip address in the line- host all all 127.0.0.1/32 md5 so changed it back to 127.0.0.1. Thanks.
... View more
07-19-2020
09:22 PM
CREATE ROLE <user> LOGIN PASSWORD '<password>'; CREATE DATABASE <database> OWNER <user> ENCODING 'UTF8'; I had changed the password using the above commands for each database, I have anyways tried with the default password "scm" as well, the error still persists.
... View more
07-18-2020
03:37 AM
@Shelton sudo /opt/cloudera/cm/schema/scm_prepare_database.sh postgresql scm scm And in the next line I was prompted for password.
... View more
07-17-2020
11:31 PM
Hi @Shelton, Thanks for the response. I have tried with the following syntax- $ sudo /opt/cloudera/cm/schema/scm_prepare_database.sh [options] <databaseType> <databaseName> <databaseUser> <password> but the output remains the same.
... View more
07-17-2020
07:30 AM
I am using PostgreSQL for the Cloudera Manager Server and other services that use databases. I'm using a RHEL 7.4 Azure VM and following the official documentation -https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/prepare_cm_database.html I have completed step 4(Install Databases). In Step 5 : Set up the Cloudera Manager Database, on executing the scm_prepare_database.sh script I'm getting the following output- [root@machine1 ~]# sudo /opt/cloudera/cm/schema/scm_prepare_database.sh postgresql scm scm
Enter SCM password:
JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
Verifying that we can write to /etc/cloudera-scm-server
Creating SCM configuration file in /etc/cloudera-scm-server
Executing: /usr/java/jdk1.8.0_181-cloudera/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/java/postgresql-connector-java.jar:/opt/cloudera/cm/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.
Jul 17, 2020 1:59:50 PM org.postgresql.Driver connect
SEVERE: Connection error:
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "scm"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.cloudera.enterprise.dbutil.DbCommandExecutor.testDbConnection(DbCommandExecutor.java:263)
at com.cloudera.enterprise.dbutil.DbCommandExecutor.main(DbCommandExecutor.java:139)
[ main] DbCommandExecutor INFO Unable to login using supplied username/password.
[ main] DbCommandExecutor ERROR Error when connecting to database.
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "scm"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)[postgresql-42.1.4.jre7.89c9f79016bab67349a92c00c55907dd.jar:42.1.4.jre7]
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)[postgresql-42.1.4.jre7.89c9f79016bab67349a92c00c55907dd.jar:42.1.4.jre7]
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)[postgresql-42.1.4.jre7.89c9f79016bab67349a92c00c55907dd.jar:42.1.4.jre7]
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)[postgresql-42.1.4.jre7.89c9f79016bab67349a92c00c55907dd.jar:42.1.4.jre7]
at org.postgresql.Driver.makeConnection(Driver.java:450)[postgresql-42.1.4.jre7.89c9f79016bab67349a92c00c55907dd.jar:42.1.4.jre7]
at org.postgresql.Driver.connect(Driver.java:252)[postgresql-42.1.4.jre7.89c9f79016bab67349a92c00c55907dd.jar:42.1.4.jre7]
at java.sql.DriverManager.getConnection(DriverManager.java:664)[:1.8.0_181]
at java.sql.DriverManager.getConnection(DriverManager.java:247)[:1.8.0_181]
at com.cloudera.enterprise.dbutil.DbCommandExecutor.testDbConnection(DbCommandExecutor.java:263)[db-common-6.3.1.96818eaab0a222aa84a7854b8d22c0c7.jar:]
at com.cloudera.enterprise.dbutil.DbCommandExecutor.main(DbCommandExecutor.java:139)[db-common-6.3.1.96818eaab0a222aa84a7854b8d22c0c7.jar:]
[ main] DbCommandExecutor ERROR Exiting with exit code 8
--> Error 8, giving up (use --force if you wish to ignore the error) I had logged into postgres using # sudo -u postgres psql. Please help. Thanks in advance.
... View more
Labels:
- Labels:
-
Cloudera Manager
07-07-2020
02:39 AM
Correction : curl output curl -i http://vm2:7180 gives following output- HTTP/1.1 200 OK Expires: Thu, 01-Jan-1970 00:00:00 GMT Set-Cookie: CLOUDERA_MANAGER_SESSIONID=6zye6pcmlwjzmidtgt9x0ac1;Path=/;HttpOnly Content-Type: text/html; charset=utf-8 Last-Modified: Sat, 18 May 2019 06:13:36 GMT Content-Length: 63 Accept-Ranges: bytes Cache-Control: max-age=3600,public Server: Jetty(6.1.26.cloudera.4) <head><meta http-equiv="refresh" content="0;url=/cmf/"></head>
... View more
07-07-2020
02:31 AM
I'm using Windows 7(firewall and proxy disabled) and accessing the RHEL 7 VM through putty. I'm getting connection refused on using curl command. Here's the output for service cloudera-scm-server status- /etc/init.d/cloudera-scm-server: line 109: pstree: command not found ● cloudera-scm-server.service - LSB: Cloudera SCM Server Loaded: loaded (/etc/rc.d/init.d/cloudera-scm-server; bad; vendor preset: disabled) Active: active (exited) since Tue 2020-07-07 08:52:42 UTC; 19min ago Docs: man:systemd-sysv-generator(8) Process: 921 ExecStart=/etc/rc.d/init.d/cloudera-scm-server start (code=exited, status=0/SUCCESS) Jul 07 08:52:37 vm2 systemd[1]: Starting LSB: Cloudera SCM Server... Jul 07 08:52:37 vm2 cloudera-scm-server[921]: /etc/rc.d/init.d/cloudera-scm-server: line 109: pstree: command not found Jul 07 08:52:37 vm2 su[963]: (to cloudera-scm) root on none Jul 07 08:52:42 vm2 cloudera-scm-server[921]: Starting cloudera-scm-server: [ OK ] Jul 07 08:52:42 vm2 systemd[1]: Started LSB: Cloudera SCM Server. Here's the output for netstat -na | grep 7180- tcp 0 0 0.0.0.0:7180 0.0.0.0:* LISTEN I have also checked /var/log/cloudera-scm-server/cloudera-scm-server.log and there doesn't seem to be any errors. Any help is appreciated.
... View more
07-07-2020
02:27 AM
Hi, I have successfully installed Cloudera Manager on RHEL 7 Azure VM but I'm not able to access the web ui. I have tried after adding 7180 port as inbound port in Network Security Group in azure portal.
... View more
Labels:
- Labels:
-
Cloudera Manager