Line 1: |
Line 1: |
− | == PHPMyAdmin for SME Server == | + | {{usefulnote}} |
| + | ==PHPMyAdmin for SME Server== |
| {{Level|Medium}} | | {{Level|Medium}} |
− | {{Warning box|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.
| |
| | | |
− | ---[[User:Unnilennium|Unnilennium]] 13:32, 24 September 2012 (MDT) | + | ---[[User:Unnilennium|Unnilennium]]<nowiki> 13:32, 24 September 2012 (MDT) |
− | }} | + | }}</nowiki> |
− | {{#smeversion:phpmyadmin|description}} | + | {{#smeversion:phpMyAdmin|Description}} |
− | {{#smeversion:smeserver-phpmyadmin|description}} | + | {{#smeversion:smeserver-phpmyadmin|Description}} |
− | <br>
| + | |
− | <br>
| + | ===Maintainer=== |
− | <br>
| |
− | <br>
| |
− | <br>
| |
− | <br>
| |
− | <br>
| |
− | <br>
| |
− | === Maintainer === | |
| JP Pialasse (aka Unnilennium) | | 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. |
| | | |
Line 25: |
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 |
− | 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 |
Line 34: |
Line 42: |
| expand-template /etc/httpd/conf/httpd.conf | | expand-template /etc/httpd/conf/httpd.conf |
| service httpd-e-smith restart | | service httpd-e-smith restart |
| + | </tab> |
| + | </tabs> |
| | | |
− | === Configuration === | + | ===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. |
| | | |
Line 84: |
Line 94: |
| | | |
| {{Tip box| remember that at any time you can see you db configuration by the command "config show phpmyadmin in a root Terminal}} | | {{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 |
| + | |
| + | *status |
| + | |
| + | You can enable/disable phpmyadmin (enabled|disabled) |
| + | config setprop phpmyadmin status disabled |
| + | signal-event phpmyadmin-update |
| + | |
| + | *sqladmin |
| | | |
− | === Additional information ===
| + | You have a super sql user when you use the cookies authentication mode (phpmyadmin-multi or multiaccess enabled)<br /> |
− | * '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
| + | login : sqladmin<br /> |
| + | password : content of the db '''sqladminPassword'''<br /> |
| | | |
− | * Adminaccess with admin username/password via: https://yourdomain/phpmyadmin | + | *Blowfish secret |
| | | |
− | * 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)
| + | Starting SME10, you also have a secret generated,for blowfish, but you can change it if you want. |
| + | BlowfishSecret=ssdfgsdg/sdfgsdffgsdrtert546y654bttbt |
| | | |
− | * 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 | + | *'''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). |
| + | |
| + | *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 === | + | ===Uninstall=== |
− | yum remove smeserver-phpmyadmin phpmyadmin | + | yum remove phpMyAdmin |
| signal-event post-upgrade; signal-event reboot | | 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]] |