Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
ozgurceozturkce opened this issue Nov 6, 2023 · 5 comments
Closed

Comments

@ozgurceozturkce
Copy link

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;

  • I install the application and complete it without any problems.
  • I launch the web interface and the installation screen comes up without errors
  • I enter the relevant settings on the database settings page.
  • I click on the "Test" button and I get the message "Database test successful!".

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
Copy link
Member

da3dsoul commented Nov 6, 2023

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

@da3dsoul
Copy link
Member

da3dsoul commented Nov 6, 2023

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

@ozgurceozturkce
Copy link
Author

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
Copy link
Member

da3dsoul commented Nov 6, 2023

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
Copy link

Serneum commented Dec 5, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants