Changes

From SME Server
Jump to navigationJump to search

PHPMyAdmin (view source)

Revision as of 01:03, 22 June 2013

1,305 bytes added ,  01:03, 22 June 2013
no edit summary
Line 23: Line 23:  
  signal-event post-upgrade; signal-event reboot
 
  signal-event post-upgrade; signal-event reboot
 
or
 
or
 +
expand-template /etc/phpMyAdmin/config.inc.php
 +
expand-template /etc/httpd/conf/httpd.conf
 +
service httpd-e-smith restart
   −
for SME 7
+
{{note box|msg=The contrib is not yet in smecontribs [[bugzilla:7627]], so you have to download it by smetest}}
−
expand-template /usr/share/phpmyadmin/config.inc.php
  −
expand-template /etc/httpd/conf/httpd.conf
  −
/usr/local/bin/svc -h /service/httpd-e-smith
     −
for SME 8
+
yum install smeserver-phpmyadmin --enablerepo=smetest,smecontribs
 +
and then
 
  expand-template /etc/phpMyAdmin/config.inc.php
 
  expand-template /etc/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
    
{{note box| if you need to install php-mcrypt this is the workaround}}
 
{{note box| if you need to install php-mcrypt this is the workaround}}
Line 46: Line 47:  
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.}}
 +
 +
*adminaccess
 +
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
 +
 +
*multiaccess
 +
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.
 +
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
   −
{{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.}}
+
*prevent the adminaccess
 +
in certain cases you may want to forbid the admin access for security reasons and 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
    
=== Additional information ===
 
=== Additional information ===
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/20448"

Navigation menu