[
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 [email protected] ^
--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 [email protected] ^
> --smtp-server correu.upc.es --system-email-address [email protected] ^
> --email-auth-user [email protected] --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)
