Adventures in Linux Land

gaekwad · 2025-06-11 14:20:14

Algaris wrote #339844:

My requirements are:

The software must be able to run on its own server managed by me and be accessible only on my network.

The software must be free with no upfront costs or subscriptions.

The software must be able to manage multiple Git repositories.

The software must be able to easily deploy repositories’ to other servers (dev or production).

The software must be able to be able to sync code via git from other servers back to the central server.

There must be no arbitrary limits on how many repositories I can manage or deploy, etc.

Self-hosted GitLab should fit the bill, add your preferred Git UI of choice, and away you go. If you’re running a local server and you’re the only tenant, you may well get away with less then the 4GB RAM it states in the system requirements.

I store my software repos in ~/repos/org/repo-name/, and in my experience changing your local Git management method (e.g., Tower to CLI, CLI to Nova, Nova to Git Butler) shouldn’t cause you any hassle since the repo is essentially self-contained / portable.

Last edited by gaekwad (2025-06-11 14:20:33)

Algaris · 2025-06-13 15:01:15

Thanks Pete. I’m glad to know I’m on the right track.

GitLab was my first choice but I wasn’t sure if there if there’s anything better out there. Sometimes I second-guess myself and end up going rabbit holes researching things rather than getting on with what I need to do. Part of the problem is I’m not fully aware of what’s out there (the old “known unknowns” chestnut), which keeps me researching.

Last edited by Algaris (2025-06-17 08:17:37)

gaekwad · 2025-06-23 15:37:23

Algaris wrote #339865:

Sometimes I second-guess myself and end up going rabbit holes researching things rather than getting on with what I need to do.

Welcome to my world, amigo. It’s exhausting sometimes, I’ve been there many times.

There was something I heard on the Self Hosted show a few years ago: “don’t be the tallest nail”. I found that oddly cathartic, given I’d been getting so cross with stuff that should be just working and wasn’t for weeks.

Iterate. Make notes. Keep a server build document / repo. Accept that in order to be good at something you have to suck at it first. Then you improve incrementally.

Today I am doing PostgreSQL in anger for the first time in a long time, and I’m having to take it slow…change a few things, secure a few things, check, twiddle some knobs, check again, etc. All the time I’m making notes and keeping shell code snippets, along with milestone VOS snapshots so I can a) rebuild really quickly, and copy-paste as much as possible in future.

How do I enable password auth for the postgres user when I do psql -U postgres? I suspect it’s something to do with pg_hba.conf and likely answered here – but my brain is foggy and this stuff is hard today. That said, I’ll probably know in a few hours, and then I’ll update my notes, and then I’ll know forever (or at least until they change it).

Notes. Iterate. Snapshots. Keep at it. It’s never-ending but it’s hella cool when it all works.

gaekwad · 2025-06-23 17:04:48

gaekwad wrote #339892:

How do I enable password auth for the postgres user when I do psql -U postgres? I suspect it’s something to do with pg_hba.conf and likely answered here

Done (in much less than two hours, thankfully):

Use passwd to set user account password for user postgres.
Use sudo -u postgres psql to open PostgreSQL console.
Use \password postgres to set the postgres user password for the console.
Tell pg_bha.conf to use scram-sha-256 for local user(s):

local all         all              scram-sha-256

Bounce postgresql service.
Subsequent psql connections now need a password, even from a local connection.

Algaris · 2025-10-31 12:15:06

I’m currently updating one of my Ubuntu servers. After running sudo apt update, I encountered the following errors. This is a new issue for me, so I’m searching online for a solution. In the meantime if anyone has any advice it would be helpful.

W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://repo.mysql.com/apt/ubuntu noble InRelease: The following signatures were invalid: EXPKEYSIG B7B3B788A8D3785C MySQL Release Engineering <mysql-build@oss.oracle.com>

W: Failed to fetch http://repo.mysql.com/apt/ubuntu/dists/noble/InRelease  The following signatures were invalid: EXPKEYSIG B7B3B788A8D3785C MySQL Release Engineering <mysql-build@oss.oracle.com>

W: Some index files failed to download. They have been ignored, or old ones used instead.

gaekwad · 2025-10-31 12:20:03

bugs.mysql.com/bug.php?id=119212

Translation: pop the kettle on and wait for the Oracle rabble to catch up and sort themselves out.

