PDA

View Full Version : [Mondrian] JPivot Error



Luna, Enrique
03-29-2007, 04:20 PM
Hi,



I've just installed Mondrian on a Linux Fedora 6 with Tomcat and MySql
5. I'm trying to execute the samples (FoodMart) for MySql, I loaded the
data into MySql with no issues, and reconfigured the mondrian.jsp to
include the user and password (foodmart)



I try to run the first example but I get the following error:



Error while creating SQL Dialect



Then I go down on the web page and I see



Java.net.ConnectException

MESSAGE : Connection refused





I can login to mysql using the foodmart account and can run queries from
the command line.



Any idea of what am I doing wrong?



Regards,

Enrique


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Julian Hyde
03-29-2007, 04:54 PM
Did you search for the error message? You would have found

http://forums.pentaho.org/showthread.php?p=152315

Julian


_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Luna, Enrique
Sent: Thursday, March 29, 2007 1:14 PM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] JPivot Error



Hi,



I've just installed Mondrian on a Linux Fedora 6 with Tomcat and MySql
5. I'm trying to execute the samples (FoodMart) for MySql, I loaded the
data into MySql with no issues, and reconfigured the mondrian.jsp to
include the user and password (foodmart)



I try to run the first example but I get the following error:



Error while creating SQL Dialect



Then I go down on the web page and I see



Java.net.ConnectException

MESSAGE : Connection refused





I can login to mysql using the foodmart account and can run queries from
the command line.



Any idea of what am I doing wrong?



Regards,

Enrique


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Luna, Enrique
03-29-2007, 04:54 PM
Yes, but this is not what I'm looking for...



I have done the change in the mondrian.jsp to show the following:



<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver"

jdbcUrl="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart
"

catalogUri="/WEB-INF/queries/FoodMart.xml">

select

{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store
Sales]} on columns,

{([Promotion Media].[All Media], [Product].[All Products])} ON rows

from Sales

where ([Time].[1997])

</jp:mondrianQuery>

<c:set var="title01" scope="session">Test Query uses Mondrian
OLAP</c:set>





But not working...



________________________________

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Julian Hyde
Sent: Thursday, March 29, 2007 2:40 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] JPivot Error



Did you search for the error message? You would have found



http://forums.pentaho.org/showthread.php?p=152315



Julian




________________________________


From: mondrian-bounces (AT) pentaho (DOT) org
[mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Luna, Enrique
Sent: Thursday, March 29, 2007 1:14 PM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] JPivot Error

Hi,



I've just installed Mondrian on a Linux Fedora 6 with Tomcat and
MySql 5. I'm trying to execute the samples (FoodMart) for MySql, I
loaded the data into MySql with no issues, and reconfigured the
mondrian.jsp to include the user and password (foodmart)



I try to run the first example but I get the following error:



Error while creating SQL Dialect



Then I go down on the web page and I see



Java.net.ConnectException

MESSAGE : Connection refused





I can login to mysql using the foodmart account and can run
queries from the command line.



Any idea of what am I doing wrong?



Regards,

Enrique


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Luna, Enrique
03-29-2007, 04:54 PM
It is working now:



I changed the localhost for 127.0.0.1



Thanks!



________________________________

From: Luna, Enrique
Sent: Thursday, March 29, 2007 2:47 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] JPivot Error



Yes, but this is not what I'm looking for...



I have done the change in the mondrian.jsp to show the following:



<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver"

jdbcUrl="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart
"

catalogUri="/WEB-INF/queries/FoodMart.xml">

select

{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store
Sales]} on columns,

{([Promotion Media].[All Media], [Product].[All Products])} ON rows

from Sales

where ([Time].[1997])

</jp:mondrianQuery>

<c:set var="title01" scope="session">Test Query uses Mondrian
OLAP</c:set>





But not working...



________________________________

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Julian Hyde
Sent: Thursday, March 29, 2007 2:40 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] JPivot Error



Did you search for the error message? You would have found



http://forums.pentaho.org/showthread.php?p=152315



Julian




________________________________


From: mondrian-bounces (AT) pentaho (DOT) org
[mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Luna, Enrique
Sent: Thursday, March 29, 2007 1:14 PM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] JPivot Error

Hi,



I've just installed Mondrian on a Linux Fedora 6 with Tomcat and
MySql 5. I'm trying to execute the samples (FoodMart) for MySql, I
loaded the data into MySql with no issues, and reconfigured the
mondrian.jsp to include the user and password (foodmart)



I try to run the first example but I get the following error:



Error while creating SQL Dialect



Then I go down on the web page and I see



Java.net.ConnectException

MESSAGE : Connection refused





I can login to mysql using the foodmart account and can run
queries from the command line.



Any idea of what am I doing wrong?



Regards,

Enrique


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Julian Hyde
03-29-2007, 07:30 PM
Try quoting the '&' as '&amp;'.


_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Luna, Enrique
Sent: Thursday, March 29, 2007 1:47 PM
To: Mondrian developer mailing list
Subject: RE: [Mondrian] JPivot Error



Yes, but this is not what I'm looking for.



I have done the change in the mondrian.jsp to show the following:



<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver"

jdbcUrl="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart
"

catalogUri="/WEB-INF/queries/FoodMart.xml">

select

{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store
Sales]} on columns,

{([Promotion Media].[All Media], [Product].[All Products])} ON rows

from Sales

where ([Time].[1997])

</jp:mondrianQuery>

<c:set var="title01" scope="session">Test Query uses Mondrian
OLAP</c:set>





But not working.




_____


From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Julian Hyde
Sent: Thursday, March 29, 2007 2:40 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] JPivot Error



Did you search for the error message? You would have found



http://forums.pentaho.org/showthread.php?p=152315



Julian




_____


From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Luna, Enrique
Sent: Thursday, March 29, 2007 1:14 PM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] JPivot Error

Hi,



I've just installed Mondrian on a Linux Fedora 6 with Tomcat and MySql
5. I'm trying to execute the samples (FoodMart) for MySql, I loaded the
data into MySql with no issues, and reconfigured the mondrian.jsp to
include the user and password (foodmart)



I try to run the first example but I get the following error:



Error while creating SQL Dialect



Then I go down on the web page and I see



Java.net.ConnectException

MESSAGE : Connection refused





I can login to mysql using the foodmart account and can run queries from
the command line.



Any idea of what am I doing wrong?



Regards,

Enrique


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian