I would suggest to fill it little bit differently :) 1) configure system PATH so tools are accessible by default OR 2) configure it via web interface, create backup and then just "install with restore": ./admin.sh -i -file _name_here_ --drop
On Wed, Feb 11, 2015 at 6:20 PM, José Fernando da Silva <[email protected] > wrote: > 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 <[email protected]>: > >> 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 >> > > -- WBR Maxim aka solomax
