Hello, Yes, ODBC Driver and JDBC Driver use Kylin Rest API.
To access kylin with SSL: For JDBC Driver, set parameter ssl=true (http://kylin.apache.org/docs/howto/howto_jdbc.html) For ODBC Driver, set server host='my-host', port='8443' (http://kylin.apache.org/docs/tutorial/tableau.html) These both works fine for me. Is it possible that tomcat configuration has something wrong? For example, try to set 'secure'='true'? (https://tomcat.apache.org/tomcat-6.0-doc/config/http.html) SSLEnabled Use this attribute to enable SSL traffic on a connector. To turn on SSL handshake/encryption/decryption on a connector set this value to true. The default value is false. When turning this value true you will want to set the scheme and the secure attributes as well to pass the correct request.getScheme() andrequest.isSecure() values to the servlets See SSL Support <https://tomcat.apache.org/tomcat-6.0-doc/config/http.html#SSL Support> for more information. Thanks, Dong Li Thanks, Dong Li 2016-02-11 18:20 GMT+08:00 Johan Öhr <[email protected]>: > Hi > > Kylin, access och tomcat log wont say anything. > We did a odbc trace and the odbc trace said nothing using odbc, but using > tablau it said something, not very useful tho > http://pastebin.com/MJQaWa6S > > We can confirm that: > Kylin listens on https (8443) > We can use this port to log into kylin using python requests module > We can use this port with our web browser > > Does odbc driver use kylin API? > > Is there any kylin documentation regarding activating SSL? > It feels like kylin uses SSL on API but while using jdbc/odbc its not even > recognizing this > > > // > > Johan Öhr > > *Spelsystem* > > Från: Dong Li <[email protected]> > Svara till: "[email protected]" <[email protected]> > Datum: torsdag 11 februari 2016 10:06 > Till: "[email protected]" <[email protected]> > Ämne: Re: JDBC/ODBC https problem > > Hello, > > Could you check more logs/traces to see if there's any exception? For > example, kylin log, tomcat log, odbc trace etc. > > For ODBC tracing, please refer to > https://support.microsoft.com/en-us/kb/274551 > > Thanks, > Dong Li > > 2016-02-11 0:01 GMT+08:00 Johan Öhr <[email protected]>: > >> Hi, >> >> I have activated https over tomcat: >> >> <Connector port="8443" >> protocol="org.apache.coyote.http11.Http11Protocol" >> >> maxThreads="150" SSLEnabled="true" scheme="https" >> secure="false" >> >> keystoreFile="/root/.keystore" >> keystorePass=“mypassword" >> >> clientAuth="false" sslProtocol="TLS" /> >> >> >> Kyling listens on 8443, it works fine to go there on my browser >> >> >> Works fine to log in using requests module in python >> >> r = requests.get('https://my-host:8443/kylin/api/user/authentication', >> auth=('ADMIN', ‘password'),verify=False) >> >> >>> r.json() >> >> >> But ODBC/JDBC wont work at all >> >> Ive seen created sessions on my firewall, but kylin does not log the >> attempt >> >> Using http over 7070 works fine! >> >> >> Have i missed something? >> >> Tested both 32 and 64-bit kylin driver >> >> >> // >> >> Johan Öhr >> >> *Spelsystem* >> >> AB SVENSKA SPEL >> 621 80 Visby >> Norra Hansegatan 17, Visby >> Växel: +4610-120 00 00 >> https://svenskaspel.se >> >> PPlease consider the environment before printing this email >> > >
