Upgrade: Name [jdbc/OpenOLATDS] is not bound in this Context. Unable to find [jdbc].

[20har...@gmail.com]

Hi,

During upgrade from version 9.4.2 to the newest I cannot solve the issue  Name [jdbc/OpenOLATDS] is not bound in this Context. Unable to find [jdbc].

This is in fact new Tomcat installation.. I followed instruction from https://www.openolat.com/fileadmin/adminwiki/_START_.html and this https://www.openolat.com/fileadmin/adminwiki/_START_.html

OS is Centos 6.5

DB is MySQL

Java is "1.8.0_77"

Error in cataliona.out is:

 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databaseUpgrader' defined in class path resource [org/olat/upgrade/_spring/databaseUpgradeContext.xml]: Cannot resolve reference to bean 'mysql_jndi_DataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mysql_jndi_DataSource' defined in class path resource [org/olat/core/commons/persistence/_spring/databaseCorecontext.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException: Name [jdbc/OpenOLATDS] is not bound in this Context. Unable to find [jdbc].

ROOT.xml is

<?xml version="1.0" encoding="UTF-8" ?>

<Context path="" docBase="/d1/olat14/olatdata" debug="0" reloadable="false" allowLinking="true">

  <Resource name="jdbc/OpenOLATDS" auth="Container" type="javax.sql.DataSource"

    maxTotal="16" maxIdle="4" maxWaitMillis="60000"

    username="****" password="****"

    driverClassName="com.mysql.jdbc.Driver"

    validationQuery="SELECT 1".

    validationQueryTimeout="-1".

    testOnBorrow="true".

    testOnReturn="false"

  url="jdbc:mysql://localhost:3306/oodb?useUnicode=true&amp;characterEncoding=UTF-8&amp;cachePrepStmts=true&amp;cacheCallableStmts=true&amp;autoReconnectForPools=true"/>

</Context>

Full catalina.out is attached.

Thanks for help

[Florian Gnaegi]

Hi

What do you have in your olat.local.properties configured for: 

db.source=

db.jndi=

And: we recommend using Postgres. Our main development is all done for Postgres, we migrated all MySQL installations to Postgres. If you are setting up a new installation. We still support MySQL, but If you can, use Postgres. 

Cheers

Florian

--
--
Sie erhalten diese Nachricht, weil Sie Mitglied sind von Google
Groups-Gruppe "OpenOlat".
Für das Erstellen von Beiträgen in dieser Gruppe senden Sie eine E-Mail
an open...@googlegroups.com
Um sich von dieser Gruppe abzumelden, senden Sie eine E-Mail an
openolat+u...@googlegroups.com
Weitere Optionen finden Sie in dieser Gruppe unter
http://groups.google.com/group/openolat?hl=de
-------------------------------------------------------------------------------------------------------------------
OpenOlat - infinite learning - http://www.openolat.org
---
You received this message because you are subscribed to the Google Groups "OpenOlat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openolat+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openolat/8146cf8e-5de1-4fcb-93a6-e508e8865259%40googlegroups.com.
<catalina.out>

--------------------------------------------------------------------

professional services for the e-learning system OpenOlat

hosting - operating - support - development - mobile - consulting

--------------------------------------------------------------------

www.frentix.com | www.openolat.com 

frentix  GmbH

Florian Gnägi, Geschäftsführer

Okenstrasse 6

CH-8037 Zürich, Switzerland

tel://+41-43-544-9000

dir://+41-43-544-9001

fax://+41-43-544-9009

Find me on wire skype twitter xing linkedin 

--------------------------------------------------------------------

[Tomek Kabziński]

db.source=jndi

db.jndi=java:comp/env/jdbc/OpenOLATDS

At the moment I cannot switcch to Posgress as I am not familiar with it and old data have in MySQL.

Regards

[Florian Gnaegi]

Hi

I think your root.xml is not the one loaded by tomcat. It does not find the jdbc resource, are you sure your database is up and running, the users exist and are allowed to connect to the dbms?

What looks bogous to me is

 docBase="/d1/olat14/olatdata“ 

This should not point to the olatdata directoy but rather to your webapp directory, e.g. 

