Hello Maxim. Unable to install version 3. I moved the file mysql-connector-java-gpl-5.1.29 to \webapps\openmeetings\WEB-INF\lib and exectued it, but the error persists.
Any ideas? Thank you, Lee. Installation is failed org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.2.2-r422266:1468616 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) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at org.apache.openmeetings.db.dao.user.UserLevelDao$$EnhancerByCGLIB$$d391be88.addUserLevel(<generated>) at org.apache.openmeetings.installation.ImportInitvalues.loadUserLevels(ImportInitvalues.java:133) at org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:960) at org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:998) at org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:389) at java.lang.Thread.run(Thread.java:722) Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518) at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531) at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456) at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:120) at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:967) at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:958) at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:338) at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:326) at org.apache.openjpa.kernel.AbstractBrokerFactory.initializeBroker(AbstractBrokerFactory.java:228) at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:212) at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:445) at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:366) ... 11 more Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) ... 30 more Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1702) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1547) at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420) ... 35 more On Sun, Mar 2, 2014 at 4:37 AM, Maxim Solodovnik <solomax...@gmail.com>wrote: > The option should be -v (verbose) I guess. > > There was couple of fixes regarding cleanup in 3.0 could you please search > mailing lists and/or try 3.0? > On Mar 2, 2014 6:52 AM, "Lee Saunders" <leesenglishless...@gmail.com> > wrote: > >> Hello Maxim. >> >> I've always called the operation the same way. Only recently has it >> started failing. >> That option -d didn't work. it was unrecognised. >> >> All the above suggestions failed. >> >> >> On Sat, Mar 1, 2014 at 11:08 AM, Maxim Solodovnik >> <solomax...@gmail.com>wrote: >> >>> The problem is in how you are calling this commend :( >>> >>> According to the "./admin.sh" output: >>> >>> -------------------------------------------------------------------------------------------------- >>> -f,--files File operations - statictics/cleanup >>> --cleanup (optional) Should intermediate >>> files be clean up >>> >>> -------------------------------------------------------------------------------------------------- >>> >>> so you need to use "-f" OR "--files" >>> >>> please try >>> "./admin.sh -d -f --cleanup" >>> or >>> "./admin.sh -d --files --cleanup" >>> >>> PS on windows please use "admin.bat" instead of "./admin.sh" >>> >>> >>> On Fri, Feb 28, 2014 at 9:13 PM, Lee Saunders < >>> leesenglishless...@gmail.com> wrote: >>> >>>> Hello, >>>> >>>> I am receiving errors when I want to clean up files. It used to show me >>>> the size of data removed and other information. Here's the CMD output: >>>> >>>> >>>> I:\classes>admin -f --files --cleanup >>>> >>>> I:\classes>REM ############################################# >>>> >>>> I:\classes>REM Licensed under the Apache License, Version 2.0 (the >>>> "License"); >>>> >>>> I:\classes>REM you may not use this file except in compliance with the >>>> License. >>>> >>>> >>>> I:\classes>REM You may obtain a copy of the License at >>>> >>>> I:\classes>REM >>>> >>>> I:\classes>REM http://www.apache.org/licenses/LICENSE-2.0 >>>> >>>> I:\classes>REM >>>> >>>> I:\classes>REM Unless required by applicable law or agreed to in >>>> writing, softwa >>>> re >>>> >>>> I:\classes>REM distributed under the License is distributed on an "AS >>>> IS" BASIS, >>>> >>>> >>>> I:\classes>REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either >>>> express or i >>>> mplied. >>>> >>>> I:\classes>REM See the License for the specific language governing >>>> permissions a >>>> nd >>>> >>>> I:\classes>REM limitations under the License. >>>> >>>> I:\classes>REM ############################################# >>>> Setting default logging context: default >>>> WARNING: all intermadiate files will be clean up! >>>> Context init... >>>> Logger name for context: openmeetings >>>> Context logger config file: logback-config.xml >>>> Adding logger context: openmeetings to map for context: openmeetings >>>> DEBUG 02-28 14:09:20.500 ContextLoggingListener.java 75 72 ROOT [main] >>>> - Startin >>>> g up context openmeetings >>>> SLF4J: Class path contains multiple SLF4J bindings. >>>> SLF4J: Found binding in >>>> [jar:file:/I:/classes/red5.jar!/org/slf4j/impl/StaticLog >>>> gerBinder.class] >>>> SLF4J: Found binding in >>>> [jar:file:/I:/classes/lib/logback-classic-1.0.3.jar!/org >>>> /slf4j/impl/StaticLoggerBinder.class] >>>> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an >>>> explanation. >>>> >>>> [INFO] [main] >>>> org.springframework.context.support.ClassPathXmlApplicationContext >>>> - Refreshing >>>> org.springframework.context.support.ClassPathXmlApplicationContext >>>> @4c60db08: startup date [Fri Feb 28 14:09:20 GMT 2014]; root of context >>>> hierarch >>>> y >>>> [INFO] [main] >>>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Lo >>>> ading XML bean definitions from class path resource >>>> [openmeetings-applicationCon >>>> text.xml] >>>> [INFO] [main] >>>> org.springframework.beans.factory.support.DefaultListableBeanFacto >>>> ry - Pre-instantiating singletons in >>>> org.springframework.beans.factory.support.D >>>> efaultListableBeanFactory@6b1ddb66: defining beans >>>> [entityManagerFactory,transac >>>> >>>> tionManager,org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostPro >>>> >>>> cessor#0,jpaTransactionManager,multipartResolver,org.springframework.web.servlet >>>> >>>> .mvc.method.annotation.RequestMappingHandlerMapping#0,org.springframework.format >>>> >>>> .support.FormattingConversionServiceFactoryBean#0,org.springframework.web.servle >>>> >>>> t.mvc.method.annotation.RequestMappingHandlerAdapter#0,org.springframework.web.s >>>> ervlet.handler.MappedInterceptor#0, >>>> org.springframework.web.servlet.mvc.method.an >>>> >>>> notation.ExceptionHandlerExceptionResolver#0,org.springframework.web.servlet.mvc >>>> .annotation.ResponseStatusExceptionResolver#0, >>>> org.springframework.web.servlet.mv >>>> >>>> c.support.DefaultHandlerExceptionResolver#0,org.springframework.web.servlet.hand >>>> >>>> ler.BeanNameUrlHandlerMapping,org.springframework.web.servlet.mvc.HttpRequestHan >>>> >>>> dlerAdapter,org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter,o >>>> >>>> rg.springframework.aop.config.internalAutoProxyCreator,org.springframework.trans >>>> >>>> action.annotation.AnnotationTransactionAttributeSource#0,org.springframework.tra >>>> nsaction.interceptor.TransactionInterceptor#0, >>>> org.springframework.transaction.co >>>> >>>> nfig.internalTransactionAdvisor,org.springframework.context.annotation.internalC >>>> >>>> onfigurationAnnotationProcessor,org.springframework.context.annotation.internalA >>>> >>>> utowiredAnnotationProcessor,org.springframework.context.annotation.internalRequi >>>> >>>> redAnnotationProcessor,org.springframework.context.annotation.internalCommonAnno >>>> >>>> tationProcessor,org.springframework.context.annotation.internalPersistenceAnnota >>>> >>>> tionProcessor,backupImportController,importController,networkTestingController,s >>>> >>>> creenController,uploadController,web.handler,openmeetings.SessionManager,openmee >>>> >>>> tings.EmoticonsManager,openmeetings.HashMapStore,whiteBoardObjectListManagerById >>>> >>>> ,whiteBoardObjectSyncManager,openmeetings.DatabaseStore,openmeetings.ServerUtil, >>>> >>>> xmlcrm.service,printservice.service,pollservice.service,organisationservice.serv >>>> >>>> ice,meetingmemberservice.service,languageservice.service,invitationservice.servi >>>> >>>> ce,ldapconfigservice.service,whiteboardservice.service,userservice.service,files >>>> >>>> ervice.service,openmeetings.FileProcessor,openmeetings.FlvExplorerConverter,erro >>>> >>>> rservice.service,conferenceservice.service,configservice.service,chatservice.ser >>>> >>>> vice,calendarservice.service,flvrecorderservice.service,openmeetings.FlvRecorder >>>> >>>> ConverterTask,openmeetings.FlvInterviewConverterTask,openmeetings.FlvInterviewRe >>>> >>>> ConverterTask,openmeetings.FlvInterviewConverter,openmeetings.FlvRecorderConvert >>>> >>>> er,openmeetings.SlaveHTTPConnectionManager,openmeetings.SessionClearJob,sessionC >>>> >>>> learJob,triggerSessionClear,openmeetings.MeetingReminderJob,meetingReminderClear >>>> >>>> ,triggerMeetingReminder,testSetupCleanupJob,testSetupCleanup,triggerTestSetupCle >>>> >>>> anup,mailHandler,resetSendingMailStatus,triggerResetSendingMailStatus,sendMails, >>>> >>>> triggerSendMails,org.springframework.scheduling.quartz.SchedulerFactoryBean#0,ap >>>> >>>> pointmentReminderTypDaoImpl,appointmentCategoryDaoImpl,roommanagement,roomDao,si >>>> >>>> pDao,organisationmanagement,organisationDao,organisationUserDao,salutationmanage >>>> >>>> ment,errorManagement,navimanagement,pollManagement,omTimeZoneDaoImpl,statemanage >>>> >>>> ment,fieldLanguageDaoImpl,fieldValueDaoImpl,fieldLanguagesValuesDAO,fieldmanagme >>>> >>>> nt,configurationDaoImpl,appointmentDao,appointmentLogic,meetingMemberLogic,sessi >>>> >>>> onManagement,userManagement,roomModeratorsDao,conferenceLogDao,conferenceLogType >>>> >>>> Dao,emailManagement,fileExplorerItemDao,flvRecordingDao,flvRecordingLogDao,flvRe >>>> >>>> cordingMetaDataDao,flvRecordingMetaDeltaDao,ldapConfigDao,invitationManagement,m >>>> >>>> eetingMemberDao,privateMessageFolderDao,privateMessagesDao,soapLoginDao,userCont >>>> >>>> actsDao,usersDao,serverDao,chatDao,clientDao,mailMessageDao,manageCryptStyle,gen >>>> >>>> erateImage,generateThumbs,generatePDF,smsHandler,feedbackManagement,importInitva >>>> >>>> lues,languageImport,userImport,libraryWmlLoader,loadAtomRssFeed,authLevelManagem >>>> >>>> ent,generateSWF,fileUtils,ldapLoginManagement,timezoneUtil,whiteboardManagement, >>>> >>>> registerUserTemplate,feedbackTemplate,invitationTemplate,requestContactTemplate, >>>> >>>> requestContactConfirmTemplate,resetPasswordTemplate,taskExecutor,userWebService, >>>> >>>> roomWebService,fileWebService,calendarWebService,jabberWebService,serverWebServi >>>> >>>> ce,backupExport,org.springframework.context.annotation.ConfigurationClassPostPro >>>> cessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy >>>> [INFO] [main] org.springframework.orm.jpa.LocalEntityManagerFactoryBean >>>> - Buildi >>>> ng JPA EntityManagerFactory for persistence unit 'openmeetings' >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/backup.upload],methods=[POST],params=[],headers=[] >>>> ,consumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeetings.se >>>> >>>> rvlet.outputhandler.BackupImportController.service(javax.servlet.http.HttpServle >>>> tRequest,javax.servlet.http.HttpServletResponse) throws >>>> javax.servlet.ServletExc >>>> eption,java.io.IOException >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/import.upload],methods=[POST],params=[],headers=[] >>>> ,consumes=[],produces=[],custom=[]}" onto protected void >>>> org.apache.openmeetings >>>> >>>> .servlet.outputhandler.ImportController.service(javax.servlet.http.HttpServletRe >>>> quest,javax.servlet.http.HttpServletResponse) throws >>>> javax.servlet.ServletExcept >>>> ion >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/networktest.upload],methods=[GET],params=[],header >>>> s=[],consumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeeting >>>> >>>> s.servlet.outputhandler.NetworkTestingController.serviceGet(javax.servlet.http.H >>>> >>>> ttpServletRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.Http >>>> Session) throws javax.servlet.ServletException,java.io.IOException >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/networktest.upload],methods=[POST],params=[],heade >>>> rs=[],consumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeetin >>>> >>>> gs.servlet.outputhandler.NetworkTestingController.servicePost(javax.servlet.http >>>> .HttpServletRequest,javax.servlet.http.HttpServletResponse, >>>> javax.servlet.http.Ht >>>> tpSession) throws javax.servlet.ServletException,java.io.IOException >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/screen.upload],methods=[],params=[],headers=[],con >>>> sumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeetings.servle >>>> >>>> t.outputhandler.ScreenController.handleRequest(javax.servlet.http.HttpServletReq >>>> uest,javax.servlet.http.HttpServletResponse) >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/file.upload],methods=[POST],params=[],headers=[],c >>>> onsumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeetings.serv >>>> >>>> let.outputhandler.UploadController.handleFileUpload(javax.servlet.http.HttpServl >>>> >>>> etRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.HttpSession) >>>> throws javax.servlet.ServletException >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/remotelog.upload],methods=[POST],params=[],headers >>>> =[],consumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeetings >>>> >>>> .servlet.outputhandler.UploadController.handleRemoteLog(javax.servlet.http.HttpS >>>> ervletRequest,javax.servlet.http.HttpServletResponse) throws >>>> javax.servlet.Servl >>>> etException >>>> [INFO] [main] >>>> org.springframework.web.servlet.mvc.method.annotation.RequestMappi >>>> ngHandlerMapping - Mapped >>>> "{[/upload.upload],methods=[POST],params=[],headers=[] >>>> ,consumes=[],produces=[],custom=[]}" onto public void >>>> org.apache.openmeetings.se >>>> >>>> rvlet.outputhandler.UploadController.handleFormUpload(javax.servlet.http.HttpSer >>>> vletRequest,javax.servlet.http.HttpServletResponse) throws >>>> javax.servlet.Servlet >>>> Exception >>>> [INFO] [main] >>>> org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - >>>> Initializing ExecutorService 'taskExecutor' >>>> [INFO] [main] org.quartz.core.SchedulerSignalerImpl - Initialized >>>> Scheduler Sign >>>> aller of type: class org.quartz.core.SchedulerSignalerImpl >>>> [INFO] [main] org.quartz.core.QuartzScheduler - Quartz Scheduler >>>> v.1.8.5 created >>>> . >>>> [INFO] [main] org.quartz.simpl.RAMJobStore - RAMJobStore initialized. >>>> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler meta-data: >>>> Quartz Sche >>>> duler (v1.8.5) >>>> 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' wi >>>> th instanceId 'NON_CLUSTERED' >>>> Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. >>>> NOT STARTED. >>>> Currently in standby mode. >>>> Number of jobs executed: 0 >>>> Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 >>>> threads. >>>> Using job-store 'org.quartz.simpl.RAMJobStore' - which does not >>>> support persis >>>> tence. and is not clustered. >>>> >>>> [INFO] [main] org.quartz.impl.StdSchedulerFactory - Quartz scheduler >>>> 'org.spring >>>> framework.scheduling.quartz.SchedulerFactoryBean#0' initialized from an >>>> external >>>> ly provided properties instance. >>>> [INFO] [main] org.quartz.impl.StdSchedulerFactory - Quartz scheduler >>>> version: 1. >>>> 8.5 >>>> [INFO] [main] org.quartz.core.QuartzScheduler - JobFactory set to: >>>> org.springfra >>>> mework.scheduling.quartz.AdaptableJobFactory@65f578dd >>>> [INFO] [main] >>>> org.springframework.context.support.DefaultLifecycleProcessor - St >>>> arting beans in phase 2147483647 >>>> [INFO] [main] >>>> org.springframework.scheduling.quartz.SchedulerFactoryBean - Start >>>> ing Quartz Scheduler now >>>> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler >>>> org.springframework.sc >>>> heduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started. >>>> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler >>>> org.springframework.sc >>>> heduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down. >>>> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler >>>> org.springframework.sc >>>> heduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused. >>>> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler >>>> org.springframework.sc >>>> heduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown >>>> complete. >>>> 2593 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA >>>> 2.2.1 >>>> [ERROR] [main] org.apache.openmeetings.cli.Admin - Files failed null >>>> I:\classes> >>>> >>> >>> >>> >>> -- >>> WBR >>> Maxim aka solomax >>> >> >>