Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri
← Tutte le soluzioni
Setup del serverIGCNS9, S12, S16, S17, S18

How do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?

Scritto da MuADMINS a partire dalla fonteNot verified

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 back up MuOnline (and Me_MuOnline if you use it):
BACKUP DATABASE [MuOnline] TO DISK = N'C:\MUBackup\MuOnline_before_md5.bak' WITH INIT;
  1. Open 1. DataServer\IGCDS.ini, section [JoinServer], key PasswordEncryptType:
  • 0 = no MD5, memb__pwd varchar(20)
  • 1 = WZ_MD5, memb__pwd binary(16), only on x86 (32 bit) SQL Server, needs WZ_MD5_MOD.dll
  • 2 = IGC_MD5, memb__pwd varchar(32), md5 of the password as PHP md5() makes it
  • 3 = SHA256, memb__pwd binary(32), uses PasswordEncryptSalt
  1. Check what your database really has:
SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'MEMB_INFO' AND COLUMN_NAME = 'memb__pwd';
  1. For a new server use the matching script from Database\1. Full Scripts: MuOnline_MD5.sql (binary(16)) or MuOnline_without_MD5.sql (varchar(20)), and the same pair for Me_MuOnline. The two files differ only in that one column.
  2. Accounts saved in the old form do not log in after a switch: reset their passwords in the new form (see "IGCN: set a new password for one account in SQL") and make the website use the same mode (WebEngine: none / wzmd5 / phpmd5 / sha256).

Source: IGCN Season 16 and 17 server files, 1. DataServer/IGCDS.ini ([JoinServer] PasswordEncryptType block) and Database/1. Full Scripts (MuOnline_MD5.sql, MuOnline_without_MD5.sql, Me_MuOnline pair); the IGCN 18.2.2.13 suite ships the same files.

Scritto da MuADMINS
Ti è stato utile?

Non hai ancora risolto? Cerca su MuGPS Chiedi all'Assistente MU

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.