Results 1 to 15 of 15

Thread: SRL-Stats moved to a different server

  1. #1
    Join Date
    Feb 2006
    Location
    Amsterdam
    Posts
    13,691
    Mentioned
    146 Post(s)
    Quoted
    130 Post(s)

    Default SRL-Stats moved to a different server

    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!
    Last edited by Wizzup?; 11-22-2011 at 03:05 PM.



    The best way to contact me is by email, which you can find on my website: http://wizzup.org
    I also get email notifications of private messages, though.

    Simba (on Twitter | Group on Villavu | Website | Stable/Unstable releases
    Documentation | Source | Simba Bug Tracker on Github and Villavu )


    My (Blog | Website)

  2. #2
    Join Date
    Oct 2008
    Posts
    196
    Mentioned
    1 Post(s)
    Quoted
    20 Post(s)

    Default

    Yay? lol jking

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

  3. #3
    Join Date
    Aug 2007
    Location
    Colorado
    Posts
    7,421
    Mentioned
    268 Post(s)
    Quoted
    1442 Post(s)

    Default

    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?

    Current projects:
    [ AeroGuardians (GotR minigame), Motherlode Miner, Blast furnace ]

    "I won't fall in your gravity. Open your eyes,
    you're the Earth and I'm the sky..."


  4. #4
    Join Date
    Sep 2009
    Location
    Cyberpolice HQ
    Posts
    133
    Mentioned
    0 Post(s)
    Quoted
    0 Post(s)

    Default

    ^^

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

  5. #5
    Join Date
    Dec 2006
    Location
    Program TEXAS home of AUTOERS
    Posts
    7,934
    Mentioned
    26 Post(s)
    Quoted
    237 Post(s)

    Default

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

  6. #6
    Join Date
    Jan 2010
    Posts
    1,414
    Mentioned
    0 Post(s)
    Quoted
    1 Post(s)

    Default

    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.
    Quote Originally Posted by P1nky View Post
    Is this the reason, that made my username and password invalid :S?

  7. #7
    Join Date
    Feb 2006
    Location
    Amsterdam
    Posts
    13,691
    Mentioned
    146 Post(s)
    Quoted
    130 Post(s)

    Default

    Quote Originally Posted by Flight View Post
    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.



    The best way to contact me is by email, which you can find on my website: http://wizzup.org
    I also get email notifications of private messages, though.

    Simba (on Twitter | Group on Villavu | Website | Stable/Unstable releases
    Documentation | Source | Simba Bug Tracker on Github and Villavu )


    My (Blog | Website)

  8. #8
    Join Date
    Dec 2006
    Location
    Program TEXAS home of AUTOERS
    Posts
    7,934
    Mentioned
    26 Post(s)
    Quoted
    237 Post(s)

    Default

    Quote Originally Posted by Wizzup? View Post
    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.

  9. #9
    Join Date
    Dec 2006
    Location
    Sweden
    Posts
    10,812
    Mentioned
    3 Post(s)
    Quoted
    16 Post(s)

    Default

    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.


    Send SMS messages using Simba
    Please do not send me a PM asking for help; I will not be able to help you! Post in a relevant thread or make your own! And always remember to search first!

  10. #10
    Join Date
    Aug 2007
    Location
    Colorado
    Posts
    7,421
    Mentioned
    268 Post(s)
    Quoted
    1442 Post(s)

    Default

    Quote Originally Posted by Harry View Post
    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. :/

    Current projects:
    [ AeroGuardians (GotR minigame), Motherlode Miner, Blast furnace ]

    "I won't fall in your gravity. Open your eyes,
    you're the Earth and I'm the sky..."


  11. #11
    Join Date
    Apr 2008
    Location
    Marquette, MI
    Posts
    15,252
    Mentioned
    138 Post(s)
    Quoted
    680 Post(s)

    Default

    Committed that fix, Harry.

  12. #12
    Join Date
    Feb 2006
    Location
    Amsterdam
    Posts
    13,691
    Mentioned
    146 Post(s)
    Quoted
    130 Post(s)

    Default

    Quote Originally Posted by Harry View Post
    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.



    The best way to contact me is by email, which you can find on my website: http://wizzup.org
    I also get email notifications of private messages, though.

    Simba (on Twitter | Group on Villavu | Website | Stable/Unstable releases
    Documentation | Source | Simba Bug Tracker on Github and Villavu )


    My (Blog | Website)

  13. #13
    Join Date
    Dec 2006
    Location
    Sweden
    Posts
    10,812
    Mentioned
    3 Post(s)
    Quoted
    16 Post(s)

    Default

    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.


    Send SMS messages using Simba
    Please do not send me a PM asking for help; I will not be able to help you! Post in a relevant thread or make your own! And always remember to search first!

  14. #14
    Join Date
    Feb 2006
    Location
    Amsterdam
    Posts
    13,691
    Mentioned
    146 Post(s)
    Quoted
    130 Post(s)

    Default

    Quote Originally Posted by Harry View Post
    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.



    The best way to contact me is by email, which you can find on my website: http://wizzup.org
    I also get email notifications of private messages, though.

    Simba (on Twitter | Group on Villavu | Website | Stable/Unstable releases
    Documentation | Source | Simba Bug Tracker on Github and Villavu )


    My (Blog | Website)

  15. #15
    Join Date
    Feb 2006
    Location
    Amsterdam
    Posts
    13,691
    Mentioned
    146 Post(s)
    Quoted
    130 Post(s)

    Default

    Username should be case insensitive now.



    The best way to contact me is by email, which you can find on my website: http://wizzup.org
    I also get email notifications of private messages, though.

    Simba (on Twitter | Group on Villavu | Website | Stable/Unstable releases
    Documentation | Source | Simba Bug Tracker on Github and Villavu )


    My (Blog | Website)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •