"Too Many Redirects" after backup recovery in a new server


I installed a new server to test the production server backup following this instructions http://doc.nuxeo.com/display/public/ADMINDOC/Backup+and+Restore

The new server is identical to the primary server:

  • Ubuntu 10.04 LTS 64 bits
  • Nuxeo 5.4.2 from Ubuntu nuxeo-dm package
  • PostgreSQL 8.4

After the new nuxeo-dm package installation we have a fresh new PostgreSQL database with Administrator user and fresh new data directory under /var/lib/

In order to recover production server to new server:

  1. Stopped Nuxeo server.
  2. Data directory (/var/lib/nuxeo-dm) replaced: Deleted and restored a copy from the production server to the same location.
  3. Restored the SQL dump from the production server: # psql -h localhost -p 5433 -U nuxeodm nuxeodm < nuxeodm-production.sql
  4. Server started.

SQL dump made in the production server with: pg_dump -h localhost -p 5433 -U nuxeodm nuxeodm > nuxeodm-production.sql

After the restore, the problem is that I can't login with a production user and password. The error is Too Many Redirects after login.

Maybe the problem is due a bad restore of the SQL dump? I receive a lot of errors like these:

ERROR:  relation “rel_srch_ecm_path” already exists

ERROR:  insert or update on table “acls” violates foreign key constraint “acls_id_hierarchy_fk” DETAIL:  Key (id)=(14acc6c6-4f95-4865-864d-6a6e25270446) is not present in table “hierarchy”.

The solution is to dump into an empty Nuxeo database? Any workaround? :)




0 votes

0 answers