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 <solomax...@gmail.com>:
> 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 <
> josefs...@gmail.com> 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 <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
>>>
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>
