search

dbarzin / mercator

Mapping the information system / Cartographie du système d'information
GNU General Public License v3.0
272 stars 43 forks source link

table storage_devices has no column named physical_switch_id (docker install) #817

Closed matt32106 closed 1 month ago

matt32106 commented 1 month ago

Bonjour, lorsque je lance l'install docker, j'ai un message d'erreur :

 SQLSTATE[HY000]: General error: 1 table storage_devices has no column named physical_switch_id (Connection: sqlite, SQL: insert into "storage_devices" ("bay_id", "building_id", "created_at", "deleted_at", "description", "id", "name", "physical_switch_id", "product", "site_id", "updated_at", "vendor", "version") values (3, 2, 2020-06-21 17:30:16, ?, <p>Description du serveur d stockage 1</p>, 1, DiskServer 1, ?, ?, 1, 2020-06-21 17:30:16, ?, ?), (2, 2, 2020-06-21 17:33:51, ?, <p>Main oracle server</p>, 2, Oracle Server, ?, ?, 1, 2020-06-21 17:34:38, ?, ?))

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829

Que faire ?

Ci-dessous le log complet pour situer le problème :

$ docker run -it --rm -e USE_DEMO_DATA=1 -p 8000:80 ghcr.io/dbarzin/mercator:latest                                                                                                                 Unable to find image 'ghcr.io/dbarzin/mercator:latest' locally
latest: Pulling from dbarzin/mercator
94c7366c1c30: Pull complete 
d90ce4000612: Pull complete 
b82f0f5e49b7: Pull complete 
2856bf55ec7b: Pull complete 
48b4b98cd964: Pull complete 
0ea67f8fa3bc: Pull complete 
eb2e168caf17: Pull complete 
29d2c893d07d: Pull complete 
4113c8e28004: Pull complete 
77f1fb28e9b7: Pull complete 
bc7c10fe8374: Pull complete 
eca33ed95493: Pull complete 
e4f4085e5d64: Pull complete 
7211344f1598: Pull complete 
90cbc9b04095: Pull complete 
9c0045fb8b7f: Pull complete 
a4be88cc1dea: Pull complete 
4f4fb700ef54: Pull complete 
b86080aa8f6d: Pull complete 
e22a0d681b56: Pull complete 
e3163d27807b: Pull complete 
cbacdb2323b8: Pull complete 
cd165b020807: Pull complete 
6fd9614b66b0: Pull complete 
67536015797b: Pull complete 
257bf4dac157: Pull complete 
291d084a5cb3: Pull complete 
Digest: sha256:5380452e28d062932bf777b11d70788c17c1338409af7318e463bce81e2e9e60
Status: Downloaded newer image for ghcr.io/dbarzin/mercator:latest
2024-09-13 12:26:38,431 INFO supervisord started with pid 1
2024-09-13 12:26:39,437 INFO spawned: 'migrate' with pid 7
2024-09-13 12:26:39,439 INFO spawned: 'nginx' with pid 8
2024-09-13 12:26:39,440 INFO spawned: 'php' with pid 9
nginx: [warn] the "user" directive makes sense only if the master process runs with super-user privileges, ignored in /etc/nginx/nginx.conf:3
nginx: [warn] duplicate MIME type "text/html" in /etc/nginx/http.d/default.conf:8
2024/09/13 12:26:39 [notice] 8#8: using the "epoll" event method
2024/09/13 12:26:39 [notice] 8#8: nginx/1.24.0
2024/09/13 12:26:39 [notice] 8#8: OS: Linux 6.6.47-1-MANJARO
2024/09/13 12:26:39 [notice] 8#8: getrlimit(RLIMIT_NOFILE): 1073741816:1073741816
2024/09/13 12:26:39 [notice] 8#8: start worker processes
2024/09/13 12:26:39 [notice] 8#8: start worker process 12
2024/09/13 12:26:39 [notice] 8#8: start worker process 13
2024/09/13 12:26:39 [notice] 8#8: start worker process 14
2024/09/13 12:26:39 [notice] 8#8: start worker process 15
2024/09/13 12:26:39 [notice] 8#8: start worker process 16
2024/09/13 12:26:39 [notice] 8#8: start worker process 17
2024/09/13 12:26:39 [notice] 8#8: start worker process 18
2024/09/13 12:26:39 [notice] 8#8: start worker process 19
2024/09/13 12:26:39 [notice] 8#8: start worker process 20
2024/09/13 12:26:39 [notice] 8#8: start worker process 21
2024/09/13 12:26:39 [notice] 8#8: start worker process 22
2024/09/13 12:26:39 [notice] 8#8: start worker process 23
2024/09/13 12:26:39 [notice] 8#8: start worker process 24
2024/09/13 12:26:39 [notice] 8#8: start worker process 25
2024/09/13 12:26:39 [notice] 8#8: start worker process 26
2024/09/13 12:26:39 [notice] 8#8: start worker process 27

   INFO  Preparing database.  

  Creating migration table ......................................... 10ms DONE

   INFO  Running migrations.  

  2016_06_01_000001_create_oauth_auth_codes_table ................... 6ms DONE
  2016_06_01_000002_create_oauth_access_tokens_table ................ 6ms DONE
  2016_06_01_000003_create_oauth_refresh_tokens_table ............... 6ms DONE
  2016_06_01_000004_create_oauth_clients_table ...................... 6ms DONE
  2016_06_01_000005_create_oauth_personal_access_clients_table ...... 3ms DONE
  2019_12_14_000001_create_personal_access_tokens_table ............ 10ms DONE
  2021_05_08_191249_create_activities_table ......................... 7ms DONE
  2021_05_08_191249_create_activity_operation_table ................ 17ms DONE
  2021_05_08_191249_create_activity_process_table .................. 15ms DONE
  2021_05_08_191249_create_actor_operation_table ................... 12ms DONE
  2021_05_08_191249_create_actors_table ............................. 9ms DONE
  2021_05_08_191249_create_annuaires_table ......................... 10ms DONE
  2021_05_08_191249_create_application_blocks_table ................. 8ms DONE
  2021_05_08_191249_create_application_module_application_service_table  13ms DONE
  2021_05_08_191249_create_application_modules_table ................ 7ms DONE
  2021_05_08_191249_create_application_service_m_application_table . 10ms DONE
  2021_05_08_191249_create_application_services_table ............... 7ms DONE
  2021_05_08_191249_create_audit_logs_table ......................... 3ms DONE
  2021_05_08_191249_create_bay_wifi_terminal_table .................. 9ms DONE
  2021_05_08_191249_create_bays_table .............................. 12ms DONE
  2021_05_08_191249_create_buildings_table ......................... 10ms DONE
  2021_05_08_191249_create_database_entity_table ................... 11ms DONE
  2021_05_08_191249_create_database_information_table .............. 11ms DONE
  2021_05_08_191249_create_database_m_application_table ............ 11ms DONE
  2021_05_08_191249_create_databases_table ......................... 14ms DONE
  2021_05_08_191249_create_dhcp_servers_table ...................... 10ms DONE
  2021_05_08_191249_create_dnsservers_table ........................ 11ms DONE
  2021_05_08_191249_create_domaine_ad_forest_ad_table .............. 16ms DONE
  2021_05_08_191249_create_domaine_ads_table ....................... 10ms DONE
  2021_05_08_191249_create_entities_table ........................... 9ms DONE
  2021_05_08_191249_create_entity_m_application_table .............. 14ms DONE
  2021_05_08_191249_create_entity_process_table .................... 12ms DONE
  2021_05_08_191249_create_external_connected_entities_table ........ 9ms DONE
  2021_05_08_191249_create_external_connected_entity_network_table . 10ms DONE
  2021_05_08_191249_create_fluxes_table ............................ 36ms DONE
  2021_05_08_191249_create_forest_ads_table ........................ 18ms DONE
  2021_05_08_191249_create_gateways_table .......................... 11ms DONE
  2021_05_08_191249_create_information_process_table ............... 11ms DONE
  2021_05_08_191249_create_information_table ........................ 7ms DONE
  2021_05_08_191249_create_lan_man_table ............................ 9ms DONE
  2021_05_08_191249_create_lan_wan_table ............................ 9ms DONE
  2021_05_08_191249_create_lans_table ............................... 7ms DONE
  2021_05_08_191249_create_logical_server_m_application_table ....... 9ms DONE
  2021_05_08_191249_create_logical_server_physical_server_table ..... 9ms DONE
  2021_05_08_191249_create_logical_servers_table .................... 7ms DONE
  2021_05_08_191249_create_m_application_process_table ............. 11ms DONE
  2021_05_08_191249_create_m_applications_table .................... 19ms DONE
  2021_05_08_191249_create_macro_processuses_table ................. 10ms DONE
  2021_05_08_191249_create_man_wan_table ........................... 16ms DONE
  2021_05_08_191249_create_mans_table .............................. 12ms DONE
  2021_05_08_191249_create_media_table ............................. 10ms DONE
  2021_05_08_191249_create_network_subnetword_table ................ 10ms DONE
  2021_05_08_191249_create_network_switches_table ................... 7ms DONE
  2021_05_08_191249_create_networks_table ........................... 7ms DONE
  2021_05_08_191249_create_operation_task_table ..................... 9ms DONE
  2021_05_08_191249_create_operations_table ......................... 6ms DONE
  2021_05_08_191249_create_password_resets_table .................... 7ms DONE
  2021_05_08_191249_create_peripherals_table ....................... 15ms DONE
  2021_05_08_191249_create_permission_role_table ................... 10ms DONE
  2021_05_08_191249_create_permissions_table ........................ 4ms DONE
  2021_05_08_191249_create_phones_table ............................ 25ms DONE
  2021_05_08_191249_create_physical_router_vlan_table ..............2024-09-13 12:26:40,448 INFO success: migrate entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2024-09-13 12:26:40,448 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2024-09-13 12:26:40,448 INFO success: php entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
 15ms DONE
  2021_05_08_191249_create_physical_routers_table .................. 17ms DONE
  2021_05_08_191249_create_physical_security_devices_table ......... 15ms DONE
  2021_05_08_191249_create_physical_servers_table .................. 24ms DONE
  2021_05_08_191249_create_physical_switches_table ................. 22ms DONE
  2021_05_08_191249_create_processes_table ......................... 12ms DONE
  2021_05_08_191249_create_relations_table ......................... 13ms DONE
  2021_05_08_191249_create_role_user_table ......................... 13ms DONE
  2021_05_08_191249_create_roles_table .............................. 5ms DONE
  2021_05_08_191249_create_routers_table ............................ 7ms DONE
  2021_05_08_191249_create_security_devices_table ................... 7ms DONE
  2021_05_08_191249_create_sites_table .............................. 7ms DONE
  2021_05_08_191249_create_storage_devices_table ................... 21ms DONE
  2021_05_08_191249_create_subnetworks_table ....................... 18ms DONE
  2021_05_08_191249_create_tasks_table .............................. 7ms DONE
  2021_05_08_191249_create_users_table ............................. 10ms DONE
  2021_05_08_191249_create_vlans_table .............................. 7ms DONE
  2021_05_08_191249_create_wans_table ............................... 5ms DONE
  2021_05_08_191249_create_wifi_terminals_table .................... 24ms DONE
  2021_05_08_191249_create_workstations_table ...................... 22ms DONE
  2021_05_08_191249_create_zone_admins_table ....................... 10ms DONE
  2021_05_08_191251_add_foreign_keys_to_activity_operation_table .... 2ms DONE
  2021_05_08_191251_add_foreign_keys_to_activity_process_table ...... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_actor_operation_table ....... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_annuaires_table ............. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_application_module_application_service_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_application_service_m_application_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_bay_wifi_terminal_table ..... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_bays_table .................. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_buildings_table ............. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_database_entity_table ....... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_database_information_table .. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_database_m_application_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_databases_table ............. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_domaine_ad_forest_ad_table .. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_entity_m_application_table .. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_entity_process_table ........ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_external_connected_entity_network_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_fluxes_table ................ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_forest_ads_table ............ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_information_process_table ... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_lan_man_table ............... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_lan_wan_table ............... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_logical_server_m_application_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_logical_server_physical_server_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_m_application_process_table . 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_m_applications_table ........ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_man_wan_table ............... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_network_subnetword_table .... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_operation_task_table ........ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_peripherals_table ........... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_permission_role_table ....... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_phones_table ................ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_physical_router_vlan_table .. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_physical_routers_table ...... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_physical_security_devices_table  0ms DONE
  2021_05_08_191251_add_foreign_keys_to_physical_servers_table ...... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_physical_switches_table ..... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_processes_table ............. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_relations_table ............. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_role_user_table ............. 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_storage_devices_table ....... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_subnetworks_table ........... 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_wifi_terminals_table ........ 0ms DONE
  2021_05_08_191251_add_foreign_keys_to_workstations_table .......... 0ms DONE
  2021_05_13_180642_add_cidt_criteria ............................. 112ms DONE
  2021_05_19_161123_rename_subnetwork .............................. 17ms DONE
  2021_06_22_170555_add_type ........................................ 7ms DONE
  2021_07_14_071311_create_certificates_table ...................... 17ms DONE
  2021_08_08_125856_config_right .................................... 0ms DONE
  2021_08_11_201624_certificate_application_link .................... 9ms DONE
  2021_08_18_171048_network_redesign ............................... 21ms DONE
  2021_08_20_034757_default_gateway ................................. 4ms DONE
  2021_08_28_152910_cleanup ........................................ 35ms DONE
  2021_09_19_125048_relation-inportance ............................ 14ms DONE
  2021_09_21_161028_add_router_ip ................................... 4ms DONE
  2021_09_22_114706_add_security_ciat .............................. 22ms DONE
  2021_09_23_192127_rename_descrition .............................. 36ms DONE
  2021_09_28_205405_add_direction_to_flows .......................... 5ms DONE
  2021_10_12_210233_physical_router_name_type ....................... 3ms DONE
  2021_10_19_102610_add_address_ip .................................. 7ms DONE
  2021_11_23_204551_add_app_version ................................. 4ms DONE
  2022_02_08_210603_create_cartographer_m_application_table ......... 2ms DONE
  2022_02_22_32654_add_cert_status .................................. 4ms DONE
  2022_02_27_162738_add_functional_referent_to_m_application ........ 4ms DONE
  2022_02_27_163129_add_editor_to_m_application ..................... 4ms DONE
  2022_02_27_192155_add_date_fields_to_m_application ................ 8ms DONE
  2022_02_28_205630_create_m_application_event_table ................ 3ms DONE
  2022_05_02_123756_add_update_to_logical_servers ................... 7ms DONE
  2022_05_18_140331_add_is_external_column_to_entities .............. 6ms DONE
  2022_05_21_103208_add_type_property_to_entities .................. 10ms DONE
  2022_06_27_061444_application_workstation ........................ 24ms DONE
  2022_07_28_105153_add_link_operation_process ...................... 5ms DONE
  2022_08_11_165441_add_vpn_fields ................................. 36ms DONE
  2022_09_13_204845_cert_last_notification .......................... 5ms DONE
  2022_12_17_115624_rto_rpo ......................................... 7ms DONE
  2023_01_03_205224_database_logical_server ......................... 7ms DONE
  2023_01_08_123726_add_physical_link .............................. 85ms DONE
  2023_01_27_165009_add_flux_nature ................................. 7ms DONE
  2023_01_28_145242_add_logical_devices_link ....................... 38ms DONE
  2023_02_09_164940_gdpr ........................................... 30ms DONE
  2023_03_16_123031_create_documents_table ......................... 20ms DONE
  2023_03_22_185812_create_cpe .................................... 119ms DONE
  2023_04_18_123308_add_gdpr_tables ................................ 59ms DONE
  2023_05_29_161406_security_controls_links ........................ 19ms DONE
  2023_06_14_120958_add_physical_address_ip ........................ 22ms DONE
  2023_08_06_100128_add_physicalserver_size ........................ 39ms DONE
  2023_08_07_183714_application_physical_server .................... 10ms DONE
  2023_09_04_111440_add_application_patching ....................... 38ms DONE
  2023_09_26_074104_iot ............................................ 24ms DONE
  2023_10_28_124418_add_cluster .................................... 25ms DONE
  2023_11_30_070804_fix_migration_typo ............................. 16ms DONE
  2024_02_21_085107_application_patching ........................... 11ms DONE
  2024_02_29_134239_patching_attributes ............................ 29ms DONE
  2024_03_14_165211_router_ip_lenght ............................... 17ms DONE
  2024_03_19_195927_contracts ...................................... 67ms DONE
  2024_04_06_161307_nomalization ................................... 27ms DONE
  2024_04_08_105719_network_flow .................................... 5ms DONE
  2024_04_14_072101_add_parent_entity .............................. 12ms DONE
  2024_04_28_075916_normalize_process_name ......................... 19ms DONE
  2024_05_09_180526_improve_network_flow ........................... 32ms DONE
  2024_05_15_212326_routers_log_phys ............................... 26ms DONE
  2024_06_03_165236_add_user ....................................... 14ms DONE
  2024_06_11_060639_external_connnected_entities_desc .............. 16ms DONE
  2024_06_18_125723_link_domain_lservers ............................ 7ms DONE
  2024_08_27_200851_normalize_storage_devices ...................... 22ms DONE
  2024_09_12_094232_add_ldap_columns_to_users_table ................ 17ms DONE

   INFO  Seeding database.  

  Database\Seeders\PermissionsTableSeeder ............................ RUNNING  
  Database\Seeders\PermissionsTableSeeder .......................... 6 ms DONE  

  Database\Seeders\RolesTableSeeder .................................. RUNNING  
  Database\Seeders\RolesTableSeeder ................................ 3 ms DONE  

  Database\Seeders\PermissionRoleTableSeeder ......................... RUNNING  
  Database\Seeders\PermissionRoleTableSeeder ................... 2,459 ms DONE  

  Database\Seeders\UsersTableSeeder .................................. RUNNING  
  Database\Seeders\UsersTableSeeder ................................ 7 ms DONE  

  Database\Seeders\RoleUserTableSeeder ............................... RUNNING  
  Database\Seeders\RoleUserTableSeeder ............................. 4 ms DONE  

  Database\Seeders\DemoMigrationsTableSeeder ......................... RUNNING  
  Database\Seeders\DemoMigrationsTableSeeder ....................... 8 ms DONE  

  Database\Seeders\DemoOauthAuthCodesTableSeeder ..................... RUNNING  
  Database\Seeders\DemoOauthAuthCodesTableSeeder ................... 2 ms DONE  

  Database\Seeders\DemoOauthAccessTokensTableSeeder .................. RUNNING  
  Database\Seeders\DemoOauthAccessTokensTableSeeder ................ 2 ms DONE  

  Database\Seeders\DemoOauthRefreshTokensTableSeeder ................. RUNNING  
  Database\Seeders\DemoOauthRefreshTokensTableSeeder ............... 2 ms DONE  

  Database\Seeders\DemoOauthClientsTableSeeder ....................... RUNNING  
  Database\Seeders\DemoOauthClientsTableSeeder ..................... 2 ms DONE  

  Database\Seeders\DemoOauthPersonalAccessClientsTableSeeder ......... RUNNING  
  Database\Seeders\DemoOauthPersonalAccessClientsTableSeeder ....... 2 ms DONE  

  Database\Seeders\DemoApplicationBlocksTableSeeder .................. RUNNING  
  Database\Seeders\DemoApplicationBlocksTableSeeder ................ 5 ms DONE  

  Database\Seeders\DemoOperationsTableSeeder ......................... RUNNING  
  Database\Seeders\DemoOperationsTableSeeder ....................... 4 ms DONE  

  Database\Seeders\DemoActorsTableSeeder ............................. RUNNING  
  Database\Seeders\DemoActorsTableSeeder ........................... 6 ms DONE  

  Database\Seeders\DemoActorOperationTableSeeder ..................... RUNNING  
  Database\Seeders\DemoActorOperationTableSeeder ................... 4 ms DONE  

  Database\Seeders\DemoZoneAdminsTableSeeder ......................... RUNNING  
  Database\Seeders\DemoZoneAdminsTableSeeder ....................... 4 ms DONE  

  Database\Seeders\DemoAnnuairesTableSeeder .......................... RUNNING  
  Database\Seeders\DemoAnnuairesTableSeeder ........................ 5 ms DONE  

  Database\Seeders\DemoApplicationServicesTableSeeder ................ RUNNING  
  Database\Seeders\DemoApplicationServicesTableSeeder .............. 5 ms DONE  

  Database\Seeders\DemoApplicationModulesTableSeeder ................. RUNNING  
  Database\Seeders\DemoApplicationModulesTableSeeder ............... 5 ms DONE  

  Database\Seeders\DemoAuditLogsTableSeeder .......................... RUNNING  
  Database\Seeders\DemoAuditLogsTableSeeder ........................ 3 ms DONE  

  Database\Seeders\DemoSitesTableSeeder .............................. RUNNING  
  Database\Seeders\DemoSitesTableSeeder ............................ 4 ms DONE  

  Database\Seeders\DemoBuildingsTableSeeder .......................... RUNNING  
  Database\Seeders\DemoBuildingsTableSeeder ........................ 4 ms DONE  

  Database\Seeders\DemoBaysTableSeeder ............................... RUNNING  
  Database\Seeders\DemoBaysTableSeeder ............................. 4 ms DONE  

  Database\Seeders\DemoDhcpServersTableSeeder ........................ RUNNING  
  Database\Seeders\DemoDhcpServersTableSeeder ...................... 2 ms DONE  

  Database\Seeders\DemoFluxesTableSeeder ............................. RUNNING  
  Database\Seeders\DemoFluxesTableSeeder ........................... 3 ms DONE  

  Database\Seeders\DemoForestAdsTableSeeder .......................... RUNNING  
  Database\Seeders\DemoForestAdsTableSeeder ........................ 4 ms DONE  

  Database\Seeders\DemoLansTableSeeder ............................... RUNNING  
  Database\Seeders\DemoLansTableSeeder ............................. 2 ms DONE  

  Database\Seeders\DemoGatewaysTableSeeder ........................... RUNNING  
  Database\Seeders\DemoGatewaysTableSeeder ......................... 2 ms DONE  

  Database\Seeders\DemoMansTableSeeder ............................... RUNNING  
  Database\Seeders\DemoMansTableSeeder ............................. 3 ms DONE  

  Database\Seeders\DemoMediaTableSeeder .............................. RUNNING  
  Database\Seeders\DemoMediaTableSeeder ............................ 2 ms DONE  

  Database\Seeders\DemoLogicalServersTableSeeder ..................... RUNNING  
  Database\Seeders\DemoLogicalServersTableSeeder ................... 2 ms DONE  

  Database\Seeders\DemoNetworkSwitchesTableSeeder .................... RUNNING  
  Database\Seeders\DemoNetworkSwitchesTableSeeder .................. 0 ms DONE  

  Database\Seeders\DemoPasswordResetsTableSeeder ..................... RUNNING  
  Database\Seeders\DemoPasswordResetsTableSeeder ................... 2 ms DONE  

  Database\Seeders\DemoPeripheralsTableSeeder ........................ RUNNING  
  Database\Seeders\DemoPeripheralsTableSeeder ...................... 2 ms DONE  

  Database\Seeders\DemoNetworksTableSeeder ........................... RUNNING  
  Database\Seeders\DemoNetworksTableSeeder ......................... 2 ms DONE  

  Database\Seeders\DemoPhysicalSecurityDevicesTableSeeder ............ RUNNING  
  Database\Seeders\DemoPhysicalSecurityDevicesTableSeeder .......... 2 ms DONE  

  Database\Seeders\DemoRoutersTableSeeder ............................ RUNNING  
  Database\Seeders\DemoRoutersTableSeeder .......................... 0 ms DONE  

  Database\Seeders\DemoEntitiesTableSeeder ........................... RUNNING  
  Database\Seeders\DemoEntitiesTableSeeder ......................... 4 ms DONE  

  Database\Seeders\DemoRelationsTableSeeder .......................... RUNNING  
  Database\Seeders\DemoRelationsTableSeeder ........................ 2 ms DONE  

  Database\Seeders\DemoTasksTableSeeder .............................. RUNNING  
  Database\Seeders\DemoTasksTableSeeder ............................ 4 ms DONE  

  Database\Seeders\DemoVlansTableSeeder .............................. RUNNING  
  Database\Seeders\DemoVlansTableSeeder ............................ 4 ms DONE  

  Database\Seeders\DemoWansTableSeeder ............................... RUNNING  
  Database\Seeders\DemoWansTableSeeder ............................. 2 ms DONE  

  Database\Seeders\DemoMacroProcessusesTableSeeder ................... RUNNING  
  Database\Seeders\DemoMacroProcessusesTableSeeder ................. 4 ms DONE  

  Database\Seeders\DemoProcessesTableSeeder .......................... RUNNING  
  Database\Seeders\DemoProcessesTableSeeder ........................ 4 ms DONE  

  Database\Seeders\DemoCertificatesTableSeeder ....................... RUNNING  
  Database\Seeders\DemoCertificatesTableSeeder ..................... 2 ms DONE  

  Database\Seeders\DemoMApplicationsTableSeeder ...................... RUNNING  
  Database\Seeders\DemoMApplicationsTableSeeder .................... 3 ms DONE  

  Database\Seeders\DemoInformationTableSeeder ........................ RUNNING  
  Database\Seeders\DemoInformationTableSeeder ...................... 4 ms DONE  

  Database\Seeders\DemoDatabasesTableSeeder .......................... RUNNING  
  Database\Seeders\DemoDatabasesTableSeeder ........................ 4 ms DONE  

  Database\Seeders\DemoSubnetworksTableSeeder ........................ RUNNING  
  Database\Seeders\DemoSubnetworksTableSeeder ...................... 2 ms DONE  

  Database\Seeders\DemoDnsserversTableSeeder ......................... RUNNING  
  Database\Seeders\DemoDnsserversTableSeeder ....................... 2 ms DONE  

  Database\Seeders\DemoExternalConnectedEntitiesTableSeeder .......... RUNNING  
  Database\Seeders\DemoExternalConnectedEntitiesTableSeeder ........ 2 ms DONE  

  Database\Seeders\DemoWorkstationsTableSeeder ....................... RUNNING  
  Database\Seeders\DemoWorkstationsTableSeeder ..................... 2 ms DONE  

  Database\Seeders\DemoActivitiesTableSeeder ......................... RUNNING  
  Database\Seeders\DemoActivitiesTableSeeder ....................... 4 ms DONE  

  Database\Seeders\DemoPhysicalServersTableSeeder .................... RUNNING  
  Database\Seeders\DemoPhysicalServersTableSeeder .................. 0 ms DONE  

  Database\Seeders\DemoStorageDevicesTableSeeder ..................... RUNNING  

   Illuminate\Database\QueryException 

  SQLSTATE[HY000]: General error: 1 table storage_devices has no column named physical_switch_id (Connection: sqlite, SQL: insert into "storage_devices" ("bay_id", "building_id", "created_at", "deleted_at", "description", "id", "name", "physical_switch_id", "product", "site_id", "updated_at", "vendor", "version") values (3, 2, 2020-06-21 17:30:16, ?, <p>Description du serveur d stockage 1</p>, 1, DiskServer 1, ?, ?, 1, 2020-06-21 17:30:16, ?, ?), (2, 2, 2020-06-21 17:33:51, ?, <p>Main oracle server</p>, 2, Oracle Server, ?, ?, 1, 2020-06-21 17:34:38, ?, ?))

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕ 
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

      +7 vendor frames 

  8   database/seeders/DemoStorageDevicesTableSeeder.php:21
      Illuminate\Database\Query\Builder::insert()
      +8 vendor frames 

  17  database/seeders/DatabaseSeeder.php:69
      Illuminate\Database\Seeder::call("Database\Seeders\DemoStorageDevicesTableSeeder")

