search

renderpci / dedalo

Dédalo: Cultural Heritage & Oral History Management System
https://dedalo.dev
GNU Affero General Public License v3.0
32 stars 6 forks source link

Problema en el volcado de la BBDD durante la instalación de Dédalo #20

Closed lauraprillo closed 4 years ago

lauraprillo commented 5 years ago

Hola Alex,

Estoy intentando instalar Dédalo en local sobre xampp y ya tengo Postgre SQL instalado, he creado la base de datos dedalo4_elprattvvideoteca, pero al hacer el restore de la base de datos de Dédalo con PgAdmin4, me da este error:

C:\Program Files\PostgreSQL\11\bin\pg_restore.exe --host "localhost" --port "5432" --username "postgres" --no-password --dbname "dedalo4_elprattvvideoteca" --verbose "C:\xampp\htdocs\dedalo\install\db\DEDALO~1.BAC"

Resultado:

pg_restore: conectando a la base de datos para reestablecimiento pg_restore: creando EXTENSION �plpgsql� pg_restore: creando COMMENT �EXTENSION plpgsql� pg_restore: creando EXTENSION �pg_trgm� pg_restore: creando COMMENT �EXTENSION pg_trgm� pg_restore: creando EXTENSION �unaccent� pg_restore: creando COMMENT �EXTENSION unaccent� pg_restore: creando TYPE �public.sino� pg_restore: [archiver (bd)] Error durante PROCESAMIENTO DE TABLA DE CONTENIDOS: pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 687; 1247 2179229 TYPE sino paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TYPE public.sino OWNER TO paco;

pg_restore: creando FUNCTION �public.check_array_component(boolean, jsonb)� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 301; 1255 2179233 FUNCTION check_array_component(boolean, jsonb) paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER FUNCTION public.check_array_component(condition boolean, component_path jsonb) OWNER TO paco;

pg_restore: creando FUNCTION �public.count_estimate(text)� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 302; 1255 2179234 FUNCTION count_estimate(text) paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER FUNCTION public.count_estimate(query text) OWNER TO paco;

pg_restore: creando FUNCTION �public.f_unaccent(text)� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 303; 1255 2179235 FUNCTION f_unaccent(text) paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER FUNCTION public.f_unaccent(text) OWNER TO paco;

pg_restore: creando TABLE �public.jer_dd� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 198; 1259 2179236 TABLE jer_dd paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.jer_dd OWNER TO paco;

pg_restore: creando SEQUENCE �public.jer_dd_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 199; 1259 2179242 SEQUENCE jer_dd_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.jer_dd_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.jer_dd_id_seq� pg_restore: creando TABLE �public.main_dd� pg_restore: creando SEQUENCE �public.main_dd_id_seq� pg_restore: creando SEQUENCE OWNED BY �public.main_dd_id_seq� pg_restore: creando SEQUENCE �public.matrix_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 200; 1259 2179249 SEQUENCE matrix_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 201; 1259 2179251 TABLE matrix paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_activities_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 202; 1259 2179258 SEQUENCE matrix_activities_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_activities_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_activities� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 203; 1259 2179260 TABLE matrix_activities paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_activities OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_activity_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 204; 1259 2179267 SEQUENCE matrix_activity_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_activity_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_activity_section_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 205; 1259 2179269 SEQUENCE matrix_activity_section_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_activity_section_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_activity� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 206; 1259 2179271 TABLE matrix_activity paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_activity OWNER TO paco;

pg_restore: creando TABLE �public.matrix_counter� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 207; 1259 2179281 TABLE matrix_counter paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_counter OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_counter_dd_id_seq� pg_restore: creando TABLE �public.matrix_counter_dd� pg_restore: creando SEQUENCE �public.matrix_counter_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 208; 1259 2179296 SEQUENCE matrix_counter_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_counter_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_counter_id_seq� pg_restore: creando SEQUENCE �public.matrix_dataframe_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 209; 1259 2179298 SEQUENCE matrix_dataframe_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_dataframe_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_dataframe� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 210; 1259 2179300 TABLE matrix_dataframe paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_dataframe OWNER TO paco;

pg_restore: creando TABLE �public.matrix_dd� pg_restore: creando SEQUENCE �public.matrix_dd_id_seq� pg_restore: creando SEQUENCE OWNED BY �public.matrix_dd_id_seq� pg_restore: creando SEQUENCE �public.matrix_descriptors_dd_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 211; 1259 2179315 SEQUENCE matrix_descriptors_dd_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_descriptors_dd_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_descriptors_dd� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 212; 1259 2179317 TABLE matrix_descriptors_dd paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_descriptors_dd OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_hierarchy_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 213; 1259 2179324 SEQUENCE matrix_hierarchy_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_hierarchy_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_hierarchy� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 214; 1259 2179326 TABLE matrix_hierarchy paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_hierarchy OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_hierarchy_main_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 215; 1259 2179333 SEQUENCE matrix_hierarchy_main_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_hierarchy_main_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_hierarchy_main� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 216; 1259 2179335 TABLE matrix_hierarchy_main paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_hierarchy_main OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_indexations_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 217; 1259 2179342 SEQUENCE matrix_indexations_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_indexations_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_indexations� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 218; 1259 2179344 TABLE matrix_indexations paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_indexations OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_langs_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 219; 1259 2179351 SEQUENCE matrix_langs_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_langs_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_langs� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 220; 1259 2179353 TABLE matrix_langs paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_langs OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_layout_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 221; 1259 2179360 SEQUENCE matrix_layout_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_layout_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_layout� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 222; 1259 2179362 TABLE matrix_layout paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_layout OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_layout_dd_id_seq� pg_restore: creando TABLE �public.matrix_layout_dd� pg_restore: creando SEQUENCE �public.matrix_list_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 223; 1259 2179378 SEQUENCE matrix_list_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_list_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_list� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 224; 1259 2179380 TABLE matrix_list paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_list OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_notes_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 225; 1259 2179387 SEQUENCE matrix_notes_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_notes_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_notes� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 226; 1259 2179389 TABLE matrix_notes paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_notes OWNER TO paco;

pg_restore: creando TABLE �public.matrix_notifications� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 227; 1259 2179396 TABLE matrix_notifications paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_notifications OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_notifications_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 228; 1259 2179402 SEQUENCE matrix_notifications_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_notifications_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_notifications_id_seq� pg_restore: creando TABLE �public.matrix_profiles� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 229; 1259 2179404 TABLE matrix_profiles paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_profiles OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_profiles_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 230; 1259 2179410 SEQUENCE matrix_profiles_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_profiles_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_profiles_id_seq� pg_restore: creando TABLE �public.matrix_projects� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 231; 1259 2179412 TABLE matrix_projects paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_projects OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_projects_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 232; 1259 2179418 SEQUENCE matrix_projects_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_projects_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_projects_id_seq� pg_restore: creando TABLE �public.matrix_stat� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 233; 1259 2179420 TABLE matrix_stat paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_stat OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_stat_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 234; 1259 2179426 SEQUENCE matrix_stat_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_stat_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_stat_id_seq� pg_restore: creando SEQUENCE �public.matrix_structurations_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 235; 1259 2179428 SEQUENCE matrix_structurations_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_structurations_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_structurations� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 236; 1259 2179430 TABLE matrix_structurations paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_structurations OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_test_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 237; 1259 2179437 SEQUENCE matrix_test_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_test_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_test� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 238; 1259 2179439 TABLE matrix_test paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_test OWNER TO paco;

