Fresh Setup Database Migrations fails [v1.14.1]

[deB4SH]

Current Behavior

Hi all,
I'm currently running into a setup issue with ptreodactyl in version 1.14.1.
The database is fresh without any setup. Image is provided the credentials via environment variables. The service starts and wants to seed the database but runs into an issue while running migrations.

ln: /var/log/panel/logs: File exists
external vars exist.
Checking if https is required.
Checking if letsencrypt email is set.
No letsencrypt email is set using http config.
Removing the default nginx config
Checking log folder permissions.
Fixing log folder permissions.
Checking database status.
IP_OF_DATABASE_HOST (IP_OF_DATABASE_HOST:3306) open
Migrating and Seeding D.B

   INFO  Preparing database.  

  Creating migration table ...................................... 65.97ms DONE

   INFO  Running migrations.  

  2016_01_23_195641_add_allocations_table ....................... 58.46ms DONE
  2016_01_23_195851_add_api_keys ................................ 55.87ms DONE
  2016_01_23_200044_add_api_permissions ......................... 93.91ms DONE
  2016_01_23_200159_add_downloads .............................. 147.13ms DONE
  2016_01_23_200421_create_failed_jobs_table .................... 70.78ms DONE
  2016_01_23_200440_create_jobs_table .......................... 158.59ms DONE
  2016_01_23_200528_add_locations .............................. 124.91ms DONE
  2016_01_23_200648_add_nodes .................................. 123.36ms DONE
  2016_01_23_201433_add_password_resets ........................ 186.32ms DONE
  2016_01_23_201531_add_permissions ............................. 69.07ms DONE
  2016_01_23_201649_add_server_variables ....................... 105.50ms DONE
  2016_01_23_201748_add_servers ................................ 315.13ms DONE
  2016_01_23_202544_add_service_options ......................... 56.83ms DONE
  2016_01_23_202731_add_service_varibles ........................ 58.11ms DONE
  2016_01_23_202943_add_services ................................ 91.20ms DONE
  2016_01_23_203119_create_settings_table ...................... 162.44ms DONE
  2016_01_23_203150_add_subusers ............................... 172.23ms DONE
  2016_01_23_203159_add_users .................................. 202.67ms DONE
  2016_01_23_203947_create_sessions_table ...................... 276.58ms DONE
  2016_01_25_234418_rename_permissions_column ................... 52.39ms DONE
  2016_02_07_172148_add_databases_tables ....................... 180.20ms DONE
  2016_02_07_181319_add_database_servers_table .................. 59.49ms DONE
  2016_02_13_154306_add_service_option_default_startup ......... 115.56ms DONE
  2016_02_20_155318_add_unique_service_field .................... 83.48ms DONE
  2016_02_27_163411_add_tasks_table ............................. 90.28ms DONE
  2016_02_27_163447_add_tasks_log_table ......................... 94.88ms DONE
  2016_03_18_155649_add_nullable_field_lastrun .................. 28.43ms DONE
  2016_08_30_212718_add_ip_alias ................................ 39.32ms DONE
  2016_08_30_213301_modify_ip_storage_method ................... 109.38ms DONE
  2016_09_01_193520_add_suspension_for_servers .................. 31.00ms DONE
  2016_09_01_211924_remove_active_column ........................ 29.90ms DONE
  2016_09_02_190647_add_sftp_password_storage ................... 31.82ms DONE
  2016_09_04_171338_update_jobs_tables ......................... 169.74ms DONE
  2016_09_04_172028_update_failed_jobs_table .................... 29.48ms DONE
  2016_09_04_182835_create_notifications_table ................. 124.17ms DONE
  2016_09_07_163017_add_unique_identifier ....................... 78.62ms DONE
  2016_09_14_145945_allow_longer_regex_field ................... 181.82ms DONE
  2016_09_17_194246_add_docker_image_column ..................... 29.46ms DONE
  2016_09_21_165554_update_servers_column_name .................. 39.60ms DONE
  2016_09_29_213518_rename_double_insurgency ..................... 6.52ms DONE
  2016_10_07_152117_build_api_log_table ......................... 67.67ms DONE
  2016_10_14_164802_update_api_keys ............................ 187.12ms DONE
  2016_10_23_181719_update_misnamed_bungee ....................... 4.30ms DONE
  2016_10_23_193810_add_foreign_keys_servers ......................... 2s DONE
  2016_10_23_201624_add_foreign_allocations .................... 736.14ms DONE
  2016_10_23_202222_add_foreign_api_keys ....................... 173.81ms DONE
  2016_10_23_202703_add_foreign_api_permissions ................ 337.72ms DONE
  2016_10_23_202953_add_foreign_database_servers ............... 238.99ms DONE
  2016_10_23_203105_add_foreign_databases ...................... 524.32ms DONE
  2016_10_23_203335_add_foreign_nodes .......................... 440.61ms DONE
  2016_10_23_203522_add_foreign_permissions .................... 411.64ms DONE
  2016_10_23_203857_add_foreign_server_variables ............... 875.18ms DONE
  2016_10_23_204157_add_foreign_service_options ................ 395.39ms DONE
  2016_10_23_204321_add_foreign_service_variables .............. 377.98ms DONE
  2016_10_23_204454_add_foreign_subusers ....................... 536.43ms DONE
  2016_10_23_204610_add_foreign_tasks .......................... 208.70ms DONE
  2016_11_04_000949_add_ark_service_option_fixed ................. 4.25ms DONE
  2016_11_11_220649_add_pack_support ........................... 337.95ms DONE
  2016_11_11_231731_set_service_name_unique ..................... 75.93ms DONE
  2016_11_27_142519_add_pack_column ............................ 392.77ms DONE
  2016_12_01_173018_add_configurable_upload_limit ............... 88.64ms DONE
  2016_12_02_185206_correct_service_variables ................... 14.96ms DONE
  2017_01_03_150436_fix_misnamed_option_tag ...................... 4.72ms DONE
  2017_01_07_154228_create_node_configuration_tokens_table ..... 259.16ms DONE
  2017_01_12_135449_add_more_user_data ......................... 216.44ms DONE
  2017_02_02_175548_UpdateColumnNames ................................ 2s DONE
  2017_02_03_140948_UpdateNodesTable ........................... 243.26ms DONE
  2017_02_03_155554_RenameColumns .............................. 561.70ms DONE
  2017_02_05_164123_AdjustColumnNames .......................... 239.02ms DONE
  2017_02_05_164516_AdjustColumnNamesForServicePacks ........... 288.21ms DONE
  2017_02_09_174834_SetupPermissionsPivotTable ................. 534.62ms DONE
  2017_02_10_171858_UpdateAPIKeyColumnNames .................... 251.03ms DONE
  2017_03_03_224254_UpdateNodeConfigTokensColumns .............. 294.06ms DONE
  2017_03_05_212803_DeleteServiceExecutableOption .............. 382.08ms DONE
  2017_03_10_162934_AddNewServiceOptionsColumns ................ 528.98ms DONE
  2017_03_10_173607_MigrateToNewServiceSystem .................... 4.13ms DONE
  2017_03_11_215455_ChangeServiceVariablesValidationRules ....... 73.34ms DONE
  2017_03_12_150648_MoveFunctionsFromFileToDatabase ............. 43.09ms DONE
  2017_03_14_175631_RenameServicePacksToSingluarPacks .......... 275.06ms DONE
  2017_03_14_200326_AddLockedStatusToTable ...................... 36.98ms DONE
  2017_03_16_181109_ReOrganizeDatabaseServersToDatabaseHost .... 274.52ms DONE
  2017_03_16_181515_CleanupDatabasesDatabase ................... 378.98ms DONE
  2017_03_18_204953_AddForeignKeyToPacks ....................... 442.78ms DONE
  2017_03_31_221948_AddServerDescriptionColumn .................. 41.48ms DONE
  2017_04_02_163232_DropDeletedAtColumnFromServers .............. 69.63ms DONE
  2017_04_15_125021_UpgradeTaskSystem .......................... 561.24ms DONE
  2017_04_20_171943_AddScriptsToServiceOptions ................. 188.49ms DONE
  2017_04_21_151432_AddServiceScriptTrackingToServers ........... 25.59ms DONE
  2017_04_27_145300_AddCopyScriptFromColumn .................... 305.35ms DONE
  2017_04_27_223629_AddAbilityToDefineConnectionOverSSLWithDaemonBehindProxy  74.87ms DONE
  2017_05_01_141528_DeleteDownloadTable ......................... 36.49ms DONE
  2017_05_01_141559_DeleteNodeConfigurationTable ................ 37.49ms DONE
  2017_06_10_152951_add_external_id_to_users .................... 87.97ms DONE
  2017_06_25_133923_ChangeForeignKeyToBeOnCascadeDelete ........ 244.71ms DONE
  2017_07_08_152806_ChangeUserPermissionsToDeleteOnUserDeletion  947.24ms DONE
  2017_07_08_154416_SetAllocationToReferenceNullOnServerDelete . 229.01ms DONE
  2017_07_08_154650_CascadeDeletionWhenAServerOrVariableIsDeleted  475.08ms DONE
  2017_07_24_194433_DeleteTaskWhenParentServerIsDeleted ........ 273.30ms DONE
  2017_08_05_115800_CascadeNullValuesForDatabaseHostWhenNodeIsDeleted  214.69ms DONE
  2017_08_05_144104_AllowNegativeValuesForOverallocation ....... 633.01ms DONE
  2017_08_05_174811_SetAllocationUnqiueUsingMultipleFields ...... 85.24ms DONE
  2017_08_15_214555_CascadeDeletionWhenAParentServiceIsDeleted . 255.95ms DONE
  2017_08_18_215428_RemovePackWhenParentServiceOptionIsDeleted . 323.43ms DONE
  2017_09_10_225749_RenameTasksTableForStructureRefactor ........ 30.39ms DONE
  2017_09_10_225941_CreateSchedulesTable ....................... 285.99ms DONE
  2017_09_10_230309_CreateNewTasksTableForSchedules ............ 377.60ms DONE
  2017_09_11_002938_TransferOldTasksToNewScheduler .............. 41.05ms DONE
  2017_09_13_211810_UpdateOldPermissionsToPointToNewScheduleSystem  2.99ms DONE
  2017_09_23_170933_CreateDaemonKeysTable ...................... 566.23ms DONE
  2017_09_23_173628_RemoveDaemonSecretFromServersTable .......... 70.65ms DONE
  2017_09_23_185022_RemoveDaemonSecretFromSubusersTable ........ 105.08ms DONE
  2017_10_02_202000_ChangeServicesToUseAMoreUniqueIdentifier ... 611.85ms DONE
  2017_10_02_202007_ChangeToABetterUniqueServiceConfiguration .. 195.34ms DONE
  2017_10_03_233202_CascadeDeletionWhenServiceOptionIsDeleted .. 269.76ms DONE
  2017_10_06_214026_ServicesToNestsConversion .................. 301.57ms DONE
  2017_10_06_214053_ServiceOptionsToEggsConversion ............. 593.65ms DONE
  2017_10_06_215741_ServiceVariablesToEggVariablesConversion .... 97.85ms DONE
  2017_10_24_222238_RemoveLegacySFTPInformation ................. 89.04ms DONE
  2017_11_11_161922_Add2FaLastAuthorizationTimeColumn .......... 277.28ms DONE
  2017_11_19_122708_MigratePubPrivFormatToSingleKey ............ 334.47ms DONE
  2017_12_04_184012_DropAllocationsWhenNodeIsDeleted ........... 299.65ms DONE
  2017_12_12_220426_MigrateSettingsTableToNewFormat ............ 360.46ms DONE
  2018_01_01_122821_AllowNegativeValuesForServerSwap ........... 310.77ms DONE
  2018_01_11_213943_AddApiKeyPermissionColumns ................. 308.89ms DONE
  2018_01_13_142012_SetupTableForKeyEncryption ................. 335.06ms DONE
  2018_01_13_145209_AddLastUsedAtColumn ........................ 334.72ms DONE
  2018_02_04_145617_AllowTextInUserExternalId .................. 245.94ms DONE
  2018_02_10_151150_remove_unique_index_on_external_id_column ... 45.49ms DONE
  2018_02_17_134254_ensure_unique_allocation_id_on_servers_table  84.53ms DONE
  2018_02_24_112356_add_external_id_column_to_servers_table ..... 89.91ms DONE
  2018_02_25_160152_remove_default_null_value_on_table ......... 167.37ms DONE
  2018_02_25_160604_define_unique_index_on_users_external_id .... 72.06ms DONE
  2018_03_01_192831_add_database_and_port_limit_columns_to_servers_table  74.94ms DONE
  2018_03_15_124536_add_description_to_nodes .................... 47.33ms DONE
  2018_05_04_123826_add_maintenance_to_nodes .................... 35.99ms DONE
  2018_09_03_143756_allow_egg_variables_to_have_longer_values .. 177.44ms DONE
  2018_09_03_144005_allow_server_variables_to_have_longer_values  190.49ms DONE
  2019_03_02_142328_set_allocation_limit_default_null ........... 17.00ms DONE
  2019_03_02_151321_fix_unique_index_to_account_for_host ....... 217.13ms DONE
  2020_03_22_163911_merge_permissions_table_into_subusers ....... 65.08ms DONE
  2020_03_22_164814_drop_permissions_table ...................... 34.49ms DONE
  2020_04_03_203624_add_threads_column_to_servers_table ......... 22.98ms DONE
  2020_04_03_230614_create_backups_table ....................... 304.13ms DONE
  2020_04_04_131016_add_table_server_transfers ................. 287.37ms DONE
  2020_04_10_141024_store_node_tokens_as_encrypted_value ....... 140.63ms FAIL

