Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir
← Todas as soluções
Configuração do servidorIGCNS9, S12, S16, S17, S18

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

Escrita pelo MuADMINS a partir da 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.

Escrito pelo MuADMINS
Isso ajudou?

Ainda com problema? Buscar no MuGPS Pergunte ao Assistente MU

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.