MuADMINS
Giải pháp
Các cách sửa ngắn gọn cho những lỗi thường gặp của server, client và website MU Online, mỗi cách đều kèm nguồn và ngày. “Đã xác nhận” nghĩa là người đặt câu hỏi cho biết cách sửa đã hiệu quả.
42 giải pháp cho “dataserver” · Xóa lọc
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,...
✓ Được người mở chủ đề xác nhậnDarksTeam · 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...
✓ Được người mở chủ đề xác nhậnTUServerMU · 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 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.
✓ Được người mở chủ đề xác nhậnTuServerMU · 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 verifiedDo MuADMINS biên soạnGameServer, 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 (...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-06-16GameServer 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...
✓ Được người mở chủ đề xác nhậnDarksTeam · 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...
✓ Được người mở chủ đề xác nhậnDarksTeam · 2009-11-04Two separate servers (not subservers) both show in the client as server 1 with the same name
The client serverlist file was broken, not the server codes. 1. Replace the client Data serverlist.bmd with a working one (for example from another client of the same version) and edit th...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-06-18Two 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2019-10-09I cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?
1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-01-06MuEmu 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 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 verifiedDo MuADMINS biên soạnPlayers 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 verifiedDo MuADMINS biên soạnMuDevs 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 verifiedDo MuADMINS biên soạnWhich 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 verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạn