My fault Maxim, I forgot to put --db-pass in command line. Now, it works. Thanks so much for your help.
By the way, is it possible to fill swftools_path, imagemagik_path, sox_path, ffmeg_path, office.path and jod.path using the admin.sh script ? Regards, Jose Fernando. 2015-02-11 9:42 GMT-02:00 Maxim Solodovnik <solomax...@gmail.com>: > 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 < > josefs...@gmail.com> 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 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 >> > > > > -- > WBR > Maxim aka solomax >
