Thank you to all those who donated in 2015!



DONATION STATUS
Needed before 2016-12-31
$ 2,500
So far donated
$ 595

Denial-of-Service

Discussion in 'General' started by robert, Sep 8, 2007.

  1. robert

    robert New Member Piano Society Artist

    Joined:
    Jun 7, 2006
    Messages:
    1,842
    Likes Received:
    0
    Location:
    Sweden
    Home Page:
    Last Name:
    Stahlbrand
    First Name:
    Robert
    WEBSITE:
    http://pianosociety.com
    WLM:
    robertstahlbrand@hotmail.com
    LOCATION:
    Sweden
    Someone obviously didn't like my trick where you must take a ticket before downloading music and launched a Denial-of-Service attack against the site. Good enough, my profession is computer security so I have taken actions against it. Sorry for the downtime.
     
  2. pianolady

    pianolady Monica Hart, Administrator Staff Member Piano Society Artist

    Joined:
    Jun 14, 2006
    Messages:
    8,702
    Likes Received:
    0
    Last Name:
    Hart
    First Name:
    Monica
    Uh oh - I think that happened just as I was on the site about to listen to myself. Just when I clicked on me, it went dead. ( no jokes about sounding so terrible that I killed the site :lol: - unless I really did? :shock: )
     
  3. PJF

    PJF New Member Piano Society Artist

    Joined:
    Jul 13, 2006
    Messages:
    1,278
    Likes Received:
    0
    Last Name:
    Fournet
    First Name:
    Pierre
    That's pretty sad. I guess some people have too much time on their hands.

    We can also have a giggle at someone who thought they could get the best of you. :lol:
     
  4. robert

    robert New Member Piano Society Artist

    Joined:
    Jun 7, 2006
    Messages:
    1,842
    Likes Received:
    0
    Location:
    Sweden
    Home Page:
    Last Name:
    Stahlbrand
    First Name:
    Robert
    WEBSITE:
    http://pianosociety.com
    WLM:
    robertstahlbrand@hotmail.com
    LOCATION:
    Sweden
    So it was you! 8)

    No, it was someone loading the MySQL database with huge quires using PHP but I am not sure how he/she did it.
     
  5. PJF

    PJF New Member Piano Society Artist

    Joined:
    Jul 13, 2006
    Messages:
    1,278
    Likes Received:
    0
    Last Name:
    Fournet
    First Name:
    Pierre
    Oh Monica, how could you?! :lol:
     
  6. Anonymous

    Anonymous Guest

    Well done. I've seen the statistics stopped at the 5th of the month (as happened in august also).
    There are many possibilities, among them:
    1) the fifth is a diabolic day
    2) too many download of CoccoBill LvB variations and the system went over

    All best,
    Sandro
     
  7. robert

    robert New Member Piano Society Artist

    Joined:
    Jun 7, 2006
    Messages:
    1,842
    Likes Received:
    0
    Location:
    Sweden
    Home Page:
    Last Name:
    Stahlbrand
    First Name:
    Robert
    WEBSITE:
    http://pianosociety.com
    WLM:
    robertstahlbrand@hotmail.com
    LOCATION:
    Sweden
    Hehe, or a C-program cannot open files more than 2 GB. ;)

    I'll have Chris write a shell script instead using bzcat on bzipped-files.

    Or perhaps I should write a wrapper which once a day cleans up the access_log from useless information. It would shrink the log about 10 times.
     
  8. Anonymous

    Anonymous Guest

    Don't dare! My motto is ars gratia artis (art for art's sake). :lol: :lol: :lol:
     
  9. techneut

    techneut Active Member Piano Society Artist

    Joined:
    Jun 12, 2006
    Messages:
    9,930
    Likes Received:
    0
    Location:
    Netherlands
    Last Name:
    Breemer
    First Name:
    Chris
    LOCATION:
    Netherlands
    Hear hear ... I won't let you torture me like that :p

    I'm not even going to try and do this stuff from a shell script. You have no idea of the amount of
    sorting and processing going on within stats. It would probably hang the system when attempted
    from a script. Maybe I'll have a go at coding it in Java (assuming it does not have the 2GB restriction, which I am not sure about).

    That would help. Obviously stats only needs the lines that pertain to audio files.

    But surely Apache must have some way of customizing the access log contents ?
     
  10. robert

    robert New Member Piano Society Artist

    Joined:
    Jun 7, 2006
    Messages:
    1,842
    Likes Received:
    0
    Location:
    Sweden
    Home Page:
    Last Name:
    Stahlbrand
    First Name:
    Robert
    WEBSITE:
    http://pianosociety.com
    WLM:
    robertstahlbrand@hotmail.com
    LOCATION:
    Sweden
    :)

    I am sure Apache has that but I think it would be easier for me to implement a wrapper than try to fool around with Apache.
     
  11. robert

    robert New Member Piano Society Artist

    Joined:
    Jun 7, 2006
    Messages:
    1,842
    Likes Received:
    0
    Location:
    Sweden
    Home Page:
    Last Name:
    Stahlbrand
    First Name:
    Robert
    WEBSITE:
    http://pianosociety.com
    WLM:
    robertstahlbrand@hotmail.com
    LOCATION:
    Sweden
    Done! Statistics back.
     
  12. techneut

    techneut Active Member Piano Society Artist

    Joined:
    Jun 12, 2006
    Messages:
    9,930
    Likes Received:
    0
    Location:
    Netherlands
    Last Name:
    Breemer
    First Name:
    Chris
    LOCATION:
    Netherlands
    Huzzah for Taco Man :lol:
     
  13. Anonymous

    Anonymous Guest

    What a pair! :lol:
     

Share This Page