Re: Upgrade Apache OpenMeetings to the latest version

2021-08-10 Thread Maxim Solodovnik 
"*/opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
(Permission denied)"*


The user who start backup/restore
Has no write permissions to OM folders 


from mobile (sorry for typos ;)


On Tue, Aug 10, 2021, 17:25 Aom Jeff Root  wrote:

> Hi,
> Here is the content of the openmeetings.service file (in /opt/open610/)
> *cat /opt/open610/openmeetings.service*
> *..*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *[Service]Type=forkingEnvironment=JAVA_HOME=/usr/lib/jvm/java-11-openjdk-amd64Environment=CATALINA_PID=/var/run/openmeetings.pidWorkingDirectory=/opt/openmeetingsEnvironment=CATALINA_HOME=/opt/openmeetingsEnvironment=CATALINA_BASE=/opt/openmeetingsEnvironment='JDK_JAVA_OPTIONS=--add-modules
> java.se  --add-exports
> java.base/jdk.internal.ref=ALL-UNNAMED --add-opens
> java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.nio=ALL-UNNAMED
> --add-opens java.base/sun.nio.ch =ALL-UNNAMED
> --add-opens java.management/sun.management=ALL-UNNAMED --add-opens
> jdk.management/com.sun.management.internal=ALL-UNNAMED'Environment='CATALINA_OPTS=-Xms1G
> -Xmx4G -server
> -XX:+UseParallelGC'Environment='JAVA_OPTS=-Djava.awt.headless=true
> -Djava.security.egd=file:/dev/./urandom'ExecStart=/opt/openmeetings/bin/startup.shExecStop=/opt/openmeetings/bin/shutdown.shUser=nobodyGroup=nogroupUMask=0007RestartSec=10Restart=always*
> *.*
>
> Here is the ful result of
> *./admin.sh -i -file ~/omBackup.zip --db-type mysql --db-host localhost
> --db-user userGranted --db-pass userGrantedPass --db-name open610*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *10:18:20.703 [main] INFO org.apache.openmeetings.util.OmFileHelper -
> Using file locations - omHome: /opt/open610/webapps/openmeetings DATA_DIR:
> /opt/open610/webapps/openmeetings/data10:18:20.841 [main] ERROR
> org.apache.openmeetings.cli.Admin - Unexpected
> errorjavax.xml.transform.TransformerException:
> java.io.FileNotFoundException:
> /opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> (Permission denied)at
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:554)
>   at
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:367)
>   at
> org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:112)
>   at
> org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:121)
>   at org.apache.openmeetings.cli.Admin.processInstall(Admin.java:324)
>   at org.apache.openmeetings.cli.Admin.process(Admin.java:259)
> at org.apache.openmeetings.cli.Admin.main(Admin.java:563)Caused by:
> java.io.FileNotFoundException:
> /opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> (Permission denied)at
> java.base/java.io.FileOutputStream.open0(Native Method)at
> java.base/java.io.FileOutputStream.open(FileOutputStream.java:291)
> at java.base/java.io.FileOutputStream.(FileOutputStream.java:234)
> at
> java.base/java.io.FileOutputStream.(FileOutputStream.java:184)
> at
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:539)
>   ... 6 common frames omittedjavax.xml.transform.TransformerException:
> java.io.FileNotFoundException:
> /opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> (Permission denied)at
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:554)
>   at
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:367)
>   at
> org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:112)
>   at
> org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:121)
>   at org.apache.openmeetings.cli.Admin.processInstall(Admin.java:324)
>   at org.apache.openmeetings.cli.Admin.process(Admin.java:259)
> at org.apache.openmeetings.cli.Admin.main(Admin.java:563)Caused by:
> java.io.FileNotFoundException:
> /opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> (Permission denied)at
> java.base/java.io.FileOutputStream.open0(Native Method)at
> java.base/java.io.FileOutputStream.open(FileOutputStream.java:291)
> at java.base/java.io.FileOutputStream.(FileOutputStream.java:234)
> at
> java.base/java.io.FileOutputStream.(FileOutputStream.java:184)
> at
> java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:539)
>   ... 6 more-java.io.FileNotFoundException:
> /opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> (Permission denied)at
>

Re: Upgrade Apache OpenMeetings to the latest version

2021-08-10 Thread Aom Jeff Root 
Hi,
Here is the content of the openmeetings.service file (in /opt/open610/)
*cat /opt/open610/openmeetings.service*
*..*



















*[Service]Type=forkingEnvironment=JAVA_HOME=/usr/lib/jvm/java-11-openjdk-amd64Environment=CATALINA_PID=/var/run/openmeetings.pidWorkingDirectory=/opt/openmeetingsEnvironment=CATALINA_HOME=/opt/openmeetingsEnvironment=CATALINA_BASE=/opt/openmeetingsEnvironment='JDK_JAVA_OPTIONS=--add-modules
java.se  --add-exports
java.base/jdk.internal.ref=ALL-UNNAMED --add-opens
java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.nio=ALL-UNNAMED
--add-opens java.base/sun.nio.ch =ALL-UNNAMED
--add-opens java.management/sun.management=ALL-UNNAMED --add-opens
jdk.management/com.sun.management.internal=ALL-UNNAMED'Environment='CATALINA_OPTS=-Xms1G
-Xmx4G -server
-XX:+UseParallelGC'Environment='JAVA_OPTS=-Djava.awt.headless=true
-Djava.security.egd=file:/dev/./urandom'ExecStart=/opt/openmeetings/bin/startup.shExecStop=/opt/openmeetings/bin/shutdown.shUser=nobodyGroup=nogroupUMask=0007RestartSec=10Restart=always*
*.*