In Connection.php line 825:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column '`daemonSecret`' in   
  'nodes' (Connection: mariadb, SQL: alter table `nodes` rename column ```dae  
  monSecret``` to `daemon_token`)                                              
                                                                               

In Connection.php line 571:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column '`daemonSecret`' in   
  'nodes'                                                                      
                                                                               

Starting cron jobs.
Starting supervisord.
2026-07-16 12:19:32,617 CRIT Server 'unix_http_server' running without any HTTP authentication checking

Image is build based on Dockerfile provided within the release branch.

Expected Behavior

Migrations are applied without any issue and service starts afterwards.

Steps to Reproduce

• create a new clean database within mariadb
• restart container

Panel Version

1.14.1

Wings Version

NONE

Games and/or Eggs Affected

No response

Docker Image

No response

Error Logs

2020_04_04_131016_add_table_server_transfers ................. 287.37ms DONE
2020_04_10_141024_store_node_tokens_as_encrypted_value ....... 140.63ms FAIL

In Connection.php line 825:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column '`daemonSecret`' in   
  'nodes' (Connection: mariadb, SQL: alter table `nodes` rename column   
  monSecret to `daemon_token`)                                              
                                                                               

In Connection.php line 571:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column '`daemonSecret`' in   
  'nodes'

Is there an existing issue for this?

• I have searched the existing issues before opening this issue. I understand that maintainers may close this issue without communication if I have not provided sufficient information.