Changes

Jump to navigation Jump to search

PHPMyAdmin (view source)

Revision as of 23:19, 28 March 2021

4,313 bytes added ,  23:19, 28 March 2021
no edit summary
Line 1: Line 1: −
== PHPMyAdmin for SME Server ==
+
{{usefulnote}}
 +
==PHPMyAdmin for SME Server==
 
{{Level|Medium}}
 
{{Level|Medium}}
   −
=== Maintainer ===
+
---[[User:Unnilennium|Unnilennium]]<nowiki> 13:32, 24 September 2012 (MDT)
−
Darrell May
+
}}</nowiki>
 +
{{#smeversion:phpMyAdmin|Description}}
 +
{{#smeversion:smeserver-phpmyadmin|Description}}
   −
=== Description ===
+
===Maintainer===
 +
JP Pialasse (aka Unnilennium)
 +
 
 +
===Description===
 
PHPMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.  
 
PHPMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.  
   Line 12: Line 18:  
This contrib provides PHPMyAdmin for SME Server.
 
This contrib provides PHPMyAdmin for SME Server.
   −
=== Installation ===
+
===Installation===
 +
<tabs container><tab name="For SME10">
 +
yum install --enablerepo=smecontribs smeserver-phpmyadmin
 +
then configure according to your needs
 +
</tab>
 +
<tab name="For SME9">
 +
yum install --enablerepo=smecontribs smeserver-phpmyadmin
 +
then reconfigure
 +
signal-event post-upgrade; signal-event reboot
 +
or if you don't want to restart your server
 +
signal-event phpmyadmin-update
 +
</tab>
 +
<tab name="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
 +
 +
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
 +
expand-template /etc/phpMyAdmin/config.inc.php
 +
expand-template /etc/httpd/conf/httpd.conf
 +
service httpd-e-smith restart
 +
</tab>
 +
</tabs>
   −
=== Uninstall ===
+
===Configuration===
−
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.
 
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:
 
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 and newer settings====
 +
 +
Starting 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
   −
{{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.}}
+
*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 />
 +
 
 +
*Blowfish secret
 +
 
 +
Starting SME10, you also have a secret generated,for blowfish, but you can change it if you want.
 +
BlowfishSecret=ssdfgsdg/sdfgsdffgsdrtert546y654bttbt
 +
 
 +
===Additional information===
 +
 
 +
*'''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).
   −
=== Additional information ===
+
*Did we mention : '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
−
* Access with admin username/password via: https://yourdomain/phpmyadmin
     −
* The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
+
*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.
   −
=== Bugs ===
+
===Uninstall===
 +
yum remove phpMyAdmin
 +
signal-event post-upgrade; signal-event reboot
 +
 
 +
===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,250

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/11842...39249"

Navigation menu