спасибо, продвигаюсь
2016-10-11 17:08 GMT+03:00 Maxim Solodovnik <solomax...@gmail.com>:
> первая ошибка связана с тем что в таблице configuration колонка KEY0
> переименована в om_key
> надо
> update configuration set om_key = key0;
>
> вторая ошибка
> это скорее всего проблемы с доступом к базе
>
> On Tue, Oct 11, 2016 at 8:29 PM, sergey sivun <neptu...@gmail.com> wrote:
> > скачал 3.1.4-SNAPSHOT 1764193 2016/10/11 04:27
> > по ссылке приводимой тут ниже.
> > Решил посмотреть т.к. очень нужно правильная работа списка
> подключившихся к
> > комнате(или возвращаться к более ранней версии надо)
> > разархивировал архив, скопировал из 3.1.3 файлы
> > mysql-connector-java-5.1.35.jar и persistence.xml
> > запускаю, захожу на страницу, появляется окно с вводом логина и пароля,
> > ввожу и потом чистая страница и Internal error, которую привел ниже из
> лог
> > файла.
> > Что-то еще забыл сделать? или в 3.1.4 что-то поменяли?
> >
> >
> > DEBUG 10-11 14:58:15.074 o.a.o.u.c.CryptProvider:32
> > [http-nio-0.0.0.0-5080-exec-9] - getInstanceOfCrypt::
> > configKeyCryptClassName: null
> > ERROR 10-11 14:58:15.083 o.a.w.DefaultExceptionMapper:170
> > [http-nio-0.0.0.0-5080-exec-9] - Unexpected error occurred
> > org.apache.wicket.WicketRuntimeException: Method onRequest of interface
> > org.apache.wicket.behavior.IBehaviorListener targeted at
> > org.apache.wicket.ajax.markup.html.form.AjaxButton$1@75c92e1 on
> component
> > [AjaxButton [Component id = submit]] threw an exception
> > at
> > org.apache.wicket.RequestListenerInterface.internalInvoke(
> RequestListenerInterface.java:268)
> > at
> > org.apache.wicket.RequestListenerInterface.invoke(
> RequestListenerInterface.java:241)
> > at
> > org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandle
> r.invokeListener(ListenerInterfaceRequestHandler.java:248)
> > at
> > org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandle
> r.respond(ListenerInterfaceRequestHandler.java:234)
> > at
> > org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(
> RequestCycle.java:895)
> > at
> > org.apache.wicket.request.RequestHandlerStack.execute(
> RequestHandlerStack.java:64)
> > at
> > org.apache.wicket.request.cycle.RequestCycle.execute(
> RequestCycle.java:265)
> > at
> > org.apache.wicket.request.cycle.RequestCycle.
> processRequest(RequestCycle.java:222)
> > at
> > org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(
> RequestCycle.java:293)
> > at
> > org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(
> AbstractUpgradeFilter.java:70)
> > at
> > org.apache.wicket.protocol.http.WicketFilter.
> processRequest(WicketFilter.java:203)
> > at
> > org.apache.wicket.protocol.http.WicketFilter.doFilter(
> WicketFilter.java:284)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:192)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:165)
> > at
> > org.red5.logging.LoggerContextFilter.doFilter(
> LoggerContextFilter.java:84)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:192)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:165)
> > at
> > org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:198)
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:108)
> > at
> > org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:472)
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:140)
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:79)
> > at
> > org.apache.catalina.valves.AbstractAccessLogValve.invoke(
> AbstractAccessLogValve.java:620)
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:87)
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:349)
> > at
> > org.apache.coyote.http11.Http11Processor.service(
> Http11Processor.java:784)
> > at
> > org.apache.coyote.AbstractProcessorLight.process(
> AbstractProcessorLight.java:66)
> > at
> > org.apache.coyote.AbstractProtocol$ConnectionHandler.process(
> AbstractProtocol.java:802)
> > at
> > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.
> doRun(NioEndpoint.java:1410)
> > at
> > org.apache.tomcat.util.net.SocketProcessorBase.run(
> SocketProcessorBase.java:49)
> > at
> > java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> > at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> > at
> > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: java.lang.reflect.InvocationTargetException: null
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> > sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> > at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:497)
> > at
> > org.apache.wicket.RequestListenerInterface.internalInvoke(
> RequestListenerInterface.java:258)
> > ... 33 common frames omitted
> > Caused by: java.lang.NullPointerException: null
> > at
> > org.apache.openmeetings.db.dao.user.UserDao.verifyPassword(UserDao.java:
> 452)
> > at org.apache.openmeetings.db.dao.user.UserDao.login(UserDao.java:615)
> > at
> > org.apache.openmeetings.db.dao.user.UserDao$$FastClassBySpringCGLIB$$
> 1492ba5a.invoke(<generated>)
> > at org.springframework.cglib.proxy.MethodProxy.invoke(
> MethodProxy.java:204)
> > at
> > org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.
> invokeJoinpoint(CglibAopProxy.java:720)
> > at
> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:157)
> > at
> > org.springframework.transaction.interceptor.TransactionInterceptor$1.
> proceedWithInvocation(TransactionInterceptor.java:99)
> > at
> > org.springframework.transaction.interceptor.TransactionAspectSupport.
> invokeWithinTransaction(TransactionAspectSupport.java:280)
> > at
> > org.springframework.transaction.interceptor.
> TransactionInterceptor.invoke(TransactionInterceptor.java:96)
> > at
> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> > at
> > org.springframework.aop.framework.CglibAopProxy$
> DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> > at
> > org.apache.openmeetings.db.dao.user.UserDao$$EnhancerBySpringCGLIB$$
> 885aa38e.login(<generated>)
> > at org.apache.openmeetings.web.app.WebSession.signIn(
> WebSession.java:298)
> > at
> > org.apache.openmeetings.web.pages.auth.SignInDialog.
> onSubmit(SignInDialog.java:177)
> > at
> > org.apache.openmeetings.web.pages.auth.SignInDialog$
> SignInForm$1.onSubmit(SignInDialog.java:225)
> > at
> > org.apache.wicket.ajax.markup.html.form.AjaxButton$1.
> onSubmit(AjaxButton.java:113)
> > at
> > org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$
> AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215)
> > at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.
> java:1307)
> > at org.apache.wicket.markup.html.form.Form.process(Form.java:974)
> > at
> > org.apache.wicket.markup.html.form.StatelessForm.process(
> StatelessForm.java:100)
> > at org.apache.wicket.markup.html.form.Form.onFormSubmitted(
> Form.java:795)
> > at
> > org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(
> AjaxFormSubmitBehavior.java:171)
> > at
> > org.apache.wicket.ajax.AjaxEventBehavior.respond(
> AjaxEventBehavior.java:155)
> > at
> > org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(
> AbstractDefaultAjaxBehavior.java:601)
> > ... 38 common frames omitted
> > WARN 10-11 14:58:18.750 o.a.o.d.d.b.ConfigurationDao:118
> > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-7]
> -
> > Could not find key in configurations: smtp_server
> >
> > Продолжение - ну ладно, создал новую базу - open314
> > запускаю openmeetings/install
> > тестирование соединения с базой проходит успешно
> > на последнем этапе вылетает ошибка
> > Ошибка установки
> >
> > org.springframework.orm.jpa.JpaSystemException: The transaction has
> > been rolled back. See the nested exceptions for details on the errors
> > that occurred.; nested exception is <openjpa-2.4.1-r422266:1730418
> > fatal general error>
> > org.apache.openjpa.persistence.PersistenceException: The transaction
> > has been rolled back. See the nested exceptions for details on the
> > errors that occurred.
> > FailedObject: org.apache.openmeetings.db.entity.basic.Naviglobal@
> 66cb7068
> > at org.springframework.orm.jpa.EntityManagerFactoryUtils.
> convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
> > at org.springframework.orm.jpa.DefaultJpaDialect.
> translateExceptionIfPossible(DefaultJpaDialect.java:122)
> > at org.springframework.orm.jpa.JpaTransactionManager.doCommit(
> JpaTransactionManager.java:521)
> > at org.springframework.transaction.support.
> AbstractPlatformTransactionManager.processCommit(
> AbstractPlatformTransactionManager.java:761)
> > at org.springframework.transaction.support.
> AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionMan
> ager.java:730)
> > at org.springframework.transaction.interceptor.
> TransactionAspectSupport.commitTransactionAfterReturnin
> g(TransactionAspectSupport.java:483)
> > at org.springframework.transaction.interceptor.
> TransactionAspectSupport.invokeWithinTransaction(
> TransactionAspectSupport.java:290)
> > at org.springframework.transaction.interceptor.
> TransactionInterceptor.invoke(TransactionInterceptor.java:96)
> > at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:179)
> > at org.springframework.aop.framework.CglibAopProxy$
> DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> > at org.apache.openmeetings.db.dao.basic.NavigationDao$$
> EnhancerBySpringCGLIB$$4082f43d.addGlobalStructure(<generated>)
> > at org.apache.openmeetings.installation.ImportInitvalues.
> loadMainMenu(ImportInitvalues.java:119)
> > at org.apache.openmeetings.installation.ImportInitvalues.
> loadSystem(ImportInitvalues.java:518)
> > at org.apache.openmeetings.installation.ImportInitvalues.
> loadAll(ImportInitvalues.java:534)
> > at org.apache.openmeetings.web.pages.install.InstallWizard$
> InstallProcess.run(InstallWizard.java:642)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error>
> > org.apache.openjpa.persistence.PersistenceException: The transaction
> > has been rolled back. See the nested exceptions for details on the
> > errors that occurred.
> > FailedObject: org.apache.openmeetings.db.entity.basic.Naviglobal@
> 66cb7068
> > at org.apache.openjpa.kernel.BrokerImpl.newFlushException(
> BrokerImpl.java:2368)
> > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.
> java:2205)
> > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(
> BrokerImpl.java:2103)
> > at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(
> BrokerImpl.java:2021)
> > at org.apache.openjpa.kernel.LocalManagedRuntime.commit(
> LocalManagedRuntime.java:81)
> > at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.
> java:1526)
> > at org.apache.openjpa.kernel.DelegatingBroker.commit(
> DelegatingBroker.java:932)
> > at org.apache.openjpa.persistence.EntityManagerImpl.
> commit(EntityManagerImpl.java:571)
> > at org.springframework.orm.jpa.JpaTransactionManager.doCommit(
> JpaTransactionManager.java:517)
> > ... 13 more
> > Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error>
> > org.apache.openjpa.persistence.PersistenceException: Table
> > 'open314.naviglobal' doesn't exist {prepstmnt 2066625157 INSERT INTO
> > naviglobal (comment, deleted, icon, inserted, label_id, level_id,
> > name, naviorder, tooltip_label_id, updated) VALUES (?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?)} [code=1146, state=42S02]
> > FailedObject: org.apache.openmeetings.db.entity.basic.Naviglobal@
> 66cb7068
> > at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(
> DBDictionary.java:5003)
> > at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(
> DBDictionary.java:4963)
> > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> SQLExceptions.java:133)
> > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> SQLExceptions.java:75)
> > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.
> flushAndUpdate(PreparedStatementManagerImpl.java:144)
> > at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManag
> erImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
> > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.
> flushInternal(PreparedStatementManagerImpl.java:100)
> > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.
> flush(PreparedStatementManagerImpl.java:88)
> > at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(
> ConstraintUpdateManager.java:550)
> > at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(
> ConstraintUpdateManager.java:106)
> > at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManage
> r.flush(BatchingConstraintUpdateManager.java:59)
> > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.
> flush(AbstractUpdateManager.java:104)
> > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.
> flush(AbstractUpdateManager.java:77)
> > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(
> JDBCStoreManager.java:731)
> > at org.apache.openjpa.kernel.DelegatingStoreManager.flush(
> DelegatingStoreManager.java:131)
> > at org.apache.openjpa.datacache.DataCacheStoreManager.flush(
> DataCacheStoreManager.java:668)
> > at org.apache.openjpa.kernel.DelegatingStoreManager.flush(
> DelegatingStoreManager.java:131)
> > ... 21 more
> > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
> > 'open314.naviglobal' doesn't exist {prepstmnt 2066625157 INSERT INTO
> > naviglobal (comment, deleted, icon, inserted, label_id, level_id,
> > name, naviorder, tooltip_label_id, updated) VALUES (?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?)} [code=1146, state=42S02]
> > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(
> LoggingConnectionDecorator.java:218)
> > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(
> LoggingConnectionDecorator.java:194)
> > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.
> access$1000(LoggingConnectionDecorator.java:58)
> > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$
> LoggingConnection$LoggingPreparedStatement.executeUpdate(
> LoggingConnectionDecorator.java:1133)
> > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.
> executeUpdate(DelegatingPreparedStatement.java:275)
> > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.
> executeUpdate(DelegatingPreparedStatement.java:275)
> > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.
> executeUpdate(PreparedStatementManagerImpl.java:268)
> > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.
> flushAndUpdate(PreparedStatementManagerImpl.java:119)
> > ... 33 more
>
>
>
> --
> WBR
> Maxim aka solomax
>
