Yup, this is the last time I muck around with spamassassin unless the project gets a magical revival.
I think I got it working. I've got this in /etc/default/spamd:
undefined
OPTIONS="-x -q -u spamd --max-children 5 -H /etc/mail/spamassassin/"
and this in /etc/default/spamass-milter:
undefined
OPTIONS="-e example.com -u spamass-milter -i 127.0.0.1"
And it definitely reads user prefs from the database because I can change the 'required_hits' to 6.7 for a given user and I see this in the logs:
undefined
spamd[523771]: spamd: clean message (-0.2/6.7) for user@example.com:133 in 1.2 seconds, 24427 bytes.
I don't know how many different combinations of config flags I've tried, but these seem to do the job.
Email server help: postfix and spamassassin with user prefs in MySQL
Hi,
I'm trying and failing to get spamassassin to load user prefs from a mysql database. I'm using spamass-milter and I can't find any way in the docs to send anything. spamass fails to parse the recipient as the user and just uses it's running user in it's call to spamd. The database is properly configured and I can connect and set settings from roundcube. The sql config is added to local.cf.
I know that you can use spamd as a pipe, and then you can pass more variables, but I can't figure out the correct config for this setup.
This is what I have in /etc/default/spamd:
OPTIONS="-Q -x --max-children 5 -D sql,bayes -H /etc/mail/spamassassin/"
I've also tried multiple combinations with the flags -q, without -x...
And this is what I have in /etc/default/spamass-milter
OPTIONS="-u spamass-milter -x -i 127.0.0.1"
Where again I've tried without -u, with -e domain.com to explicitly set the domain.
If anyone has any advice or can point me to a recent tutorial for Ubuntu 24.04, I wo
“Japanese” duplex
No, lol! I wish I had known of this or would've been clever enough to come up with something similar. I basically just yolo'd it the best I could. It was a torture.
I've put everything up on github: V6 conversion. Have fun. If you are going to get into this adventure, this might come in handy (it helped me): How to Build a Custom Keyboard From Scratch
That's a nice board!
Yes, I got it made at jlcpcb. It’s a big board, so it wasn’t as cheap as a small prototype board. But not unreasonable. A good price per board, but a bit of a waste because I now have 4 more that I will never use.
Yes, I want to, just haven’t gotten around to put it all together yet. But it’s on my to do list.
It was a fun process, much recommended. I've got an extra 4 pcbs that require a few bodge wires if you've got a V6. :D
I made my own pcb to "un-south" my Keychron v6
I was initially excited about my Keychron V6 keyboard, I was looking forward to a thockier keyboard and wanted the customizability with qmk. The V6 seemed like a good match. But after unboxing it, I realized that the south-facing LEDs weren't ideal. I had just purchased Razer PBT keycaps, which I loved, but they didn't work at all with the LEDs and the escaping light underneath just blinded me.
I tried to make the setup work with custom keycaps from fkcaps (https://fkcaps.com/custom/5ELZPQ). While they were cool, they weren't the same as double-shot PBT keys. The setup wasn't ideal but I just stuck with it.
When I saw a YouTube video about building a keyboard with KiCad, I was inspired to try it myself. I used an ATmega32U, because I thought it would be easier to integrate, but it did have it's challenges: limited I/O meant I had to sacrifice the layout switch, and my matrix is best described as "tortuous". Despite a few errors on my PCB (a group of LEDs were not connected and I comp