GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Notices by ilja (ilja@ilja.space), page 2

  1. Embed this notice
    ilja (ilja@ilja.space)'s status on Tuesday, 13-Jun-2023 00:45:06 JST ilja ilja

    I was getting annoyed to always have to look through bash history for finding specific http requests, so i decided to make a gui tool :blobfoxcheer:

    Something like this already exists ofc, but the one people typically use isn't floss, and i wanted an excuse to get experience with at least some gui framework/library.

    It's very basic atm, only GET requests are implemented, and even then it only shows the response body. But I can already save and open requests, so hooray. I'll probably continue working on it, implementing features as i need them.

    If any one is interested, repo is https://codeberg.org/ilja/gibme/

    Oh yeah, and if you're wondering about the name, i was inspired by the 10grans bot :blobfoxlaughsweat:

    In conversation Tuesday, 13-Jun-2023 00:45:06 JST from ilja.space permalink

    Attachments


    1. https://media.ilja.space/media/a6560954-904b-427c-9cc5-d6319fe6901f/Screenshot_20230612_172712.png

    2. Invalid filename.
  2. Embed this notice
    ilja (ilja@ilja.space)'s status on Tuesday, 30-May-2023 00:30:09 JST ilja ilja
    • :sprout: evil mental tofu haver
    @FloatingGhost i have the hypothesis that actually no one knows anything, but some are just used to pretending they do, and the rest just follows bc in the end, the advice seems sound regardless.
    In conversation Tuesday, 30-May-2023 00:30:09 JST from ilja.space permalink
  3. Embed this notice
    ilja (ilja@ilja.space)'s status on Monday, 29-May-2023 22:03:33 JST ilja ilja
    • Oneesan succubus

    For Akkoma peeps who host their media on the same domain as akkoma-fe, see this post from @lain

    I also made a post on the forum about it https://meta.akkoma.dev/t/another-vector-for-the-injection-vulnerability-found/483

    RE: https://pleroma.soykaf.com/objects/3b39ef1b-194e-44ec-b726-b8d83a478961

    In conversation Monday, 29-May-2023 22:03:33 JST from ilja.space permalink

    Attachments

    1. Domain not in remote thumbnail source whitelist: meta.akkoma.dev
      Another vector for the injection vulnerability found
      See Pleroma/Soykaf As you all probably know (if not, see the comments in https://meta.akkoma.dev/t/akkoma-stable-2023-05-baked-beans-and-spam/475/8), there has recently been discovered an injection vulnerability in Akkoma-fe. Both Pleroma and Akkoma are affected by it. Some fixes have already been done do mitigate this issue, but yet another attack vector has been found. From what I understand, the vulnerability allows remote code execution with code being injected through media. When that med...

  4. Embed this notice
    ilja (ilja@ilja.space)'s status on Saturday, 06-May-2023 05:08:46 JST ilja ilja
    in reply to
    • lainy
    @lain yeah im lgbt, Lover of Good Botanical Things
    In conversation Saturday, 06-May-2023 05:08:46 JST from ilja.space permalink
  5. Embed this notice
    ilja (ilja@ilja.space)'s status on Wednesday, 01-Mar-2023 01:45:37 JST ilja ilja
    in reply to
    • lainy
    @lain we don't have hundreds of years of rock yet :blobfoxthink:
    In conversation Wednesday, 01-Mar-2023 01:45:37 JST from ilja.space permalink
  6. Embed this notice
    ilja (ilja@ilja.space)'s status on Sunday, 19-Feb-2023 19:26:54 JST ilja ilja
    in reply to
    • lainy
    @lain Not entirely sure what "the whole left of the universe" exactly entails, but in general and with current understanding, my guess would be that you wouldn't feel that :blobfoxthinking: If there's a gravitational attraction change, the earth would start to accelerate in a different direction to compensate, so the net result to you would be the same. Otoh, there will be a stronger force on one side of the planet then the other, but I'm not sure how much of a difference that would make :blobfoxthink: Or maybe you're on the "left part" who disappeared, in which case you may not feel anything at all any more :blobfoxo_o:
    In conversation Sunday, 19-Feb-2023 19:26:54 JST from ilja.space permalink
  7. Embed this notice
    ilja (ilja@ilja.space)'s status on Friday, 17-Feb-2023 03:34:56 JST ilja ilja
    • lainy
    @lain fav this post if you like Nikola Tesla, or if you like furry sex robot. Nobody will know wich
    In conversation Friday, 17-Feb-2023 03:34:56 JST from ilja.space permalink
  8. Embed this notice
    ilja (ilja@ilja.space)'s status on Monday, 13-Feb-2023 00:07:09 JST ilja ilja
    in reply to
    • lainy
    • Sarvo
    • your new favourite fungus

    @lain @sarvo @duponin Not that I could find. What I did find is that you can pass a list with what you want to restore and in what order. But it still takes some extra steps and even with these steps added to the docs, people still just did a dump and restore like they were used to (and then understandably still complained that restoration goes super slow).

    To get the list

    pg_restore -l pleroma.pgdump > db.list

    Then find the line where the index is restored and move it. Then restore using the new list with

    sudo -Hu postgres pg_restore -L db.list -d pleroma -v -1 pleroma.pgdump
    In conversation Monday, 13-Feb-2023 00:07:09 JST from ilja.space permalink
  9. Embed this notice
    ilja (ilja@ilja.space)'s status on Monday, 13-Feb-2023 00:07:05 JST ilja ilja
    in reply to
    • lainy
    • ilja
    • Sarvo
    • your new favourite fungus
    @lain @duponin @sarvo I was also thinking for a while that maybe postgresql should be more smarter in dumping, but then I realised that this is really just a very edge-case thing, so I didn't bother filing a feature request for it.
    In conversation Monday, 13-Feb-2023 00:07:05 JST from ilja.space permalink
  10. Embed this notice
    ilja (ilja@ilja.space)'s status on Sunday, 12-Feb-2023 23:53:30 JST ilja ilja
    in reply to
    • lainy
    • Sarvo
    • your new favourite fungus
    @duponin @lain @sarvo https://akkoma.dev/AkkomaGang/akkoma/pulls/427
    In conversation Sunday, 12-Feb-2023 23:53:30 JST from ilja.space permalink

    Attachments

    1. Domain not in remote thumbnail source whitelist: akkoma.dev
      Allow the prune_objects task to delete orphaned activities
      from AkkomaGang
      This builds further on https://akkoma.dev/AkkomaGang/akkoma/pulls/350 , but i made it a separate PR so we can keep changes smaller in the hope that this makes reviewing easier. Do let me know if it's better to keep the whole thing as one PR. After pruning objects, we still have a whole bunch of activities that don't link to anything existing any more. Here we find and delete those activities. * [x] Make a first working thing * [x] Make it work for also object-arrays * [x] Dogfood (woof woof) * The first run, it had to prune 2+ years worth of activities and took over 24h to complete * I then ran on a daily basis and it takes 20-30min each time * After vacuum full, my DB size went from ~10G to ~3G ? * [x] Docs * [x] While we're at it, improve the docs to explain the vacuum full and mention autovacuum (could also be a separate MR). See https://akkoma.dev/AkkomaGang/akkoma/issues/436#issuecomment-6948 * https://docs.akkoma.dev/develop/administration/CLI_tasks/database/#prune-old-remote-posts-from-the-database * https://docs.akkoma.dev/develop/configuration/postgresql/ * Autovacumm should be on by default according to Postgresql docs, so it doesn't seem like something I should add here. * Maybe other places where it makes sense... * Also added it to the vacuum task. Otherwise the only postgresql references I see in the docs are in the install guides. I made this an option because it may cause extra load, time, and risk. Note that I also check what tables we have in the DB. As explained in the comments of the test, this is because the objects that the activities point to can be stored in different tables. Currently I see three of them, but it's possible we add more tables in the future. If those tables also hold objects and we don't check there, we may delete activities who shouldn't be deleted. For that reason I make a test fail when a new table is added.
  11. Embed this notice
    ilja (ilja@ilja.space)'s status on Sunday, 12-Feb-2023 23:53:27 JST ilja ilja
    in reply to
    • lainy
    • Sarvo
    • your new favourite fungus
    @duponin @lain @sarvo You'll never going to believe this, but https://akkoma.dev/AkkomaGang/akkoma/pulls/455 :blobfoxsmirk: (should make restoration of DB significantly faster)
    In conversation Sunday, 12-Feb-2023 23:53:27 JST from ilja.space permalink

    Attachments

    1. Domain not in remote thumbnail source whitelist: akkoma.dev
      Rename index for faster database restore
      from AkkomaGang
      fix https://akkoma.dev/AkkomaGang/akkoma/issues/440 I manually changed the index name. On a 10G dump it took ~30min to restore with this rename. I don't know exactly how long it took without renaming the index, but I tried and cancelled the operation after it was already stuck on the problematic index for over 1h. I also saw that the renamed index is indeed the very first index that's being restored (and before the "problematic" activities_visibility_index). Renaming the index: ```sh sudo -Hu postgres psql -d akkoma -c "ALTER INDEX public.\"users_ap_id_COALESCE_follower_address_index\" RENAME TO \"aa_users_ap_id_COALESCE_follower_address_index\";" ``` It's a bit dirty because we go away from naming conventions, but if it works, I think it's worth it. * [x] Write a migration for it (and make it clear in a comment why we do it) * [x] See that new installations can still create a DB from scratch (sometimes you need things outside of transactions, I'm unsure if this is also such one) * [x] Adapt docs (backup-restore doesn't need the note for this any more, maybe also add to changelog) * [x] Run in prod ? * Cherry picked the commits, ran the migration and restarted my instance. Things still work * Stopped instance, did db dump, extracted the list to see the order of indexes, the renamed one is indeed the first. * Dropped database, recreate database, restore from dump. We see that the renamed index is restored as first index[1]. DB is 3G in size, restoration took less then 10 minutes. Afterwards I restarted the instance and things seem to still run smoothly. [1] Excerpt from the output from restoring the DB. We see the renamed index being the first index restored (2nd output line), and the "problematic" visibility index only later (last output line of this excerpt). ``` ... pg_restore: creating CONSTRAINT "public.users users_pkey" pg_restore: creating INDEX "public.aa_users_ap_id_COALESCE_follower_address_index" pg_restore: creating INDEX "public.activities_actor_id_DESC_NULLS_LAST_index" pg_restore: creating INDEX "public.activities_cc_index" pg_restore: creating INDEX "public.activities_context_index" pg_restore: creating INDEX "public.activities_create_objects_index" pg_restore: creating INDEX "public.activities_hosts" pg_restore: creating INDEX "public.activities_id_desc_nulls_last_local_index" pg_restore: creating INDEX "public.activities_in_reply_to" pg_restore: creating INDEX "public.activities_likes" pg_restore: creating INDEX "public.activities_local_index" pg_restore: creating INDEX "public.activities_recipients_index" pg_restore: creating INDEX "public.activities_to_index" pg_restore: creating INDEX "public.activities_unique_apid_index" pg_restore: creating INDEX "public.activities_visibility_index" ... ```
  12. Embed this notice
    ilja (ilja@ilja.space)'s status on Sunday, 12-Feb-2023 02:34:15 JST ilja ilja

    There's a masto instance whith 150 users and they ask a monthly fee to get an account, and that fee is more expensive than getting your own instance from masto.host :/

    I swear, sometimes you just have to be not afraid to ask money, and we're all idiots for not doing that…

    In conversation Sunday, 12-Feb-2023 02:34:15 JST from ilja.space permalink
  13. Embed this notice
    ilja (ilja@ilja.space)'s status on Sunday, 12-Feb-2023 02:34:09 JST ilja ilja
    in reply to
    • 「 Fried Fristi 」
    @fristi Oh, it gets even better :) From the about page:

    "For December 2022 and January 2023, [Name of instance] is being generously sponsored by our hosts, [Name of host]! "
    In conversation Sunday, 12-Feb-2023 02:34:09 JST from ilja.space permalink
  14. Embed this notice
    ilja (ilja@ilja.space)'s status on Sunday, 12-Feb-2023 02:34:07 JST ilja ilja
    in reply to
    • 「 Fried Fristi 」
    • ilja
    @fristi Anyhow, regardless, people know what they get and they can always move if they want, so it's not that I think this is bad or anything. But it is a bit surprising to me that this actually works. But that's really more a "me" problem than a "them" problem.
    In conversation Sunday, 12-Feb-2023 02:34:07 JST from ilja.space permalink
  15. Embed this notice
    ilja (ilja@ilja.space)'s status on Friday, 10-Feb-2023 12:02:26 JST ilja ilja
    in reply to
    • lainy
    @lain cosmos has a postgresql api, so that's three :blobfox3c: (not sure how "complete" it is, though)
    In conversation Friday, 10-Feb-2023 12:02:26 JST from ilja.space permalink
  16. Embed this notice
    ilja (ilja@ilja.space)'s status on Thursday, 09-Feb-2023 14:43:25 JST ilja ilja
    in reply to
    • lainy
    @lain Sounds about right. I have a rule-of-thumb that (assuming 2% inflation yearly) prices double every ~30 year (every 35 year to be more precise). Which is quite wild when you think about it, because that means that by the time you retire, you've seen prices go ~ times 4 in your life!
    In conversation Thursday, 09-Feb-2023 14:43:25 JST from ilja.space permalink
  17. Embed this notice
    ilja (ilja@ilja.space)'s status on Monday, 06-Feb-2023 00:50:33 JST ilja ilja
    in reply to
    • Evan Prodromou
    • jph
    @jph @evan
    > I'm not really sure what I could do other than maybe vote for the people I already vote for?

    If you have the choice of several suppliers, then switching to the cleanest one may be an option. Where I live, Greenpeace has a ranking. I switched from a provider who had a 6/20 score to one who has a 19/20 score. And this summer one of the coops who have a 20/20 score should open up for contracts again. This may ocf not be an option for everyone.

    I still chose Qualified Yes, though. I'm not sure if in this day and age a Strong Yes is something that really exists.
    In conversation Monday, 06-Feb-2023 00:50:33 JST from ilja.space permalink
  18. Embed this notice
    ilja (ilja@ilja.space)'s status on Friday, 03-Feb-2023 06:26:45 JST ilja ilja
    in reply to
    • lainy
    @lain lain is responsible for mutti, not mutti herself :blobfox3cevil:
    In conversation Friday, 03-Feb-2023 06:26:45 JST from ilja.space permalink
  19. Embed this notice
    ilja (ilja@ilja.space)'s status on Thursday, 26-Jan-2023 00:47:37 JST ilja ilja
    in reply to
    • lainy
    @lain I followed this channel years ago and it's really good!
    In conversation Thursday, 26-Jan-2023 00:47:37 JST from ilja.space permalink
  20. Embed this notice
    ilja (ilja@ilja.space)'s status on Wednesday, 25-Jan-2023 03:25:29 JST ilja ilja
    in reply to
    • lainy
    @lain don't worry, neither are the cd's :blobfoxuwu: (they actually seem good)
    In conversation Wednesday, 25-Jan-2023 03:25:29 JST from ilja.space permalink
  • After
  • Before

User actions

    ilja

    ilja

    Hellooo :blobfoxwave: I'm ilja!I try to improve myself and the world by trying to contribute to the world of free software. Floss projects that currently interest me the most are Pleroma, YUNoHost and Ubuntu Touch. My main focus is currently Pleroma.I created the following bots: @citizeninitiativebot@ilja.space @translate@ilja.space @ccmusicbot@ilja.space @translate uses an MRF module I made with the goal of making it easier to create "reply and I respond"-type bots. If you're interested in that, check out it's profile.What people say about me:"I will haunt your soul for eternity, smartass" --fristi"one of the best lines in the pleroma code" --lain (talking about some code I wrote)"MEW MEW MEW MEW" --oceanTrans rights are human rights :transflag: :agenderflag: queer rights are human rights :rainbowflag: :lesbianlipstick_flag: And it's sad that over half a century after the Stonewall uprising, we still have to remember peop

    Tags
    • (None)

    Following 0

      Followers 0

        Groups 0

          Statistics

          User ID
          1729
          Member since
          26 Jul 2022
          Notices
          206
          Daily average
          0

          Feeds

          • Atom
          • Help
          • About
          • FAQ
          • TOS
          • Privacy
          • Source
          • Version
          • Contact

          GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

          Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.