kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johan Öhr <johan....@svenskaspel.se>
Subject Re: windows 10 failed to connect kylin using odbc
Date Tue, 08 Mar 2016 07:18:15 GMT
You should activate SSL in tomcat,
https://tomcat.apache.org/tomcat-6.0-doc/ssl-howto.html

The port then would be 8443, if default

You should be able to https:// to your kylin-host, using port 8443/kylin

You can verify it with requests module in python or maybe some curl client

 r = requests.get('https://hostname:8443/kylin/api/user/authentication<https://thd03.test.svenskaspel.se:8443/kylin/api/user/authentication>',
auth=('ADMIN', 'PASSWORD'),verify=False)


If this work you may still have problem with SSL in odbc, as i did

It seems like it need a "real certificate" and not a home made one

I havent gotten around to it yet tho, so i exported the java key store cert and imported on
the windows machine using odbc

On machine runnin kylin:

keytool -genkey -alias tomcat -keyalg RSA

On kylin machine, export to windows crt cert

keytool -export -alias tomcat -file mykey.crt -keystore /root/.keystore

Move mykey.crt to your windows computer, import it to trusted certificate publisher

This work around is maybe bad, but i had no other success to get odbc ssl working than this
(other than having a real certificate)



//
Johan Öhr
Spelsystem

Från: ianzeng <claytonly@163.com<mailto:claytonly@163.com>>
Svara till: "user@kylin.apache.org<mailto:user@kylin.apache.org>" <user@kylin.apache.org<mailto:user@kylin.apache.org>>
Datum: tisdag 8 mars 2016 03:44
Till: "user@kylin.apache.org<mailto:user@kylin.apache.org>" <user@kylin.apache.org<mailto:user@kylin.apache.org>>
Ämne: windows 10 failed to connect kylin using odbc

Hi, all
I try to connect kylin using odic following http://kylin.apache.org/docs/tutorial/odbc.html.
The configuration is
port:7070, user:ADMIN, PASSWORD: KYLIN,
but odic failed to connect, the error msg is user/password is wrong or kylin out of service.
odbc is installed on windows 10. Is that ok?
AB SVENSKA SPEL
621 80 Visby
Norra Hansegatan 17, Visby
Växel: +4610-120 00 00
https://svenskaspel.se

Please consider the environment before printing this email

Mime
View raw message