Dear Carlos,
Your issue could be resolved by the following steps.
(1). For MariaBD, use
"~webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml" to
connect to your DB.
(2). Just supply the IP / hostname of the remote server on which MariaDB is
running. Insert it in your database connection string, instead of localhost.
For example:
jdbc:mysql://192.168.15.25:3306/yourdatabase
Input in mysql_persistence.xml L71,
... value="DriverClassName=com.mysql.jdbc.Driver
, Url=jdbc:mysql://localhost:3306/ ...
(3). Open through firewall access to port 3306. Open the port in your OS and
firewall in your LAN between the server OM is in and your DB server.
(4). Configure MariaDB to allow remote connections, my.cnf file.
(5). GRANT appropriate permissions to that host and user in your MySQL schema
to connect from this particular hostname. For development environments it is
safe to do this by 'username'@'%'. Check the user creation manual and the GRANT
manual.
If the above steps do not work, perhaps you need container managed transactions
(JTA). Tomcat does not support container managed transactions at all. On
"plain" Tomcat, you'd need to install JTA separately.
Real Java EE containers such as Glassfish, JBoss AS and TomEE support JTA (and
JPA, EJB, JSF, etc.) out of the box.
Thank you.
Sincerely,
Hemant K. Sabat
Coscend Communications Solutions
Web site: www.Coscend.com
------------------------------------------------------------------
CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail Messages
from Coscend Communications Solutions' posted at:
http://www.Coscend.com/Terms_and_Conditions.html
-----Original Message-----
From: Carlos Cruz [mailto:[email protected]]
Sent: Friday, August 12, 2016 2:33 PM
To: [email protected]
Subject: RE: installing openmeetins on windows 10
Thanks for the input, I appreciate the help!!
I got that error when I was trying to install OpenMeetins with Derby after a
few unsuccessful tries installing with a remote MySQL (Actually MariaDB)
I deleted the installation and reinstalled OpenMeetings. I was able to
successfully install with Derby, but not with the MySQL install. So I have a
couple of questions:
The MySQL install fails because I'm using MariaDB (I use it with several
projects never an issue) ?
Or does the MySQL install fail because it's a remote Data Base ?
Thanks for the help!!!
Carlos
-----Original Message-----
From: Maxim Solodovnik [mailto:[email protected]]
Sent: Friday, August 12, 2016 2:13 PM
To: Openmeetings user-list <[email protected]>;
[email protected]
Subject: Re: installing openmeetins on windows 10
According to your error:
Schema 'CARLOS' does not exist
you haven't created database
On Sat, Aug 13, 2016 at 1:09 AM, Coscend@OM <[email protected]> wrote:
> Dear Carlos,
>
>
>
> Assuming you have not done any customization in DB, and navigation
> files of OM application, you might want to check your persistence.xml
> in “webapps/openmeetings/WEB-INF/classes/META-INF/” folder.
>
>
>
> Is it the right *.xml file, does it have the correct username, and
> correct password?
>
>
>
> Thank you.
>
>
>
> Sincerely,
>
>
>
> Hemant K. Sabat
>
>
>
> Coscend Communications Solutions
>
> Web site: www.Coscend.com
>
> ------------------------------------------------------------------
>
> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail
> Messages from Coscend Communications Solutions' posted at:
> http://www.Coscend.com/Terms_and_Conditions.html
>
>
>
> From: Carlos Cruz [mailto:[email protected]]
> Sent: Friday, August 12, 2016 8:14 AM
> To: [email protected]
> Subject: installing openmeetins on windows 10
>
>
>
> Can someone tell me why I get the error bellow during openmeeting setup?
>
>
>
> I have Java 1.7 JDK (7) installed.
>
>
>
> Thanks!
>
> Carlos
>
> Installation is failed
>
> 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
> error> transaction
> has been rolled back. See the nested exceptions for details on the
> errors that occurred.
>
> at
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccess
> ExceptionIfPossible(EntityManagerFactoryUtils.java:415)
>
> at
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPoss
> ible(DefaultJpaDialect.java:122)
>
> at
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransact
> ionManager.java:521)
>
> at
> org.springframework.transaction.support.AbstractPlatformTransactionMan
> ager.processCommit(AbstractPlatformTransactionManager.java:757)
>
> at
> org.springframework.transaction.support.AbstractPlatformTransactionMan
> ager.commit(AbstractPlatformTransactionManager.java:726)
>
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.c
> ommitTransactionAfterReturning(TransactionAspectSupport.java:521)
>
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.i
> nvokeWithinTransaction(TransactionAspectSupport.java:291)
>
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.inv
> oke(TransactionInterceptor.java:96)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R
> eflectiveMethodInvocation.java:179)
>
> at
> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedIntercep
> tor.intercept(CglibAopProxy.java:653)
>
> at
> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCG
> LIB$$481ea8e4.addGlobalStructure(<generated>)
>
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(Imp
> ortInitvalues.java:117)
>
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(Impor
> tInitvalues.java:607)
>
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportIn
> itvalues.java:626)
>
> at
> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess
> .run(InstallWizard.java:641)
>
> 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.
>
> 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(LocalManagedRunti
> me.java:81)
>
> at
> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
>
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.jav
> a:932)
>
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerI
> mpl.java:571)
>
> at
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransact
> ionManager.java:517)
>
> ... 13 more
>
> Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Schema 'CARLOS'
> does not exist {INSERT INTO naviglobal (action, comment, deleted,
> icon, inserted, isleaf, isopen, label_id, level_id, name, naviorder,
> tooltip_label_id,
> updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000,
> state=42Y07]
>
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003
> )
>
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionar
> y.java:4963)
>
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:
> 133)
>
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:
> 107)
>
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:
> 59)
>
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(Prep
> aredStatementManagerImpl.java:90)
>
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Constrain
> tUpdateManager.java:550)
>
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Constrain
> tUpdateManager.java:106)
>
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(B
> atchingConstraintUpdateManager.java:59)
>
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpd
> ateManager.java:104)
>
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpd
> ateManager.java:77)
>
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager
> .java:731)
>
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStore
> Manager.java:131)
>
> at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStor
> eManager.java:668)
>
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStore
> Manager.java:131)
>
> ... 21 more
>
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema
> 'CARLOS' does not exist {INSERT INTO naviglobal (action, comment,
> deleted, icon, inserted, isleaf, isopen, label_id, level_id, name,
> naviorder, tooltip_label_id, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?)} [code=20000, state=42Y07]
>
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCon
> nectionDecorator.java:218)
>
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCon
> nectionDecorator.java:198)
>
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(Logg
> ingConnectionDecorator.java:58)
>
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnecti
> on.prepareStatement(LoggingConnectionDecorator.java:250)
>
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(Dele
> gatingConnection.java:133)
>
> at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$Configuring
> Connection.prepareStatement(ConfiguringConnectionDecorator.java:139)
>
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(Dele
> gatingConnection.java:133)
>
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.pre
> pareStatement(JDBCStoreManager.java:1642)
>
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(Dele
> gatingConnection.java:122)
>
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareSta
> tement(PreparedStatementManagerImpl.java:290)
>
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUp
> date(PreparedStatementManagerImpl.java:113)
>
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.fl
> ushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
>
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInter
> nal(PreparedStatementManagerImpl.java:100)
>
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(Prep
> aredStatementManagerImpl.java:88)
>
> ... 30 more
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7752 / Virus Database: 4633/12797 - Release Date:
> 08/12/16
--
WBR
Maxim aka solomax
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7752 / Virus Database: 4633/12797 - Release Date: 08/12/16
