Phpmyadmin

iankarlwallace wrote on Tuesday, June 24, 2014:

fsgl - I guess in the end this comes down to Brady - keeping a bunch
of different versions available (one with phpmyadmin, one without) is
kinda a pain. The tools is readily available to be
installed/configured to access the OpenEMR mysql database at any time.
I personally would lobby for the following:

  1. For the next several packages of OpenEMR (4.1.2 patch 8 and beyond)
    I would suggest that we announce that phpmyadmin will be removed - how
    we do that I am not sure … modification of the phpmyadmin index page
    to alert people if will be removed (?) - announcement on the downloads
    page as well(?)

  2. For the debian-med version I will remove it from the source via a
    Files-Excluded header directive otherwise the package will be rejected
    out of hand for duplicated code that doesn’t need to be in the
    package.

I think I might have confused more than I clarified with my prior
email. My intent WOULD be to remove phpmyadmin from the entire code
base (Windows/Linux distro). I guess I was trying to impart that it
is readily available from other resources and can be installed for
usage on the demos/peoples local instances without much hassle.
People are missing out on the updates from the phpmyadmin project by
using our embedded version.

I will start looking into how hard this is since I am talking in the
theoretical at this point. Won’t be able to do it tonight but will
try to look at tomorrow.

Again I apologize if I misled anyone.

cheers
ian

On Mon, Jun 23, 2014 at 9:37 PM, fsgl fsgl@users.sf.net wrote:

Ian,

PhpMyAdmin is part of the package deal of XAMPP for Windows, that takes care
of the majority of users. LAMP has it. The Demo’s will have it. Only the
future Ubuntu-Debian package will not have it.

For most of this thread, I got the impression phpMyAdmin will be uncoupled
from all copies of OpenEMR. Incorrect understanding on my part.

The mountain turned out to be a molehill.

Equilibrium has been restored to this little universe.


Pimm,

The first of my duplicate posts has been deemed not to be a spambot, so you
can click the link and see that most beginners will be able to install it.


phpmyadmin


Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net


Ian Wallace - CCRMC DFM Staff Physician - (c) 303.681.5732

bradymiller wrote on Tuesday, June 24, 2014:

Hi,

After reading above posts, sounds like key things to sort out before considering removal of phpmyadmin are:

  1. See how easy it is to install phpmyadmin on linux by a DIY user.
  2. Ensure we are not sending the DIY user over a security cliff (ie. unknowingly install a very unsecure phpmyadmin that requires no credentials, which ends up being much worse from a security perspective than what is currently in OpenEMR).
  3. Get it working on the demo farm

Regarding the debian package, should migrate following key points of discussion to the openemr deb/ubuntu package forum thread:

  1. Don’t let philosophy get in the way :slight_smile: (OpenEMR is simply a beast of a software package :slight_smile: I would suggest not removing features or doing things that hinder innovation/progress in OpenEMR or cause future undue burden towards yourself to proceed or maintain). For example, phpmyadmin has been modified to work with OpenEMR credentials/ACL; I would rec not removing it from any package unless OpenEMR community agrees.
  2. What to do with the current deb package when the official debian-med one is in circulation(this is simple(ie. remove from existence), but need to iron out some details).

-brady
OpenEMR

blankev wrote on Tuesday, June 24, 2014:

Brady,

you sound like a very involved person… LOL … YOU ARE!

A WIKI Page and some reassurances about security and HIPPAA are INTERNATIONAL good practice policies. No doubt about that. If phpMyAdmin is placed in a different folder outside OpenEMR and make a comparisson or compare phpMyAdmin with other similar software in a WIKI, it could be an advantage. I wish I had more time to investigate. I did a check on my Web-site and there the option to include or not use phpMyAdmin for Database corrections is available, it is also something optional and very easy to implement (C-panel is used and very encouraging for starters like me).

So it could be “we see elephants and bears” (not beers like in soccer) but indeed caution should be in place not to harm the vast majority of Users with less willingness to spend more money.

It is hard to get the funds for accreditation (?), so it will be hard to convince USERS to pay or to pay more than a sub-liminal virtual fee.

blankev wrote on Tuesday, June 24, 2014:

