Site Tools


Hotfix release available: 2025-05-14b "Librarian". upgrade now! [56.2] (what's this?)
Hotfix release available: 2025-05-14a "Librarian". upgrade now! [56.1] (what's this?)
New release available: 2025-05-14 "Librarian". upgrade now! [56] (what's this?)
Hotfix release available: 2024-02-06b "Kaos". upgrade now! [55.2] (what's this?)
Hotfix release available: 2024-02-06a "Kaos". upgrade now! [55.1] (what's this?)
New release available: 2024-02-06 "Kaos". upgrade now! [55] (what's this?)
Hotfix release available: 2023-04-04b "Jack Jackrum". upgrade now! [54.2] (what's this?)
Hotfix release available: 2023-04-04a "Jack Jackrum". upgrade now! [54.1] (what's this?)
New release available: 2023-04-04 "Jack Jackrum". upgrade now! [54] (what's this?)
Hotfix release available: 2022-07-31b "Igor". upgrade now! [53.1] (what's this?)
Hotfix release available: 2022-07-31a "Igor". upgrade now! [53] (what's this?)
New release available: 2022-07-31 "Igor". upgrade now! [52.2] (what's this?)
New release candidate 2 available: rc2022-06-26 "Igor". upgrade now! [52.1] (what's this?)
New release candidate available: 2022-06-26 "Igor". upgrade now! [52] (what's this?)
Hotfix release available: 2020-07-29a "Hogfather". upgrade now! [51.4] (what's this?)
New release available: 2020-07-29 "Hogfather". upgrade now! [51.3] (what's this?)
New release candidate 3 available: 2020-06-09 "Hogfather". upgrade now! [51.2] (what's this?)
New release candidate 2 available: 2020-06-01 "Hogfather". upgrade now! [51.1] (what's this?)
New release candidate available: 2020-06-01 "Hogfather". upgrade now! [51] (what's this?)
Hotfix release available: 2018-04-22c "Greebo". upgrade now! [50.3] (what's this?)
Hotfix release available: 2018-04-22b "Greebo". upgrade now! [50.2] (what's this?)
setup_db_server

Download and Install MySQL database on database server

USE VERSION 5.5, Download locations for MySQL 5.5

wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-shared-compat-5.5.13-1.rhel5.x86_64.rpm
wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-client-5.5.13-1.rhel5.x86_64.rpm
wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-server-5.5.13-1.rhel5.x86_64.rpm
wget http://downloads.mysql.com/archives/mysql-5.5/MySQL-devel-5.5.13-1.rhel5.x86_64.rpm

rpm -ivvh MySQL-shared-compat-5.5.13-1.rhel5.x86_64.rpm
rpm -ivvh MySQL-devel-5.5.13-1.rhel5.x86_64.rpm
rpm -ivvh MySQL-client-5.5.13-1.rhel5.x86_64.rpm
rpm -ivvh MySQL-server-5.5.13-1.rhel5.x86_64.rpm

Note: Run the ln command below (on app servers), else deploy:cold (initial deploy task) will fail to install mysql gem

ln -s /usr/lib64/mysql/libmysqlclient.a /usr/lib64/libmysqlclient.a
/usr/bin/mysqladmin -u root password newpasswd

Run the below as mysql root to create required database, user and privileges, adjust values as required:

create database cb_production DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
grant all on cb_production.* to produser@'localhost' identified by 'prodpswd';
grant all on cb_production.* to produser@'websrvr_IP_or_NAME' identified by 'prodpswd';
setup_db_server.txt · Last modified: 2018/08/31 16:16 (external edit)