• souperk@reddthat.com
    link
    fedilink
    English
    arrow-up
    15
    ·
    edit-2
    12 hours ago

    Wondering if a volunteer could go to the physical location necessary to restore service. If it’s in Athens Greece, I can make the trip.

    Edit: The server is located in Azores, the flight would cost 415eur, I cannot afford that, maybe someone in Portugal could help?

    • IcyToes@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      11
      ·
      edit-2
      10 hours ago

      Is it in a data centre or someone’s house? If the latter, would they let a stranger in?

      Surely they would need a backup and replicate db to so in case of hardware failure they switch over.

      Sounds like they could improve their setup.

      Too much of a single point of failure.

      • Kris@feddit.org
        link
        fedilink
        English
        arrow-up
        35
        ·
        edit-2
        9 hours ago

        Slrpnk.net admin here.

        The failure seems to have been in the main firewall, if it had been the server itself we could have easily restored it on another server from the backups on another machine. But as it stands, remote access is entirely cut off.

        There usually is another person with hardware access, but they are on summer holidays. This seemed like an acceptable risk at the time…

        An off-site backup would have been nice of course, but due to the costs involved in running an Lemmy instance of that size on a rented server, it would have not been a great option either.

        I have plans to add a KVM to the main firewall via a secondary connection, but even that might have not helped in this case. I’ll know more when I have physical access again.

        • nickwitha_k (he/him)@lemmy.sdf.org
          link
          fedilink
          English
          arrow-up
          2
          ·
          2 hours ago

          I’ve done a lot of SysAdmin and DCOps stuff in the past so, thought I’d give you some plausible suggestions (haven’t dug deep into Lemmy DB stuff and DNS/Federation of the stack, so not sure all is practical).

          Scenario 1 - Preserve and merge when access is restored

          Setup

          • Spin up two VMs/VPS (or one that has enough grunt for two Lemmy servers). Call them robak.slrpnk.net and slrpnk.net and point DNS appropriately.
          • Pull federated content from other instances and place it on robak, set as read-only.
          • Sync important comms to (new) slrpnk.net without content.
          • Allow users to sign up, vetting as possible (all mods). Keep a list of those that are vetted (call it vetted.list). Inform all users that any non-vetted users will have their content dropped when access is restored.

          Merge!

          • Once access is restored, ensure that (old) slrpnk.net is set to read-only.
          • Schedule a maintenance window (announce more time than you are likely to need).
          • During the maintenance window, put (new) slrpnk.net into R/O, or just block external access.
          • Query the db on (old) slrpnk.net for all users.
          • Subtract the vetted users from vetted.list from the list.
          • Drop all records from the resulting list of non-vetted users from (new) slrpnk.net.
          • Insert the records from vetted and new users (those without conflicts) into the DB on (old) slrpnk.net.
          • Validate that everything is working
          • Cut over DNS and spin down the new VMs/VPS.

          Scenario 2 - Server is in DC or Admin able to facilitate access

          • Get a db dump/backup.
          • Spin up temporary slrpnk.net on a VM/VPS.
          • Use backup of temporary server to restore data to original, when possible.
    • A_norny_mousse@feddit.org
      link
      fedilink
      English
      arrow-up
      15
      arrow-down
      2
      ·
      11 hours ago

      Off topic, but in Portugal was the first time me, a Central European, ever ate a ripe Papaya. Yum! Thanks to the Azores. The shit you get in the supermarkets round here is useless. Same for mangoes, usually.

      • pdqcp@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        2
        ·
        edit-2
        9 hours ago

        You are in luck then, because both are climacteric fruits, meaning they continue to ripe after being harvested, due to producing ethylene gas that triggers the ripening

        Throw them in a paper bag and let them rest at room temp. If you want to speed up the process, add a ripe banana or apple (or other ripe climacteric fruits)

          • pdqcp@lemmy.dbzer0.com
            link
            fedilink
            English
            arrow-up
            3
            ·
            8 hours ago

            You might have eaten a different cultivar than those exported. In that case, I agree, there are so many different varieties that we never get to taste, supermarkets usually only have 1 or 2 different types

            • AnarchistArtificer@lemmy.world
              link
              fedilink
              English
              arrow-up
              2
              ·
              4 hours ago

              It’s baffling to me how customisable some fruit features can be. I know someone who works in plant genomics and cultivation and it’s really cool how they can use genomic analysis alongside selective breeding to select for traits. I imagine that imported papayas are cultivars that are easier to transport internationally.