User Pass
Home Sign Up Contact Log In
Page:
 
Bort
Admin
offline
Link
 
Originally posted by crzyblue
I would like to offer to help bort in reading the logs if he would like... I personally deal with SQL databases and logs all day long. so bort if you need some help send me a PM and drop a log somewhere for me to view and I'll help you sort this out. I would like to help you get this resolved so that you can get to work on the updates for next season.


I'm looking at the Apache access logs, but the IP information is bad because the logging is misconfigured.
 
dkgojackets
offline
Link
 
max: not just accessed, updated from what I read
Last edited Jul 15, 2008 17:27:00
 
Link
 
Originally posted by Maximus Power
Originally posted by crzyblue

Originally posted by Bort


Ok, from what I can tell from the server logs, there were a few POSTs (updates) made to that page (team_energy_tactics.pl?team_id=216) today:

It was viewed a bunch of times too (GETS) though I'm not sure if any of them would have been updates. I'm pretty sure all the forms on that page are POSTs, but I might be mistaken.

(these are game time, MST)
11:45am
12:26pm
12:52.19pm
12:52.20pm

12:53pm


the bolded part is probably where 2 people were editing at once. the second save over took the first now from the log which I've stated
Originally posted by crzyblue



so by that log we can narrow it down to 1 of 4 people.....
Maximus Power, BobJoeJim, dkgojackets, Vanilla Thunder
giveyourcash hasn't logged in since yesterday.
I'm going to put my money on bobjoejim..... just cause of the name.


It had to be 2 people editing.... which 2 I couldn't tell you myself but that would explain the bolded part up top.


My guess is that's VT reloading the page to see what the hell was going on with the tactics, but I can't be sure. It does seem suspicious that the page was accessed that many times around game time.


I was absolutely refreshing the page in frequent intervals.
 
crzyblue
offline
Link
 
Originally posted by Maximus Power
Originally posted by crzyblue

Originally posted by Bort


Ok, from what I can tell from the server logs, there were a few POSTs (updates) made to that page (team_energy_tactics.pl?team_id=216) today:

It was viewed a bunch of times too (GETS) though I'm not sure if any of them would have been updates. I'm pretty sure all the forms on that page are POSTs, but I might be mistaken.

(these are game time, MST)
11:45am
12:26pm
12:52.19pm
12:52.20pm

12:53pm


the bolded part is probably where 2 people were editing at once. the second save over took the first now from the log which I've stated
Originally posted by crzyblue



so by that log we can narrow it down to 1 of 4 people.....
Maximus Power, BobJoeJim, dkgojackets, Vanilla Thunder
giveyourcash hasn't logged in since yesterday.
I'm going to put my money on bobjoejim..... just cause of the name.


It had to be 2 people editing.... which 2 I couldn't tell you myself but that would explain the bolded part up top.


My guess is that's VT reloading the page to see what the hell was going on with the tactics, but I can't be sure. It does seem suspicious that the page was accessed that many times around game time.


IT wasn't ACCESSED TWICE... it was UPDATED twice
 
dkgojackets
offline
Link
 
it seems even stranger that it was updated that many times
 
Bort
Admin
offline
Link
 
Originally posted by Vanilla Thunder
But it doesn't memecache Tactics does it? I thought that was only home and league screens.


No, but clocks might not be synchronized.
 
Maximus Power
offline
Link
 
Originally posted by oldskool
Originally posted by BobJoeJim

Thank you for giving us this information. It at least confirms that this was almost certainly done by someone, rather than just a bug. Hopefully we can figure out what actually happened now... I very much appreciate your effort Bort.

Originally posted by dkgojackets

Pretty sure what it does prove is the game was completely fucked up to give us no chance to win.


lol.


By someone BJJ is referring to someone outside of one of the GMs. Which means our game against BSoDF was completely fucked. We realize it was not Bort's fault, however.
 
Commander
offline
Link
 
