Post 9oRVF1ROvQPRD9kCw4 by rin@patch.cx
(DIR) More posts by rin@patch.cx
(DIR) Post #9oQuijdnyNQWOBqpo8 by DJWalnut@vulpine.club
2019-10-24T02:17:08Z
0 likes, 0 repeats
@ivesen I borked my server :(
(DIR) Post #9oQuik6WFcOZpFHlZ2 by DJWalnut@vulpine.club
2019-10-24T03:52:49Z
0 likes, 0 repeats
right, so I'm trying to check out 1.0.1 (e01bab843b137ae7b11735a1fa432ae0beac626a) and update to that as a bridge tot he most recent version, suspecting that there was a database change that's not transitive
(DIR) Post #9oQuikTCtGXkxbtsvY by DJWalnut@vulpine.club
2019-10-24T03:54:44Z
0 likes, 0 repeats
note to self, keep your servers up to date regularly, so issues like this either don't happen or aren't bespoke to me
(DIR) Post #9oQuikqxSxXg9H0qwq by DJWalnut@vulpine.club
2019-10-24T04:07:41Z
0 likes, 0 repeats
is it possible to backup everything, nuke, re-install then copy over the files?
(DIR) Post #9oQuilFlyhOLOEcfcu by mewmew@blob.cat
2019-10-29T00:38:57.571280Z
0 likes, 0 repeats
@DJWalnut late response but yes, what you want to do is* make a backup of your database, static files, and media uploads* nuke the instance folder* checkout a newer version of pleroma* copy back your config file and media uploads* reimport the database and do the mix ecto.migrate thing(worked for me)
(DIR) Post #9oQuilX8w7HoG6kXhY by DJWalnut@vulpine.club
2019-10-29T23:35:22Z
1 likes, 0 repeats
@mewmew thank you fro the responce, my instance is still busted. how do I do this right? also, I think ecto.migrate is just broken, and that's why nothing works
(DIR) Post #9oQumTAl902kTI2ukC by mewmew@blob.cat
2019-10-29T23:36:17.227822Z
0 likes, 0 repeats
@DJWalnut what happens when you do ecto.migrate?
(DIR) Post #9oQvZeyq22lRHXvSbo by DJWalnut@vulpine.club
2019-10-29T23:44:59Z
1 likes, 0 repeats
@mewmew https://vulpine.club/@DJWalnut/103014952342881651
(DIR) Post #9oQvkjKADnQpwLBB5c by mewmew@blob.cat
2019-10-29T23:47:10.464225Z
0 likes, 0 repeats
@DJWalnut hmmdid you try it with MIX_ENV=prod ?
(DIR) Post #9oQxvTva0PA5HYw1Ee by DJWalnut@vulpine.club
2019-10-30T00:11:16Z
1 likes, 0 repeats
@mewmew yep
(DIR) Post #9oQxxAA2T8WSYWV2DA by mewmew@blob.cat
2019-10-30T00:11:49.970345Z
0 likes, 0 repeats
@DJWalnut what branch do you run (stable or develop)?
(DIR) Post #9oQy16QoHEv09CDsEC by DJWalnut@vulpine.club
2019-10-30T00:12:20Z
1 likes, 0 repeats
@mewmew 0.9 havn't updated since I first installed
(DIR) Post #9oQyB6buSyBrbABUbg by mewmew@blob.cat
2019-10-30T00:14:21.183479Z
0 likes, 0 repeats
@DJWalnut oh wow, that'd explain.hmm ok sofirst what you want to do is login as the postgres user and do pg_dump pleroma > pleroma-database.psql(replace "pleroma" with whatever your database is)next login as the pleroma user and copy your config files, your static files (excluding fe files), and your uploads to a safe folder so you can restore them later
(DIR) Post #9oQyqFoX9V3212i5x2 by DJWalnut@vulpine.club
2019-10-30T00:21:00Z
0 likes, 0 repeats
@mewmew alright, so I'm logged onto my server, how do I do postgres stuff? I've never touched it before
(DIR) Post #9oQyqGPkv6p1sU7oy8 by mewmew@blob.cat
2019-10-30T00:21:47.046922Z
0 likes, 0 repeats
@DJWalnut sudo su postgres then cd
(DIR) Post #9oQysbRBjB7leuuVpg by mewmew@blob.cat
2019-10-30T00:22:12.926110Z
0 likes, 0 repeats
@DJWalnut fortunately you don't need to mess with the postgres console and can do everything in the linux shell for this
(DIR) Post #9oQyvJ8uCiK3mreHey by toast@toast.cafe
2019-10-30T00:22:41.820353Z
1 likes, 0 repeats
@mewmew @DJWalnutme, an intellectual: it's `sudo -u postgres -i`
(DIR) Post #9oQyyP4cbqyl3B7Zdg by mewmew@blob.cat
2019-10-30T00:23:15.765840Z
0 likes, 0 repeats
@toast @DJWalnut :blobcatthink: but that's a longer command
(DIR) Post #9oQyzediDlnfcJ8BWa by DJWalnut@vulpine.club
2019-10-30T00:23:22Z
1 likes, 0 repeats
@mewmew that worked, now in /var/lib/postgresql as the postgres user
(DIR) Post #9oQz0VLoF3yH68A8Tg by mewmew@blob.cat
2019-10-30T00:23:38.618651Z
0 likes, 0 repeats
@DJWalnut yep, run the command I gave you now to backup the database
(DIR) Post #9oQz1xuJYT33xCzxku by toast@toast.cafe
2019-10-30T00:23:54.128970Z
1 likes, 0 repeats
@mewmew @DJWalnut but it has fewer dependencies!
(DIR) Post #9oQz8yKCOvd3HARlM8 by DJWalnut@vulpine.club
2019-10-30T00:25:02Z
1 likes, 0 repeats
@mewmew so, does it matter where I dump it to as long as I can remember where I put it?
(DIR) Post #9oQzCf224eAIb8hzKi by mewmew@blob.cat
2019-10-30T00:25:50.365332Z
0 likes, 0 repeats
@DJWalnut nope, but I'd recommend dumping it to the postgres user's home directory for simplicity
(DIR) Post #9oR01cBqOo2IYMavho by DJWalnut@vulpine.club
2019-10-30T00:34:48Z
1 likes, 0 repeats
@mewmew got the following error:bash: /mnt/weirdart_pleroma_1_v1/pleroma-database.psql: Permission deniedmaybe because I was messing around as root a while ago?
(DIR) Post #9oR03GuiTUXJ94NCoC by mewmew@blob.cat
2019-10-30T00:35:20.759401Z
0 likes, 0 repeats
@DJWalnut write to a directory that the postgres user has access toa location within its home folder is ideal
(DIR) Post #9oR07G8PJVFbt3g7wO by DJWalnut@vulpine.club
2019-10-30T00:35:36Z
1 likes, 0 repeats
@mewmew /mnt/weirdart_pleroma_1_v1 is the external (from my server's prespactive) disk where everything has to live since I ran out of room onmy main disk
(DIR) Post #9oR08j657KSe0CI3Rw by DJWalnut@vulpine.club
2019-10-30T00:36:10Z
1 likes, 0 repeats
@mewmew how large is this file? I have maybe 15 GB to work with without using my volume
(DIR) Post #9oR0AM47iduJ9N9Pv6 by mewmew@blob.cat
2019-10-30T00:36:37.613221Z
0 likes, 0 repeats
@DJWalnut run du -sh, it'll be smaller than that
(DIR) Post #9oR0CWOeHNwhlpmhW4 by DJWalnut@vulpine.club
2019-10-30T00:36:44Z
1 likes, 0 repeats
@mewmew this is what's going on https://www.digitalocean.com/docs/volumes/
(DIR) Post #9oR0KUytQSSphIXcau by DJWalnut@vulpine.club
2019-10-30T00:38:19Z
1 likes, 0 repeats
@mewmew pg_dump: [archiver (db)] connection to database "pleroma" failed: FATAL: database "pleroma" does not exist
(DIR) Post #9oR0L42f4RH6R7ZcpM by mewmew@blob.cat
2019-10-30T00:38:33.876914Z
0 likes, 0 repeats
@DJWalnut what's your database name?
(DIR) Post #9oR0MFfVKSikmjJB0S by DJWalnut@vulpine.club
2019-10-30T00:38:38Z
1 likes, 0 repeats
@mewmew ls retyurns: 10 pleroma-database.psql
(DIR) Post #9oR0P51tLBbueq81hI by DJWalnut@vulpine.club
2019-10-30T00:39:12Z
1 likes, 0 repeats
@mewmew I don't know
(DIR) Post #9oR0RIirOwNthmHmC0 by mewmew@blob.cat
2019-10-30T00:39:41.428363Z
0 likes, 0 repeats
@DJWalnut type psqlit'll open a shell, type \l and show me the resultsthen do \q to exit the postgres shell
(DIR) Post #9oR0fqAJrGhvTr3vaC by DJWalnut@vulpine.club
2019-10-30T00:40:13Z
1 likes, 0 repeats
@mewmew List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -------------+----------+----------+---------+---------+----------------------- pleroma_dev | pleroma | UTF8 | C.UTF-8 | C.UTF-8 | postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres(4 rows)
(DIR) Post #9oR0gGLuUnQahKgYG8 by DJWalnut@vulpine.club
2019-10-30T00:41:02Z
1 likes, 0 repeats
@mewmew note that I think those files may be softlinked to the /mnt/ for space reasons.
(DIR) Post #9oR0gLPHhg68NFIoiG by DJWalnut@vulpine.club
2019-10-30T00:41:58Z
1 likes, 0 repeats
@mewmew ls /mnt/weirdart_pleroma_1_v1/postgresql/ returns10 pleroma-database.psqlso that might be the real location of the file, which is probably the database file in question
(DIR) Post #9oR0lvpTiGdamgDcZs by mewmew@blob.cat
2019-10-30T00:43:24.796248Z
0 likes, 0 repeats
@DJWalnut nope, the pleroma-database.psql file is the one that you're creating, and while it failed, it got far enough to make an empty filetake the original command and replace "pleroma" with "pleroma_dev" and it should work (so pg_dump pleroma_dev > pleroma-database.psql )
(DIR) Post #9oR0nJ0l0bAIyH9KSW by DJWalnut@vulpine.club
2019-10-30T00:43:24Z
1 likes, 0 repeats
@mewmew is it possible I just nuked the database?
(DIR) Post #9oR0wcH0lI0hJmBxOy by DJWalnut@vulpine.club
2019-10-30T00:45:13Z
1 likes, 0 repeats
@mewmew ok, this one looks to be executing rightnow
(DIR) Post #9oR2UlyjHhu1DZUXdg by DJWalnut@vulpine.club
2019-10-30T01:02:32Z
1 likes, 0 repeats
@mewmew so that finished with no issue, so now log in as pleroma's user and cope over everything?
(DIR) Post #9oR2ZTjwWRZm6Gor8C by mewmew@blob.cat
2019-10-30T01:03:34.573280Z
0 likes, 0 repeats
@DJWalnut yes, copy your your uploads folder, your config folder, and your terms of service
(DIR) Post #9oR33G8DgNr8a8NJGC by DJWalnut@vulpine.club
2019-10-30T01:08:12Z
1 likes, 0 repeats
@mewmew so that would be the /uploads/ , /config/ and where TOS is, right?
(DIR) Post #9oR36yfqX1Prb1sPbc by DJWalnut@vulpine.club
2019-10-30T01:09:32Z
1 likes, 0 repeats
@mewmew thank you for helping me, I'm very clueless
(DIR) Post #9oR37o3LVPW6wgGOoa by mewmew@blob.cat
2019-10-30T01:09:46.831877Z
0 likes, 0 repeats
@DJWalnut yes
(DIR) Post #9oR3AEImsozow0dqi0 by mewmew@blob.cat
2019-10-30T01:10:13.251432Z
0 likes, 0 repeats
@DJWalnut no problemoh also if you have custom emojos you want to back those up too but it's not too hard to re-add them
(DIR) Post #9oR3QZWdk6z3OJuiRM by DJWalnut@vulpine.club
2019-10-30T01:13:02Z
1 likes, 0 repeats
@mewmew where's the TOS at agian?I don't have custom emoji, never got that far
(DIR) Post #9oR3SxylnNQLoQDGpk by mewmew@blob.cat
2019-10-30T01:13:36.385003Z
1 likes, 0 repeats
@DJWalnut probably priv/static/static/terms-of-service.html
(DIR) Post #9oR3XodvvybcIxmNe4 by DJWalnut@vulpine.club
2019-10-30T01:14:19Z
1 likes, 0 repeats
@mewmew and there shouldn't be anything else of value in the old install, right?
(DIR) Post #9oR3ZEPRcZIuVVg3HM by mewmew@blob.cat
2019-10-30T01:14:44.300213Z
0 likes, 0 repeats
@DJWalnut not unless you modified some instance files (like customizing your side panel)
(DIR) Post #9oR3fBzLXEH8jiJQy8 by DJWalnut@vulpine.club
2019-10-30T01:15:43Z
1 likes, 0 repeats
@mewmew and I havn't. so after that, I can safely nuke and pave?
(DIR) Post #9oR3gk02ZFs8VfNLNY by mewmew@blob.cat
2019-10-30T01:16:05.717531Z
0 likes, 0 repeats
@DJWalnut yes, rm -rf your pleroma directory if you're sure your files are safe
(DIR) Post #9oR3uzuyBH4bvvnmCm by DJWalnut@vulpine.club
2019-10-30T01:18:30Z
1 likes, 0 repeats
@mewmew done. now just install a vanilla pleroma like a fresh server?
(DIR) Post #9oR3zxovPHFKsNLIXo by mewmew@blob.cat
2019-10-30T01:19:34.240391Z
0 likes, 0 repeats
@DJWalnut not exactly. you've already done everything up until the point where you make the pleroma user, so start there and stop when you get to the section where you make your config, instead copy your config folder back
(DIR) Post #9oR609JyqXhOSC5JL6 by DJWalnut@vulpine.club
2019-10-30T01:41:36Z
1 likes, 0 repeats
@mewmew so this is the part where you make the config, right?so now I just copy over the dir I backed up?
(DIR) Post #9oR60P28QevnBTrHkG by DJWalnut@vulpine.club
2019-10-30T01:41:54Z
1 likes, 0 repeats
@mewmew I just ran the deps.get
(DIR) Post #9oR60oE2lWJNJeceHI by mewmew@blob.cat
2019-10-30T01:42:07.977044Z
0 likes, 0 repeats
@DJWalnut ye, copy the dir back
(DIR) Post #9oR6KcImo3lG7yHm9w by DJWalnut@vulpine.club
2019-10-30T01:45:32Z
1 likes, 0 repeats
@mewmew shit, I nuked that file
(DIR) Post #9oR6L2MDvtxYwA5t7w by mewmew@blob.cat
2019-10-30T01:45:47.349153Z
0 likes, 0 repeats
@DJWalnut the config dir?
(DIR) Post #9oR6OESnNarfLsgvrM by DJWalnut@vulpine.club
2019-10-30T01:46:05Z
1 likes, 0 repeats
@mewmew I nuked my whole backed up config dir with a misplaced mv instead of a cp and rm
(DIR) Post #9oR6PsnusaMkkvMEwS by DJWalnut@vulpine.club
2019-10-30T01:46:27Z
1 likes, 0 repeats
@mewmew yes. it's possible an old one exists in a backup
(DIR) Post #9oR6RhNELfA7ssk1XE by mewmew@blob.cat
2019-10-30T01:46:59.519556Z
0 likes, 0 repeats
@DJWalnut that should work, what you need is the database password, which doesn't change(you could reset it but that's much harder)
(DIR) Post #9oR6RwB1JLJ9nM8z5M by DJWalnut@vulpine.club
2019-10-30T01:46:52Z
1 likes, 0 repeats
@mewmew or I could try and revoer an RMed file, but that's sketchey and hard
(DIR) Post #9oR6YjUkrMFEUTcBnM by DJWalnut@vulpine.club
2019-10-30T01:47:35Z
1 likes, 0 repeats
@mewmew so, what was in that old config directory that's not nuked anyways?
(DIR) Post #9oR6aSicCluR2RvGkq by mewmew@blob.cat
2019-10-30T01:48:34.607241Z
0 likes, 0 repeats
@DJWalnut your prod.secret.exs is what matters
(DIR) Post #9oR6di0zn12hLf4HoG by toast@toast.cafe
2019-10-30T01:49:09.865801Z
1 likes, 0 repeats
@mewmew @DJWalnut if a migration is happening anyway, maybe consider moving to OTP releases? :)
(DIR) Post #9oR6fy8ynIc9wxsdgu by mewmew@blob.cat
2019-10-30T01:49:34.174031Z
1 likes, 0 repeats
@toast @DJWalnut I would never suggest that sacrilege
(DIR) Post #9oR6gIIvq0SWTcgryq by DJWalnut@vulpine.club
2019-10-30T01:49:34Z
1 likes, 0 repeats
@mewmew and everything else is boilerplate?
(DIR) Post #9oR6hCAi7l9nkLH5wO by mewmew@blob.cat
2019-10-30T01:49:47.686294Z
0 likes, 0 repeats
@DJWalnut yeah, it should work just fine
(DIR) Post #9oR6hpo4lKoofizaDI by toast@toast.cafe
2019-10-30T01:49:54.277881Z
1 likes, 0 repeats
@mewmew @DJWalnut you are allowed to be wrong
(DIR) Post #9oR6ioBuFrX1x0bSgi by mewmew@blob.cat
2019-10-30T01:50:05.105247Z
0 likes, 0 repeats
@DJWalnut after the config is in place, try rerunning the migration
(DIR) Post #9oR6ml4xlcYJSQEsNc by mewmew@blob.cat
2019-10-30T01:50:47.958613Z
1 likes, 0 repeats
@toast @DJWalnut besides, in this case I wouldn't like to try a migration I've never done before :blobcatdunno:
(DIR) Post #9oR6wPPBCm2r8IISum by DJWalnut@vulpine.club
2019-10-30T01:52:21Z
1 likes, 0 repeats
@mewmew ok so, the biolerplate stuff in /config, right? I tried to copy the backed up config file on top of all the boilerplate, but it just ended up in /config/configso I rm -rf'ed config, including the only copy orf that old config dir
(DIR) Post #9oR6yDTIXpt6hV5Ksq by mewmew@blob.cat
2019-10-30T01:52:52.180349Z
0 likes, 0 repeats
@DJWalnut yeah, the boilerplate stuff is fine except for your prod.secret.exs
(DIR) Post #9oR6z9xR5wSS5ldDua by DJWalnut@vulpine.club
2019-10-30T01:52:45Z
1 likes, 0 repeats
@mewmew that's where I'm at right now. /opt/pleroma/config is empty
(DIR) Post #9oR70yXSWNozFvLZbs by mewmew@blob.cat
2019-10-30T01:53:22.134893Z
0 likes, 0 repeats
@DJWalnut oh, yeah. found an old backup or no?
(DIR) Post #9oR72UxFU8Iu588UrI by DJWalnut@vulpine.club
2019-10-30T01:53:22Z
1 likes, 0 repeats
@mewmew so if I make a new clone it'll be fine, if I can get prod.secret.exs back?
(DIR) Post #9oR72j0xD9aPgfyeZs by mewmew@blob.cat
2019-10-30T01:53:41.099979Z
0 likes, 0 repeats
@DJWalnut yes
(DIR) Post #9oR75XGDMtBI6OSIWO by DJWalnut@vulpine.club
2019-10-30T01:53:56Z
1 likes, 0 repeats
@mewmew havn't gone looking yet. how vital is that file? what does it do anyways?
(DIR) Post #9oR78QtlTkAzEtKuWG by mewmew@blob.cat
2019-10-30T01:54:42.974669Z
0 likes, 0 repeats
@DJWalnut it'll take you a bit of time and be kinda a PITA if you lost it. not fatal or anything but you'll have to reset or find again the database password and some other stuff
(DIR) Post #9oR7JCqK4qKwperatc by DJWalnut@vulpine.club
2019-10-30T01:56:30Z
1 likes, 0 repeats
@mewmew I set up backups, thank arceus. now I just have to get at it. that may take a little time, so if you need a bathroom break or something, go do that now
(DIR) Post #9oR9eDzlBjBGOZQaMy by DJWalnut@vulpine.club
2019-10-30T02:22:35Z
1 likes, 0 repeats
@mewmew ok, that's done, file recovered, and the rest of the config dir too. now what do?
(DIR) Post #9oR9eqzmBbMnLujeJE by mewmew@blob.cat
2019-10-30T02:22:59.098190Z
0 likes, 0 repeats
@DJWalnut it's in the config dir now?
(DIR) Post #9oR9mTfwlxYNLO5zZQ by DJWalnut@vulpine.club
2019-10-30T02:24:04Z
1 likes, 0 repeats
@mewmew yes, and the other config files too, which I saved in the recovery
(DIR) Post #9oR9nFST7NIDXU9uE4 by mewmew@blob.cat
2019-10-30T02:24:30.052379Z
0 likes, 0 repeats
@DJWalnut ok goodtry running the migration with MIX_ENV=prod
(DIR) Post #9oR9qv9CZhM3hktjqi by DJWalnut@vulpine.club
2019-10-30T02:25:01Z
1 likes, 0 repeats
@mewmew as is? havn't touched my uploads folder
(DIR) Post #9oR9t8OAJZj9Lpx7h2 by mewmew@blob.cat
2019-10-30T02:25:33.924242Z
0 likes, 0 repeats
@DJWalnut you don't need to now, this is just to get it running. afterwards if it works, you can put the uploads back, but if it doesn't, putting them back wastes a lot of time
(DIR) Post #9oR9zCwuGwvhET6B2u by DJWalnut@vulpine.club
2019-10-30T02:26:29Z
1 likes, 0 repeats
@mewmew so run "sudo -Hu pleroma MIX_ENV=prod mix ecto.migrate" right?
(DIR) Post #9oRA25LsyUfuXU9dh2 by mewmew@blob.cat
2019-10-30T02:27:11.018805Z
0 likes, 0 repeats
@DJWalnut yeah but for convenience I'd do sudo -u pleroma bash and then just the MIX_ENV=prod mix ecto.migrate separately (easier to debug)
(DIR) Post #9oRAAfSgbUDgqdQa9Y by DJWalnut@vulpine.club
2019-10-30T02:28:35Z
1 likes, 0 repeats
@mewmew =ERROR REPORT==== 30-Oct-2019::02:27:52.985889 ===file:path_eval(["/root"],".erlang"): permission deniedCould not find Hex, which is needed to build dependency :phoenixShall I install Hex? (if running non-interactively, use "mix local.hex --force") [Yn] Y** (File.Error) could not make directory (with -p) "/root/.mix/archives/hex-0.20.1": permission denied (elixir) lib/file.ex:314: File.mkdir_p!/1 (mix) lib/mix/tasks/archive.install.ex:113: Mix.Tasks.Archive.Install.install/3 (mix) lib/mix/local/installer.ex:107: Mix.Local.Installer.local_install/3 (mix) lib/mix/dep/loader.ex:188: Mix.Dep.Loader.with_scm_and_app/4 (mix) lib/mix/dep/loader.ex:141: Mix.Dep.Loader.to_dep/3 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (mix) lib/mix/dep/loader.ex:359: Mix.Dep.Loader.mix_children/2 (mix) lib/mix/dep/loader.ex:18: Mix.Dep.Loader.children/0
(DIR) Post #9oRAElDZ912zrIJ5qi by mewmew@blob.cat
2019-10-30T02:29:21.014383Z
0 likes, 0 repeats
@DJWalnut try running the deps.get command again
(DIR) Post #9oRAFFoTOMOYkRnzXc by DJWalnut@vulpine.club
2019-10-30T02:28:50Z
1 likes, 0 repeats
@mewmew logged in as pleroma user
(DIR) Post #9oRAM4XlgpN7p8F7jM by DJWalnut@vulpine.club
2019-10-30T02:29:55Z
0 likes, 0 repeats
@mewmew =ERROR REPORT==== 30-Oct-2019::02:29:32.901667 ===file:path_eval(["/root"],".erlang"): permission denied!!! RUNNING IN LOCALHOST DEV MODE! !!!FEDERATION WON'T WORK UNTIL YOU CONFIGURE A dev.secret.exsCould not find Hex, which is needed to build dependency :phoenixShall I install Hex? (if running non-interactively, use "mix local.hex --force") [Yn] Y** (File.Error) could not make directory (with -p) "/root/.mix/archives/hex-0.20.1": permission denied (elixir) lib/file.ex:314: File.mkdir_p!/1 (mix) lib/mix/tasks/archive.install.ex:113: Mix.Tasks.Archive.Install.install/3 (mix) lib/mix/local/installer.ex:107: Mix.Local.Installer.local_install/3 (mix) lib/mix/dep/loader.ex:188: Mix.Dep.Loader.with_scm_and_app/4 (mix) lib/mix/dep/loader.ex:141: Mix.Dep.Loader.to_dep/3 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (mix) lib/mix/dep/loader.ex:359: Mix.Dep.Loader.mix_children/2 (mix) lib/mix/dep/loader.ex:18: Mix.Dep.Loader.children/0
(DIR) Post #9oRAM4zQ21URCtBCpU by mewmew@blob.cat
2019-10-30T02:30:47.490925Z
0 likes, 0 repeats
@DJWalnut sure you're not running as root?
(DIR) Post #9oRAQ311JUwKF5oxTk by DJWalnut@vulpine.club
2019-10-30T02:31:20Z
1 likes, 0 repeats
@mewmew pleroma@weirdart-pleroma-1:/mnt/weirdart_pleroma_1_v1/pleroma$ whoamipleromaas best as I can tell, no I'm not
(DIR) Post #9oRAa0hCnCIJwbIrOS by mewmew@blob.cat
2019-10-30T02:33:18.763422Z
0 likes, 0 repeats
@DJWalnut that is weirdtryMIX_ENV=prod deps.get again, maybe?
(DIR) Post #9oRAkcPvOtRZpYHLoO by DJWalnut@vulpine.club
2019-10-30T02:34:12Z
1 likes, 0 repeats
@mewmew pleroma@weirdart-pleroma-1:/mnt/weirdart_pleroma_1_v1/pleroma$ MIX_ENV=prod deps.getdeps.get: command not foundpleroma@weirdart-pleroma-1:/mnt/weirdart_pleroma_1_v1/pleroma$ MIX_ENV=prod mix deps.get=ERROR REPORT==== 30-Oct-2019::02:33:50.641664 ===file:path_eval(["/root"],".erlang"): permission deniedCould not find Hex, which is needed to build dependency :phoenixShall I install Hex? (if running non-interactively, use "mix local.hex --force") [Yn] Y** (File.Error) could not make directory (with -p) "/root/.mix/archives/hex-0.20.1": permission denied (elixir) lib/file.ex:314: File.mkdir_p!/1 (mix) lib/mix/tasks/archive.install.ex:113: Mix.Tasks.Archive.Install.install/3 (mix) lib/mix/local/installer.ex:107: Mix.Local.Installer.local_install/3 (mix) lib/mix/dep/loader.ex:188: Mix.Dep.Loader.with_scm_and_app/4 (mix) lib/mix/dep/loader.ex:141: Mix.Dep.Loader.to_dep/3 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (mix) lib/mix/dep/loader.ex:359: Mix.Dep.Loader.mix_children/2 (mix) lib/mix/dep/loader.ex:18: Mix.Dep.Loader.children/0
(DIR) Post #9oRAkpfI94SauyZJ4K by DJWalnut@vulpine.club
2019-10-30T02:35:00Z
1 likes, 0 repeats
@mewmew is it possible that this uwer doesn't have permission to use a file it needs? do I have to reinstall some dependency further back?
(DIR) Post #9oRAnrUpnDnlSz7bs0 by mewmew@blob.cat
2019-10-30T02:35:49.082543Z
0 likes, 0 repeats
@DJWalnut seems like you screwed up something somewhere, because it shouldn't be trying to install in /root at all. run ls -l in your current directory
(DIR) Post #9oRB4dphqWRm0ssxn6 by DJWalnut@vulpine.club
2019-10-30T02:38:43Z
1 likes, 0 repeats
@mewmew looks like root owns the files on the config folder. is that a problem?
(DIR) Post #9oRB4wXcI0Ga2HZHjU by DJWalnut@vulpine.club
2019-10-30T02:37:04Z
1 likes, 0 repeats
@mewmew pleroma@weirdart-pleroma-1:/opt/pleroma$ ls -ltotal 180-rw-r--r-- 1 pleroma pleroma 34449 Oct 30 01:39 AGPL-3-rw-r--r-- 1 pleroma pleroma 20131 Oct 30 01:39 CC-BY-SA-4.0-rw-r--r-- 1 pleroma pleroma 23471 Oct 30 01:39 CHANGELOG.md-rw-r--r-- 1 pleroma pleroma 1898 Oct 30 01:39 COPYING-rw-r--r-- 1 pleroma pleroma 938 Oct 30 01:39 Dockerfile-rw-r--r-- 1 pleroma pleroma 46 Oct 30 01:39 Procfile-rw-r--r-- 1 pleroma pleroma 6346 Oct 30 01:39 README.mddrwxr-xr-x 2 pleroma pleroma 4096 Oct 30 02:23 configdrwxr-xr-x 100 pleroma pleroma 4096 Oct 30 01:40 deps-rwxr-xr-x 1 pleroma pleroma 290 Oct 30 01:39 docker-entrypoint.shdrwxr-xr-x 6 pleroma pleroma 4096 Oct 30 01:39 docs-rw-r--r-- 1 pleroma pleroma 43 Oct 30 01:39 elixir_buildpack.configdrwxr-xr-x 5 pleroma pleroma 4096 Oct 30 01:39 installationdrwxr-xr-x 4 pleroma pleroma 4096 Oct 30 01:39 lib-rw-r--r-- 1 pleroma pleroma 9261 Oct 30 01:39 mix.exs-rw-r--r-- 1 pleroma pleroma 21956 Oct 30 01:39 mix.lockdrwxr-xr-x 6 pleroma pleroma 4096 Oct 30 01:39 privdrwxr-xr-x 3 pleroma pleroma 4096 Oct 30 01:39 reldrwxr-xr-x 17 pleroma pleroma 4096 Oct 30 01:39 testdrwxr-xr-x 2 pleroma pleroma 4096 Oct 30 01:39 uploadspleroma@weirdart-pleroma-1:/opt/pleroma$
(DIR) Post #9oRB4xP94z5IiIc2AS by DJWalnut@vulpine.club
2019-10-30T02:38:00Z
1 likes, 0 repeats
@mewmew switched dirs to /opt/pleroma, which is once agian softlinked to /mnt/weirdart_pleroma_1_v1/pleroma
(DIR) Post #9oRB5CXUoDg1eXdPlY by mewmew@blob.cat
2019-10-30T02:38:56.945500Z
0 likes, 0 repeats
@DJWalnut possibly
(DIR) Post #9oRB6rMkVBHUZ2Omoa by DJWalnut@vulpine.club
2019-10-30T02:39:00Z
1 likes, 0 repeats
@mewmew pleroma@weirdart-pleroma-1:/opt/pleroma$ ls -la ./config/total 48drwxr-xr-x 2 pleroma pleroma 4096 Oct 30 02:23 .drwxr-xr-x 12 pleroma pleroma 4096 Oct 30 01:40 ..-rw-r--r-- 1 root root 8638 Oct 30 02:23 config.exs-rw-r--r-- 1 root root 1949 Oct 30 02:23 dev.exs-rw-r--r-- 1 root root 773 Oct 30 02:23 emoji.txt-rw-r--r-- 1 root root 2100 Oct 30 02:23 prod.exs-rw-r--r-- 1 root root 2934 Oct 30 02:23 prod.secret.exs-rw-r--r-- 1 root root 2933 Oct 30 02:23 prod.secret.exs~-rw-r--r-- 1 root root 355 Oct 30 02:23 setup_db.psql-rw-r--r-- 1 root root 1614 Oct 30 02:23 test.exspleroma@weirdart-pleroma-1:/opt/pleroma$
(DIR) Post #9oRBRtqyRsGwMOZKy0 by DJWalnut@vulpine.club
2019-10-30T02:42:55Z
1 likes, 0 repeats
@mewmew changed that back, now I gotta su to pleroma agina
(DIR) Post #9oRBVKRU33RXh1HUJ6 by DJWalnut@vulpine.club
2019-10-30T02:43:30Z
1 likes, 0 repeats
@mewmew changed user to root to do the chown to plreoma for those files
(DIR) Post #9oRBYhC7ucLL7uhft2 by DJWalnut@vulpine.club
2019-10-30T02:44:04Z
1 likes, 0 repeats
@mewmew what was the command? as I understand it pleroma isn't an ordinary user account I can just su to right?
(DIR) Post #9oRBYhcML5KKRGycm8 by mewmew@blob.cat
2019-10-30T02:44:16.837756Z
0 likes, 0 repeats
@DJWalnut sudo -u pleroma bash
(DIR) Post #9oRBciceXsVsiI1sIq by DJWalnut@vulpine.club
2019-10-30T02:44:48Z
1 likes, 0 repeats
@mewmew so, let's try migriating agian?
(DIR) Post #9oRBdVfWC0v6pMkM4W by mewmew@blob.cat
2019-10-30T02:45:09.114685Z
0 likes, 0 repeats
@DJWalnut the deps.get one should be run first
(DIR) Post #9oRC7yQbpWPAi9Icam by DJWalnut@vulpine.club
2019-10-30T02:46:28Z
0 likes, 0 repeats
@mewmew pleroma@weirdart-pleroma-1:/opt/pleroma$ mix deps.get=ERROR REPORT==== 30-Oct-2019::02:45:41.958882 ===file:path_eval(["/root"],".erlang"): permission denied!!! RUNNING IN LOCALHOST DEV MODE! !!!FEDERATION WON'T WORK UNTIL YOU CONFIGURE A dev.secret.exsCould not find Hex, which is needed to build dependency :phoenixShall I install Hex? (if running non-interactively, use "mix local.hex --force") [Yn] Y** (File.Error) could not make directory (with -p) "/root/.mix/archives/hex-0.20.1": permission denied (elixir) lib/file.ex:314: File.mkdir_p!/1 (mix) lib/mix/tasks/archive.install.ex:113: Mix.Tasks.Archive.Install.install/3 (mix) lib/mix/local/installer.ex:107: Mix.Local.Installer.local_install/3 (mix) lib/mix/dep/loader.ex:188: Mix.Dep.Loader.with_scm_and_app/4 (mix) lib/mix/dep/loader.ex:141: Mix.Dep.Loader.to_dep/3 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (mix) lib/mix/dep/loader.ex:359: Mix.Dep.Loader.mix_children/2 (mix) lib/mix/dep/loader.ex:18: Mix.Dep.Loader.children/0pleroma@weirdart-pleroma-1:/opt/pleroma$
(DIR) Post #9oRC7yq8IcozzJF0NM by mewmew@blob.cat
2019-10-30T02:50:39.148632Z
0 likes, 0 repeats
@DJWalnut still the same issue, hmm :blobcatthinking: I'm sure there's something I'm missing here but I can't figure out whatat this point I'd recommend making an issue on the Pleroma GitLab: https://git.pleroma.social/pleroma/pleroma-support/issues(they recently launched a new repo for support questions)anyway after that's fixed, which the Pleroma people will probably figure out, you can copy the uploads folder back and everything should work perfectly fine
(DIR) Post #9oRCJycivgAQnAgnlg by DJWalnut@vulpine.club
2019-10-30T02:52:40Z
1 likes, 0 repeats
@mewmew my database is in a diffrent place, agian softlinked. could that possibly cause issues?
(DIR) Post #9oRCKRi2myed04OxaS by mewmew@blob.cat
2019-10-30T02:52:54.738377Z
0 likes, 0 repeats
@DJWalnut it shouldn't, no.
(DIR) Post #9oRCTHgvPBN4XI5nvM by DJWalnut@vulpine.club
2019-10-30T02:54:19Z
1 likes, 0 repeats
@mewmew maybe I need to be root to do this?
(DIR) Post #9oRCUsbhdf1BJlPX1s by mewmew@blob.cat
2019-10-30T02:54:47.889001Z
0 likes, 0 repeats
@DJWalnut you shouldn't need to be, mix is trying to put the files in the wrong place for some reason.
(DIR) Post #9oRCYGMjlFpDsA1XrE by DJWalnut@vulpine.club
2019-10-30T02:55:09Z
1 likes, 0 repeats
@mewmew would being root and running "sudo -Hu pleroma MIX_ENV=prod mix ecto.migrate" be the same thing?
(DIR) Post #9oRCZL8BWszkwQjMye by mewmew@blob.cat
2019-10-30T02:55:36.213563Z
0 likes, 0 repeats
@DJWalnut you'd run into the same exact issue, yes
(DIR) Post #9oRCgWryHh1zNIZicq by DJWalnut@vulpine.club
2019-10-30T02:56:39Z
1 likes, 0 repeats
@mewmew so this is a bug in whatever version of pleroma I pulled? running this as root shouldn't do anything good for me?
(DIR) Post #9oRCiuBuXvKGHi2Dc8 by mewmew@blob.cat
2019-10-30T02:57:19.871670Z
0 likes, 0 repeats
@DJWalnut doubt it's a bug in Pleroma, there's some weird issue that I can't figure out the cause of. Running it as root would only make things worse.
(DIR) Post #9oRCw1mXdQhHakQS5A by DJWalnut@vulpine.club
2019-10-30T02:59:00Z
1 likes, 0 repeats
@mewmew this server only exists to run my instance. would doing a hard nuke and pave (new VPS instance fresh of the factory line, move over domain and cert) fix this?
(DIR) Post #9oRCw2T55GizigKQO8 by mewmew@blob.cat
2019-10-30T02:59:41.899940Z
0 likes, 0 repeats
@DJWalnut probably, but it may not be worth your time, and the Pleroma people will probably get back to you quicklysorry I couldn't fix this
(DIR) Post #9oRD65zCrHb7Wj9NSK by DJWalnut@vulpine.club
2019-10-30T03:01:16Z
1 likes, 0 repeats
@mewmew so, if I do make a new server and start from scratch like that, how do I deal with certs? I use certbot as recomended
(DIR) Post #9oRD9eh6GtQe2ZNXPs by mewmew@blob.cat
2019-10-30T03:02:10.017145Z
0 likes, 0 repeats
@DJWalnut you can follow all the installation instructions again, except for reimporting the database and uploads, which is a bit harder
(DIR) Post #9oRDSLHefAjTLHO5AG by DJWalnut@vulpine.club
2019-10-30T03:05:17Z
1 likes, 0 repeats
@mewmew I think I figured it outI was several laywer of user changes deeprunning "exit" like 7 times seems to have fixed that
(DIR) Post #9oRDTFkeiXCkTRO28u by mewmew@blob.cat
2019-10-30T03:05:42.516855Z
0 likes, 0 repeats
@DJWalnut wait, it worked now?
(DIR) Post #9oRDWe6ubjmmtHPlzM by DJWalnut@vulpine.club
2019-10-30T03:06:10Z
1 likes, 0 repeats
@mewmew apparently logging out and logging back in did something
(DIR) Post #9oRDkepwhhYjCJ9zgu by DJWalnut@vulpine.club
2019-10-30T03:08:26Z
1 likes, 0 repeats
@mewmew well, a new error exists nowpleroma@weirdart-pleroma-1:/mnt/weirdart_pleroma_1_v1/pleroma$ MIX_ENV=prod mix deps.getCould not find Hex, which is needed to build dependency :phoenixShall I install Hex? (if running non-interactively, use "mix local.hex --force") [Yn] Y** (File.Error) could not make directory (with -p) "/home/myname/.mix/archives/hex-0.20.1": no such file or directory (elixir) lib/file.ex:314: File.mkdir_p!/1 (mix) lib/mix/tasks/archive.install.ex:113: Mix.Tasks.Archive.Install.install/3 (mix) lib/mix/local/installer.ex:107: Mix.Local.Installer.local_install/3 (mix) lib/mix/dep/loader.ex:188: Mix.Dep.Loader.with_scm_and_app/4 (mix) lib/mix/dep/loader.ex:141: Mix.Dep.Loader.to_dep/3 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (mix) lib/mix/dep/loader.ex:359: Mix.Dep.Loader.mix_children/2 (mix) lib/mix/dep/loader.ex:18: Mix.Dep.Loader.children/0pleroma@weirdart-pleroma-1:/mnt/weirdart_pleroma_1_v1/pleroma$
(DIR) Post #9oRDlpWITCDWcVWphQ by DJWalnut@vulpine.club
2019-10-30T03:08:54Z
1 likes, 0 repeats
@mewmew myname being the username of the non-root account that I have under my real name, which I'm not posting publically
(DIR) Post #9oRDqgOZp1tHljEPxI by mewmew@blob.cat
2019-10-30T03:09:56.604457Z
0 likes, 0 repeats
@DJWalnut this is weird, try the sudo -Hu version of the command(i swear if this is the issue, i will feel very stupid)
(DIR) Post #9oRE1YmIU3LNKTVsVE by DJWalnut@vulpine.club
2019-10-30T03:11:43Z
1 likes, 0 repeats
@mewmew that workeddon't worry, computers are non-deterministic, despite what we are lead to believe
(DIR) Post #9oRE4W7unWN5yW2E6a by mewmew@blob.cat
2019-10-30T03:12:26.550824Z
0 likes, 0 repeats
@DJWalnut okwell now you can run the migration (also to be safe, with the sudo -Hu)
(DIR) Post #9oRE6fjm2KgIMRlq52 by DJWalnut@vulpine.club
2019-10-30T03:12:42Z
1 likes, 0 repeats
@mewmew doing that as we speak, no issues so far
(DIR) Post #9oRE7uOV1oPq6lPR6u by mewmew@blob.cat
2019-10-30T03:13:03.323354Z
0 likes, 0 repeats
@DJWalnut (and i'm beginning to believe you, there's no reason that should work with the sudo -Hu but not logged in as the user wtf)
(DIR) Post #9oRECwL5Dz4HaWD76O by DJWalnut@vulpine.club
2019-10-30T03:13:51Z
1 likes, 0 repeats
@mewmew there's got to be some deep wizardry going on somewhere that makes a difference
(DIR) Post #9oREHr16RLJMWsCxns by DJWalnut@vulpine.club
2019-10-30T03:14:36Z
1 likes, 0 repeats
@mewmew we'd need a hardcore unix neckbeard in here
(DIR) Post #9oREN5tuWrfS8gLJDM by ivesen@miniwa.moe
2019-10-30T03:15:46.349369Z
1 likes, 0 repeats
@mewmew @DJWalnut recent versions of ubuntu will sometimes fuck your env vars up majorly depending on how you log inmight also be true for debian, I don't know what @DJWalnut is running though :blobshrug:
(DIR) Post #9oREQ8WjDoQN9Vwxou by mewmew@blob.cat
2019-10-30T03:16:21.033305Z
0 likes, 0 repeats
@ivesen @DJWalnut env vars is probably the issuei fucking hate env vars btw
(DIR) Post #9oRERvXGUho9RK3SZE by DJWalnut@vulpine.club
2019-10-30T03:16:34Z
1 likes, 0 repeats
@ivesen @mewmew Ubuntu 18.04.2 x64
(DIR) Post #9oRF35g7kJtHbzv4Fc by DJWalnut@vulpine.club
2019-10-30T03:19:14Z
0 likes, 0 repeats
@mewmew @ivesen == Compilation error in file lib/pleroma/web/endpoint.ex ==** (Protocol.UndefinedError) protocol Enumerable not implemented for nil of type Atom (elixir) lib/enum.ex:1: Enumerable.impl_for!/1 (elixir) lib/enum.ex:141: Enumerable.reduce/3 (elixir) lib/enum.ex:3023: Enum.join/2 lib/pleroma/web/endpoint.ex:85: (module)now what the fuck's going on
(DIR) Post #9oRF365eDQJ6t9rS2C by ivesen@miniwa.moe
2019-10-30T03:23:22.260132Z
0 likes, 0 repeats
@DJWalnut @mewmew is your version of elixir / erlang up to date?
(DIR) Post #9oRFCKlb19jb0tt1pg by DJWalnut@vulpine.club
2019-10-30T03:23:39Z
0 likes, 0 repeats
@ivesen @mewmew how do I check?
(DIR) Post #9oRFCLA3YDIgElKYxU by ivesen@miniwa.moe
2019-10-30T03:25:02.558508Z
0 likes, 0 repeats
@DJWalnut @mewmew iex --version
(DIR) Post #9oRFIonyFUUlug5bLU by DJWalnut@vulpine.club
2019-10-30T03:25:26Z
0 likes, 0 repeats
@ivesen @mewmew Erlang/OTP 22 [erts-10.5.3] [source] [64-bit] [smp:1:1] [ds:1:1:10] [async-threads:1]IEx 1.9.2 (compiled with Erlang/OTP 21)
(DIR) Post #9oRFIpRJtByFsiV1g8 by ivesen@miniwa.moe
2019-10-30T03:26:13.415113Z
0 likes, 0 repeats
@DJWalnut @mewmew that should be goodI guess you should try running mix deps.get a couple of times
(DIR) Post #9oRFkW9HCqkW9yGMQy by DJWalnut@vulpine.club
2019-10-30T03:29:33Z
0 likes, 0 repeats
@ivesen @mewmew and this is origin/stableall the files in /config/ are copied straight from a 0.9 install, if that makes a diffrence
(DIR) Post #9oRFkWZVdJjVTKXJK4 by ivesen@miniwa.moe
2019-10-30T03:31:13.193694Z
0 likes, 0 repeats
@DJWalnut @mewmew probably not what your particular issue is, but you can search for breaking in herehttps://git.pleroma.social/pleroma/pleroma/blob/stable/CHANGELOG.md
(DIR) Post #9oRMfDHQdB2xs5UfjM by DJWalnut@vulpine.club
2019-10-30T03:41:21Z
0 likes, 0 repeats
@ivesen @mewmew it's not in there, it seems to be a coding error in lib/pleroma/web/endpoint.exhow do I open a bug report?
(DIR) Post #9oRMfDgb7bBD89Glxg by DJWalnut@vulpine.club
2019-10-30T04:07:02Z
0 likes, 0 repeats
@ivesen @mewmew this looks to be the offending linehttps://git.pleroma.social/pleroma/pleroma/blob/develop/lib/pleroma/web/endpoint.ex#L85
(DIR) Post #9oRMfEFL2Qy8rtWW6y by DJWalnut@vulpine.club
2019-10-30T04:19:34Z
0 likes, 0 repeats
@ivesen @mewmew is it possible that stable is just broken right now? testing develop to see if that compiles (in a fresh dir away from my pleroma install, copying over the prod.secrete file, not as the pleroma user, but as a normal user account)
(DIR) Post #9oRMfEdRaoFe4enlgW by DJWalnut@vulpine.club
2019-10-30T04:27:38Z
0 likes, 0 repeats
@ivesen @mewmew that compiled, but that old database error is back.nuked that test dir.
(DIR) Post #9oRMfEyML2yv7WaTHk by DJWalnut@vulpine.club
2019-10-30T04:48:30Z
1 likes, 0 repeats
@ivesen @mewmew trying the install agian, this time using branch release/1.0 (might not want to jump to far forward with the db from 0.9) will probably chain update to the latest version
(DIR) Post #9oRMuJ53LbIoCku0OG by DJWalnut@vulpine.club
2019-10-30T04:51:13Z
1 likes, 0 repeats
@ivesen @mewmew so, if this works, I can copy over the uploads, fire up the server and it should work, right? then I can update again to a more recent version?
(DIR) Post #9oRU3B3LGKzrapHLqi by absturztaube@fedi.absturztau.be
2019-10-30T06:11:28.048314Z
2 likes, 0 repeats
@mewmew @DJWalnut you forget the mix thereit should be MIX_ENV=prod mix deps.get
(DIR) Post #9oRVF1ROvQPRD9kCw4 by rin@patch.cx
2019-10-30T06:24:48.132409Z
1 likes, 0 repeats
@DJWalnut @ivesen @mewmew most likely a new migration broke an old one. please try applying this patch (git apply /path/to/patch)bookmark_migration.patch
(DIR) Post #9oRVUz6NODpeadWObw by DJWalnut@vulpine.club
2019-10-30T06:26:52Z
0 likes, 0 repeats
@rin for which version is this?
(DIR) Post #9oRVUzVXsdxtqhIUqG by rin@patch.cx
2019-10-30T06:27:40.526640Z
0 likes, 0 repeats
@DJWalnut should work with the latest stable
(DIR) Post #9oRVv6Y0KUuhD9towq by DJWalnut@vulpine.club
2019-10-30T06:28:10Z
0 likes, 0 repeats
@rin that version has a compilation issue in it
(DIR) Post #9oRVv7EXmKwPL5nnFo by rin@patch.cx
2019-10-30T06:32:23.979635Z
0 likes, 0 repeats
@DJWalnut the compilation error above only appears when the user has a corrupted config/config.exs, could you try git checkout HEAD config/config.exs ?
(DIR) Post #9oRWw9urOGr5u1elmK by DJWalnut@vulpine.club
2019-10-30T06:42:26Z
0 likes, 0 repeats
@rin so I rant hat command to checkout the config.exs, returned nothing. operating in a clean stable pleroma dir with copied over prod.secret.exs. have not applied patch yet
(DIR) Post #9oRWwALRnQ7fEU60Dg by rin@patch.cx
2019-10-30T06:43:47.596062Z
0 likes, 0 repeats
@DJWalnut does it compile now?
(DIR) Post #9oRXmpWfvm6s0nSZW4 by DJWalnut@vulpine.club
2019-10-30T06:44:35Z
0 likes, 0 repeats
@rin let me try
(DIR) Post #9oRXmq5lpIBNldsbDc by DJWalnut@vulpine.club
2019-10-30T06:50:45Z
0 likes, 0 repeats
@rin nope, it runs into the bookmark thing. I'll try the patch
(DIR) Post #9oRXmrlzZnYAysdpfU by DJWalnut@vulpine.club
2019-10-30T06:52:12Z
0 likes, 0 repeats
@rin patch applied, no change06:51:22.518 [info] == Running 20190414125034 Pleroma.Repo.Migrations.MigrateOldBookmarks.up/0 forward** (Postgrex.Error) ERROR 42501 (insufficient_privilege) permission denied for relation bookmarks (ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1 (ecto) lib/ecto/repo/schema.ex:649: Ecto.Repo.Schema.apply/4 (ecto) lib/ecto/repo/schema.ex:262: anonymous fn/15 in Ecto.Repo.Schema.do_insert/4 _build/prod/lib/pleroma/priv/repo/migrations/20190414125034_migrate_old_bookmarks.exs:21: anonymous fn/2 in Pleroma.Repo.Migrations.MigrateOldBookmarks.up/0 (elixir) lib/enum.ex:783: Enum."-each/2-lists^foreach/1-0-"/2 (elixir) lib/enum.ex:783: Enum.each/2 (elixir) lib/enum.ex:789: anonymous fn/3 in Enum.each/2 (elixir) lib/enum.ex:3023: anonymous fn/3 in Enum.each/2
(DIR) Post #9oRXmsGpj8DiWX4Sjw by rin@patch.cx
2019-10-30T06:53:18.845890Z
0 likes, 0 repeats
@DJWalnut that's a different error though. are you sure your database config is correct and you are running with the right MIX_ENV?
(DIR) Post #9oRY81kFhDj3zPuy6i by DJWalnut@vulpine.club
2019-10-30T06:53:50Z
0 likes, 0 repeats
@rinyeah sudo -Hu pleroma MIX_ENV=prod mix ecto.migrate
(DIR) Post #9oRY82Izc3VzjAAiG0 by rin@patch.cx
2019-10-30T06:57:08.952560Z
0 likes, 0 repeats
@DJWalnut try logging into the postgresql console (psql -U postgres -d $name_of_your_pleroma_db) and granting all permissions to the pleroma user (GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO $name_of_your_pleroma_user; )
(DIR) Post #9oRYokCqmRzs2vfCJk by DJWalnut@vulpine.club
2019-10-30T07:03:54Z
0 likes, 0 repeats
@rin psql: FATAL: Peer authentication failed for user "postgres"
(DIR) Post #9oRYokhKx6NpZTvXpw by rin@patch.cx
2019-10-30T07:04:52.613128Z
0 likes, 0 repeats
@DJWalnut try doing that with sudo -Hu postgres in front
(DIR) Post #9oRZRuQchzgn2kmTsO by DJWalnut@vulpine.club
2019-10-30T07:06:18Z
0 likes, 0 repeats
@rin warning: unused alias User _build/prod/lib/pleroma/priv/repo/migrations/20190414125034_migrate_old_bookmarks.exs:6warning: unused alias User _build/prod/lib/pleroma/priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs:3warning: unused alias User _build/prod/lib/pleroma/priv/repo/migrations/20190711042024_copy_muted_to_muted_notifications.exs:307:05:57.564 [info] == Running 20190414125034 Pleroma.Repo.Migrations.MigrateOldBookmarks.up/0 forward** (Postgrex.Error) ERROR 42501 (insufficient_privilege) permission denied for relation bookmarks (ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1 (ecto) lib/ecto/repo/schema.ex:649: Ecto.Repo.Schema.apply/4 (ecto) lib/ecto/repo/schema.ex:262: anonymous fn/15 in Ecto.Repo.Schema.do_insert/4 _build/prod/lib/pleroma/priv/repo/migrations/20190414125034_migrate_old_bookmarks.exs:21: anonymous fn/2 in Pleroma.Repo.Migrations.MigrateOldBookmarks.up/0 (elixir) lib/enum.ex:783: Enum."-each/2-lists^foreach/1-0-"/2 (elixir) lib/enum.ex:783: Enum.each/2 (elixir) lib/enum.ex:789: anonymous fn/3 in Enum.each/2 (elixir) lib/enum.ex:3023: anonymous fn/3 in Enum.each/2
(DIR) Post #9oRZRuxwi6LOi6N5oe by rin@patch.cx
2019-10-30T07:11:56.722324Z
0 likes, 0 repeats
@DJWalnut try resetting the file ( git checkout HEAD priv/repo/migrations/20190414125034_migrate_old_bookmarks.exs ) and apply the attached patch please. (sorry for making you test patches, I just don't have a backup of a pleroma database with a schema that old)bookmark_migration.patch
(DIR) Post #9oRaFH0ZXudxGN8OkC by DJWalnut@vulpine.club
2019-10-30T07:13:51Z
0 likes, 0 repeats
@rin don't worry, I'm desperate and thinking of just giving up and spinning up a mastodon instance. I'll try anything that might work
(DIR) Post #9oRaFJuekMh4GtODRI by DJWalnut@vulpine.club
2019-10-30T07:15:13Z
0 likes, 0 repeats
@rin sudo -Hu pleroma MIX_ENV=prod mix ecto.migratewarning: unused alias User _build/prod/lib/pleroma/priv/repo/migrations/20190414125034_migrate_old_bookmarks.exs:6warning: unused alias User _build/prod/lib/pleroma/priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs:3warning: unused alias User _build/prod/lib/pleroma/priv/repo/migrations/20190711042024_copy_muted_to_muted_notifications.exs:307:14:52.307 [info] == Running 20190414125034 Pleroma.Repo.Migrations.MigrateOldBookmarks.up/0 forward** (Postgrex.Error) ERROR 42501 (insufficient_privilege) permission denied for relation bookmarks (ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1 (ecto) lib/ecto/repo/schema.ex:649: Ecto.Repo.Schema.apply/4 (ecto) lib/ecto/repo/schema.ex:262: anonymous fn/15 in Ecto.Repo.Schema.do_insert/4 _build/prod/lib/pleroma/priv/repo/migrations/20190414125034_migrate_old_bookmarks.exs:21: anonymous fn/2 in Pleroma.Repo.Migrations.MigrateOldBookmarks.up/0 (elixir) lib/enum.ex:783: Enum."-each/2-lists^foreach/1-0-"/2 (elixir) lib/enum.ex:783: Enum.each/2 (elixir) lib/enum.ex:789: anonymous fn/3 in Enum.each/2 (elixir) lib/enum.ex:3023: anonymous fn/3 in Enum.each/2
(DIR) Post #9oRaFNGkGh94gGkOmm by rin@patch.cx
2019-10-30T07:20:10.038116Z
0 likes, 0 repeats
@DJWalnut do bookmarks even exist? try logging into the postges console and doing "select from bookmarks;"
(DIR) Post #9oRb5SPwN87Fhqspuq by rin@patch.cx
2019-10-30T07:30:18.229171Z
0 likes, 0 repeats
@DJWalnut try doing mix ecto.rollback -v 1 and migrate again
(DIR) Post #9oRb7uGzmBHCg7rq4m by rin@patch.cx
2019-10-30T07:30:45.448353Z
0 likes, 0 repeats
@DJWalnut s/-v/-n
(DIR) Post #9oRbE1abUH9l6gxLl2 by igeljaeger@jpop.club
2019-10-30T07:31:51.619013Z
0 likes, 1 repeats
@rin @DJWalnut Im glad Im part of the not-updating-gang because of stuff like this :dab: Stability > new features
(DIR) Post #9oRbLsUPCkZ7CUnmD2 by rin@patch.cx
2019-10-30T07:33:16.092563Z
1 likes, 0 repeats
@igeljaeger @DJWalnut actually, the current problem is because the user didn't update for too long
(DIR) Post #9oRbOXsuGlCiAGXAo4 by DJWalnut@vulpine.club
2019-10-30T07:32:25Z
0 likes, 0 repeats
@rin what does that do?
(DIR) Post #9oRbOYKYbxK1Y1TFuC by rin@patch.cx
2019-10-30T07:33:45.607688Z
0 likes, 0 repeats
@DJWalnut nevermind
(DIR) Post #9oRbU8HgMcbqVImqSe by igeljaeger@jpop.club
2019-10-30T07:34:47.212081Z
0 likes, 1 repeats
@rin @DJWalnut mmmmmmmmmh but this still is sort of a two edged blade imo...Breaking my server is a nightmare for a social media addict like me
(DIR) Post #9oRbmXGOEMXPBhxQMC by DJWalnut@vulpine.club
2019-10-30T07:31:13Z
0 likes, 0 repeats
@rin udo -Hu pleroma MIX_ENV=prod mix ecto.rollback -v 107:30:44.707 [info] == Running 20190413085040 Pleroma.Repo.Migrations.AddSigninAndLastDigestDatesToUser.change/0 backward07:30:44.716 [info] alter table users07:30:44.753 [info] == Migrated 20190413085040 in 0.0s07:30:44.787 [info] == Running 20190413082658 Pleroma.Repo.Migrations.CreateBookmarks.change/0 backward07:30:44.788 [info] drop index if exists bookmarks_user_id_activity_id_index** (Postgrex.Error) ERROR 42501 (insufficient_privilege) must be owner of relation bookmarks_user_id_activity_id_index (ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (ecto_sql) lib/ecto/adapters/sql.ex:705: Ecto.Adapters.SQL.execute_ddl/4 (ecto_sql) lib/ecto/migration/runner.ex:302: Ecto.Migration.Runner.log_and_execute_ddl/3 (ecto_sql) lib/ecto/migration/runner.ex:111: anonymous fn/5 in Ecto.Migration.Runner.flush/0 (elixir) lib/enum.ex:1948: Enum."-reduce/3-lists^foldl/2-0-"/3 (ecto_sql) lib/ecto/migration/runner.ex:110: Ecto.Migration.Runner.flush/0 (stdlib) timer.erl:166: :timer.tc/1
(DIR) Post #9oRbmXhgasN8YMjDu4 by rin@patch.cx
2019-10-30T07:38:05.240076Z
0 likes, 0 repeats
@DJWalnut hmm, I think you may have done the previous migration without setting MIX_ENV/having corrupted config, resulting in the bookmark table being owned by a different user than the one running the migration. what does running "select tableowner from pg_tables where tablename = 'bookmarks';" in postgres console output?
(DIR) Post #9oRbprlMTDiJdQ24ES by rin@patch.cx
2019-10-30T07:38:42.069889Z
0 likes, 0 repeats
@igeljaeger @DJWalnut that's why we have a stable branch...
(DIR) Post #9oRbrmdgUXHSK4M7Hs by igeljaeger@jpop.club
2019-10-30T07:39:03.691752Z
0 likes, 1 repeats
@rin @DJWalnut implying I know how to switch to that
(DIR) Post #9oRbxjLLeqrnq3cBRA by DJWalnut@vulpine.club
2019-10-30T07:38:46Z
0 likes, 0 repeats
@rin tableowner ------------ postgres(1 row)
(DIR) Post #9oRbxjqBoBXLNi2oVc by DJWalnut@vulpine.club
2019-10-30T07:39:14Z
0 likes, 0 repeats
@rin I'm guessing that's the problem?
(DIR) Post #9oRbxkDwNsXGZN9mWu by rin@patch.cx
2019-10-30T07:40:06.473109Z
0 likes, 0 repeats
@DJWalnut yup. try ALTER TABLE bookmarks OWNER TO pleroma;
(DIR) Post #9oRc2KRZf4Bm3tigD2 by DJWalnut@vulpine.club
2019-10-30T07:40:42Z
0 likes, 0 repeats
@rin done. now what?
(DIR) Post #9oRc2KrS6qtBM9pLXs by rin@patch.cx
2019-10-30T07:40:57.226608Z
0 likes, 0 repeats
@DJWalnut migrate
(DIR) Post #9oRcXkeMHFsmJegOaO by rin@patch.cx
2019-10-30T07:46:36.758565Z
9 likes, 4 repeats
@igeljaeger @DJWalnutPleroma Devs Hate Him!Local Pleroma admin exposes shocking stability secret. Learn this one WEIRD trick to his stunning results!image.png
(DIR) Post #9oRcfi29t6quWEbrd2 by igeljaeger@jpop.club
2019-10-30T07:48:04.566499Z
1 likes, 1 repeats
@rin @DJWalnut my mind is blown
(DIR) Post #9oRcjmEcD8YChqNN20 by absturztaube@fedi.absturztau.be
2019-10-30T07:48:48.700170Z
1 likes, 0 repeats
@rin @igeljaeger @DJWalnut :blobcatlul:
(DIR) Post #9oRcpDN6kAaEJlwPYW by DJWalnut@vulpine.club
2019-10-30T07:41:37Z
0 likes, 0 repeats
@rin seems to be working so far
(DIR) Post #9oRcpEEHYT7MygosRE by DJWalnut@vulpine.club
2019-10-30T07:49:07Z
0 likes, 0 repeats
@rin 07:48:00.882 [info] create index objects_in_reply_to_indexis it supposed to take a few minutes on this line?
(DIR) Post #9oRcpEwatiYzC7YGVU by rin@patch.cx
2019-10-30T07:49:46.252041Z
0 likes, 0 repeats
@DJWalnut yeah, index creations usually take a while
(DIR) Post #9oRd5Po6HEjZWEI91E by DJWalnut@vulpine.club
2019-10-30T07:50:23Z
0 likes, 0 repeats
@rin it finished. yeah, this is a $5 VPS so CPU speed isn't the strong suit
(DIR) Post #9oRd5QjWpifgOLA0X2 by DJWalnut@vulpine.club
2019-10-30T07:52:06Z
0 likes, 0 repeats
@rin ** (Postgrex.Error) ERROR 42501 (insufficient_privilege) permission denied for relation conversation_participations (ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1 (elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2 (ecto_sql) lib/ecto/adapters/sql.ex:705: Ecto.Adapters.SQL.execute_ddl/4 (ecto_sql) lib/ecto/migration/runner.ex:302: Ecto.Migration.Runner.log_and_execute_ddl/3 (ecto_sql) lib/ecto/migration/runner.ex:111: anonymous fn/5 in Ecto.Migration.Runner.flush/0 (elixir) lib/enum.ex:1948: Enum."-reduce/3-lists^foldl/2-0-"/3 (ecto_sql) lib/ecto/migration/runner.ex:110: Ecto.Migration.Runner.flush/0 (stdlib) timer.erl:166: :timer.tc/1
(DIR) Post #9oRd5RoWocGTk8VVxo by DJWalnut@vulpine.club
2019-10-30T07:52:16Z
0 likes, 0 repeats
@rin same as before I assume?
(DIR) Post #9oRd5SOgeBBjYHQOK8 by rin@patch.cx
2019-10-30T07:52:42.458152Z
0 likes, 0 repeats
@DJWalnut yeah
(DIR) Post #9oRd8xlCUp8Pgwcw2i by DJWalnut@vulpine.club
2019-10-30T07:53:15Z
2 likes, 0 repeats
@rin BORN TO BREAK / WORLD IS A DB ERROR / Kill Em All 1989 / I am trash admin / 410,757,864,530 DEAD INSTANCES
(DIR) Post #9oRdCJmT55jqr6ostc by igeljaeger@jpop.club
2019-10-30T07:53:57.521433Z
0 likes, 1 repeats
@rin @DJWalnut :mariathink:Capture.png
(DIR) Post #9oRdFFjwYprPBz2REG by rin@patch.cx
2019-10-30T07:54:28.726705Z
0 likes, 0 repeats
@igeljaeger @DJWalnut you need to `git pull` first
(DIR) Post #9oRdGJlf4URzyQLk4O by DJWalnut@vulpine.club
2019-10-30T07:54:03Z
0 likes, 0 repeats
@rin what's the name of this table?
(DIR) Post #9oRdGK4RwdTmuh8kM4 by rin@patch.cx
2019-10-30T07:54:41.090207Z
0 likes, 0 repeats
@DJWalnut conversation_participations
(DIR) Post #9oRdmDkIzoeuZ0vaZU by DJWalnut@vulpine.club
2019-10-30T07:59:27Z
1 likes, 0 repeats
@rin it's...donedone at last!
(DIR) Post #9oRdwJ7zq9yQ9Toplo by rin@patch.cx
2019-10-30T08:02:15.878513Z
0 likes, 0 repeats
@DJWalnut nice. if you have pleroma problems in the future there is https://irc.pleroma.social/ where pleroma devs and admins are idling and https://git.pleroma.social/pleroma/pleroma-support/issues
(DIR) Post #9oRfSYJj0EACTtFClM by DJWalnut@vulpine.club
2019-10-30T08:13:22Z
1 likes, 0 repeats
@rin thank you for the help
(DIR) Post #9oRfxSlHhwf8ECsGjA by vaartis@pl.kotobank.ch
2019-10-30T08:24:44.803881Z
0 likes, 0 repeats
@rin @DJWalnut there's a pleroma IRC now huh
(DIR) Post #9oRg5hUyneFOFcAxl2 by rin@patch.cx
2019-10-30T08:26:22.130992Z
0 likes, 0 repeats
@vaartis @DJWalnut I mean, the irc channel has been there forever, but yeah the webchat is a recent addition
(DIR) Post #9oRg8W0txRAZV0Rufg by vaartis@pl.kotobank.ch
2019-10-30T08:26:44.964768Z
0 likes, 0 repeats
@rin @DJWalnut oh ok so it just connects to the pleroma room on freenode?
(DIR) Post #9oRgA7oysJ3J2zdnyS by rin@patch.cx
2019-10-30T08:27:11.071153Z
1 likes, 0 repeats
@vaartis @DJWalnut yeah