There are two parts of concern:

  1. phpMyadmin for the Tables (now available inmost versions of OpenEMR.
  2. getting the folders to show where what is and who did the work to make things as is. (not available in OpenEMR Farm versions, nor Demos) Only visible for view and changes and can be approached and changed in Local versions and GitHub.

fsgl wrote on Tuesday, June 24, 2014:

O.K.,

So it’s really a mountain after all.

Returning to the mindset of when I installed OpenEMR for the first time in 2009. It was a bear. Failed miserably to the point that I gave up trying for the next 3 years.

Brady will remember how difficult it was before Sam Bowen gave us the first XAMPP-OpenEMR package for Windows. Without the package, I would never been able to install OpenEMR and certainly would not be posting in the Forums today.

I would not be going out on a limb to say that Windows users would be less inclined to deploy OpenEMR. the more components we ask them to install. A quick sampling of the install questions comes from Linux users, not Windows users. This phenomenal success is due in large part to the package. Bear in mind, most physicians would not have the confidence to explore open source applications in the first place and reflexively would go for the paid stuff.

Gentlemen,

I would suggest that we should not have OpenEMR become the purview of IT types, however inadvertently. We value our developers, but we must not miss the forest for the trees. If we make the geeks happy, but physicians are scared away, is it not a Pyrrhic victory?

blankev wrote on Tuesday, June 24, 2014:

fsgl,

you sound depressive. Why not stay with the facts. 2009 can not be compared with the 2014 and future.

phpMyAdmin is separate in Xampp in OpenEMR distros.

It is included in other versions. Bu we need a WIKI on how to handle phpMyAdmin an when do you need this insecure extra and when do you do your things without. There are awesome new features ready to install in version 4.0.3 even some more in Patch 1… ;-( so be sure to keep Brady as a friend and let Developers think we doctors are so stupid that we have problems with even the minor chores that have to be done with install, maintenance, and small easy extra’s like LBF forms of OpenEMR…

fsgl wrote on Tuesday, June 24, 2014:

Pimm,

Physicians should not behave like the blonde.

[[embed url=https://www.youtube.com/watch?v=0lCPmaq960E]]

iankarlwallace wrote on Wednesday, June 25, 2014:

Thanks to everyone for posting to the discussion. I think for the
time being let’s shelve the decision (to remove or not) and I can take
on a few items:

  1. I can proceed by excluding our phpmyadmin code from the distro for
    debian-med with a Files-Excluded header include
  2. I will add to my to-do list taking a look at the modifications that
    we’ve added to phpmyadmin and see if we can somehow use the debian
    packaged phpmyadmin distro to do the same thing.
  3. Brady - agree that we can move discussion about philosophy around
    packaging to the other thread on the debian/ubuntu package.

Open to other ideas/suggestions on this. If people are in agreement
to remove phpmyadmin from within OpenEMR don’t let me stand in the way
but I think that some are split about the idea and we need a clearer
understanding on a migration path to a non-packaged version.

cheers
ian

On Tue, Jun 24, 2014 at 12:07 PM, fsgl fsgl@users.sf.net wrote:

Pimm,

Physicians should not behave like the blonde.


phpmyadmin


Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net


Ian Wallace - CCRMC DFM Staff Physician - (c) 303.681.5732

bradymiller wrote on Sunday, June 29, 2014:

Hi,

To kick the can a little further along before community reaches a consensus, I just placed most recent version of phpmyadmin (4.2.5) into OpenEMR codebase. Also updated the pertinent wiki page with a summary there also going over this thread (“To Be or Not To Be” section at top of the wiki page):
http://www.open-emr.org/wiki/index.php/PhpMyAdmin#For_OpenEMR_versions_4.1.3_and_above

Ian, check out the third commit to see how it’s integrated.

-brady
OpenEMR

iankarlwallace wrote on Sunday, June 29, 2014:

Will look at the 4.1.3 commits to investigate the integration more closely.

Ian

Ian Wallace 303-681-5732

On Jun 29, 2014, at 3:14 AM, “Brady Miller” bradymiller@users.sf.net wrote:

Hi,

To kick the can a little further along before community reaches a consensus, I just placed most recent version of phpmyadmin (4.2.5) into OpenEMR codebase. Also updated the pertinent wiki page with a summary there also going over this thread (“To Be or Not To Be” section at top of the wiki page):
PhpMyAdmin - OpenEMR Project Wiki

Ian, check out the third commit to see how it’s integrated.

-brady
OpenEMR

phpmyadmin

Sent from sourceforge.net because you indicated interest in OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit SourceForge.net: Log In to SourceForge.net