Recent content by PeterK900

Here is the response from the support team at the hosting company, detailing what they did. 1. Inside Plesk, navigate to > Tools & Settings > Database Servers > Settings > Local MariaDB/MySQL Settings and make sure "Allow local MariaDB/MySQL external..." is checked 2. SSH into the server and...

Thanks for your continued guidance on this. I'll post again if I find out any more about what solved the problem,

The hosting company responded as follows "I've made some changes and made sure the port is allowed in the server's firewall too in order to accept external connections." After this ODBC connectivity works! Interestingly I found this article Resolved - 3306 port is not accessible - how to fix...

Thanks for clarifying the Web Application Firewall setting. I'll raise this issue with the hosting company and post back when I know more. Thanks again.

I mean to add that Web application firewall mode is set to OFF.

Thanks for clarifying my confusing terminology. And for your wide range of command line tests. In the end I opted for sudo ss -tulpn | grep LISTEN run on the host where ODBC connectivity fails. This command shows... tcp6 0 0 0.0.0.0:3306 :::*...

Thanks for your help. Running the Powershell comand you cite gives me the same result. But when I repeat the command but with the ip address of a web server where ODBC connectivity works, the test connection works. So, my understanding is that port closure/firewall problem you write about...

Testing the ODBC connection produces the message "Cannot connect to server". Error log [Sun Jul 06 06:09:16.438625 2025] [authz_core:error] [pid 3245906:tid 3245958] [client 34.162.213.107:0] AH01630: client denied by server configuration: /var/www/vhosts/xxxx.com/httpdocs/.git The database I'm...

I've managed to complete the update with OS Ubuntu 20.x rather than AlmaLinux8. Here are two articles that helped... How to Upgrade MariaDB Server to a Newer Version in Ubuntu https://community.hetzner.com/tutorials/how-to-install-mariadb-10-6-on-ubuntu-20-04 I started with the first article...

Thanks Maarten for the point about login credentials. And also about Plesk support. I'll check both these out.

Thanks Bitpalast. The outputs for journalctl -xe and /var/log/messages are shown below. /var/log/syslog produces no output. I'm afraid the output gives me no clues as to the problem or how to solve it. Plesk support is a paid for option and may not be possible as my Plesk licence is in the name...

[peterkaye@128 etc]$ journalctl -xe -u mariadb Hint: You are currently not seeing messages from other users and the system. Users in groups 'adm', 'systemd-journal', 'wheel' can see all messages. Pass -q to turn off this notice. -- Logs begin at Fri 2024-10-04 11:13:25 UTC, end at...

Thanks. Is this what you want? [peterkaye@128 mysql]$ sudo systemctl start mysqld Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

Thanks Bitpalast. You were spot on - it includes an error message! Here's the content of my.cnf... # This group is read both both by the client and the server # use it for options that affect everything # [client-server] # # include all files from the config directory # !includedir...

I have completed the install of MariadB 10.6 , server, client, common and shared without any error messages. [see below]. However when I try and start MariaDB sudo systemctl start mariadb , I get this error message... . Job for mariadb.service failed because the control process exited with...