Difference between revisions of "PHPMyAdmin"

From SME Server
Jump to navigationJump to search
Line 23: Line 23:
 
  signal-event post-upgrade; signal-event reboot
 
  signal-event post-upgrade; signal-event reboot
 
or
 
or
 +
expand-template /etc/phpMyAdmin/config.inc.php
 +
expand-template /etc/httpd/conf/httpd.conf
 +
service httpd-e-smith restart
  
−
for SME 7
+
{{note box|msg=The contrib is not yet in smecontribs [[bugzilla:7627]], so you have to download it by smetest}}
−
expand-template /usr/share/phpmyadmin/config.inc.php
 
−
expand-template /etc/httpd/conf/httpd.conf
 
−
/usr/local/bin/svc -h /service/httpd-e-smith
 
  
−
for SME 8
+
yum install smeserver-phpmyadmin --enablerepo=smetest,smecontribs
 +
and then
 
  expand-template /etc/phpMyAdmin/config.inc.php
 
  expand-template /etc/phpMyAdmin/config.inc.php
 
  expand-template /etc/httpd/conf/httpd.conf
 
  expand-template /etc/httpd/conf/httpd.conf
−
  /usr/local/bin/svc -h /service/httpd-e-smith
+
  service httpd-e-smith restart
  
 
{{note box| if you need to install php-mcrypt this is the workaround}}
 
{{note box| if you need to install php-mcrypt this is the workaround}}
Line 46: Line 47:
 
To view the current access setting:
 
To view the current access setting:
 
   
 
   
−
  db configuration show phpmyadmin
+
  config show phpmyadmin
  
 
This would output something like this:
 
This would output something like this:
 
  phpmyadmin=configuration
 
  phpmyadmin=configuration
 
   access=private
 
   access=private
 +
  adminaccess=enabled
 +
  multiaccess=disabled
  
 
To change the current setting:
 
To change the current setting:
−
  db configuration setprop phpmyadmin access (private|public)
+
*private or public access
 +
  config setprop phpmyadmin access (private|public)
 
  signal-event ibay-modify
 
  signal-event ibay-modify
 +
{{Warning box|Setting the access type to public makes PHPMyAdmin available to the internet, make sure you choose a strong password before doing so as you severely weaken the security of your server.}}
 +
 +
*adminaccess
 +
set to enabled (enabled|disabled) to use with the url https://your-sme-ip/phpmyadmin with the SME admin account and its password.
 +
config setprop phpmyadmin adminaccess enabled
 +
and do these commands
 +
expand-template /etc/phpMyAdmin/config.inc.php
 +
expand-template /etc/httpd/conf/httpd.conf
 +
service httpd-e-smith restart
 +
 +
*multiaccess
 +
set to enabled (enabled|disabled) to use with the url https://your-sme-ip/phpmyadmin-multi with the '''Mysql user account of a database''' and its password.
 +
config setprop phpmyadmin multiaccess enabled
 +
and do these commands
 +
expand-template /etc/phpMyAdmin/config.inc.php
 +
expand-template /etc/httpd/conf/httpd.conf
 +
service httpd-e-smith restart
  
−
{{Warning box|Setting the access type to public makes PHPMyAdmin available to the internet, make sure you choose a strong password before doing so as you severely weaken the security of your server.}}
+
*prevent the adminaccess
 +
in certain cases you may want to forbid the admin access for security reasons and you have to set the adminaccess to disabled and the multiaccess to enabled
 +
 
 +
config setprop phpmyadmin adminaccess disabled
 +
config setprop phpmyadmin multiaccess enabled
 +
and do these commands
 +
expand-template /etc/phpMyAdmin/config.inc.php
 +
expand-template /etc/httpd/conf/httpd.conf
 +
service httpd-e-smith restart
  
 
=== Additional information ===
 
=== Additional information ===

Revision as of 00:03, 22 June 2013

PHPMyAdmin for SME Server

PythonIcon.png Skill level: Medium
The instructions on this page require a basic knowledge of linux.


Warning.png Warning:
ONLY run this contribs on SME 8, if you use the current updated version : including smeserver-phpmyadmin-3.5.2.2-1.el5.sme and phpMyAdmin3-3.5.2.2-1.el5 or newer. phpmyadmin 2 will corrupt your data if you intent to use it with SME8 as it uses php 5.3

---Unnilennium 13:32, 24 September 2012 (MDT)


phpmyadmin
description


Contrib 10:
Contrib 9:
smeserver-phpmyadmin
description


Maintainer

Darrell May

Description

PHPMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.

Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats.

This contrib provides PHPMyAdmin for SME Server.

Installation

This contrib can be found in the smecontribs repository. To install this contrib you will have to get shell access as root user, and issue the following command: 

yum --enablerepo=smecontribs install smeserver-phpmyadmin

and either 

signal-event post-upgrade; signal-event reboot

or 

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart


Important.png Note:
The contrib is not yet in smecontribs bugzilla:7627, so you have to download it by smetest 


yum install smeserver-phpmyadmin --enablerepo=smetest,smecontribs

and then 

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart


Important.png Note:
if you need to install php-mcrypt this is the workaround 


yum --enablerepo=smecontribs install php-mcrypt
signal-event post-upgrade; signal-event reboot

Uninstall

rpm -e smeserver-phpmyadmin phpmyadmin

Configuration

By default, access to phpmyadmin is restricted to the local network, and to any trusted networks. To make phpmyadmin accessible to external networks (the internet), the configuration parameter for access has to be changed. Changing this parameter requires you to use the SME Server shell.

To view the current access setting: 

config show phpmyadmin

This would output something like this: 

phpmyadmin=configuration
 access=private
 adminaccess=enabled
 multiaccess=disabled

To change the current setting:

  • private or public access
config setprop phpmyadmin access (private|public)
signal-event ibay-modify
Warning.png Warning:
Setting the access type to public makes PHPMyAdmin available to the internet, make sure you choose a strong password before doing so as you severely weaken the security of your server.


  • adminaccess

set to enabled (enabled|disabled) to use with the url https://your-sme-ip/phpmyadmin with the SME admin account and its password. 

config setprop phpmyadmin adminaccess enabled

and do these commands 

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart
  • multiaccess

set to enabled (enabled|disabled) to use with the url https://your-sme-ip/phpmyadmin-multi with the Mysql user account of a database and its password. 

config setprop phpmyadmin multiaccess enabled

and do these commands 

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart
  • prevent the adminaccess

in certain cases you may want to forbid the admin access for security reasons and you have to set the adminaccess to disabled and the multiaccess to enabled 

config setprop phpmyadmin adminaccess disabled
config setprop phpmyadmin multiaccess enabled

and do these commands 

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart

Additional information

  • The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).

More information about PhpMyAdmin can be found on the PHPMyAdmin site.

Bugs

Please raise bugs under the SME-Contribs section in bugzilla and select the smeserver-phpmyadmin component or use this link .

Retrieved from "https://wiki.koozali.org/index.php?title=PHPMyAdmin&oldid=20448"