Changes

From SME Server
Jump to navigationJump to search

PHPMyAdmin (view source)

Revision as of 15:35, 26 July 2016

3,302 bytes added ,  15:35, 26 July 2016
no edit summary
Line 1: Line 1:  +
{{usefulnote}}
 
== PHPMyAdmin for SME Server ==
 
== PHPMyAdmin for SME Server ==
 
{{Level|Medium}}
 
{{Level|Medium}}
−
{{Warning box|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 3.5.
      
---[[User:Unnilennium|Unnilennium]] 13:32, 24 September 2012 (MDT)
 
---[[User:Unnilennium|Unnilennium]] 13:32, 24 September 2012 (MDT)
 
}}
 
}}
−
{{#smeversion:phpmyadmin|description}}
+
{{#smeversion:phpMyAdmin|Description}}
−
{{#smeversion:smeserver-phpmyadmin|description}}
+
{{#smeversion:smeserver-phpmyadmin|Description}}
 +
 
 
=== Maintainer ===
 
=== Maintainer ===
−
Darrell May
+
JP Pialasse (aka Unnilennium)
    
=== Description ===
 
=== Description ===
Line 18: Line 19:     
=== Installation ===
 
=== Installation ===
 +
 +
= '''For SME8''' =
 
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:
 
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
 
  yum --enablerepo=smecontribs install smeserver-phpmyadmin
−
and either
+
 
 +
On sme8 this will also install the dependencies libmcrypt, php53-mcrypt, php53-php-gettext & phpMyAdmin3
 +
 
 +
then do either
 
  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 SME9''' =
   −
for SME 7
  −
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 --enablerepo=smecontribs smeserver-phpmyadmin
−
  expand-template /etc/phpMyAdmin/config.inc.php
+
then reconfigure
−
  expand-template /etc/httpd/conf/httpd.conf
+
  signal-event post-upgrade; signal-event reboot
−
  /usr/local/bin/svc -h /service/httpd-e-smith
+
or if you don't want to restart your server
 +
  signal-event phpmyadmin-update
   −
=== Uninstall ===
+
<headertabs/>
−
rpm -e smeserver-phpmyadmin phpmyadmin
      
=== Configuration ===
 
=== Configuration ===
Line 42: Line 49:  
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.}}
 +
 +
====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.'''
 +
{{note box|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 access for multi user will be available through the url https://your-sme-ip/phpmyadmin (instead of phpmyadmin-multi)
 +
 +
{{Tip box| remember that at any time you can see you db configuration by the command "config show phpmyadmin in a root Terminal}}
 +
====specific SME Server 9 settings====
   −
{{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.}}
+
Only for SME9 you have some more settings available by DB
 +
 
 +
# config show phpmyadmin
 +
phpmyadmin=configuration
 +
    DbName=phpmyadmin
 +
    DbPassword=rvAd9ShvG2GyiWPXiH+oAK3/yk4GwCxDW5PWzy2CWdtMG7zu3SSH7XkJUEV7EpY8HSVaCCHKL//2
 +
    DbUser=phpmyadmin
 +
    access=private
 +
    adminaccess=enabled
 +
    multiaccess=disabled
 +
    sqladminPassword=mcJ1Tad4I0XENJrl+sfzkKjS8rs4Bq6C0MsjbTkgyv3evFLrPgrXy8eP1u23vANuGtSkQ3//8tmM
 +
    status=enabled
 +
* status
 +
You can enable/disable phpmyadmin (enabled|disabled)
 +
config setprop phpmyadmin status disabled
 +
signal-event phpmyadmin-update
 +
* sqladmin
 +
You have a super sql user when you use the cookies authentication mode (phpmyadmin-multi or multiaccess enabled)<br />
 +
login    : sqladmin<br />
 +
password : content of the db '''sqladminPassword'''<br />
    
=== Additional information ===
 
=== Additional information ===
−
* Access with admin username/password via: https://yourdomain/phpmyadmin
+
* '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
 +
 
 +
* Adminaccess with admin username/password via: https://yourdomain/phpmyadmin
 +
 
 +
* multiaccess with the '''Mysql user account of a database''' and its password via: https://your-sme-ip/phpmyadmin-multi (or https://yourdomain/phpmyadmin if admin access disabled)
    
* The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
 
* The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
 +
 +
* Did we mention : '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
 +
 +
* If you see this error '''#1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist''' when viewing data see a solution here: http://forums.contribs.org/index.php/topic,51696.0.html
    
More information about PhpMyAdmin can be found on the [http://www.phpmyadmin.net PHPMyAdmin] site.
 
More information about PhpMyAdmin can be found on the [http://www.phpmyadmin.net PHPMyAdmin] site.
 +
 +
=== Uninstall ===
 +
yum remove smeserver-phpmyadmin phpMyAdmin3 libmcrypt php53-mcrypt php53-php-gettext
 +
signal-event post-upgrade; signal-event reboot
    
=== Bugs ===
 
=== Bugs ===
 
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-phpmyadmin component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-phpmyadmin|title=this link}}.
 
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-phpmyadmin component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-phpmyadmin|title=this link}}.
 +
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |component=smeserver-phpmyadmin |noresultsmessage="No open bugs found."}}
 +
 +
===Changelog===
 +
Only released version in smecontrib are listed here.
 +
 +
{{ #smechangelog: smeserver-phpmyadmin}}
 +
 
----
 
----
 
[[Category: Contrib]]
 
[[Category: Contrib]]
 
[[Category: Administration]]
 
[[Category: Administration]]
Unnilennium
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,240

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/16609...31736"

Navigation menu