It is using derby unless you have reconfigured it to use another DB. On Thu, Aug 2, 2012 at 8:31 PM, Mukesh Reddy <muk...@ustechsolutions.com>wrote:
> Maxim,**** > > Why it is not using apache derby like previous versions/revisions?**** > > ** ** > > *From:* Mukesh Reddy [mailto:muk...@ustechsolutions.com] > *Sent:* Thursday, August 02, 2012 6:44 PM > *To:* openmeetings-user@incubator.apache.org > *Subject:* RE: install problem**** > > ** ** > > Maxim,**** > > still same error, I edited my.ini followed ur instructions but again > getting same error**** > > ** ** > > *From:* Maxim Solodovnik [mailto:solomax...@gmail.com] > *Sent:* Thursday, August 02, 2012 5:18 PM > *To:* openmeetings-user@incubator.apache.org > *Subject:* Re: install problem**** > > ** ** > > yes you can edit this file and restart MySQL**** > > OR**** > > drop your DB**** > > and create it as follows:**** > > CREATE DATABASE openmeetings DEFAULT CHARACTER SET utf8 COLLATE > utf8_general_ci;**** > > On Thu, Aug 2, 2012 at 5:37 PM, Mukesh Reddy <muk...@ustechsolutions.com> > wrote:**** > > Maxim,**** > > **** > > Means I have to edit this one? Right**** > > **** > > **** > > *From:* Maxim Solodovnik [mailto:solomax...@gmail.com] > *Sent:* Thursday, August 02, 2012 3:33 PM > *To:* openmeetings-user@incubator.apache.org > *Subject:* Re: install problem**** > > **** > > According to this:**** > > Caused by: org.apache.openjpa.persistence.PersistenceException: Incorrect > string**** > > value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1 {prepstmnt > 130**** > > 9484384 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, > language_id,**** > > starttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, > ?, ?**** > > ]} [code=1366, state=HY000]**** > > your DB is not UTF-8.**** > > Please recreate database and/or change your DB configuration to be unicode > compatible**** > > **** > > **** > > **** > > On Thu, Aug 2, 2012 at 4:55 PM, Mukesh Reddy <muk...@ustechsolutions.com> > wrote:**** > > Maxim,**** > > Can you explain me more in detail what I have to change in > persistence.xml, I attached my log here.**** > > Please find the attached text file..**** > > **** > > *Thanks and Regards,***** > > *Mukesh Reddy,***** > > *US TECH SOLUTIONS. Inc.***** > > **** > > **** > > *From:* Maxim Solodovnik [mailto:solomax...@gmail.com] > *Sent:* Thursday, August 02, 2012 10:02 AM > *To:* openmeetings-user@incubator.apache.org > *Subject:* Re: install problem**** > > **** > > /opt/red5/webapps/openmeetings/conf/hibernate.cfg.xml **** > > was removed from our sources**** > > to edit DB settings you need to edit > /opt/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml** > ** > > On Thu, Aug 2, 2012 at 2:16 AM, Alexei Fedotov <alexei.fedo...@gmail.com> > wrote:**** > > Please check the last exception > You should delete didectory**** > > 01.08.2012 16:35 пользователь "Claudio" <csaccav...@consorzioarsenal.it> > написал:**** > > **** > > Hi,**** > > I try to install the last version on an Ubuntu server 10.04, but I cannot > find this file (sudo nano /opt/red5/webapps/openmeetings/conf/hibernate. > cfg.xml**** > > )**** > > that is request to modify into the install guideline …**** > > **** > > So If I try to run red5.sh I have this error :**** > > **** > > ERROR 08-01 14:26:39.661 ScopeApplicationAdapter.java 3292 156 > org.openmeetings.app.remote.red5.ScopeApplicationAdapter > [Launcher:/openmeetings] - [appStart]**** > > org.springframework.transaction.CannotCreateTransactionException: Could > not open JPA EntityManager for transaction; nested exception is > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (Failed to create database 'openmeetings', see > the next exception for details.)**** > > at > org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427) > ~[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) > ~[org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) > ~[org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) > ~[org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > ~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) > ~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.openmeetings.app.data.basic.Configurationmanagement$$EnhancerByCGLIB$$421e4ca2.getConfKey(<generated>) > ~[com.springsource.net.sf.cglib-2.2.0.jar:na]**** > > at > org.openmeetings.app.remote.red5.ScopeApplicationAdapter.appStart(ScopeApplicationAdapter.java:124) > ~[openmeetings-2.1.0-SNAPSHOT.jar:na]**** > > at > org.red5.server.adapter.MultiThreadedApplicationAdapter.start(MultiThreadedApplicationAdapter.java:403) > [red5.jar:na]**** > > at org.red5.server.scope.Scope.start(Scope.java:1081) [red5.jar:na]**** > > at org.red5.server.scope.Scope.init(Scope.java:864) [red5.jar:na]**** > > at org.red5.server.scope.WebScope.register(WebScope.java:213) [red5.jar:na] > **** > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > ~[na:1.6.0_26]**** > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > ~[na:1.6.0_26]**** > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > ~[na:1.6.0_26]**** > > at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_26]**** > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1581) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1522) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) > [spring-beans-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913) > [spring-context-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464) > [spring-context-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at org.red5.server.tomcat.TomcatLoader$1.run(TomcatLoader.java:593) > [tomcatplugin-1.3.jar:na]**** > > Caused by: org.apache.openjpa.persistence.PersistenceException: Cannot > create PoolableConnectionFactory (Failed to create database 'openmeetings', > see the next exception for details.)**** > > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:968) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:959) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:445) > ~[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > at > org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:366) > ~[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]**** > > ... 28 common frames omitted**** > > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Failed to create database 'openmeetings', see > the next exception for details.)**** > > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > at > org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) > ~[openjpa-bundle-2.2.0.jar:2.2.0]**** > > ... 45 common frames omitted**** > > Caused by: java.sql.SQLException: Failed to create database > 'openmeetings', see the next exception for details.**** > > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ~[commons-dbcp-jar-1.4.jar:1.4]**** > > ... 50 common frames omitted**** > > Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Failed to create > database 'openmeetings', see the next exception for details.**** > > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > ... 64 common frames omitted**** > > Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: The database > directory '/opt/red5/openmeetings' exists. However, it does not contain the > expected 'service.properties' file. Perhaps Derby was brought down in the > middle of creating this database. You may want to delete this directory and > try creating the database again.**** > > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > ... 61 common frames omitted**** > > Caused by: org.apache.derby.iapi.error.StandardException: The database > directory '/opt/red5/openmeetings' exists. However, it does not contain the > expected 'service.properties' file. Perhaps Derby was brought down in the > middle of creating this database. You may want to delete this directory and > try creating the database again.**** > > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.services.monitor.StorageFactoryService.access$600(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at java.security.AccessController.doPrivileged(Native Method) > ~[na:1.6.0_26]**** > > at > org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > at > org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown > Source) ~[derby-jar-10.8.2.2.jar:na]**** > > ... 61 common frames omitted**** > > **** > > **** > > Thaks for help**** > > **** > > **** > > **** > > Claudio Saccavini**** > > CIO**** > > Arsenàl.IT - Veneto's Research Centre for e-Health Innovation**** > > Viale Oberdan 5 - 31100 Treviso**** > > **** > > csaccav...@consorzioarsenal.it**** > > +39 345 2623774**** > > **** > > **** > > > > **** > > **** > > -- > WBR > Maxim aka solomax**** > > > > **** > > **** > > -- > WBR > Maxim aka solomax**** > > > > **** > > ** ** > > -- > WBR > Maxim aka solomax**** > -- WBR Maxim aka solomax
