No more custom packages in 11.36?

[vs-fam]

Hi,

We use Percona MySQL on our servers, however, in cPanel 11.36 update preferences, the option to select what package to update no longer is available, hence cPanel will replace/update everything with its packages.

Is that the case? No more custom packages?

 

[NixTree]

Try the following steps.

1. Run "touch /etc/mysqlupdisable" from SSH as root.

2. Enter "MYSQLUP=never" to /etc/cpupdate.conf

If you have cPanel 11.36.0.4 on your server, the above should work ( check for case 63298 in changelog CPanelVersion1136 < AllDocumentation/ChangeLog < TWiki )

 

[cPanelNick]

Replacing MySQL with Percona in 11.36 | cPanel Blog

 

[vs-fam]

Replacing MySQL with Percona in 11.36 | cPanel Blog

Those instructions don't work and shouldn't be followed. EasyApache breaks.

EDIT: Package Percona-Server-devel-55 is needed as well. The instructions does not mention it. That solves EasyApache issue.

 

[InterServed]

Those instructions don't work and shouldn't be followed. EasyApache breaks.

We followed those instructions and worked just fine (replacing MySQL with MariaDB). The only problem we had was actually a bug in MariaDB 5.5.29 that had to do with mysqli library. We fixed the problem by editing

/var/cpanel/easy/apache/rawopts/all_php5

and add

--with-mysqli=mysqlnd

, then easyapache worked flawlessly.

 

[vs-fam]

We followed those instructions and worked just fine (replacing MySQL with MariaDB). The only problem we had was actually a bug in MariaDB 5.5.29 that had to do with mysqli library. We fixed the problem by editing

/var/cpanel/easy/apache/rawopts/all_php5

and add

--with-mysqli=mysqlnd

, then easyapache worked flawlessly.

Well, that doesn't work for Percona.

 

[vs-fam]

Narrowing it down, EasyApache exits with: checking for mysql_config... not found

checking for mysql_config... not found
configure: error: Unable to find your mysql installation

EDIT: In order to have mysql_config, the devel package should be installed. The link provided by cpanelnick does not mention the devel package: Percona-Server-devel-55

It solves it and EasyApache works

 

[InterServed]

Narrowing it down, EasyApache exits with: checking for mysql_config... not found

checking for mysql_config... not found
configure: error: Unable to find your mysql installation

EDIT: In order to have mysql_config, the devel package should be installed. The link provided by cpanelnick does not mention the devel package: Percona-Server-devel-55

It solves it and EasyApache works

Indeed , that's the case , i forgot to mention it since i didn't think "further" that some people might not know that. I for one always install all packages , example of mariadb:

[email protected] [~]# rpm -qa|grep MariaDB
MariaDB-server-5.5.30-1.x86_64
MariaDB-shared-5.5.30-1.x86_64
MariaDB-devel-5.5.30-1.x86_64
MariaDB-common-5.5.30-1.x86_64
MariaDB-client-5.5.30-1.x86_64
MariaDB-compat-5.5.30-1.x86_64

Basically you need to look at what packages you uninstall and then keep in mind to install the same packages from your desired alternative such as Percona or MariaDB.

 

[cPanelKenneth]

Thank you for bringing the missing -devel package to our attention. I've asked for the article to be updated with that information.

 

[cPanelJesse]

I have updated the blog entry to include the Percona-Server-devel-55 package - in my testing it didn't appear to need this (or installed it automatically) previously.

Thanks for pointing this out!