Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir
← Toutes les solutions

"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

Rédigé par MuADMINS à partir de la sourceNot verified

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 = MuOnline): open the 32 bit ODBC tool (C:\Windows\SysWOW64\odbcad32.exe) and check the DSN's database. IGCN reads IGCDS.ini [SQL] MeMuOnlineDB (MuOnline or Me_MuOnline).
  2. Is the account really there, spelled the same?
SELECT memb_guid, memb___id, LEN(memb___id) AS len, bloc_code FROM MEMB_INFO WHERE memb___id = 'account1';
  1. Does the password form match the server setting? IGCN PasswordEncryptType 0 = varchar(20), 1 = binary(16), 2 = varchar(32), 3 = binary(32); MuEmu based JoinServer.ini MD5Encryption = 0 means plain text.
SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MEMB_INFO' AND COLUMN_NAME = 'memb__pwd';

A website that saves MD5 into a plain column (or the other way round) creates accounts that never log in.

  1. Is it blocked? bloc_code = 1 is a blocked account in the Louis ban scripts.
  2. Account names longer than the column (memb___id varchar(10) in every MSSQL family we read) cannot exist.
  3. The MuEmu based JoinServer.ini also has CaseSensitive (shipped 0): if someone set it to 1, the name must be typed with the exact upper and lower case.

Source: MEMB_INFO in IGCN S9 to S18, X-Team S2 / S17, MuDevs S18 scripts; JoinServer.ini of Louis V13, MSPro V14, X-Team S17; IGCN IGCDS.ini; Louis S6 Update 11 WZ_DesblocAccount.

Rédigé par MuADMINS
Cela vous a-t-il aidé ?

Toujours bloqué ? Rechercher sur MuGPS Demander à l'Assistant MU

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.