docBase="/home/openolat/webapp“

Cheers

Florian

--
--
Sie erhalten diese Nachricht, weil Sie Mitglied sind von Google
Groups-Gruppe "OpenOlat".
Für das Erstellen von Beiträgen in dieser Gruppe senden Sie eine E-Mail
an open...@googlegroups.com
Um sich von dieser Gruppe abzumelden, senden Sie eine E-Mail an
openolat+u...@googlegroups.com
Weitere Optionen finden Sie in dieser Gruppe unter
http://groups.google.com/group/openolat?hl=de
-------------------------------------------------------------------------------------------------------------------
OpenOlat - infinite learning - http://www.openolat.org
---
You received this message because you are subscribed to the Google Groups "OpenOlat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openolat+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/openolat/c879d974-07ec-4124-b61d-f2ae655ca24b%40googlegroups.com.

[Tomek Kabziński]

Thanks for help,

In fact this was wrong bu anyway I didn't manage to make it work. So I decided to procedure a different way. First I wanted to configure a fresh olat installation.

Still Centos 6.5 and MySQL.

I followed exactly procedure described here: https://www.openolat.com/fileadmin/adminwiki/_START_.html

Unfortunately I cannot make it run. The error is One or more listeners failed to start. Full details will be found in the appropriate container log file 

I found this error on this forum, so I'm not the first. But no clue how to find what the reason is.

Thanks for help.

Including catalina.out, olat.out

W dniu czwartek, 26 marca 2020 20:02:50 UTC+1 użytkownik Tomek Kabziński napisał:

[Stéphane Rossé]

From your logs, OpenOlat cannot connect to your database:

java.net.ConnectException: Połączenie odrzucone (Connection refused)

Double check the host, port, username, password and the name of the database and ensure that your user has the permission to access the database.

And that the database exists.

Best regards

Stéphane Rossé

[Tomek Kabziński]

Thanks,

Managed to conenct to database and database phase of upgrade (I think) went without errors. But during filesystem (olatdata directory) upgrade are problems I think with Lucene and more. 

Cannot initialized the searcher manager org.apache.lucene.index.IndexFormatTooOldException: Format version is not supported (resource BufferedChecksumIndexInput(MMapIndexInput

(path="/d1/openolatkursy/olatdata/bcroot/tmp/search_index/segments_1"))): 0 (needs to be between 6 and 9). This version of Lucene only supports indexes created with release 6.0 and later

Problem was mentioned here so I am not the first:

https://groups.google.com/forum/#!msg/openolat/2eHeDroELE4/rXd0HuJvCgAJ

I include logs files.

Best Regards.

W dniu czwartek, 26 marca 2020 20:02:50 UTC+1 użytkownik Tomek Kabziński napisał:

[Stéphane Rossé]

Stop OpenOlat

Delete the following index:

/d1/openolatkursy/olatdata/bcroot/tmp/search_index

/d1/openolatkursy/olatdata/bcroot/tmp/perm_index

/d1/openolatkursy/olatdata/bcroot/tmp/temp_search_index

/d1/openolatkursy/olatdata/bcroot/tmp/temp_spellcheck_index

restart OpenOlat

Reindex in OpenOlat Administration > Core configuration > full text search

Best regards

Stéphane Rossé

[Tomek Kabziński]

Thanks,

Managed to login but for unknown reason user which is admin, after upgrade is no longer admin. Administration tabs not visible after login. Only Courses tab.

I see one more error during upgrade - maybe this is the reasons not everything went well (somethiog releted to group membership as I see).

