• Sylvartas@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    edit-2
    6 months ago

    This was actually tried btw. Mostly as a joke iirc

    Edit: Looking into it, apparently it’s not confirmed. Damn, that was a very popular urban myth in french programming circles back in the 2010’s

  • bstix@feddit.dk
    link
    fedilink
    English
    arrow-up
    0
    ·
    6 months ago

    It’s a Renault Mégane 1. There’s not a whole lot of those around anymore so it’d be easy to identify the owner even without a license plate.

  • Zarcher@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    6 months ago

    I have been learning some database stuff today. Finally understand the drop table thing better.

      • brbposting@sh.itjust.works
        cake
        link
        fedilink
        arrow-up
        0
        ·
        6 months ago

        Makes me wonder if the Lucky 10,000 comic came out because of how often people might’ve said “everybody’s seen that XKCD”.

      • IsoKiero@sopuli.xyz
        link
        fedilink
        arrow-up
        0
        ·
        6 months ago

        I’m pretty sure the cameras around here don’t use OCR at all or even if it does it only recognizes the format for plates from a thing shaped like a plate. So if you’re driving like an ass with the drop tables-“plate” that is pretty relevant.

        The Bobby Tables one I’m quite sure would work at least on some systems if they let you input your kids name by yourself to some sort of digital form. Or at least I would be pretty surprised if every school system on earth would be patched against simple sql injections.

        • 14th_cylon@lemm.ee
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          So if you’re driving like an ass with the drop tables-“plate” that is pretty relevant.

          the only thing they have in common is the license plate. that is like saying that every joke that starts with “three people walk into a bar” is basically the same joke.

          but here, have a photo that is actually relevant to the submitted xkcd ;)

        • PriorityMotif@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          The license plate cameras near me simply take a photo when motion is detected and send it to the server or stores it until connection is reestablished. Then they use image recognition on the car to determine the make and model and on the license plate. They also claim that they can record items such as bumper stickers or body damage. I think that they probably have humans review cars that don’t match exactly. My guess is that they use object detection to isolate the license plate, but you could probably make one by printing text onto a piece of paper and gluing it onto some cardboard. I also think you could mess with it if you put a decal of a letter or number next to your license plate.

      • kholby@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        6 months ago

        Replace “all 1’s or something” with “drop database or something” and it 100% applies.

        • 14th_cylon@lemm.ee
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          and replace pork steak with tofu chilli bowl and it is now vegetarian food. what is your point?

            • 14th_cylon@lemm.ee
              link
              fedilink
              arrow-up
              0
              ·
              edit-2
              6 months ago

              And if my grandma had two wheels she would be a bicycke.

              No, she would be human with two wheels. That is not what a bicycle is

              What are we talking about again?

              We are talking about the fact that when someone says “that is not relevant”, countering with “if some facts were different, it would suddenly be relevant” is not very useful answer.

              • Syrc@lemmy.world
                link
                fedilink
                arrow-up
                0
                ·
                6 months ago

                You also have to “change facts” to have the Bobby Tables xkcd apply here, because this is about plates and not children.

                It doesn’t have to apply 100% to be a relevant xkcd, they just posted it because, like op’s pic, it’s about a person trying to be clever by messing with speed cameras, but everyone would know whose fault is it the second time it happens because of how weird the plate is.

                Your one obviously applies more, but there’s no need to gatekeep.

                • 14th_cylon@lemm.ee
                  link
                  fedilink
                  arrow-up
                  0
                  ·
                  edit-2
                  6 months ago

                  because this is about plates and not children.

                  but this isn’t about plates, it is about sql injection.

                  but there’s no need to gatekeep.

                  well, yes, i could have phrased that differently

  • The_Tired_Horizon@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    6 months ago

    Reminds me of the woman that got a fine for “driving in a bus lane” here in the UK. When she looked at the attached image on the fine it was of a woman walking in the street of a town she’d never been to. On that woman’s jumper was lettering that closely resembled her plates.

    Made me think I could attach a sheet of card with the plate details of some arsehole I disliked, ride a bicycle down the bus lane and see if they start complaining about being fined. 😅

    • Dr Cog@mander.xyz
      link
      fedilink
      arrow-up
      0
      ·
      6 months ago

      They’ll get the picture in the fine letter so make sure you give them your best one-finger salute

  • seathru@lemmy.sdf.org
    link
    fedilink
    English
    arrow-up
    0
    ·
    6 months ago

    Is there even a remotely possible chance something like that would work? I have to drive past a ALPR that checks for insurance every day. I wouldn’t mind plastering code across my tailgate in a design that resembles a license plate.

      • AwkwardLookMonkeyPuppet@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        6 months ago

        They tried to revive it, but ultimately the boards have been dead for the past 5 years or so.

        That’s a new level of incompetence, even for the government. So, after spending all that tax-payer money, they just let the entire project die rather than have a developer spin up a new database schema, which would take anyone competent like 5 minutes? For real? And these are the people that everyone expects to fix our problems?

        • Jarix@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          This is complete guess work but I’m pretty sure its the kind of things that was put together by some office assistant not a developer.

          Real parks and rec vibes.

          I don’t know what a database is and it’s been too long im afraid to go ask

        • Zoop@beehaw.org
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          It’s a link to a comment on this subject that says:

          Ok, so to explain. This DID happen,literally 500m from my home :) the system was designed to store reg plate numbers and later turned to a speed camera. The stunt was done by a few students of the Technical University, it did bring the whole db down. They tried to revive it, but ultimately the boards have been dead for the past 5 years or so. Mind that this hack was performed around 7 or 8 years ago:) I can provide pics of the dead board now and exact coordinates too:)

          And then later in the replies they do give the coordinates of the camera billboard thing they broke, and someone posts a Google Maps screenshot of the board at the coordinates they gave that just looks like a little digital billboard that’s turned off and is just black, and the OP confirms that it is the board they mentioned.

          Hope that all makes sense; I’ve got a lot brain fog/stress brain and stuff and it felt like too much to screenshot lol

      • seathru@lemmy.sdf.org
        link
        fedilink
        English
        arrow-up
        0
        ·
        6 months ago

        Worth a shot. Wouldn’t surprise me if this backwoods town is vulnerable. That being said, I’m open to anyone’s code suggestions and I’ll slap it on there. My coding abilities are limited to BASIC and just enough C to make microcontrollers work.

    • 14th_cylon@lemm.ee
      link
      fedilink
      arrow-up
      0
      ·
      6 months ago

      according to Tartaro, he says he received a notice that the California DMV would not let him renew his registration unless he actually paid some of those fines.

      that sounds so illegal. but i am not an american, so what do i know.

      • AwkwardLookMonkeyPuppet@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        6 months ago

        California will do a lot more than deny a renewal over unpaid fines. First they’ll double the fine the first day that you are late, and then they’ll add more fees every day until it is paid. Eventually, I think it’s after six months or a year, they’ll suspend your driver’s license, and after that they’ll issue a bench warrant for your arrest. So it’s entirely possible for your whole life to be ruined over a traffic ticket in California, culminating with you being thrown into prison.

        • 14th_cylon@lemm.ee
          link
          fedilink
          arrow-up
          0
          ·
          edit-2
          6 months ago

          ok, but while that is wild in itself, i assume that is under the assumption of them actually being your tickets. here we talk about situation where they demand the hero pays someone else’s tickets just because of the fault of their system.

          • AwkwardLookMonkeyPuppet@lemmy.world
            link
            fedilink
            English
            arrow-up
            0
            ·
            6 months ago

            That aligns perfectly from what I’ve seen from the California DMV. They do not give a fuck. They will do whatever their stupid little antiquated computer program tells them to do.

      • Patches@sh.itjust.works
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        6 months ago

        It’s illegal to have consequences for not paying your fines???

        He literally fucked around, and found out.

    • Trollception@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      6 months ago

      How the heck does a system interpret a string value null as a literal null? That seems insane to me that there really is software out there written like this. “null” != null… Or so I thought, maybe there are languages out there that this can happen in easily? Or someone is storing the string value of null in a non nullable database column?

    • Syrc@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      6 months ago

      “He had it coming,” says Christopher Null, a journalist who has written previously for WIRED about the challenges his last name presents.

      This is peak nottheonion material

  • LillyPip@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    6 months ago

    Little Bobby tables learns to drive.

    This is smart. When my son was learning, I put a magnetic ‘student driver’ sign on my car, too. More people should do this. It’s just polite.

      • LillyPip@lemmy.ca
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        6 months ago

        They’re not required here. You just plop your child in your regular car with no changes whilst they’re learning. It’s insane. I bought a magnetic sign to warn people though, because that seems nuts to me.

        I was making a joke tho.

        • Jajcus@kbin.social
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          Poland and probably most of Europe. You don’t need a car here for everyday living, so there is no point in giving licenses and care to kids.

        • 0x4E4F@sh.itjust.works
          link
          fedilink
          English
          arrow-up
          0
          ·
          edit-2
          6 months ago

          Almost everywhere… there are very few places where you can drive before you’re 18. There are like junuor permits and you can get them when you’re 16, but your parrents are the ones responsible for your driving. Something happens, they get ringed. So, yeah, they can also not give you the license if you cause too much trouble.

          • dave@hal9000@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            6 months ago

            Yeah, I assumed most of the world was at least 18. I was surprised when I moved to the US at 15 and could get a learner’s permit and drive with an adult, and drive by myself at 16.

            • Pacmanlives@lemmy.world
              link
              fedilink
              arrow-up
              0
              ·
              6 months ago

              Growing up in a rural part of Ohio it was needed. Everything was 20-30 miles away. Need milk and eggs, well see you an a hour

              • dave@hal9000@lemmy.world
                link
                fedilink
                arrow-up
                0
                ·
                6 months ago

                Yeah, I totally understand how it’s necessary across many parts of the US. There’s so much I couldn’t have done in high school, like having a job, if I couldn’t drive. I didn’t live in a rural area, but between the sprawl and lack of public transportation…

        • RampageDon@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          6 months ago

          In the US you don’t get your full driver’s license until 18. 16 is permit and requires an over 21 license driver with you, and 17 is a provisional license so it has restrictions on how late you can drive and how many people can be in the car.

          • toynbee@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            6 months ago

            Admittedly it’s been a long time since this was relevant to me, so this may have changed, but where and when I grew up in the US you could get a learner’s permit (unlimited driving with another qualified driver in the car) at 15 yrs and 9 mos, then a full license (able to drive by yourself and transport anyone over 18) at, I think, 16 and 6 mos. At 18 the restrictions on whom you could transport disappeared, but I’ve never heard of anyone paying attention to or enforcing those rules anyway.

            There may also have been a restriction about driving after midnight, but I don’t recall for sure.

          • Vytle@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            6 months ago

            I think that may be a state restriction. For sure you can get a permit at 15, and 16 should be provisional, but iirc the only restriction is that those under 18 cant drive after 11pm, atleast in FL.

            • nyan@lemmy.cafe
              link
              fedilink
              English
              arrow-up
              0
              ·
              6 months ago

              Pretty sure the US allows individual states to set the ages. In Canada, it’s provinces that set it. Lowest age I’ve ever heard of was 12 (for limited permits to move farm machinery along back roads in Saskatchewan, although that was decades ago and it might not still be a thing). I had a full and unrestricted license at 16, but the rules have changed since then.

            • bobs_monkey@lemm.ee
              link
              fedilink
              arrow-up
              0
              ·
              6 months ago

              Yeah but I think what he’s saying is that you can have a license, but there are still restrictions for a certain amount of time. In California when I got my license on my 16th birthday, I think it was 6 months that I couldn’t have anyone in the car under 18 without someone over 25, and I couldn’t drive past 10 or 11 pm (unless I was coming from work or some kind of emergency). It’s been a minute (almost 20 years lol) and I remember changes to the rules not long after my restrictions were lifted (I think they extended them to a year), but yeah, it’s not like they handed you a license and you were a free agent.

              • Ragnarok314159@sopuli.xyz
                link
                fedilink
                arrow-up
                0
                ·
                6 months ago

                Old Millennial, here. Gather round!

                In most of the USA, you could get a permit at 15 1/2 years old, and this came with the restriction of needing someone over 18 with you.

                Then at 16, if you passed the test, you were given a license and could drive all you want. No restrictions, no limits, have your friends in the car, no one really cared. Then people started to realize that giving 16 years olds free rein to drive causes a lot of accidents. Over the past ~15 years more states have adopted the graduated driver’s license and it has caused a notable drop in fatalities.

                • Baku@aussie.zone
                  link
                  fedilink
                  English
                  arrow-up
                  0
                  ·
                  6 months ago

                  Isn’t this the same country that made the drinking age 21 because of car accidents?

      • PhlubbaDubba@lemm.ee
        link
        fedilink
        arrow-up
        0
        ·
        6 months ago

        Not expecting someone to war drive a drop table query into an EZ pass database isn’t incompetence, n’or is not expecting any other vulnerability to be exploited unless you have specific training to look out for it.

        Even master defensive coders won’t be able to write something that’s impenetrable, just difficult enough to break into that it isn’t worth it to 99.99999% of attackers.

    • Image is European but I’m pretty sure here in California trying to obscure your plate is illegal. Though I’m not sure what actually counts against it, since I know a couple of people with those bullshit plastic films that claim to obscure your plate from traffic cams but not from people looking at it.

      They don’t actually work, but I feel like the intent behind using them could get you in trouble.

      • space@lemmy.dbzer0.com
        link
        fedilink
        arrow-up
        0
        ·
        6 months ago

        Where I live, you only need valid plates to drive on public roads. If the car is parked or you drive on private property, there’s no problem. The procedure for getting plates requires you to not have plates for like 2 or 3 days.

        Cars can still be identified by the VIN which is on the windshield.

        • Cars can still be identified by the VIN which is on the windshield.

          You mean that tiny little plate of numbers you can only see by being up close to inspect? How does that help find, say, a suspect in a hit and run? You’re sure as hell not gonna be able to read the VIN off a moving vehicle unless you’re hanging onto the hood for dear life.

        • PriorityMotif@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          edit-2
          6 months ago

          I don’t see how. The premise of these cameras is that anybody is allowed to film in public. All you’re doing is showing something in public which is perfectly legal. It doesn’t damage the camera. If they decide to use the image from their camera to enter text into a database, then that’s on them if something bad happens. You have no control over what happens inside of their computer. It’s no different than someone blindly copy pasting commands into their Linux terminal and deleting system 32.

          • Solemarc@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            6 months ago

            As far as I’m aware cybercrime is generally: “anything done maliciously involving a computer” intentionally sticking a drop table command over your plates because you’re expecting something to read your plate and input it into a db might count.

            • PriorityMotif@lemmy.world
              link
              fedilink
              arrow-up
              0
              ·
              6 months ago

              No, because it is a widly known meme and would be considered free speech as satire. Since you did not access the system, there is no crime. If a person was manually entering license plates and entered it into a database, would it be your fault? No, you had no control over that person’s actions, and no reasonable person would mistake that as a licence plate. If a computer enters it on its own, then that is also not your fault, the programmer is responsible. You have no responsibility to know how a system handles its database inputs in order to avoid messing it up.

          • 14th_cylon@lemm.ee
            link
            fedilink
            arrow-up
            0
            ·
            edit-2
            6 months ago

            All you’re doing is showing something in public which is perfectly legal.

            no, it is not, showing something in public is often not legal, it - as is often the case - depend on the context.

            It doesn’t damage the camera.

            it damages the database.

            then that’s on them if something bad happens. You have no control over what happens inside of their computer.

            no, that is on you, because you made that clearly intentionally malicious input. it is the same as if you had used the keyboard, the input method is really not important.

            do you think that if you successfully hack a bank and steal some money you will get away with the defense of “all i did was send your computer some input, sending input to computers is perfectly legal and i really don’t have any control over what is going inside it”?

            that is 5 year’s old idea of how law works.

        • I made a joke elsewhere about Amazon’s search thing using AI to generate a string that would crash the Amazon server and thought about that too afterward. If that actually worked, could someone be charged with a crime?

          • SeabassDan@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            6 months ago

            I’m only using the tools provided, not accessing anything that’s clearly pointed out I shouldn’t. If anything, that question field is specifically designed for me to use.

            • CileTheSane@lemmy.ca
              link
              fedilink
              arrow-up
              0
              ·
              6 months ago

              If I go to a hardware store and start taking a sledgehammer to the walls “I’m only using the tools provided” is not going to be a valid defense.

              • SeabassDan@lemmy.world
                link
                fedilink
                arrow-up
                0
                ·
                6 months ago

                Not a good comparison, the sledgehammer isn’t meant to be used in the store, the search function in the website is, don’t be dumb.

                • CileTheSane@lemmy.ca
                  link
                  fedilink
                  arrow-up
                  0
                  ·
                  6 months ago

                  Okay, the hardware store has a saw for customers to cut planks to the length they need. There are many ways they could “misuse the tool provided”

          • Solemarc@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            edit-2
            6 months ago

            Id guess maybe, if I generated a string using AI and intentionally crashed their stuff, it might be crime.

      • VeganCheesecake@lemmy.blahaj.zone
        link
        fedilink
        arrow-up
        0
        ·
        6 months ago

        I’m pretty sure obscuring your plates is illegal in most places in Europe. How much anyone actually cares probably depends on specific locality.