MuADMINS
Soluciones
Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.
17 soluciones para “DataServer” en Instalación del servidor para MuDevs y para todos los server files · Limpiar
JoinServer and DataServer show Could not connect to database on start.
1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...
✓ Confirmado por el autor del temaTuServerMU · 2017-07-05DataServer 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...
✓ Confirmado por el autor del temaTUServerMU · 2021-06-08Characters 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...
✓ Confirmado por el autor del temaTUServerMU · 2021-03-24JoinServer 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...
✓ Confirmado por el autor del temaTUServerMU · 2018-09-27After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?
1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...
✓ Confirmado por el autor del temaTuServerMU · 2020-05-23ODBC / 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 verifiedEscrito por MuADMINSHow to protect the server from attackers with the firewall
Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...
✓ Confirmado por el autor del temaDarksTeam · 2008-06-30GameServer, DataServer or JoinServer will not start: MSVCR100.dll, MSVCP120.dll or VCRUNTIME140.dll is missing. Which runtime do I install?
1. The number in the DLL name tells the Visual C++ version: 80 = 2005, 90 = 2008, 100 = 2010, 110 = 2012, 120 = 2013, 140 = 2015 to 2026. 2. Download the matching Visual C++ Redistributab...
"Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?
1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...
MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)
The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...
Not verifiedEscrito por MuADMINSGameServer says "Please input authentication server address and port number. => LoginServer connect fail" (Season 3 Episode 1, 1.04H)
The server starter did not pass the JoinServer and DataServer addresses to the GameServer. 1. Open ServerStartUp.ini. 2. Give the JoinServer the parameters /p55970 /ca:ip: /cp55557. 3. Gi...
✓ Confirmado por el autor del temaDarksTeam · 2008-06-03"login server connect fail" when the server starts the GameServer
The confirmed cause was an IP address that was not changed in one of the server configs. 1. Go through the configs of ConnectServer, JoinServer, DataServer and GameServer. 2. Replace ever...
✓ Confirmado por el autor del temaDarksTeam · 2009-11-04I run one server on my VPS and want a second one with its own database on the same VPS, but it does not connect. What must change?
1. Give the second server its own database and create a new ODBC data source pointing to it (same driver, Server = (local), Database = new name). 2. Point the second JoinServer and DataSe...
✓ Confirmado por el autor del temaTuServerMU · 2019-10-09Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedEscrito por MuADMINSPlayers show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)
How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with Con...
Not verifiedEscrito por MuADMINSHow do I open the MU server ports (44405, 55901, 55919 and others) in Windows Firewall quickly and correctly?
1. Open PowerShell as administrator on the server. 2. Create one inbound rule for all TCP ports, for example: New-NetFirewallRule -DisplayName "MU Server" -Direction Inbound -Protocol TCP...
The ODBC data source exists but the server says it cannot find it (64-bit Windows)
64-bit Windows has two ODBC administrators and each keeps its own list of System DSNs. Most MU server programs (JoinServer, DataServer, GameServer) are 32-bit, so they only see data sourc...



