Community AlphaAlpha MUADMINS
TRTürkçe
Giriş yap
MuADMINS'teConfig ScannerDosyalarının zip'ini yükle: rate'ler, droplar, spotlar, limitlerAçMuADMINS'teDiscord'da buluşalımYardım iste, üzerinde çalıştığın şeyleri paylaş ve diğer sunucu sahipleriyle MU hakkında konuş.Aç
← Tüm çözümler
Sunucu kurulumuIGCNS9, S12, S16, S17, S18

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

Kaynaktan yola çıkılarak MuADMINS tarafından yazıldıNot 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.

MuADMINS tarafından yazıldı
Bu işinize yaradı mı?

Hâlâ takıldınız mı? MuGPS'te ara MU Asistanı'na sor

MuADMINS Community Alpha: ücretsiz, topluluk tarafından yapılıyor, aktif geliştirmede.