pg_restore: creando TABLE �public.matrix_time_machine� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 239; 1259 2179446 TABLE matrix_time_machine paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_time_machine OWNER TO paco;

pg_restore: creando SEQUENCE �public.matrix_time_machine_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 240; 1259 2179452 SEQUENCE matrix_time_machine_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_time_machine_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_time_machine_id_seq� pg_restore: creando TABLE �public.matrix_updates� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 241; 1259 2179454 TABLE matrix_updates paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_updates OWNER TO paco;

pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 242; 1259 2179460 SEQUENCE matrix_updates_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_updates_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_updates_id_seq� pg_restore: creando SEQUENCE �public.matrix_users_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 243; 1259 2179462 SEQUENCE matrix_users_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_users_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_users� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 244; 1259 2179464 TABLE matrix_users paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_users OWNER TO paco;

pg_restore: creando TABLE �public.relations� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 245; 1259 2179471 TABLE relations paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.relations OWNER TO paco;

pg_restore: creando SEQUENCE �public.relations_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 246; 1259 2179477 SEQUENCE relations_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.relations_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.relations_id_seq� pg_restore: creando DEFAULT �public.jer_dd id� pg_restore: creando DEFAULT �public.main_dd id� pg_restore: creando DEFAULT �public.matrix_counter id� pg_restore: creando DEFAULT �public.matrix_dd id� pg_restore: creando DEFAULT �public.matrix_notifications id� pg_restore: creando DEFAULT �public.matrix_profiles id� pg_restore: creando DEFAULT �public.matrix_projects id� pg_restore: creando DEFAULT �public.matrix_stat id� pg_restore: creando DEFAULT �public.matrix_time_machine id� pg_restore: creando DEFAULT �public.matrix_updates id� pg_restore: creando DEFAULT �public.relations id� pg_restore: procesando datos de la tabla �public.jer_dd� pg_restore: procesando datos de la tabla �public.main_dd� pg_restore: procesando datos de la tabla �public.matrix� pg_restore: procesando datos de la tabla �public.matrix_activities� pg_restore: procesando datos de la tabla �public.matrix_activity� pg_restore: procesando datos de la tabla �public.matrix_counter� pg_restore: procesando datos de la tabla �public.matrix_counter_dd� pg_restore: procesando datos de la tabla �public.matrix_dataframe� pg_restore: procesando datos de la tabla �public.matrix_dd� pg_restore: procesando datos de la tabla �public.matrix_descriptors_dd� pg_restore: procesando datos de la tabla �public.matrix_hierarchy� pg_restore: procesando datos de la tabla �public.matrix_hierarchy_main� pg_restore: procesando datos de la tabla �public.matrix_indexations� pg_restore: procesando datos de la tabla �public.matrix_langs� pg_restore: procesando datos de la tabla �public.matrix_layout� pg_restore: procesando datos de la tabla �public.matrix_layout_dd� pg_restore: procesando datos de la tabla �public.matrix_list� pg_restore: procesando datos de la tabla �public.matrix_notes� pg_restore: procesando datos de la tabla �public.matrix_notifications� pg_restore: procesando datos de la tabla �public.matrix_profiles� pg_restore: procesando datos de la tabla �public.matrix_projects� pg_restore: procesando datos de la tabla �public.matrix_stat� pg_restore: procesando datos de la tabla �public.matrix_structurations� pg_restore: procesando datos de la tabla �public.matrix_test� pg_restore: procesando datos de la tabla �public.matrix_time_machine� pg_restore: procesando datos de la tabla �public.matrix_updates� pg_restore: procesando datos de la tabla �public.matrix_users� pg_restore: procesando datos de la tabla �public.relations� pg_restore: ejecutando SEQUENCE SET jer_dd_id_seq pg_restore: ejecutando SEQUENCE SET main_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_activities_id_seq pg_restore: ejecutando SEQUENCE SET matrix_activity_id_seq pg_restore: ejecutando SEQUENCE SET matrix_activity_section_id_seq pg_restore: ejecutando SEQUENCE SET matrix_counter_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_counter_id_seq pg_restore: ejecutando SEQUENCE SET matrix_dataframe_id_seq pg_restore: ejecutando SEQUENCE SET matrix_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_descriptors_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_hierarchy_id_seq pg_restore: ejecutando SEQUENCE SET matrix_hierarchy_main_id_seq pg_restore: ejecutando SEQUENCE SET matrix_id_seq pg_restore: ejecutando SEQUENCE SET matrix_indexations_id_seq pg_restore: ejecutando SEQUENCE SET matrix_langs_id_seq pg_restore: ejecutando SEQUENCE SET matrix_layout_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_layout_id_seq pg_restore: ejecutando SEQUENCE SET matrix_list_id_seq pg_restore: ejecutando SEQUENCE SET matrix_notes_id_seq pg_restore: ejecutando SEQUENCE SET matrix_notifications_id_seq pg_restore: ejecutando SEQUENCE SET matrix_profiles_id_seq pg_restore: ejecutando SEQUENCE SET matrix_projects_id_seq pg_restore: ejecutando SEQUENCE SET matrix_stat_id_seq pg_restore: ejecutando SEQUENCE SET matrix_structurations_id_seq pg_restore: ejecutando SEQUENCE SET matrix_test_id_seq pg_restore: ejecutando SEQUENCE SET matrix_time_machine_id_seq pg_restore: ejecutando SEQUENCE SET matrix_updates_id_seq pg_restore: ejecutando SEQUENCE SET matrix_users_id_seq pg_restore: ejecutando SEQUENCE SET relations_id_seq pg_restore: creando CONSTRAINT �public.jer_dd jer_dd_id� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 242; 1259 2179460 SEQUENCE matrix_updates_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_updates_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.matrix_updates_id_seq� pg_restore: creando SEQUENCE �public.matrix_users_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 243; 1259 2179462 SEQUENCE matrix_users_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_users_id_seq OWNER TO paco;

pg_restore: creando TABLE �public.matrix_users� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 244; 1259 2179464 TABLE matrix_users paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.matrix_users OWNER TO paco;

pg_restore: creando TABLE �public.relations� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 245; 1259 2179471 TABLE relations paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.relations OWNER TO paco;

pg_restore: creando SEQUENCE �public.relations_id_seq� pg_restore: [archiver (bd)] Error en entrada de la tabla de contenidos 246; 1259 2179477 SEQUENCE relations_id_seq paco pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TABLE public.relations_id_seq OWNER TO paco;