You could chuck deb [allow-insecure=yes] into the mix if you absolutely need to get it updated today, but this is not a good idea.

Algaris · 2025-10-31 12:24:27

So, I can effectively ignore the error and continue upgrading my server without any issues?

gaekwad · 2025-10-31 12:26:04

Algaris wrote #341048:

So, I can effectively ignore the error and continue upgrading my server without any issues?

Yes. It’s essentially saying the MySQL signing key has expired at the Oracle end. This has happened before, they will resolve it their side, and the warning (W: means warning, and E: means error) will go away.

ETA: I realise the warning includes the word ‘error’, but the W: prefix means it’s a warning.

Last edited by gaekwad (2025-10-31 12:27:00)

Algaris · 2025-10-31 12:29:02

That’s a relief all the search results were telling me to update the mysql keyring by running commands like:

curl -fsSL https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | gpg --dearmor | sudo tee /usr/share/keyrings/mysql.gpg > /dev/null

and then update the mysql sources list manually.

I got nervous at that point as I don’t like doing something unless I understand the reasoning behind it.

Last edited by Algaris (2025-10-31 12:29:47)

gaekwad · 2025-10-31 12:50:02

There is reportedly a new key with a 2027 expiry, and an updated mysql-apt-config with it baked in. You could push this through with the following:

curl -Lo \
"$HOME"/mysql-apt-config.deb \
https://dev.mysql.com/get/mysql-apt-config_0.8.35-1_all.deb \
&& sudo dpkg -i \
"$HOME"/mysql-apt-config.deb

What this does: downloads the updated mysql-apt-config with the fresh key embedded; installs it.

This sidesteps the manual update of your sources.list stuff, but achieves the same result.

Edited: correct local file this time.

Last edited by gaekwad (2025-10-31 14:30:04)

Algaris · 2025-10-31 13:56:32

I tried running this and got the following error:

dpkg: error: cannot access archive '/home/user01/mysql-apt-config': No such file or directory

gaekwad · 2025-10-31 14:31:18

Mea culpa – I missed the local file extension. Updated:

curl -Lo \
"$HOME"/mysql-apt-config.deb \
https://dev.mysql.com/get/mysql-apt-config_0.8.35-1_all.deb \
&& sudo dpkg -i \
"$HOME"/mysql-apt-config.deb

When this completes, you can remove "$HOME"/mysql-apt-config and "$HOME"/mysql-apt-config.deb:

rm -f "$HOME"/mysql-apt-config "$HOME"/mysql-apt-config.deb

Last edited by gaekwad (2025-10-31 14:31:30)

Algaris · 2025-10-31 14:47:04

Thank you that worked.

gaekwad · 2025-10-31 14:55:26

Algaris wrote #341050:

I got nervous at that point as I don’t like doing something unless I understand the reasoning behind it.

Do you understand what the | stuff does?

Algaris · 2025-11-03 09:17:58

gaekwad wrote #341055:

Do you understand what the | stuff does?

I get the gist of the code, but I’m not sure what the specific commands do.

Textpattern CMS

Textpattern CMS support forum

#46 2025-06-11 14:20:14

Re: Adventures in Linux Land

Algaris wrote #339844:

#47 2025-06-13 15:01:15

Re: Adventures in Linux Land

#48 2025-06-23 15:37:23

Re: Adventures in Linux Land

Algaris wrote #339865:

#49 2025-06-23 17:04:48

Re: Adventures in Linux Land

gaekwad wrote #339892:

#50 2025-10-31 12:15:06

Re: Adventures in Linux Land

#51 2025-10-31 12:20:03

Re: Adventures in Linux Land

#52 2025-10-31 12:24:27

Re: Adventures in Linux Land

#53 2025-10-31 12:26:04

Re: Adventures in Linux Land

Algaris wrote #341048:

#54 2025-10-31 12:29:02

Re: Adventures in Linux Land

#55 2025-10-31 12:50:02

Re: Adventures in Linux Land

#56 2025-10-31 13:56:32

Re: Adventures in Linux Land

#57 2025-10-31 14:31:18

Re: Adventures in Linux Land

#58 2025-10-31 14:47:04

Re: Adventures in Linux Land

#59 2025-10-31 14:55:26

Re: Adventures in Linux Land

Algaris wrote #341050:

#60 2025-11-03 09:17:58

Re: Adventures in Linux Land

gaekwad wrote #341055:

Board footer