You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by ianzeng <cl...@163.com> on 2016/03/08 03:44:26 UTC

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?

Re: windows 10 failed to connect kylin using odbc

Posted by ianzeng <cl...@163.com>.
Ok， Many Thx.  :-)
> 在 2016年3月8日，15:18，Johan Öhr <jo...@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 <ma...@163.com>>
> Svara till: "user@kylin.apache.org <ma...@kylin.apache.org>" <user@kylin.apache.org <ma...@kylin.apache.org>>
> Datum: tisdag 8 mars 2016 03:44
> Till: "user@kylin.apache.org <ma...@kylin.apache.org>" <user@kylin.apache.org <ma...@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

Re: windows 10 failed to connect kylin using odbc

Posted by Johan Öhr <jo...@svenskaspel.se>.
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 <cl...@163.com>>
Svara till: "user@kylin.apache.org<ma...@kylin.apache.org>" <us...@kylin.apache.org>>
Datum: tisdag 8 mars 2016 03:44
Till: "user@kylin.apache.org<ma...@kylin.apache.org>" <us...@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