MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 34 по запросу “joinserver” в категории «Настройка сервера» · Сбросить
Anyone can log in with a random account name and password, and the login creates that account in SQL
1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...
✓ Подтверждено автором темыRaGEZONE · 2021-04-15After 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...
✓ Подтверждено автором темыTuServerMU · 2020-05-23MSVCP100.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...
Client disconnects after choosing the server; the client log shows it connecting to someone else's IP (10.0.0.33, port 55901) with Pinkof Season 2 files
The server files and the client still pointed to the IP of the person who packed them. 1. Put your own IP in the ConnectServer server list config. 2. Put your own IP in the JoinServer con...
✓ Подтверждено автором темыDarksTeam · 2015-02-13I 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-09"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database
Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...
Not verifiedНаписано MuADMINSCould 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Написано MuADMINSHow do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?
Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...
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Написано 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...