Install SepMySQL on CentOS/Fedora/RedHat with preinstalled Kloxo-MR

The initial state of the system:

  1. Kloxo MR installed
  2. Installed mysql 5.5 and mysqlclient16
  3. Disk space 2GB

Installation:

  • yum install wget sqlite -y
  • wget http://repo.bayrepo.net/bayrepo-common.repo -O /etc/yum.repos.d/bayrepo-common.repo
  • yum install sepmysql sepmysql-web sepmysql-balancer --enablerepo=bayrepo-test
  • add to /etc/yum.conf: exclude=mysql* mysql55*
  • service mysqld stop
  • chkconfig mysqld off
  • /opt/sepmysql/install/switch-to-mysql-wrapper
  • open port 4111 in iptables (for internal net or for external)
  • got to page: http://[IP address]:4111/sepmysql
    • choose menu item Login and enter admin: admin

  • on the new page choose menu item: MySQL→List and add such service and name it Native

  • Save new service and choose: Rules→Rules list and add chain and rule

  • service sepmysql restart
  • Mandatory - get a clue on the website http://sepmysql.bayrepo.net/ and add it to the menu: Configuration→Add license

Instuction how to use License Manager here

  • yum install patch
  • patch -p1 /usr/local/lxlabs/kloxo/httpdocs/htmllib/lib/pserver/driver/mysqldb__mysqllib.php /opt/sepmysql/scripts/panels/kloxo/kloxo-sepmysql.patch