Originally posted by Bort
Originally posted by Commander

so we have the times.

is there any way bort can find out when people have logged in, and from what IP? this info would be so clutch.


That's the data I thought I could get from the logs, if they were configured properly. I've never had to actually try and dig through them before for something like this so I never noticed. I only have recent login data in the database.



if you can't check the IP's people log in from, how do you bust multiaccounting players?

and I am guessing the "recent log-in info" won't help us...?

again, thanks for the interest in this problem. we're pretty sure that there is somebody running around CPL now who is capable hacking accounts/screwing over tactics for games, and getting rid of that garbage is a priority for the integrity of the game.
 
Maximus Power
offline
Link
 
Meh, I thought he said he couldn't be sure if any of those were actually updates. My mistake.
 
crzyblue
offline
Link
 
Unfortunately that's the only answer I can give you with the information provided. I have offered my extent of sql databases and logs to help look into with bort, bort has provided as much information as he can. with the information provided it gives you when it got updated. the sims are set to Read-only so it would have had to corrupt a table or database file all together to make it write over it, and it mostlikely had been blank, null, or 0 not 1. Sorry that you guys lost, and the servers from being configured properly but you can see that the tactics got updated quite frequently by you guys before the game.
 
crzyblue
offline
Link
 
Originally posted by Commander
Originally posted by Bort

Originally posted by Commander


so we have the times.

is there any way bort can find out when people have logged in, and from what IP? this info would be so clutch.


That's the data I thought I could get from the logs, if they were configured properly. I've never had to actually try and dig through them before for something like this so I never noticed. I only have recent login data in the database.



if you can't check the IP's people log in from, how do you bust multiaccounting players?

and I am guessing the "recent log-in info" won't help us...?

again, thanks for the interest in this problem. we're pretty sure that there is somebody running around CPL now who is capable hacking accounts/screwing over tactics for games, and getting rid of that garbage is a priority for the integrity of the game.


I grabbed the recent login information that's how I narrowed it down to 4 people instead of 5
 
dkgojackets
offline
Link
 
Originally posted by crzyblue
the tactics got updated quite frequently by you guys before the game.


This is the part that is completely wrong. None of us messed with anything. Why the hell would any of us change the tactics to make us lose?
Last edited Jul 15, 2008 17:33:50
 
crzyblue
offline
Link
 
how is that wrong... look at the log... the log tells all. you may not have done it. VT may not have done it.... but the log says SOMEONE did it.
 
Maximus Power
offline
Link
 
Originally posted by crzyblue
Unfortunately that's the only answer I can give you with the information provided. I have offered my extent of sql databases and logs to help look into with bort, bort has provided as much information as he can. with the information provided it gives you when it got updated. the sims are set to Read-only so it would have had to corrupt a table or database file all together to make it write over it, and it mostlikely had been blank, null, or 0 not 1. Sorry that you guys lost, and the servers from being configured properly but you can see that the tactics got updated quite frequently by you guys before the game.


That's just the point we're trying to make though. The tactics weren't updated by us, and we're trying to figure out who did it.
 
Link
 
Originally posted by crzyblue
Unfortunately that's the only answer I can give you with the information provided. I have offered my extent of sql databases and logs to help look into with bort, bort has provided as much information as he can. with the information provided it gives you when it got updated. the sims are set to Read-only so it would have had to corrupt a table or database file all together to make it write over it, and it mostlikely had been blank, null, or 0 not 1. Sorry that you guys lost, and the servers from being configured properly but you can see that the tactics got updated quite frequently by you guys before the game.


So which one of our guys was brain dead enough to set tactics differnently then we've run for 3 years (they've all been there that long) or had a reason to sabatoge the team?

That's the problem. I would have no issue with thinking this was either intentional or sabatoge if there was ANY possible gain to be had here. There just isn't.
 
Page:
 


You are not logged in. Please log in if you want to post a reply.