The most impressive thing about this is that the offending app doesn't even display the image, it was some copypasta code the app developers apparently didn't even understand.
the hard part about this, if it were not wikimedia but some individual person's server, is that the traditional method of using something like an apache rewrite rule to replace the jpg/png with goatse wouldn't work, because the image isn't even being displayed.
Wikimedia narrows down the app sendin 90M requests to a pic of flower
81–90 of 105 posts
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#82> To narrow down the app, we decided to observe connections to the image from clients (phones) to our servers. We did this by opening the popular apps one-by-one and noting down the time. After doing this for all the apps, we then ran this query in Hive: SELECT * FROM wmf.webrequest WHERE year=2021 AND month=2 AND day=9 AND parse_media_file_url(uri_path).base_name='/wikipedia/commons/1/16/AsterNovi-belgii-flower-1mb.…
"way easier" depends on what you are familiar with. If you are familiar with "querying the entirety of wikimedia server logs" and do it all the time (the word "entirety" makes it seem like a big deal, but they clearly have tools meant for this that they use all the time)... and have never learned to use "mitmproxy/Charles etc" before.... It sounds like the "querying the entirety of the server logs" for this task prob…
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#83Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#84It makes sense that's still included deep down in some copy/paste app stuff.
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#85This reminds me of a Stack Overflow answer that became popular but instead of using 'example.com', they used some other random, but valid, URL that suddenly created a huge spike in traffic for the unsuspecting web page.
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#86Earlier quoted context omitted.
the hard part about this, if it were not wikimedia but some individual person's server, is that the traditional method of using something like an apache rewrite rule to replace the jpg/png with goatse wouldn't work, because the image isn't even being displayed.
Even worse: You might be seen as an easy way to Goatse people. Just give the yahoos the URL of an image you're rewriting to be the infamous gape. The traffic would only grow once you came to be known for Goatse as a Service.
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#87Earlier quoted context omitted.
Even worse: You might be seen as an easy way to Goatse people. Just give the yahoos the URL of an image you're rewriting to be the infamous gape. The traffic would only grow once you came to be known for Goatse as a Service.
> Goatse as a Service (YC S21)
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#88Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#89> To narrow down the app, we decided to observe connections to the image from clients (phones) to our servers. We did this by opening the popular apps one-by-one and noting down the time. After doing this for all the apps, we then ran this query in Hive: SELECT * FROM wmf.webrequest WHERE year=2021 AND month=2 AND day=9 AND parse_media_file_url(uri_path).base_name='/wikipedia/commons/1/16/AsterNovi-belgii-flower-1mb.…
It does say later in the post that they used a local proxy to confirm their findings, too. Maybe they wanted to check from both sides, just to be sure.
Re: Wikimedia narrows down the app sendin 90M requests to a pic of flower
#90[deleted]