Brady - Just an FYI that I am pursing the integration with the official
Debian phpmyadmin package. Trialed a configuration last night that seemed
to work but wanted to do some more testing before committing to the Debian
git repo and describing the integration here.
It essentially consists of installing a configuration file in
/etc/phpmyadmin/con.d that changes the configuration if it’s called from an
OpenEMR URI or leaves the configuration alone if accessed from the a
non-OpenEMR URI.
One question: In your commit you override the session setting from
“phpMyadmin” to “OpenEMR” in phpmyadmin/libraries/session.inc.php. Any
reason that we have to override the session? In my short testing it
appears to work fine in the center frame.
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):
It did not work without the session change (when they used different session names, it broke). Have you tested this using the original development codebase?
It did not work without the session change (when they used different
session names, it broke). Have you tested this using the original
development codebase?
-brady
On 08/19/2014 01:09 PM, iankarlwallace wrote:
Brady - Just an FYI that I am pursing the integration with the official
Debian phpmyadmin package. Trialed a configuration last night that seemed
to work but wanted to do some more testing before committing to the Debian
git repo and describing the integration here.
It essentially consists of installing a configuration file in
/etc/phpmyadmin/con.d that changes the configuration if it’s called
from an
OpenEMR URI or leaves the configuration alone if accessed from the a
non-OpenEMR URI.
One question: In your commit you override the session setting from
“phpMyadmin” to “OpenEMR” in phpmyadmin/libraries/session.inc.php. Any
reason that we have to override the session? In my short testing it
appears to work fine in the center frame.
wrote:
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):
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
phpmyadmin
Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202506/
<https://sourceforge.net/p/openemr/discussion/202506>
To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
<https://sourceforge.net/auth/subscriptions>
------------------------------------------------------------------------
phpmyadmin
http://sourceforge.net/p/openemr/discussion/202506/thread/5eb111fd/?limit=25&page=1#e7e7/e691
------------------------------------------------------------------------
Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202506/
<https://sourceforge.net/p/openemr/discussion/202506>
To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
<https://sourceforge.net/auth/subscriptions>
I am testing this now but am finding maybe that that is an issue. I thought I had it working and I tried to package it and bumbled something. I will keep working on it in the background seeing how I don’t have any MU2 stuff.
It did not work without the session change (when they used different session names, it broke). Have you tested this using the original development codebase?
-brady
OpenEMR
Re: [openemr:discussion] Re: phpmyadmin - integration with Debian Package
MD Support - Thanks for the tip. Will still need a few items in the
configuration file but that would probably solve some of the problems I am
bumping up against (the fact that the dual sessions cause PHP to barf at
some random location in the code).
Will give that a try to see if it clears up some of the issues. Not sure
if it’ll still set it’s own session as well.
Without any configuration, wouldn’t it be better to call admin in a
separate window with the correct $_POSTs as shown in phpmyadmin
documentation http://wiki.phpmyadmin.net/pma/Auth_types#signon?
I have not added it to the github repo yet but I have been able to
integrate OpenEMR and phpMyAdmin without needing to modify the underlying
phpMyAdmin code. I am using the single_signon method described by
phpMyAdmin in the documentation but you also need to create a second
session (due to a ‘feature’ or ‘bug’ not sure in php that always sends a
header cookie with session_start()).
Will commit over the next several days so that others can look at the
integration. Requires the following:
Configuration file in /etc/phpmyadmin/conf.d to set the basic framework
if it finds the OpenEMRphpMyAdmin cookie
Modifications to interface/globals.php to add in the creation of a
second session cookie under the /openemr/phpmyadmin/ path
Modifications to interface/main/left_nav.php so that it stashes the PMA
login credentials if the Database link is visible or sets them all to null
if it shouldn’t be visible.
Configuration file changes for Apache so that it creates an alias from
/openemr/phpmyadmin to the system maintained one
In initial testing works well. I will send another email once the code is
in the repo.
Brady - I am not sure if there’s a way to place this in one of the demo’s
so that it can be tested? It includes changes to Apache’s configuration,
an extra configuration file for phpMyAdmin, and the two patches for
global.php and left_nav.php. I have also not looked at how this would be
included/work with the build in LAMP/XAMP packages.
MD Support - Thanks for the tip. Will still need a few items in the
configuration file but that would probably solve some of the problems I am
bumping up against (the fact that the dual sessions cause PHP to barf at
some random location in the code).
Will give that a try to see if it clears up some of the issues. Not sure
if it’ll still set it’s own session as well.
Without any configuration, wouldn’t it be better to call admin in a
separate window with the correct $_POSTs as shown in phpmyadmin
documentation auth_types · phpmyadmin/phpmyadmin Wiki · GitHub?
Seems rather complicated, but will definitely keep an open mind.
One option to get a demo up is to add an option to demo farm that builds the debian package (from the branch selected) and installs that(I am assuming the debian/ubuntu package wills set all the config files etc):
Would involve adding a toggle option in:
And then adding the code to do it in:
(if installing via ubuntu/debian package, then build it and then install the package rather than the manual install that is done)
Note packages can be installed even if prompt for questions; to do this, see the example of installing Postfix in the demo_build.sh script above.
This would be a nice feature in the demo farm, because could then test the debian/ubuntu packages easily and have ability to link it to all the other pieces(portals etc.).
Brady - In the end probably worth the effort to get a demo build that
builds with from the Debian/Ubuntu package. Interestingly enough Ubuntu
runs a bit behind the actual Debian release builds b/c they are down
stream. I have been working with Andreas Tille on the Debian Med group
using their git repo to make some of the changes. I am sure the rules
files/etc can be ported over to the Ubuntu build but should go one step at
a time.
You are correct that the package would setup/restart apache as needed. It
sets all the configuration files and (the pure Debian version) installs in
/usr/share/openemr (as per their policy). That’s probably a bit radical
right now since there was quite a stir with just moving from /var/www/html
to /var/www (or the other way around).
So first thing would be to add the flag and start working on the
infrastructure. Can look at that later in the week as time permits.
Note packages can be installed even if prompt for questions; to do this,
see the example of installing Postfix in the demo_build.sh script above.
This would be a nice feature in the demo farm, because could then test the
debian/ubuntu packages easily and have ability to link it to all the other
pieces(portals etc.).
I like the separate window concept with automatic login. It’s normal to want to do things in openemr and keep up with how that affects the database. For me it’s just awkward to work with phpmyadmin inside the openemr frameset.