stats

A section to chat about whatever takes your fancy about the team in general. For queries about the UBT Forum, please post a message here. Likewise, any suggestions for making the forum better...
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Woaaa..

"Shut her down Clancy, She's a pumpin mud!!!" has appeared. All hands on deck cap'in!  :shock:

Reported: 18:04 (02/12/2008)


***Editied***
All appears to be ok now
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Ben wrote:Woaaa..

"Shut her down Clancy, She's a pumpin mud!!!" has appeared. All hands on deck cap'in!  :shock:

Reported: 18:04 (02/12/2008)


***Editied***
All appears to be ok now
hmmn, thats the default error message  :?

Do you remember where you were, what you clicked?

If it happened at 18:04 its possible you got it right in the middle of an update but it normally handles that ok
There's nothing unusual in the apache log files around that time

:? :?
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:Do you remember where you were, what you clicked?
I was at college having a look at the stats. Opened up Firefox, clicked on it from the bookmarks and got to that page. Tried refreshing 4 times and got the same message so i left it at that.

Temujin wrote:If it happened at 18:04 its possible you got it right in the middle of an update but it normally handles that ok
Yeah, sometimes i check on the hour, or 1 min past the hour and it has been fine. Probably just a hiccup.

Working fine at the moment
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

New project colours as defined here

thanks Darren
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

A few little mods to report, all on the graphs popup

1. There is now a "period summary" area map on each of the 3 combined graphs. Place your mouse where it says "Last 24 Hours Combined...." and a new summary will popup showing the total and percentage of period total for each project in that time period.

2. The projects table (at the bottom) now has its own graph links. So from any graph page, you can now get to the graphs for any other project (or combined).
(Test pages only)

3. On the hour/day mouseover popup, the project colour images have been combined into 1 image. It really annoyed me how long they took to load, so its now 1 image rather than 80+

And it would be really nice if someone could fix Bens post :roll:
[admin]Fixed[/admin]
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:And it would be really nice if someone could fix Bens post :roll:

Ooo err... I'd correct it if i knew what it was  :?

But, as usual nice work John! It is defiantly better  :)
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

The dreaded power cut struck again at just after 1am this morning :evil:

My machine recovered like its meant to but it looks like my router has got screwed up somehow. At home i can browse out etc but as you've probably already noticed, outside can't get in.

It'll have to wait till I get home tonight.
Sorry about that
Rockinfroggi
Posts: 1434
Joined: Tue Jan 09, 2007 12:00 am

Post by Rockinfroggi »

Ahh, so you're the reason I can't view your stats, knew it had to be something else after rebooting my PC and router  :shock:

Gary.
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

back up again :thumbup:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

I'll be taking my stats machine down after the 9pm update tonight, to give it a damned good seeing to with a vacuum cleaner cos its been running a bit hot.

It should go down at about 9.15 and be back up as soon as I'm done.
Assuming I don't mangle a fan or summat of course :roll:

edit
all back again and its running 15C cooler
:thumbup:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Hi all

