You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Łukasz Stefański SoSimple <lu...@sosimple.pl> on 2023/04/12 14:07:14 UTC

MDX interface for EXCEL from Docker image gets login failed

Hi 
I am using docker kylin for now. But after buidling the cube I discovered that it is not possible to connect to CUBE from EXCEL or POWERBI. 
I am getting login failed for user ADMIN/KYLIN. 

Bellow logs shows login try from excel :

File mdx.log : 

2023-04-07 04:02:59,273 [WARN ] [Query f3f4b028-1bde-4c2d-e1a6-e1d0d219d3c1] i.k.m.i.s.f.MdxServiceFilter.doFilter - [MDX-04010001] please add auth info in your request.
2023-04-07 04:02:59,331 [INFO ] [Query 5202bd61-6de4-5925-12c9-c43ccb98a3a6] i.k.m.w.x.MdxXmlaServlet.prepareMondrianSchema - begin init datasource, username=ANALYST, project=learn_kylin
2023-04-07 04:02:59,331 [ERROR] [Query 5202bd61-6de4-5925-12c9-c43ccb98a3a6] i.k.m.i.s.f.MdxServiceFilter.doFilter - internal error
io.kylin.mdx.insight.common.SemanticException: The connection user information or password maybe empty or has been changed, please contact system admin to update in Configuration page under Management.
        at io.kylin.mdx.insight.core.support.SemanticFacade.getSemanticProjectByUser(SemanticFacade.java:62) ~[semantic-core-1.2.0.jar!/:?]
        at io.kylin.mdx.core.service.ModelManager.buildMondrianSchemaFromDataSet(ModelManager.java:70) ~[mdx-1.2.0.jar!/:?]
        at io.kylin.mdx.web.xmla.XmlaDatasource.loadMdnSchemas(XmlaDatasource.java:108) ~[mdx-1.2.0.jar!/:?]
        at io.kylin.mdx.web.xmla.XmlaDatasource.initDatasource(XmlaDatasource.java:90) ~[mdx-1.2.0.jar!/:?]
        at io.kylin.mdx.web.xmla.MdxXmlaServlet.prepareMondrianSchema(MdxXmlaServlet.java:216) ~[mdx-1.2.0.jar!/:?]
        at io.kylin.mdx.web.xmla.MdxXmlaServlet.process(MdxXmlaServlet.java:103) ~[mdx-1.2.0.jar!/:?]
        at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:119) ~[olap4j-xmlaserver-1.2.0.jar!/:?]

Can you please help to fix this docker setup ? 

Łukasz

Re: MDX interface for EXCEL from Docker image gets login failed

Posted by ShaoFeng Shi <sh...@apache.org>.
Good to know you solved it by checking the document :-)

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC,
Apache Incubator PMC,
Email: shaofengshi@apache.org

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org




Łukasz Stefański SoSimple <lu...@sosimple.pl> 于2023年4月13日周四
01:29写道：

