search

ShokoAnime / ShokoServer

Repository for Shoko Server.
http://shokoanime.com/shoko-server/
MIT License
391 stars 75 forks source link

MySQL Database Connection Error on First Installation of Shoko Server #1093

Closed ozgurceozturkce closed 9 months ago

ozgurceozturkce commented 11 months ago

VERSION INFORMATION

Server Version : 4.2.2.0 (WebUI 1.1.12)

Desktop Version : Not used / Not installed

LOG FILE

[2023-11-06 18:38:25:448] Info|Application.OnStartup => App.OnStartup => Startup.Start Initializing Web Hosts... [2023-11-06 18:38:32:860] Info|ServerStartup.ConfigureServices => Loader.AddPlugins => RenameFileHelper.FindRenamers Added Renamer: GroupAwareRenamer - Group Aware Sorter [2023-11-06 18:38:32:860] Info|ServerStartup.ConfigureServices => Loader.AddPlugins => RenameFileHelper.FindRenamers Added Renamer: Legacy - Legacy [2023-11-06 18:38:37:406] Info|Startup.Start => ShokoServer.StartUpServer => Loader.InitPlugins Loading 1 plugins [2023-11-06 18:38:37:421] Info|Startup.Start => ShokoServer.StartUpServer => Loader.InitPlugins Loaded: Shoko Base [2023-11-06 18:38:37:421] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog -------------------- SYSTEM INFO ----------------------- [2023-11-06 18:38:37:433] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog Shoko Server Version: v4.2.2.0 [2023-11-06 18:38:37:433] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog Operating System: [2023-11-06 18:38:38:016] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog MediaInfo 20.3.0.0 (C:\Program Files (x86)\Shoko\Shoko Server\MediaInfo\MediaInfo.exe) [2023-11-06 18:38:38:052] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog RHash 0.0.0.0 (C:\Program Files (x86)\Shoko\Shoko Server\x64\librhash.dll) [2023-11-06 18:38:38:052] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog ------------------------------------------------------- [2023-11-06 18:38:38:052] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog ----------------- SERVER SETTINGS ---------------------- [2023-11-06 18:38:38:052] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.ServerPort: 8111 [2023-11-06 18:38:38:056] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.PluginAutoWatchThreshold: 0.89 [2023-11-06 18:38:38:056] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.CachingDatabaseTimeout: 180 [2023-11-06 18:38:38:056] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.Culture: "en" [2023-11-06 18:38:38:056] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.WebUI_Settings: "" [2023-11-06 18:38:38:056] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.FirstRun: True [2023-11-06 18:38:38:056] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.LegacyRenamerMaxEpisodeLength: 33 [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.LogRotator.Enabled: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.LogRotator.Zip: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.LogRotator.Delete: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.LogRotator.Delete_Days: "" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.MySqliteDirectory: "C:\ProgramData\ShokoServer\SQLite" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.DatabaseBackupDirectory: "C:\ProgramData\ShokoServer\DatabaseBackup" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.DefaultUserUsername: "Default" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.Type: "SQLite" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.Username: "" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.Schema: "" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.Hostname: "" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Database.SQLite_DatabaseFile: "JMMServer.db3" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.Username: null [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.ServerAddress: "api.anidb.net" [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.ServerPort: 9000 [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.ClientPort: 4556 [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.AVDumpClientPort: 4557 [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.DownloadRelatedAnime: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.DownloadSimilarAnime: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.DownloadReviews: False [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.DownloadReleaseGroups: False [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MyList_AddFiles: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MyList_ReadUnwatched: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MyList_ReadWatched: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MyList_SetWatched: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MyList_SetUnwatched: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.DownloadCharacters: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.DownloadCreators: True [2023-11-06 18:38:38:056] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MaxRelationDepth: 3 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.MinimumHoursToRedownloadAnimeInfo: 24 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.AniDb.AutomaticallyImportSeries: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.Enabled: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.Address: "https://localhost:44307" [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.BannedReason: null [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.BannedExpiration: (null) [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.XRefFileEpisode_Get: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.XRefFileEpisode_Send: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.TvDB_Get: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.TvDB_Send: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.Trakt_Get: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.WebCache.Trakt_Send: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoLink: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoFanart: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoFanartAmount: 10 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoWideBanners: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoWideBannersAmount: 10 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoPosters: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.AutoPostersAmount: 10 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TvDB.Language: "en" [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.MovieDb.AutoFanart: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.MovieDb.AutoFanartAmount: 10 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.MovieDb.AutoPosters: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.MovieDb.AutoPostersAmount: 10 [2023-11-06 18:38:38:072] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hasher.MD5: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hasher.SHA1: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hasher.CRC: True [2023-11-06 18:38:38:072] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hasher.ForceGeneratesAllHashes: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.VideoExtensions: ["MKV","AVI","MP4","MOV","OGM","WMV","MPG","MPEG","MK3D","M4V"] [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Exclude: ["[\\\/]\$RECYCLE\.BIN[\\\/]","[\\\/]\.Recycle\.Bin[\\\/]","[\\\/]\.Trash-\d+[\\\/]"] [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.RunOnStart: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.MaxAutoScanAttemptsPerFile: 15 [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.ScanDropFoldersOnStart: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hash_CRC32: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hash_MD5: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.Hash_SHA1: False [2023-11-06 18:38:38:072] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.UseExistingFileWatchedStatus: True [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.AutomaticallyDeleteDuplicatesOnImport: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.FileLockChecking: True [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.AggressiveFileLockChecking: True [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.FileLockWaitTimeMS: 4000 [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.AggressiveFileLockWaitTimeSeconds: 8 [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.SkipDiskSpaceChecks: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.RenameThenMove: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.RenameOnImport: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.MoveOnImport: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.MediaInfoPath: null [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Import.MediaInfoTimeoutMinutes: 5 [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plex.ThumbnailAspects: "Default, 0.6667, IOS, 1.0, Android, 1.3333" [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plex.Libraries: [] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plex.Server: "" [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plugins.EnabledPlugins: {} [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plugins.Priority: [] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plugins.EnabledRenamers: {} [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plugins.RenamerPriorities: {} [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plugins.Settings: [] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Plugins.DeferOnError: False [2023-11-06 18:38:38:087] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.AutoGroupSeries: False [2023-11-06 18:38:38:087] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.AutoGroupSeriesRelationExclusions: "same setting|character" [2023-11-06 18:38:38:087] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.AutoGroupSeriesUseScoreAlgorithm: False [2023-11-06 18:38:38:087] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.FileQualityFilterEnabled: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.PreferredTypes: ["SOURCE","RESOLUTION","AUDIOSTREAMCOUNT","SUBSTREAMCOUNT","SUBGROUP","CHAPTER","VIDEOCODEC","AUDIOCODEC","VERSION"] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.PreferredAudioCodecs: ["flac","dca","aac","ac3","wmav2","wmapro","adpcm_ms","mp3","mp2","vp6f"] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.PreferredResolutions: ["2160p","1440p","1080p","720p","480p"] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.PreferredSubGroups: ["fffpeeps","doki","commie","horriblesubs"] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.PreferredVideoCodecs: ["hevc","h264","mpeg4","vc1","flv","mpeg2","mpeg1","vp6f"] [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.Prefer8BitVideo: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.AllowDeletionOfImportedFiles: False [2023-11-06 18:38:38:087] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredTypes: ["SOURCE","CHAPTER","VERSION"] [2023-11-06 18:38:38:087] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredAudioCodecs.Value: ["flac","dca","aac"] [2023-11-06 18:38:38:103] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredAudioStreamCount.Value: 1 [2023-11-06 18:38:38:103] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredResolutions.Value: ["1080p"] [2023-11-06 18:38:38:103] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredSources.Value: ["bd","dvd"] [2023-11-06 18:38:38:103] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredSubGroups.Value: ["horriblesubs"] [2023-11-06 18:38:38:103] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredSubStreamCount.Value: 1 [2023-11-06 18:38:38:103] Info|SettingsProvider.DumpSettings => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.RequiredVideoCodecs.Value: ["hevc","h264"] [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.PreferredSources: ["bd","dvd","tv","www","unknown"] [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.FileQualityPreferences.AllowDeletingFilesWithMissingInfo: False [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.LanguagePreference: ["x-jat","en"] [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.EpisodeLanguagePreference: "" [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.LanguageUseSynonyms: True [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.CloudWatcherTime: 3 [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.ImagesPath: null [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TraktTv.Enabled: False [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.TraktTv.PIN: "" [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.UpdateChannel: "Stable" [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Linux.UID: -1 [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Linux.GID: -1 [2023-11-06 18:38:38:103] Info|SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings => SettingsProvider.DumpSettings Settings.Linux.Permission: 0 [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.TraceLog: False [2023-11-06 18:38:38:103] Info|ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog => SettingsProvider.DumpSettings Settings.SentryOptOut: False [2023-11-06 18:38:38:103] Info|Startup.Start => ShokoServer.StartUpServer => SettingsProvider.DebugSettingsToLog ------------------------------------------------------- [2023-11-06 18:38:38:307] Info|AniDBUDPConnectionHandler..ctor => AniDBUDPConnectionHandler.InitInternal => AniDBSocketHandler.TryConnection Bound to local address: 0.0.0.0:4556 - Port: 4556 (InterNetwork) [2023-11-06 18:38:38:323] Info|AniDBUDPConnectionHandler..ctor => AniDBUDPConnectionHandler.InitInternal => AniDBSocketHandler.TryConnection Bound to remote address: 94.130.237.200 : 9000 [2023-11-06 18:38:38:323] Info|RuntimeMethodHandle.InvokeMethod => AniDBUDPConnectionHandler..ctor => AniDBUDPConnectionHandler.InitInternal starting ping timer... [2023-11-06 18:38:38:323] Warn|Application.OnStartup => App.OnStartup => Startup.Start The Server is NOT STARTED. It needs to be configured via webui or the settings.json [2023-11-06 18:40:13:453] Info|Application.ShutdownImpl => Application.DoShutdown => App.OnExit Exit was Requested. Shutting Down

DESCRIPTION

Hello, Today I wanted to install Shoko Server (version 4.2.2) for the first time but I encountered an error during the installation.

To explain step by step;

Up to this point I had no problems, but after that the problem starts. Although the test connection is successful, when I click "Next", it gives me a "Failed to Connect" error and does not proceed to the next settings. I also verified that it successfully saves the database settings in the configuration file, which was also the case with the old "4.2.0" version. I had the same problem when I tried with Firefox and Edge browsers.

I am using MySQL as a database. I created an empty database and give the user full permissions. I have no problem connecting through the console. As I mentioned above, the test connection is successful only the first time. After that, no matter how many times I try, I get the error in the screenshot.

When I open the developer tools in my browser, I see that the api query sent as XHR to "localhost:8111/api/v3/Init/database/test" throws an error. I guess there is not much information in the logs since I just installed it. I am attaching screenshots in the hope that it will help. I don't think I am making a mistake but please let me know what I am doing wrong. Or tell me what I should do.

My operating system is : Windows Server 2022 Database : MySQL 8.0.33

Note: I have hidden my personal information in the pictures.

Screenshot of a successful first test: shokok_db_con_succ

Then the screenshot when I click on the "Next" button: shokok_db_con_err

Developer tools screenshot: (shokok_ffx_dev_bad_req.png) shokok_ffx_dev_bad_req

da3dsoul commented 11 months ago

Bad Request, huh? I'll see if I can spot anything

da3dsoul commented 11 months ago

I pushed a probable fix. Try updating to daily after a few minutes from this post

ozgurceozturkce commented 11 months ago

Hello again, first of all thank you for your interest. I made another attempt around 19:25 (UTC+0) and the result seems to be the same for now. As you said, I will try every day at random intervals until I get a positive result. If the result is positive, I will let you know here. If it continues like this for 1-2 weeks, then I will stop trying and uploading. Regards and good work.

da3dsoul commented 11 months ago

Oh, sorry, by "daily", I was referring to the release channel of Shoko Server. On docker, you change the tag from latest to daily On windows, you can get it here: https://shokoanime.com/files/shoko-server/daily/ShokoServer.zip

Serneum commented 10 months ago

I just wanted to add that I was running into this as well (but with MariaDB) and switching to daily worked for me