mysql

Hi, i've this version plesk 17.5.3 patch #26 installed on a centos 7.4.1708 and this morning i've realized that mariadb service is down because of this : Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown... Oct 24 11:01:51...

Hi, this is my first post on this forum. I have searched related info on How to upgrade client MySQL from 5.1 to 5.6 on Windows It says I can use "plesk installer" to finish this upgrade. Now I have three mysql databases(version 5.1) linked with three websites. I want to know the following...

So I have this error: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found and I am aware of the suggestions / solutions provided here: Unable to access Application Vault: Can't open lib '/usr/lib64/libmyodbc5.so' : file not found but still I am not getting it...

Hi, anyone know how to solve this? I'm missing a few MySQL users after using the Plesk Migration tool to migrate from an old server to a new server. Both using Plesk. I see all the databases migrated to new server, but not all the users. Thanks!

Trying to open port 3306 for MYSQL remote access. Similar to this: Resolved - Cannot connect to database remote but on our server the firewall is not running. Centos 7 systemctl status firewalld ? firewalld.service - firewalld - dynamic firewall daemon Loaded: loaded...

Hello, I want to run a Magento site. Magento needs a later MYSQL than what is installed on my AWS Ubuntu 14.04 server. I tried the answer here: Question - MySQL Upgrade 5.1 to 5.6 or 5.7? but it removes plesk, and all such programs :O. I need to upgrade MYSQL-core. Tutorials say to do a dump...

Hello, good day, sorry but I'm a bit newbie here, after trying to update mysql (on ubuntu 14.04.5 LTS) using as reference the documentation of you on this page Cómo actualizar MySQL 5.5 a 5.6/5.7 en Linux I get some issues related to broken dependencies, the terminal showed that tried to...

Hello Developers and Community, I can unfortunately the forum tool CBACK from Germany not with MariaDB 5.5 operate. Therefore I wanted to upgrade to MariaDB 10.x. MariaDB 10.x I have now installed by command line, but it can not upgrade to Plesk. How can I get all MySQL databases on MariaDB...

In Plesk Onyx is it possible to edit php.ini and Mysql through the admin interface?

I want to set a Cron job to optimise all my databases, so i tried running this command from a Scheduled Task: mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --optimize --verbose --all-databases But it always throws an error: Task "mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow`...

Hi I'm new to this forum. Just turned from cPanel to Plesk and I'm loving it. Anyway, I managed to Install Onyx on CentOS7 with no problem and the forum really helped. I was trying to secure my installation so I did not know Plesk changed root to admin so I updated admin user's password and my...

OS: Ubuntu 14.04.5 LTS Product: Plesk Onyx 17.5.3 Update #14 , last updated at July 23, 2017 08:33 PM I managed to get Health Monitoring installed on Plesk. Noticed MySQL memory usage is very high. How can I determine what is causing this? I limited memory usage on each domain but still see the...

Plesk version: Plesk Onyx 17.0.17 Update #29 Is it possible to limit and monitor resources for individual domains? Noticed some domains are using more resources than other domains and causes my server resources to be depleted. I want to limit each individual domain if possible? Does Plesk have...

Hello Community and Pleskians! I have an upgrade problem from Plesk Onyx to the new version 17.5.3. It is on the psa-php5-configruator and related to php-mysql. When upgrading from Plesk I have these lines that are displayed. Installation started in background Loaded plugins: fastestmirror...

Hi, I want to add a custom action to all jails, this action calls a script that writes the ban info to mysql. When i run my script directly from the console, it works fine. But it does not get called with the actionban... First some info: Plesk 17.5.3 CentOS 7 Fail2Ban v0.9.6 MariaDB 5.5.52...

Hi guys, by connecting plesk i got this error, where should I start my search? ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0...

Hi all, I tried to run "mysql_secure_installation" command on my server where Onyx is running but I always get login error because the Onyx default db user is admin and not root: I also tried to run: "mysql_secure_installation -uadmin" but with no success. Can anyone help me on this and tell...

Hello, I was creating users in MySQL server, as i dont know the "admin" password i tried update the password. Onces I updated i got this error message: I was performing some of the KB solutions but could not be able to fix it, i create a ticket because maybe you have faced this situation...

Hi, I can't find here on forum similar question. I need to have open port 3306 for all IPs. Is it possible somehow to protect mysql authentification with Fail2Ban? I found that enabling general log can slow server, but also I saw that is possible to enable only "log_warnings = 2", Is someone...

Hi, two days ago I made a terrible mistake by removing some packages with dependencies to Plesk. So I had to restore from a backup. But unfortunately this fails and MySql wont start. So Plesk isn't staring as well. My service is hosted by STRATO and the guys told me that when I'm using their...