Error upgrading PostSystemInitUpgrade::OLAT_10.0.0 javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value : org.olat.basesecurity.model.GroupMembershipImpl.inheritanceModeString at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:708) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:688) at org.olat.upgrade.OLATUpgrade_10_0_0.processSecurityGroup(OLATUpgrade_10_0_0.java:573) at org.olat.upgrade.OLATUpgrade_10_0_0.processRepositoryEntry(OLATUpgrade_10_0_0.java:243) at org.olat.upgrade.OLATUpgrade_10_0_0.upgradeRepositoryEntries(OLATUpgrade_10_0_0.java:226) at org.olat.upgrade.OLATUpgrade_10_0_0.doPostSystemInitUpgrade(OLATUpgrade_10_0_0.java:123) at org.olat.upgrade.UpgradeManagerImpl$UpgradesTask.run(UpgradeManagerImpl.java:73) at org.olat.core.commons.services.taskexecutor.model.DBSecureRunnable.run(DBSecureRunnable.java:42) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.PropertyValueException: not-null property references a null or transient value : org.olat.basesecurity.model.GroupMembershipImpl.inheritanceModeString at org.hibernate.engine.internal.Nullability.checkNullability(Nullability.java:111) at org.hibernate.engine.internal.Nullability.checkNullability(Nullability.java:55) at org.hibernate.action.internal.AbstractEntityInsertAction.nullifyTransientReferencesIfNotAlready(AbstractEntityInsertAction.java:116) at org.hibernate.action.internal.AbstractEntityInsertAction.makeEntityManaged(AbstractEntityInsertAction.java:125) at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:289) at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:263) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:250) at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:343) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:292) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:198) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:140) at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:192) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:135) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:62) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:108) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:702) ... 12 more

W dniu czwartek, 26 marca 2020 20:02:50 UTC+1 użytkownik Tomek Kabziński napisał:

[Florian Gnaegi]

Hi 

I am not sure if you can upgrade from a 9.4 to a 14.2 in one step! There are many things in between. Try upgrading by installing the major releases, at least 10.x, then 11.x, then 12.x, then 13.x and then 14.x. You can probably skip 11 and 13, but I suggest at least installing the 10 before doing the other updates. No guarantee that this is the problem, but 9.4 is really so long ago, this is even before responsive design times…

Cheers

Florian

--
--
Sie erhalten diese Nachricht, weil Sie Mitglied sind von Google
Groups-Gruppe "OpenOlat".
Für das Erstellen von Beiträgen in dieser Gruppe senden Sie eine E-Mail
an open...@googlegroups.com
Um sich von dieser Gruppe abzumelden, senden Sie eine E-Mail an
openolat+u...@googlegroups.com
Weitere Optionen finden Sie in dieser Gruppe unter
http://groups.google.com/group/openolat?hl=de
-------------------------------------------------------------------------------------------------------------------
OpenOlat - infinite learning - http://www.openolat.org
---
You received this message because you are subscribed to the Google Groups "OpenOlat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openolat+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/openolat/94815b96-a985-47d1-bf7a-d3ac00ff2cda%40googlegroups.com.

[Tomek Kabziński]

Hi,

Managed to upgrade to 12.5.9 so far. System seems to work but find some errors during upgrade and later after restart. Please tell me if I can ignore this problems and proceed with upgrade to newest versions or must fix the problem now?

How to find if everything i OK?

14:53:44,204  WARN UpgradeManagerImpl:175 - OLAT::WARN ^%^ N1-W4 ^%^ org.olat.upgrade ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a ^%^ Error upgrading PostSystemInitUpgrade::OLAT_10.0.0 ^%^ >>>stack of 1.cause::javax.persistence.PersistenceException: org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of org.olat.portfolio.model.structel.EPStructureElement.key ->  at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423) at org.hibernate.query.Query.getResultList(Query.java:146) at org.olat.upgrade.OLATUpgrade_10_0_0.hasGroupsRelations(OLATUpgrade_10_0_0.java:442) at org.olat.upgrade.OLATUpgrade_10_0_0.processMap(OLATUpgrade_10_0_0.java:399) at org.olat.upgrade.OLATUpgrade_10_0_0.upgradeEPMap(OLATUpgrade_10_0_0.java:386) at org.olat.upgrade.OLATUpgrade_10_0_0.doPostSystemInitUpgrade(OLATUpgrade_10_0_0.java:126) at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:78) at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:204) at org.olat.core.util.event.AbstractEventBus$2.run(AbstractEventBus.java:171)>>>stack of 2.cause::org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of org.olat.portfolio.model.structel.EPStructureElement.key ->  at org.hibernate.property.access.spi.GetterMethodImpl.get(GetterMethodImpl.java:64) at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:224) at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:4734) at org.hibernate.type.EntityType.toLoggableString(EntityType.java:550) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:66) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:109) at org.hibernate.event.internal.AbstractFlushingEventListener.logFlushResults(AbstractFlushingEventListener.java:120) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:96) at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:44) at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1397) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1482)>>>stack of 3.cause::java.lang.IllegalArgumentException: java.lang.ClassCastException@2f4869c2 ->  at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.hibernate.property.access.spi.GetterMethodImpl.get(GetterMethodImpl.java:41) at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:224) at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:4734) at org.hibernate.type.EntityType.toLoggableString(EntityType.java:550) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:66) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:109) at org.hibernate.event.internal.AbstractFlushingEventListener.logFlushResults(AbstractFlushingEventListener.java:120) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:96)

