Cloudera Community
Huriye
user rank
Explorer
My Accepted Solutions
Show All

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-26-2018 11:44 PM
‎07-26-2018 11:44 PM
Hello,   I changed the jar file name as mysql-connector-java.jar then I get error which password is not suitable for the policy. But removed my redhat machines and created Centos. Now I dont have any error to connecting mysql database.  I still dont know what was the problem.   Thanks,   Huriye ... View more

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-25-2018 01:56 AM
‎07-25-2018 01:56 AM
Hello,   I resolved the error which wasa "Unable to find jdbc" by defining the full jar file name in /etc/defaul/cloudera-scm-server. But now I am getting another issue which is;    [ main] DbProvisioner ERROR Exception when creating/dropping database with user 'root' and jdbc url 'jdbc:mysql://localhost/?useUnicode=true&characterEncoding=UTF-8' java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'Support123*'' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:790)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:675)[mysql-connector-java-8.0.11.jar:8.0.11] at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:299)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)[db-common-5.15.0.jar:] [ main] DbProvisioner ERROR Stack Trace: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'Support123*'' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:790)[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:675)[mysql-connector-java-8.0.11.jar:8.0.11] at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:299)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)[db-common-5.15.0.jar:] --> Error 1, giving up (use --force if you wish to ignore the error)   I have changed the password and tried again but getting the same error.    Could you help me on this please?   Thanks,   Huriye ... View more

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-23-2018 06:34 AM
‎07-23-2018 06:34 AM
Hello,   I dont know how exactly I can use the test code. I dont have java know-how.   Thanks,   Huriye ... View more

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-19-2018 04:24 AM
‎07-19-2018 04:24 AM
Hello,   I checked if root is belong to local host and I tried to run with root user and localhost but got the same error.    mysql> SELECT User, Host FROM mysql.user; +------------------+-----------+ | User | Host | +------------------+-----------+ | reportmanager | % | | temp | % | | mysql.infoschema | localhost | | mysql.session | localhost | | mysql.sys | localhost | | root | localhost | +------------------+-----------+ 6 rows in set (0.01 sec) mysql> exit Bye         [root@cm ~]# /usr/share/cmf/schema/scm_prepare_database.sh mysql -h localhost -u root -p 3306 --verbose scmdb scmuser Enter database password: JAVA_HOME=/usr/java/jdk1.8.0_171-amd64/ Verifying that we can write to /etc/cloudera-scm-server Database type: mysql Database user: root Executing: /usr/java/jdk1.8.0_171-amd64//bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/java/postgresql-connector-java.jar:/usr/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbProvisioner --create -h localhost -u root -H localhost -U scmdb -d 3306 -t mysql [ main] DbProvisioner ERROR Exception when creating/dropping database with user 'root' and jdbc url 'jdbc:mysql://localhost/?useUnicode=true&characterEncoding=UTF-8' com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_171] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_171] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_171] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_171] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java.jar:] at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java.jar:] ... View more

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-18-2018 10:46 PM
‎07-18-2018 10:46 PM
Hello,   I run the tcpdump command, the output is in below;   [root@cm ~]# tcpdump -i any -w ~/mysql.pcap port 3306 tcpdump: listening on any, link-type LINUX_SLL (Linux cooked), capture size 262144 bytes   There is no error in mysqld.log and mysql.log.   Do you have any idea?   Thanks,   Huriye ... View more

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-18-2018 06:32 AM
‎07-18-2018 06:32 AM
Hello,   I can access to mysql with temp user and I have disabled selinux before. I get the output in below;   [root@cm ~]# mysql -h localhost -u temp -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 8.0.11 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> exit Bye [root@cm ~]# getenforce Disabled   Thanks,   Huriye ... View more

Re: scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-18-2018 06:23 AM
‎07-18-2018 06:23 AM
Hello, Thank you for the response. I have installed mysql with default options, even if I specify the port I still get the same error. I also tried to run the script by using root user, I still get the same error. Thanks, Huriye ... View more

scm_prepare_database.sh failure

by Explorer in Support Questions
‎07-17-2018 06:44 AM
‎07-17-2018 06:44 AM
Hello,   I have installed mysql database as external database and I'm trying to run scm_prepare_database.sh script and I get this error;   [root@cm mysql]# /usr/share/cmf/schema/scm_prepare_database.sh mysql -h localhost -u temp -p --verbose scmdb scmuser Enter database password: Enter SCM password: JAVA_HOME=/usr/java/jdk1.8.0_171-amd64/ Verifying that we can write to /etc/cloudera-scm-server Database type: mysql Database user: temp Executing: /usr/java/jdk1.8.0_171-amd64//bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/java/postgresql-connector-java.jar:/usr/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbProvisioner --create -h localhost -u temp -H localhost -U scmuser -d scmdb -t mysql [ main] DbProvisioner ERROR Exception when creating/dropping database with user 'temp' and jdbc url 'jdbc:mysql://localhost/?useUnicode=true&characterEncoding=UTF-8' com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_171] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_171] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_171] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_171] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java.jar:] at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2570)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:839)[mysql-connector-java.jar:] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)[mysql-connector-java.jar:] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_171] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_171] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_171] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_171] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:421)[mysql-connector-java.jar:] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:350)[mysql-connector-java.jar:] at java.sql.DriverManager.getConnection(DriverManager.java:664)[:1.8.0_171] at java.sql.DriverManager.getConnection(DriverManager.java:247)[:1.8.0_171] at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:296)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)[db-common-5.15.0.jar:] [ main] DbProvisioner ERROR Stack Trace: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_171] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_171] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_171] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_171] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java.jar:] at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)[mysql-connector-java.jar:] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2570)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:839)[mysql-connector-java.jar:] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)[mysql-connector-java.jar:] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_171] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_171] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_171] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_171] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java.jar:] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:421)[mysql-connector-java.jar:] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:350)[mysql-connector-java.jar:] at java.sql.DriverManager.getConnection(DriverManager.java:664)[:1.8.0_171] at java.sql.DriverManager.getConnection(DriverManager.java:247)[:1.8.0_171] at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:296)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)[db-common-5.15.0.jar:] at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)[db-common-5.15.0.jar:] --> Error 1, giving up (use --force if you wish to ignore the error)   Could you help me on this?   Best regards,   Huriye ... View more
Labels:

