To Install phpMyAdmin

On your SME Server's (Contribs.org) console, issue the following commands:

yum --enablerepo=smecontribs install smeserver-phpmyadmin
signal-event post-upgrade
expand-template /usr/share/phpmyadmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
svc –t /service/httpd-e-smith
svc –t /service/httpd-admin

OR if above gives you an error "No package smeserver-phpmyadmin available. Nothing to do" then do a yum localinstall:

cd /tmp
wget http://www.sme-server.de/download/sme7/contribs/smecontribs/smeserver-phpmyadmin-2.11.1.2-3.el4.sme.noarch.rpm
yum localinstall smeserver-phpmyadmin-2.11.1.2-3.el4.sme.noarch.rpm
signal-event post-upgrade
expand-template /usr/share/phpmyadmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
svc –t /service/httpd-e-smith
svc –t /service/httpd-admin

OR update your repository to sme7contribs:

db yum_repositories set sme7contribs repository \
 GPGCheck yes \
 MirrorList http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smecontribs-7 \
 Name 'SME 7 - contribs' \
 Visible no \
 status disabled
signal-event yum-modify
yum clean all

Then repeat the installation procedure above where it says yum --enablerepo=smecontribs install smeserver-phpmyadmin.

 

To Uninstall phpMyAdmin

rpm -e smeserver-phpmyadmin

 

 To Limit Access of phpMyAdmin Web Interface to Certain IP

  1. Copy 86PhpmyadminAlias from /etc/e-smith/templates/etc/httpd/conf/httpd.conf/ to /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
  2. Change
    ...
    allow from all
    ...
    to
    ...
    allow from 127.0.0.1 192.168.1.0/255.255.255.0 123.456.789.012
    ...
    Of course, 123.456.789.012 will be your public IP address.
  3. Restart httpd service
    svc -t /service/httpd-e-smith

Troubleshooting

  • ERROR: “The configuration file now needs a secret passphrase (blowfish_secret)” Error when viewing the webconsole
    SOLUTION: Maybe you didn't issue this command as per above:
    expand-template /usr/share/phpmyadmin/config.inc.php
    svc –t /service/httpd-e-smith

Facebook Page