MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 208 в категории «Настройка сервера» · Сбросить
OpenMU in Docker on Windows: the client sees the server list but is disconnected when joining a server.
1. Use the client version the server targets (1.04d English, Season 6 E3). 2. Open the ports in the Windows firewall (and allow NAT edge traversal). 3. The connect server hands out the IP...
✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2019-11-12MSVCP100.DLL is missing when starting ConnectServer, DataServer or JoinServer (MuEmu S6 files).
Install the Microsoft Visual C++ 2010 Redistributable (x86, plus x64 on 64 bit Windows). Prefer the Microsoft download over single DLL sites.
✓ Подтверждено автором темыTuServerMU · 2018-06-11The server works on the host PC, but other players cannot get in (MuEmu S8).
1. Exclude main.exe from DEP and add the client folder to the antivirus exceptions. 2. Open the antihack port 55999 in the Windows firewall and in the router. 3. Allow ConnectServer and G...
✓ Подтверждено автором темыTuServerMU · 2017-01-18'You are disconnected from the server' at server select on an Amazon AWS VPS, even with all ports open in the Windows firewall (MuDevs S16 free files).
Open the ports in the AWS console too: Security Groups > pick the right VPC/instance group > add inbound rules for the game ports. AWS blocks inbound traffic by default even when Windows...
✓ Подтверждено автором темыTuServerMU · 2021-04-27DataServer and JoinServer do not connect after running the ODBC file that came with the files
The .reg or .bat ODBC file bundled with many server files does not always create the data source on your Windows. Create it by hand: 1. Open the ODBC Data Source Administrator (on 64-bit...
✓ Подтверждено автором темыTUServerMU · 2021-06-08ODBC test works but JoinServer and DataServer still do not connect (Louis files on a VPS)
The topic starter fixed it by reinstalling SQL Server: it was installed wrong. The helper's diagnosis was a named instance (SQLEXPRESS) while the files expect the default instance. 1. Ope...
✓ Подтверждено автором темыTUServerMU · 2021-04-26Characters do not save and the DataServer log shows State (42S22)
SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...
✓ Подтверждено автором темыTUServerMU · 2021-03-24Nothing is saved in game and editors say the database is read-only
The database that came with a repack can be damaged or incomplete. Here the fix was to use the clean database of the package the files are based on. 1. Download the original package the r...
✓ Подтверждено автором темыTUServerMU · 2024-01-28Client disconnects right after choosing the server (server on a VPS)
The server list shows, so the ConnectServer port is open, but the client is dropped when it moves on to the GameServer: the GameServer port is closed somewhere. 1. Find the GameServer por...
✓ Подтверждено автором темыTUServerMU · 2023-09-16Restoring the MuOnline database fails in SQL Server 2022 (MSPro v17 files)
1. In SQL Server Management Studio right click Databases > Restore Database, choose Device and pick the .bak file that came with the files. 2. Open the Options page. 3. Tick "Overwrite th...
✓ Подтверждено автором темыTUServerMU · 2026-09-27JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)
Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...
✓ Подтверждено автором темыTUServerMU · 2018-10-06JoinServer and DataServer cannot connect to the database although the backup is restored
These files had the database name MuOnlineS6 in the server configs while the database was restored as MuOnline, so the servers looked for a database that does not exist. 1. In SQL Server...
✓ Подтверждено автором темыTUServerMU · 2018-09-27IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)
IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...
Not verifiedНаписано MuADMINSHow do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?
Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...
Not verifiedНаписано MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedНаписано MuADMINSKorean, Cyrillic, Greek or other character names turn into ?? (collation and Unicode in MU databases)
In every MSSQL files family we read, names are VARCHAR: Character.Name varchar(10), AccountCharacter.GameID1 ... varchar(10), Guild.G_Name varchar(8), MEMB_INFO.memb___id varchar(10). A V...
Not verifiedНаписано MuADMINSODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)
MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...
Not verifiedНаписано MuADMINSHow do I back up and restore MU databases: which ones, in which order, and moving to a new PC?
Back up every database of the server at the same moment (server closed), and restore them together: - IGCN: MuOnline, Me_MuOnline (if used), Events, Ranking, BattleCore - MuEmu, Louis, MS...
Not verifiedНаписано MuADMINSWhat breaks a MU server database? Safe SQL checklist before you run a query
What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...
Not verifiedНаписано MuADMINSI changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)
The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...
Not verifiedНаписано MuADMINS