Questions tagged [mariadb]
The mariadb tag has no usage guidance.
133
questions
0
votes
2answers
18 views
How to install MariaDB-Client on CentOS 8? It says 'unable to find a match'
Objective: Installing client only of MariaDB for command line testing of working connection webserver <> external server.
There are numerous tutorials to be found which describe MariaDB ...
1
vote
1answer
14 views
How do I install MariaDB to non-default root and data directories in Debian?
I'd like to install mariadb on Debian 10 with the --basedir=/usr/local/mariadb and --datadir=/data/mariadb. I've tried to add these options to the apt install mariadb-server command line but I get ...
1
vote
1answer
57 views
Unable to reset MariaDB root password
I am doing:
$ sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
then adding
skip-grant-tables
then
$ sudo service mysqld restart
then
$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor....
0
votes
0answers
29 views
How to start MariaDB properly on Debian 10?
I have a Digital Ocean VPS running Debian 10 for development purposes. For some unknown reasons, the existing MySQL was screwed up (couldn't connect to it). apt-get purge or autoremove didn't solve ...
0
votes
0answers
8 views
Rsyslog to limit backlogs on database?
I just connected my Rsyslog to a MariaDB database called Syslog. Is it possible to set rsyslog to automatically limit the data within the database to contain only 3-4 months worth of backlogs? Like ...
0
votes
1answer
20 views
my startup script does not start when I want to
So I am having a bash script in /etc/init.d/ containing this init info:
### BEGIN INIT INFO
# Provides: minio server
# Required-Start: $local_fs $remote_fs $mysql $all
# Required-Stop: ...
1
vote
0answers
34 views
MariaDB connector (remote)
I'm new to databases and have some very basic how-to/where-to questions:
I have successfully setup a MariaDB + phpmyadmin on my raspberrypi zero (running the latest diet-pi), including a database ...
3
votes
1answer
164 views
logrotate reports “my_print_defaults: unknown option '--mariadbd'”
My server is running Ubuntu 18.04.5 and I recently installed mariadb 10.5.5 from the MariaDB repositories (not from the Ubuntu repositories where that version is not available yet). Since then, I ...
0
votes
1answer
19 views
After reducing Mutt storage size, how do I get that storage reflected back into df
My goal is to get back the storage space in my opt directory.
I want to be able to see it growing in size so that regular maintenance checks mean I can down size it when space is needed.
Before I ...
0
votes
0answers
19 views
What is the use case for using the --extra-lsndir option of mariabackup?
I am modifying a script I found to create rotating weekly incremental backups using mariabackup. It passes this option to the backup command.
According to the docs the --extra-lsndir option creates ...
0
votes
1answer
2k views
Why I get “Access denied for user \'root\'@\'localhost\' (using password: NO)” after I added .env variables?
I'm using mariadb with nodejs on centos 8. Whenever I add process.env variables to my mysql.createConnection function I get error Access denied for user \'root\'@\'localhost\' (using password: NO) but ...
-1
votes
1answer
544 views
Error while installing mariadb-server on Kali Linux
I'm starting to set up my first DVWA on my Kali Linux machine. I tried to install mariadb-server using apt-get install mariadb-server as a root. I ran into error and I couldn't proceed.
Preparing to ...
0
votes
1answer
41 views
CentOS OpenLdap Apache PHP and MediaWiki
So I have been trying to setup a "Free" wiki that integrates with my "Free" version of Active Directory (aka. OpenLdap), so I can get a super simple setup together for a dev group, ...
0
votes
0answers
98 views
Mysql resource only starts when run by root user inside pacemaker cluster. Why?
I have a pacemaker/corosync cluster with a basic configuration, nothing relatively complex. (The mysql database is on a shared disk which is not important.)
The mysql primitive: (ocf_heartbeat_mysql)
...
0
votes
1answer
67 views
How to delete files using grep?
Here the result of this command :
sudo dpkg -l | grep mariadb
It returns me this :
ic mariadb-server-10.3 1:10.3.23+maria~bionic amd64 MariaDB ...
0
votes
1answer
146 views
ERROR 2002 (HY000) while trying to connect to MariaDB
I'm on Linux Mint 19 and use MariaDB as database server for my wordpress site in localhost.
I try to run MariaDB and when I check the status running
systemctl status mysql.service
I get this message:
...
0
votes
1answer
455 views
Mariadb on Raspbian: Can't connect to local MySQL server through socket
I'm setting up a "clean" image for my home Raspberry pi running the latest Raspbian, and I'm finding a small problem when installing the mariadb database.
So far, the steps I've taken are ...
1
vote
0answers
59 views
ARM version of MariaDB ODBC Connector
Is it possible to download a ARMv7 version of the MariaDB ODBC connector library (libmaodbc.so)? I started to build it from source but have got bogged down in compile issues. Its for a Raspberry Pi 3+ ...
0
votes
1answer
57 views
How to create an unprivileged sql database
I need to learn what sql is.
But am too scared of creating a database as root.
This is my current "progress":
$pacman -Syu mariadb # succeeds
$mysql_install_db --basedir=~/.sql/install --...
0
votes
0answers
16 views
How to show status of master slaves replication using Telegram
I would like to ask if anyone know how to use Telegram to show status when i am doing replication of Mariadb master slave. Whether the replication is successful or not, i want the status showed up on ...
4
votes
2answers
1k views
Failed to search for file: Failed to download gpg key for repo 'mariadb-main': Curl error (37)
I installed MariaDB on a computer with CentOS using the instructions given here:
MariaDB Package Repository Setup and Usage - MariaDB Knowledge Base
The basic command I used was:
sudo yum install ...
1
vote
1answer
34 views
Why is there a ROOT (as opposed to root) account for MySQL and MariaDB?
As far as I can tell, the MySQL and MariaDB database "ROOT" account is completely separate from the operating system's "root" account. Why did someone consider it a good idea to create the ambiguous ...
0
votes
1answer
63 views
Why does MySQL give me “ERROR 114 - Table Full”?
I have a MySQL database table with 31,107,600 rows in it.
It's using InnoDB.
This is on a CentOS 7 system.
The table has these columns:
id
timestamp
mac
data
direction
site_id
I want to create an ...
0
votes
0answers
14 views
Galera: Create & maintain a developer copy (clone) on a new server
We have a MariaDB 10.1 Galera cluster with 3 Ubuntu Linux 18.4 servers. All servers are virtual.
We want to have a developer/test copy of all data each day on another server. As the database is 1TB (~...
0
votes
2answers
165 views
mariadb server wont start, modular dependency problems?
I'm trying to create a maridb table on a rhel instance in my ec2 container, but everytime I try to start mariadb I get this:
Redirecting to /bin/systemctl start mariadb-server.service Failed to start ...
0
votes
1answer
188 views
Ubuntu MySQL Failing install with Apt-Get
I previously had MariaDB installed and I'm wanting to install MySQL 5.7 on my server. I purged all files with mariadb and mysql. Though when I install MySQL-Server-5.7 I get the following error. (When ...
1
vote
0answers
52 views
Debian (Buster) Nextcloud Error While Trying To Create Admin User - Access Denied
I am performing a manual installation of Nextcloud on my personal machine running Debian (Buster).
I've followed all of the steps of the instructions, up to the point where it wants me to complete ...
0
votes
0answers
701 views
Unable to start mariadb
I'm not able to start mariadb getting following error while starting db service.
root@server_name:~# systemctl status mariadb.service
ā mariadb.service - MariaDB 10.3.9 database server
Loaded: ...
0
votes
1answer
215 views
Ubuntu 18.04 mariadb access error
I'm on ubuntu 18.04, i have installed maria-db,
maria-db is running with the command:
sudo service mysql status
but when i write this command:
sudo mysql -u root -p
ERROR: i get this error:
...
1
vote
0answers
30 views
How I can detect whether the database layer is either mysql or mariadb using only netcat
Sometimes on docker entrypoint files I need to detect whether the database layer is either mysql or mariadb in order to provide the correct configuration for my application whilst I develop docker ...
0
votes
0answers
552 views
Accessing to Mariadb database with telnet from LAN
System is Debian 10 upgraded from Debian 9.
MariaDB version is mariadb Ver 15.1 Distrib 10.1.41-MariaDB
Server machine running telnet command responds like this
telnet localhost 3306
Trying ::1...
...
1
vote
2answers
329 views
Installing MariaDB 10.4 on Centos 7
I am experiencing some trouble with installing MariaDB 10.4 on Centos 7. The official mariaDB guide says that a new repo file MariaDB.repo should created in /etc/yum.repos.d/ with the contents of:
# ...
0
votes
2answers
192 views
Python to IPTables safest way of altering
Does anybody know what the safest way is to alter IPTables from Python?
For a schoolproject we're building a simple captive portal. When the user is authenticated (via python & mariadb) on the ...
2
votes
2answers
14k views
The following packages have unmet dependencies: mariadb-server
How can I get Mariadb running again?
My WordPress site is returning:
Error establishing a database connection
It seems that my database is down. (I updated Ubuntu 19.04 to 19.10 and have had ...
0
votes
1answer
147 views
Connect to a mariadb running on host from docker
I am trying to install nextcloud on a pi. So i installed the docker container, and i can access the first visit page. So i want to use mariadb as database backend.
Then i typed:
host: 192.168.178.62:...
1
vote
2answers
534 views
How to find a package name and version by its library name and version using a shell command?
Is there a command that could give me a package name and version for a library?
For example, I want to get mariadb-libs version for libmysqlclient_r.so.16 library that is currently not installed, but ...
1
vote
0answers
32 views
Running multiple mariaDB instances in a safe-to-update way?
On a certain server, multiple instances of 'mySQL/mariaDB' have to be ran.
Using mysql-multi or other methods, one can define multiple mySQL instances. Each runs on its own port.
As such, this ...
1
vote
1answer
2k views
sudo apt-get update errors: how do I clean up my MariaDB installation?
Linux Mint 18.3 (based on Ubuntu Xenial).
I have looked at the other questions here, but I still don't know where to start about cleaning up my package lists and specifically MariaDB. Any links to ...
0
votes
1answer
603 views
InstantWP Alpine Linux - repository tag for world dependency 'apk-tools@edge' does not exist
I am using InstantWP which installs a virtual server running Alpine Linux. InstantWP is for running a local version of Wordpress. It has MariaDB 10.1 installed, which isn't the latest version of ...
1
vote
0answers
76 views
How can I separate MariaDB's mysqld from MySQL 8's mysqld process to solve A mysqld process already exists error?
My goal is to have MariaDB 10.1 and MySQL 8 on the same Ubuntu 18.04 server.
I was able to setup MySQL 8 successfully, and got stuck almost at the end while setting up MariaDB following this guide:
...
0
votes
1answer
28 views
How can I purge a mysql setup
I installed mariadb-server-10.0 and php-mysql with the following.
sudo apt install mariadb-server-10.0 php-mysql
I setup with sudo mysql_secure_installation
I created a database for WordPress with
...
1
vote
1answer
416 views
MySQL&PHP - Aborted connection to db: (Got an error reading communication packets)
PHP version 5.6
I have a PHP program (running in CodeIgniter 'CI_VERSION', '2.1.3') looping through 100 items to process.
Apache (via Codeigniter) will give me 500 Error and no indication anywhere ...
0
votes
1answer
226 views
SElinux configuration of symlinked /etc/my.cnf -> /app/program/my.cnf
Please advise me of whether it is possible to configure SElinux context in a way that MariaDB would pick it up.
current configuration:
ls -lZ /etc/my.cnf
lrwxrwxrwx. root root system_u:object_r:...
1
vote
1answer
191 views
mariadb.service - linking unit aliases mysql.service & mysqld.service - (why) is it necessary
I cannot find the originally site I found how to set up MariaDB on linux.
Dependend on that tutorial I wrote an ansible playbook. While refactoring my playbooks I found those two tasks.
- name: ...
1
vote
1answer
2k views
Manjaro MySQL - mariadb.service fails when trying to start
When trying to start MariaDB with systemctl status mariadb, I get:
ā mariadb.service - MariaDB 10.3.15 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor ...
0
votes
0answers
39 views
Mariadb running out of memory
I have an old web server that's been running for some time, with regular updates. For the last month it's been crashing every few days. I tracked it down to:
$ dmesg
Out of memory in UB 136: OOM ...
0
votes
2answers
33 views
Why is MariaDB rejecting my SQL Backup?
I had to rebuild my Linode to Debian 9 since I couldn't get the sources from my previous question to work.
I used this setup guide to reconfigure and reinstall everything to the new Debian ...
1
vote
1answer
737 views
unixODBC: Cannot load libmaodbc.so
I'm working on an embedded platform and I am trying to access a MariaDB through unixODBC.
Trying to test the connection with isql I get the response:
isql -v mydsn myuser mypw
[01000][unixODBC][...
0
votes
1answer
2k views
Getting “ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value” Error using mariadb
While creating a haproxy_check user in MariaDB I am getting error ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value, what I need to do?
2
votes
0answers
423 views
How to enable Persian support in GNOME terminal?
I have Persian character in my MariaDB database, when I select data from tables and show in terminal, Persian is not supported and bad are displayed.