Skip to content

Instantly share code, notes, and snippets.

@bentito

bentito/mysql_metering.md

Last active March 10, 2021 20:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bentito/874d299213ade422bc0ac2828a2aafaa to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bentito/874d299213ade422bc0ac2828a2aafaa to your computer and use it in GitHub Desktop.
Download ZIP
getting metering 4.6 running on 4.7 cluster with MySQL 5.7 backing store for Hive
Raw
mysql_metering.md

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

bentito commented Mar 10, 2021 •
edited
Loading

Copy link
Copy Markdown
Author

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

bentito commented Mar 10, 2021

Copy link
Copy Markdown
Author

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