Hello Horace, On Tue, 31 Dec 2024 at 09:59, Horace Miles <horace.mi...@gmail.com> wrote: > > Hi Maxim, > Thanks for you help, I got openmeetings to load successfully. > I do have a couple of problems and I need to know if you have any suggestions. > 1. The user accounts are not lining up. > 2. RoomID aren't lining up > 3. GroupID dont line up. > > It seems openmeeting installer is asking for a default account to act as an > administrator. Even if I use the same account, it creates the account, but > the importer also imports all the accounts so the User ID's seem to get > assigned new UserID's, which makes them not line up with the correct room.
I would say you have several options here :)) - you can try to use your previous DB "as is" (lots of chances it will work :))) - you can use "Command line installer" [1] it has `--skip-default-objects` option to skip createion of default users/groups etc. - you can use "Command line installer" [1] with `-file your_backup.zip` options: this will not create default objects as well > > 4. My backup file is 29.6 GB. I change the make file upload size to > accommodate that and the importer did not complain. > > My issue issue is default rooms are being created and then the importer is > also importing them from the backup and so I should have approx 70 rooms but > instead I end up with about 99. > > This throws group membership off and then the groups off so member accounts > are not related to the correct room and no files that were uploaded can be > found. the above shouldn't happen :( while importing users/groups/rooms/files are being created and ownership should be transferred to new IDs (I'll try to create test for this, could you please file JIRA so it will be in my TODO list :)) > > Do you have any suggestion as to how I can get around this? > I am thinking I have to after signing into the om, I need to delete all > accounts and rooms. Then do the the import. > > What are your thoughts? [1] https://openmeetings.apache.org/CommandLineAdmin.html > > Miles > > > On Sun, Dec 29, 2024 at 10:57 PM Horace Miles <horace.mi...@gmail.com> wrote: >> >> Thanks will do. >> >> On Sun, Dec 29, 2024 at 10:14 PM Maxim Solodovnik <solomax...@gmail.com> >> wrote: >>> >>> Hello Horace :) >>> >>> On Mon, 30 Dec 2024 at 11:30, Horace Miles <horace.mi...@gmail.com> wrote: >>> > >>> > Hello Maximum, >>> > I tried to send this to user@openmeetings.apache.org but it bounced. I >>> > may have been purged from the subscriber list. >>> >>> I've added CC to user@ list :) >>> >>> > >>> > I finally have some time and I am trying to upgrade from OM 6.1.0 to OM >>> > 7.2.0. >>> > I have not been able to get a proper environment to work to do any >>> > programing yet. >>> > Here is my current configuration: >>> > user@meetings:/opt/open720/bin/logs# java -version >>> > openjdk version "17.0.7" 2023-04-18 >>> > OpenJDK Runtime Environment (build 17.0.7+7-Ubuntu-0ubuntu118.04) >>> > OpenJDK 64-Bit Server VM (build 17.0.7+7-Ubuntu-0ubuntu118.04, mixed >>> > mode, sharing) >>> > user@meetings:/opt/open720/bin/logs# cat /etc/os-release >>> > NAME="Ubuntu" >>> > VERSION="18.04.6 LTS (Bionic Beaver)" >>> > ID=ubuntu >>> > ID_LIKE=debian >>> > PRETTY_NAME="Ubuntu 18.04.6 LTS" >>> > VERSION_ID="18.04" >>> > VERSION_CODENAME=bionic >>> > UBUNTU_CODENAME=bionic >>> > >>> > Steps I have done: >>> > >>> > Stop Openmeetings >>> > (*) Backup folder with existing installation >>> > (*) Perform DB backup using tools available for your database >>> > mv open700 to open700.old >>> > Drop existing OM database >>> > Create empty Database with same name and UTF-8 support >>> > Unzip new version to open720 >>> > Copied the following files from open700 to open720: >>> > >>> > /opt/open700/webapps/openmeetings/WEB-INF/classes/openmeetings.properties/ >>> > opt/open700/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml >>> > /opt/open700/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml >>> >>> These files should be **merged** NOT **copied** :((( >>> The error below: >>> "Could not resolve placeholder 'otp.issuer' in value "${otp.issuer}"" >>> >>> Caused by the fact **new** values are missing from >>> `openmeetings.properties` file >>> You can compare your current file and the file shipped with OM using >>> your favorite visual diff tool (vim, Meld, WinMerge :))) >>> >>> I would recommend to use visual diff tool for all 3 files above >>> instead of copying :) >>> >>> > /opt/open700/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-8.0.29.jar >>> > /opt/open700/conf/glorytoyah.org.jks/opt/open700/conf/meetings.glorytoyah.org.jks >>> > /opt/open700/conf/logging.properties/opt/open700/conf/server.xml/opt/open700/conf/web.xml >>> > >>> > Updated Catalina home to /opt/open720 in tomcat4 file and >>> > openmeetings.service file >>> > >>> > Start Openmeetings >>> > go to https://localhost:5443/openmeetings >>> > >>> > I am getting the following error when starting openmeetings >>> > ERROR 12-29 19:17:11.376 o.s.w.c.ContextLoader:299 [main] - Context >>> > initialization failed >>> > org.springframework.beans.factory.BeanCreationException: Error creating >>> > bean with name 'otpManager': Injection of autowired dependencies failed; >>> > nested exception is java.lang.IllegalArgumentException: Could not resolve >>> > placeholder 'otp.issuer' in value "${otp.issuer}" >>> > >>> > Here is the complete Openmeetings log file that is generated: >>> > INFO 12-29 19:17:08.557 o.s.w.c.ContextLoader:257 [main] - Root >>> > WebApplicationContext: initialization started >>> > INFO 12-29 19:17:10.291 o.s.o.j.LocalEntityManagerFactoryBean:437 [main] >>> > - Initialized JPA EntityManagerFactory for persistence unit 'openmeetings' >>> > DEBUG 12-29 19:17:11.107 o.a.o.m.KurentoHandler:144 [pool-1-thread-1] - >>> > Reconnecting KMS >>> > INFO 12-29 19:17:11.168 o.k.j.c.JsonRpcClientNettyWebSocket:191 >>> > [pool-1-thread-1] - Connecting native client >>> > INFO 12-29 19:17:11.171 o.k.j.c.JsonRpcClientNettyWebSocket:220 >>> > [pool-1-thread-1] - Creating new NioEventLoopGroup >>> > WARN 12-29 19:17:11.366 o.s.w.c.s.XmlWebApplicationContext:599 [main] - >>> > Exception encountered during context initialization - cancelling refresh >>> > attempt: org.springframework.beans.factory.BeanCreationException: Error >>> > creating bean with name 'otpManager': Injection of autowired dependencies >>> > failed; nested exception is java.lang.IllegalArgumentException: Could not >>> > resolve placeholder 'otp.issuer' in value "${otp.issuer}" >>> > INFO 12-29 19:17:11.369 o.s.o.j.LocalEntityManagerFactoryBean:651 [main] >>> > - Closing JPA EntityManagerFactory for persistence unit 'openmeetings' >>> > ERROR 12-29 19:17:11.376 o.s.w.c.ContextLoader:299 [main] - Context >>> > initialization failed >>> > org.springframework.beans.factory.BeanCreationException: Error creating >>> > bean with name 'otpManager': Injection of autowired dependencies failed; >>> > nested exception is java.lang.IllegalArgumentException: Could not resolve >>> > placeholder 'otp.issuer' in value "${otp.issuer}" >>> > at >>> > org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:414) >>> > at >>> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) >>> > at >>> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) >>> > at >>> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) >>> > at >>> > org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) >>> > at >>> > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) >>> > at >>> > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) >>> > at >>> > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) >>> > at >>> > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) >>> > at >>> > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:929) >>> > at >>> > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591) >>> > at >>> > org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:399) >>> > at >>> > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:278) >>> > at >>> > org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103) >>> > at >>> > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4462) >>> > at >>> > org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4914) >>> > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) >>> > at >>> > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683) >>> > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658) >>> > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:661) >>> > at >>> > org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1186) >>> > at >>> > org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1941) >>> > at >>> > java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) >>> > at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) >>> > at >>> > org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) >>> > at >>> > java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123) >>> > at >>> > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1096) >>> > at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:478) >>> > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1619) >>> > at >>> > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:318) >>> > at >>> > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:114) >>> > at >>> > org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402) >>> > at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:345) >>> > at >>> > org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:893) >>> > at >>> > org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:794) >>> > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) >>> > at >>> > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) >>> > at >>> > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) >>> > at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) >>> > at >>> > org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) >>> > at >>> > java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) >>> > at >>> > org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) >>> > at >>> > org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:248) >>> > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) >>> > at >>> > org.apache.catalina.core.StandardService.startInternal(StandardService.java:433) >>> > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) >>> > at >>> > org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:921) >>> > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) >>> > at org.apache.catalina.startup.Catalina.start(Catalina.java:772) >>> > at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native >>> > Method) >>> > at >>> > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) >>> > at >>> > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> > at java.base/java.lang.reflect.Method.invoke(Method.java:568) >>> > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:347) >>> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478) >>> > Caused by: java.lang.IllegalArgumentException: Could not resolve >>> > placeholder 'otp.issuer' in value "${otp.issuer}" >>> > at >>> > org.springframework.util.PropertyPlaceholderHelper.parseStringValue(PropertyPlaceholderHelper.java:180) >>> > at >>> > org.springframework.util.PropertyPlaceholderHelper.replacePlaceholders(PropertyPlaceholderHelper.java:126) >>> > at >>> > org.springframework.beans.factory.config.PropertyPlaceholderConfigurer$PlaceholderResolvingStringValueResolver.resolveStringValue(PropertyPlaceholderConfigurer.java:230) >>> > at >>> > org.springframework.beans.factory.support.AbstractBeanFactory.resolveEmbeddedValue(AbstractBeanFactory.java:936) >>> > at >>> > org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1332) >>> > at >>> > org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) >>> > at >>> > org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:710) >>> > at >>> > org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:693) >>> > at >>> > org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) >>> > at >>> > org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:408) >>> > ... 54 common frames omitted >>> > INFO 12-29 19:17:11.438 o.k.j.c.JsonRpcClientNettyWebSocket:191 >>> > [rbeatExec-e1-t0] - Connecting native client >>> > >>> > -- >>> > Horace Miles Jr >>> > Ga 6:3 For if a man think himself to be something, when he is nothing, >>> > he deceiveth himself. >>> >>> >>> >>> -- >>> Best regards, >>> Maxim >> >> >> >> -- >> Horace Miles Jr >> Ga 6:3 For if a man think himself to be something, when he is nothing, he >> deceiveth himself. > > > > -- > Horace Miles Jr > Ga 6:3 For if a man think himself to be something, when he is nothing, he > deceiveth himself. -- Best regards, Maxim
