MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 40 по запросу “igc.dataserver” в категории «Настройка сервера» · Сбросить
How 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,...
✓ Подтверждено автором темыDarksTeam · 2008-06-30MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config
MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...
✓ Подтверждено автором темыTUServerMU · 2020-07-12After moving from TitansTech to MuEmu, characters roll back on relog: items and position are not saved. The database was converted. What fixed it?
1. Character data is saved by the DataServer, so check that first, not the tables. 2. Do not reuse the DataServer from your old TitansTech files: it did not work with MuEmu. 3. Use the Da...
✓ Подтверждено автором темыTuServerMU · 2017-11-02MSVCP100.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-11What are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
Not verifiedНаписано MuADMINSGameServer, 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...
Files 99B DarksTeam on Windows 7: MuServer startup throws an ODBC error even with the 64-bit ODBC .reg applied. How was it solved?
1. Use the ODBC .reg (or manual DSN) that matches your Windows: 32-bit or 64-bit. 2. Make sure the databases were created or restored in SQL Server. 3. Right click the startup shortcuts (...
✓ Подтверждено автором темыTuServerMU · 2018-06-16Which databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?
IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...
Not verifiedНаписано MuADMINSHow do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?
On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...
Not verifiedНаписано 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...
✓ Подтверждено автором темыDarksTeam · 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...
✓ Подтверждено автором темыDarksTeam · 2009-11-04Two MuEmu S8 servers on one machine: the first works, the second disconnects at login although its ports (55902, 55920, 55961, 55971) are forwarded.
1. Open the router page and check that the forwarding rules for the second server ports are really enabled, not only created. 2. If a rule turns itself off again after a refresh, delete i...
✓ Подтверждено автором темыTuServerMU · 2020-06-17I 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...
✓ Подтверждено автором темыTuServerMU · 2019-10-09MuEmu S6 (KoshGames/Louis) on SQL Server Express 2012: JoinServer says "Could not connect to database" although MuOnline is restored and the .reg files were run.
1. SQL Express installs a named instance, usually SQLEXPRESS, so (local) alone does not reach it. 2. Open the ODBC admin for your Windows bits and create the DSNs by hand. 3. In the serve...
✓ Подтверждено автором темыTuServerMU · 2020-08-08Could 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 verifiedНаписано 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 verifiedНаписано MuADMINSMuDevs 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 verifiedНаписано 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...