Questions tagged [mariadb]
The mariadb tag has no summary.
180 questions
3
votes
1
answer
85
views
How to configure multiple credentials in MariaDB for easy access?
I can't find this information. I also use Grok, but his solution didn't work.
How can I add multiple accounts/credentials to different MySQL/MariaDB servers to be used with mysql command? Similar to ....
- 10.5k
0
votes
0
answers
23
views
mariadb client connection settings
Computer with mariadb server was set up a long time ago and has 3 client-computers on LAN that work great.
I want to add another client.
Installed mariadb-client on latest linux mint 22.2. But,
...
- 37
3
votes
1
answer
53
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
49
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
42
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
62
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
49
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
148
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
96
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
93
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
238
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
216
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 &...
- 323
-1
votes
1
answer
205
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
79
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
127
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
511
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
1
vote
2
answers
2k
views
Why is mariadb.service not restarted by systemd after OOM kill
The mysql.service got killed by the OOM killer. While investigating the root cause I wanted to change the unit configuration to restart if killed. I was surprised to find
Restart=on-abort
already in ...
- 191
0
votes
0
answers
282
views
How to identify which process is causing a high memory consumption?
I am running a virtualized Arch Linux machine.
From time to time, it shows a high memory consumption and I do not know the reason because basically, the machine is sitting idle.
# ps aux --sort=-%mem ...
1
vote
1
answer
366
views
start mariadb but systemctl status mariadb with failed
I installed mariaDB under the path ‘/app/mysql’;
Since the configuration file could not be found, I created the 'my.cnf' file under the 'etc/mysql' path and copied the content online, my.cnf CODE:
[...
- 11
0
votes
0
answers
88
views
Mysql server under pressure?
I'm having issue with a server than hosting 5 Wordpress and 1 staging
Including on Woocommerce and one Bbpress with huge db.
The server got 120Go Ram with 500Mo swap set.
I have a TTFB around 3s...
...
- 1
1
vote
2
answers
782
views
Why do we misnomer MariaDB as a "mysql-server"?
I've had an interesting discussion recently, about whether it is okay to call MariaDB a "mysql server" when in reality, Maria is not 100% compatible with MySQL.
I understand it was ...
- 63
1
vote
0
answers
58
views
"Access Denied user root error code 1045 (28000)" after changing root passwords
I'm encountering an "Access Denied user root error code 1045 (28000)" error with user root. I'm facing this problem after changing passwords. It was working fine before, and I'm confused ...
0
votes
1
answer
54
views
Why can I not transfer a db from one container to another?
In my case, I have 2 mariadb containers running with 2 seperate volumes:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS ...
- 1,321
0
votes
1
answer
58
views
I can't find where to put these options, hence no sock file
I have installed mariadb-server and after a lot of struggling, I managed to get it to re/start without errors. However, there's no sock file so I can't even log in. It also doesn't show in netstat -...
- 61
0
votes
0
answers
374
views
How to use tmpfs in MariaDB when SELinux is enforced?
Running AlmaLinux 9.2 and MariaDB 10.11.
Trying to use in my.cnf:
tmpdir = /dev/shm
This works fine when PHP-FPM is connecting using TCP port.
Now trying to use faster Socket (/var/lib/mysql/mysql....
- 1
1
vote
1
answer
2k
views
Why am I getting this error on mariadb installation?
I am trying to follow this article and systemctl start mariadb.service gives me
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb....
- 61
0
votes
1
answer
182
views
Website down - MariaDB failed
I had a working website for 2 years, which suddenly stopped working. I haven't performed any updates or upgrades. When I woke up, I noticed that it was not functioning.
I contacted my hosting provider,...
- 1
0
votes
1
answer
501
views
Cannot upgrade MariaDB Connector/C on Parrot OS
Please note very new to ParrotOS + Python.
Error output when trying pip3 install mariadb :
MariaDB Connector/Python requires MariaDB Connector/C >= 3.3.1, found version 3.1.18
I cannot seem to ...
0
votes
0
answers
1k
views
mariadb service not found in centos 8
On a Centos 8 server I'm trying to install MariaDB and MySQL.
I have used this command
dnf install mariadb-server mariadb -y
mysql-community-server-5.7.40-1.el7.x86_64 was installed after that.
Now, ...
- 1
0
votes
1
answer
86
views
How can I get MariaDB to resume action?
I was working on my Wordpress site, and to get a non-database, HTML version suitable for my datamine, such as is running correctly at https://orthodoxchurchfathers.com and https://searchgkchesterton....
- 529
0
votes
1
answer
996
views
Setting custom MariaDB max_allowed_packet value in Debian 11?
Our Moodle server, running Debian 11 (bullseye), now seems to produce an "Error writing to database" message in the web browser when course admins try to manually backup some (larger) ...
- 451
0
votes
1
answer
841
views
how execute curl in mariadb/mysql stored procedure
I am using information from here and here.
I am running mariadb server on Debian 10. I download and copied the files to the server and execute the install.sh and I get the following error below.
&...
2
votes
0
answers
1k
views
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Cannot assign requested address)")
I have a streamlit app that requires connection to MariaDB. When I run docker-compose up I get this error:
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([...
- 21
0
votes
1
answer
2k
views
Selinux php-fpm httpd and mariadb socket connection
New note with important details
I just ran a few version tests and resulted in the following:
Alright, here’s my latest update:
10.5 works
10.6 doesn’t
10.7 works
10.8 work
etc.
I was hoping to use ...
- 292
1
vote
0
answers
602
views
Missing dependencies after migration to Debian 11
After update to Debian 11, I got this error message
apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -...
- 39
2
votes
1
answer
3k
views
How to do offline-installation of multiple images via podman load/save
I am using an app depending on the image docker.io/library/mariadb:10.7. Images can be pulled, and saved in a tarball:
podman pull \
docker.io/photoprism/photoprism:latest \
docker.io/library/...
- 31
1
vote
0
answers
124
views
raspberrypi - recover innodb data from 32 bit mariadb server to 64 bit server
After a system crash of my raspberrypi 3B+ (32 bit, OS buster) I could not recover madiadb (version: 10.3.31) data on localhost for several virtual hosts. I had to buy a new raspberrypi 4 with 64 bit ...
- 11
0
votes
1
answer
2k
views
LibreOffice Base ODBC connection to MariaDB fails: "Data source name not found"
Linux Mint 20 (Ubuntu 20).
MariaDB version:
"mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2"
I want to run LibreOffice Base as the front end, ...
- 1,226
0
votes
1
answer
166
views
why when I execute a select it works and when I execute an update the script blocks?
when I try to execute a query of type update the script hangs and the sql console stays still.
This command executes all queries in the script:
res=$(mysql --defaults-file=conf_file --skip-column-...
- 1
2
votes
2
answers
4k
views
MariaDB & Amazon Linux 2: ERROR: ld.so: object '/usr/lib64/libjemalloc.so.1' from LD_PRELOAD cannot be preloaded
Following AWS documents, I'm attempting to get a basic LAMP server up and running. Everything appears to be working fine. Logging into MySQL either through the terminal or phpMyAdmin (GUI) works.
...
0
votes
1
answer
311
views
Can't restart MariaDB after adding datadir line to my.cnf file
Having a issue getting MariaDB to restart after adding the following line to the [mysqld] section of my.cnf:
datadir = /home/mysql
It won't restart. Could this be a permissions issue. This is the ...
0
votes
1
answer
145
views
Free up mysql space on low-disk PC
I have a PC with a small disk:
Filesystem Size Used Avail Use% Mounted on
/dev/root 3.5G 3.1G 249M 93% /
devtmpfs 459M 0 459M 0% /dev
tmpfs 463M 0 463M 0% ...
- 1,341
-1
votes
1
answer
627
views
Can't get MariaDB to start..OpenSuse 15.2
I am logged in as root and below is what I see when I try to start the service. I have removed and reinstalled, I have also ran mysql_install_db. So far I haven't been able to resolve this issue.
...
2
votes
1
answer
760
views
Why can't install specified mariadb version with readline library?
My os info:
uname -a
Linux debian 5.10.0-9-amd64 #1 SMP Debian 5.10.70-1 (2021-09-30) x86_64 GNU/Linux
Locale setting:
locale
LANG=en_US.UTF-8
LANGUAGE=en_US:en
LC_CTYPE="en_US.UTF-8"
...
- 601
-1
votes
1
answer
201
views
mysql on artix linux gives the 'ERROR 2002 (HY000)'
I'm using artix linux with runit init system and I've stumbled upon this issue where I can't login into mariadb by using
sudo mysql -u root -p
because it gives me the following error:
ERROR 2002 (...
- 41
1
vote
0
answers
201
views
Dovecot - password query syntax error
Whenever Thunderbird attempts to connect to my server I receive an error in the maillog of
dovecot: auth-worker(32527): Error: sql(admin,xxx.xxx.xxx.xxx,): Password query failed: You have an error in ...
- 11
1
vote
1
answer
1k
views
start mysql/mariaDB service after datadir change
I installed the mariadb server and create a root user with a password
with
sudo apt install mariadb-server
sudo mysql_secure_installation
Since I use a Rasperri Pi I want to swap the DB to an ...
- 113
1
vote
1
answer
910
views
How to query mysql from cron script?
I have the following code in my script:
mapfile results < <(mysql --batch -u $DB_USERNAME -p$DB_PASSWORD $DB_DATABASE < query.sql)
and it works fine if running from command line. But if ...
- 3,485
-1
votes
1
answer
356
views
mariadb server not running after install amazon linux 2
My mariadb server is not running after I install it with yum install mariadb-server. after running this command, it displays:
mariadb-server-10.2.38-1.amzn2.0.1.x86_64 is obsoleted by mysql-community-...
- 21