Difference between revisions of "PHPMyAdmin"

From SME Server
Jump to navigationJump to search
Line 7: Line 7:
 
{{#smeversion:phpmyadmin|description}}
 
{{#smeversion:phpmyadmin|description}}
 
{{#smeversion:smeserver-phpmyadmin|description}}
 
{{#smeversion:smeserver-phpmyadmin|description}}
 +
<br>
 +
<br>
 +
<br>
 +
<br>
 +
<br>
 +
<br>
 +
<br>
 +
<br>
 
=== Maintainer ===
 
=== Maintainer ===
Darrell May
+
JP Pialasse (aka Unnilennium)
  
 
=== Description ===
 
=== Description ===
Line 26: Line 34:
 
  expand-template /etc/httpd/conf/httpd.conf
 
  expand-template /etc/httpd/conf/httpd.conf
 
  service httpd-e-smith restart
 
  service httpd-e-smith restart
 
{{note box|msg=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
 
 
{{note box| if you need to install php-mcrypt this is the workaround}}
 
yum --enablerepo=smecontribs install php-mcrypt
 
signal-event post-upgrade; signal-event reboot
 
  
 
=== Configuration ===
 
=== Configuration ===
Line 58: Line 54:
 
{{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.}}
 
{{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====
+
====admin access only (default)====
 
set to enabled (enabled|disabled) to use with the url https://your-sme-ip/phpmyadmin with the SME admin account and its password.
 
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
 
  config setprop phpmyadmin adminaccess enabled
Line 66: Line 62:
 
  service httpd-e-smith restart
 
  service httpd-e-smith restart
  
====multiaccess====
+
====multiuser access====
 
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. '''Only the database concerned is seen in the phpmyadmin management web page.'''
 
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. '''Only the database concerned is seen in the phpmyadmin management web page.'''
{{note box|alternatively you can use root and ldap password (cat /etc/ldap.secret) or (cat /etc/.my.cnf), but it is not advisable}}
+
{{note box|alternatively you can use root and ldap password (cat /etc/ldap.secret), but it is not advisable}}
 
  config setprop phpmyadmin multiaccess enabled
 
  config setprop phpmyadmin multiaccess enabled
 
and do these commands
 
and do these commands
Line 75: Line 71:
 
  service httpd-e-smith restart
 
  service httpd-e-smith restart
  
====prevent the adminaccess====
+
====prevent the admin access====
 
in certain cases you may want to forbid the adminaccess and allow only the multiaccess, so you have to set the adminaccess to disabled and the multiaccess to enabled
 
in certain cases you may want to forbid the adminaccess and allow only the multiaccess, so you have to set the adminaccess to disabled and the multiaccess to enabled
  

Revision as of 18:49, 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 smeserver-phpmyadmin-3.5.2.2-1.el5.sme and phpMyAdmin3-3.5.2.2-1.el5 or newer on a SME8. phpmyadmin 2 will corrupt your data if you intend to use it with SME8, as it runs php 5.3 with some deprecated functions missing.

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


phpmyadmin
description


Contrib 10:
Contrib 9:
smeserver-phpmyadmin
description










Maintainer

JP Pialasse (aka Unnilennium)

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

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.


admin access only (default)

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

multiuser access

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. Only the database concerned is seen in the phpmyadmin management web page.

Important.png Note:
alternatively you can use root and ldap password (cat /etc/ldap.secret), but it is not advisable


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 admin access

in certain cases you may want to forbid the adminaccess and allow only the multiaccess, so 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

therefore the management will do by the url https://your-sme-ip/phpmyadmin


Information.png Tip:
remember that at any time you can see you db configuration by the command "config show phpmyadmin in a root Terminal


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.

Uninstall

yum remove smeserver-phpmyadmin phpmyadmin
signal-event post-upgrade; signal-event reboot

Bugs

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