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.

0 votes

2 answers

3783 views

ANSWER

Warn can be ignored: see here

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.

12/22/2011



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';
1 votes



Thanks a lot Bjalon. Works fine now.
12/23/2011

hi, i am using mysql,and reinstall, can you please guide me. getting same error
07/04/2013

Caused by: org.nuxeo.ecm.core.api.DocumentException: org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Error executing: CREATE FUNCTION NX_IN_TREE(id varchar(36), baseid varchar(36)) RETURNS BOOLEAN LANGUAGE SQL READS SQL DATA BEGIN DECLARE curid varchar(36) DEFAULT id; 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 : 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))

07/04/2013

Please create a new question for a new question.
07/05/2013


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
0 votes