Phpmyadmin - CORE MANAGED

From Cheatsheet
Revision as of 08:19, 11 September 2010 by Admin (talk | contribs)
Jump to navigation Jump to search

How to install PHPMYADMIN on COREMANAGED box, also switching to php 5.2.13

First download the phpmyadmin

cd /var/www/html/
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.3.7/phpMyAdmin-3.3.7-all-languages.tar.gz?r=http%3A%2F%2Fwww.phpmyadmin.net%2Fhome_page%2Fdownloads.php&ts=1284192929&use_mirror=cdnetworks-us-1
tar -zxvf phpMyAdmin-3.3.7-all-languages.tar.gz
rm -rf phpMyAdmin-3.3.7-all-languages.tar.gz
mv phpMyAdmin-3.3.7-all-languages phpmyadmin

Visit servers main ip/phpMyAdmin to see if the install needs further components.
If this does not resolve you will have to check with the customer and have them configure their apache server, unless the wish to provide explicit instructions as to how the would like their server setup.

If you need to install apache please go to the following wiki: Coremanaged HTTPD

Install rpmforge repo for yum installation based on the OS architecture.

 uname -a

From this command get the system bit.

32bit OS
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.i386.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.i386.rpm

64bit OS
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm

Add the development repositories

First thing we need to do is add the development repositories to yum. When we add the development repository we're going to configure it so it only pulls PHP packages. To start we'll need create a new yum repository configuration file (use your favorite editor):

 # /etc/yum.repos.d/CentOS-Testing.repo

Copy/paste the following into this file:

# CentOS-Testing:
# !!!! CAUTION !!!!
# This repository is a proving grounds for packages on their way to CentOSPlus and CentOS Extras.
# They may or may not replace core CentOS packages, and are not guaranteed to function properly.
# These packages build and install, but are waiting for feedback from testers as to
# functionality and stability. Packages in this repository will come and go during the
# development period, so it should not be left enabled or used on production systems without due
# consideration.
[c5-testing]
name=CentOS-5 Testing
baseurl=http://dev.centos.org/centos/$releasever/testing/$basearch/
enabled=1
gpgcheck=1
gpgkey=http://dev.centos.org/centos/RPM-GPG-KEY-CentOS-testing
includepkgs=php*
      • Make sure to remove any spaces at the start of each line, then save and close the file and you're done.***


Now install mysql

yum install mysql
yum install mysql-server-5.0.77-4.el5_5.3.x86_64

Now onto customizing php to work with our installation. Download the files.

wget 'http://www.atoomnet.net/./php/php-5.2.13/php-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-cli-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-common-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-devel-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mbstring-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mcrypt-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mysql-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-pdo-5.2.13-1.x86_64.rpm'

now onto installing them

yum install libmcrypt-2.5.8-4.el5.centos.x86_64

After installing this dependency, install the rest.

rpm -ivh php-common-5.2.13-1.x86_64.rpm
rpm -ivh php-cli-5.2.13-1.x86_64.rpm
rpm -ivh php-5.2.13-1.x86_64.rpm
rpm -ivh php-pdo-5.2.13-1.x86_64.rpm
rpm -ivh php-mysql-5.2.13-1.x86_64.rpm
rpm -ivh php-mbstring-5.2.13-1.x86_64.rpm
rpm -ivh php-devel-5.2.13-1.x86_64.rpm
rpm -ivh php-mcrypt-5.2.13-1.x86_64.rpm

Run to set the phpmyadmin password

mysqladmin -u root password 'PASSWORD'

To enable the cookies do the following.

cd /var/www/html/phpmyadmin
cp config.sample.inc.php config.inc.php
vim config.inc.php

change the following

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE

where the \\ is put a randompassword in there.