I'm posting this from work cos I've got adsl problems at home, so no stats till its fixed :(

Demon reckon everything is ok and the fault is at my end :roll:
I've replaced the router, just about to replace the filter, after that ?????

John


edit
hmmn :?
it's been down for 5 hours or so and has just decided to work again :?
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Temujin wrote:I'm posting this from work cos I've got adsl problems at home, so no stats till its fixed :(

edit
hmmn :?
it's been down for 5 hours or so and has just decided to work again :?
and another hmmn :?
my ADSL was down for 5 hours again tonight :evil:

sorry about that, I've no idea what's going on  :shock:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Oops
my database server just overheated and locked up for 3 hours :shock:

I guess I'll be giving it a spring clean tomorrow night
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Hi all :wave:

Sorry chaps, it looks like my router was taken out by a thunderstorm on Saturday night.  
I didn't get back until 7pm last night so it'll be tonight before it's back up again
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

1 new netgear router and we're back up :thumbup:
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

Temujin wrote:1 new netgear router and we're back up :thumbup:
Still seems to be out John.
Hope you haven`t had another strike!  :lol:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

UBT - Rick Horn wrote:
Temujin wrote:1 new netgear router and we're back up :thumbup:
Still seems to be out John.
Hope you haven`t had another strike!  :lol:
huh ???

I'm using it right now, is it still not working?


edit
aww gawd, gotta re-setup all my firewall rules
it should be there soon
Joshrandom
Posts: 5602
Joined: Sat Jun 23, 2007 1:00 am

Post by Joshrandom »

It's working fine for me.  :D
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

Joshrandom wrote:It's working fine for me.  :D
Me too! Thanks for all your hard work John.  :D
UBT - bobuk
Active UBT Contributor 10+ yrs
Posts: 3227
Joined: Wed Aug 23, 2006 1:00 am

Post by UBT - bobuk »

looking good again  :lol:  :lol:  :lol:






b. :D
UBT - The Prof....
Posts: 1630
Joined: Mon Nov 06, 2006 12:00 am

Post by UBT - The Prof.... »

All up and running here..
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:
UBT - Rick Horn wrote:
Temujin wrote:1 new netgear router and we're back up :thumbup:
Still seems to be out John.
Hope you haven`t had another strike!  :lol:
huh ???

I'm using it right now, is it still not working?


edit
aww gawd, gotta re-setup all my firewall rules
it should be there soon

Hurrah! :lol:

Maybe time to invest in a surge protector?  :wink:  As for the firewall rules, uggg what a pain that can be sometimes  :?
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Ben wrote:Maybe time to invest in a surge protector?  :wink:  
Already got one :shock:
The router gets its power via a UPS which has a built in phone line filter & surge protector.

oh well, we'll see how long this one lasts
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

hmmn, it seems dog slow for me at work

what's it like for everybody else?
Woodles
UBT Contributor
Posts: 11757
Joined: Thu Dec 20, 2007 12:00 am
Location: Cambridgeshire

Post by Woodles »

Seems OK for me at the moment, about five seconds to load initially then a couple of seconds to load each different page.
Image
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

Fine for me. Almost instant loading (less than a second).  :D
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Ohh noess, has it broke again?  :shock:

I tried to access it about 13:20 and it timed out  :(
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Ben wrote:Ohh noess, has it broke again?  :shock:

I tried to access it about 13:20 and it timed out  :(
and I can't get to it from work (13:40), looks like there's summat wrong :(
UBT - The Prof....
Posts: 1630
Joined: Mon Nov 06, 2006 12:00 am

Post by UBT - The Prof.... »

Oh dear,  :cry:  :cry:
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:
Ben wrote:Ohh noess, has it broke again?  :shock:

I tried to access it about 13:20 and it timed out  :(
and I can't get to it from work (13:40), looks like there's summat wrong :(

Think the router has thrown in the towel already  :lol:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

hmmn, very strange

I can remotely manage the router, so it's working
I can ssh into my linux machine, so firewall rules are working

but http don't wanna work

I've got ssh and http setup just the same (except for the port numbers obviously)
Image


edit
I just don't get it :?
Everything looks to be set correctly but it just won't forward http requests to my linux machine

I'll reset it to factory defaults when I get home and start from scratch
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Temujin wrote:I'll reset it to factory defaults when I get home and start from scratch[/color]
That looks to have sorted it :thumbup:

I wonder how long it'll last :roll:
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Maybe a silly question, but is it running Apache? In which case was the port configured to be something other then port 80 possibly?

When i was using apache for a project at university (although it was for a windows machine) i was using something called XAMPP and that took a while for me to configure the ports  :?
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Yes it's using apache but on the default port of 80

the strange thing is that it was working fine up til about 1pm when the router totally refused to forward the http requests to the server.
I tried all sorts, deleted/recreated to firewall rule, reset the router.
It took a factory reset and re-setup before it would work

Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Guys, I dunno what's happening with my site. I've now got 1 new router that works as fast as a very slow thing having a slow day and 1 old router that doesn't want to work at all.

I will see if I can at least get the settings out of the old router and upload them into the new router.

If that fails I'll buy 1 more router and try that but if that also fails and I've not got it all working by friday, then that's it for 2 weeks cos I'm off on holiday.

Let's hope I can get it working tonight
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

right, that's another router in place now

I can at least get out with it at the moment but I don't think I've got the firewall setup right just yet.
Bare with me and I'll get it


edit
that looks to be working now
be sure to shout if/when it goes slow or dies again
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

It seems very fast John, I think you might have cracked it.  :D

On behalf of all the members who use your stats, thanks for your diligence and hard work on maintaining your brilliant stats pages. We really appreciate it.  :thumbup:
UBT - The Prof....
Posts: 1630
Joined: Mon Nov 06, 2006 12:00 am

Post by UBT - The Prof.... »

Fastest I have ever seen this :!:
Thanks John :D
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Just had to reboot the router cos it had locked up :evil:

I'm just about to go off on holiday for 2 weeks, so if it locks again it'll have to wait for at least #1 son to get home and me talk him through it
david
Posts: 569
Joined: Fri Mar 30, 2007 1:00 am

Post by david »

Worked fine for me at 13.30 your time using firefox on Fedora11

  David
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

Gone down again.
We could have no stats for the next  2 weeks.  :cry:
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Where is the A team when you need them!?  :(
UBT - Mikee
Marvin the Dalek
Posts: 4395
Joined: Wed Mar 15, 2006 12:00 am
Location: North Wales

Post by UBT - Mikee »

Temujin wrote:Just had to reboot the router cos it had locked up :evil:

I'm just about to go off on holiday for 2 weeks, so if it locks again it'll have to wait for at least #1 son to get home and me talk him through it
Seems #1 son has sorted it for now! Well done young man!
Follow us on Twitter... http://twitter.com/UKBOINCTeam

Image Image

Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Well, I've been back from my travels for a few days now and while I can at least keep a closer eye on my new router, it still wants to lock up in the middle of the night.

It's a weird one this. I think every morning since I got back the router has lost its ADSL link and when I check my stats, the last updates were at 1am each time. So for some reason the router is dropping its adsl connection between 1am and 2am every day.

Maybe one of those timer sockets is called for
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

What model is the router John? If you let me know i'll have a look on the web and see if i can find any solutions.  :)
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

It's a Linksys WAG320N.
After initially buying another Netgear to replace the original one and having that not behave I thought I'd spend some money and buy a proper router from a proper manufacturer (cisco) but it seems to suffer just the same.

I've searched the web myself and have discovered that this model is prone to dropping its connection during the night with no solution forthcoming from linksys/cisco

I'll persevere with it for a while, will even try the timer socket to see if that helps but if I don't get anywhere with it, it'll be going back for a refund
hgblade
Posts: 28463
Joined: Fri Jan 04, 2008 12:00 am

Post by hgblade »

A few months ago I had an apparent router problem - at between midnight and 1:30am almost every night, with the service dropping out for a minute or two. My broadband and router supplier are BT, and they denied they were responsible - but eventually an engineer friend told me, off the record, that the area exchange was being upgraded and 'plugs were pulled' on some domestic users for a short time to allow 'certain things to happen' whilst the demand was low.

After a few weeks the problem disappeared - coincidentally the exchange upgrade happened to be completed at the same time!
Image
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:It's a Linksys WAG320N.
After initially buying another Netgear to replace the original one and having that not behave I thought I'd spend some money and buy a proper router from a proper manufacturer (cisco) but it seems to suffer just the same.

I've searched the web myself and have discovered that this model is prone to dropping its connection during the night with no solution forthcoming from linksys/cisco

I'll persevere with it for a while, will even try the timer socket to see if that helps but if I don't get anywhere with it, it'll be going back for a refund
Yeah i have just been trawling through loads of posts about people encountering your problem on various different ISP's. Seems like the firmware is to blame? Although it is strange because LinkSys is usually a really good brand and are owned by Cisco.

Not sure what router would be best for the job, but as you mentioned Cisco would be a good start, either that or D-Link maybe?
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

will even try the timer socket to see if that helps
right then
thats the router now running through a timed socket, so it's gonna get turned off/on at 01:50 each morning.

Let's see if that helps


edit
that looks to have worked :thumbup:
I think today is the first time it's still been connected when I got up
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Another day, another router :evil:

After first trying a Netgear and then a Cisco, this time I've opted for a Belkin.
And also before buying, I googled for problems with it and found nothing, so lets hope it works.

Setup was easy, purchase & setup all completed within my lunch break

fingers & toes crossed
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

oh well, at least locking up once a week is better than once a day Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Looks like my latest in a long line of routers has decided it wants to behave badly.
So, I've found an industrial strength dual ADSL2+ router we have sat on a shelf here at work. I've only got the one adsl line at home (at the mo anyway) so we'll see if industrial strength routers are any better than domestic strength routers with my troublesome adsl line.

and might take the opportunity to de-fluff my cooling fans at the same time
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

hmmn, ok, that installed easy enough.
Looks to be working ok my end, speedtest.net reports upload speed is down to 0.48Mbs from 0.68Mbs, so that'l no doubt increase the time it takes for you guys to load a page.
Download speed has stayed about the same, so the hourly updates will take the same time

Oops
and I've now setup the port forwarding so you can get in  :roll:
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

It seems to be just as fast as usual from here, John.  :D
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Temujin wrote:upload speed is down to 0.48Mbs from 0.68Mbs
Download speed has stayed about the same
GAWD :evil:

it's as slow as a very slow thing having a slow day :evil:

I'll tinker with it for a while and see if I can improve things
UBT - Mikee
Marvin the Dalek
Posts: 4395
Joined: Wed Mar 15, 2006 12:00 am
Location: North Wales

Post by UBT - Mikee »

And it was all going so well...

The server at ubt-seti.dyndns.org is taking too long to respond.
Follow us on Twitter... http://twitter.com/UKBOINCTeam

Image Image

Image
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Hi John,

I have played around with the Apache webserver much more recently and although still very much a newbie i have noticed a feature called Gzip compression.

Is this enabled on your webserver? It could potentially speed up page loading times and reduce your bandwidth slightly?  :idea:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Hi Ben
thanks for the suggestion but I enabled gzip compression way back in the early days.
Yes, it helps, you should've seen it before it was enabled  Image

I really don't understand this router.
normal surfing is fine, speedtest.net reports similar speeds to the previous router (uploads are a bit slower but not too much) and yet the downloads for the hourly update take forever.
The previous router would complete all the projects in a shade over 3 minutes, this one takes 20+ minutes and a bunch of projects time out
Image
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

"Yes, it helps, you should've seen it before it was enabled
Ah good man!
I really don't understand this router.
normal surfing is fine, speedtest.net reports similar speeds to the previous router (uploads are a bit slower but not too much) and yet the downloads for the hourly update take forever.
The previous router would complete all the projects in a shade over 3 minutes, this one takes 20+ minutes and a bunch of projects time out
Image
I'm not 100% sure, although i think when a router is activated on a new line it can take 24 hours (sometimes more) to fully sychronise with the exchange line speed which means your upload and download speed may fluctuate during that time. It might just need a few days to "settle in", although i could be wrong.  :oops:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Ben wrote:I'm not 100% sure, although i think when a router is activated on a new line it can take 24 hours (sometimes more) to fully sychronise with the exchange line speed which means your upload and download speed may fluctuate during that time. It might just need a few days to "settle in", although i could be wrong.  :oops:
I think you're right there Ben, cos the update times are now back to the normal ~3 minutes, I didn't know about that.

And due to the distinct lack of hits in my logfiles and the fact I can't get access from work, it looks like I've messed up the port forwarding.
It was working ok, I setup http and ssh ports and ssh is still working but not http

oh well, will have to wait till tonight before the next tinkwering session.

I #*&%!£^ hate routers :evil:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

got it working :thumbup:
turns out the router remote administration was taking port 80 (http) since I enabled remote admin last night

It's all good fun
I still #*&%!£^ hate routers though :D
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:got it working :thumbup:
turns out the router remote administration was taking port 80 (http) since I enabled remote admin last night

It's all good fun
I still #*&%!£^ hate routers though :D
I'm suprised you don't host your excellent stats site on the web somewhere John! I't would take the headache of configuring ports and needing more bandwidth away  :wink:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Ben wrote:I'm suprised you don't host your excellent stats site on the web somewhere John! I't would take the headache of configuring ports and needing more bandwidth away  :wink:
I dunno how to do that  :?

Would I be able to have a mysql database and run the update scripts hourly etc ?
It would certainly be better for you guys what with all this router trouble I'm having.

maybe...
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:
Ben wrote:I'm suprised you don't host your excellent stats site on the web somewhere John! I't would take the headache of configuring ports and needing more bandwidth away  :wink:
I dunno how to do that  :?

Would I be able to have a mysql database and run the update scripts hourly etc ?
It would certainly be better for you guys what with all this router trouble I'm having.

maybe...
Yeah there are alot of websites which offer to host MySQL/SQL databases and various other tools.

There are ways to export and import databases (i must admit i have not done it yet, but im sure i will be soon). Which should mean that you can transfer to an external website.

As for being able to run the scripts... Pass on that one, it depends on if the host allows you to run scripting languages on their servers. What script technology are you currently using? Batch, Com, PHP etc? It also depends on how those scripts are called.

But if you got that to work, then you'd probally have access to 10Mbps upload or better!  :D
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Nice one Ben,  I'm looking into it   :thumbup:

I'd always thought I wouldn't have the access that I do at home, running shell & php scripts, using cron to schedule things, managing the databses etc but by the looks of things I can.
And I can get good bandwidth and disk space allowances for a reasonable annual fee.

maybe...
melter65
Active UBT Contributor
Posts: 3873
Joined: Thu May 17, 2007 1:00 am

Post by melter65 »

I'm sure the rest of the team would be willing to donate towards getting such a site up and running, John. We've benefited from using your excellent Stats in the past and I'm sure there would be plenty of donors  :D

A PayPal account possibly? Just say the word!
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

I`m in.
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Yeah i'd put a few bob in the pot (sorry B!)  :lol:

Also using the phpMyAdmin i exported my small helpdesk SQL database to one single file which makes it good for backup or transfering.  :D
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

I looked into a hosting site last thursday, reasonable annual fee plus all the goodies I want to manage it with.
I've setup a site and over the coming days/weeks I'll move the stats over to it.
There's some reorganisation I want to do to the database first, so it's a bit more than a simple export/import but it should be there within a couple of weeks.

And thanks for your kind offers to help but no worries chaps, i've got it :thumbup:
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Nice one John!  8)

Hopefully that might reduce the headache a bit!

What host did you go with in the end? As i was looking at the possibility of setting up a very small database so i can have a central server which is on 24/7.

The next challenge for me is to try and learn some PHP for the website bit  :shock:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Ben wrote:What host did you go with in the end? As i was looking at the possibility of setting up a very small database so i can have a central server which is on 24/7.
Hi Ben

I went with the Linux/Pro offer from http://www.tsohost.co.uk/
Took the Linux option cos that's what the stats run on here at home and chose the Pro option for the bandwidth and the free domain registration.
The next challenge for me is to try and learn some PHP for the website bit  :shock:
I hadn't done much in php before I started my stats site, I'd knocked up a few pages that gave me hourly seti top 20 stats (I used to be in the seti  top 20 back then) .
Darren helped a lot in the early days, he gave me some samples of his code and it all grew from there.
I'm not sure my code is as well commented as Darren's was but I'm sure I could rustle something up to get you started.
I find www.php.net a great help, just google for php something and it will usually point you to the php.net site which will give the answer.

No amount of php skill will beat good database design though, so you'll need to also read up on database/table design.
I recently fixed a bottleneck in the combined page update that reduced the hourly update from 6 minutes down to less than 10 seconds simply by adding the correct indexes to the tables.
That update used to kill my machine while it ran, I dunno why I hadn't got round to looking at it before :oops:

Gimme a shout if you want some code samples, I'm all to ready to help mate
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:Hi Ben

I went with the Linux/Pro offer from http://www.tsohost.co.uk/
Took the Linux option cos that's what the stats run on here at home and chose the Pro option for the bandwidth and the free domain registration.
Just taken a look and seems quite good. Nice find John, and UK hosted which is even better!
I hadn't done much in php before I started my stats site, I'd knocked up a few pages that gave me hourly seti top 20 stats (I used to be in the seti  top 20 back then) .
Darren helped a lot in the early days, he gave me some samples of his code and it all grew from there.
I'm not sure my code is as well commented as Darren's was but I'm sure I could rustle something up to get you started.
I find www.php.net a great help, just google for php something and it will usually point you to the php.net site which will give the answer.
Ah another good resource! I'll bookmark that as that as I will probably be calling upon that quite a bit..
No amount of php skill will beat good database design though, so you'll need to also read up on database/table design.
I recently fixed a bottleneck in the combined page update that reduced the hourly update from 6 minutes down to less than 10 seconds simply by adding the correct indexes to the tables.
That update used to kill my machine while it ran, I dunno why I hadn't got round to looking at it before :oops:
So true! I am still very new to this, but i remember when doing stuff with Microsoft Access at uni it was drummed into us to use the right datatype to optimise the database. The bigger it gets, the more important it is. I dread to think how big your UBT Stats database is!! :lol:
The one thing i haven't quite understood yet is how to perform querys against the database for records with a primary/foreign keys but i'm sure i will get to it eventually! :(
Gimme a shout if you want some code samples, I'm all to ready to help mate

Thanks very much! I might need to call upon you or Darren if i can't get something working.  :oops:
Darren
Posts: 752
Joined: Mon Mar 13, 2006 12:00 am

Post by Darren »

Happy to help as well.
been busy so I don't get on the forum like I once did but I do get emails so PM me if you need anything from me.

Happy to send you some code if you need that.
Not brilliant at PHP but I can get by.

Darren
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Temujin wrote:I've setup a site and over the coming days/weeks I'll move the stats over to it.
well, it's been a frustrating few days but the new site is up :thumbup:
have a looksee here

There were loads of differences between how my site runs and how the hosted site runs but I think I've got it sorted now.
The updates take about 1/2 the time my site takes and the bandwidth is much better although it does seem to just hang every now & then.

I'm sure I will have missed something somewhere, so if you notice any funny behaviour or things not working then just gimme a shout.

My home site will remain active until I'm happy with the hosted site, then i'll give it a well earned rest :D
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Nice one John!

It working fine for me, very quick as well  :D Well done that man!
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

Thanks for all your hard work John.
We all appreciate it very much.  :D
Ben
Posts: 1387
Joined: Wed Dec 19, 2007 12:00 am

Post by Ben »

Temujin wrote:although it does seem to just hang every now & then.
Not sure if it is having a wobbly, but the stats seem to be stuck on 323,335. Even though this last hour (17:00) when you click on the overall stats graph for our team it appears to be showing the correct totals for the hour which is: 270,694

Also my stats don't appear to be showing any update and won't display the latest 24 hour graph for some peculiar reason. (I checked the stats at about 17:32 so it should have had time to collate the info).

D'oh!  :lol:
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Nice one Ben
2 things here I think
Ben wrote:Not sure if it is having a wobbly, but the stats seem to be stuck on 323,335. Even though this last hour (17:00) when you click on the overall stats graph for our team it appears to be showing the correct totals for the hour which is: 270,694
I maybe haven't enabled all my scripts yet, I know I've done a lot of work on the single project page, there's probably a very important script missing somewhere :?
...... and won't display the latest 24 hour graph for some peculiar reason. (I checked the stats at about 17:32 so it should have had time to collate the info).
This is the sort of thing i've been fighting for the last week.
PHP on my home machine is tolerant of divide by zero whereas PHP on the hosted machine isn't and i've been going thru the code fixing it when I find it.
Your 24hr graph should work now
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

As some may have noticed, the stats have moved to the new site (here)

I'd hoped that I would get a good number of visitors to the new site to highlight any errors but that hasn't happened :(
So I've had to force the issue and turn off the home based site.

Please post a message if you see anything not working correctly and I'll fix it as soon as I can.
hgblade
Posts: 28463
Joined: Fri Jan 04, 2008 12:00 am

Post by hgblade »

Just a couple of things, John. Using your link brings up ABC as default - how do you display full team stats as there seems to be no way of selecting team only?

I did look on the help page - which brings me to the second point. I know it's pretty trivial but there's no link back out of help - you need to use theprevious page button.

Otherwise - looks great!!
Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

hgblade wrote:Just a couple of things, John. Using your link brings up ABC as default - how do you display full team stats as there seems to be no way of selecting team only?
I'm not sure what you mean there.
Yes, it defaults to the ABC project... but it always has.
By "full team stats" I guess you mean either the combined1 or combined2 pages, both of which are selectable from the menu.
Or do you mean the All Teams  summary page, again it's in the menu.
If it's none of those, can you describe what is on the page
I did look on the help page - which brings me to the second point. I know it's pretty trivial but there's no link back out of help - you need to use theprevious page button.
Blimey, I haven't looked at the help pages for years and there could well be no way back from them.
I'll have a look
hgblade
Posts: 28463
Joined: Fri Jan 04, 2008 12:00 am

Post by hgblade »

Temujin wrote:
hgblade wrote:Just a couple of things, John. Using your link brings up ABC as default - how do you display full team stats as there seems to be no way of selecting team only?
I'm not sure what you mean there.
Yes, it defaults to the ABC project... but it always has.
By "full team stats" I guess you mean either the combined1 or combined2 pages, both of which are selectable from the menu.
Or do you mean the All Teams  summary page, again it's in the menu.
If it's none of those, can you describe what is on the page
I was looking for a UBT summary by member (combined stats for all projects without the summary for each project as in the combined options). I'm sure that that was on the page I used to link to.

Maybe I'm expecting to see something that's not intended to be there!  :?
Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

hgblade wrote:I'm sure that that was on the page I used to link to.
have you still got the link?  I can run it at home if you have
but, any links should just need updating to the new url
hgblade
Posts: 28463
Joined: Fri Jan 04, 2008 12:00 am

Post by hgblade »

Temujin wrote:
hgblade wrote:I'm sure that that was on the page I used to link to.
have you still got the link?  I can run it at home if you have
but, any links should just need updating to the new url
If I load the link from history, before it redirects it appears to be:
http://ubt-seti.dyndns.org/ubt/UBT.php? ... oject=comb

That's the best I can offer.  :?
Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

hgblade wrote:If I load the link from history, before it redirects it appears to be:
http://ubt-seti.dyndns.org/ubt/UBT.php? ... oject=comb

That's the best I can offer.  :?
Yep, that looks right, it's the combined2 page
here's the new url
hgblade
Posts: 28463
Joined: Fri Jan 04, 2008 12:00 am

Post by hgblade »

Ahhh ... I seem to have managed to miss that!!!  :oops:    :cry:

Thanks for setting me straight!   :roll:
Image
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Everybody, updating to the new site should just be a case of changing ubt-seti.dyndns.org  to  www.ubtstats.co.uk  in any bookmarks you have.

for example, changing a bookmark url for milkyway, you would change
http://ubt-seti.dyndns.org/ubt/UBT.php?project=MilkyWay
to
http://www.ubtstats.co.uk/ubt/UBT.php?project=MilkyWay
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Hi all

For some reason I haven't yet figured out, my stats updates are sometimes just dying at random places.
I'm not getting anything useful in my logfiles, it's as if the scripts are being killed or the machine reboots, it just stops :evil:
Thankfully, it still works most of the time and even if an update does die it will self correct at the next update.  
The only problem is if it dies during the midnight update and fails to move on the days. This happened tues/wed which is why the graphs look a tad strange.

I'll email the hosting site and see if they can suggest anything but in the mean time, sorry for any inconvenience.
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Temujin wrote:I'll email the hosting site and see if they can suggest anything but in the mean time, sorry for any inconvenience.
Well they've tweaked a couple of things and it looks to be behaving itself now.
Fingers crossed.
UBT - Chris Suddick
Active UBT Contributor 15+ yrs
Posts: 698
Joined: Tue Mar 14, 2006 12:00 am
Location: Warrington, Cheshire

Post by UBT - Chris Suddick »

John,

I seem to be having a minor problem with the stats today. On the Combined2 page (project=comb) the floating box of projects is not appearing. This is happening in both IE and Firefox. If I manually type 'project=PrimeGrid' for example in the URL then I can get to the different projects and the box appears OK until I go back to the combine2 page.

Best regards,

Chris.
UBT - Chris Suddick
Active UBT Contributor 15+ yrs
Posts: 698
Joined: Tue Mar 14, 2006 12:00 am
Location: Warrington, Cheshire

Post by UBT - Chris Suddick »

Oh dear. Then presumably, the problem is at my end. I wonder what I've done? Or more likely, I wonder what my wife has done?

Hmmm, curiouser and curiouser.

Chris.
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

UBT - Chris Suddick wrote:John,

I seem to be having a minor problem with the stats today. On the Combined2 page (project=comb) the floating box of projects is not appearing. This is happening in both IE and Firefox. If I manually type 'project=PrimeGrid' for example in the URL then I can get to the different projects and the box appears OK until I go back to the combine2 page.
No problems here Chris.
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

Hi Chris

Sorry for taking so long to reply but I've not been well these last few days.

I noticed a similar behaviour, for me the menu didn't fully show. It did this for maybe 4-5 hours or so, then went back to normal. As I haven't made any changes I assumed it was my connection.

It seems to be back to normal now Image
UBT - Chris Suddick
Active UBT Contributor 15+ yrs
Posts: 698
Joined: Tue Mar 14, 2006 12:00 am
Location: Warrington, Cheshire

Post by UBT - Chris Suddick »

Hey John, don't worry about the response time. You're not paid to do this and I (and presumably everyone else) is more than grateful for the stats you provide and support as well.

Anyway, I did a bit of looking around and I would definitely say the problem is mine not yours. I noticed that each time I load the combined page then it would not complete. It would load about 2500 records and then terminate without any error message. It wasn't the same number of records each time so it wasn't related to a specific record or data item.

I came back into the office later (about 11pm) when it was freezing and it worked OK but it does sometimes fail when I have the heating on. So, if I sit in a freezing office then I can get it work otherwise it's a bit iffy. I think I can safely say that my PC is not much longer for this mortal world  :(

Chris.
Temujin
Posts: 2259
Joined: Mon Mar 13, 2006 12:00 am

Post by Temujin »

it seems my hosting site threw a wobbly tonight.

The stats were unavailable for a period after 9pm and then the time on the host server seemed to jump back & forward 3 hours several times, which made things look very strange.
It looks to have settled down again now, lets hope it stays like that.
UBT - Chris Suddick
Active UBT Contributor 15+ yrs
Posts: 698
Joined: Tue Mar 14, 2006 12:00 am
Location: Warrington, Cheshire

Post by UBT - Chris Suddick »

Hi John,

I'm sorry but every time I add to this thread it seems to to report another problem.

I noticed the other day that I seemed to get rather a lot of points in SIMAP which can happen sometimes when you're a bit short the day before and there's a catchup. I put it out of my mind at the time but then I happened to notice today that it happened to everyone else as well and it happened to the team.

Go into any project page and click on the credit graph for UBT (far right) and you will see a huge spike on Mar 1st. The spike is approximately double what it should be. My guess is that in processing the special case of Feb/leap year then the 'clear total' got bypassed.

It's not a big issue as it doesn't actually affect people's totals and in another two weeks the evidence will be gone for another year :-)

Anyway, just thought I'd let you know.

All the best,

Chris.
UBT - Liamlee
Active UBT Contributor 15+ yrs
Posts: 127
Joined: Mon Apr 10, 2006 1:00 am

Post by UBT - Liamlee »

Hi John,

Sorry to be a pain but I don't think the stats are working all I get is a blank page with just the header.
UBT - Chris Suddick
Active UBT Contributor 15+ yrs
Posts: 698
Joined: Tue Mar 14, 2006 12:00 am
Location: Warrington, Cheshire

Post by UBT - Chris Suddick »

It's working OK for me so either the problem has cleared itself or it's at your end I guess.

Chris.
UBT - Rick Horn
Posts: 17206
Joined: Sat May 06, 2006 1:00 am

Post by UBT - Rick Horn »

It was working yesterday for me, although the WCG page has not been updating for some considerable time.
UBT - Chris Suddick
Active UBT Contributor 15+ yrs
Posts: 698
Joined: Tue Mar 14, 2006 12:00 am
Location: Warrington, Cheshire

Post by UBT - Chris Suddick »

I've not seen any updates since 6 this morning. Is it just me or is there a problem?

Chris.
Post Reply