Questions tagged [mariadb]
The mariadb tag has no summary.
178 questions
3
votes
1
answer
41
views
MariaDB won’t start after php-updater change – “Unknown/unsupported storage engine: InnoDB”
I am running Nextcloud on Debian 11. Recently, I tried upgrading using php-updater, and afterwards MariaDB stopped working properly.
System details:
Debian 11
MariaDB 11.3.2
Apache with mpm_prefork (...
- 279
0
votes
0
answers
48
views
Systemd service to keep a fixed number of the same script running
I have been developing a task based system recently for a PHP project, which consists of tasks stored in a SQL database (MariaDB) for a queue, and a task worker PHP script to go through the queue and ...
0
votes
0
answers
40
views
Database Migration from EOL CentOS to MariaDB 11.3.2: Seeking Advice on Potential Compatibility Issues
I am migrating a database from EOL CentOS Linux and am ready to import it into MariaDB 11.3.2 for Debian Linux.
The database code was made with MariaDB 10.19-11.4.1 for Linux (x86_64), which is NOT ...
2
votes
1
answer
61
views
How to correctly handle apostrophes in Ansible templates for SQL statements?
I wrote an Ansible playbook to grab information from some YAML files and store it in a MariaDB database.
It uses this Jinja SQL template:
REPLACE INTO mytable(hostname,fqdn,owner, ...) VALUES
{% for ...
- 32.4k
0
votes
0
answers
42
views
Error running "service glb getinfo": missing /etc/default/glbd
I installed GLB (Galera Load Balancer) on the server following the instructions in this article.
The installation appeared to complete successfully, but in the final step, running:
service glb getinfo
...
- 1
0
votes
1
answer
118
views
How to change logrotate permissions for MariaDB error log from 640 to 644?
I need to change the read permissions from 640 to 644 so a different Linux user can access the MariaDB error log. My server's host uses CloudLinux and it is setup to use logrotate with the MariaDD ...
- 192
3
votes
0
answers
79
views
Large disk usage difference between two MariaDB servers with similar data [closed]
I'm trying to understand a significant discrepancy in disk usage between two MariaDB servers that are hosting the same application and (apparently) the same data. The two servers are entirely separate ...
- 187
0
votes
1
answer
81
views
Error installing package
In my CentOS Stream Linux 9 when I run the command:
yum install perl-DBD-MySQL
It gives me an error:
Transaction Summary
===============================================================================...
0
votes
0
answers
211
views
Install mysql (not mariadb) on raspbian bookworm and other debian
There are many servers in the network that I manage, and throughout that network, mysql is the standard and only "mysql-like" database used. (There's some postgre but that is another matter)...
- 101
0
votes
0
answers
195
views
single node Slurm machine, munge authentication problem
I'm in the process of setting up a singe-node Slurm workstation machine and I believe I followed the process closely and everything is working just fine. See below:
sudo systemctl restart slurmdbd &...
- 283
-1
votes
1
answer
183
views
MariaDB password only works if passed as command line argument
If I try to login this way, it works.
$ mariadb --user blogbot -p"password"
If I try to login this way, it doesn't work.
$ mariadb --user blogbot -p
Enter password:
ERROR 1045 (28000): ...
- 101
0
votes
0
answers
93
views
High swap consumption during database backup with mariabackup
We are experiencing a swap consumption problem when backing up our database.
Every evening at 01am we run the mariabackup command and during the process swap usage rises sharply until it reaches 100% ...
0
votes
1
answer
78
views
Script bash - Insertion of data into MariaDB from Oracle database
This script bash makes the data extraction to Oracle DB (another server), processing it and insert into MariaDB (my server), but the insertion it's misaligned and let it some columns in blank.
This ...
- 3
-1
votes
1
answer
120
views
Can ClamAV detect malicious files on a MySQL/MariaDB server?
Can ClamAV help detect malicious files (ie malware, rootkits, etc) for a MySQL/MariaDB server, specifically the /var/lib/mysql data folder?
The database server is a single role and locked down both by ...
0
votes
1
answer
492
views
AlmaLinux 9.4 how to update MariaDB to a later version
I have a brand new AlmaLinux 9.4 installation with my hosting company and it appears to have been pre-installed with a LAMP stack.
The MariaDB server version currently running is MariaDB 10.5.22 but I ...
- 101