pg_restore: creando SEQUENCE OWNED BY �public.relations_id_seq� pg_restore: creando DEFAULT �public.jer_dd id� pg_restore: creando DEFAULT �public.main_dd id� pg_restore: creando DEFAULT �public.matrix_counter id� pg_restore: creando DEFAULT �public.matrix_dd id� pg_restore: creando DEFAULT �public.matrix_notifications id� pg_restore: creando DEFAULT �public.matrix_profiles id� pg_restore: creando DEFAULT �public.matrix_projects id� pg_restore: creando DEFAULT �public.matrix_stat id� pg_restore: creando DEFAULT �public.matrix_time_machine id� pg_restore: creando DEFAULT �public.matrix_updates id� pg_restore: creando DEFAULT �public.relations id� pg_restore: procesando datos de la tabla �public.jer_dd� pg_restore: procesando datos de la tabla �public.main_dd� pg_restore: procesando datos de la tabla �public.matrix� pg_restore: procesando datos de la tabla �public.matrix_activities� pg_restore: procesando datos de la tabla �public.matrix_activity� pg_restore: procesando datos de la tabla �public.matrix_counter� pg_restore: procesando datos de la tabla �public.matrix_counter_dd� pg_restore: procesando datos de la tabla �public.matrix_dataframe� pg_restore: procesando datos de la tabla �public.matrix_dd� pg_restore: procesando datos de la tabla �public.matrix_descriptors_dd� pg_restore: procesando datos de la tabla �public.matrix_hierarchy� pg_restore: procesando datos de la tabla �public.matrix_hierarchy_main� pg_restore: procesando datos de la tabla �public.matrix_indexations� pg_restore: procesando datos de la tabla �public.matrix_langs� pg_restore: procesando datos de la tabla �public.matrix_layout� pg_restore: procesando datos de la tabla �public.matrix_layout_dd� pg_restore: procesando datos de la tabla �public.matrix_list� pg_restore: procesando datos de la tabla �public.matrix_notes� pg_restore: procesando datos de la tabla �public.matrix_notifications� pg_restore: procesando datos de la tabla �public.matrix_profiles� pg_restore: procesando datos de la tabla �public.matrix_projects� pg_restore: procesando datos de la tabla �public.matrix_stat� pg_restore: procesando datos de la tabla �public.matrix_structurations� pg_restore: procesando datos de la tabla �public.matrix_test� pg_restore: procesando datos de la tabla �public.matrix_time_machine� pg_restore: procesando datos de la tabla �public.matrix_updates� pg_restore: procesando datos de la tabla �public.matrix_users� pg_restore: procesando datos de la tabla �public.relations� pg_restore: ejecutando SEQUENCE SET jer_dd_id_seq pg_restore: ejecutando SEQUENCE SET main_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_activities_id_seq pg_restore: ejecutando SEQUENCE SET matrix_activity_id_seq pg_restore: ejecutando SEQUENCE SET matrix_activity_section_id_seq pg_restore: ejecutando SEQUENCE SET matrix_counter_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_counter_id_seq pg_restore: ejecutando SEQUENCE SET matrix_dataframe_id_seq pg_restore: ejecutando SEQUENCE SET matrix_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_descriptors_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_hierarchy_id_seq pg_restore: ejecutando SEQUENCE SET matrix_hierarchy_main_id_seq pg_restore: ejecutando SEQUENCE SET matrix_id_seq pg_restore: ejecutando SEQUENCE SET matrix_indexations_id_seq pg_restore: ejecutando SEQUENCE SET matrix_langs_id_seq pg_restore: ejecutando SEQUENCE SET matrix_layout_dd_id_seq pg_restore: ejecutando SEQUENCE SET matrix_layout_id_seq pg_restore: ejecutando SEQUENCE SET matrix_list_id_seq pg_restore: ejecutando SEQUENCE SET matrix_notes_id_seq pg_restore: ejecutando SEQUENCE SET matrix_notifications_id_seq pg_restore: ejecutando SEQUENCE SET matrix_profiles_id_seq pg_restore: ejecutando SEQUENCE SET matrix_projects_id_seq pg_restore: ejecutando SEQUENCE SET matrix_stat_id_seq pg_restore: ejecutando SEQUENCE SET matrix_structurations_id_seq pg_restore: ejecutando SEQUENCE SET matrix_test_id_seq pg_restore: ejecutando SEQUENCE SET matrix_time_machine_id_seq pg_restore: ejecutando SEQUENCE SET matrix_updates_id_seq pg_restore: ejecutando SEQUENCE SET matrix_users_id_seq pg_restore: ejecutando SEQUENCE SET relations_id_seq pg_restore: creando CONSTRAINT �public.jer_dd jer_dd_id� pg_restore: creando CONSTRAINT �public.matrix_activities matrix_activities_pkey� pg_restore: creando CONSTRAINT �public.matrix_activities matrix_activities_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_activity matrix_activity_id_primary� pg_restore: creando CONSTRAINT �public.matrix_counter_dd matrix_counter_dd_id� pg_restore: creando CONSTRAINT �public.matrix_counter_dd matrix_counter_dd_tipo_unique� pg_restore: creando CONSTRAINT �public.matrix_counter matrix_counter_id� pg_restore: creando CONSTRAINT �public.matrix_counter matrix_counter_tipo_unique� pg_restore: creando CONSTRAINT �public.matrix_dataframe matrix_dataframe_pkey� pg_restore: creando CONSTRAINT �public.matrix_dataframe matrix_dataframe_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_dd matrix_dd_id� pg_restore: creando CONSTRAINT �public.matrix_dd matrix_dd_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_descriptors_dd matrix_descriptors_dd_id� pg_restore: creando CONSTRAINT �public.matrix_hierarchy_main matrix_hierarchy_main_pkey� pg_restore: creando CONSTRAINT �public.matrix_hierarchy_main matrix_hierarchy_main_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_hierarchy matrix_hierarchy_pkey� pg_restore: creando CONSTRAINT �public.matrix_hierarchy matrix_hierarchy_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix matrix_id� pg_restore: creando CONSTRAINT �public.matrix_indexations matrix_indexations_pkey� pg_restore: creando CONSTRAINT �public.matrix_indexations matrix_indexations_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_langs matrix_langs_pkey� pg_restore: creando CONSTRAINT �public.matrix_langs matrix_langs_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_layout_dd matrix_layout_dd_pkey� pg_restore: creando CONSTRAINT �public.matrix_layout_dd matrix_layout_dd_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_layout matrix_layout_pkey� pg_restore: creando CONSTRAINT �public.matrix_layout matrix_layout_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_list matrix_list_pkey� pg_restore: creando CONSTRAINT �public.matrix_list matrix_list_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_notes matrix_notes_pkey� pg_restore: creando CONSTRAINT �public.matrix_notes matrix_notes_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_notifications matrix_notifications_id� pg_restore: creando CONSTRAINT �public.matrix_profiles matrix_profiles_pkey� pg_restore: creando CONSTRAINT �public.matrix_profiles matrix_profiles_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_projects matrix_projects_id� pg_restore: creando CONSTRAINT �public.matrix_projects matrix_projects_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix matrix_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_stat matrix_stat_pkey� pg_restore: creando CONSTRAINT �public.matrix_structurations matrix_structurations_pkey� pg_restore: creando CONSTRAINT �public.matrix_structurations matrix_structurations_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_test matrix_test_pkey� pg_restore: creando CONSTRAINT �public.matrix_test matrix_test_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_time_machine matrix_time_machine_id� pg_restore: creando CONSTRAINT �public.matrix_updates matrix_updates_id� pg_restore: creando CONSTRAINT �public.matrix_users matrix_users_pkey� pg_restore: creando CONSTRAINT �public.matrix_users matrix_users_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.relations relations_all_constraint� pg_restore: creando CONSTRAINT �public.relations relations_id� pg_restore: creando CONSTRAINT �public.jer_dd terminoID_unique� pg_restore: creando CONSTRAINT �public.main_dd tld� pg_restore: creando INDEX �public.jer_dd_esdescriptor� pg_restore: creando INDEX �public.jer_dd_esmodelo� pg_restore: creando INDEX �public.jer_dd_modelo� pg_restore: creando INDEX �public.jer_dd_norden� pg_restore: creando INDEX �public.jer_dd_parent� pg_restore: creando INDEX �public.jer_dd_parent_esdescriptor_norden� pg_restore: creando INDEX �public.jer_dd_relaciones� pg_restore: creando INDEX �public.jer_dd_terminoid� pg_restore: creando INDEX �public.jer_dd_traducible� pg_restore: creando INDEX �public.jer_dd_usableindex� pg_restore: creando INDEX �public.jer_dd_visible� pg_restore: creando INDEX �public.matrix_activities_datos_gin� pg_restore: creando INDEX �public.matrix_activities_id_idx� pg_restore: creando INDEX �public.matrix_activities_relations_idx� pg_restore: creando INDEX �public.matrix_activities_section_id� pg_restore: creando INDEX �public.matrix_activities_section_tipo� pg_restore: creando INDEX �public.matrix_activities_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_activity_date_btree� pg_restore: creando INDEX �public.matrix_activity_datos_gin� pg_restore: creando INDEX �public.matrix_activity_id_btree� pg_restore: creando INDEX �public.matrix_activity_order_section_id_desc� pg_restore: creando INDEX �public.matrix_activity_relations_idx� pg_restore: creando INDEX �public.matrix_activity_section_id� pg_restore: creando INDEX �public.matrix_activity_section_tipo� pg_restore: creando INDEX �public.matrix_activity_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_counter_dd_parent� pg_restore: creando INDEX �public.matrix_counter_parent� pg_restore: creando INDEX �public.matrix_counter_tipo� pg_restore: creando INDEX �public.matrix_dataframe_datos_idx� pg_restore: creando INDEX �public.matrix_dataframe_id_desc_idx� pg_restore: creando INDEX �public.matrix_dataframe_id_idx� pg_restore: creando INDEX �public.matrix_dataframe_relations_idx� pg_restore: creando INDEX �public.matrix_dataframe_section_id_idx� pg_restore: creando INDEX �public.matrix_dataframe_section_tipo_idx� pg_restore: creando INDEX �public.matrix_datos_gin� pg_restore: creando INDEX �public.matrix_dd_gin� pg_restore: creando INDEX �public.matrix_dd_relations_idx� pg_restore: creando CONSTRAINT �public.matrix_activities matrix_activities_pkey� pg_restore: creando CONSTRAINT �public.matrix_activities matrix_activities_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_activity matrix_activity_id_primary� pg_restore: creando CONSTRAINT �public.matrix_counter_dd matrix_counter_dd_id� pg_restore: creando CONSTRAINT �public.matrix_counter_dd matrix_counter_dd_tipo_unique� pg_restore: creando CONSTRAINT �public.matrix_counter matrix_counter_id� pg_restore: creando CONSTRAINT �public.matrix_counter matrix_counter_tipo_unique� pg_restore: creando CONSTRAINT �public.matrix_dataframe matrix_dataframe_pkey� pg_restore: creando CONSTRAINT �public.matrix_dataframe matrix_dataframe_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_dd matrix_dd_id� pg_restore: creando CONSTRAINT �public.matrix_dd matrix_dd_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_descriptors_dd matrix_descriptors_dd_id� pg_restore: creando CONSTRAINT �public.matrix_hierarchy_main matrix_hierarchy_main_pkey� pg_restore: creando CONSTRAINT �public.matrix_hierarchy_main matrix_hierarchy_main_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_hierarchy matrix_hierarchy_pkey� pg_restore: creando CONSTRAINT �public.matrix_hierarchy matrix_hierarchy_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix matrix_id� pg_restore: creando CONSTRAINT �public.matrix_indexations matrix_indexations_pkey� pg_restore: creando CONSTRAINT �public.matrix_indexations matrix_indexations_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_langs matrix_langs_pkey� pg_restore: creando CONSTRAINT �public.matrix_langs matrix_langs_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_layout_dd matrix_layout_dd_pkey� pg_restore: creando CONSTRAINT �public.matrix_layout_dd matrix_layout_dd_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_layout matrix_layout_pkey� pg_restore: creando CONSTRAINT �public.matrix_layout matrix_layout_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_list matrix_list_pkey� pg_restore: creando CONSTRAINT �public.matrix_list matrix_list_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_notes matrix_notes_pkey� pg_restore: creando CONSTRAINT �public.matrix_notes matrix_notes_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_notifications matrix_notifications_id� pg_restore: creando CONSTRAINT �public.matrix_profiles matrix_profiles_pkey� pg_restore: creando CONSTRAINT �public.matrix_profiles matrix_profiles_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_projects matrix_projects_id� pg_restore: creando CONSTRAINT �public.matrix_projects matrix_projects_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix matrix_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.matrix_stat matrix_stat_pkey� pg_restore: creando CONSTRAINT �public.matrix_structurations matrix_structurations_pkey� pg_restore: creando CONSTRAINT �public.matrix_structurations matrix_structurations_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_test matrix_test_pkey� pg_restore: creando CONSTRAINT �public.matrix_test matrix_test_section_id_section_tipo_key� pg_restore: creando CONSTRAINT �public.matrix_time_machine matrix_time_machine_id� pg_restore: creando CONSTRAINT �public.matrix_updates matrix_updates_id� pg_restore: creando CONSTRAINT �public.matrix_users matrix_users_pkey� pg_restore: creando CONSTRAINT �public.matrix_users matrix_users_section_id_section_tipo� pg_restore: creando CONSTRAINT �public.relations relations_all_constraint� pg_restore: creando CONSTRAINT �public.relations relations_id� pg_restore: creando CONSTRAINT �public.jer_dd terminoID_unique� pg_restore: creando CONSTRAINT �public.main_dd tld� pg_restore: creando INDEX �public.jer_dd_esdescriptor� pg_restore: creando INDEX �public.jer_dd_esmodelo� pg_restore: creando INDEX �public.jer_dd_modelo� pg_restore: creando INDEX �public.jer_dd_norden� pg_restore: creando INDEX �public.jer_dd_parent� pg_restore: creando INDEX �public.jer_dd_parent_esdescriptor_norden� pg_restore: creando INDEX �public.jer_dd_relaciones� pg_restore: creando INDEX �public.jer_dd_terminoid� pg_restore: creando INDEX �public.jer_dd_traducible� pg_restore: creando INDEX �public.jer_dd_usableindex� pg_restore: creando INDEX �public.jer_dd_visible� pg_restore: creando INDEX �public.matrix_activities_datos_gin� pg_restore: creando INDEX �public.matrix_activities_id_idx� pg_restore: creando INDEX �public.matrix_activities_relations_idx� pg_restore: creando INDEX �public.matrix_activities_section_id� pg_restore: creando INDEX �public.matrix_activities_section_tipo� pg_restore: creando INDEX �public.matrix_activities_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_activity_date_btree� pg_restore: creando INDEX �public.matrix_activity_datos_gin� pg_restore: creando INDEX �public.matrix_activity_id_btree� pg_restore: creando INDEX �public.matrix_activity_order_section_id_desc� pg_restore: creando INDEX �public.matrix_activity_relations_idx� pg_restore: creando INDEX �public.matrix_activity_section_id� pg_restore: creando INDEX �public.matrix_activity_section_tipo� pg_restore: creando INDEX �public.matrix_activity_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_counter_dd_parent� pg_restore: creando INDEX �public.matrix_counter_parent� pg_restore: creando INDEX �public.matrix_counter_tipo� pg_restore: creando INDEX �public.matrix_dataframe_datos_idx� pg_restore: creando INDEX �public.matrix_dataframe_id_desc_idx� pg_restore: creando INDEX �public.matrix_dataframe_id_idx� pg_restore: creando INDEX �public.matrix_dataframe_relations_idx� pg_restore: creando INDEX �public.matrix_dataframe_section_id_idx� pg_restore: creando INDEX �public.matrix_dataframe_section_tipo_idx� pg_restore: creando INDEX �public.matrix_datos_gin� pg_restore: creando INDEX �public.matrix_dd_gin� pg_restore: creando INDEX �public.matrix_dd_relations_idx� pg_restore: creando INDEX �public.matrix_dd_section_tipo� pg_restore: creando INDEX �public.matrix_dd_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_descriptors_dd_lang� pg_restore: creando INDEX �public.matrix_descriptors_dd_parent� pg_restore: creando INDEX �public.matrix_descriptors_dd_parent_tipo_lang� pg_restore: creando INDEX �public.matrix_descriptors_dd_tipo� pg_restore: creando INDEX �public.matrix_hierarchy63_geonames_id_gin_idx� pg_restore: creando INDEX �public.matrix_hierarchy_datos_idx� pg_restore: creando INDEX �public.matrix_hierarchy_id_desc_idx� pg_restore: creando INDEX �public.matrix_hierarchy_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_datos_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_id_desc_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_relations_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_section_tipo_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_relations_idx� pg_restore: creando INDEX �public.matrix_hierarchy_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_section_tipo_idx� pg_restore: creando INDEX �public.matrix_hierarchy_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_term_hierarchy25_idx� pg_restore: creando INDEX �public.matrix_id_index� pg_restore: creando INDEX �public.matrix_indexations_datos_idx� pg_restore: creando INDEX �public.matrix_indexations_id_desc_idx� pg_restore: creando INDEX �public.matrix_indexations_id_idx� pg_restore: creando INDEX �public.matrix_indexations_relations_idx� pg_restore: creando INDEX �public.matrix_indexations_section_id_idx� pg_restore: creando INDEX �public.matrix_indexations_section_tipo_idx� pg_restore: creando INDEX �public.matrix_indexations_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_langs_datos_idx� pg_restore: creando INDEX �public.matrix_langs_hierarchy41_code_gin_idx� pg_restore: creando INDEX �public.matrix_langs_id_desc_idx� pg_restore: creando INDEX �public.matrix_langs_id_idx� pg_restore: creando INDEX �public.matrix_langs_section_id_idx� pg_restore: creando INDEX �public.matrix_langs_section_tipo_idx� pg_restore: creando INDEX �public.matrix_langs_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_layout_dd_relations_idx� pg_restore: creando INDEX �public.matrix_layout_main_relations_idx� pg_restore: creando INDEX �public.matrix_layout_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_list_datos_gin� pg_restore: creando INDEX �public.matrix_list_relations_idx� pg_restore: creando INDEX �public.matrix_list_section_id� pg_restore: creando INDEX �public.matrix_list_section_tipo� pg_restore: creando INDEX �public.matrix_list_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_notes_datos_idx� pg_restore: creando INDEX �public.matrix_notes_id_desc_idx� pg_restore: creando INDEX �public.matrix_notes_id_idx� pg_restore: creando INDEX �public.matrix_notes_relations_idx� pg_restore: creando INDEX �public.matrix_notes_section_id_idx� pg_restore: creando INDEX �public.matrix_notes_section_tipo_idx� pg_restore: creando INDEX �public.matrix_notes_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_order_id_asc� pg_restore: creando INDEX �public.matrix_order_id_desc� pg_restore: creando INDEX �public.matrix_profiles_datos_gin� pg_restore: creando INDEX �public.matrix_profiles_relations_idx� pg_restore: creando INDEX �public.matrix_profiles_section_id� pg_restore: creando INDEX �public.matrix_profiles_section_tipo� pg_restore: creando INDEX �public.matrix_profiles_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_projects_datos_gin� pg_restore: creando INDEX �public.matrix_projects_relations_idx� pg_restore: creando INDEX �public.matrix_projects_section_id� pg_restore: creando INDEX �public.matrix_projects_section_tipo� pg_restore: creando INDEX �public.matrix_projects_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_relations_idx� pg_restore: creando INDEX �public.matrix_rsc24� pg_restore: creando INDEX �public.matrix_rsc25� pg_restore: creando INDEX �public.matrix_rsc90� pg_restore: creando INDEX �public.matrix_section_id� pg_restore: creando INDEX �public.matrix_section_tipo� pg_restore: creando INDEX �public.matrix_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_stat_datos_idx� pg_restore: creando INDEX �public.matrix_stat_expr_idx2� pg_restore: creando INDEX �public.matrix_stat_expr_idx3� pg_restore: creando INDEX �public.matrix_stat_expr_idx4� pg_restore: creando INDEX �public.matrix_stat_id_expr_expr1_idx� pg_restore: creando INDEX �public.matrix_stat_id_expr_expr1_idx1� pg_restore: creando INDEX �public.matrix_stat_id_idx� pg_restore: creando INDEX �public.matrix_structurations_datos_idx� pg_restore: creando INDEX �public.matrix_structurations_id_desc_idx� pg_restore: creando INDEX �public.matrix_structurations_id_idx� pg_restore: creando INDEX �public.matrix_structurations_relations_idx� pg_restore: creando INDEX �public.matrix_structurations_section_id_idx� pg_restore: creando INDEX �public.matrix_structurations_section_tipo_idx� pg_restore: creando INDEX �public.matrix_structurations_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_test_datos_idx� pg_restore: creando INDEX �public.matrix_test_expr_idx� pg_restore: creando INDEX �public.matrix_test_expr_idx1� pg_restore: creando INDEX �public.matrix_test_expr_idx2� pg_restore: creando INDEX �public.matrix_test_expr_idx3� pg_restore: creando INDEX �public.matrix_test_expr_idx4� pg_restore: creando INDEX �public.matrix_test_id_idx� pg_restore: creando INDEX �public.matrix_test_id_idx1� pg_restore: creando INDEX �public.matrix_test_section_id_idx� pg_restore: creando INDEX �public.matrix_dd_section_tipo� pg_restore: creando INDEX �public.matrix_dd_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_descriptors_dd_lang� pg_restore: creando INDEX �public.matrix_descriptors_dd_parent� pg_restore: creando INDEX �public.matrix_descriptors_dd_parent_tipo_lang� pg_restore: creando INDEX �public.matrix_descriptors_dd_tipo� pg_restore: creando INDEX �public.matrix_hierarchy63_geonames_id_gin_idx� pg_restore: creando INDEX �public.matrix_hierarchy_datos_idx� pg_restore: creando INDEX �public.matrix_hierarchy_id_desc_idx� pg_restore: creando INDEX �public.matrix_hierarchy_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_datos_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_id_desc_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_relations_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_section_tipo_idx� pg_restore: creando INDEX �public.matrix_hierarchy_main_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_relations_idx� pg_restore: creando INDEX �public.matrix_hierarchy_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_section_tipo_idx� pg_restore: creando INDEX �public.matrix_hierarchy_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_hierarchy_term_hierarchy25_idx� pg_restore: creando INDEX �public.matrix_id_index� pg_restore: creando INDEX �public.matrix_indexations_datos_idx� pg_restore: creando INDEX �public.matrix_indexations_id_desc_idx� pg_restore: creando INDEX �public.matrix_indexations_id_idx� pg_restore: creando INDEX �public.matrix_indexations_relations_idx� pg_restore: creando INDEX �public.matrix_indexations_section_id_idx� pg_restore: creando INDEX �public.matrix_indexations_section_tipo_idx� pg_restore: creando INDEX �public.matrix_indexations_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_langs_datos_idx� pg_restore: creando INDEX �public.matrix_langs_hierarchy41_code_gin_idx� pg_restore: creando INDEX �public.matrix_langs_id_desc_idx� pg_restore: creando INDEX �public.matrix_langs_id_idx� pg_restore: creando INDEX �public.matrix_langs_section_id_idx� pg_restore: creando INDEX �public.matrix_langs_section_tipo_idx� pg_restore: creando INDEX �public.matrix_langs_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_layout_dd_relations_idx� pg_restore: creando INDEX �public.matrix_layout_main_relations_idx� pg_restore: creando INDEX �public.matrix_layout_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_list_datos_gin� pg_restore: creando INDEX �public.matrix_list_relations_idx� pg_restore: creando INDEX �public.matrix_list_section_id� pg_restore: creando INDEX �public.matrix_list_section_tipo� pg_restore: creando INDEX �public.matrix_list_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_notes_datos_idx� pg_restore: creando INDEX �public.matrix_notes_id_desc_idx� pg_restore: creando INDEX �public.matrix_notes_id_idx� pg_restore: creando INDEX �public.matrix_notes_relations_idx� pg_restore: creando INDEX �public.matrix_notes_section_id_idx� pg_restore: creando INDEX �public.matrix_notes_section_tipo_idx� pg_restore: creando INDEX �public.matrix_notes_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_order_id_asc� pg_restore: creando INDEX �public.matrix_order_id_desc� pg_restore: creando INDEX �public.matrix_profiles_datos_gin� pg_restore: creando INDEX �public.matrix_profiles_relations_idx� pg_restore: creando INDEX �public.matrix_profiles_section_id� pg_restore: creando INDEX �public.matrix_profiles_section_tipo� pg_restore: creando INDEX �public.matrix_profiles_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_projects_datos_gin� pg_restore: creando INDEX �public.matrix_projects_relations_idx� pg_restore: creando INDEX �public.matrix_projects_section_id� pg_restore: creando INDEX �public.matrix_projects_section_tipo� pg_restore: creando INDEX �public.matrix_projects_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_relations_idx� pg_restore: creando INDEX �public.matrix_rsc24� pg_restore: creando INDEX �public.matrix_rsc25� pg_restore: creando INDEX �public.matrix_rsc90� pg_restore: creando INDEX �public.matrix_section_id� pg_restore: creando INDEX �public.matrix_section_tipo� pg_restore: creando INDEX �public.matrix_section_tipo_section_id� pg_restore: creando INDEX �public.matrix_stat_datos_idx� pg_restore: creando INDEX �public.matrix_stat_expr_idx2� pg_restore: creando INDEX �public.matrix_stat_expr_idx3� pg_restore: creando INDEX �public.matrix_stat_expr_idx4� pg_restore: creando INDEX �public.matrix_stat_id_expr_expr1_idx� pg_restore: creando INDEX �public.matrix_stat_id_expr_expr1_idx1� pg_restore: creando INDEX �public.matrix_stat_id_idx� pg_restore: creando INDEX �public.matrix_structurations_datos_idx� pg_restore: creando INDEX �public.matrix_structurations_id_desc_idx� pg_restore: creando INDEX �public.matrix_structurations_id_idx� pg_restore: creando INDEX �public.matrix_structurations_relations_idx� pg_restore: creando INDEX �public.matrix_structurations_section_id_idx� pg_restore: creando INDEX �public.matrix_structurations_section_tipo_idx� pg_restore: creando INDEX �public.matrix_structurations_section_tipo_section_id_idx� pg_restore: creando INDEX �public.matrix_test_datos_idx� pg_restore: creando INDEX �public.matrix_test_expr_idx� pg_restore: creando INDEX �public.matrix_test_expr_idx1� pg_restore: creando INDEX �public.matrix_test_expr_idx2� pg_restore: creando INDEX �public.matrix_test_expr_idx3� pg_restore: creando INDEX �public.matrix_test_expr_idx4� pg_restore: creando INDEX �public.matrix_test_id_idx� pg_restore: creando INDEX �public.matrix_test_id_idx1� pg_restore: creando INDEX �public.matrix_test_section_id_idx� pg_restore: creando INDEX �public.matrix_time_machine_id_matrix� pg_restore: creando INDEX �public.matrix_time_machine_lang� pg_restore: creando INDEX �public.matrix_time_machine_section_id� pg_restore: creando INDEX �public.matrix_time_machine_section_tipo� pg_restore: creando INDEX �public.matrix_time_machine_state� pg_restore: creando INDEX �public.matrix_time_machine_timestamp� pg_restore: creando INDEX �public.matrix_time_machine_tipo� pg_restore: creando INDEX �public.matrix_time_machine_userID� pg_restore: creando INDEX �public.matrix_users_datos_gin� pg_restore: creando INDEX �public.matrix_users_relations_idx� pg_restore: creando INDEX �public.matrix_users_section_id� pg_restore: creando INDEX �public.matrix_users_section_tipo� pg_restore: creando INDEX �public.matrix_users_section_tipo_section_id� pg_restore: creando INDEX �public.relations_from_component_tipo� pg_restore: creando INDEX �public.relations_section_id� pg_restore: creando INDEX �public.relations_section_tipo� pg_restore: creando INDEX �public.relations_section_tipo_section_id� pg_restore: creando INDEX �public.relations_target_section_id� pg_restore: creando INDEX �public.relations_target_section_id_section_id� pg_restore: creando INDEX �public.relations_target_section_tipo� pg_restore: creando INDEX �public.relations_target_section_tipo_section_tipo� pg_restore: creando INDEX �public.relations_target_section_tipo_target_section_id� PRECAUCI�N: errores ignorados durante la recuperaci�n: 53 pg_restore: creando INDEX �public.matrix_time_machine_id_matrix� pg_restore: creando INDEX �public.matrix_time_machine_lang� pg_restore: creando INDEX �public.matrix_time_machine_section_id� pg_restore: creando INDEX �public.matrix_time_machine_section_tipo� pg_restore: creando INDEX �public.matrix_time_machine_state� pg_restore: creando INDEX �public.matrix_time_machine_timestamp� pg_restore: creando INDEX �public.matrix_time_machine_tipo� pg_restore: creando INDEX �public.matrix_time_machine_userID� pg_restore: creando INDEX �public.matrix_users_datos_gin� pg_restore: creando INDEX �public.matrix_users_relations_idx� pg_restore: creando INDEX �public.matrix_users_section_id� pg_restore: creando INDEX �public.matrix_users_section_tipo� pg_restore: creando INDEX �public.matrix_users_section_tipo_section_id� pg_restore: creando INDEX �public.relations_from_component_tipo� pg_restore: creando INDEX �public.relations_section_id� pg_restore: creando INDEX �public.relations_section_tipo� pg_restore: creando INDEX �public.relations_section_tipo_section_id� pg_restore: creando INDEX �public.relations_target_section_id� pg_restore: creando INDEX �public.relations_target_section_id_section_id� pg_restore: creando INDEX �public.relations_target_section_tipo� pg_restore: creando INDEX �public.relations_target_section_tipo_section_tipo� pg_restore: creando INDEX �public.relations_target_section_tipo_target_section_id� PRECAUCI�N: errores ignorados durante la recuperaci�n: 53

