|
PvPGN Community Forums |
You are not logged in. Please login or register.
forums.pvpgn.pro → [EN] Tech Support → SRP3 Support
Hello,
Is SRP3 supposed to work out of the box by just using a w3l compiled with SRP3?
Right now with the latest PvPGN retrieved from appveyor (f0cf0124 - 1.99.7.645) and the w3l loader compiled with SRP3 support, every account created cannot login afterwards (error reported: "got wrong client password proof").
It works fine with the non-SRP3 version.
Warcraft version is v1.27b.
It should work out of the box
https://github.com/pvpgn/pvpgn-server/c … a8b3603eec
Check your database. There are values acct_salt and acct_verifier used if user logs in with SRP loader. Or acct_passhash1 with normal loader.
I don't have those columns in the database: acct_salt / acct_verifier (I'm using the MySQL build by the way).
Upon creating the account, using the SRP3 version of loader, it's the acct_passhash1 that is filled.
Are they supposed to be created when launching PvPGN for the first time or are they created once an account is first being made?
These columns should be created on demand.
You can enable max detailed loglevel and see what's happened in logs.
Just in case there was something wrong with the version I compiled, I used an already compiled loader, but got the same result.
I've enabled every level of log, it doesn't even try to create those new columns.
Here's the report with a generic account:
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_authreq109: [556] CLIENT_AUTHREQ_109 ticks=0x0619d123, verstr=1.27.1.173 exeinfo="war3.exe 12/09/16 06:05:09 515048" versionid=0x0000001b gameversion=0x011b01ad checksum=0xc2937d79
Sep 24 13:15:48 [info ] pvpgn::bnetd::versioncheck_validate: no match in list, setting to: W3XP
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_authreq109: [556] unable to test client, allowing anyway
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_authreq109: [556] client matches versiontag "W3XP"
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_authreq109: [556] no upgrade for W3XP is available
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_fileinforeq: [556] file requested: "termsofservice.txt" - type = 0x01
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_fileinforeq: [556] file requested: "newaccount.txt" - type = 0x02
Sep 24 13:15:48 [info ] pvpgn::bnetd::_client_fileinforeq: [556] file requested: "chathelp-war3.txt" - type = 0x03
Sep 24 13:15:49 [debug] pvpgn::bnetd::handle_udp_packet: [308] got UDPTEST packet from 10.8.0.10:6112 (myself?)
Sep 24 13:15:49 [info ] pvpgn::bnetd::_client_fileinforeq: [556] file requested: "bnserver-WAR3.ini" - type = 0x05
Sep 24 13:16:10 [debug] pvpgn::bnetd::_client_createaccountw3: [556] new account requested for "test"
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_read_account: SELECT uid FROM pvpgn_BNET WHERE username='test'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: SELECT count(*) FROM pvpgn_BNET WHERE username='test'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: DELETE FROM pvpgn_BNET WHERE uid = '1'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: INSERT INTO pvpgn_BNET (uid,username) VALUES('1','test')
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: DELETE FROM pvpgn_profile WHERE uid = '1'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: INSERT INTO pvpgn_profile (uid) VALUES('1')
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: DELETE FROM pvpgn_Record WHERE uid = '1'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: INSERT INTO pvpgn_Record (uid) VALUES('1')
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: DELETE FROM pvpgn_friend WHERE uid = '1'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_create_account: INSERT INTO pvpgn_friend (uid) VALUES('1')
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_read_attrs: SELECT * FROM pvpgn_BNET WHERE uid='1'
Sep 24 13:16:10 [trace] db_set: UPDATE pvpgn_BNET SET acct_ctime = '1506251770' WHERE uid = '1'
Sep 24 13:16:10 [trace] pvpgn::bnetd::sql_write_attrs: ALTER TABLE pvpgn_BNET ADD COLUMN acct_ctime VARCHAR(128)
Sep 24 13:16:10 [trace] db_set: UPDATE pvpgn_BNET SET acct_userid = '1' WHERE uid = '1'
Sep 24 13:16:10 [trace] db_set: UPDATE pvpgn_BNET SET acct_passhash1 = '67452301efcdab8998badcfe10325476c3d2e1f0' WHERE uid = '1'
Sep 24 13:16:10 [trace] db_set: UPDATE pvpgn_BNET SET acct_username = 'test' WHERE uid = '1'
Sep 24 13:16:10 [debug] pvpgn::bnetd::_client_createaccountw3: [556] account createdAnd the login part:
Sep 24 13:37:32 [debug] pvpgn::bnetd::handle_udp_packet: [572] got UDPTEST packet from 10.8.0.10:6112 (myself?)
Sep 24 13:37:32 [info ] pvpgn::bnetd::_client_fileinforeq: [460] file requested: "bnserver-WAR3.ini" - type = 0x05
Sep 24 13:37:42 [trace] pvpgn::bnetd::sql_read_account: SELECT uid FROM pvpgn_BNET WHERE username='test'
Sep 24 13:37:42 [trace] pvpgn::bnetd::sql_read_attrs: SELECT * FROM pvpgn_BNET WHERE uid='1'
Sep 24 13:37:42 [info ] pvpgn::bnetd::_client_loginreqw3: [460] (W3) "test" passed account check
Sep 24 13:37:42 [info ] pvpgn::bnetd::_client_logonproofreq: [460] logon proof requested
Sep 24 13:37:42 [info ] pvpgn::bnetd::_client_logonproofreq: [460] (W3) got wrong client password proof for "test"Sep 24 13:16:10 [trace] db_set: UPDATE pvpgn_BNET SET acct_passhash1 = '67452301efcdab8998badcfe10325476c3d2e1f0' WHERE uid = '1'67452301efcdab8998badcfe10325476c3d2e1f0 is hash of empty password.
https://github.com/pvpgn/pvpgn-server/issues/291
Try the latest w3loader with SRP3
Which is v1.5.1.1 right? If so, I'm up to date.
I've used the last one linked here: https://github.com/w3lh/w3l/wiki
And the one I compiled myself was done using the latest files from the same repo.
I could use the non-SRP3 version really, but starting with a fresh db it seems better to use the native system.
For now I can only suggest you try connection with pvpgn 1.99 and 1.8.5 to check if the problem on pvpgn-pro or w3l side
Both versions can be downloaded from https://github.com/pvpgn/pvpgn-server/releases at the bottom of page.
For now I can only suggest you try connection with pvpgn 1.99 and 1.8.5 to check if the problem on pvpgn-pro or w3l side
Both versions can be downloaded from https://github.com/pvpgn/pvpgn-server/releases at the bottom of page.
It works using the SRP version of the loader and the 1.99-SVN version, filling the "acct_passhash1" column.
So, it works with the latest SRP loader and 1.99-SVN, but does not work with PRO version?
That's right, I used the same loader in both cases and applied the same basic configuration.
Both times, it was the column "acct_passhash1" that was used and it worked with the SVN version, but not with the PRO one.
MySQL build for both of them too.
Can you show logs when you create an account on PvPGN 1.99-SVN?
У меня что-то не работало SPR3 (или как это называется) тоже с PvPGN PRO, всегда писало неверный пароль.
forums.pvpgn.pro → [EN] Tech Support → SRP3 Support
