Error on MySQL Governor install

[gtongco]

Hi,

I tried to install the MySQL Governor via the following:

# yum --enablerepo=cloudlinux-updates-testing --disablerepo=cloudlinux-base --disablerepo=cloudlinux-updates install mysql-server mysql

It generated an error:

Loaded plugins: fastestmirror, rhnplugin
Loading mirror speeds from cached hostfile
Excluding Packages in global exclude list
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MySQL-server.x86_64 0:5.1.48-1.el5.cloudlinux set to be updated
--> Processing Dependency: perl(DBI) for package: MySQL-server
--> Finished Dependency Resolution
MySQL-server-5.1.48-1.el5.cloudlinux.x86_64 from cloudlinux-updates-testing has depsolving problems
--> Missing Dependency: perl(DBI) is needed by package MySQL-server-5.1.48-1.el5.cloudlinux.x86_64 (cloudlinux-updates-testing)
Error: Missing Dependency: perl(DBI) is needed by package MySQL-server-5.1.48-1.el5.cloudlinux.x86_64 (cloudlinux-updates-testing)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

How do I resolve this?

And incidentally, the CPanel is set to use MySQL 5.0x. Can the yum install use MySQL 5.0x instead? Would there be any problems (from my CPanel users standpoint) if the yum install installs MySQL 5.1x?

Thanks.

[iseletsk]

If you are using cPanel, try using this script for the install:
# wget http://repo.cloudlinux.com/cloudlinu...ll-db-governor
# sh install-db-governor

More info here: http://www.cloudlinux.com/docs/mysqlgovernor.php

[gtongco]

Does the CPanel script also install MySQL 5.1x? My CPanel servers run MySQL 5.0x. Does the script upgrade the databases, too?

[iseletsk]

It automatically detects the version of MySQL you are running, and installs the right one.

[gtongco]

great! thanks!

giving it a go later.

[gtongco]

the install script has these lines:

function checkMySQL(){
res=$(rpm -qa cpanel-MySQL-server | grep cpanel-MySQL-server-$1-1.el5_5)
echo "$res"
}

but the repo has -2.el5_5.

this should be fixed. i had to scratch my head several times wondering why dbgovernor won install. it doesn because the mysql check fails.

[iseletsk]

sorry about that... fixing it now.

[iseletsk]

Fixed:
rm -f install-db-governor
wget http://repo.cloudlinux.com/cloudlinu...ll-db-governor
sh install-db-governor

[gtongco]

is it okay to install v3 on cpanel (via yum) on top of v2 installed via script?

[gtongco]

i proceeded to install anyway as you haven replied.

the yum process completed well but when i run the perl command, i get this:

...skipping 206.217.198.61......server closed connection......connecting to 206.217.198.61...@206.217.198.61......connected......receiving...Error 404 while fetching URL [URL]http://repo.cloudlinux.com//cloudlinux/sources/cpanel/CURRENT/cPpkgversion[/URL]

...skipping 206.217.198.61......server closed connection......Done

Can	 call method "haspkg" on an undefined value at /usr/share/lve/db_governor/utils/install-db-governor line 59.

how do i fix this?

[gtongco]

the folder CURRENT does not exist in the repo. only RELEASE is available.

thats why the script is getting a 404 error.

how do i fix this?

[alexey.com.s]

Thank you! I have created CURRENT folder, and it should be working now. Could you check?

[gtongco]

it went on without a hitch this time!

thank you for your usual fast action!

[accounts]

Is anyone running this on a production server yet? If so is it working OK?

[iseletsk]

We have at least 10 people running it in production right now. Probably more. I think we will go in RC in ~2 weeks, and then release it a month later.
All the bugs for the past few versions were related to the data display/collection, and didn cause any MySQL service interruption.