you don't have to add paths like /usr/bin and /usr/local/bin, just leave it empty and tools will be found automaticaly :)
On Wed, Feb 11, 2015 at 8:38 PM, José Fernando da Silva <[email protected] > wrote: > Thanks for the suggestion. But I prefer to use another approach because I > am using a script to install OM without manual intervention. So, I put this > code at the end of the script to customize it: > > Q1="USE ${OPENMEETINGS_DBNAME};" > Q2="UPDATE configuration SET conf_value='${NEW_APP_NAME}' WHERE conf_key=' > application.name';" > Q3="UPDATE configuration SET conf_value='/usr/local/bin' WHERE > conf_key='swftools_path';" > Q4="UPDATE configuration SET conf_value='/usr/bin' WHERE > conf_key='imagemagick_path';" > Q5="UPDATE configuration SET conf_value='/usr/bin' WHERE > conf_key='sox_path';" > Q6="UPDATE configuration SET conf_value='/usr/local/bin' WHERE > conf_key='ffmpeg_path';" > Q7="UPDATE configuration SET > conf_value='/usr/lib/red5/webapps/${NEW_CONTEXT_NAME}/jodconverter-core-${JODCONVERTER_VERSION}/lib' > WHERE conf_key='jod.path';" > SQL="${Q1}${Q2}${Q3}${Q4}${Q5}${Q6}${Q7}" > mysql --user="${MYSQL_ROOT_USER}" --password="${MYSQL_ROOT_PASS}" > --execute="$SQL" > > Jose Fernando > > 2015-02-11 10:23 GMT-02:00 Maxim Solodovnik <[email protected]>: > >> 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_ -- >> >> >> 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 >> > > -- WBR Maxim aka solomax
