Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: SSL Mondrian connection to mysql database

  1. #1

    Default SSL Mondrian connection to mysql database


    I have CA File, CERT File and Key File. What i must to set url, to olap database connection?

  2. #2


    I connected to mysql server over ssl.
    But when i creating mondrian (OlapConnection) via DriverManager and this url

    jdbc:mondrian:Jdbc=jdbc:mysql://server:3306/db;JdbcUser=user;JdbcPassword=pass;verifyServerCertificate=false;useSSL=true;requireSSL=true;clientCertificateKeyStoreUrl=file:///c:/cert/keystore.jks;clientCertificateKeyStorePassword=pass; CatalogContent=....

    I getting the error:
    java.sql.SQLException: Access denied for user 'capsidia'@'' (using password: YES)

    This error also getting when i trying connect to server without ssl properties (useSSL, verifyServerCertificate, clientCertificateKeyStoreUrl).

    How to fix it ?

  3. #3
    Join Date
    Jan 2013


    IIRC, to pass jdbc connection properties in your Rolap connection string you need to prefix them with "jdbc." For example, jdbc.useSSL=true;

    Let me know if that works for you.

  4. #4


    Yes, its working. Thank you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.