Re: Spark 2 Installation Failed

by Explorer in Support Questions
‎06-26-2018 04:11 AM
‎06-26-2018 04:11 AM
Hello,   Thank you for your answer, I tried to change java version but cloudera service not starting.   I followed th link: https://www.cloudera.com/documentation/enterprise/5-11-x/topics/cdh_cm_upgrading_to_jdk8.html   But I get error which is Failed to start LSB: Cloudera SCM Server and there is no error on /var/log/cloudera-scm-server   Best regards,   Huriye ... View more

Re: Spark 2 Installation Failed

by Explorer in Support Questions
‎06-25-2018 11:15 PM
‎06-25-2018 11:15 PM
Hello,   stdout and stderr are in below;   Tue Jun 26 09:01:24 +03 2018 using /usr/java/jdk1.7.0_67-cloudera as JAVA_HOME using 5 as CDH_VERSION using /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771 as CONF_DIR using spark2-conf as DIRECTORY_NAME using /etc/spark2/conf.cloudera.spark2_on_yarn as DEST_PATH using spark2-conf as ALT_NAME using /etc/spark2/conf as ALT_LINK using 51 as PRIORITY using scripts/control.sh as RUNNER_PROGRAM using client as RUNNER_ARGS using /usr/sbin/update-alternatives as UPDATE_ALTERNATIVES Deploying service client configs to /etc/spark2/conf.cloudera.spark2_on_yarn invoking optional deploy script scripts/control.sh /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771/spark2-conf /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771 Tue Jun 26 09:01:24 +03 2018: Running Spark2 CSD control script... Tue Jun 26 09:01:24 +03 2018: Detected CDH_VERSION of [5] Java version 1.8 is required for Spark 2.2. + for SPECIAL_FILE in '$DEST_PATH/{taskcontroller.cfg,container-executor.cfg}' + '[' -e /etc/spark2/conf.cloudera.spark2_on_yarn/taskcontroller.cfg ']' + for SPECIAL_FILE in '$DEST_PATH/{taskcontroller.cfg,container-executor.cfg}' + '[' -e /etc/spark2/conf.cloudera.spark2_on_yarn/container-executor.cfg ']' ++ basename /etc/spark2/conf + LINK_BASENAME=conf + [[ -d conf ]] + '[' -n scripts/control.sh ']' + chmod u+x /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771/scripts/control.sh + echo 'invoking optional deploy script scripts/control.sh' + SRC_PATH=/run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771/spark2-conf + '[' '!' -d /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771/spark2-conf ']' + pushd /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771/spark2-conf + /run/cloudera-scm-agent/process/ccdeploy_spark2-conf_etcspark2conf.cloudera.spark2_on_yarn_-1963022203308540771/scripts/control.sh client ++ log 'Running Spark2 CSD control script...' +++ date ++ timestamp='Tue Jun 26 09:01:24 +03 2018' ++ echo 'Tue Jun 26 09:01:24 +03 2018: Running Spark2 CSD control script...' ++ echo 'Tue Jun 26 09:01:24 +03 2018: Running Spark2 CSD control script...' Tue Jun 26 09:01:24 +03 2018: Running Spark2 CSD control script... ++ log 'Detected CDH_VERSION of [5]' +++ date ++ timestamp='Tue Jun 26 09:01:24 +03 2018' ++ echo 'Tue Jun 26 09:01:24 +03 2018: Detected CDH_VERSION of [5]' ++ echo 'Tue Jun 26 09:01:24 +03 2018: Detected CDH_VERSION of [5]' Tue Jun 26 09:01:24 +03 2018: Detected CDH_VERSION of [5] ++ PATH_TO_JAVA=/usr/java/jdk1.7.0_67-cloudera/bin/java +++ /usr/java/jdk1.7.0_67-cloudera/bin/java -version +++ awk -F '"' '/version/ {print $2}' ++ JAVA_VER=1.7.0_67 ++ JAVA_VER_SHORT=1.7 ++ [[ 1.7 != \1\.\8 ]] ++ echo 'Java version 1.8 is required for Spark 2.2.' ++ exit 1     ... View more
Contact Me
Online
Offline
Last Visited
‎08-01-2018 01:06 AM
Community Statistics
Member Since ‎03-08-2018 10:27 PM
Last Visited ‎08-01-2018 01:06 AM
Posts 19