heyo,
a successfull login with a soldier looks like this in the fesl.log
10:42:00 >> : UPDATE gamespy_players SET challenge='hjtnuoyr', authtoken='XfzVC+krBgx4t+kLxYd2wZc3vb5sfTFa6qC+Eb5sfTlqiucX/jte0TlKSGYdWAhw5MPLxYd2QJUDd2wZ8nnHXfzVCe' WHERE id=2
//ID is the soldier you choose10:42:00 OUT TXN=GameSpyPreAuth
challenge=hjtnuoyr
ticket=XfzVC+krBgx4t+kLxYd2wZc3vb5sfTFa6qC+Eb5sfTlqiucX/jte0TlKSGYdWAhw5MPLxYd2QJUDd2wZ8nnHXfzVCe
//encryption for transfer data is set10:42:00 waiting packets....
10:42:00 >> : DELETE FROM srv_info WHERE TIMESTAMPDIFF(SECOND, last_update, NOW()) > 60
10:42:00 available data recive
//sending account/soldier data begins now10:42:00 available data send
10:42:00 192.168.178.20:49906
10:42:00 \lc\1\challenge\UCEDPVEGUX\id\1\final\
10:42:00 ---
10:42:00 login:
10:42:00 challenge: TGISpHoPyaX9maY8OFTh6KN7SyGwpeIf
10:42:00 authtoken: XfzVC+krBgx4t+kLxYd2wZc3vb5sfTFa6qC+Eb5sfTlqiucX/jte0TlKSGYdWAhw5MPLxYd2QJUDd2wZ8nnHXfzVCe
10:42:00 response: 3bc2a4286a3274af06a08c1e3fb1864d
10:42:00 port: -15631
10:42:00 productid: 10709
10:42:00 gamename: stella
10:42:00 namespaceid: 20
10:42:00 sdkrevision: 3
10:42:00 id: 1
10:42:00 ---
10:42:00 >> : SELECT id, email, password, nick, challenge FROM gamespy_players WHERE authtoken='XfzVC+krBgx4t+kLxYd2wZc3vb5sfTFa6qC+Eb5sfTlqiucX/jte0TlKSGYdWAhw5MPLxYd2QJUDd2wZ8nnHXfzVCe'
10:42:00 \lc\2\sesskey\2\proof\33ef3290382febe51e4ef429b98b0239\userid\2\profileid\2\uniquenick\test\lt\yeIvPROSg9QPROSMVIvj5q__\id\1\final\
10:42:00 ---
10:42:07 status: 1
10:42:07 sesskey: 2
10:42:07 statstring: Online
10:42:07 locstring: Battlefield 2142
10:42:07 ---
10:42:07 \bm\100\f\2\msg\|s|1|ss|Room Name|ls|gamename://gsp!gamename/?type=title|ip|0|p|0\final\
//here the mainmenu should have loaded and you have access to BFHUB, Mupltiplayer, Options, Friendlist etc.10:42:07 ---
Please deactivate your firewall/antivirus-firewall combo software for this test, you can later create allow-rules for fesl and mysql server.
I suspect the firewall killing your connections.
Also please check if the soldier is created in the DB, go to
xampp controllpanel, click
"admin" next to mysql.
in your now open browser go to
bf2142-DB, then
"gamespy_players" and look for your soldier name found under the row
"nick".
also, none of you changed the login credentials for fesl to get into the DB?
I mean inside the DB there is a user called bf2142, his password wasnt changed by any of you? Same for the _launch.bat that starts fesl?
To be clear, i dont want you to change them (in this stage) because my guide is a "drag and drop the stuff and it just works" kind.
But you can change them later if you want, you should if you want to go publicserver, but first we need you to get running.
So:
1)I deaactivated my firewall,antivirus,and other connection blocking shit
2)in my bf2142-DB i have in "gamespy_players" slodier name is:"ServerAdmin" under the row
3)i set pass:"pw2142" (default) in _launch.bat too (everything is default)
4)I am using Windows 10 Pro x64
Also,Sorry for disturbing you(if you angry).
MY fesl login server logs:
>> : select * from information_schema.tables where table_name = 'gamespy_players' and table_schema='bf2142' limit 0,1
>> : select * from information_schema.tables where table_name = 'account' and table_schema='bf2142' limit 0,1
>> : select * from information_schema.tables where table_name = 'subaccount' and table_schema='bf2142' limit 0,1
>> : select * from information_schema.tables where table_name = 'srv_info' and table_schema='bf2142' limit 0,1
>> : select * from information_schema.tables where table_name = 'recover_info' and table_schema='bf2142' limit 0,1
>> : UPDATE gamespy_players SET challenge='', authtoken=''
>> : DELETE FROM srv_info
- wait connections on port 27900 (UDP) - stella.available.gamespy.com
- wait connections on port 27900 (UDP) - stella.master.gamespy.com
- wait connections on port 29900 (TCP) - gpcm.gamespy.com (GameSpy v3)
- wait connections on port 28910 (TCP) - stella.ms5.gamespy.com
- wait connections on port 18300 (TCP) - bf2142-pc.fesl.ea.com
>> : DELETE FROM srv_info WHERE TIMESTAMPDIFF(SECOND, last_update, NOW()) > 60
192.168.31.29:2847
waiting packets....
---
IN fsys TXN=Hello
clientString=bf2142-pc
sku=125170
locale=ru
clientPlatform=PC
clientVersion=1.10.112.0
SDKVersion=2.8.0.1.0
protocolVersion=2.0
fragmentSize=2048
OUT TXN=Hello
domainPartition.domain=eagames
messengerIp=0.0.0.0
messengerPort=0
domainPartition.subDomain=battlefield2142-2006
activityTimeoutSecs=0
curTime="Oct-19-2019 16%3a24%3a55 UTC"
theaterIp=0.0.0.0
theaterPort=0
OUT TXN=MemCheck
memcheck.[]=0
type=0
salt=1999533357
waiting packets....
---
IN fsys TXN=MemCheck
result=
waiting packets....
---
IN acct TXN=Login
returnEncryptedInfo=1
name=admin
password=admin
machineId=
macAddr=$0c9d92128e18
>> : SELECT profileid, account, email, password, countryCode FROM account WHERE account='admin' AND password='admin'
OUT TXN=Login
profileId=1
userId=1
displayName=admin
lkey=123456789012345678901234567.
encryptedLoginInfo=11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111
entitledGameFeatureWrappers.0.gameFeatureId=2590
entitledGameFeatureWrappers.0.status=0
entitledGameFeatureWrappers.0.entitlementExpirationDate=
entitledGameFeatureWrappers.0.message=
entitledGameFeatureWrappers.0.entitlementExpirationDays=-1
waiting packets....
---
IN subs TXN=GetEntitlementByBundle
bundleId=REG-PC-BF2142-UNLOCK-1
OUT TXN=GetEntitlementByBundle
localizedMessage=The customer has never had entitlement for this bundle.
errorContainer.[]=0
errorCode=3012
waiting packets....
---
IN subs TXN=GetEntitlementByBundle
bundleId=REG-PC-BF2142-UNLOCK-2
OUT TXN=GetEntitlementByBundle
localizedMessage=The customer has never had entitlement for this bundle.
errorContainer.[]=0
errorCode=3012
waiting packets....
---
IN subs TXN=GetEntitlementByBundle
bundleId=REG-PC-BF2142-UNLOCK-3
OUT TXN=GetEntitlementByBundle
localizedMessage=The customer has never had entitlement for this bundle.
errorContainer.[]=0
errorCode=3012
waiting packets....
---
IN dobj TXN=GetObjectInventory
domainId=eagames
subdomainId=bf2142
partitionKey=online_content
objectIds.[]=1
objectIds.0=bf2142_bp1
OUT TXN=GetObjectInventory
entitlements.[]=0
waiting packets....
---
IN dobj TXN=GetObjectInventory
domainId=cqc
subdomainId=cqc
partitionKey=online_content_cqc
objectIds.[]=1
objectIds.0=bf2142_bp1
OUT TXN=GetObjectInventory
entitlements.[]=0
waiting packets....
---
IN dobj TXN=GetObjectInventory
domainId=eagames
subdomainId=bf2142
partitionKey=online_content
objectIds.[]=1
objectIds.0=bf2142_bp1_beta
OUT TXN=GetObjectInventory
entitlements.[]=0
waiting packets....
---
IN acct TXN=GetSubAccounts
>> : SELECT count(subaccount) FROM subaccount WHERE profileid=1
>> : SELECT subaccount FROM subaccount WHERE profileid=1
OUT TXN=GetSubAccounts
subAccounts.0=ServerAdmin
subAccounts.[]=1
waiting packets....
---
IN acct TXN=LoginSubAccount
name=ServerAdmin
>> : SELECT id, profileid, subaccount FROM subaccount WHERE profileid=1 AND subaccount='ServerAdmin'
OUT TXN=LoginSubAccount
lkey=111111111111111111111111111.
profileId=1
userId=1
waiting packets....
---
IN acct TXN=GetAccount
>> : SELECT account, password, email, countryCode, DOBDay, DOBMonth, DOBYear, zipCode, eaMailFlag, thirdPartyMailFlag FROM account WHERE profileid=1
OUT TXN=GetAccount
name=admin
profileID=1
userId=1
email=admin@admin.admin
countryCode=AS
countryDesc=AS
dobDay=11
dobMonth=11
dobYear=1111
zipCode=
gender=U
eaMailFlag=0
thirdPartyMailFlag=0
waiting packets....
---
IN acct TXN=GameSpyPreAuth
>> : UPDATE gamespy_players SET challenge='oshsuwgg', authtoken='moFa6qiOs/Dd2w5s/Dd2QJ0TlqC+krBgRI1SmoFaa6KyWABgRIVC+krhQJUjt+kLRoFa6qCeUDd2wZ8HX/DdWABABg' WHERE id=1
OUT TXN=GameSpyPreAuth
challenge=oshsuwgg
ticket=moFa6qiOs/Dd2w5s/Dd2QJ0TlqC+krBgRI1SmoFaa6KyWABgRIVC+krhQJUjt+kLRoFa6qCeUDd2wZ8HX/DdWABABg
waiting packets....
---
>> : UPDATE gamespy_players SET challenge='', authtoken='' WHERE id=1
- disconnected
MAYBE i should try it on win 7?(((((