|
Re: Birt Viewer on Ubuntu Linux [message #504853 is a reply to message #504850] |
Wed, 23 December 2009 05:20 |
|
You do not need step 2 and 3. Other than possible permission issues
just copying the jdbc driver to the drivers directory as you did in step
2 is all that is required. Since you are using Tomcat 6 you also have
to copy the commons logging jars. Connection info is stored in the
report not the plugin.
Jason
designing woman wrote:
> 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 #504947 is a reply to message #504907] |
Wed, 23 December 2009 17:47 |
|
If you do not mind posting what you did, I will add it to the FAQ.
designing woman wrote:
> I fixed it. The setup for database connectivity in deploying to Linux
> from a windows workstation isn't well explained in any eclipse
> documentation.
|
|
|
|
|
|
Re: Birt Viewer on Ubuntu Linux [message #528775 is a reply to message #528558] |
Wed, 21 April 2010 17:38 |
|
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.03184 seconds