| Birt Viewer on Ubuntu Linux [message #504850] |
Tue, 22 December 2009 21:46  |
Eclipse User |
|
|
|
Hello,
Am trying to get BIRT Runtime 2.5 to work with Ubuntu Linux 9.1 and Tomcat 6 with a MySQL 5.1 database. The database connectivity is *not* easy!
1. Tomcat 6 installed ok
2. BIRT Runtime installed ok can view example report that has no DB connectivity. Error message:
Error org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc. There is an error in get connection, Communications link failure Last packet sent to the server was 0 ms ago..
What I've done:
1. Set security to no for java security manager in tomcat /etc/init.d/tomcat6 file (Yes, I understand ramifications)
2. Uploaded mysql connector jar into
/var/lib/tomcat6/webapps/birt/WEB-INF/platform/plugins/org.e clipse.birt.report.data.oda.jdbc_2.5.1.v20090821/drivers/mys ql-connector-java-5.1.5-bin.jar
3. Updated /var/lib/tomcat6/webapps/birt/WEB-INF/platform/plugins/org.e clipse.birt.report.data.oda.jdbc_2.5.1.v20090821/plugin.xml
with database connectivity info for username and password in the extension section as follows:
<extension
point="org.eclipse.birt.report.data.oda.jdbc.driverinfo">
<jdbcDriver
driverClass="org.apache.derby.jdbc.EmbeddedDriver" urlTemplate="jdbc:derby://localhost:3306/risk;username=myusername;password=Very_big_secret*" name="Apache Derby Embedded Driver"/>
</extension>
4. Added itext jar manually to
/var/lib/tomcat6/webapps/birt/WEB-INF/lib/itext.jar
5. Added the SIX commons logging .jar files required by tomcat6 into
/var/lib/tomcat6/webapps/birt/WEB-INF/lib
6. Did chmod 755 on all new uploaded files
7. Started/restarted Tomcat multiple times
Cookies are enables on the browser. I have tried with Firefox and IE.
I have used this page for reference
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php
but clearly it doesn't say that everything I've done as it doesn't address DB connections.
Do plugin.properties need to be set, ie
datasource.property.odaDataSource=Data Source
datasource.property.odaUser=User &Name
datasource.property.odaPassword=Pass&word
I don't see any documentation describing how plugin.properties should be configured. I didn't need it for the Windows system on which I tested.
What other steps are missing to get BIRT runtime installed WITH database connectivity on Unix/Linux?
Genius suggestions, anyone?
|
|
|
|
|
|
|
|
|
|
| Re: Birt Viewer on Ubuntu Linux [message #528775 is a reply to message #528558] |
Wed, 21 April 2010 13:38  |
| Eclipse User |
|
|
|
Sai,
Could you try it with the 5.0.8 driver?
Jason
Sai wrote:
> Hi All,
> urgent help needed, Im having the exact same problem on my server. I'm
> currently running it on Ubuntu
>
> Versions are : JVM version : 1.6.0_07-b06
> Mysql J Connector ver 5.1.12
> Tomcat 6
>
> Does it have to be using mysql jdbc 5.1.9? I cant seem to find the
> download, can someone point me to where that is
>
> It was working perfectly fine until a few weeks ago, it just suddenly
> crashed with the communications link failure error and then with
> java.lang.NoClassDefFoundError:
> com/mysql/jdbc/SingleByteCharsetConverter if i stop using localhost on
> my connection and switch it to the ip address instead.
>
> Appreciate some help from the experts out there
>
|
|
|
Powered by
FUDForum. Page generated in 0.04999 seconds
Home