OpenEMR – Force Secure Socket Login

OpenEMR, Tools

If you want to force a SSL connection to OpenEMR, insert the code below into the index.php in /var/www/openemr/index.php

Place the lines below after the line “include_once(“library/sqlconf.php”);”

/**
* Check for SSL connection to webserver
*/
if ( !isset($_SERVER[‘HTTPS’]) || ($_SERVER[‘HTTPS’] != ‘on’) ) {
echo “Do not use OpenEMR over an unsecured connection.\n\n” ; echo “\nUse this link: <a href=’https://” . $_SERVER[‘HTTP_HOST’] . $_SERVER[‘PHP_SELF’] .”‘>https://” . $_SERVER[‘HTTP_HOST’] . $_SERVER[‘PHP_SELF’] .”</a><br>”;
die();
}

OpenEMR – Check Database

OpenEMR, Tools,

This addition to the crontab is used to verify the database integrity and then to optimize the indexes and tables.

Add the following to the /etc/crontab

30 22 * * *     root    mysqlcheck -A -e –user={YOUR OPENEMR DB USER} –password={YOUR OPENEMR DB PASSWORD}  openemr
35 22 * * *     root    mysqlcheck -A -a –user={YOUR OPENEMR DB USER} –password={YOUR OPENEMR DB PASSWORD}  openemr
40 22 * * *     root    mysqlcheck -A -o –user={YOUR OPENEMR DB USER} –password={YOUR OPENEMR DB PASSWORD} openemr

Ohio LinuxFest 2010

Uncategorized, , ,

The eighth annual Ohio LinuxFest will be held on September 10-12, 2010 at the Greater Columbus Convention Center in downtown Columbus, Ohio. Hosting authoritative speakers and a large expo, the Ohio LinuxFest welcomes all Free and Open Source Software professionals, enthusiasts, and everyone interested in learning more about Free and Open Source Software.

OHIO LinuxFest 2010

OSCON 2010

Uncategorized, , ,

OSCON focuses on the substance of technology, not the shadow, filtering the information that most merits attention and preparing participants for curves and challenges in the coming year and beyond. OSCON is the place to be inspired and challenged, renew bonds to community, make new connections, and find ways to give back to the open source movement. OSCON has also become one of the most important places to make open source related announcements, and to unveil projects and products.

Open source is a fundamental principle at the core of many established and emerging technologies, driving the future of the computer industry. OSCON explores the open source technologies that are here to stay, what will broaden the foundation, and what will lead the way to unexpected places and innovations.

OSCON 2010

OpenEMR – Macintosh Installation

OpenEMR, ,

OpenEMR on the Macintosh

Configuration
iMac
Leopard 10.6.3

Configure PHP

Open the Terminal application in the Utilities folder

changes are based on the vi editor

cd /etc/apache2
sudo vi httpd.conf

/LoadModule php5
#LoadModule php5_module        libexec/apache2/libphp5.so
s/^#//
LoadModule php5_module        libexec/apache2/libphp5.so

:w

:q

create a file “/etc/php.ini” with the following contents.    The Date/Time are eastern so you need to substitute your TZ in “date.timezone”

; Openemr Stuff
short_open_tag = On
max_execution_time = 60
max_input_time = 90
memory_limit = 128M
display_errors = Off
log_errors = On
register_globals = Off
post_max_size = 30M
magic_quotes_gpc = On
file_uploads = On
upload_max_filesize = 30M
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
date.timezone = “America/New_York”

Add the following to apache setup

sudo vi /etc/apache2/other/openemr.conf
i

<Directory /Library/WebServer/Documents/openemr/documents>
order deny,allow
Deny from all
</Directory>
<Directory /Library/WebServer/Documents/openemr/openemr/edi>
order deny,allow
Deny from all
</Directory>
<Directory /Library/WebServer/Documents/openemr/era>
order deny,allow
Deny from all
</Directory>
:w

:q

INSTALL MYSQL

Download from mysql.com

http://dev.mysql.com/downloads/mysql/

Open mysql-5.1xxxx.pkg

follow the default settings

Install the MYSQL.prefPane


Turn on Apache2 (Webserver)

In the System Preferences panel click Sharing and then turn on the checkbox for Web Sharing

Verify Apache2 (web sharing) is running by clicking on the IP address shown for your personal website and the computer’s website.


Follow the linux installation

http://www.openmedsoftware.org/wiki/OpenEMR_3.1_Linux_Installation

the changes are….

Extracting the Tarball

Step 3 – Use the following

mv openemr-3.1.0               /Library/WebServer/Documents/openemr


Cleaning up FileSystem Permissions
Step 4 – Instead of apache:apache use _www:_www

Follow the remaining steps of the linux installation