Maxium,
Would this be the item that needs to be downloaded? (it was not too hard to find once I knew to look, but it would be nice if the Openmeetings install/update web site and documentation could be updated. http://dev.mysql.com/downloads/connector/j/ mysql-connector-java-5.1.20.tar.gz => mysql-connector-java-5.1.20-bin.jar I noticed that my current build has mysql-connector-java-jar-5.1.9.jar, so I guess I have located the correct place to download the JDBC driver? to red5/webapps/openmeetings/WEB_INF/lib Thanks, George Kirkham From: George Kirkham [mailto:gkirk...@co2crc.com.au] Sent: Monday, 21 May 2012 1:04 PM To: openmeetings-user@incubator.apache.org Subject: RE: Build #80 issue "Cannot load JDBC driver class 'com.mysql.jdbc.Driver' " for compiled package Maxim, I am surprised that it is not part of the JDK and needs to be introduced separately? Both myself, and many other people would not know that they would need to or even how to “download MySQL driver and put it into red5/webapps/openmeetings/WEB_INF/lib manually”. Would you please make an update to the http://incubator.apache.org/openmeetings/ web site, to explain how this can be achieved? I would suggest a new point to the installation and upgrade pages, something like; 6. Download your database driver and copy to it into red5/webapps/openmeetings/WEB_INF/lib MySQL JDBC - http://dev.mysql.com/downloads/connector/j/ Oracle JDBC - http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html DB2 JDBC - http://www-01.ibm.com/software/data/db2/express/download.html db2jcc.jar com.ibm.db2.jcc.DB2Driver http://www-304.ibm.com/support/docview.wss?uid=swg24001312 ftp://public.dhe.ibm.com/software/websphere/info/tools/DataDirect/datadirect.htm http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.apdv.java.doc%2Fdoc%2Ft0010264.htm Stephen, could you please update your OpenMeeting server build documentation for this new requirement? Thanks, George Kirkham From: Maxim Solodovnik [mailto:solomax...@gmail.com] Sent: Monday, 21 May 2012 12:23 PM To: openmeetings-user@incubator.apache.org Subject: Re: Build #80 issue "Cannot load JDBC driver class 'com.mysql.jdbc.Driver' " for compiled package Hello George, MySQL JDBC driver is licensed under LGPL which is not compatible with Apache License . This driver can not be packaged with OM (as well as Oracle and DB2 driver) So from now users need to download MuSQL driver and put it into red5/webapps/openmeetings/WEB_INF/lib manually On Mon, May 21, 2012 at 7:43 AM, George Kirkham <gkirk...@co2crc.com.au> wrote: Hi, I don’t know how much of an issue this is but it would be nice to let people know how to overcome the issue. I downloaded the build https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1340587-19-05-2012_2317.tar.gz And when I attempted to run the install the following error happens; Caused by: org.apache.openjpa.persistence.PersistenceException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' I then downloaded the source for build #80 and compile it, the compile works as it downloads the required java libraries during the build. (And no reports about missing “flash/trunk”). https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1340587-19-05-2012_2317-src.tar.gz Is there a way for people who download the compiled package to then include the required java libraries? If so, we should update the doco on the page so that people know how to get openmeetings running. /red5/log/openmeetings.log ERROR 05-21 07:48:25.613 ScopeApplicationAdapter.java 2332 174 org.openmeetings.app.remote.red5.ScopeApplicationAdapter [Launcher:/openmeetings] - [appStart] org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427) ~[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] ERROR 05-21 07:50:11.130 MeetingReminderJob.java 107849 38 org.openmeetings.app.quartz.scheduler.MeetingReminderJob [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - execute Exclusive Thanks, George Kirkham -- WBR Maxim aka solomax