Line 7: |
Line 7: |
| {{#smeversion:phpmyadmin|description}} | | {{#smeversion:phpmyadmin|description}} |
| {{#smeversion:smeserver-phpmyadmin|description}} | | {{#smeversion:smeserver-phpmyadmin|description}} |
| + | <br> |
| + | <br> |
| + | <br> |
| + | <br> |
| + | <br> |
| + | <br> |
| + | <br> |
| + | <br> |
| === Maintainer === | | === Maintainer === |
− | Darrell May
| + | JP Pialasse (aka Unnilennium) |
| | | |
| === Description === | | === Description === |
Line 26: |
Line 34: |
| expand-template /etc/httpd/conf/httpd.conf | | expand-template /etc/httpd/conf/httpd.conf |
| service httpd-e-smith restart | | service httpd-e-smith restart |
− |
| |
− | {{note box|msg=The contrib is not yet in smecontribs [[bugzilla:7627]], so you have to download it by smetest}}
| |
− |
| |
− | yum install smeserver-phpmyadmin --enablerepo=smetest,smecontribs
| |
− | and then
| |
− | expand-template /etc/phpMyAdmin/config.inc.php
| |
− | expand-template /etc/httpd/conf/httpd.conf
| |
− | service httpd-e-smith restart
| |
− |
| |
− | {{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
| |
| | | |
| === Configuration === | | === Configuration === |
Line 58: |
Line 54: |
| {{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.}} | | {{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.}} |
| | | |
− | ====adminaccess==== | + | ====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. | | 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 | | config setprop phpmyadmin adminaccess enabled |
Line 66: |
Line 62: |
| service httpd-e-smith restart | | service httpd-e-smith restart |
| | | |
− | ====multiaccess==== | + | ====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.''' | | 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) or (cat /etc/.my.cnf), but it is not advisable}} | + | {{note box|alternatively you can use root and ldap password (cat /etc/ldap.secret), but it is not advisable}} |
| config setprop phpmyadmin multiaccess enabled | | config setprop phpmyadmin multiaccess enabled |
| and do these commands | | and do these commands |
Line 75: |
Line 71: |
| service httpd-e-smith restart | | service httpd-e-smith restart |
| | | |
− | ====prevent the adminaccess==== | + | ====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 | | 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 |
| | | |