Ephes Blog

Miscellaneous things. Not sure what to put here, yet.

RSS feed icon Plain RSS

Weeknotes 2022-12-19

modern js frameworks are only possible in a negative real interest rate environment --htmx.org

Got more stuff done last week - getting better I guess 😀:

Articles

Weeklogs

Videos

Mastodon / Twitter

Software

Podcasts

Out of Context Images

Schnee mit Eiskristallen Tanne mit Schnee Grashalm im Schnee

TIL: Flush the FRITZ!Box DNS Cache

I tried to change some DNS records today, and even after the TTL was over, I couldn't get the updated records on my notebook. I flushed the DNS cache on macOS but it didn't work. After some debugging, I found that my FRITZ!Box might be the culprit.

How to do it

Just go to:

Heimnetz > Netzwerk > Netzwerkeinstellungen > IPv4-Einstellungen

And then deactivate DHCP and reactivate it afterward. This will flush the DNS cache without the need for a restart. My changed DNS records were available right after doing this đŸ€Ș.

TIL: Change Owner of Postgres Database Objects Using Ansible

For my very modest deployment needs, I use ansible. After restoring a postgres database backup using the community.general.postgresql_db role, the normal deployment of a Django app didn't work anymore. The python manage.py migrate command failed complaining it cannot modify a table not owned by the user running the migration. Turns out that all the tables in the database are owned by the postgres user after restoring the database.

Ok, let's just add an ansible task changing the owner using the postgresql_owner role. But reassign_owned_by does not work if the source user is postgres and specifying all the tables, sequences, and views manually seems to be just wrong. So my solution for this was to copy and paste a solution from StackOverflow into two ansible tasks.

- name: Create postgres function to be able to change owner of db objects
      postgresql_query:
        db: "{{ postgres_database }}"
        query: |
          CREATE FUNCTION exec(text) returns text language plpgsql volatile
            AS $f$
              BEGIN
                EXECUTE $1;
                RETURN $1;
              END;
          $f$;
      become: true
      become_user: postgres
      ignore_errors: true

    - name: "Change owner of all tables in db to {{ postgres_user }}"
      postgresql_query:
        db: "{{ postgres_database }}"
        query: |
          SELECT exec('ALTER TABLE ' || quote_ident(s.nspname) || '.' ||
                      quote_ident(s.relname) || ' OWNER TO "{{ postgres_user }}"')
            FROM (SELECT nspname, relname
                    FROM pg_class c JOIN pg_namespace n ON (c.relnamespace = n.oid)
                   WHERE nspname NOT LIKE E'pg\\_%' AND
                         nspname <> 'information_schema' AND
                         relkind IN ('r','S','v') ORDER BY relkind = 'S') s;

      become: true
      become_user: postgres

Update: This should no longe be an image. Code blocks ftw!

Sorry for the image, I still have to implement code blocks for wagtail. I added those two tasks to my database restore playbook and now all database objects belong to the original user. Maybe there's a better way to do this, but maybe this is also helpful for someone. If you know how to do this properly: let me know 🙂.

Weeknotes 2022-12-12

Due to personal reasons, I've decided to replace my hair with snakes & turn people who stare at me into stone. @roxiqt@mastodon.social

Had a stressful week due to private turmoil and couldn't get anything done.

Articles

Videos

Weeklogs

Mastodon / Twitter

Software

Podcasts

Out of Context Images

Weihnachtsmarkt Maastricht Übersicht Riesenradkabine Riesenrad Detail Riesenrad komplett Roter Stern

Weeknotes 2022-12-05

my work is terrible, and if *you* like it, well that says more about you than it does about me @carnapping

Worked the whole week with sick kids at home and finally got sick, too. Using the new Wagtail-based django-cast in production revealed lots of little bugs I tried to fix:

  • Fixed the title tag for post detail pages - thanks to Johannes for reporting this
  • Fixed gallery.html images to link to the original image source image (not relevant for this site, but sometimes relatives are trying to print out photos, etc: now they get at least a fair chance to print decent-looking images)
  • Lazy loading for gallery images (the image sizes are not quite right, yet this is just a mitigation)
  • Increased Gunicorn timeout to 10 minutes -> it's now possible to upload big videos
  • Fixed the size of the feed logo for my homepage (the python-podcast logo is inside a javascript blob called subscribe button, I have no idea how to put a size on that)
  • Upgraded from raven to sentry_sdk for my homepage and python-podcast (depleted my sentry transaction immediately, I have no idea why)
  • Fixed traefik config for mastodon: removed the separate config file for streaming
  • Fixed x-forwarded-for logging for Gunicorn for django-template, homepage, and python-podcast.de
  • Updated bootstrap and jquery for my homepage and python-podcast, removed popper
  • Added Plausible to my homepage and python-podcast (my own analytics stuff is still broken, maybe someone fixed this in the meantime by providing a suitable SaaS?)
  • Fixed a small bug in django-cast causing wagtail preview to fail

Merged a PR to my little kptncook command line scraper. More about this in Kptncook and Mealie.

Articles

Fediverse / Indieweb

Seems this should get its own category by now 😎.

Twitter / Mastodon

Software

Podcasts