¿Me podrías echar una mano?

Muchas gracias

renderpci commented 5 years ago

Hola, Hi

The question was:

I am trying to install Dédalo in local on xampp and I already have Postgre SQL installed, I have created the database dedalo4_elprattvvideoteca, but when doing the restore of Dédalo database with PgAdmin4, I get this error: .... pg_restore: [archiver (bd)] could not execute query: ERROR: no existe el rol «paco» La orden era: ALTER TYPE public.sino OWNER TO paco; ....

Answer in English:

You can see in the restore command of the database (here in github)that you need change the "rol" with the command ---role in the pg_restore, like:

Example of actual use: pg_restore --host localhost --port 5432 --username "XXX" --dbname "dedalo4_xx" --role "xxx" --no-owner --no-privileges --clean --verbose "/install/db/dedalo4_install.backup"

If you don't change the role, Postgres will need the original has role of the database: paco.

more info about --role: https://www.postgresql.org/docs/current/app-pgrestore.html https://www.postgresql.org/docs/11/role-membership.html http://www.postgresqltutorial.com/postgresql-roles/

I hope that will be clear.

Contestación en castellano:

Puedes ver en el comando de restauración de la base de postgres (aquí en github) que es necesario cambiar el "rol" con el comando --role en el pg_restore:

pg_restore --host localhost --port 5432 --username "XXX" --dbname "dedalo4_xx" --role "xxx" --no-owner --no-privileges --clean --verbose "/install/db/dedalo4_install.backup"

