Overclock.net › Forums › Overclockers Care › Overclock.net Folding@Home Team › Team Competition › Team Competition Stats - Phase 5 LIVE!
New Posts  All Forums:Forum Nav:

Team Competition Stats - Phase 5 LIVE! - Page 112

post #1111 of 1282
Thread Starter 

I know going back to spreadsheets is a short term solution, but it would be nice to find someone who can actually fix the live stats and rather quickly. We need some people who can figure this out.

 

anubis1127, does the database have backups that we can restore it too? Mine does, and I've done it a few times. We may lose some daily totals, but the overall totals won't be affected. I won't be online tonight. I have a side job.

 
HDPC
(15 items)
 
 
CPUMotherboardGraphicsGraphics
AMD Ryzen 7 1700x Asus Prime X370-Pro MSI Hawk Ek GTX 1070 MSI Hawk Ek GTX 1070 
RAMHard DriveHard DriveHard Drive
EVGA DDR4 3200 Kingston SSDNow 120GB WD Green 2TB WD Black 2 TB 
Optical DriveCoolingCoolingCooling
Samsung DVDR Ek Supremacy Evo Blue Edition XSPC RX360 Radiator Swiftech MCP 655b 
CoolingCoolingOSMonitor
EK XSPC Dual Bay Reservoir Windows 10 e-Machine 23" 
KeyboardPowerCaseMouse
OCN Ducky DK9008 G2 Keyboard PC Power & Cooling Silencer 750W Antec Lanboy Air Logitech G400s 
Audio
Realtek HD Audio 
CPUMotherboardGraphicsRAM
Intel i7 2600k Asus Sabertooth P67 EVGA GTX 770 G.Skill Ripjaws X 
Hard DriveCoolingCoolingCooling
Kingston SSDNow 120GB XSPC Rasa Acetal XSPC Pump/Res  Ek GTX 770 
OSMonitorKeyboardPower
Windows 10 Pro Vizio 58" 4k Logitec Wireless Coolmax 600w 
CaseMouseAudio
Antec 300 Logitec Wireless Realtor HD Audio  
  hide details  
Reply
 
HDPC
(15 items)
 
 
CPUMotherboardGraphicsGraphics
AMD Ryzen 7 1700x Asus Prime X370-Pro MSI Hawk Ek GTX 1070 MSI Hawk Ek GTX 1070 
RAMHard DriveHard DriveHard Drive
EVGA DDR4 3200 Kingston SSDNow 120GB WD Green 2TB WD Black 2 TB 
Optical DriveCoolingCoolingCooling
Samsung DVDR Ek Supremacy Evo Blue Edition XSPC RX360 Radiator Swiftech MCP 655b 
CoolingCoolingOSMonitor
EK XSPC Dual Bay Reservoir Windows 10 e-Machine 23" 
KeyboardPowerCaseMouse
OCN Ducky DK9008 G2 Keyboard PC Power & Cooling Silencer 750W Antec Lanboy Air Logitech G400s 
Audio
Realtek HD Audio 
CPUMotherboardGraphicsRAM
Intel i7 2600k Asus Sabertooth P67 EVGA GTX 770 G.Skill Ripjaws X 
Hard DriveCoolingCoolingCooling
Kingston SSDNow 120GB XSPC Rasa Acetal XSPC Pump/Res  Ek GTX 770 
OSMonitorKeyboardPower
Windows 10 Pro Vizio 58" 4k Logitec Wireless Coolmax 600w 
CaseMouseAudio
Antec 300 Logitec Wireless Realtor HD Audio  
  hide details  
Reply
post #1112 of 1282
Quote:
Originally Posted by BWG View Post

I know going back to spreadsheets is a short term solution, but it would be nice to find someone who can actually fix the live stats and rather quickly. We need some people who can figure this out.

anubis1127, does the database have backups that we can restore it too? Mine does, and I've done it a few times. We may lose some daily totals, but the overall totals won't be affected. I won't be online tonight. I have a side job.

This. I'm willing to help get the current live stats back. But what exactly IS the setup?
Seems to me, there's a few pieces:
1) the retrieval of the scores from Stanford
2) the storing of them in a database
3) the front end to view them

What part isn't working right now?
RAWR
(13 items)
 
Home Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i7-4790k msi z97 gaming 7 gtx 760 4gb 32GB GSkill  
Hard DriveHard DriveCoolingOS
Kingston HyperX 3K 120GB SSD Hitachi 2TB Cooler Master Hyper 212+ Windows 8.1 Pro 
MonitorKeyboardPowerCase
Vizio M492-b2 Logitech Wireless  Corsair HX620 NZXT Phantom White 
Mouse
Logitech Wireless 
  hide details  
Reply
RAWR
(13 items)
 
Home Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i7-4790k msi z97 gaming 7 gtx 760 4gb 32GB GSkill  
Hard DriveHard DriveCoolingOS
Kingston HyperX 3K 120GB SSD Hitachi 2TB Cooler Master Hyper 212+ Windows 8.1 Pro 
MonitorKeyboardPowerCase
Vizio M492-b2 Logitech Wireless  Corsair HX620 NZXT Phantom White 
Mouse
Logitech Wireless 
  hide details  
