Hi Maxim, Have you tested installing OM using admin.sh ? When I try to use the script I receive an OpenJPA error informing that it can not connect to the database. When I try to install using the web interface everything goes right.
I am calling admin.sh as below: cd /usr/lib/red5 sudo ./admin.sh -i -v -tz America/Sao_Paulo -email myem...@gmail.com -group mygroup -user myadmin --smtp-server smtp.gmail.com --smtp-port 587 --db-type mysql --db-name openmeetings --email-auth-user otherem...@gmail.com --password mypass --drop no --system-email-address nore...@gmail.com --db-user myadmin --db-host localhost --db-port 3306 --email-auth-pass mypass --email-use-tls yes The error that I receive is: INFO [main] openjpa.Runtime - Starting OpenJPA 2.3.0 [ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.3.0-r422266:1540826 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:430) ~[spring-orm-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:420) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:257) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) ~[spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) ~[spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$6f9d1a2f.getConfValue(<generated>) ~[spring-core-4.0.6.RELEASE.jar:na] at org.apache.openmeetings.db.util.UserHelper.getMinPasswdLength(UserHelper.java:34) ~[openmeetings-db-3.0.3-RELEASE.jar:na] at org.apache.openmeetings.db.util.UserHelper.invalidPassword(UserHelper.java:38) ~[openmeetings-db-3.0.3-RELEASE.jar:na] at org.apache.openmeetings.cli.Admin.checkAdminDetails(Admin.java:545) [openmeetings-cli-3.0.3-RELEASE.jar:na] at org.apache.openmeetings.cli.Admin.process(Admin.java:276) [openmeetings-cli-3.0.3-RELEASE.jar:na] at org.apache.openmeetings.cli.Admin.main(Admin.java:649) [openmeetings-cli-3.0.3-RELEASE.jar:na] Caused by: org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:107) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:535) ~[openjpa-lib-jar-2.3.0.jar:2.3.0] at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:460) ~[openjpa-lib-jar-2.3.0.jar:2.3.0] at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:121) ~[openjpa-lib-jar-2.3.0.jar:2.3.0] at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) ~[openjpa-lib-jar-2.3.0.jar:2.3.0] at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:967) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:958) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:643) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:155) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:226) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:153) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:59) ~[openjpa-bundle-2.3.0.jar:2.3.0] at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:448) ~[spring-orm-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:369) ~[spring-orm-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE] ... 12 common frames omitted Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) Thanks, Jose Fernando
