Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [EN] Tech Support → SRP3 Support

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 13

1

Topic: 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.

2

Re: SRP3 Support

It should work out of the box.
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.

harpywar.pvpgn.pl/?do=srp

Do not ask for support in PM.

3

Re: SRP3 Support

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?

4

Re: SRP3 Support

These columns should be created on demand.
You can enable max detailed loglevel and see what's happened in logs.

Do not ask for support in PM.

5

Re: SRP3 Support

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 created

And 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"

6

Re: SRP3 Support

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

Do not ask for support in PM.

7

Re: SRP3 Support

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.

8

Re: SRP3 Support

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.

Do not ask for support in PM.

9

Re: SRP3 Support

HarpyWar wrote:

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.

10

Re: SRP3 Support

So, it works with the latest SRP loader and 1.99-SVN, but does not work with PRO version?

Do not ask for support in PM.

11

Re: SRP3 Support

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.

12

Re: SRP3 Support

Can you show logs when you create an account on PvPGN 1.99-SVN?

13

Re: SRP3 Support

У меня что-то не работало SPR3 (или как это называется) тоже с PvPGN PRO, всегда писало неверный пароль.

Posts: 13

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 1 guest, 0 registered users

forums.pvpgn.pro → [EN] Tech Support → SRP3 Support



Generated in 0.108 seconds (90% PHP - 10% DB) with 20 queries