Metastore Credentials

Setting up Mysql and MeteringCR

Create metastore secret in namespace. Username, password

Have mysql instance set up in namespace in cluster first. Use mysql 5.7, make note of db name. 
Username, password, and secretName to match in all references throughout

Expose the service
oc -n <namespace> expose service mysql

grab the clusterIP with get
oc -n <namespace> get service mysql. This clusterIP will be used in your CR

Add to Metering CR like so:
  hive:
    spec:
      config:
        db:
          url: "jdbc:mysql://172.xx.xxx.xx:3306/sampledb"
          driver: "com.mysql.jdbc.Driver"
          secretName: metastore-secret
          
 The url is clusterIP+port+db name. secretName to match created one
 
 Install metering
 ~~~~
 
 To check:
- Look at ansible logs for hive-metastore-0 pod 

20/06/05 22:36:29 [pool-11-thread-17]: INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL

- Check datasources

- Go thru and fully get a report