[DiscordArchive] whats their sha_pass_hash length?
[DiscordArchive] whats their sha_pass_hash length?
Original source
As i see
rektbyfaith
06-10-2024, 09:56 AM #11Archived author: Whatifeel • Posted: 2024-06-10T09:56:29.926000+00:00
Original source
As i see
Original source
the code that is crashing for you is migrating old sha_pass_hash to new columns salt and verifier
rektbyfaith
06-10-2024, 09:56 AM #12Archived author: Tea • Posted: 2024-06-10T09:56:55.161000+00:00
Original source
the code that is crashing for you is migrating old sha_pass_hash to new columns salt and verifier
Original source
if you just drop it then accounts that didnt get converted will not be able to log in (but i think that with lenghts like 39 they couldnt log in anyway)
rektbyfaith
06-10-2024, 09:57 AM #13Archived author: Tea • Posted: 2024-06-10T09:57:31.720000+00:00
Original source
if you just drop it then accounts that didnt get converted will not be able to log in (but i think that with lenghts like 39 they couldnt log in anyway)
Original source
you would only get 39 if your code tried to use 3.3.5 hash calculation AND on top of that removed a 0 at front
rektbyfaith
06-10-2024, 09:58 AM #14Archived author: Tea • Posted: 2024-06-10T09:58:14.005000+00:00
Original source
you would only get 39 if your code tried to use 3.3.5 hash calculation AND on top of that removed a 0 at front
Original source
So i need to change gmp as i understand
rektbyfaith
06-10-2024, 09:58 AM #15Archived author: Whatifeel • Posted: 2024-06-10T09:58:55.861000+00:00
Original source
So i need to change gmp as i understand
Original source
But how then is it best to get out of this situation? Suppose I redo gmp, but bnetserver won't start. I have a small non-commercial DF server that's been running since December 2022. I don't think all players will go to restore their password just to get bnetserver up and running
rektbyfaith
06-10-2024, 10:00 AM #16Archived author: Whatifeel • Posted: 2024-06-10T10:00:23.591000+00:00
Original source
But how then is it best to get out of this situation? Suppose I redo gmp, but bnetserver won't start. I have a small non-commercial DF server that's been running since December 2022. I don't think all players will go to restore their password just to get bnetserver up and running
Original source
So i need just convert data with mass query update or smh like that in order to run bnetserver
rektbyfaith
06-10-2024, 10:01 AM #17Archived author: Whatifeel • Posted: 2024-06-10T10:01:14.582000+00:00
Original source
So i need just convert data with mass query update or smh like that in order to run bnetserver
Original source
sec
rektbyfaith
06-10-2024, 10:01 AM #18Archived author: Tea • Posted: 2024-06-10T10:01:19.349000+00:00
Original source
sec
Original source
`SELECT id, email, LENGTH(sha_pass_hash) FROM battlenet_accounts WHERE LENGTH(sha_pass_hash) != 64 AND (salt IS null OR verifier IS NULL)`
rektbyfaith
06-10-2024, 10:02 AM #19Archived author: Tea • Posted: 2024-06-10T10:02:04.141000+00:00
Original source
`SELECT id, email, LENGTH(sha_pass_hash) FROM battlenet_accounts WHERE LENGTH(sha_pass_hash) != 64 AND (salt IS null OR verifier IS NULL)`
Original source
those are the broken accounts
rektbyfaith
06-10-2024, 10:02 AM #20Archived author: Tea • Posted: 2024-06-10T10:02:08.371000+00:00
Original source
those are the broken accounts
1 Guest(s)
1 Guest(s)