You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by José Fernando da Silva <jo...@gmail.com> on 2015/02/11 12:35:30 UTC
Installing OM using admin.sh
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 myemail@gmail.com -group
mygroup -user myadmin --smtp-server smtp.gmail.com --smtp-port 587
--db-type mysql --db-name openmeetings --email-auth-user
otheremail@gmail.com --password mypass --drop no --system-email-address
noreply@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
Re: Installing OM using admin.sh
Posted by Maxim Solodovnik <so...@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 <josefsmvm@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 myemail@gmail.com
> -group mygroup -user myadmin --smtp-server smtp.gmail.com --smtp-port 587
> --db-type mysql --db-name openmeetings --email-auth-user
> otheremail@gmail.com --password mypass --drop no --system-email-address
> noreply@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