Si no cambias el rol, Postgres necesitará tener el rol original de la BBDD: paco

Espero que esté claro.

Más información acerca de --role (en inglés): https://www.postgresql.org/docs/current/app-pgrestore.html https://www.postgresql.org/docs/11/role-membership.html http://www.postgresqltutorial.com/postgresql-roles/

Best Saludos

lauraprillo commented 5 years ago

Hola Alex,

Gracias por tu anterior respuesta, hemos conseguido hacer el restore pero ahora nos sale este error al cargar Dédalo desde el navegador. Parece que le falte un fichero de log de errores?

Fatal error: Uncaught Exception: Invalid log connection string in C:\xampp\htdocs\prattvvideo\lib\dedalo\logger\class.logger.php:70 Stack trace: #0 C:\xampp\htdocs\prattvvideo\lib\dedalo\config\config4.php(187): logger::register('error', 'file://C:\xampp...') #1 C:\xampp\htdocs\prattvvideo\lib\dedalo\main\index.php(9): require('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\prattvvideo\lib\dedalo\logger\class.logger.php on line 70

Gracias

renderpci commented 5 years ago

Hi/Hola Laura

The question was:

... maybe Dédalo need a log file for errors?

The answer; Yes, Dédalo need a log file outside the code and apache/nginx directories (for security reasons):

