php-mysql or php53-mysql on clustered nodes?

Follow

Ethan Hall

• January 13, 2012 21:17

Hello all,

I was running php-mysql or php53-mysql on several of my application stacked nodes prior to the cluster install.  It seems the Controller install removed the packages.  Attempts to reinstall fail with errors similar to the conflicts in "RPM dependency problems with php-mysql".  However, my cluster controller host did not have any issues with php-mysql during deployment.

Since these nodes are not controllers, is there a way to reinstall these packages without breaking Galera or cmon for these nodes?

Thanks and regards,

Ethan

0

• 

  Johan

  • January 14, 2012 06:31

  Hi Ethan,

  In the deploy.sh script the 'uninstall-rpm.sh' script gets called. Basically the uninstall does a rpm -e `rpm -qa |grep -i mysql`.

  On top of that when you run deploy.sh the MySQL-shared rpm is installed as well by default.

  Perhaps you can make the following modifications :

  1. ./uninstall-rpm.sh (will erase your current Galera setup)
  2. reinstall the rpms you need
  3. edit deploy.sh and cut out the 'uninstall-rpm-sh' part or answer 'N' on the question 'Do you want to remove existing RPMs?'
  4. edit install-rpm.sh  and remove  MySQL-shared-${version}-1.${rhel}.${arch}.rpm  from the list of RPMs that should be installed (should be on line 128)
  5. re-run deploy.sh

  I don't know if the installation will work then because of potential dependency problems, but perhaps it works for you.

  If the CMON fails to install you can do resolve the RPM deps and then:

  ##RPM
  bash ./install-cmon.sh -c ../../repo/cmon-controller-1.1.14-1.x86_64.rpm  -a ../../repo/cmon-agent-1.1.14-1.x86_64.rpm -w ../../repo/cmon-www-1.1.14-1.noarch.rpm -s 
  
  #tar.gz
  ./install-cmon -f ../../repo/cmon-1.1.14....tar.gz 

  Let me know if this helps you,

  
  

  0

  Comment actions Permalink
• 

  Ethan Hall

  • January 14, 2012 06:40

  Johan,

  Many thanks for the suggestions.  I'll work through these ideas and let you know how it goes...

  Cheers,

  Ethan

  0

  Comment actions Permalink
• 

  Ethan Hall

  • January 16, 2012 16:00

  Johan,

  After trying a few things and doing some more research, it appears the issue centered around Yum attempting to install the older package 'libmysqlclient.so.15' for 'php53-mysql.x86_64 0:5.3.3-1.el5_7.5'.

  I was able to resolve this by installing 'MySQL-shared-compat-5.5.19-1.rhel5.x86_64.rpm'.  This allowed the install of php53-mysql without conflict.

  Cheers,

  Ethan

  0

  Comment actions Permalink
• 

  Johan

  • January 16, 2012 19:53

  Ethan,

  That is excellent news!

  Thank you,

  Johan

  0

  Comment actions Permalink

Please sign in to leave a comment.