All Questions
267
questions
0
votes
0
answers
61
views
Fatal error: Uncaught Error: Call to undefined function mysqli_connect() on Debian 12.5 with Apache2
I am trying to run my server with php 8.2 but it can't connect to my MariaDB database with mysqli.
I have extension=mysqli in my php.ini
When I do php -m | grep mysqli I get this:
% php -m | grep ...
- 1
1
vote
0
answers
173
views
Upgrading mysql - can not start server 8.0.35 => 8.0.36
After upgrading mysql the server can not start?
Upgrade
apt update && apt upgrade
8.0.35 => 8.0.36
OS: Debian bookworm
error
Tablespace 123588, name 'sys/sys_config', file './sys/...
- 2,055
1
vote
2
answers
381
views
Forward default mySQL port to a different port for outgoing traffic to a specific IP or Domain
We're using a hosted mySQL Database server which generates a port other than the default 3306, which we have no control over.
We'd like to not have to make changes to our existing connection scripts ...
- 11
0
votes
1
answer
801
views
MariaDB 11.0.2 fails to start after upgrade from 10.11.4
I am on Debian Bullseye and just upgraded (or at least attempted to upgrade) MariaDB from 10.11.4 to 11.0.2.
Unfortunately, the service fails to start now. All I'm getting through systemctl status ...
- 51
0
votes
1
answer
143
views
Mariadb creates a subprocess after crash
We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so :
mysql 26718 5.1 42.4 15062644 ...
- 343
0
votes
1
answer
3k
views
MySql: ERROR 1045 (28000): Access denied for user 'root'@'localhost' although password is okay
I run Debian 11 with mariadb and everything worked fine. Just yesterday I saw that different commands, such as "/etc/init.d/mariadb reload" or "mysql -u root" bring the error:
...
- 111
0
votes
1
answer
611
views
Automysqlbackup does not use the configured password
I have automysqlbackup installed on debian. I added USERNAME and PASSWORD to /etc/default/automysqlbackup, but when automysqlbackup runs, I get the output:
/etc/cron.daily/automysqlbackup:
ERROR 1045 (...
- 1,733
0
votes
1
answer
74
views
How to start myslq if it fails to start due to insufficient space, and the main files eating up space are mysql binary log files
My server disk usage looks like this:
Filesystem Size Used Avail Use% Mounted on
udev 989M 0 989M 0% /dev
tmpfs 200M 21M 180M 11% /run
/dev/xda1 59G 57G ...
- 1
0
votes
0
answers
1k
views
debian 11 + mariadb remote connections
I'm having trouble getting mariadb to accept remote connections on Debian 11 on a fresh installation.
I've changed bind address to bind-address: 0.0.0.0. From the same server, I can telnet into port ...
- 249
0
votes
0
answers
139
views
Connecting postfix to mysql with ssl
I've been trying to get the correct recipe of settings to allow postfix to connect to mysql where ssl is required. So far I have the following config that is not working:
user = mysqluser
password = ...
- 249
1
vote
1
answer
80
views
Jaguards database configured incorrectly
After following the steps given in the README of the open source tool provided by Jaguards, I always get the "Database configured incorrectly" warning icon, and can't manage to login with ...
- 21
1
vote
0
answers
132
views
cannot start mysql using --login-path on ubuntu
On a ubuntu-18.04 system on which mysql 5.7 was installed from a package, I can start mysql (the cmd line tool, not mysqld) using the following:
ls -l /etc/mysql/debian.cnf
-rw------- 1 root root 317 ...
- 137
1
vote
0
answers
158
views
How to restore/setup debian-sys-maint user and scripts for mysql 5.7
I recently installed mysql 5.7 on ubuntu-20.04, but the debian-sys-maint user and config appears to be missing. Can anyone explain how to restore it or set it up? It's my understanding that user is ...
- 137
0
votes
3
answers
2k
views
Performance improvement for Innodb - High CPU
I have a dotnet application that has a high-traffic connection to the MySQL database. It's an application that stores IoT data. It connects to the database approximately 50 times per second. In these ...
- 113
1
vote
0
answers
395
views
MariaDB 10.8.x Strict Mode always ON?
I'm installing MariaDB on a new Debian 11 server and transferring my projects but I have a problem.
STRICT MODE is always ENABLED on MariaDB.
I check many sites, and try to add the string sql_mode=...
0
votes
1
answer
215
views
install mysql in debian 9
I need to install MySQL 7.5 on Debian 9 stretch, I tried to download it using PPA but when I try to update and complete download I get error apt-key expire.
Err:2 http://repo.mysql.com/apt/debian ...
- 101
1
vote
1
answer
2k
views
How do i download MySql On Debian Based?
I wanna make a db and i need mysql for that.
I was trying to do this command:
sudo apt install mysql-server and i got this:
Reading package lists... Done
Building dependency tree... Done
Reading state ...
- 13
0
votes
0
answers
365
views
(FREERADIUS&MYSQL) Getting aborted connections to my db (got an error reading communication packets)
https://i.sstatic.net/qUI2n.png
Running Debian 11, 1 week trying to figure out where this issue comes from, tried authentication method (made a fresh install of mariadb, setting unix socket so radius ...
- 1
0
votes
1
answer
93
views
How can I fix the keyboard shortcuts in the MariaDB/MySQL shell?
I upgraded from Debian 10 to 11, and from MariaDB 10.3 to 10.7, and keyboard shortcuts were broken, due to a switch from GNU readline to the editline library. I was used to using vi mode, but it is ...
- 171
1
vote
1
answer
2k
views
Failed to get properties: Unit name [email protected] is missing the instance name
I've recently upgraded my MariaDB servers from 10.1 to 10.6 and now when I restart services for example wildfly, I get this message :
sudo service wildfly restart
Failed to get properties: Unit name ...
- 343
0
votes
1
answer
137
views
Run mysql in terminal without argument giving socket error
When I type in mysql into terminal I got the following error:
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
But if run mysql with some arguments like ...
0
votes
1
answer
638
views
How to allow an ip address to access a specific port on the server without blocking other traffic
First off, am using Firewalld and my configuration is as follows:
All traffic is allowed (nothin fancy).
Server has MySQL and Apache2 (Linux Debian)
I need to allow MySQL remote connections to a ...
- 121
0
votes
1
answer
846
views
Postfix doesn't send mail
I am trying to learn about mail servers and am quite daunted by all of the moving pieces in the setup..
Currently I am unable to send via from my smtp server. I can receive mails fine from various ...
1
vote
1
answer
3k
views
Is it possible to install MySQL5.7 on Debian 10/buster?
I have tried two times and it always fails. According to this little guy debian stopped packaging mysql-client as of buster. I tried to cope with it by installing MariaDB but I struggle to find a ...
0
votes
1
answer
514
views
Can no longer install mysql 8 on a fresh Debian server (Package mysql-community-server is not configured yet.)
I was able to install mysql server 8 until a couple of weeks ago on a fresh Debian Buster installation.
sudo apt update
export DEBIAN_FRONTEND=noninteractive
sudo apt full-upgrade -y
sudo apt ...
- 1,675
2
votes
1
answer
2k
views
How to install Mysql 8.0 unattended?
I have a bash installation script that automatically installs mysql without any prompts.
wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.16-1_all....
- 1,675
-1
votes
1
answer
144
views
Local MySQL connection blocked on port 10050
I have two servers both on local IPs and for some reason MySQL can't connect.
Source server: mysql -u user_name -h 192.168.130.231 -p
On the MySQL server I get a UFW block on port 10050 but am not ...
- 149
2
votes
1
answer
5k
views
How to install mysql 8.0 client on Debian Buster?
This is how I would install a central Mysql 8.0 database on Debian 10.
MYSQL_8_file="mysql-apt-config_0.8.16-1_all.deb"
apt install gnupg -y
wget -c https://dev.mysql.com/get/${MYSQL_8_file}
...
- 1,675
0
votes
2
answers
3k
views
How to install mysql workbench on linux debian 10 (Google Pixelbook) [closed]
I first asked this question on StackOverflow but someone told me there that I have a better chance of getting an answer here
I am trying to install MySQL Workbench on my Google Pixelbook. It runs ...
0
votes
1
answer
386
views
Can't restore master/slave replication from Percona backup (slave server)
A slave is restored from a master backup created with Percona xtrabackup
On the master binlog is set to expire in 14 days and this backup is less than 24 hours old
my.cnf (master)
expire_logs_days = ...
- 2,055
0
votes
2
answers
6k
views
Galera + MariaDB: Deadlock: wsrep aborted transaction
I have 1 server configured the galera, 4 servers with mariadb and 1 with haproxy.
But when I want to do an update on any server I get the error "Deadlock: wsrep aborted transaction" or "...
1
vote
3
answers
2k
views
Mysql filling all the buff/cache memory
The more time the server run, the more buff/cache Mysql processes use, i'm at 95% right now and only a server reboot free the buff/cache memory. None of the mysql commands free it on the go.
Is it a ...
- 123
1
vote
1
answer
2k
views
Multiple long running mysqld processes
today i've checked our server status with htop and i saw somethig that i could not believe.
Could someone please answer me the following questions?
Why are there so much mysqld processes?
Why they ...
- 13
0
votes
1
answer
138
views
Is there "another" way of getting log information on SFTP activity?
I'm administrating a debian server since last week. It used to have another administrator.
I presume it's been hacked: files might have been read via SFTP to obtain information about a site that's ...
- 101
0
votes
1
answer
1k
views
Unable to start mysql server on linux Debian 9
I have tried a hundred of commands to fix this but to no avail.
I get this error when I try to run mysql service:
root@lander:/# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.45 ...
- 101
1
vote
0
answers
6k
views
Unable to load dynamic library 'mysqli' - Debian 10
I'm setting up a webserver, using Debian 10, Apache2, PHP7.3, MariaDB and PHPMyAdmin.
When i start Apache2 it wil say:
PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/...
- 11
1
vote
0
answers
3k
views
mysqldump: Couldn't execute 'show create table `xxx.yyy`': Table 'yyy' doesn't exist in engine (1932)
I had to redo my server (Debian 9) in Proxmox. I updated a package (libc6) and I broke the dependencies (I didn't snapshot it...). One of the affected daemons was MySQL / MariaDB, I could not make a ...
- 119
0
votes
0
answers
262
views
MariaDB 10.3.22 for RPI started with innodb_force_recovery = 5: mysqldump fails, claims "[mysqld]" is not in configuration but it's actually present
I am running MariaDB 10.3.22 on a Raspberry Pi 3 with Raspbian Buster, using the InnoDB engine. Due to a power outage on my RPI, a table on my innodb_system tablespace corrupted. I eventually managed ...
- 151
0
votes
1
answer
1k
views
Exported MariaDB dump different size
I'm trying to copy a database from a MariaDB server on another. I made a dump of the database on server A with :
sudo mysqldump -u root -p --databases database1 > /var/tmp/database1.sql
I created ...
- 343
0
votes
1
answer
3k
views
Freeradius 3.0.12 doesn't send any data through mysql
After upgrading from v 2.x, freeradius stopped working for me.
I have done multiple tshooting steps which led me to believe that the application is not sending any data through MySQL, even though it ...
- 1
0
votes
0
answers
234
views
MySQL refusing connection
Since a few days my MySQL-Server is refusing the connection after a few hours. When trying to connect I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/...
- 145
0
votes
3
answers
6k
views
Error during installation MySQL 8.0 on Debian 10
I am trying to install MySQL on Debian 10, I'm doing everything according to instuction but I get error shown below. Can somebody help me solve this probem ?
matt@debian:~$ sudo apt install mysql-...
- 1
1
vote
0
answers
804
views
MySQL: connection lost after 5 minutes
I'm using web app (AppSheet.com) to connect to my MySQL database and export data from this app to my mysql.
I don't have ability to edit the app (connection, queries etc.), but I have full root access ...
- 1,491
0
votes
4
answers
21k
views
MariaDB won't start after fresh install. No errors, no logs
I just installed MariaDB from the debian repo and I can't start it.
root@Debian9A1:~$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/var/run/mysqld/mysqld.sock' (2)
I ...
- 51
1
vote
1
answer
147
views
Linux VPS getting ERROR 2002 when attempting to connect to MySQL service
I am trying to set up SQL on my VPS which is running Kali (Debian) When I run any of the commands I am getting these errors below:
root@kali:~# sudo service mysql restart
Failed to restart mysql....
- 191
-2
votes
2
answers
1k
views
Access denied for user 'root'@'localhost' What proces is causing this?
I got this connections constantly in logs, how to trace what app is trying to connect?
root@localhost is allowed to connect
190310 22:38:57 [Warning] Access denied for user 'root'@'localhost' (...
- 27
0
votes
0
answers
62
views
Monitor long ongoing mysql queries
is there any plugin or possibility to check with nagios MySQL query, which is running longer than for example 1hour? So I get alerted and can manage it?
I use this code, but I am not sure how to ...
- 207
-1
votes
2
answers
640
views
Increasing the number of connections MySQL 8 can handle (Debian 9 server) and auto restart event scheduler
I have a Debian 9 server (12 CPUs, 80GB of RAM), running Percona server for MySQL 8.0, about 1100 clients per second, the load is not very high around 0.3 to 2.30
Latested numbers from show engine ...
11
votes
2
answers
15k
views
MySQL Repository Key Expired
The MySQL repository key has suddenly expired again, so I get a GPG error in Ubuntu when running apt-get update
The error is W: GPG error: http://repo.mysql.com/apt/ubuntu xenial InRelease: The ...
- 3,596
6
votes
2
answers
21k
views
Enabling mysql on boot error (Refusing to operate on linked unit file mysql.service)
I'm following instructions on vultr to install LAMP stack on VPS (https://www.vultr.com/docs/how-to-install-apache-mysql-and-php-on-ubuntu-16-04). When trying to enable mysql on boot I'm getting an ...
- 61