Difference between revisions of "PhpMyAdmin"

From OpenEMR Project Wiki
Line 1: Line 1:
==For versions 4.1.2 and above==
==To Be or Not To Be==
:There has been an ongoing debate for several years now whether we should be embedding phpMyAdmin into OpenEMR. Those against phpMyAdmin cite security concerns while those for phpMyAdmin cite practical concerns. At this point, phpMyAdmin remains embedded in OpenEMR for now with the caveat that one can consider removal of the phpmyadmin directory (ie. manually remove phpmyadmin) if a user has any security concerns. This is an ongoing debate, so not sure what the community will decide for future OpenEMR versions; most recent forum thread discussing this issue can be found [https://sourceforge.net/p/openemr/discussion/202506/thread/5eb111fd/ found here].
 
==For OpenEMR versions 4.1.3 and above==
===Integration into OpenEMR===
:Embedded phpMyAdmin was upgraded to 4.2.5. This included:
:*Removal of previous phpmyadmin version:
::*https://github.com/openemr/openemr/commit/7bd0904c15f2ce8e2dfbebe364a61dd0a394e6ed
:*Addition of stock phpMyAdmin 4.2.5 (All Language version).
::*https://github.com/openemr/openemr/commit/cfc1ddf0544bc98af242756b8b5c74dc19e7b51f
:*Integration for phpMyAdmin 4.2.5 into OpenEMR
::*https://github.com/openemr/openemr/commit/4ed7c7b5763538fab5090d3145194cfdd6120752
 
==For OpenEMR version 4.1.2==
===Integration into OpenEMR===
===Integration into OpenEMR===
:Embedded phpMyAdmin was upgraded to 4.0.4. This included:
:Embedded phpMyAdmin was upgraded to 4.0.4. This included:
Line 19: Line 32:
::::*http://github.com/openemr/openemr/commit/23ae06ee46d2c05377b70c9510c1e68b36644aef
::::*http://github.com/openemr/openemr/commit/23ae06ee46d2c05377b70c9510c1e68b36644aef


===To Be or Not To Be===
==For OpenEMR versions 3.1.0 - 4.1.1==
:There has been an ongoing debate for several years now whether we should be embedding phpMyAdmin into OpenEMR. Those against phpMyAdmin cite security concerns while those for phpMyAdmin cite practical concerns. Because of the practical concerns, phpMyAdmin will remain embedded in OpenEMR for now (as of version 4.1.2), with the caveat that one can consider removal of the phpmyadmin directory (ie. manually remove phpmyadmin) if a user has any security concerns. This is an ongoing debate, so not sure what the community will decide for future OpenEMR versions.
 
==For versions 3.1.0 - 4.1.1==
:The phpMyAdmin version (chose 2.x branch to ensure compatibility with php4/mysql4) has been upgraded and migrated to openemr/phpmyadmin. The customizations involved to embed phpMyAdmin involved creating a custom openemr/phpmyadmin/config.inc.php file and modifying several files (openemr/phpmyadmin/libraries/session.inc.php and openemr/phpmyadmin/libraries/common.inc.php) to ensure the sessions of phpMyAdmin and OpenEMR do not conflict. Note that the session name in openemr/interface/globals.php and openemr/phpmyadmin/libraries/session.inc.php need to be identical (this has been documented in the globals.php file for users whom want to change the session names). phpMyAdmin was imported into the cvs code with PHPMYADMIN tags to allow simple upgrading in the cvs to new phpMyAdmin versions in future via cvs import and merge.
:The phpMyAdmin version (chose 2.x branch to ensure compatibility with php4/mysql4) has been upgraded and migrated to openemr/phpmyadmin. The customizations involved to embed phpMyAdmin involved creating a custom openemr/phpmyadmin/config.inc.php file and modifying several files (openemr/phpmyadmin/libraries/session.inc.php and openemr/phpmyadmin/libraries/common.inc.php) to ensure the sessions of phpMyAdmin and OpenEMR do not conflict. Note that the session name in openemr/interface/globals.php and openemr/phpmyadmin/libraries/session.inc.php need to be identical (this has been documented in the globals.php file for users whom want to change the session names). phpMyAdmin was imported into the cvs code with PHPMYADMIN tags to allow simple upgrading in the cvs to new phpMyAdmin versions in future via cvs import and merge.
:*Upgraded OpenEMR 4.0 to phpMyAdmin 2.11.10 via cvs import command (very easy) (4/22/2010)
:*Upgraded OpenEMR 4.0 to phpMyAdmin 2.11.10 via cvs import command (very easy) (4/22/2010)
==For versions 3.0.1 and below==
==For OpenEMR versions 3.0.1 and below==
 
:The embedded phpMyAdmin can be found at openemr/interface/main/myadmin.
:The embedded phpMyAdmin can be found at openemr/interface/main/myadmin.


[[Category:Developer Guide]]
[[Category:Developer Guide]]

Revision as of 10:12, 29 June 2014

To Be or Not To Be

There has been an ongoing debate for several years now whether we should be embedding phpMyAdmin into OpenEMR. Those against phpMyAdmin cite security concerns while those for phpMyAdmin cite practical concerns. At this point, phpMyAdmin remains embedded in OpenEMR for now with the caveat that one can consider removal of the phpmyadmin directory (ie. manually remove phpmyadmin) if a user has any security concerns. This is an ongoing debate, so not sure what the community will decide for future OpenEMR versions; most recent forum thread discussing this issue can be found found here.

For OpenEMR versions 4.1.3 and above

Integration into OpenEMR

Embedded phpMyAdmin was upgraded to 4.2.5. This included:
  • Removal of previous phpmyadmin version:
  • Addition of stock phpMyAdmin 4.2.5 (All Language version).
  • Integration for phpMyAdmin 4.2.5 into OpenEMR

For OpenEMR version 4.1.2

Integration into OpenEMR

Embedded phpMyAdmin was upgraded to 4.0.4. This included:
  • Removal of previous phpmyadmin version:
  • Addition of stock phpMyAdmin 4.0.4 (All Language version).
  • Integration for phpMyAdmin 4.0.4 into OpenEMR

Security Patches

  • Goal is to keep this version updated by phpmyadmin security patches released here:
  • First security patch:
  • FROM (phpmyadmin codebase):
  • TO (openemr codebase):

For OpenEMR versions 3.1.0 - 4.1.1

The phpMyAdmin version (chose 2.x branch to ensure compatibility with php4/mysql4) has been upgraded and migrated to openemr/phpmyadmin. The customizations involved to embed phpMyAdmin involved creating a custom openemr/phpmyadmin/config.inc.php file and modifying several files (openemr/phpmyadmin/libraries/session.inc.php and openemr/phpmyadmin/libraries/common.inc.php) to ensure the sessions of phpMyAdmin and OpenEMR do not conflict. Note that the session name in openemr/interface/globals.php and openemr/phpmyadmin/libraries/session.inc.php need to be identical (this has been documented in the globals.php file for users whom want to change the session names). phpMyAdmin was imported into the cvs code with PHPMYADMIN tags to allow simple upgrading in the cvs to new phpMyAdmin versions in future via cvs import and merge.
  • Upgraded OpenEMR 4.0 to phpMyAdmin 2.11.10 via cvs import command (very easy) (4/22/2010)

For OpenEMR versions 3.0.1 and below

The embedded phpMyAdmin can be found at openemr/interface/main/myadmin.