[ https://issues.apache.org/jira/browse/OPENMEETINGS-997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13996963#comment-13996963 ]
Miguel Muñoz commented on OPENMEETINGS-997: ------------------------------------------- I have the same problem with 3.0.2. I believe I have a problem in persistence.xml because any table is created in the db. The command line neither work for me. Error: ----- 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 create PoolableConnectionFactory (Error de inicio de sesión del usuario ''. ClientConnectionId:d7880f78-3f23-4de9-b5ab-15d6519e81d2) 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$$784222d3.addUserLevel(<generated>) at org.apache.openmeetings.installation.ImportInitvalues.loadUserLevels(ImportInitvalues.java:136) at org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:959) at org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:997) at org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:389) at java.lang.Thread.run(Thread.java:744) Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (Error de inicio de sesión del usuario ''. ClientConnectionId:d7880f78-3f23-4de9-b5ab-15d6519e81d2) 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 create PoolableConnectionFactory (Error de inicio de sesión del usuario ''. ClientConnectionId:d7880f78-3f23-4de9-b5ab-15d6519e81d2) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) 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: com.microsoft.sqlserver.jdbc.SQLServerException: Error de inicio de sesión del usuario ''. ClientConnectionId:d7880f78-3f23-4de9-b5ab-15d6519e81d2 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 35 more ----- The persistence file: ----- <?xml version="1.0" encoding="UTF-8"?> <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <!-- persistence.xml schema --> <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" version="2.0"> <persistence-unit name="openmeetings" transaction-type="RESOURCE_LOCAL"> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> <class>org.apache.openmeetings.db.entity.basic.Configuration</class> <class>org.apache.openmeetings.db.entity.basic.ErrorType</class> <class>org.apache.openmeetings.db.entity.basic.ErrorValue</class> <class>org.apache.openmeetings.db.entity.server.LdapConfig</class> <class>org.apache.openmeetings.db.entity.basic.MailMessage</class> <class>org.apache.openmeetings.db.entity.basic.Naviglobal</class> <class>org.apache.openmeetings.db.entity.basic.Navimain</class> <class>org.apache.openmeetings.db.entity.server.Sessiondata</class> <class>org.apache.openmeetings.db.entity.server.SOAPLogin</class> <class>org.apache.openmeetings.db.entity.server.Server</class> <class>org.apache.openmeetings.db.entity.calendar.Appointment</class> <class>org.apache.openmeetings.db.entity.calendar.AppointmentCategory</class> <class>org.apache.openmeetings.db.entity.calendar.AppointmentReminderTyps</class> <class>org.apache.openmeetings.db.entity.calendar.MeetingMember</class> <class>org.apache.openmeetings.db.entity.basic.ChatMessage</class> <class>org.apache.openmeetings.db.entity.user.Organisation</class> <class>org.apache.openmeetings.db.entity.user.Organisation_Users</class> <class>org.apache.openmeetings.db.entity.record.FlvRecording</class> <class>org.apache.openmeetings.db.entity.record.FlvRecordingLog</class> <class>org.apache.openmeetings.db.entity.record.FlvRecordingMetaData</class> <class>org.apache.openmeetings.db.entity.record.FlvRecordingMetaDelta</class> <class>org.apache.openmeetings.db.entity.room.Invitation</class> <class>org.apache.openmeetings.db.entity.label.FieldLanguage</class> <class>org.apache.openmeetings.db.entity.label.Fieldlanguagesvalues</class> <class>org.apache.openmeetings.db.entity.label.Fieldvalues</class> <class>org.apache.openmeetings.db.entity.log.ConferenceLog</class> <class>org.apache.openmeetings.db.entity.log.ConferenceLogType</class> <class>org.apache.openmeetings.db.entity.room.PollType</class> <class>org.apache.openmeetings.db.entity.room.RoomPoll</class> <class>org.apache.openmeetings.db.entity.room.RoomPollAnswers</class> <class>org.apache.openmeetings.db.entity.room.Client</class> <class>org.apache.openmeetings.db.entity.room.RoomModerator</class> <class>org.apache.openmeetings.db.entity.room.Room</class> <class>org.apache.openmeetings.db.entity.room.RoomType</class> <class>org.apache.openmeetings.db.entity.room.Whiteboard</class> <class>org.apache.openmeetings.db.entity.room.WhiteboardItem</class> <class>org.apache.openmeetings.db.entity.room.RoomOrganisation</class> <class>org.apache.openmeetings.db.entity.user.Address</class> <class>org.apache.openmeetings.db.entity.user.State</class> <class>org.apache.openmeetings.db.entity.user.PrivateMessage</class> <class>org.apache.openmeetings.db.entity.user.PrivateMessageFolder</class> <class>org.apache.openmeetings.db.entity.user.Salutation</class> <class>org.apache.openmeetings.db.entity.user.UserContact</class> <class>org.apache.openmeetings.db.entity.user.Userdata</class> <class>org.apache.openmeetings.db.entity.user.Userlevel</class> <class>org.apache.openmeetings.db.entity.user.User</class> <class>org.apache.openmeetings.db.entity.file.FileExplorerItem</class> <class>org.apache.openmeetings.db.entity.user.AsteriskSipUser</class> <class>org.apache.openmeetings.db.entity.server.OAuthServer</class> <exclude-unlisted-classes>false</exclude-unlisted-classes> <properties> <property name="openjpa.RuntimeUnenhancedClasses" value="unsupported" /> <property name="openjpa.ConnectionDriverName" value="org.apache.commons.dbcp.BasicDataSource" /> <property name="openjpa.ConnectionProperties" value="DriverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver,Url=jdbc:sqlserver://localhost:1433;databaseName=openmeetings;user=openmeetings;password=123456;" /> <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema" /> <property name="openjpa.Log" value="DefaultLevel=WARN, Runtime=INFO" /> <property name="openjpa.DataCache" value="true" /> <!-- QueryCache disabled due to changes outside of JPA doesn't take effect with caching --> <property name="openjpa.QueryCache" value="false" /> <property name="openjpa.jdbc.DBDictionary" value="batchLimit=100" /> <property name="openjpa.jdbc.QuerySQLCache" value="false" /> </properties> </persistence-unit> </persistence> ----- The command line: ----- admin.bat -i -v -tz Europe/Berlin ^ -group cusers ^ -user admin --password 123abc --email s...@email.com ^ --db-type mssql --db-host localhost --db-port 1433 ^ --db-name openmeetings --db-user openmeetings --db-pass 123456 ^ --force ----- The red5.log ----- 2014-05-14 00:01:14,249 [main] INFO o.s.c.s.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@74650bb9: startup date [Wed May 14 00:01:14 CEST 2014]; root of context hierarchy 2014-05-14 00:01:14,280 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [openmeetings-applicationContext.xml] 2014-05-14 00:01:14,545 [main] INFO o.s.c.a.ClassPathBeanDefinitionScanner - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning 2014-05-14 00:01:15,450 [main] INFO o.s.b.f.s.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@313a6b9: defining beans [entityManagerFactory,transactionManager,org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor#0,multipartResolver,org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping#0,org.springframework.format.support.FormattingConversionServiceFactoryBean#0,org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter#0,org.springframework.web.servlet.handler.MappedInterceptor#0,org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver#0,org.springframework.web.servlet.mvc.annotation.ResponseStatusExceptionResolver#0,org.springframework.web.servlet.mvc.support.DefaultHandlerExceptionResolver#0,org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping,org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter,org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,networkTestingController,screenController,uploadController,web.handler,openmeetings.SessionManager,openmeetings.EmoticonsManager,openmeetings.HashMapStore,whiteBoardObjectListManagerById,whiteBoardObjectSyncManager,openmeetings.DatabaseStore,openmeetings.ServerUtil,xmlcrm.service,printservice.service,pollservice.service,languageservice.service,invitationservice.service,whiteboardservice.service,userservice.service,fileservice.service,openmeetings.FileProcessor,openmeetings.FlvExplorerConverter,errorservice.service,conferenceservice.service,chatservice.service,flvrecorderservice.service,openmeetings.FlvRecorderConverterTask,openmeetings.FlvInterviewConverterTask,openmeetings.FlvInterviewReConverterTask,openmeetings.FlvInterviewConverter,openmeetings.FlvRecorderConverter,openmeetings.SlaveHTTPConnectionManager,openmeetings.SessionClearJob,sessionClearJob,triggerSessionClear,openmeetings.MeetingReminderJob,meetingReminderClear,triggerMeetingReminder,testSetupCleanupJob,testSetupCleanup,triggerTestSetupCleanup,mailHandler,resetSendingMailStatus,triggerResetSendingMailStatus,sendMails,triggerSendMails,org.springframework.scheduling.quartz.SchedulerFactoryBean#0,appointmentReminderTypDaoImpl,appointmentCategoryDaoImpl,roommanagement,roomDao,sipDao,invitationDao,organisationmanagement,organisationDao,organisationUserDao,salutationmanagement,errorManagement,navimanagement,pollManagement,statemanagement,fieldLanguageDaoImpl,fieldValueDaoImpl,fieldLanguagesValuesDAO,fieldmanagment,configurationDaoImpl,appointmentDao,appointmentLogic,sessionManagement,userManagement,roomModeratorsDao,roomOrganisationDao,roomTypeDao,conferenceLogDao,conferenceLogTypeDao,emailManagement,fileExplorerItemDao,flvRecordingDao,flvRecordingLogDao,flvRecordingMetaDataDao,flvRecordingMetaDeltaDao,ldapConfigDao,invitationManagement,meetingMemberDao,privateMessageFolderDao,privateMessagesDao,soapLoginDao,userContactsDao,dao,usersDao,adminUserDao,userLevelDao,serverDao,chatDao,clientDao,mailMessageDao,oauth2Dao,generateImage,generateThumbs,generatePDF,smsHandler,importInitvalues,languageImport,libraryWmlLoader,generateSWF,fileUtils,ldapLoginManagement,timezoneUtil,whiteboardManagement,backupExport,backupImport,taskExecutor,userWebService,roomWebService,fileWebService,calendarWebService,jabberWebService,serverWebService,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy 2014-05-14 00:01:15,497 [main] INFO o.s.o.j.LocalEntityManagerFactoryBean - Building JPA EntityManagerFactory for persistence unit 'openmeetings' 2014-05-14 00:01:15,980 [main] INFO o.s.w.s.m.m.a.RequestMappingHandlerMapping - Mapped "{[/networktest.upload],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void org.apache.openmeetings.servlet.outputhandler.NetworkTestingController.serviceGet(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.HttpSession) throws javax.servlet.ServletException,java.io.IOException 2014-05-14 00:01:15,980 [main] INFO o.s.w.s.m.m.a.RequestMappingHandlerMapping - Mapped "{[/networktest.upload],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void org.apache.openmeetings.servlet.outputhandler.NetworkTestingController.servicePost(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.HttpSession) throws javax.servlet.ServletException,java.io.IOException 2014-05-14 00:01:15,996 [main] INFO o.s.w.s.m.m.a.RequestMappingHandlerMapping - Mapped "{[/screen.upload],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void org.apache.openmeetings.servlet.outputhandler.ScreenController.handleRequest(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) 2014-05-14 00:01:15,996 [main] INFO o.s.w.s.m.m.a.RequestMappingHandlerMapping - Mapped "{[/file.upload],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void org.apache.openmeetings.servlet.outputhandler.UploadController.handleFileUpload(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.HttpSession) throws javax.servlet.ServletException 2014-05-14 00:01:15,996 [main] INFO o.s.w.s.m.m.a.RequestMappingHandlerMapping - Mapped "{[/remotelog.upload],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void org.apache.openmeetings.servlet.outputhandler.UploadController.handleRemoteLog(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws javax.servlet.ServletException 2014-05-14 00:01:15,996 [main] INFO o.s.w.s.m.m.a.RequestMappingHandlerMapping - Mapped "{[/upload.upload],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void org.apache.openmeetings.servlet.outputhandler.UploadController.handleFormUpload(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws javax.servlet.ServletException 2014-05-14 00:01:16,417 [main] WARN o.s.aop.framework.Cglib2AopProxy - Unable to proxy method [public final long org.apache.openmeetings.db.dao.basic.ConfigurationDao.getMaxUploadSize()] because it is final: All calls to this method via a proxy will be routed directly to the proxy. 2014-05-14 00:01:16,854 [main] INFO o.s.s.c.ThreadPoolTaskExecutor - Initializing ExecutorService 'taskExecutor' 2014-05-14 00:01:17,930 [main] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2014-05-14 00:01:17,930 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.1.8.5 created. 2014-05-14 00:01:17,930 [main] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 2014-05-14 00:01:17,930 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v1.8.5) 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' with 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 persistence. and is not clustered. 2014-05-14 00:01:17,930 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized from an externally provided properties instance. 2014-05-14 00:01:17,930 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 1.8.5 2014-05-14 00:01:17,930 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@51205cb7 2014-05-14 00:01:18,071 [main] INFO o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 2147483647 2014-05-14 00:01:18,071 [main] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 2014-05-14 00:01:18,071 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started. 2014-05-14 00:01:18,071 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down. 2014-05-14 00:01:18,071 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused. 2014-05-14 00:01:18,071 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete. 2014-05-14 00:01:18,445 [main] ERROR org.apache.openmeetings.cli.Admin - Install 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 create PoolableConnectionFactory (Error de inicio de sesión del usuario ''. ClientConnectionId:63c67b4d-c528-40af-b9d8-4bcf93a3a1af) at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427) ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) ~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerByCGLIB$$49ff01ab.getConfValue(<generated>) ~[com.springsource.net.sf.cglib-2.2.0.jar:na] at org.apache.openmeetings.db.util.UserHelper.getMinPasswdLength(UserHelper.java:34) ~[openmeetings-db-3.0.2-SNAPSHOT.jar:na] at org.apache.openmeetings.db.util.UserHelper.invalidPassword(UserHelper.java:38) ~[openmeetings-db-3.0.2-SNAPSHOT.jar:na] at org.apache.openmeetings.cli.Admin.checkAdminDetails(Admin.java:543) [openmeetings-cli-3.0.2-SNAPSHOT.jar:na] at org.apache.openmeetings.cli.Admin.process(Admin.java:274) [openmeetings-cli-3.0.2-SNAPSHOT.jar:na] at org.apache.openmeetings.cli.Admin.main(Admin.java:625) [openmeetings-cli-3.0.2-SNAPSHOT.jar:na] Caused by: org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (Error de inicio de sesión del usuario ''. ClientConnectionId:63c67b4d-c528-40af-b9d8-4bcf93a3a1af) at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:120) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:967) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:958) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:644) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:445) ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:366) ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] ... 11 common frames omitted Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Error de inicio de sesión del usuario ''. ClientConnectionId:63c67b4d-c528-40af-b9d8-4bcf93a3a1af) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[commons-dbcp-jar-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[commons-dbcp-jar-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[commons-dbcp-jar-1.4.jar:1.4] at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) ~[openjpa-bundle-2.2.2.jar:2.2.2] at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) ~[openjpa-bundle-2.2.2.jar:2.2.2] ... 28 common frames omitted Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Error de inicio de sesión del usuario ''. ClientConnectionId:63c67b4d-c528-40af-b9d8-4bcf93a3a1af at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) ~[sqljdbc4.jar:na] at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-jar-1.4.jar:1.4] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-jar-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-jar-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-jar-1.4.jar:1.4] ... 33 common frames omitted ----- I have tested the db user and it can create tables in the openmettings data base. ¿can you help me? I have tested the same procedure with mysql (on other pc) and it worked ok, but i can not use mysql in this server. Regards, > error installing with mssql > ---------------------------- > > Key: OPENMEETINGS-997 > URL: https://issues.apache.org/jira/browse/OPENMEETINGS-997 > Project: Openmeetings > Issue Type: Bug > Affects Versions: 3.0.1 > Environment: windows 2008 r2 > Reporter: Miguel Muñoz > Assignee: Maxim Solodovnik > Fix For: 3.0.2, 3.1.0 > > > I was not able to configure mssql during the install process. I changed the > persistence.xml, added sqljdbc4.jar (or sqljdbc.jar) and tried to install > using the command line and the web ui, both of them failed. > When I use the command line I get the following error: > ----- > Setting default logging context: default > [ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed > java.lang.IllegalArgumentException: No enum constant > org.apache.openmeetings.cli.ConnectionProperties.DbType.mssql > at java.lang.Enum.valueOf(Enum.java:236) ~[na:1.7.0_45] > at > org.apache.openmeetings.cli.ConnectionProperties$DbType.valueOf(ConnectionProperties.java:22) > ~[openmeetings-cli-3.0.1-RELEASE.jar:na] > at > org.apache.openmeetings.cli.ConnectionPropertiesPatcher.getPatcher(ConnectionPropertiesPatcher.java:46) > ~[openmeetings-cli-3.0.1-RELEASE.jar:na] > at org.apache.openmeetings.cli.Admin.process(Admin.java:253) > [openmeetings-cli-3.0.1-RELEASE.jar:na] > at org.apache.openmeetings.cli.Admin.main(Admin.java:625) > [openmeetings-cli-3.0.1-RELEASE.jar:na] > ----- > I'm using the command: > ----- > admin.bat -i -v -tz Europe/Berlin ^ > -group gusers ^ > -user admin --password xxxx --email s...@email.com ^ > --smtp-server correu.upc.es --system-email-address s...@email.com ^ > --email-auth-user s...@email.com --email-auth-pass somepass ^ > --email-use-tls yes --disable-frontend-register yes ^ > --db-type mssql --db-host localhost --db-port 1433 ^ > --db-name openmeetings --db-user openmeetings --db-pass somepass > --- > The web ui install also failed with an error related with language.xml... -- This message was sent by Atlassian JIRA (v6.2#6252)