Regarding to WHM Backup Restoration, there is something strange when I restore a backup for any account.
If there is an old backup includes (some files in File Manager, emails and there is no any databases)
Today, I created a new database and changed some files & emails.
When I try to...
Hello guys! All right with you?
I have a problem with my whm that I have hosted on Google Cloud. I am unable to enable user access on mysql. Only from WHM and with root user I can access phpMyAdmin.
When I migrated from the old server to this WHM that I host on Google Cloud, I used the...
Hi, I have an error and I cannot install a plugin and I get this error I know that it is not possible because of the mysql and I want to deactivate the mysql this is the error that skips me
1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
Just upgraded from PostgreSQL 9.6 to 10.3 on CloudLinux 6.9 but cPanel seems to only partially work with it.
In cPanel, all of the PostgreSQL links have gone.
But in WHM, its still visible such as the Configure PostgreSQL page and its listed in the Service Manager.
However, if I run Install...
Hi I'm configuring a CentOS 7 VPS with 4 vCore and 24gb of RAM, I installed cPanel and I'm using it to host 2 Wordpress sites. There are 2 small dbs, totally about 400MB.
The sites in production will have about 10k visits monthly, now the visits are low.
Mysqld uses high cpu, about 80-120%...
Hi this might be random and at the minute not causing no issues at all but i have noticed the databases on my servers are split into sections.
I think in my theory I'm correct but still not sure.
from what i can see the databases are in groups if there are more than 1 database per user...
I tried to upgrade MySQL 5.6 to MariaDB 10.3 last week within the cpanel upgrade tool withtout succes so I made it in terminal.
MariaDB upgrade was succesful but now I stuck with broken dependencies (I guess) blocking other uprade. Cpanel seems to still see MySQL 5.6 as the default db server...
I have an issue similar to this but I couldn't reply to that old topic anymore.
CSF/LFD reports something like this:
lfd on xxx: Excessive resource usage: xxx
Time: Sat Jul 6 16:02:00 2019
Resource: Process Time
Exceeded: 84921 > 1800 (seconds)
After upgrading Postgres from 9.2 to 9.4 and starting the new service 9.4 and confirming that the running version is 9.4, the Restarting PostgresSQL Server tool via WHM no longer works.
I think that because there's no symbolic between the service bin file and the new upgraded version...
I have a site on a WHM/CentOS dedicated server. This 144.x.x.x server has a client who has a remote database on a different server (37.x.x.x) and he needs to connect his script from the local server over to that 37.x server using a remote MySQL connection.
Up until now all he gets when we...
Upgrade to Latest VersionHy, everyone!
One of our servers is now having cPanel upgrades blocked because it assumes to be running on MySQL 5.5 for whatever reason:
[2019-07-01 21:18:16 -0300] W NOTE: A system upgrade was not possible due to the following blockers:
[2019-07-01 21:18:16 -0300] W...
Few days back my dedicated server has passed through a severe hard drive crash and my service provider unable to recover the data. They suggested me to go with a brand new server and create vps nodes there and migrate data one by one to the new vps nodes. (As bulk migration stops...
I am trying to connect my PHP project that is hosted on my CPanel website to the MySQL database that i have setup on CPanel's PHPMyAdmin however I can't. I think it is because i am using the incorrect username and password to access the CPanel database (The project was initially...
I am receiving email notifications after I rebooted my VPS about the MySQL not running. In WHM I can see the MySQL service marked as down. However, MySQL seems to running fine. When I run the command service mysql status I get SUCCESS! MariaDB running (5139)
When I run /scripts/restartsrv_mysql...
Doesn't seem like this question gets asked alot, but is there a way to completely remove CPANEL from WHM?
Is this, from 2011, still valid?
how to uninstall phpmyadmin included with cpanel installation
Delete (though i would just chmod it away) /usr/local/cpanel/base/3rdparty/phpMyAdmin
I'm having a new issue with PMA 4.8.3 (PHP 7.2.7), and I'm hoping someone can suggest a fix.
I have a rather large table (2.4G, about 10 million rows), and I regularly run queries on it to find specific data and then copy a row.
I run something like:
SELECT * FROM table WHERE colA = 'foo' AND...
Hi I am very new to cpanel and MySQL in general. Currently trying to upgrade MySQL version but it says that there will catastrophic data loss if i proceed. I'm wondering if i can create a new MySQLServer upgrade that to the latest version and then import the data from the old server?
i installing cpanel on centos 7.1 64 bit
after creating account i will giving error
my error is :
Account Creation Status: failed
Cpanel::Exception/(XID fq4zz2) The system failed to determine the “mysqld” version. at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 194...