<2022-09-27T12:34:36.000Z> josh: ok
<2022-09-27T12:34:37.000Z> josh: look
<2022-09-27T12:34:47.000Z> josh: i got the fucking thing to work, i had to manually set the port
<2022-09-27T12:34:50.000Z> josh: but now it doesn't come up
<2022-09-27T12:34:55.000Z> josh: neither A or B actually comes up
<2022-09-27T12:35:28.000Z> DumpsterFire: have the failures in the log changed?
<2022-09-27T12:35:42.000Z> josh: ye sec
<2022-09-27T12:36:55.000Z> josh: klgrth.io/paste/nay6o
<2022-09-27T12:37:05.000Z> josh: I guess there's no point censoring any of that because it's public IPs
<2022-09-27T12:40:48.000Z> DumpsterFire: all good, only concerned with making the people taking a victory lap seethe, having a look at the logs now
<2022-09-27T12:53:14.000Z> DumpsterFire: initial suspicion is on the start of the primary in the cluster[Warning] WSREP: no nodes coming from prim view, prim not possiblewhat nix distro is the server running? think it could be the way gallera is bootstrapped 
<2022-09-27T12:55:15.000Z> josh: debian 11
<2022-09-27T12:55:17.000Z> josh: and that IS the primary
<2022-09-27T12:55:58.000Z> DumpsterFire: also can you go into mysql cmd and run SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';
<2022-09-27T12:56:44.000Z> josh: not without turning off galera.
<2022-09-27T12:56:50.000Z> DumpsterFire: and did you start the cluster with galera_new_cluster
<2022-09-27T12:57:01.000Z> josh: do I have to do that every time it reboots?
<2022-09-27T12:57:29.000Z> josh: actually I can't because myself refuses to boot if I try
<2022-09-27T12:59:01.000Z> josh: i see
<2022-09-27T12:59:04.000Z> josh: different error when using that
<2022-09-27T12:59:05.000Z> DumpsterFire: mysql refuses to start on the noew cluster invoke?
<2022-09-27T12:59:10.000Z> josh: yes
<2022-09-27T12:59:17.000Z> josh: both nodes bitched about not being the last one
<2022-09-27T12:59:24.000Z> josh: but it's dns, the records don't change unless it's manual so whatever
<2022-09-27T12:59:30.000Z> josh: i got it up
<2022-09-27T13:00:35.000Z> DumpsterFire: the galler_new_cluster only needs to be run on the primary or first server, i think it only needs to be run when the entire cluster goes down
<2022-09-27T13:01:09.000Z> josh: cheers mate, this shit is driving me crazy
<2022-09-27T13:01:20.000Z> josh: ✔️ Backup database restored.✔️ Files synchronized.✔️ Self-hosted DNS✔️ Primary web servers configured.❌ Secondary web servers configured.✔️ Tertiary web servers configured.❌ DNS round-robin with healthchecks.❌ Automated backups reconfigured.✔️ Email server NS records set.❌ Mass mandatory password reset.❌ Tor .onion hidden service.❌ GamerGate 2
<2022-09-27T13:01:23.000Z> josh: this is the checklist now
<2022-09-27T13:03:25.000Z> DumpsterFire: no worries, hit me up if you hit any more roadblocks and i'll help where i can, about to head to bed though as it's 11pm and i have to work tomorrow.
<2022-09-27T13:03:50.000Z> DumpsterFire: also dying to find out what gamergate 2 entails
<2022-09-27T13:03:57.000Z> josh: nothing lol
<2022-09-27T13:04:00.000Z> josh: sorry to disappoint