kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ianzeng <clayto...@163.com>
Subject Re: windows 10 failed to connect kylin using odbc
Date Tue, 08 Mar 2016 08:28:35 GMT
Ok, Many Thx.  :-)
> 在 2016年3月8日,15:18,Johan Öhr <johan.ohr@svenskaspel.se> 写道:
> 
> You should activate SSL in tomcat,
> https://tomcat.apache.org/tomcat-6.0-doc/ssl-howto.html <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
<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 <https://svenskaspel.se/>
> 
> PPlease consider the environment before printing this email


Mime
View raw message