Post ArDa5EetRdcIKImbaK by jerry@my-place.social
(DIR) More posts by jerry@my-place.social
(DIR) Post #ArChycL1by5ADPsvvE by _elena@mastodon.social
0 likes, 0 repeats
Good morning Fedi friends!Today marks the 2-month anniversary of my #selfhosting journey: on Dec 17 I signed up for a VPS and installed #YunoHost https://mastodon.social/@_elena/113667636910565210I have never felt more empowered, tech-wise, than in the past two months. I set up my own #GoToSocial, #Pixelfed and #Friendica instances. Seeing the label "admin" next to my name always makes me smile.Today I will sign up for a 2nd VPS (that runs on Ubuntu) and manually install #Ghost. Wish me luck!#MySoCalledSudoLife
(DIR) Post #ArCi62fU7Dlvu4zlg0 by alberto@albertoventurini.com
0 likes, 0 repeats
@_elena Good luck and congratulations on your self-hosting journey!
(DIR) Post #ArCiNQstKj1bvpYhEm by mensrea@freeradical.zone
0 likes, 0 repeats
@_elena an reason you're not doing that with yunohost?
(DIR) Post #ArCjHHw9moI6Omihc0 by fabio@manganiello.social
0 likes, 0 repeats
@_elena I haven’t followed the context, but I wish they had decided to try and get things to work with MariaDB rather than MySQL 8, considering that the latter is now Oracle-owned and not FOSS…@leberschnitzel
(DIR) Post #ArCjHLxMqFdUrhJj3Q by TotalSonic@mastodon.social
0 likes, 0 repeats
@_elena - thank you so much for your sharing your self hosting journey here - you inspired me to install Yunohost today on a ununsed desktop I had laying around. I will be configuring it over the next few days, looking forward to seeing what I can do with it ....
(DIR) Post #ArCjRvsQ97SlAK32Q4 by sanzky@masto.es
0 likes, 0 repeats
@_elena I love your enthusiasm. It's always nice to read your updates on what you are up to in your self hosting journey.
(DIR) Post #ArCjzToQzkApyIBDyy by sanzky@masto.es
0 likes, 0 repeats
@_elena oh. I got the same issue on gotosocial (which I discovered through you!)good luck!
(DIR) Post #ArCkR1HWfIiJapv3om by citizenk@mastodon.social
0 likes, 0 repeats
@_elena Good luck! 🍀 Provided you can afford it, it’s also a good thing to have another, different VPS laying around, just in case one of them throws a tantrum one day. And it’s always great to learn new things!
(DIR) Post #ArCkt6PXBkajbq3XVo by leberschnitzel@existiert.ch
0 likes, 0 repeats
@_elenaWhat worries me with YunoHost is the implications of an easier point of entry for self hosting.Someone more experienced could run MySQL and MariaDB on the same server, create docker instances of either or find other possibilities to run it, without depending on Yunohost volunteers.Having an easy point of entry is good, but it poses it's own risk. And someone with less experience might not be able to evaluate those risks when they want to want support something long term.
(DIR) Post #ArCl6bx9E7oHCTDhbs by mensrea@freeradical.zone
0 likes, 0 repeats
@_elena odd. i'll need to look onto their reasoning behind "not supporting" mariadb. it's supposed to be a drop-in replacement for mysql for those that want nothing to do with oracle
(DIR) Post #ArCofvunIfId6pea24 by gdjp@mastodon.sdf.org
0 likes, 0 repeats
@_elena This is very interesting. I have used wordpress in the past. I will recommend some writers that I follow to review this service. Thanks. https://ghost.org/alternatives/
(DIR) Post #ArCpd45AZrs7WchdAm by fmors@fosstodon.org
0 likes, 0 repeats
@leberschnitzel @_elena that's true, but if you run Yunohost installed on a server or VPS running Debian, you can still run Docker with your custom apps and just use Yunohost to set up reverse proxy and certificate management! From a purist POV may not be enough, but it gives plenty of possibilities beyond the capabilities of Yunohost volunteers!
(DIR) Post #ArCpd4vHS7YW8F5FOi by leberschnitzel@existiert.ch
0 likes, 0 repeats
@fmors oh yeah definitely the possibility is there. But if you start with YunoHost *because* it's easy, it's unlikely that you have experience with implementing a solution like this. See for example @_elena 😅 (not meant as a negative, you just always point out that you are not a developer)EDIT because my keyboard eats some letters
(DIR) Post #ArCrEP3Lfiz9EWDduy by fmors@fosstodon.org
0 likes, 0 repeats
@_elena @leberschnitzel that's the beauty of the tech world: you pick easier and practical solutions to start with, then you get excited about the possibilities, go very deep, learn a lot on custom and more advanced topics, and then you go back to simplicity because, well, it's simpler! 😂
(DIR) Post #ArCwogt5LBsEk2Xbhg by thedudeabides420@universeodon.com
0 likes, 0 repeats
@_elena I set up a pixelfed instance for my website on a host, but decided I wanted to self host, so I bought a high end router and port forwarded the connection for my domain name to my PC where I am running virtual box Ubuntu LAMP stack vm to serve out my websites. I plan to have friendica, pixelfed, Mastodon and Lemmy installed. This is kinda fun actually. https://pxlfd.thedudeabides.shop
(DIR) Post #ArD7YCbjFh9HgzlNFg by bigTanuki@social.linux.pizza
0 likes, 0 repeats
@_elena did you use a vps suggested by yunohost?
(DIR) Post #ArD7fp1wnMZiszeyeG by gumnos@bsd.cafe
0 likes, 0 repeats
@_elena not much to add beyond cheering you along the journey. Thanks for sharing your notes of your venture!🥳 🎉
(DIR) Post #ArDD1WFTnzlMmF9fNY by jerry@my-place.social
0 likes, 0 repeats
Wow. You're on fire! Very impressive!
(DIR) Post #ArDDsoUGj2lugtU88m by guayabito@mastodon.cr
0 likes, 0 repeats
@_elena good luck!
(DIR) Post #ArDQ0zERrKolmXkUXg by jerry@my-place.social
0 likes, 0 repeats
I don't think this error means a disastrous install problem.ECONNREFUSED is a TCP error, so this tells me you are not connecting with a socket, but using a TCP connection on port 3306. So why would the connection be refused?What I would do next, from the command line, is to see if anything is even listening on port 3306. Depending on whether anything accepts the connection, it gives the next debugging step.telnet, btw, is not natively installed on Ubuntu, so you may need to do this first before continuing:sudo apt updatesudo apt install telnetdThen:telnet localhost 3306So, is anything listening? If not, then either the database didn't start or it's listening on a different port.If something is listening, then try to access the database directly:mysql -h localhost -u root -p 3306If this fails, hopefully you get a meaningful error message telling you why. Maybe a DB issue, or perhaps no database is up.If it works, then your database is up and running and listening on port 3306. This is good news. So either your Ghost configuration has the wrong host/port information for the database, or perhaps the connection needs or doesn't need an SSL connection.But, these are the steps I'd do first just to get additional information about the issue.
(DIR) Post #ArDUXpqQBN6A2XQg7c by jerry@my-place.social
0 likes, 0 repeats
I wish it finished the sentence, "not a recogonisable Ghost installation because ..."What happens when you run "sudo mysql" ?If it opens and connects, then it's still using socket-based authentication. Then I would manually run the ALTER, FLUSH, and exit. Then try to restart ghost.If it doesn't open, but asks for the password, and the password works, then this change in the authentication method already was done and the problem isn't this particular step. Does ghost doctor provide any diagnostics?
(DIR) Post #ArDa5EetRdcIKImbaK by jerry@my-place.social
0 likes, 0 repeats
This is what self-hosting is about. Living in a cloud of confusion because you're dealing with a bunch of different tech, none of which you'd ever be able to become an expert in. So, there's a lot of trial and error. This is so familiar. And the fun of it.The ALTER statement format, I believe, is wrong. It is showing single quotes around "mysql_native_password" which makes it a literal string. But, IDENTIFIED WITH specifies the name of the authentication plugin, not a string. Can you try instead:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your-new-root-password>';Reference: dev.mysql.com/doc/refman/8.0/e… and the section showing:| IDENTIFIED WITH auth_plugin BY 'auth_string'Notice, no single quotes around auth_plugin