The sql directory patched version must replace the one in deploy/nuxeo.ear/system
Tiry Le 17 oct. 2010 10:34, "Joseph John" <[email protected]> a écrit : > HI Russel > My file location are > "ojdbc14.jar" > > /opt/nuxeo-dm-5.3.2/server/default/lib/ojdbc14.jar > > and for "nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar" I kept it in > a different places,Since I was not sure of JBOSS lib directorry > > /opt/nuxeo-dm-5.3.2/lib/nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar > /opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/system/nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar > /opt/nuxeo-dm-5.3.2/server/default/lib/nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar > > I have checked my databases it is up and running > Thanks > > > > On Sun, Oct 17, 2010 at 10:23 AM, Alexandre Russel <[email protected]> wrote: >> where did you put the oracle driver ? >> >> On 17 October 2010 07:08, Joseph John <[email protected]> wrote: >>> >>> Hi Thierry >>> Thanks for the mail, I had gone through the link >>> "https://jira.nuxeo.org/browse/NXP-5795"; >>> did the changes in "hibernate.properties" and in "nuxeo.properties" >>> (in the templates) . >>> Downloaded the file "nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar " >>> kept in the directory >>> "/opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/system/" >>> restarted the system. I am still getting the error on "stderr.log" as >>> soon as I access the url to nuxeo >>> I have cut and pasted the error message >>> "2010-10-15 21:30:16,567 ERROR [STDERR] java.lang.RuntimeException: >>> java.lang.RuntimeException: Unkown user directory userDirectory >>> 2010-10-15 21:30:16,568 ERROR [STDERR] at >>> >>> org.jboss.ejb3.interceptor.LifecycleInterceptorHandler.postConstruct(LifecycleInterceptorHandler.java:113) >>> 2010-10-15 21:30:16,568 ERROR [STDERR] at >>> org.jboss.ejb3.EJBContainer.invokePostConstruct(EJBContainer.java:623) >>> 2010-10-15 21:30:16,568 ERROR [STDERR] at >>> org.jboss.ejb3.AbstractPool.create(AbstractPool.java:131) >>> 2010-10-15 21:30:16,568 ERROR [STDERR] at >>> org.jboss.ejb3.InfinitePool.get(InfinitePool.java:49) >>> . >>> . >>> 2010-10-15 21:30:16,572 ERROR [STDERR] Caused by: >>> org.nuxeo.ecm.directory.DirectoryException: >>> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain >>> a connection >>> 2010-10-15 21:30:16,573 ERROR [STDERR] at >>> >>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:52) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] at >>> >>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getSchema(SQLDirectoryProxy.java:67) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] at >>> >>> org.nuxeo.ecm.directory.DirectoryServiceImpl.getDirectorySchema(DirectoryServiceImpl.java:154) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] at >>> >>> org.nuxeo.ecm.platform.usermanager.UserManagerImpl.setUserDirectoryName(UserManagerImpl.java:181) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] ... 61 more >>> 2010-10-15 21:30:16,573 ERROR [STDERR] Caused by: >>> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain >>> a connection >>> . >>> . >>> 2010-10-15 21:30:16,573 ERROR [STDERR] Caused by: >>> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> org.jboss.util.NestedSQLException. message: Could not create >>> connection; - nested throwable: >>> (org.jboss.resource.JBossResourceException: Failed to register driver >>> for: oracle.jdbc.driver.OracleDriver; - nested throwable: >>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)); >>> - nested throwable: (org.jboss.resource.JBossResourceException: Could >>> not create connection; - nested throwable: >>> (org.jboss.resource.JBossResourceException: Failed to register driver >>> for: oracle.jdbc.driver.OracleDriver; - nested throwable: >>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver))) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] at >>> >>> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] at >>> >>> org.nuxeo.ecm.directory.sql.SQLDirectory.getConnection(SQLDirectory.java:214) >>> 2010-10-15 21:30:16,573 ERROR [STDERR] ... 67 more >>> 2010-10-15 21:30:16,573 ERROR [STDERR] Caused by: >>> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> org.jboss.resource.JBossResourceException. message: Could not create >>> connection; - nested throwable: >>> (org.jboss.resource.JBossResourceException: Failed to register driver >>> for: oracle.jdbc.driver.OracleDriver; - nested throwable: >>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)) >>> 2010-10-15 21:30:16,574 ERROR [STDERR] at >>> >>> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190) >>> " >>> >>> Thanks >>> Joseph John >>> >>> On Thu, Oct 14, 2010 at 4:21 PM, Thierry Delprat <[email protected]> >>> wrote: >>> > java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver >>> > => You need to add the oracle JDBC driver in Jboss lib >>> > Furthermore if you are using Oracle 11, the hibernate version that comes >>> > with Jboss 4.2 does not support correctly Oracle 11 (wrong detection). >>> > => You may need to look at https://jira.nuxeo.org/browse/NXP-5795 >>> > Tiry >>> > >>> > On 14 October 2010 14:03, Joseph John <[email protected]> wrote: >>> >> >>> >> Hi >>> >> I am trying to make nuxeo 5.3.2 with oracle 11.1 >>> >> Edited /bin/nuxeo.conf file and restarted nuxeo 5.3.2, I did not get >>> >> any error messages on >>> >> boot.log >>> >> nuxeo-error.log >>> >> but I get error log in "stderr.log" when I try to log in from the >>> >> nuxeo interface. the error in "stderr.log" I have cut and pasted >>> >> " >>> >> java.lang.RuntimeException: java.lang.RuntimeException: Unkown user >>> >> directory userDirectory >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> >>> >> >>> >> org.jboss.ejb3.interceptor.LifecycleInterceptorHandler.postConstruct(LifecycleInterceptorHandler.java:113) >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> org.jboss.ejb3.EJBContainer.invokePostConstruct(EJBContainer.java:623) >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> org.jboss.ejb3.AbstractPool.create(AbstractPool.java:131) >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> org.jboss.ejb3.InfinitePool.get(InfinitePool.java:49) >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> org.jboss.ejb3.ThreadlocalPool.create(ThreadlocalPool.java:50) >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> org.jboss.ejb3.ThreadlocalPool.get(ThreadlocalPool.java:90) >>> >> 2010-10-13 04:26:09,331 ERROR [STDERR] at >>> >> >>> >> >>> >> org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:54) >>> >> 2010-10-13 04:26:09,332 ERROR [STDERR] at >>> >> >>> >> >>> >> org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) >>> >> 2010-10-13 04:26:09,332 ERROR [STDERR] at org.jboss.aspects.security >>> >> >>> >> ... >>> >> .. >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] Caused by: >>> >> org.nuxeo.ecm.directory.DirectoryException: >>> >> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> >> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain >>> >> a connection >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:52) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getSchema(SQLDirectoryProxy.java:67) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.DirectoryServiceImpl.getDirectorySchema(DirectoryServiceImpl.java:154) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.platform.usermanager.UserManagerImpl.setUserDirectoryName(UserManagerImpl.java:181) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] ... 61 more >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] Caused by: >>> >> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> >> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain >>> >> a connection >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.sql.SQLDirectory.getConnection(SQLDirectory.java:216) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.sql.SQLDirectory.buildDialect(SQLDirectory.java:297) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> org.nuxeo.ecm.directory.sql.SQLDirectory.<init>(SQLDirectory.java:90) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:50) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] ... 64 more >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] Caused by: >>> >> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> >> org.jboss.util.NestedSQLException. message: Could not create >>> >> connection; - nested throwable: >>> >> (org.jboss.resource.JBossResourceException: Failed to register driver >>> >> for: oracle.jdbc.driver.OracleDriver; - nested throwable: >>> >> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)); >>> >> - nested throwable: (org.jboss.resource.JBossResourceException: Could >>> >> not create connection; - nested throwable: >>> >> (org.jboss.resource.JBossResourceException: Failed to register driver >>> >> for: oracle.jdbc.driver.OracleDriver; - nested throwable: >>> >> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver))) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] at >>> >> >>> >> >>> >> org.nuxeo.ecm.directory.sql.SQLDirectory.getConnection(SQLDirectory.java:214) >>> >> 2010-10-13 04:26:09,336 ERROR [STDERR] ... 67 more >>> >> 2010-10-13 04:26:09,337 ERROR [STDERR] Caused by: >>> >> org.nuxeo.ecm.core.api.WrappedException: Exception: >>> >> org.jboss.resource.JBossResourceException. message: Could not create >>> >> connection; - nested throwable: >>> >> (org.jboss.resource.JBossResourceException: Failed to register driver >>> >> for: oracle.jdbc.driver.OracleDriver; - nested throwable: >>> >> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)) >>> >> >>> >> # >>> >> Going through the error, I have a feeling that there is no information >>> >> of nuxeo users on oracle database, Do I need to import some tables and >>> >> values to make it work >>> >> >>> >> >>> >> -- >>> >> Thanks >>> >> Joseph John >>> >> http://www.oss101.com/ >>> >> _______________________________________________ >>> >> ECM mailing list >>> >> [email protected] >>> >> http://lists.nuxeo.com/mailman/listinfo/ecm >>> >> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm >>> > >>> > >>> >>> >>> >>> -- >>> Thanks >>> Joseph John >>> http://www.oss101.com/ >>> _______________________________________________ >>> ECM mailing list >>> [email protected] >>> http://lists.nuxeo.com/mailman/listinfo/ecm >>> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm >> >> > > > > -- > Thanks > Joseph John > http://www.oss101.com/ > _______________________________________________ > ECM mailing list > [email protected] > http://lists.nuxeo.com/mailman/listinfo/ecm > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
