Resolving the MariaDB and Fedora problem Dark _ □ ✕
  • Posts
  • About
  • Debug
Post

Resolving the MariaDB and Fedora problem

Published
2026-09-05 13:30 UTC (precision: second)
Author
Kelly Adams
Source feed
Ubergeek Kelly's World [exclude this blog]
Link
https://www.kgadams.net/sitenews/resolving-the-mariadb-and-fedora-problem
Length
4525 runes
Extracted text
I previously recounted an issue with my blog server wherein the MariaDB failed to start after a Fedora update. I found a work-around for that problem to get the blogs back up and running but the underlying issue remained: each time the server rebooted the MariaDB database would fail to start due to a missing /run/mariadb folder. The root cause My workaround involved manually re-creating the /run/mariadb folder each time the server restarted. This means I have to be aware of when the server might have gone through a restart cycle and I have to be in a position with my computer handy to perform the steps necessary to recreate the folder. This all makes it very likely that my blog will be in an outage state at least once a week and is simply kind of aggravating so, after another outage earlier this week, I decided to re-examine the situation. Examining the process to create the /run files I identified the following elements: a folder called /usr/lib/tmpfiles.d: which is where all of the packages like MariaDB create their pre-run configurations (*.conf files) a folder called /etc/tmpfiles.d: where you can create override files for the directives in /usr/lib/tmpfiles.d the systemd-tmpfiles command: which parses the above files usually during service startup and creates temporary files according to the directives I created a simplified version of mariadb.conf file in /etc/tmpfiles.d that only creates the /run/mariadb folder. I then attempted to execute the systemd-tmpfiles command against just that single configuration file and observed an error. [root@kgadams kadams]# cat /etc/tmpfiles.d/mariadb.conf d /run/mariadb 0755 mysql mysql - [root@kgadams kadams]# systemd-tmpfiles --create /etc/tmpfiles.d/mariadb.conf Detected unsafe path transition / (owned by 1026) ? /run (owned by root) during canonicalization of run. [root@kgadams kadams]# cd /run I also observed the same error recurring hundreds of times if I use the systemd-tmpfiles command without a file parameter which causes it to execute all the configuration files in /usr/lib/tmpfiles.d (/etc/tmpfiles.d is the over-ride folder) Based on a Google search I found a reference to the problem. It appears to be a security setting that prevents systemd-tmpfiles from working with folders that are owned by something other than root. This is intended to prevent privilege escalation techniques. [root@kgadams run]# ls -ld /run drwxr-xr-x. 34 root root 1060 Sep 2 09:28 /run [root@kgadams run]# ls -ld / drwxrwxrwx. 21 1026 users 4096 Aug 22 21:29 / [root@kgadams run]# chown root:root / [root@kgadams run]# ls -ld / drwxrwxrwx. 21 root root 4096 Aug 22 21:29 / I don’t know why the root (/) folder was owned by user UID=1026 and group users, and the permissions look a bit too permissive. But changing the ownership was sufficient for systemd-tmpfiles to work. After making this change the /run/mariadb folder was created on restart and the MariaDB database started without error. Summation MariaDB has worked on my server for years without issue. The problem started with a Fedora update that occurred just before my previous server outage which occurred on (I believe) August 25. I have automatic upgrades enabled meaning a lot of things change fairly quickly on my server, so something occurred on that date that triggered the outage conditions. There was a kernel upgrade performed on my server on August 25 which causes a restart so it is possible that either the update itself or merely the reboot along with a prior change was the trigger. That means that one of two things changed: The / directory had previously been owned by UID=1026 but the security rules were tightened The / directory ownership was changed by something in the Fedora update to UID=1026 instead of root I don’t know how long the security rules associated with systemd-tmpfiles have been in place so I cannot eliminate #1 as a cause. As for #2: I have zero recollection of ever changing ownership of the / folder on my server. That doesn’t mean that I never did: the server has been operating for close to a decade so a lot can happen in that time. My best guess is that the security rules changed and I am somehow at fault for the incorrect directory ownership. I suppose it is just barely possible that some Fedora package changed the ownership of the root folder, but at the moment I’m going to assume that isn’t the case. Regardless, I now count this problem as “Fixed” as my server can restart reliably without causing a database and, thereby, blog outage. Hurray!
Stored topics

Every stored assignment is listed, including rows below the current cutoff (0.75), so a missing tag can be explained.