14:53:44,205 ERROR ClusterEventBus:173 - OLAT::ERROR ^%^ N1-E1 ^%^ org.olat.commons.coordinate.cluster.jms ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a ^%^ Error while sending generic event: org.olat.upgrade.UpgradeManagerImpl@3b1f4489 ^%^ >>>stack of 1.cause::java.lang.RuntimeException: *** CRITICAL ERROR IN UPGRADE MANAGER. Loading aborted. ->  at org.olat.upgrade.UpgradeManager.abort(UpgradeManager.java:198) at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:86) at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:204) at org.olat.core.util.event.AbstractEventBus$2.run(AbstractEventBus.java:171) at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) at org.olat.core.util.event.AbstractEventBus.doFire(AbstractEventBus.java:168) at org.olat.core.util.event.AbstractEventBus.doFire(AbstractEventBus.java:141) at org.olat.commons.coordinate.cluster.jms.ClusterEventBus.serveMessage(ClusterEventBus.java:336) at org.olat.commons.coordinate.cluster.jms.ClusterEventBus.onMessage(ClusterEventBus.java:264) at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1394) at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:131)>>>stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of org.olat.portfolio.model.structel.EPStructureElement.key ->  at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423) at org.hibernate.query.Query.getResultList(Query.java:146) at org.olat.upgrade.OLATUpgrade_10_0_0.hasGroupsRelations(OLATUpgrade_10_0_0.java:442) at org.olat.upgrade.OLATUpgrade_10_0_0.processMap(OLATUpgrade_10_0_0.java:399) at org.olat.upgrade.OLATUpgrade_10_0_0.upgradeEPMap(OLATUpgrade_10_0_0.java:386) at org.olat.upgrade.OLATUpgrade_10_0_0.doPostSystemInitUpgrade(OLATUpgrade_10_0_0.java:126) at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:78) at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:204) at org.olat.core.util.event.AbstractEventBus$2.run(AbstractEventBus.java:171)>>>stack of 3.cause::org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of org.olat.portfolio.model.structel.EPStructureElement.key ->  at org.hibernate.property.access.spi.GetterMethodImpl.get(GetterMethodImpl.java:64) at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:224) at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:4734) at org.hibernate.type.EntityType.toLoggableString(EntityType.java:550) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:66) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:109) at org.hibernate.event.internal.AbstractFlushingEventListener.logFlushResults(AbstractFlushingEventListener.java:120) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:96) at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:44) at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1397) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1482)>>>stack of 4.cause::java.lang.IllegalArgumentException: java.lang.ClassCastException@2f4869c2 ->  at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.hibernate.property.access.spi.GetterMethodImpl.get(GetterMethodImpl.java:41) at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:224) at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:4734) at org.hibernate.type.EntityType.toLoggableString(EntityType.java:550) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:66) at org.hibernate.internal.util.EntityPrinter.toString(EntityPrinter.java:109) at org.hibernate.event.internal.AbstractFlushingEventListener.logFlushResults(AbstractFlushingEventListener.java:120) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:96)

W dniu czwartek, 26 marca 2020 20:02:50 UTC+1 użytkownik Tomek Kabziński napisał:

[Tomek Kabziński]

Now I see admin privileges  disappeared during upgrade from  12.5.9  to 13.1.2

W dniu czwartek, 26 marca 2020 20:02:50 UTC+1 użytkownik Tomek Kabziński napisał: