deploying old application on new server - jdbc ****

i'll say this right off the bat: whoever solves this problem for me, i will send a $100 pre-paid visa. i've been running in circles trying to solve this, and i just want it done. so if your reply fixes my problem, i'll send you $100. my real name is my username, so i'm not exactly hiding.

i'm helping someone move their web stuff from a backup (server crashed) to a new server. they had some birt reports in their old build, and for the life of me, i can't get them to work. old box was ubuntu 11, new one is ubuntu 12.

i have the backup (basically, everything that was in /var/lib/tomcat6/webapps), and i've installed tomcat, apache, mysql... copied all of the files to the webapps directory (under the WebViewerExample folder, as that was how it was done on the original box). web server running everything else fine. when i click on the link to the birt reports, the page comes up, does a little work, and then gives me an error. i'm pretty sure i deployed the birt runtime correctly, but who knows (not sure how to test this).

i've got the logging turned on in birt, mysql, tomcat and everything else. it looks like birt can't find the jdbc driver for mysql.

i downloaded the jdbc driver (jar), and have linked it in ${tomcat.dir}/lib (/usr/share/tomcat6/lib). i've tried putting it in the /var/lib/tomcat6/webapps/WebViewerExample/WEB-INF/lib directory. i've specified that jar exclusively in the classpath within tomcat6. i tried giving it permission in the 04webapps.policy file.

but birt can't find the friggin driver.

any help is profitable help.

oh, and this has to be done from the command line via ssh. no nice eclipse gui.

Find more posts tagged with

Comments

jasonmclos

i'm no longer getting the same error. now the error is this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>Sep 2, 2012 2:41:11 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server..
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:264)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:214)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
</pre>
 
originally, it was this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>Sep 1, 2012 3:49:51 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: refreshUrlsWhenFail: true
Sep 1, 2012 3:49:51 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: driverClassPath: null
Sep 1, 2012 3:49:51 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: Registered URLs:
Sep 1, 2012 3:49:51 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
WARNING: Failed to load JDBC driver class: com.mysql.jdbc.Driver
Sep 1, 2012 3:49:51 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.mysql.jdbc.Driver.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:782)
.... Huge stack trace...</pre>
 
so it looks like it is finding the driver, but not connecting. 
 
any clues. like i said, $100 to anyone who can help me fix this.

jasonmclos

figured it out. the BIRT code was connecting via an IP, not 'localhost'. MySQL wasn't binding on that IP (was binding on localhost). so had to let mysql bind on the IP, and then give the user access within mysql to that IP as well.

problem solved. saved myself $100.