if you see the code in the config.php in the line 187 (that you error indicated):

# ERROR LOG FILE 

    # Log aplication errors in file

        # Logs dir (Maintain this directory unaccessible for security)  

        define('DEDALO_LOGS_DIR'  , dirname(dirname(DEDALO_ROOT)) . '/logs');   # !! In production mode log MUST BE out of site 

        # Set file. In production mode log MUST BE out of site

        logger::register('error', 'file://'.DEDALO_LOGS_DIR.'/dedalo_errors.log');  

        # Store object in logger static array var

        logger::$obj['error'] = logger::get_instance('error');

well, first DEDALO_ROOT is declarated in the 25 line of the config.php like:

# Dedalo paths

    define('DEDALO_ROOT', dirname(dirname(dirname(dirname(__FILE__)))));

if the config.php is in the directory:

/dedalo/lib/dedalo/config/config.php

so DEDALO_ROOT in this path is:

/dedalo

so the logs directory is defined like:

# Logs dir (Maintain this directory unaccessible for security)

define('DEDALO_LOGS_DIR'  , dirname(dirname(DEDALO_ROOT)) . '/logs');

so, the DEDALO_LOGS_DIR need to be two directories up in your directory structure:

../../dedalo

and inside this directory is necessary a log directory:

/logs

