<2022-11-08T02:47:24.000Z> matty@nicecrew.digital: Hey, did Graf assist you with tuning your postgres configuration?
<2022-11-08T03:27:46.000Z> chudbere: no
<2022-11-08T03:28:01.000Z> chudbere: we haven't done that yet
<2022-12-07T02:04:08.000Z> chudbere: Matty what method do you use to run a backup of the pleroma database
<2022-12-07T02:21:54.000Z> matty@nicecrew.digital: #create postgres dumpecho "dumping postgres DB"sudo -Hu postgres pg_dumpall | gzip > /tmp/pleroma_dump.gz#create zip file for easy transfer#tar czvf /tmp/pgdump.tar.gz /tmp/pg_dump.pgdump#remove uncompressed pgdump#rm /tmp/pg_dump.pgdump#move the dump to your external backup location (if needed)echo "moving postgres DB to offsite backup"mv /tmp/pleroma_dump.gz /mnt/remote/backups/postgres/"$(date +"%FT%H")_pleroma.gz"
<2022-12-07T02:22:06.000Z> matty@nicecrew.digital: The first two commands are to create the actual backup
<2022-12-07T02:23:20.000Z> chudbere: okay a few questions
<2022-12-07T02:23:37.000Z> chudbere: do you switch to opt/pleroma before running the sudo command
<2022-12-07T02:23:49.000Z> chudbere: do you stop pleroma while running this
<2022-12-07T02:24:51.000Z> matty@nicecrew.digital: No. Dumps don't require you to halt the database service or the Pleroma service. 
<2022-12-07T02:25:29.000Z> matty@nicecrew.digital: And no, you can run the command just like that from root because the sudo - Hu command switches to the postgres user for the rest of the command. 
<2022-12-07T02:27:30.000Z> chudbere: gave this error but checking my filesystem i see the dump file
<2022-12-07T02:31:39.000Z> matty@nicecrew.digital: That error is fine. It's still running. 
<2022-12-07T02:31:51.000Z> matty@nicecrew.digital: It'll take time for it to complete. Just run the command and let it go. 
<2022-12-07T02:31:54.000Z> chudbere: okay
<2022-12-07T02:32:18.000Z> chudbere: I'm going to attempt to do the delete notifications older than 2 months query later
<2022-12-07T02:32:38.000Z> chudbere: wanted to have a backup first and the way graf does backups was confusing 
<2022-12-07T02:32:41.000Z> matty@nicecrew.digital: Okay. You can set up a cron job to run the dump every day. 
<2022-12-07T02:33:10.000Z> chudbere: was what you pasted from your crontab?
<2022-12-07T02:33:20.000Z> matty@nicecrew.digital: No. That's the actual script. 
<2022-12-07T02:33:36.000Z> chudbere: okay
<2022-12-07T02:38:09.000Z> chudbere: thank you for your help
<2022-12-07T02:44:31.000Z> matty@nicecrew.digital: Any time! 
<2022-12-07T02:45:10.000Z> chudbere: 2GB database, not as big as I thought as it would be
<2022-12-07T02:46:30.000Z> matty@nicecrew.digital: That's the compressed size.
<2022-12-07T02:46:43.000Z> chudbere: oh true, forgot it's running gzip
<2022-12-07T02:48:09.000Z> matty@nicecrew.digital: That and the dump will make it much smaller. 
<2022-12-07T02:48:32.000Z> matty@nicecrew.digital: du -sh /var/lib/postgresql will give you the size of the database 
<2022-12-07T02:50:05.000Z> chudbere: 24GB lol
<2022-12-07T02:50:41.000Z> matty@nicecrew.digital: Yeah that's more like it.
<2022-12-07T02:50:53.000Z> matty@nicecrew.digital: Not bad though, considering the size of your user base.
<2022-12-07T02:50:56.000Z> matty@nicecrew.digital: Mine's 38 GB
<2022-12-07T18:06:54.000Z> chudbere: Wasn't this peach person just involved in some drama with you guys? 
<2022-12-07T18:07:02.000Z> matty@nicecrew.digital: Yup. 
<2022-12-07T18:07:25.000Z> chudbere: Anything I should be aware of since they've made an alt here now?
<2022-12-07T18:08:42.000Z> matty@nicecrew.digital: I personally consider them bad actors. 
<2022-12-07T18:09:21.000Z> chudbere: They dox or anything like that? 
<2022-12-07T18:10:29.000Z> matty@nicecrew.digital: They post pictures of an individual who (allegedly) DM'd someone else a picture of themselves. This was shared, and then they posted it on the fediverse or something. They say that this individual posted a picture of themselves publicly, but I've not seen any evidence to back up that claim and based on what I know about them, I assume they're lying.
<2022-12-07T18:11:32.000Z> matty@nicecrew.digital: If you're going to allow that group  of people on your platform, make sure you watch them. Billington, Crom and Peach primarily. Get ready for the drama because Billington will inevitably sperg out on you. I think he has serious mental issues.
<2022-12-07T18:16:47.000Z> chudbere: i don't think billington has made an alt yet
<2022-12-07T18:16:56.000Z> chudbere: i see crom did this morning as well
<2022-12-07T18:17:22.000Z> matty@nicecrew.digital: They move like a pack of retarded dogs. 
<2022-12-07T18:17:24.000Z> chudbere: they won't be posting facedox of anyone here
<2022-12-07T18:17:54.000Z> matty@nicecrew.digital: Alright, they will. Just warning you ahead of time. They'll also be generally disagreeable. Think of like a high school clique but with extra chromosomes.
<2022-12-07T18:19:46.000Z> chudbere: gotcha
<2022-12-07T18:20:05.000Z> matty@nicecrew.digital: Any way, let me know if there's anything I can do for you!
<2022-12-07T18:20:20.000Z> chudbere: i just mean if they try to post facedox it will be deleted and then they can sperg and leave or if they keep doing it they will be yeeted
<2022-12-07T18:20:53.000Z> chudbere: idk why they think coming here would be a good fit given that I don't even allow people to post pictures of graf here
<2022-12-07T18:20:55.000Z> matty@nicecrew.digital: Then prepare to yeet them lmao. I'm not sure what your TOS is like but they'll try to bend it. They also like posting pornography, if memory serves me right.
<2022-12-07T18:21:40.000Z> chudbere: we allow nudes/lewds as long as it's marked nsfw. no loli and no super degenerate or obscene stuff. 
<2022-12-07T18:22:46.000Z> matty@nicecrew.digital: Like I said, they'll try to bend the rules. You'll see what I mean. They don't do the loli/cp stuff as far as I know so they at least have that going for th em.
<2022-12-07T18:23:35.000Z> chudbere: yeah all my mods are on watch, pliskin and mackivelli saw what happened between them and nicecrew when they were on eveningzoo
<2022-12-07T18:27:39.000Z> matty@nicecrew.digital: When you give them the boot, they'll also continue to run their mouths about you even though you did literally nothing wrong. They act like children. Regardless, just be aware. 
<2022-12-07T18:35:36.000Z> chudbere: that's fine, i give less than zero fucks about what anyone says about me or the instance, especially people who have been banned
<2022-12-08T00:20:26.000Z> matty@nicecrew.digital: That's a good outlook to have. If there's anything I can do for you, please let me know.
<2022-12-08T00:20:44.000Z> chudbere: i sure will, thankyou
<2022-12-10T18:33:39.000Z> chudbere: do you use certbot/letsencrypt for SSL certificates
<2022-12-10T18:38:19.000Z> matty@nicecrew.digital: Yes. 
<2022-12-10T18:39:22.000Z> chudbere: ours is almost up for renewal, what is the process you do for that? 
<2022-12-10T18:39:30.000Z> chudbere: this is the instructions on soapbox
<2022-12-10T18:40:04.000Z> matty@nicecrew.digital: Just do certbot in the command line. It'll walk you through the rest of the steps. 
<2022-12-10T18:40:28.000Z> chudbere: do i need to be root or pleroma
<2022-12-10T18:40:33.000Z> matty@nicecrew.digital: Root. 
<2022-12-10T18:41:47.000Z> chudbere: okay
<2022-12-10T18:42:03.000Z> matty@nicecrew.digital: It should be pretty simple but let me know if you have any problems 
<2022-12-10T18:42:12.000Z> chudbere: okay
<2022-12-10T18:43:39.000Z> chudbere: is this what i should run (last line)
<2022-12-10T18:43:54.000Z> chudbere: i just need it to renew/replace our existing certbot certificate
<2022-12-10T18:51:54.000Z> chudbere: i gotta run a kid to a friend's house, just when you get a chance lmk if i did this right or whether i need to fix that error :)
<2022-12-10T19:54:06.000Z> matty@nicecrew.digital: try certbot --certonly -d chudbuds.lol
<2022-12-10T19:55:36.000Z> chudbere: okay yes, place in root?
<2022-12-10T19:57:36.000Z> matty@nicecrew.digital: it should overwrite the current certificates you have
<2022-12-10T19:57:50.000Z> matty@nicecrew.digital: But, you could add the path flag if you wish
<2022-12-10T20:00:13.000Z> matty@nicecrew.digital: Why are you using webroot?
<2022-12-10T20:00:30.000Z> chudbere: i didn't know which one to pick
<2022-12-10T20:00:31.000Z> matty@nicecrew.digital: You could just use the temporary webserver. This may require you to turn off NGINX for a moment though
<2022-12-10T20:00:35.000Z> chudbere: i can back out and start again
<2022-12-10T20:01:14.000Z> matty@nicecrew.digital: Wait, are you using NGINX?
<2022-12-10T20:01:22.000Z> chudbere: yes
<2022-12-10T20:01:25.000Z> matty@nicecrew.digital: do this
<2022-12-10T20:01:30.000Z> matty@nicecrew.digital: apt install python3-certbot-nginx
<2022-12-10T20:01:36.000Z> matty@nicecrew.digital: It's an NGINX plugin for certbot.
<2022-12-10T20:02:01.000Z> chudbere: done
<2022-12-10T20:02:26.000Z> matty@nicecrew.digital: Now run it again - but this time do "certbot renew"
<2022-12-10T20:06:10.000Z> chudbere: do i need to stop nginx?
<2022-12-10T20:29:35.000Z> chudbere: got it figured out
<2022-12-10T20:32:55.000Z> matty@nicecrew.digital: Got it renewed? 
<2022-12-10T20:33:43.000Z> chudbere: yeah
<2022-12-10T20:33:50.000Z> matty@nicecrew.digital: Nice job! 
<2022-12-10T20:33:53.000Z> chudbere: i had to stop nginx and run it then start it again
<2022-12-10T20:34:11.000Z> chudbere: and uncomment a section in the nginx config
<2022-12-10T20:39:27.000Z> matty@nicecrew.digital: What did you uncomment? 
<2022-12-10T20:47:44.000Z> chudbere: location ~ /.well-known/acme-challenge/ {root /var/lib/letsencrypt/;}
<2022-12-10T20:48:03.000Z> chudbere: okay so i just noticed a new issue after updating soapbox earlier today
<2022-12-10T20:48:33.000Z> chudbere: react container is now being cutoff by the edge of the post on desktop
<2022-12-10T20:48:40.000Z> chudbere: on mobile it still wraps to two rows
<2022-12-10T20:50:15.000Z> matty@nicecrew.digital: I had to make a custom build with custom CSS to fix that. I think Alex will have a fix for it at some point in production 
<2022-12-10T20:51:29.000Z> chudbere: it was fine on the previous build we were on
<2022-12-10T20:51:49.000Z> chudbere: on desktop the reacts just extended out wide on one row, floating above the post container
<2022-12-10T20:52:05.000Z> chudbere: now it's being cutoff
<2022-12-10T20:52:12.000Z> matty@nicecrew.digital: I don't know what to tell you. It changes based on the view you're on, whether it's the selected status or a status in the feed. 
<2022-12-10T20:54:31.000Z> chudbere: bleh. just a pain in the butt
<2023-02-04T20:38:35.000Z> chudbere: how did your migration go
<2023-02-04T20:39:19.000Z> matty@nicecrew.digital: Fine, for the most part. It's just slow. I don't know why. It shouldn't be. I don't know what I'm doing wrong here or what is misconfigured. Maybe it just needs time 
<2023-02-04T20:50:55.000Z> chudbere: Hopefully so!
<2023-02-04T20:52:59.000Z> chudbere: I was going to ask you if there was a certain script you used to make the nigbot on your instance
<2023-02-04T20:53:16.000Z> chudbere: I'd like to make a similar one that replies to people randomly
<2023-02-04T20:54:24.000Z> matty@nicecrew.digital: I built my script 
<2023-02-04T20:54:34.000Z> chudbere: oooh okay lol
<2023-02-04T20:54:44.000Z> matty@nicecrew.digital: But I can make it open source I think. I've been thinking about it anyway. 
<2023-02-04T20:55:05.000Z> chudbere: does it pull quotes from a text file?
<2023-02-04T20:55:48.000Z> matty@nicecrew.digital: Not from a file, just an array. 
<2023-02-04T20:56:47.000Z> chudbere: I have a random quote bot already that just posts new quotes from a text file, but what I have in mind for this would be a lot funnier if it could reply to people
<2023-02-04T20:57:10.000Z> chudbere: it's an "inverse bot (as in bot@seal.cafe" bot 
<2023-02-04T20:58:09.000Z> chudbere: where it would say stuff about body positivity, rich people are bad, trans women are women etc
<2023-02-04T21:04:39.000Z> matty@nicecrew.digital: Ohhh haha that's funny!
<2023-02-04T21:05:09.000Z> matty@nicecrew.digital: Well, let me see if I can take the code from it and make it open source. No guarantees in having it done today as I'm hungover right now but it's something I've definitely been considering.
<2023-02-04T21:05:21.000Z> chudbere: no worries or hurry :)
<2023-02-08T19:56:02.000Z> chudbere: hey wanted to give you a little poke about that bot code thing
<2023-02-08T19:56:41.000Z> matty@nicecrew.digital: Ah, sorry, I kind of put it on the back burner for now. My working on wrenching out issues with the instance but I'll do my best to get to it as soon as I can.
<2023-02-08T19:56:58.000Z> chudbere: No worries :)
<2023-02-10T01:22:10.000Z> matty@nicecrew.digital: https://gitea.nicecrew.digital/matty/ncd-bot
<2023-02-10T01:22:38.000Z> matty@nicecrew.digital: Sorry that took me so long. I had to refactor some of it for ease of use and remove the more vulgar parts just in case other people wanted to use it.
<2023-02-10T01:32:42.000Z> chudbere: no worries!
<2023-02-10T01:32:57.000Z> chudbere: i will give it a look tonight when I get a chance
<2023-02-10T01:33:28.000Z> matty@nicecrew.digital: Sure thing. If you have any questions don't hesitate to ask. I'll update it over time.
<2023-02-10T01:37:11.000Z> chudbere: does it ever post statuses on it's own?
<2023-02-10T01:37:23.000Z> chudbere: or only replies
<2023-02-10T01:37:53.000Z> matty@nicecrew.digital: Only replies as of right now. 
<2023-02-10T01:38:06.000Z> matty@nicecrew.digital: I could pretty easily add a "just post a status" ability to it.
<2023-02-10T01:38:38.000Z> chudbere: only if you want to, I have a different bot which can do that if needed
<2023-02-10T01:38:51.000Z> chudbere: and how does it decide when to reply
<2023-02-10T01:38:54.000Z> chudbere: and to who
<2023-02-10T01:39:56.000Z> matty@nicecrew.digital: It's random. It pulls latest statuses from the fediverse (you can change it to local only if you want) and then picks a random status to reply to. I run this off of crontab, so my machine calls the script every 10 minutes.
<2023-02-10T01:40:49.000Z> matty@nicecrew.digital: so in /etc/crontab this will run every ten minutes */10 *    * * *   bot    (cd ~/nice-bot/ && ./nice-bot.js nigger)
<2023-02-10T01:41:23.000Z> matty@nicecrew.digital: */10 *    * * *   bot    (cd ~/nice-bot/ && ./nice-bot.js nigger)
<2023-02-10T01:41:45.000Z> matty@nicecrew.digital: Of course that's not the same as you'll use, as it's renamed to "replybot" for the open source stuff.
<2023-02-10T01:41:51.000Z> chudbere: right
<2023-02-10T01:42:28.000Z> chudbere: Is there a way to make it reply to mentions?
<2023-02-10T01:42:52.000Z> matty@nicecrew.digital: Unfortunately I don't know how to do that right now, but I'd sure like to figure it out.
<2023-02-10T01:43:06.000Z> matty@nicecrew.digital: I know the ebooks bots can, but that's written in a different language.
<2023-02-10T01:43:26.000Z> chudbere: https://github.com/cadadr/moody_bot
<2023-02-10T01:43:35.000Z> chudbere: i was playing with this last night trying to get it to work
<2023-02-10T01:43:48.000Z> chudbere: it was developed for mastodon with python
<2023-02-10T01:44:30.000Z> chudbere: but when i try to  ./run.bash post
<2023-02-10T01:44:40.000Z> chudbere: it tells me that it can't find the mastodon python module
<2023-02-10T01:44:45.000Z> chudbere: even though I have it installed
<2023-02-10T01:44:52.000Z> matty@nicecrew.digital: Are you running it as root?
<2023-02-10T01:44:55.000Z> chudbere: yes
<2023-02-10T01:46:27.000Z> matty@nicecrew.digital: That means there's an issue with importing the mastodon module like it's not installed. Hmm
<2023-02-10T01:46:55.000Z> chudbere: yeah idk it's installed but it's the only module in the list which is capitalized
<2023-02-10T01:47:03.000Z> chudbere: and it has .py after the name
<2023-02-10T01:47:13.000Z> matty@nicecrew.digital: https://github.com/animeavi/fedi_ebooks
<2023-02-10T01:47:18.000Z> chudbere: i tried editing the code to call for Mastodon.py there instead and that didn't work
<2023-02-10T01:47:21.000Z> matty@nicecrew.digital: That's the one the Ebooks ones use
<2023-02-10T01:48:08.000Z> chudbere: that's what happens when I changed the name of it in the moody.py file
<2023-02-10T01:48:16.000Z> chudbere: okay I'll check out the ebooks one
<2023-02-10T05:22:15.000Z> chudbere: hey the env example file still has the n word in it lol
<2023-02-10T12:14:16.000Z> matty@nicecrew.digital: It does? Whoops lmao 
<2023-02-10T13:31:15.000Z> matty@nicecrew.digital: Latest build can post regular statuses too
