Line 1: |
Line 1: |
− | {{Languages}} | + | {{usefulnote}} |
− | {{Needs review}}
| |
| == PHPMyAdmin for SME Server == | | == PHPMyAdmin for SME Server == |
| + | {{Level|Medium}} |
| + | |
| + | ---[[User:Unnilennium|Unnilennium]] 13:32, 24 September 2012 (MDT) |
| + | }} |
| + | {{#smeversion:phpMyAdmin|Description}} |
| + | {{#smeversion:smeserver-phpmyadmin|Description}} |
| | | |
| === Maintainer === | | === Maintainer === |
− | Darell May
| + | JP Pialasse (aka Unnilennium) |
| | | |
| === Description === | | === 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. |
− | <br>
| + | |
| 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. | | 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. |
| | | |
Line 14: |
Line 19: |
| | | |
| === Installation === | | === Installation === |
− | This contrib can be found in the [http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/ Darrell's contrib directory] . To install this contrib you will have to get shell access as root user, download the contrib and issue the following command:
| |
− | yum localinstall /path/to/smeserver-phpmyadmin*.rpm
| |
| | | |
− | === Check installed version === | + | = '''For SME8''' = |
− | yum info installed smeserver-phpmyadmin | + | 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 |
| + | |
| + | 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 |
| + | or |
| + | expand-template /etc/phpMyAdmin/config.inc.php |
| + | expand-template /etc/httpd/conf/httpd.conf |
| + | service httpd-e-smith restart |
| + | |
| + | = '''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 |
| | | |
− | === Uninstall ===
| + | <headertabs/> |
− | yum remove smeserver-phpmyadmin
| |
| | | |
| === Configuration === | | === Configuration === |
Line 28: |
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 |
| | | |
− | {{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.}} | + | ====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==== |
| + | |
| + | 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 === |
− | * To access PHPMyadmin, go to your-domain/phpmyadmin | + | * '''NEVER''' MODIFY MYSQL ROOT user PASSWORD |
| | | |
− | * The initial login and password for phpmyadmin is login="admin" & password="admin" | + | * 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). |
− | <br>
| + | |
− | <br>
| + | * 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]] |