asked on February 13, 2017
Hello,
Am trying to connect Flexmonster to Kylin through Mondrian as JDBC connection.
As I tried with MySQL and Postgres by providing JDBC Connection params and succeeded, i would like to try similar fashion with Kylin JDBC.
I tried JDBC connectivity through Java JDBC Code and it is working fine. But Am facing below issue when trying with flexmonster.config :
vidya@localhost:~/PMondrian/server$ java -jar flexmonster-proxy-mondrian-4.jar
[2017-02-13 14:08:28] INFO: Flexmonster Data Speed Accelerator for Pentaho Mondrian 4.4
[2017-02-13 14:08:28] INFO: Version 2.303
[2017-02-13 14:08:28] INFO:
log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
log4j:WARN Please initialize the log4j system properly.
[2017-02-13 14:08:28] INFO: Reading config...
[2017-02-13 14:08:28] INFO: Reading config - OK
[2017-02-13 14:08:28] INFO: Loading JDBC driver...
[2017-02-13 14:08:28] INFO: Driver path: jar:file:./kylin-jdbc-1.0-incubating.jar!/
[2017-02-13 14:08:28] INFO: Driver class name: org.apache.kylin.jdbc.Driver
[2017-02-13 14:08:28] INFO: Loading JDBC driver - OK
[2017-02-13 14:08:28] INFO:
[2017-02-13 14:08:28] INFO: Testing connection...
[2017-02-13 14:08:28] INFO:
[2017-02-13 14:08:28] INFO: Starting server...
2017-02-13 14:08:28.361:INFO::main: Logging initialized @210ms
2017-02-13 14:08:28.446:INFO:oejs.Server:main: jetty-9.2.z-SNAPSHOT
2017-02-13 14:08:29.580:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@2a1f3166{/,null,AVAILABLE}
2017-02-13 14:08:29.590:INFO:oejs.ServerConnector:main: Started ServerConnector@65b32b8f{HTTP/1.1}{0.0.0.0:50007}
2017-02-13 14:08:29.590:INFO:oejs.Server:main: Started @1439ms
[2017-02-13 14:08:29] INFO: Starting server - OK
[2017-02-13 14:08:29] INFO: Server is running at http://localhost:50007/
[2017-02-13 14:08:35] INFO: Handshaking...
[2017-02-13 14:08:35] INFO: Loading dimensions...
[2017-02-13 14:08:36] SEVERE: Mondrian Error:Internal error: Error while creating SQL connection:
Jdbc=jdbc:kylin://localhost:7070/AdventureWorks?JdbcUser=admin&JdbcPassword=KYLIN
Any help will be much appreciated.
Thanks in advance!
⋅ February 13, 2017
Hello Vidyasagar,
Thank you for your question. We have noticed that your connection string is a little bit different from the one we have in our documentation. Could you please replace 'JdbcUser' with 'user' and 'JdbcPassword' with 'password' ? Here is an example -
Jdbc=jdbc:kylin://localhost:7070/AdventureWorks?user=admin&password=KYLIN;JdbcDrivers=org.apache.kylin.jdbc.Driver;
If the issue still occurs please try to separate username and password with ';' like in the following example:
Jdbc=jdbc:kylin://localhost:7070/AdventureWorks;JdbcUser=admin;JdbcPassword=KYLIN;JdbcDrivers=org.apache.kylin.jdbc.Driver
Please let us know if it solves your issue.
Best regards,
Dmytro.
⋅ February 14, 2017
Hello Dmytro,
Thanks for your response.
I have tried to change Connection URL as you mentioned:
[2017-02-14 10:08:37] INFO: Flexmonster Data Speed Accelerator for Pentaho Mondrian 4.4
[2017-02-14 10:08:37] INFO: Version 2.303
[2017-02-14 10:08:37] INFO:
log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
log4j:WARN Please initialize the log4j system properly.
[2017-02-14 10:08:37] INFO: Reading config...
[2017-02-14 10:08:37] INFO: Reading config - OK
[2017-02-14 10:08:37] INFO: Loading JDBC driver...
[2017-02-14 10:08:37] INFO: Driver path: jar:file:./kylin-jdbc-1.0-incubating.jar!/
[2017-02-14 10:08:37] INFO: Driver class name: org.apache.kylin.jdbc.Driver
[2017-02-14 10:08:37] INFO: Loading JDBC driver - OK
[2017-02-14 10:08:37] INFO:
[2017-02-14 10:08:37] INFO: Testing connection...
[2017-02-14 10:08:37] INFO: jdbc:kylin://localhost:7070/AdventureWorks&user=admin&password=KYLIN
[2017-02-14 10:08:38] SEVERE: Data Source connection - FAILED
[2017-02-14 10:08:38] SEVERE: java.io.IOException: org.apache.commons.httpclient.methods.PostMethod@280b532e failed, error code 401 and response: <html><head><title>Apache Tomcat/7.0.69 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 401 - Unauthorized</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Unauthorized</u></p><p><b>description</b> <u>This request requires HTTP authentication.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.69</h3></body></html>
I somehow believe it is connecting to RestAPI Client rather as JDBC Connection.
Looking forward to hear from you.
Best Regards,
Vidy
⋅ February 14, 2017
Hello Dmytro,
It is working finally.
CONNECTION_STRING=JDbc=jdbc:kylin://localhost:7070/AdventureWorks;JdbcUser=admin;JdbcPassword=KYLIN;JdbcDrivers=org.apache.kylin.jdbc.Driver;
This is what it made work!
But am facing new issue here:
SEVERE: Mondrian Error:Internal error: Reading row count from table [null, null, PRODUCT]; sql=[select count(*) from "PRODUCT"]
I think this is something we need to do with Mondrian XML file.
Best Regards,
Vidy
⋅ February 14, 2017
Hello Vidy,
Thanks for the update. It seems that the problem is with Mondrian XML file.
Regards,
Tanya
