Thursday, 19 September 2013

Mondrian setup error. Ubuntu server, MySQL, tomcat6

Mondrian setup error. Ubuntu server, MySQL, tomcat6

I need to fix my Mondrian installation. I have created a mondrian.xml
schema with Schema WorkBench. This Schema was created poiting to a MySQL
Database.
Now when I try to browse this data from jpivot, I get this error:
The Mondrian XML: java.lang.NullPointerException
This are the changes I've made:
copied mysql-connector-java-5.0.8-bin.jar to /mondrian/WEB-INF/lib Not
sure if this is the correct way to setup the driver.
My servlet section in web.xml. I changed the DynamicDatasourceXmlaServlet,
don't know which I need actually
<servlet>
<servlet-name>MondrianXmlaServlet</servlet-name>
<servlet-class>mondrian.xmla.impl.MondrianXmlaServlet</servlet-class>
<init-param>
<param-name>DataSourcesConfig</param-name>
<param-value>/var/lib/tomcat6/webapps/mondrian/WEB-INF/datasources.xml</param-value>
</init-param>
</servlet>
My datasources.xml
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=ocupacion;</DataSourceName>
<DataSourceDescription>datasource
ocupacion</DataSourceDescription>
<URL>http://localhost:8081/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://172.26.0.120:3306/my_db;JdbcUser=root;JdbcPassword=mypass;JdbcDrivers=com.mysql.jdbc.Driver
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="OCUPACION">
<Definition>/WEB-INF/queries/OCUPACION.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
I don't know if I need to do something else.
Thanks for helping! :)

No comments:

Post a Comment