Reply
post #1113 of 1282
Quote:
Originally Posted by hometoast View Post


This. I'm willing to help get the current live stats back. But what exactly IS the setup?
Seems to me, there's a few pieces:
1) the retrieval of the scores from Stanford
2) the storing of them in a database
3) the front end to view them

What part isn't working right now?

I can show you how it is setup later.  Basically there is a php update file that runs a shell script on the Web server, the shell script invokes a ruby script to query Stanford, sort the results, and store them in the db.  The second part of the shell script tells the webserver to run another php file to process and sort the results on the website itself.  I think the part that is not working is the ruby script.

 

We also don't have shell access to the web server to look at logs, or errors.

 

 

[edit]

In the meantime, I am working on getting all the old gdoc spreadsheets updated with the current TC users, and the points added.  Hope to have an update by tonight.


Edited by anubis1127 - 9/18/13 at 7:04am
post #1114 of 1282
Thread Starter 

Just so you know, I have a refresh going every 3 hours on all 3 files just in case a miracle occurs.

 
HDPC
(15 items)
 
 
CPUMotherboardGraphicsGraphics
AMD Ryzen 7 1700x Asus Prime X370-Pro MSI Hawk Ek GTX 1070 MSI Hawk Ek GTX 1070 
RAMHard DriveHard DriveHard Drive
EVGA DDR4 3200 Kingston SSDNow 120GB WD Green 2TB WD Black 2 TB 
Optical DriveCoolingCoolingCooling
Samsung DVDR Ek Supremacy Evo Blue Edition XSPC RX360 Radiator Swiftech MCP 655b 
CoolingCoolingOSMonitor
EK XSPC Dual Bay Reservoir Windows 10 e-Machine 23" 
KeyboardPowerCaseMouse
OCN Ducky DK9008 G2 Keyboard PC Power & Cooling Silencer 750W Antec Lanboy Air Logitech G400s 
Audio
Realtek HD Audio 
CPUMotherboardGraphicsRAM
Intel i7 2600k Asus Sabertooth P67 EVGA GTX 770 G.Skill Ripjaws X 
Hard DriveCoolingCoolingCooling
Kingston SSDNow 120GB XSPC Rasa Acetal XSPC Pump/Res  Ek GTX 770 
OSMonitorKeyboardPower
Windows 10 Pro Vizio 58" 4k Logitec Wireless Coolmax 600w 
CaseMouseAudio
Antec 300 Logitec Wireless Realtor HD Audio  
  hide details  
Reply
 
HDPC
(15 items)
 
 
CPUMotherboardGraphicsGraphics
AMD Ryzen 7 1700x Asus Prime X370-Pro MSI Hawk Ek GTX 1070 MSI Hawk Ek GTX 1070 
RAMHard DriveHard DriveHard Drive
EVGA DDR4 3200 Kingston SSDNow 120GB WD Green 2TB WD Black 2 TB 
Optical DriveCoolingCoolingCooling
Samsung DVDR Ek Supremacy Evo Blue Edition XSPC RX360 Radiator Swiftech MCP 655b 
CoolingCoolingOSMonitor
EK XSPC Dual Bay Reservoir Windows 10 e-Machine 23" 
KeyboardPowerCaseMouse
OCN Ducky DK9008 G2 Keyboard PC Power & Cooling Silencer 750W Antec Lanboy Air Logitech G400s 
Audio
Realtek HD Audio 
CPUMotherboardGraphicsRAM
Intel i7 2600k Asus Sabertooth P67 EVGA GTX 770 G.Skill Ripjaws X 
Hard DriveCoolingCoolingCooling
Kingston SSDNow 120GB XSPC Rasa Acetal XSPC Pump/Res  Ek GTX 770 
OSMonitorKeyboardPower
Windows 10 Pro Vizio 58" 4k Logitec Wireless Coolmax 600w 
CaseMouseAudio
Antec 300 Logitec Wireless Realtor HD Audio  
  hide details  
Reply
post #1115 of 1282
Quote:
Originally Posted by BWG View Post
 

Just so you know, I have a refresh going every 3 hours on all 3 files just in case a miracle occurs.

 

LOL.

post #1116 of 1282
Do you guys think it could something to do with this.

http://folding.stanford.edu/home/blog
    
CPUMotherboardGraphicsGraphics
Intel i7 2600k ASUS P8Z77WS EVGA GTX 980 SC ACX 2.0 EVGA GTX 980 ACX 2.0 
GraphicsRAMPower
EVGA GTX 970 SC ACX 2.0 Mushkin Enhanced Blackline 8GB (2 x 4GB) 240-Pi... FirePower ZX Series 1250W 80Plus Gold 
  hide details  
Reply
    
CPUMotherboardGraphicsGraphics
Intel i7 2600k ASUS P8Z77WS EVGA GTX 980 SC ACX 2.0 EVGA GTX 980 ACX 2.0 
GraphicsRAMPower
EVGA GTX 970 SC ACX 2.0 Mushkin Enhanced Blackline 8GB (2 x 4GB) 240-Pi... FirePower ZX Series 1250W 80Plus Gold 
  hide details  
