#wordpress 2025-03-14

2025-03-14 UTC
#
Kolev Someone claims to be able to access calebh.top.
#
[artlung] It's returning a 403 Forbidden and announcing it's from `nginx/1.18.0 (Trisquel GNU/Linux)` - and browse reports secured with a Let's Encrypt cert.
#
Kolev [artlung], what's going on now?
#
[artlung] _Welcome to http://calebh.top!_
#
Kolev Now I'm getting this:
#
Kolev https://share.csh.snikket.chat/upload/4_ayr5aEXNHfqJ3CW48IS-0A/2025-03-13-wp-setup-config.png
#
Kolev Cannot select database. The database server could be connected to (which means your username and password is okay) but the wordpress database could not be selected.
#
GWG Okay. I assume you set up a user and a database in MySQL for it?
#
Kolev GWG, I haven't because I cannot access phpmyadmin.
#
Kolev https://share.csh.snikket.chat/upload/eW3LDNbRF7r_ddzvx9JB-qjr/2025-03-13-phpmyadmin-404.png
#
GWG What about doing it on the command line?
#
GWG Is the SQL server on the same box?
#
Kolev Yes.
#
Kolev IDK how to do it on the command line.
#
GWG That I can help you with
#
GWG sudo mysql should get you root access to mysql.
#
GWG https://developer.wordpress.org/advanced-administration/before-install/creating-database/#using-the-mysql-client
#
Kolev GWG, right.
#
GWG This has the instructions to add the database with username and password
#
Kolev GWG, ERROR 1044 (42000): Access denied for user 'caleb'@'%' to database 'wordpress'
#
GWG Hmm...which step in those instructions?
#
Kolev OK, fixed with `sudo mysql`.
#
GWG Great.
#
Kolev GWG, a WordPress page is now up. What now?
#
GWG What do you want to do first? I'd pick a theme and create a few pages of content, then we can add Indieweb plugins
#
Kolev GWG, I don't even know how to pick a theme or create pages. How do It do i get to the panel?
#
GWG Go to /wp-admin
#
GWG And log in.
#
GWG That will get you all the interfaces.
#
GWG And you can start playing with settings.
#
GWG I'd say play around for a bit before we do anything else specific
#
Kolev GWG, it refers to calebh.top which my laptop cannot access for some reason.
#
GWG It refers from calebh.top/wp-admin to just calebh.top ?
#
Kolev <https://farnsworth/wp-admin> redirects to <https://calebh.top/wp-login.php?redirect_to=https%3A%2F%2Ffarnsworth%2Fwp-admin%2F&reauth=1>.
#
GWG It should redirect to wp-login, that's fine.
#
Kolev And my laptop cannot access <https://calebh.top/>. Firefox says "Unable to connect."
#
GWG When I click the link, it gives me the login page
#
GWG SO I can get the non logged in site
#
Kolev GWG, that's weird. Why can't my own laptop not get it?
#
GWG It might be the same problem I had earlier
#
GWG Cached DNS for the old address?
#
GWG Not sure
#
Kolev I can't access it from my phone either.
#
GWG But both on your home network?
#
Kolev GWG, yes.
#
GWG Try putting the phone on mobile.
#
GWG It might be cached in the DNS server on your router
#
Kolev The phone is Spectrum too. Turned off Wi-Fi. Just loads forever.
#
GWG Weird.
#
GWG I am using Chrome, but unsure.
#
Kolev bashes head against wall.
#
GWG What exactly is the error?
#
Kolev Well I used Chrome on Google Pixel and Firefox on Trisquel.
#
Kolev GWG, no error, it just starts to load and stops.
#
GWG Anything in the dev console or such?
#
GWG I'd ask if I could try logging in, but I don't want to know your password.
#
Kolev Dev console... on mobile?
#
GWG On the desktop
#
GWG In the browser. Sometimes there are error messages there
#
Kolev My desktop is Wi-Fi, so it can't connect.
#
GWG Trying to think of network related issues, because it has to be something there, because the site seems to be working
#
Kolev And I still don't have Let's Encrypt to auto-renew because the stupid officail guide demands I use Snap or Pip, which aren't available on Trisquel.
#
GWG Kolev: It uses systemd?
#
Kolev GWG, it uses systemd.
#
GWG If so, see if there is a certbot.timer you can enable?
#
GWG I know that's a default in many distros
#
Kolev It's already updating my cert? https://paste.debian.net/1362971/
#
GWG Yes
#
GWG Most distros started adding a timer by default now
#
Kolev Cool.
#
Kolev NAT loop. Dammit.
[jeremycherfas], [artlung], Guest6, [schmarty] and [Sophia_wood] joined the channel
#
Kolev Uh oh.
#
Kolev Error establishing a database connection
#
Kolev GWG, I'm on a new LAN and that's what I got.
#
GWG Progress... but I got a login screen last night...odd
#
Kolev GWG: Supposedly I'll be able to access my server st home if I add the local IP to hosts file.
#
GWG That's how I've done it until it propogated
#
Kolev GWG: well, in think hostname was originally local host and then I did Farnsworth
#
GWG If you use a different name than the site the redirects might fail
#
Kolev GWG: Farnsworth is the server's local name though
#
Kolev And I still have to get around the hair pinning
#
Kolev Should I have done local host...
#
GWG In your hosts file you can just add the private IP address with the public name
#
Kolev GWG: yeah
#
GWG I have a router where I manually override DNS
#
Kolev I'm stuck with Spectrum router. Sad.
#
[snarfed] Kolev sorry this has been such a struggle. at this point you may want to try other general WordPress support chats or forums; we're often able to help here, but there are many more WP experts in those places!
#
GWG So far, we haven't even gotten to WordPress...this is more network and server stuff
#
Kolev Sorry...
#
GWG Kolev: Nothing to be sorry about
#
GWG We're still here to help
#
GWG I have an idea though
#
GWG What timezone are you in?
#
Kolev I'll open a support thread in WordPress forum.
#
Kolev GWG: UTC-5
#
GWG Okay. . perfect
#
Kolev Why?
#
GWG I haven't done a how to set up Indieweb plugin demo in ages...we have a Zoom account for the community. I could schedule one and at the same time, record it for future users
#
GWG If I put it on the event calendar a few people might show
#
Kolev How do I enable nonfree flathub? I only have the floss subset enabled.
#
Kolev Hm. Maybe I can just re-add Flathub.
#
Kolev `flatpak remote-modify --subset= flathub`
#
[Sophie_Young] alright I'm taking a crack at installing WordPress! fingers crossed 🤞
#
Kolev [Sophie_Young]: good luck
#
GWG It usually works quickly
#
Kolev When I get home I'll check if mysql is running
Saige_Leah_catgi joined the channel
#
GWG [Sophie_Young]: Tell us if we can help?
#
GWG You interested in a live session on Indieweb and Press? Thinking of doing one for an hour.
#
Kolev Server added to hosts. MySQL running.
#
Kolev GWG, edited wp-config.php and still same error.
#
Kolev https://share.csh.snikket.chat/upload/k3WwqpNjsS5OIXHeLaeginML/2025-03-14-database-settings.png
#
GWG And those are the settings that you added to the database?
#
Kolev GWG, yes.
#
Kolev Oh shit, guess I better change... fuck
#
Kolev Better change my password.
#
GWG Was about to say that
#
GWG But this is rather odd
#
Kolev How do I start over? :-(
#
GWG Drop The database and recreate it?
#
GWG drop database wordpress;
#
Kolev OK, where are the instructions on making the database again?
#
Kolev https://developer.wordpress.org/advanced-administration/before-install/creating-database/#using-the-mysql-client
#
Kolev > All right, sparky! You’ve made it through this part of the installation.
#
Kolev I'm in the admin dashboard.
gRegorLove_ joined the channel
#
GWG Kolev++
#
Loqi Kolev has 1 karma in this channel over the last year (12 in all channels)
#
Kolev GWG, is there a recommended theme?
#
Kolev Great. I need FTP...
#
Kolev Guess I'm not messing with themes right now.
#
Kolev GWG, llinks won't work. I changed the permalinks format.