buggtb
commented
11 years ago Did you either restart the tomcat server, or press the little green refresh data sources arrows?
Closed damonmccarthy closed 7 years ago
buggtb
commented
11 years ago Did you either restart the tomcat server, or press the little green refresh data sources arrows?
damonmccarthy
commented
11 years ago I did both if those things. I also looked in the Catalina.out but could not see any attempts to connect to vectorwise.
Thanks,
Damon
On 22 Apr 2013, at 17:28, Tom Barber notifications@github.com wrote:
Did you either restart the tomcat server, or press the little green refresh data sources arrows?
— Reply to this email directly or view it on GitHub.
buggtb
commented
11 years ago Oh sorry damon, had a sleep and saw at least one issue. The driver line in your data sources file, as perverse as it sounds should still be the olap4j driver, mondrian.olap4j.MondrianOlap4jDriver
To use a database you need to specify the database driver in the location line. I don't have a Vectorwise setup here, but I have used it before so I know it works fine, you need something like:
location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost/saikudemo;Catalog=res:foodmart/FoodMart.xml;JdbcDrivers=com.mysql.jdbc.Driver;
But obviously with the mysql bits swapped for vectorwise.
damonmccarthy
commented
11 years ago Tom,
That did not work either. My badoo file is now: type=OLAP name=badoo driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:ingres://bi1:VW7/badoo_dwh;UID=pentaho;DBPWD=pentaho;GRP=appli_ro;Catalog=res:badoo/badoo_schema.xml;JdbcDriver=com.ingres.jdbc.IngresDriver username=xxx password=xxx
Damon
On 23 Apr 2013, at 10:20, Tom Barber wrote:
location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost/saikudemo;Catalog=res:foodmart/FoodMart.xml;JdbcDrivers=com.mysql.jdbc.Driver;
Regards,
Damon McCarthy BI Consultant
damon.mccarthy@corp.badoo.com
We're hiring at Badoo!
Badoo Trading Limited is a limited company registered in England and Wales under CRN 7540255 with its registered office at Badoo Trading Limited, Media Village, 131 - 151 Great Titchfield Street, London, W1W 5BB.
This email is confidential and is intended for the addressee only. If you have received it in error, you are on notice of its status. Please notify us by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purpose or disclose its content to any other person.
buggtb
commented
11 years ago Still looks wrong to me Damon, here is a template that I use for vectorwise connections, I can tell you with 100% certainty this template works:
type=OLAP name=foodmart driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:mondrian:Jdbc=jdbc:ingres://localhost:V97/foodmart;Catalog=res:foodmart/FoodMart.xml;JdbcDrivers=com.ingres.jdbc.IngresDriver; username=ingres password=<%= vectorw_password %>
If you still get nowhere, pastebin your catalina.out file and I'll take a look. And if you're really stuck and can't make it work, I'll be in Soho about 3:30pm if you want me to swing by and take a look. ;)
damonmccarthy
commented
11 years ago Tom,
We are getting somewhere. My badoo file is now: type=OLAP name=badoo driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:mondrian:Jdbc=jdbc:ingres://bi1:VW7/badoo_dwh;Catalog=res:badoo/badoo_schema.xml;JdbcDrivers=com.ingres.jdbc.IngresDriver; username=ingres password=xxx
I now get an error in catalina.out when I click the green arrows for refreshing the cubes.
Here's the catalina.out generated after I click refresh.
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:ingres://bi1:VW7/badoo_dwh; JdbcUser=ingres; JdbcPassword=xxx
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967)
at mondrian.olap.Util.newInternal(Util.java:2323)
at mondrian.olap.Util.newError(Util.java:2339)
at mondrian.rolap.RolapConnection.
Damon
On 23 Apr 2013, at 11:08, Tom Barber wrote:
Still looks wrong to me Damon, here is a template that I use for vectorwise connections, I can tell you with 100% certainty this template works:
type=OLAP name=foodmart driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:mondrian:Jdbc=jdbc:ingres://localhost:V97/foodmart;Catalog=res:foodmart/FoodMart.xml;JdbcDrivers=com.ingres.jdbc.IngresDriver; username=ingres password=<%= vectorw_password %>
If you still get nowhere, pastebin your catalina.out file and I'll take a look. And if you're really stuck and can't make it work, I'll be in Soho about 3:30pm if you want me to swing by and take a look. ;)
Reply to this email directly or view it on GitHub.
Regards,
Damon McCarthy BI Consultant
damon.mccarthy@corp.badoo.com
We're hiring at Badoo!
Badoo Trading Limited is a limited company registered in England and Wales under CRN 7540255 with its registered office at Badoo Trading Limited, Media Village, 131 - 151 Great Titchfield Street, London, W1W 5BB.
This email is confidential and is intended for the addressee only. If you have received it in error, you are on notice of its status. Please notify us by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purpose or disclose its content to any other person.
buggtb
commented
11 years ago Look much improved Damon,
The problem lines are:
Caused by: java.sql.SQLNonTransientConnectionException: Communications error while establishing connection. at com.ingres.gcf.util.SqlExType.getSqlEx(SqlExType.java:97) at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:68) at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:158) at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:197) at com.ingres.gcf.dam.MsgIo.connect(MsgIo.java:326) at com.ingres.gcf.dam.MsgOut.connect(MsgOut.java:325) at com.ingres.gcf.dam.MsgIn.connect(MsgIn.java:343) at com.ingres.gcf.dam.MsgConn.
Not having access to the servers I'm not sure, I've not see the extra params you pass with the connection string before, so I'll just have to assume you have them set correctly.
At this point though, its really an Ingres JDBC issue, so you have to make 100% sure you have the correct port(thats always weird) and the other bits and bobs are correct, because Saiku is now using the driver correctly but clearly failing to make the connection
I have install saiku on a linux machine with foodmart and can happliy create reports.
I would like to connect to a Vectorwise database and use a specific mondrian schema.
I have added a new badoo file into the following dir: saiku/saiku-server/tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources
The file contains the following: type=OLAP name=badoo driver=com.ingres.jdbc.IngresDriver location=jdbc:ingres://bi1:VW7/badoo_dwh;UID=pentaho;DBPWD=pentaho;GRP=appli_ro;Catalog=res:badoo/badoo_schema.xml; username=xxx password=xxx
some security configuration for roles, first enable it
security.enabled=true
there are 3 different types of security:
"one2one" (try and map spring user roles to mondrian roles),
"mapping" (define the mapping of spring and mondrian roles manually)
"passthrough" (will pass username + password of logged in user to connection, e.g. jdbc user + password)
security.type=one2one
security.type=mapping
security.mapping=springRole=mondrianRole1;springRole2=mondrianRole2
I have added my schema to: saiku/saiku-server/tomcat/webapps/saiku/WEB-INF/classes/badoo
But when I open Saiku I only see foodmart.
I have looked in the catalina.out error log but cannot see anything.