First page unreachable after installation

[Francois_]

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.

[Benjamin_Jalon1]

Warn can be ignored

[Benjamin_Jalon1 · Accepted solution]

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

[Francois_]

Thanks a lot Bjalon.

[bharat4212_]

hi,

[bharat4212_]

Caused by

[Benjamin_Jalon1]

Please create a new question for a new question.

[bharat4212_]

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