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
- Copy 86PhpmyadminAlias from /etc/e-smith/templates/etc/httpd/conf/httpd.conf/ to /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
- 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.
... - 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