in other words and with the full path, if you have, for example, Dédalo in one path like:

/my_dedalo_dir/httpdocs/dedalo/lib/dedalo/config/config.php

the log path is:

/my_dedalo_dir/logs

IMPORTANT: think that apache or nginx root folder need to be:

/my_dedalo_dir/httpdocs/

and ONLY PHP can access to the logs folder.

But if you need change the logs folder, you can change the config.php to configure other paths.

I hope that will be clear.

En Castellano:

Sí, Dédalo necesita un archivo de registro fuera de los directorios de código (por razones de seguridad).

Si ves el código en el archivo config.php en la línea 187 (que te indica el error):

# ERROR LOG FILE 

    # Log aplication errors in file

        # Logs dir (Maintain this directory unaccessible for security)  

        define('DEDALO_LOGS_DIR'  , dirname(dirname(DEDALO_ROOT)) . '/logs');   # !! In production mode log MUST BE out of site 

        # Set file. In production mode log MUST BE out of site

        logger::register('error', 'file://'.DEDALO_LOGS_DIR.'/dedalo_errors.log');  

        # Store object in logger static array var

        logger::$obj['error'] = logger::get_instance('error');

Primero DEDALO_ROOT se declara en la línea 25 de config.php como:

# Dedalo paths

    define('DEDALO_ROOT', dirname(dirname(dirname(dirname(__FILE__)))));

Si el archivo config.php está en el directorio:

/dedalo/lib/dedalo/config/config.php

Por tanto DEDALO_ROOT esta en la ruta:

/dedalo

Y el directorio de logs se define como:

# Logs dir (Maintain this directory unaccessible for security)

define('DEDALO_LOGS_DIR'  , dirname(dirname(DEDALO_ROOT)) . '/logs');

Por lo tanto, DEDALO_LOGS_DIR debe estar dos directorios por encima en tu estructura de directorios:

../../dedalo

y dentro de este directorio es necesario un directorio:

/logs

en otras palabras y con la ruta completa, si tienes Dédalo, por ejemplo, en una ruta como:

/my_dedalo_dir/httpdocs/dedalo/lib/dedalo/config/config.php

La ruta para el path del log es:

/my_dedalo_dir/logs

IMPORTANTE: ten en cuenta que Apache o Nginx root directory tiene que apuntar a:

/my_dedalo_dir/httpdocs/

y SÓLO PHP tiene que poder acceder a la carpeta de logs.

Pero si necesitas cambiar la carpeta de logs, puedes cambiar el archivo config.php para configurar otras rutas.

Espero que este claro.

Best Saludos

lauraprillo commented 5 years ago

Hola Alex,

