kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johan Öhr <>
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,

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<>',
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

Från: ianzeng <<>>
Svara till: "<>" <<>>
Datum: tisdag 8 mars 2016 03:44
Till: "<>" <<>>
Ämne: windows 10 failed to connect kylin using odbc

Hi, all
I try to connect kylin using odic following
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?
621 80 Visby
Norra Hansegatan 17, Visby
Växel: +4610-120 00 00

Please consider the environment before printing this email

View raw message