PDA

View Full Version : SRL-Stats moved to a different server



Wizzup?
11-22-2011, 02:56 PM
Hey,

Because the Runescape update will probably break scripts for a small time, I've decided to take the liberty of transferring SRL-Stats to a different server. The old SRL-Stats will stay running for a bit in case something goes horribly wrong, but I doubt that will happen.

http://stats.villavu.com should soon point to the new server, so no user changes are required.

E: By the way, we're now officially using PostgreSQL as backend for SRL Stats! :D :D

HT BaaFly
11-22-2011, 04:18 PM
Yay? lol jking :)

Thanks a lot for putting a huge amount of effort and work into this fabulous project

Flight
11-22-2011, 04:51 PM
I was about to ask what this change implies and I noticed the speed difference... Wow... Why is this so much faster? Is PostgreSQL that good or was it something else?

Alaska
11-22-2011, 06:06 PM
^^

The speed is incredible, page to page is pretty much instantaneous. Wow.

P1nky
11-22-2011, 06:40 PM
Is this the reason, that made my username and password invalid :S?

RISK
11-22-2011, 06:42 PM
It shouldn't have. Wizzup stated that no user changes should happen, at least from what I understand of it.

http://stats.villavu.com should soon point to the new server, so no user changes are required.


Is this the reason, that made my username and password invalid :S?

Wizzup?
11-22-2011, 07:07 PM
I was about to ask what this change implies and I noticed the speed difference... Wow... Why is this so much faster? Is PostgreSQL that good or was it something else?

PostgreSQL is better than MySQL, but performance wise I don't think there is a big difference. The new server just has a lot more processing power and memory to use for caching. (24GB RAM). The actual internet connection is of a lesser quality but is not metered, which is nice.

P1nky, if you're sure the old site used to work, let me know. I don't think there is a difference, but it is possible.

P1nky
11-22-2011, 07:19 PM
PostgreSQL is better than MySQL, but performance wise I don't think there is a big difference. The new server just has a lot more processing power and memory to use for caching. (24GB RAM). The actual internet connection is of a lesser quality but is not metered, which is nice.

P1nky, if you're sure the old site used to work, let me know. I don't think there is a difference, but it is possible.

It was working last night (3 am for me lol). I woke up to check my stats, invalid login.

Harry
11-24-2011, 05:43 AM
Fun bug: if your username has any capital letters in it, you must modify your stats.simba or else you get invalid login.

Set it to:
stats_Username := UserName;

At the moment it does lowercase(username), and the new server requires EXACT casing now? Is this going to be changed? It'd be best if it allowed lowercased passwords and usernames, but uppercase ones are also accepted.

Flight
11-24-2011, 06:02 AM
Fun bug: if your username has any capital letters in it, you must modify your stats.simba or else you get invalid login.

Set it to:
stats_Username := UserName;

At the moment it does lowercase(username), and the new server requires EXACT casing now? Is this going to be changed? It'd be best if it allowed lowercased passwords and usernames, but uppercase ones are also accepted.

Well that explains why the last 3 hours of trying to commit have been telling me my name/pass is wrong. :/

Coh3n
11-24-2011, 06:39 AM
Committed that fix, Harry.

Wizzup?
11-24-2011, 09:45 AM
Fun bug: if your username has any capital letters in it, you must modify your stats.simba or else you get invalid login.

Set it to:
stats_Username := UserName;

At the moment it does lowercase(username), and the new server requires EXACT casing now? Is this going to be changed? It'd be best if it allowed lowercased passwords and usernames, but uppercase ones are also accepted.

I don't think this was an intended feature but rather a bug in (my knowledge of) MySQL. Unless you guys really want this fixed I'd rather leave the username case sensitive. Hmm... now that I think of it, case insensitivity may be good for usernames.

Harry
11-24-2011, 07:15 PM
Case insensitive for both user+pass would be useful, I am pretty sure Jagex does it like that, and script users don't realize it and stop sending commits.

Wizzup?
11-24-2011, 07:21 PM
Case insensitive for both user+pass would be useful, I am pretty sure Jagex does it like that, and script users don't realize it and stop sending commits.

Well, not for password.

Wizzup?
11-24-2011, 08:08 PM
Username should be case insensitive now.