Member since
03-08-2018
19
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5460 | 03-21-2018 08:27 AM |
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
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
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
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
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
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
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
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:
- Labels:
-
Cloudera Manager
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
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