tofubl @ tofubl @discuss.tchncs.de

Posts

5

Comments

188

Joined

2 yr. ago

Okay, did the migration just now. Everything seems a little more responsive, but I wouldn't call it way faster.

Either way, it wasn't very scary at all. For anybody coming after me:

• add postgres container to compose file like so. I named mine "postgres", added a "postgres" volume, and added it to depends_on for app and cron
• run migration command from nextcloud app container like any other occ command and check admin settings/system for db state: ./occ db:convert-type --password $POSTGRES_PASSWORD --all-apps pgsql $POSTGRES_USER postgres $POSTGRES_DB
• remove old "db" container and volume and all references to it from compose file and run docker compose up -d --remove-orphans

Interesting. Do you remember where you read this?

The process seems simple enough. I'm on the nextcloud:stable docker image, so adding a postgres container is really easy, but it's a scary task...

A very welcome compliment after this ordeal. Thank you! :)

The cleanest way to solve the scaling issue would probably be to go into the pdf2pic module and hack it open to accept the "pcl:fit-to-page" option that GraphicsMagick (the underlying software package doing the actual conversion from PDF to PCL) supports. (Supposing it actually does what it says. I'm not so sure about anything in printer land anymore.)

But since this whole thing is for internal documents only and the scaling can probably be estimated by choosing better values for width/height to account for printer margins I most likely won't bother.

Thanks again for suggesting Node-RED. I'm very happy with the result.

One deep dive into the IPP protocol, printer drivers, and specific supported formats ("what the hell is an octet-stream?!") later, I have something functional.

I'm not a JS guy, so I don't know if it's a very node-y way to do it. But except for the pages coming out a little scaled this works:

Edit to briefly explain what this does: The mail node ingests unread emails and passes them forward to a function node that checks for pdf attachments. Those are passed forward one by one to a function node that takes care of converting the pdf to pcl (my printer supposedly knows how to handle pdf 1.7 but doesn't, so I had to resort to this) and passes it to the IPP node as a data buffer .

I do actually use Node-RED myself for my zigbee home automation. Funny how it never crossed my mind to pick it up for this. It's perfect as I want a non-programmer to be able to maintain it.

I doubt my solution will be much more than ingest and print, but I'll report back. Still fighting to get that hp p3015 to do something over IPP...

Now this is an idea I like. Thank you so much, I never would have considered Node-RED for this application!

Thank you for the suggestion. Not exactly what I'm looking for, sadly.

Gotcha. Thanks anyway. 🙂

You're right about printing not being all that, but certain situations (my situation) call for it, at least for the time being.

This is for manufacturing orders in a low tech environment, and at this point in time I need to stick with a paper trail (so I can get rid of it in the future.)

Thanks for the reply. I don't think I fully understand what you mean.

What I would like to have is a service running on a server, fetching and printing mails. Could you please elaborate how your idea would work?

Thanks for the idea. It's not quite what I was looking for, but I might look into it more if I don't find anything better.

From the looks of it, it requires python scripting anyway, so there isn't a big advantage to fetching the mail with python and imaplib directly.

The killer feature for me is my networked scanner scanning directly to the paperless consume samba share and the documents just popping up in the inbox fully OCRd and pre-categorised. Pretty magical.

NB, the docs make it sound like a proper DB is optional, but it's really not. Performance was iffy for me with sqlite but is rock solid with Postgres.

Paperless-NGX

This ticks all your boxes. It's really good.

Papery taste, according to James Hoffmann.

The Truth about V60 Filter Papers

Snapcast works incredibly well for multi-device audio.

Has anyone tried setting up multiple zones with it that can play different things at the same time? I imagine you would need one snapcast server per zone? And is there an easy way to assign the clients to one of the servers?

So I had a very nasty behaviour of my exchange work calendar which I synced into my Nextcloud calendar, and it would automatically cancel and recreate all events, which would resend invitations to attendees. It was very unprofessional, to say the least.

After months of this, I finally figured out that the culprit was the calendar auto-backup in the Android Nextcloud client. Turned it off, and my problems went away. Maybe you have something similar going on?

If only every Windows install came with an internet exploder! We wouldn't have to read Elon Musk X fluff pieces on the news ever single day. And privacy concerns... What privacy concerns?

Just been through the fire of having to clone my system to a new SSD and no, startup repair did nothing for me.

I've recently started using a Hetzner storage box for encrypted daily incremental backups and I'm very happy with it so far.

I'm sorry to hear it, and I hope you are being kind to yourself.

Woah, are you okay?