Reply
post #1117 of 1282
Looks like the EOC site is missing some updates as well.
game rig
(16 items)
 
  
CPUMotherboardGraphicsRAM
i7 2600k Asus P8P67 Pro MSI 7970 2x2GB G Skill Ripjaw X 1600 CL6 
Hard DriveCoolingCoolingCooling
samsung 830 XSPC RX360 XSPC Raystorm EK 7970 
OSMonitorKeyboardPower
Windows 7 LG W2240 Ducky Corsair AX 850 
CaseMouse
Switch 810 Razer Naga 
  hide details  
Reply
game rig
(16 items)
 
  
CPUMotherboardGraphicsRAM
i7 2600k Asus P8P67 Pro MSI 7970 2x2GB G Skill Ripjaw X 1600 CL6 
Hard DriveCoolingCoolingCooling
samsung 830 XSPC RX360 XSPC Raystorm EK 7970 
OSMonitorKeyboardPower
Windows 7 LG W2240 Ducky Corsair AX 850 
CaseMouse
Switch 810 Razer Naga 
  hide details  
Reply
post #1118 of 1282
The collection servers are down. Look for cs on the list.

http://fah-web.stanford.edu/pybeta/serverstat.html
    
CPUMotherboardGraphicsGraphics
Intel i7 2600k ASUS P8Z77WS EVGA GTX 980 SC ACX 2.0 EVGA GTX 980 ACX 2.0 
GraphicsRAMPower
EVGA GTX 970 SC ACX 2.0 Mushkin Enhanced Blackline 8GB (2 x 4GB) 240-Pi... FirePower ZX Series 1250W 80Plus Gold 
  hide details  
Reply
    
CPUMotherboardGraphicsGraphics
Intel i7 2600k ASUS P8Z77WS EVGA GTX 980 SC ACX 2.0 EVGA GTX 980 ACX 2.0 
GraphicsRAMPower
EVGA GTX 970 SC ACX 2.0 Mushkin Enhanced Blackline 8GB (2 x 4GB) 240-Pi... FirePower ZX Series 1250W 80Plus Gold 
  hide details  
Reply
post #1119 of 1282
Quote:
Originally Posted by hertz9753 View Post

Do you guys think it could something to do with this.



http://folding.stanford.edu/home/blog

 


Quote:
The http://foldingforum.org/ forum is currently down for servicing. In particular, we are adding https support for more secure logins to the forum. There will be a DNS change associated with the changes and DNS can take some time to update. Until then, you can access the forum now with https (i.e. at https://foldingforum.org ).

My access to the folding forum was down yesterday but I believe this thread on that forum refers to our current problem.

PS: I'm referring to Stanford, not TC stats.
Edited by msgclb - 9/18/13 at 8:30pm
YGBSM!
(18 items)
 
exTC Folder
(13 items)
 
 
CPUMotherboardGraphicsRAM
Motorola MC6800 SS50 Backplane with support for SS-50 plug in b... MP-C Serial Interface MP-M 8k Ram 
OSMonitorKeyboardPower
Flex CT-64 CT-1024 Terminal 8V 10 Amp 
Other
SWTPC AC-30 Cassette Interface 
  hide details  
Reply
YGBSM!
(18 items)
 
exTC Folder
(13 items)
 
 
CPUMotherboardGraphicsRAM
Motorola MC6800 SS50 Backplane with support for SS-50 plug in b... MP-C Serial Interface MP-M 8k Ram 
OSMonitorKeyboardPower
Flex CT-64 CT-1024 Terminal 8V 10 Amp 
Other
SWTPC AC-30 Cassette Interface 
  hide details  
Reply
post #1120 of 1282

So I was able to spend some time yesterday updating all the old spreadsheets, adding the stats to them from the point to where the TC stats site went down, and the Stanford servers went down yesterday. 

 

I did it all wrong though, but I have accurate totals, it just doesn't play nice with the rest of the spreadsheet.  BWG sent a PM last night that said he was going to work on the stats, so I guess I don't have to worry about it.

 

I do have totals for everyone's numbers up to the 18th when the stanford site went down. 

 

[edit]

 

Took a little time this afternoon, and imported the numbers over from my spreadsheet to zodac's old Team Stats sheet, instead of continuing to do it wrong.

 

A couple minor things need to be touched up, but all the numbers are there up to the 18th, rankings is accurate for teams.

 

Check the 'Old Stats' in the 2nd post of your team's thread, you should see my updates.

 

[edit again]

 

Since the Stanford site stats started working again earlier, and I got an email with new stats for today I went ahead and updated the spreadsheet again.

 

Stats are current as of the Sept 19th 4pm EST update.

 

[edit again]

 

Did some touching up to the team rankings, and category rankings sheets.


Edited by anubis1127 - 9/19/13 at 3:16pm
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Team Competition
Overclock.net › Forums › Overclockers Care › Overclock.net Folding@Home Team › Team Competition › Team Competition Stats - Phase 5 LIVE!