Hello Jose, I'm using this script all the time According to your error: 1) have you modified persistense.xml to use MySQL? (otherwise Derby DB will be used) 2) it seems like you DB user has no password, is it correct? 3) can you connect using "mysql" command line tool using following parameters: mysql -hlocalhost -umyadmin -P3306 openmeetings -p
On Wed, Feb 11, 2015 at 5:35 PM, José Fernando da Silva <[email protected] > wrote: > 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 [email protected] > -group mygroup -user myadmin --smtp-server smtp.gmail.com --smtp-port 587 > --db-type mysql --db-name openmeetings --email-auth-user > [email protected] --password mypass --drop no --system-email-address > [email protected] --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 > -- WBR Maxim aka solomax