2024-09-13 12:26:45,174 INFO exited: migrate (exit status 0; expected)
[13-Sep-2024 12:26:45] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root
[13-Sep-2024 12:26:45] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
[13-Sep-2024 12:26:45] NOTICE: fpm is running, pid 9
[13-Sep-2024 12:26:45] NOTICE: ready to handle connections
^[[6~^[[5~^[[6~^C2024-09-13 12:45:46,065 WARN received SIGINT indicating exit request
2024-09-13 12:45:46,066 INFO waiting for nginx, php to die
[13-Sep-2024 12:45:46] NOTICE: Terminating ...
[13-Sep-2024 12:45:46] NOTICE: exiting, bye-bye!
2024-09-13 12:45:46,078 INFO stopped: php (exit status 0)
2024/09/13 12:45:46 [notice] 8#8: signal 15 (SIGTERM) received from 1, exiting
2024/09/13 12:45:46 [notice] 15#15: exiting
2024/09/13 12:45:46 [notice] 16#16: exiting
2024/09/13 12:45:46 [notice] 22#22: exiting
2024/09/13 12:45:46 [notice] 14#14: exiting
2024/09/13 12:45:46 [notice] 13#13: exiting
2024/09/13 12:45:46 [notice] 12#12: exiting
2024/09/13 12:45:46 [notice] 24#24: exiting
2024/09/13 12:45:46 [notice] 19#19: exiting
2024/09/13 12:45:46 [notice] 21#21: exiting
2024/09/13 12:45:46 [notice] 26#26: exiting
2024/09/13 12:45:46 [notice] 17#17: exiting
2024/09/13 12:45:46 [notice] 23#23: exiting
2024/09/13 12:45:46 [notice] 20#20: exiting
2024/09/13 12:45:46 [notice] 18#18: exiting
2024/09/13 12:45:46 [notice] 16#16: exit
2024/09/13 12:45:46 [notice] 14#14: exit
2024/09/13 12:45:46 [notice] 15#15: exit
2024/09/13 12:45:46 [notice] 19#19: exit
2024/09/13 12:45:46 [notice] 24#24: exit
2024/09/13 12:45:46 [notice] 12#12: exit
2024/09/13 12:45:46 [notice] 21#21: exit
2024/09/13 12:45:46 [notice] 23#23: exit
2024/09/13 12:45:46 [notice] 17#17: exit
2024/09/13 12:45:46 [notice] 26#26: exit
2024/09/13 12:45:46 [notice] 20#20: exit
2024/09/13 12:45:46 [notice] 18#18: exit
2024/09/13 12:45:46 [notice] 13#13: exit
2024/09/13 12:45:46 [notice] 22#22: exit
2024/09/13 12:45:46 [notice] 25#25: exiting
2024/09/13 12:45:46 [notice] 27#27: exiting
2024/09/13 12:45:46 [notice] 25#25: exit
2024/09/13 12:45:46 [notice] 27#27: exit
2024/09/13 12:45:46 [notice] 8#8: signal 14 (SIGALRM) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 27
2024/09/13 12:45:46 [notice] 8#8: worker process 27 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 26
2024/09/13 12:45:46 [notice] 8#8: worker process 26 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 21
2024/09/13 12:45:46 [notice] 8#8: worker process 21 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 20
2024/09/13 12:45:46 [notice] 8#8: worker process 20 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: worker process 22 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 16
2024/09/13 12:45:46 [notice] 8#8: worker process 16 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 19
2024/09/13 12:45:46 [notice] 8#8: worker process 19 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 14
2024/09/13 12:45:46 [notice] 8#8: worker process 14 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 17
2024/09/13 12:45:46 [notice] 8#8: worker process 17 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 24
2024/09/13 12:45:46 [notice] 8#8: worker process 24 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 23
2024/09/13 12:45:46 [notice] 8#8: worker process 23 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 18
2024/09/13 12:45:46 [notice] 8#8: worker process 18 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 15
2024/09/13 12:45:46 [notice] 8#8: worker process 15 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 29 (SIGIO) received
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 25
2024/09/13 12:45:46 [notice] 8#8: worker process 25 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: signal 17 (SIGCHLD) received from 12
2024/09/13 12:45:46 [notice] 8#8: worker process 12 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: worker process 13 exited with code 0
2024/09/13 12:45:46 [notice] 8#8: exit
2024-09-13 12:45:46,188 INFO stopped: nginx (exit status 0)
dbarzin commented 1 month ago

OK, corrigé ici : https://github.com/dbarzin/mercator/pull/818

matt32106 commented 1 month ago

Ah, si nos éditeurs et intégrateurs payants étaient aussi réactifs... :) Merci Il faut que je recharge le docker ou çà se met à jour ?

dbarzin commented 1 month ago

Il faut recharger le Docker.

matt32106 commented 1 month ago

Merci

siddjellali commented 1 month ago

j'ai le même message d'erreur , dans la dernière version.

2024_08_27_200851_normalize_storage_devices .................... 7.57ms FAIL
2024-10-06T12:01:26.619856137Z 
2024-10-06T12:01:26.619866470Z    Illuminate\Database\QueryException 
2024-10-06T12:01:26.619868303Z 
2024-10-06T12:01:26.619869762Z   SQLSTATE[HY000]: General error: 1 error in table storage_devices after drop column: unknown column "physical_switch_id" in foreign key definition (Connection: sqlite, SQL: alter table "storage_devices" drop column "physical_switch_id")
2024-10-06T12:01:26.620150303Z 
2024-10-06T12:01:26.620163803Z   at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
2024-10-06T12:01:26.623672970Z     821▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
2024-10-06T12:01:26.623690387Z     822▕                 );
2024-10-06T12:01:26.623692095Z     823▕             }
2024-10-06T12:01:26.623693553Z     824▕ 
2024-10-06T12:01:26.623694887Z   ➜ 825▕             throw new QueryException(
2024-10-06T12:01:26.623696678Z     826▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
2024-10-06T12:01:26.623698262Z     827▕             );
2024-10-06T12:01:26.623699553Z     828▕         }
2024-10-06T12:01:26.623700803Z     829▕     }
2024-10-06T12:01:26.623702095Z 
2024-10-06T12:01:26.623703303Z       +9 vendor frames 
2024-10-06T12:01:26.623704720Z 
2024-10-06T12:01:26.623705970Z   10  database/migrations/2024_08_27_200851_normalize_storage_devices.php:22
2024-10-06T12:01:26.623707470Z       Illuminate\Support\Facades\Facade::__callStatic("table")
2024-10-06T12:01:26.623709053Z       +25 vendor frames 
2024-10-06T12:01:26.623710428Z 
2024-10-06T12:01:26.623711637Z   36  artisan:35
2024-10-06T12:01:26.623713012Z       Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
2024-10-06T12:01:26.623714970Z 
2024-10-06T12:01:26.628418095Z 2024-10-06 12:01:26,628 INFO exited: migrate (exit status 0; expected)
2024-10-06T12:01:27.566133637Z [06-Oct-2024 12:01:27] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root
2024-10-06T12:01:27.566170262Z [06-Oct-2024 12:01:27] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
2024-10-06T12:01:27.566173179Z [06-Oct-2024 12:01:27] NOTICE: fpm is running, pid 9
2024-10-06T12:01:27.566534845Z [06-Oct-2024 12:01:27] NOTICE: ready to handle connections
dbarzin commented 1 month ago

C'est un autre problème. Le dernier test d'intégration s'est bien déroulé sans problème : https://github.com/dbarzin/mercator/actions/runs/11201015166/job/31135441721

As-tu fait quelque chose de spécial ? Tu utilises dans Docker ? Avec quel moteur de base de données ?

siddjellali commented 1 month ago

J'ai créé une autre issue https://github.com/dbarzin/mercator/issues/887