Concept Code Score Meter Margin Origin Path
economy, business and finance economy-business-and-finance 0.98 3.91 ↑derived from 20000225 economy, business and finance
products and services products-and-services 0.98 3.91 ↑derived from 20000225 economy, business and finance > products and services
computing and information technology computing-and-information-technology 0.98 3.91 direct economy, business and finance > products and services > computing and information technology
science and technology science-and-technology 0.97 3.44 ↑derived from local:information-security science and technology
technology and engineering technology-and-engineering 0.97 3.44 ↑derived from local:information-security science and technology > technology and engineering
information technology and computer science information-technology-and-computer 0.97 3.44 ↑derived from local:information-security science and technology > technology and engineering > information technology and computer science
Information security information-security 0.97 3.44 direct science and technology > technology and engineering > information technology and computer science > Information security
software and applications software-and-applications 0.95 2.99 direct economy, business and finance > products and services > computing and information technology > software and applications
Software development software-development 0.75 1.09 direct economy, business and finance > products and services > computing and information technology > software and applications > Software development
Open source open-source 0.72 0.96 direct economy, business and finance > products and services > computing and information technology > software and applications > Open source
Cryptography cryptography 0.23 -1.21 direct science and technology > technology and engineering > information technology and computer science > Cryptography
arts, culture, entertainment and media arts-culture-entertainment-and-media 0.22 -1.25 ↑derived from local:blogging arts, culture, entertainment and media
mass media mass-media 0.22 -1.25 ↑derived from local:blogging arts, culture, entertainment and media > mass media
social media social-media 0.22 -1.25 ↑derived from local:blogging arts, culture, entertainment and media > mass media > social media
Blogging blogging 0.22 -1.25 direct arts, culture, entertainment and media > mass media > social media > Blogging
arts and entertainment arts-and-entertainment 0.17 -1.58 ↑derived from 20000013 arts, culture, entertainment and media > arts and entertainment
literature literature 0.17 -1.58 direct arts, culture, entertainment and media > arts and entertainment > literature
environment environment 0.16 -1.66 direct environment
crime, law and justice crime-law-and-justice 0.14 -1.80 ↑derived from 20000086 crime, law and justice
crime crime 0.14 -1.80 ↑derived from 20000086 crime, law and justice > crime
cyber crime cyber-crime 0.14 -1.80 direct crime, law and justice > crime > cyber crime
Self-hosting self-hosting 0.13 -1.88 direct economy, business and finance > products and services > computing and information technology > Self-hosting
media and entertainment industry media-and-entertainment-industry 0.13 -1.89 ↑derived from 20001293 economy, business and finance > products and services > media and entertainment industry
streaming service streaming-service 0.13 -1.89 direct economy, business and finance > products and services > media and entertainment industry > streaming service
society society 0.11 -2.06 ↑derived from 20001300 society
fundamental rights fundamental-rights 0.11 -2.06 ↑derived from 20001300 society > fundamental rights
privacy privacy 0.11 -2.06 direct society > fundamental rights > privacy
artificial intelligence artificial-intelligence 0.11 -2.08 direct science and technology > technology and engineering > information technology and computer science > artificial intelligence
family family 0.08 -2.43 direct society > family
film industry film-industry 0.08 -2.43 direct economy, business and finance > products and services > media and entertainment industry > film industry
sport sport 0.07 -2.54 ↑derived from 20001183 sport
competition discipline competition-discipline 0.07 -2.54 ↑derived from 20001183 sport > competition discipline
eSports esports 0.07 -2.54 direct sport > competition discipline > eSports
scientific research scientific-research 0.07 -2.55 ↑derived from 20000739 science and technology > scientific research
scientific exploration scientific-exploration 0.07 -2.55 ↑derived from 20000739 science and technology > scientific research > scientific exploration
space exploration space-exploration 0.07 -2.55 direct science and technology > scientific research > scientific exploration > space exploration
lifestyle and leisure lifestyle-and-leisure 0.06 -2.83 ↑derived from local:mmorpg lifestyle and leisure
leisure leisure 0.06 -2.83 ↑derived from local:mmorpg lifestyle and leisure > leisure
game game 0.06 -2.83 ↑derived from local:mmorpg lifestyle and leisure > leisure > game
video game video-game 0.06 -2.83 ↑derived from local:mmorpg lifestyle and leisure > leisure > game > video game
MMORPG mmorpg 0.06 -2.83 direct lifestyle and leisure > leisure > game > video game > MMORPG
Tabletop gaming tabletop-gaming 0.05 -2.94 direct lifestyle and leisure > leisure > game > Tabletop gaming
health health 0.04 -3.08 ↑derived from 20000458 health
disease and condition disease-and-condition 0.04 -3.08 ↑derived from 20000458 health > disease and condition
mental health and disorder mental-health-and-disorder 0.04 -3.08 direct health > disease and condition > mental health and disorder
labour labour 0.03 -3.44 direct labour
consumer goods consumer-goods 0.03 -3.48 ↑derived from 20001160 economy, business and finance > products and services > consumer goods
handicrafts handicrafts 0.03 -3.48 direct economy, business and finance > products and services > consumer goods > handicrafts
health treatment and procedure health-treatment-and-procedure 0.02 -3.71 direct health > health treatment and procedure
disaster, accident and emergency incident disaster-accident-and-emergency-incident 0.02 -3.73 direct disaster, accident and emergency incident
exercise and fitness exercise-and-fitness 0.02 -3.79 direct lifestyle and leisure > wellness > exercise and fitness
wellness wellness 0.02 -3.79 ↑derived from 20001239 lifestyle and leisure > wellness
education education 0.02 -3.80 direct education
natural science natural-science 0.02 -3.85 ↑derived from 20000719 science and technology > natural science
biology biology 0.02 -3.85 direct science and technology > natural science > biology
visual arts visual-arts 0.02 -3.95 ↑derived from 20000036 arts, culture, entertainment and media > arts and entertainment > visual arts
photography photography 0.02 -3.95 direct arts, culture, entertainment and media > arts and entertainment > visual arts > photography
podcast podcast 0.02 -4.01 direct economy, business and finance > products and services > media and entertainment industry > podcast
climate change climate-change 0.02 -4.10 direct environment > climate change
books and publishing books-and-publishing 0.02 -4.14 direct economy, business and finance > products and services > media and entertainment industry > books and publishing
social sciences social-sciences 0.01 -4.20 direct science and technology > social sciences
human interest human-interest 0.01 -4.22 ↑derived from 20000498 human interest
award and prize award-and-prize 0.01 -4.22 direct human interest > award and prize
lifestyle lifestyle 0.01 -4.40 ↑derived from 20001257 lifestyle and leisure > lifestyle
house and home house-and-home 0.01 -4.40 ↑derived from 20001257 lifestyle and leisure > lifestyle > house and home
gardening gardening 0.01 -4.40 direct lifestyle and leisure > lifestyle > house and home > gardening
politics and government politics-and-government 0.01 -4.44 direct politics and government
history history 0.01 -4.45 direct science and technology > social sciences > history
conflict, war and peace conflict-war-and-peace 0.01 -4.47 direct conflict, war and peace
hobby hobby 0.01 -4.58 direct lifestyle and leisure > leisure > hobby
television television 0.01 -4.63 direct arts, culture, entertainment and media > mass media > television
religion religion 0.01 -4.66 direct religion
animation animation 0.01 -4.81 direct arts, culture, entertainment and media > arts and entertainment > animation
food and drink enthusiasm food-and-drink-enthusiasm 0.01 -4.98 direct lifestyle and leisure > leisure > hobby > food and drink enthusiasm
card game card-game 0.01 -5.06 direct lifestyle and leisure > leisure > game > card game
culture culture 0.00 -5.37 direct arts, culture, entertainment and media > culture
public health public-health 0.00 -5.53 direct health > public health
board game board-game 0.00 -5.58 direct lifestyle and leisure > leisure > game > board game
weather weather 0.00 -5.75 ↑derived from 20001128 weather
weather forecast weather-forecast 0.00 -5.75 direct weather > weather forecast
diet diet 0.00 -5.88 direct health > health treatment and procedure > diet
music music 0.00 -6.43 direct arts, culture, entertainment and media > arts and entertainment > music
travel and tourism travel-and-tourism 0.00 -6.54 direct lifestyle and leisure > leisure > travel and tourism

← Back to posts

feedtagger 0.1.0-dev model: modernbert-base-zeroshot-v2.0/int8@all-s256 2115 posts 0 unclassified min score 0.75