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 |
− | for SME 7
| |
− | expand-template /usr/share/phpmyadmin/config.inc.php | |
| expand-template /etc/httpd/conf/httpd.conf | | expand-template /etc/httpd/conf/httpd.conf |
− | /usr/local/bin/svc -h /service/httpd-e-smith | + | service httpd-e-smith restart |
| | | |
− | for SME 8
| + | = '''For SME9''' = |
− | expand-template /etc/phpMyAdmin/config.inc.php
| |
− | expand-template /etc/httpd/conf/httpd.conf
| |
− | /usr/local/bin/svc -h /service/httpd-e-smith
| |
| | | |
− | {{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}} | + | 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/> |
− | rpm -e smeserver-phpmyadmin phpmyadmin
| |
| | | |
| === Configuration === | | === Configuration === |
Line 46: |
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 |
| | | |
− | {{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.}} | + | 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 === |
− | * 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]] |