Project

General

Profile

Edit History

Appion Home » Appion Manual » Complete Installation » Web Server Installation »

Install phpMyAdmin » History » Version 9

Neil Voss, 01/06/2012 09:39 AM

1 1 Amber Herold 
h1. Install phpMyAdmin
2 





    3
    
    
    





    4
    3
    Amber Herold
    
You are not required to install phpMyAdmin for Appion or Leginon, however, it is a useful tool for interfacing with the mysql databases. 





    5
    
    
    





    6
    6
    Amber Herold
    
h2. Install supporting packages





    7
    3
    Amber Herold
    





    8
    1
    Amber Herold
    
|_.Name:|_.Download site:|_.yum package name|_.SuSE rpm name|





    9
    3
    Amber Herold
    
|PHP|http://php.net/downloads.php |php||





    10
    
    
    
|php-mysql| |php-mysql||





    11
    
    
    





    12
    6
    Amber Herold
    
h2. Install phpMyAdmin





    13
    3
    Amber Herold
    





    14
    1
    Amber Herold
    
If you have not already installed phpMyAdmin, do so. The yum installation is:





    15
    3
    Amber Herold
    
<pre>





    16
    
    
    
sudo yum -y install phpMyAdmin





    17
    
    
    
</pre>





    18
    
    
    





    19
    6
    Amber Herold
    
h2. Configure phpMyAdmin





    20
    3
    Amber Herold
    





    21
    
    
    
Edit the phpMyAdmin config file @/etc/phpMyAdmin/config.inc.php@ and change the following lines:





    22
    
    
    





    23
    
    
    
<pre>





    24
    8
    Neil Voss
    
sudo nano /etc/phpMyAdmin/config.inc.php





    25
    
    
    
</pre>





    26
    
    
    





    27
    
    
    
<pre>





    28
    3
    Amber Herold
    
$cfg['Servers'][$i]['AllowRoot']     = FALSE;





    29
    7
    Neil Voss
    
$cfg['Servers'][$i]['host']          = 'mysqlserver.INSTITUTE.EDU';





    30
    3
    Amber Herold
    
</pre>





    31
    
    
    





    32
    
    
    
Edit the phpMyAdmin apache config file @/etc/httpd/conf.d/phpMyAdmin.conf@ and change the following lines:





    33
    
    
    





    34
    8
    Neil Voss
    
<pre>





    35
    
    
    
sudo nano /etc/httpd/conf.d/phpMyAdmin.conf





    36
    
    
    
</pre>





    37
    3
    Amber Herold
    





    38
    9
    Neil Voss
    
<pre>





    39
    3
    Amber Herold
    
<Directory /usr/share/phpMyAdmin/>





    40
    
    
    
   order deny,allow





    41
    
    
    
   deny from all





    42
    1
    Amber Herold
    
   allow from 127.0.0.1





    43
    3
    Amber Herold
    
   allow from YOUR_IP_ADDRESS





    44
    
    
    
</Directory>





    45
    9
    Neil Voss
    
<pre>





    46
    3
    Amber Herold
    





    47
    
    
    
*Note:* If you want to access phpMyAdmin from another computer, you can also add it to this config file with an @allow from@ tag





    48
    
    
    





    49
    6
    Amber Herold
    
h2. Restart Web Server





    50
    3
    Amber Herold
    





    51
    
    
    
Next restart the web server to take on the new setting





    52
    
    
    
<pre>





    53
    
    
    
sudo /sbin/service httpd restart





    54
    
    
    
</pre>





    55
    
    
    





    56
    6
    Amber Herold
    
h2. Test the configuration





    57
    3
    Amber Herold
    





    58
    
    
    
To test the phpMyAdmin configuration, point your browser to http://YOUR_IP_ADDRESS/phpMyAdmin or http://localhost/phpMyAdmin and login with the usr_object user.





    59
    
    
    





    60
    5
    Amber Herold
    
!http://emg.nysbc.org/attachments/177/phpMyAdmin.png!





    61
    4
    Amber Herold
    





    62
    3
    Amber Herold
    
A common problem is that the firewall may be blocking access to the web server and mysql server. On CentOS/Fedora you can configure this with the system config:





    63
    
    
    





    64
    
    
    
<pre>





    65
    
    
    
system-config-securitylevel





    66
    
    
    
</pre>





    67
    
    
    





    68
    
    
    
Firewall configuration is specific to different Unix distributions, so consult a guide on how to do this on non-RedHat machines.





    69
    
    
    





    70
    
    
    





    71
    1
    Amber Herold
    





    72
    
    
    





    73
    
    
    





    74
    
    
    
______





    75
    
    
    





    76
    2
    Amber Herold
    
[[Install the Web Interface|< Install the Web Interface]] | [[Potential Problems|Potential Problems >]]





    77
    1
    Amber Herold
    





    78
    
    
    
______