Skip to content

Instantly share code, notes, and snippets.

@bentito
Last active March 10, 2021 20:37
Show Gist options
  • Save bentito/874d299213ade422bc0ac2828a2aafaa to your computer and use it in GitHub Desktop.
Save bentito/874d299213ade422bc0ac2828a2aafaa to your computer and use it in GitHub Desktop.
getting metering 4.6 running on 4.7 cluster with MySQL 5.7 backing store for Hive

where the namespace I will run metering in is btofel:

oc new-app -n btofel -e MYSQL_USER=mysql -e MYSQL_PASSWORD=password -e MYSQL_DATABASE=hive_metastore -e MYSQL_ROOT_PASSWORD=password  mysql:5.7
@bentito
Copy link
Author

bentito commented Mar 10, 2021

then with metering deployed to the btofel namesspace with this CR:

apiVersion: metering.openshift.io/v1
kind: MeteringConfig
metadata:
  name: "operator-metering"
  annotations:
    "ansible.operator-sdk/verbosity": "1"
spec:
  unsupportedFeatures:
    enableHDFS: true
  storage:
    type: "hive"
    hive:
      type: "hdfs"
      hdfs:
        namenode: "hdfs-namenode-0.hdfs-namenode:9820"
  hive:
      spec:
        config:
          db:
            driver: org.mariadb.jdbc.Driver
            url: jdbc:mariadb://mysql:3306/hive_metastore?user=mysql?password=password

@bentito
Copy link
Author

bentito commented Mar 10, 2021

Above config then throws metastore container log errors of:

Caused by: java.sql.SQLException: Access denied for user 'APP'@'10.128.2.75' (using password: YES)

Which is a mysql access config error (and who know what someone has set for this access configs). Also, there is an idea that maybe there is an SSL error, but not sure what in the config is requiring SSL for the JDBC connection?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment