First page unreachable after installation
Hi there,
Just having installed Nuxeo Platform 5.5 (with Windows Installer and bundled JDK+Postgres) to discover and try this amazing product. I'm running it on a Windows XP Wokstation After signing as Administrator in the login page, this message displays on my browser:
If you can read this in your browser, this probably because of a configuration problem of your nuxeo.war/WEB-INF/pages.xml. To change this, edit the OSGI-INF/deployment-fragment.xml of your project at extension pages#PAGES.
Can someone tell me what I'm supposed to do ? In addition, some error lines from the server Console. NB: the first ERROR lines, before logging in.
2011-12-22 14:30:01,578 ERROR [org.apache.geronimo.connector.outbound.MCFConnectionInterceptor] Error occurred creating ManagedConnection for org.apache.geronimo.connector.outbound.ConnectionInfo@1580c3d
org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Error executing: CREATE OR REPLACE FUNCTION NX_IN_TREE(id varchar(36), baseid varchar(36))
RETURNS boolean
AS $$
DECLARE
curid varchar(36) := id;
BEGIN
IF baseid IS NULL OR id IS NULL OR baseid = id THEN
RETURN false;
END IF;
LOOP
SELECT parentid INTO curid FROM hierarchy WHERE hierarchy.id = curid;
IF curid IS NULL THEN
RETURN false;
ELSEIF curid = baseid THEN
RETURN true;
END IF;
END LOOP;
END $$
LANGUAGE plpgsql
STABLE
COST 400; : ERREUR: le langage « plpgsql » n'existe pas
Indice : Utiliser CREATE LANGUAGE pour charger le langage dans la base de données.
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:145)*
*2011-12-22 14:30:01,593 ERROR [org.nuxeo.ecm.platform.mail.listener.MailEventListener] MailEventListener error… org.nuxeo.ecm.core.api.ClientException: Failed to load repository default
at org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:106)
at org.nuxeo.ecm.core.api.local.LocalSession.getSession(LocalSession.java:171)*
*2011-12-22 14:30:02,578 ERROR [org.apache.geronimo.connector.outbound.MCFConnectionInterceptor] Error occurred creating ManagedConnection for org.apache.geronimo.connector.outbound.ConnectionInfo@1db4c44 org.nuxeo.ecm.core.storage.StorageException: Could not select: SELECT “id” FROM “repositories” WHERE “name” = ?
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.getRootId(JDBCMapper.java:561)*
*2011-12-22 14:30:02,578 ERROR [org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl] Unable to register pending descriptors org.nuxeo.ecm.core.api.ClientException: Failed to load repository default
at org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:106)*
ThanX for helping.
Ok your trouble comes from the configuration of your PostgreSQL.
Please follow this documentation carefully:
http://doc.nuxeo.com/display/ADMINDOC/Configuring+PostgreSQL
The part missing in your case is:
CREATE LANGUAGE 'plpgsql';
 |
Benjamin Jalon
Member (18.8K) 5 7 5 |
12/22/2011 ( History) |
RETURN FALSE;
END IF; LOOP
SELECT parentid INTO curid FROM hierarchy WHERE hierarchy.id = curid;
IF curid IS NULL THEN
RETURN FALSE;
ELSEIF curid = baseid THEN
RETURN TRUE;
END IF;
END LOOP; END : You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getSession(ConnectionFactoryImpl.java:228)
at org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:104)
... 51 more
Caused by: org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Error executing: CREATE FUNCTION NX_IN_TREE(id varchar(36), baseid varchar(36))
1…..Caused by: java.sql.SQLException: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
2…….. caused by: java.lang.IllegalArgumentException: Repository not found: default
at org.nuxeo.ecm.core.api.local.LocalSession.lookupRepository(LocalSession.java:147)
at org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:102)
... 53 more
 |
bharat4212
Member (190) 1 2 1 |
07/04/2013 ( History) |
The ERROR you gave us, is not really expressive. Can you try to get the First ERROR.
I create a little documentation here to explain a bit which information we need.