US and Worldwide: +1 (866) 660-7555
Results 1 to 4 of 4

Thread: SSL Mondrian connection to mysql database

  1. #1

    Default SSL Mondrian connection to mysql database

    Hello.

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

  2. #2

    Default

    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'@'91.225.218.179' (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
    Posts
    496

    Default

    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

    Default

    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
  •