> Problem solved with tutorial:
> https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html
>
>
>
>
>
> *From:* Łukasz Stefański SoSimple <lu...@sosimple.pl>
> *Sent:* Wednesday, April 12, 2023 4:07 PM
> *To:* user@kylin.apache.org
> *Subject:* MDX interface for EXCEL from Docker image gets login failed
>
>
>
> Hi
>
> I am using docker kylin for now. But after buidling the cube I discovered
> that it is not possible to connect to CUBE from EXCEL or POWERBI.
>
> I am getting login failed for user ADMIN/KYLIN.
>
>
>
> Bellow logs shows login try from excel :
>
>
>
> File mdx.log :
>
>
>
> 2023-04-07 04:02:59,273 [WARN ] [Query
> f3f4b028-1bde-4c2d-e1a6-e1d0d219d3c1] i.k.m.i.s.f.MdxServiceFilter.doFilter
> - [MDX-04010001] please add auth info in your request.
>
> 2023-04-07 04:02:59,331 [INFO ] [Query
> 5202bd61-6de4-5925-12c9-c43ccb98a3a6]
> i.k.m.w.x.MdxXmlaServlet.prepareMondrianSchema - begin init datasource,
> username=ANALYST, project=learn_kylin
>
> 2023-04-07 04:02:59,331 [ERROR] [Query
> 5202bd61-6de4-5925-12c9-c43ccb98a3a6] i.k.m.i.s.f.MdxServiceFilter.doFilter
> - internal error
>
> io.kylin.mdx.insight.common.SemanticException: The connection user
> information or password maybe empty or has been changed, please contact
> system admin to update in Configuration page under Management.
>
>         at
> io.kylin.mdx.insight.core.support.SemanticFacade.getSemanticProjectByUser(SemanticFacade.java:62)
> ~[semantic-core-1.2.0.jar!/:?]
>
>         at
> io.kylin.mdx.core.service.ModelManager.buildMondrianSchemaFromDataSet(ModelManager.java:70)
> ~[mdx-1.2.0.jar!/:?]
>
>         at
> io.kylin.mdx.web.xmla.XmlaDatasource.loadMdnSchemas(XmlaDatasource.java:108)
> ~[mdx-1.2.0.jar!/:?]
>
>         at
> io.kylin.mdx.web.xmla.XmlaDatasource.initDatasource(XmlaDatasource.java:90)
> ~[mdx-1.2.0.jar!/:?]
>
>         at
> io.kylin.mdx.web.xmla.MdxXmlaServlet.prepareMondrianSchema(MdxXmlaServlet.java:216)
> ~[mdx-1.2.0.jar!/:?]
>
>         at
> io.kylin.mdx.web.xmla.MdxXmlaServlet.process(MdxXmlaServlet.java:103)
> ~[mdx-1.2.0.jar!/:?]
>
>         at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:119)
> ~[olap4j-xmlaserver-1.2.0.jar!/:?]
>
>
>
> Can you please help to fix this docker setup ?
>
>
>
> Łukasz
>

RE: MDX interface for EXCEL from Docker image gets login failed

Posted by Łukasz Stefański SoSimple <lu...@sosimple.pl>.
Problem solved with tutorial:  <https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html> https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html

 

 

From: Łukasz Stefański SoSimple <lu...@sosimple.pl> 
Sent: Wednesday, April 12, 2023 4:07 PM
To: user@kylin.apache.org
Subject: MDX interface for EXCEL from Docker image gets login failed 

 

Hi 

I am using docker kylin for now. But after buidling the cube I discovered that it is not possible to connect to CUBE from EXCEL or POWERBI. 

I am getting login failed for user ADMIN/KYLIN. 

 

Bellow logs shows login try from excel :

 

File mdx.log : 

 

2023-04-07 04:02:59,273 [WARN ] [Query f3f4b028-1bde-4c2d-e1a6-e1d0d219d3c1] i.k.m.i.s.f.MdxServiceFilter.doFilter - [MDX-04010001] please add auth info in your request.

2023-04-07 04:02:59,331 [INFO ] [Query 5202bd61-6de4-5925-12c9-c43ccb98a3a6] i.k.m.w.x.MdxXmlaServlet.prepareMondrianSchema - begin init datasource, username=ANALYST, project=learn_kylin

2023-04-07 04:02:59,331 [ERROR] [Query 5202bd61-6de4-5925-12c9-c43ccb98a3a6] i.k.m.i.s.f.MdxServiceFilter.doFilter - internal error

io.kylin.mdx.insight.common.SemanticException: The connection user information or password maybe empty or has been changed, please contact system admin to update in Configuration page under Management.

        at io.kylin.mdx.insight.core.support.SemanticFacade.getSemanticProjectByUser(SemanticFacade.java:62) ~[semantic-core-1.2.0.jar!/:?]

        at io.kylin.mdx.core.service.ModelManager.buildMondrianSchemaFromDataSet(ModelManager.java:70) ~[mdx-1.2.0.jar!/:?]

        at io.kylin.mdx.web.xmla.XmlaDatasource.loadMdnSchemas(XmlaDatasource.java:108) ~[mdx-1.2.0.jar!/:?]

        at io.kylin.mdx.web.xmla.XmlaDatasource.initDatasource(XmlaDatasource.java:90) ~[mdx-1.2.0.jar!/:?]

        at io.kylin.mdx.web.xmla.MdxXmlaServlet.prepareMondrianSchema(MdxXmlaServlet.java:216) ~[mdx-1.2.0.jar!/:?]

        at io.kylin.mdx.web.xmla.MdxXmlaServlet.process(MdxXmlaServlet.java:103) ~[mdx-1.2.0.jar!/:?]

        at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:119) ~[olap4j-xmlaserver-1.2.0.jar!/:?]

 

Can you please help to fix this docker setup ? 

 

Łukasz