Here is the ful result of
*./admin.sh -i -file ~/omBackup.zip --db-type mysql --db-host localhost
--db-user userGranted --db-pass userGrantedPass --db-name open610*














































*10:18:20.703 [main] INFO org.apache.openmeetings.util.OmFileHelper - Using
file locations - omHome: /opt/open610/webapps/openmeetings DATA_DIR:
/opt/open610/webapps/openmeetings/data10:18:20.841 [main] ERROR
org.apache.openmeetings.cli.Admin - Unexpected
errorjavax.xml.transform.TransformerException:
java.io.FileNotFoundException:
/opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
(Permission denied)at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:554)
  at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:367)
  at
org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:112)
  at
org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:121)
  at org.apache.openmeetings.cli.Admin.processInstall(Admin.java:324)
  at org.apache.openmeetings.cli.Admin.process(Admin.java:259)
at org.apache.openmeetings.cli.Admin.main(Admin.java:563)Caused by:
java.io.FileNotFoundException:
/opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
(Permission denied)at
java.base/java.io.FileOutputStream.open0(Native Method)at
java.base/java.io.FileOutputStream.open(FileOutputStream.java:291)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:234)
at
java.base/java.io.FileOutputStream.(FileOutputStream.java:184)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:539)
  ... 6 common frames omittedjavax.xml.transform.TransformerException:
java.io.FileNotFoundException:
/opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
(Permission denied)at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:554)
  at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:367)
  at
org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:112)
  at
org.apache.openmeetings.cli.ConnectionPropertiesPatcher.patch(ConnectionPropertiesPatcher.java:121)
  at org.apache.openmeetings.cli.Admin.processInstall(Admin.java:324)
  at org.apache.openmeetings.cli.Admin.process(Admin.java:259)
at org.apache.openmeetings.cli.Admin.main(Admin.java:563)Caused by:
java.io.FileNotFoundException:
/opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
(Permission denied)at
java.base/java.io.FileOutputStream.open0(Native Method)at
java.base/java.io.FileOutputStream.open(FileOutputStream.java:291)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:234)
at
java.base/java.io.FileOutputStream.(FileOutputStream.java:184)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:539)
  ... 6 more-java.io.FileNotFoundException:
/opt/open610/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
(Permission denied)at
java.base/java.io.FileOutputStream.open0(Native Method)at
java.base/java.io.FileOutputStream.open(FileOutputStream.java:291)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:234)
at
java.base/java.io.FileOutputStream.(FileOutputStream.java:184)
at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutputHandler(TransformerImpl.java:539)
  at
java.xml/com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:367)
  at

Re: Upgrade Apache OpenMeetings to the latest version

2021-08-10 Thread Maxim Solodovnik 
In such case please provide

1 result of telten command
Full stack trace with the error :)

from mobile (sorry for typos ;)


On Tue, Aug 10, 2021, 16:18 Aom Jeff Root  wrote:

> Hello,
>
> Of course, MySQL listens on port 3306.
>
> Best regards.
>

Re: Upgrade Apache OpenMeetings to the latest version

2021-08-09 Thread Maxim Solodovnik 
Hello Jeffrey,

your question is definitely NOT for security@ list :))
Please send your questions and follow-ups to user@ list

Your error "ConnectException: Connection refused"
states there is NO MySql listening on port 3306

I would recommend to ensure MySql is accessible via TCP :)

On Mon, 9 Aug 2021 at 21:30, Aom Jeff Root  wrote:

> Hi,
> I run OM 5.0.1 on ubuntu18.04 LTS. I want to upgrade the version to latest
> 6.1.0 .
>
> I have tomcat3 in /etc/init.d/, mysql connector in
> /opt/aom610/webapps/openmeetings/WEB-INF/lib
>
> all instructions for the upgrade are runed; but i have some error when I
> arrive at this command.
>
> ./admin.sh -i -file ~/omBackup.zip --db-type mysql --db-host localhost
> --db-user userGranted --db-pass userGranterPass --db-name open610
>
> Caused by: java.net.ConnectException: Connection refused at
> java.base/sun.nio.ch.Net.connect0(Native Method) at
> java.base/sun.nio.ch.Net.connect(Net.java:503) at
> java.base/sun.nio.ch.Net.connect(Net.java:492) at
> java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:588)
> at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:333)
> at java.base/java.net.Socket.connect(Socket.java:648) at
> com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
> at
> com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
> ... 55 more
>
> What can be the cause of this, how can i fix it and made the upgrade ?
>
> Jeffrey, student in computer science Sys/Admin
>
> Best regards.
>


-- 
Best regards,
Maxim