Gracias por la respuesta, hemos creado una subcarpeta de logs en apache y dentro hemos creado un fichero dedalo_errors.log

Haciendo esto nos sigue apareciendo este error:

Fatal error: Uncaught Exception: Invalid log connection string in C:\xampp\htdocs\prattvvideo\lib\dedalo\logger\class.logger.php:70 Stack trace: #0 C:\xampp\htdocs\prattvvideo\lib\dedalo\config\config4.php(188): logger::register('error', 'file://C:\xampp...') #1 C:\xampp\htdocs\prattvvideo\lib\dedalo\main\index.php(9): require('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\prattvvideo\lib\dedalo\logger\class.logger.php on line 70

Hemos printado la variable DEDALO_LOGS_DIR y es esta: C:\xampp/logs

¿Alguna pista de qué podemos mirar?

Muchas gracias

renderpci commented 5 years ago

Hi/Hola Laura

The question was:

... we was created the log file dedalo_errors.log, but the error continue...

Well I think that the problem is the Windows file access with the Dédalo config for read and write the log file.

you can see in your error:

C:\xampp\htdocs\prattvvideo\lib\dedalo\config\config4.php(188): logger::register('error', 'file://C:\xampp...')

the access to the file of the error log is in the path: file://C:\xampp... so I think that you are configure the DEDALO_LOGS_DIR with a absolute path: C:\xampp/logs But the access need to be relative, in other words remove the C:\ in your path, the access need to be: file://xampp...

We are not testing Dédalo in Windows with Xampp, please comment versions for other users.

Castellano:

Creo que el problema está en la configuración de acceso al fichero log en el config de Dédalo y el acceso de lectura/escritura de Windows.

puedes observar en el error que envías:

C:\xampp\htdocs\prattvvideo\lib\dedalo\config\config4.php(188): logger::register('error', 'file://C:\xampp...')

que el acceso al fichero del registro de errores tiene la siguiente ruta: file://C:\xampp... Creo que has configurado la variable DEDALO_LOGS_DIR con un path absoluto: C:\xampp/logs pero el acceso tiene que ser relativo, en otras palabras, quita de la ruta C:\ el acceso necesita ser: file://xampp...

Nosotros no probamos Dédalo sobre Windows, te agradeceríamos si pudieras poner las versiones de Xampp y Windows para otros usuarios.

Gracias / Thanks Alex

renderpci commented 5 years ago

Hi / Hola Laura

We talk with windows / php users and tell me that the problem can be the "file://" inside the config.php line 187:

# Set file. In production mode log MUST BE out of site
        logger::register('error', 'file://'.DEDALO_LOGS_DIR.'/dedalo_errors.log');

maybe you can probe add a "/" to the file://. This is a Windows only problem with PHP. Seems that work different to the UNIX/Linux/MacOs X systems. set this line with:

logger::register('error', 'file:///'.DEDALO_LOGS_DIR.'/dedalo_errors.log');

And appear that in Windows is normal put the C:\ in file statement.... maybe you can probe with or without the "C:\"

please tell me if it is correct.

Castellano

Hemos comentado el problema a usuarios Windows / php y nos dicen que el problema puede estar en "file://" dentro del config.php en la línea 187:

# Set file. In production mode log MUST BE out of site
        logger::register('error', 'file://'.DEDALO_LOGS_DIR.'/dedalo_errors.log');

puedes probara a añadir una barra "/" a "file://". Este es un problema sólo con Windows que parece ser funciona de forma diferente a como funciona en UNIX/Linux/MacOs X. cambia la línea a:

logger::register('error', 'file:///'.DEDALO_LOGS_DIR.'/dedalo_errors.log');

Y parece que en Windows es normal poner "C:\" en los paths.... quizás puedes probar a especificar o no "C:\"

Por favor indícanos si esto es correcto.

Alex

lauraprillo commented 5 years ago

Hola Álex,

Gracias por la respuesta, añadiéndole otra barra a 'file: ///', el error que aparecía, se ha solucionado. Ahora me aparece esto:

Could not connect to database (52):

A qué puede ser debido?

Muchas gracias

renderpci commented 5 years ago

The question was:

I fixed the error adding to the config.php other '/' to 'file:///' but now new error appear: Could not connect to database (52):

Well, the answer seems simple, config the 'config4_db.php' file with your DB configuration.

This error say that Dédalo can't connect to the PostgreSQL, review your configuration.

Castellano:

Parece que no está configurado debidamente el 'config4_db.php', con tu configuración de PostgreSQL.

Este error aparece cuando Dédalo no puede conectarse con PostgreSQL, revisa la configuración.

Alex

lauraprillo commented 5 years ago

Hola Álex,

Como me dijiste, he configurado bien el 'config4_db.php' y ya me da acceso a la base de datos.

Ahora tengo otro problema, en el usuario y la contraseña de inicio, que tengo que poner lo de "root" o "postgres"?

Con la de "root" me sale este error:

Error on init test Error on read or create image <1MB deleted directory. Permission denied

Muchas gracias

renderpci commented 5 years ago

Hi / Hola Laura

The question was:

Now, I have other problem in the init user and password. that I can use "root" or "postage" account?

With the "root" account dédalo show me:

Error on init test Error on read or create image <1MB deleted directory. Permission denied

The answer:

The Postgres account is only for connect Dédalo to the PostgreSQL DataBase (DB), is not a user account, don't use it for login. The "root" account is the "main" user, the Dédalo superuser, that you only need it for config the main admin account. in the first login you need use "root" account because Dédalo don't has any other account by default. So, login with "root" only once and create your specific admin and users accounts, quit and re-login to normal access.

The error: this error appear when Dédalo try to build the media structure in your hard-drive, and say that Dédalo (PHP) don't has acces to it or can't create the media directories.

Review the media directory permissions in your HD. /dedalo/media

Libraries: do you has all OS system libraries ready and running in your system? (ffmpeg, ImageMagick, etc...)

Note: I think that you need evaluated the possibility that use Dédalo with Linux or MacOsX, we don't test it with Windows, almost errors that you are find only appear in Windows and don't happens in Linux (CentOS, Debian, etc), I don't say that Dédalo can't run well in Windows, but I think that it do hard...

Spanish

La cuenta de Postgres sólo se utiliza para que Dédalo se conecte a la Base de Datos, no es una cuenta de usuario, no la uses para iniciar la sesión.

La cuenta de "root" es el usuario principal super-usuario, pero sólo se ha de utilizar para configurar el administrador principal. En el primer login es necesario utilizar la cuenta "root" porque Dédalo no tiene configurada otra cuenta por defecto. Así que , haz el login con "root" sólo una vez y crea tu administrador o usuarios, cierra Dédalo y entra con esas cuentas creadas para tener un acceso normal.

El error: este error aparece cuando Dédalo intenta crear la estructura de directorios en tu disco duro, lo que que indica es que Dédalo (PHP) no puede acceder a esta estructura, o no puede crear los directorios.

Revisa los permisos del directorio media en tu disco duro: /dedalo/media

Librerías: ¿Tienes instaladas y funcionales todas las librerías del sistema? (ffmpeg, ImageMagick,...)

Nota: Creo que tendrías que pensar en utilizar Linux o MacOsX... en Windows no lo hemos probado, casi todos estos errores no ocurren en una instalación Linux (CentOs, Debian,), no digo que Dédalo no pueda ir en Windows, pero creo que es complicarse la vida...

Alex